Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_008253 (Escherichia coli 536) |
3e-64 |
100 |
|
hypothetical protein |
NC_008563 (Escherichia coli APEC O1) |
3e-64 |
100 |
|
hypothetical protein |
NC_017628 (Escherichia coli IHE3034) |
3e-64 |
100 |
|
hypothetical protein |
NC_011993 (Escherichia coli LF82) |
3e-64 |
100 |
|
hypothetical protein |
NC_017634 (Escherichia coli NRG 857C) |
3e-64 |
100 |
|
hypothetical protein |
NC_022370 (Escherichia coli PMV-1) |
3e-64 |
100 |
|
type VI secretion protein |
NC_017632 (Escherichia coli UM146) |
3e-64 |
100 |
|
hypothetical protein |
NC_007946 (Escherichia coli UTI89) |
3e-64 |
100 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
6e-64 |
100 |
|
hypothetical protein |
NC_011742 (Escherichia coli S88) |
6e-64 |
100 |
|
putative type VI secretion system protein |
NC_017626 (Escherichia coli 042) |
1e-63 |
99 |
|
hypothetical protein |
NC_011751 (Escherichia coli UMN026) |
1e-63 |
99 |
|
type VI secretion protein, VC_A0107 family |
NC_020063 (Enterobacteriaceae bacterium FGI 57) |
2e-44 |
67 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
2e-44 |
56 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
2e-44 |
56 |
|
hypothetical protein |
NC_005126 (Photorhabdus luminescens TTO1) |
7e-44 |
56 |
|
TssA |
NC_022000 (Proteus mirabilis BB2000) |
9e-44 |
56 |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
9e-44 |
56 |
|
hypothetical protein |
NC_013364 (Escherichia coli 11128) |
3e-43 |
55 |
|
hypothetical protein |
NC_013353 (Escherichia coli 12009) |
3e-43 |
55 |
|
hypothetical protein |
NC_018650 (Escherichia coli 2009EL-2050) |
3e-43 |
55 |
|
hypothetical protein |
NC_018661 (Escherichia coli 2009EL-2071) |
3e-43 |
55 |
|
hypothetical protein |
NC_018658 (Escherichia coli 2011C-3493) |
3e-43 |
55 |
|
hypothetical protein |
NC_011748 (Escherichia coli 55989) |
3e-43 |
55 |
|
hypothetical protein |
NC_009801 (Escherichia coli E24377A) |
3e-43 |
55 |
|
hypothetical protein |
NC_009800 (Escherichia coli HS) |
3e-43 |
55 |
|
hypothetical protein |
NC_016822 (Shigella sonnei 53G) |
3e-43 |
55 |
|
hypothetical protein |
NC_007384 (Shigella sonnei Ss046) |
3e-43 |
55 |
|
hypothetical protein |
NC_012962 (Photorhabdus asymbiotica ATCC 43949) |
5e-43 |
56 |
|
hypothetical protein |
NC_011740 (Escherichia fergusonii ATCC 35469) |
6e-43 |
57 |
|
hypothetical protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
1e-42 |
51 |
|
hypothetical protein |
NC_011353 (Escherichia coli EC4115) |
7e-43 |
55 |
|
hypothetical protein |
NC_002655 (Escherichia coli EDL933) |
7e-43 |
55 |
|
hypothetical protein |
NC_011741 (Escherichia coli IAI1) |
7e-43 |
55 |
|
hypothetical protein |
NC_002695 (Escherichia coli Sakai) |
7e-43 |
55 |
|
hypothetical protein |
NC_011415 (Escherichia coli SE11) |
7e-43 |
55 |
|
hypothetical protein |
NC_013008 (Escherichia coli TW14359) |
7e-43 |
55 |
|
hypothetical protein |
NC_017906 (Escherichia coli Xuzhou21) |
7e-43 |
55 |
|
type VI secretion protein |
NC_012917 (Pectobacterium carotovorum PC1) |
8e-43 |
51 |
|
hypothetical protein |
NC_018525 (Pectobacterium carotovorum PCC21) |
8e-43 |
51 |
|
Type VI secretion protein, VC_A0107 family |
NC_017845 (Pectobacterium sp. SCC3193) |
8e-43 |
51 |
|
hypothetical protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
8e-43 |
51 |
|
type VI secretion protein |
NC_016902 (Escherichia coli KO11FL) |
9e-43 |
54 |
|
hypothetical protein |
NC_017660 (Escherichia coli KO11FL) |
9e-43 |
54 |
|
hypothetical protein |
NC_022364 (Escherichia coli LY180) |
9e-43 |
54 |
|
T6SS-associated protein |
NC_017635 (Escherichia coli W) |
9e-43 |
54 |
|
hypothetical protein |
NC_017664 (Escherichia coli W) |
9e-43 |
54 |
|
hypothetical protein |
NC_013941 (Escherichia coli CB9615) |
2e-42 |
54 |
|
hypothetical protein |
NC_017656 (Escherichia coli RM12579) |
2e-42 |
54 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
2e-42 |
54 |
|
hypothetical protein |
NC_011274 (Salmonella enterica 287/91) |
5e-42 |
54 |
|
hypothetical protein |
NC_021984 (Salmonella enterica S06004) |
8e-42 |
55 |
|
hypothetical protein |
NC_022221 (Salmonella enterica CDC1983-67) |
9e-42 |
55 |
|
type VI secretion protein |
NC_011205 (Salmonella enterica CT_02021853) |
9e-42 |
55 |
|
hypothetical protein |
NC_016831 (Salmonella enterica RKS5078) |
9e-42 |
55 |
|
type VI secretion protein, family |
NC_011149 (Salmonella enterica SL483) |
9e-42 |
55 |
|
type VI secretion protein |
NC_010506 (Shewanella woodyi ATCC 51908) |
4e-39 |
49 |
|
hypothetical protein |
NC_009654 (Marinomonas sp. MWYL1) |
9e-39 |
46 |
|
hypothetical protein |
NC_019905 (Pseudomonas putida PC9) |
2e-37 |
50 |
|
hypothetical protein |
NC_016642 (Pseudovibrio sp. FO-BEG1) |
5e-37 |
47 |
|
hypothetical protein |
NC_005810 (Yersinia pestis 91001) |
6e-37 |
55 |
|
hypothetical protein |
NC_004088 (Yersinia pestis KIM) |
6e-37 |
55 |
|
hypothetical protein |
NC_006155 (Yersinia pseudotuberculosis IP 32953) |
6e-37 |
55 |
|
type VI secretion protein |
NC_010634 (Yersinia pseudotuberculosis PB1/+) |
6e-37 |
55 |
|
type VI secretion protein |
NC_010322 (Pseudomonas putida GB-1) |
6e-37 |
48 |
|
hypothetical protein |
NC_017168 (Yersinia pestis A1122) |
7e-37 |
55 |
|
hypothetical protein |
NC_010159 (Yersinia pestis Angola) |
7e-37 |
55 |
|
hypothetical protein |
NC_008150 (Yersinia pestis Antiqua) |
7e-37 |
55 |
|
hypothetical protein |
NC_003143 (Yersinia pestis CO92) |
7e-37 |
55 |
|
hypothetical protein |
NC_017154 (Yersinia pestis D106004) |
7e-37 |
55 |
|
hypothetical protein |
NC_017160 (Yersinia pestis D182038) |
7e-37 |
55 |
|
hypothetical protein |
NC_017265 (Yersinia pestis Harbin 35) |
7e-37 |
55 |
|
hypothetical protein |
NC_008149 (Yersinia pestis Nepal516) |
7e-37 |
55 |
|
hypothetical protein |
NC_009381 (Yersinia pestis Pestoides F) |
7e-37 |
55 |
|
hypothetical protein |
NC_014029 (Yersinia pestis Z176003) |
7e-37 |
55 |
|
hypothetical protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
7e-37 |
55 |
|
type VI secretion protein |
NC_010465 (Yersinia pseudotuberculosis YPIII) |
7e-37 |
55 |
|
hypothetical protein |
NC_017506 (Marinobacter adhaerens HP15) |
8e-37 |
46 |
|
hypothetical protein |
NC_002947 (Pseudomonas putida KT2440) |
4e-36 |
47 |
|
hypothetical protein |
NC_018220 (Pseudomonas putida DOT-T1E) |
6e-36 |
47 |
|
hypothetical protein |
NC_017986 (Pseudomonas putida ND6) |
6e-36 |
47 |
|
hypothetical protein |
NC_009512 (Pseudomonas putida F1) |
6e-36 |
47 |
|
hypothetical protein |
NC_017530 (Pseudomonas putida BIRD-1) |
7e-36 |
47 |
|
hypothetical protein |
NC_008740 (Marinobacter aquaeolei VT8) |
3e-35 |
48 |
|
secretion system protein (EvpA-like) |
NC_017067 (Marinobacter hydrocarbonoclasticus ATCC 49840) |
3e-35 |
48 |
|
hypothetical protein |
NC_002947 (Pseudomonas putida KT2440) |
5e-35 |
45 |
|
hypothetical protein |
NC_018220 (Pseudomonas putida DOT-T1E) |
6e-35 |
45 |
|
hypothetical protein |
NC_020802 (Psychromonas sp. CNPT3) |
2e-34 |
43 |
|
hypothetical protein |
NC_008095 (Myxococcus xanthus DK 1622) |
2e-34 |
45 |
|
hypothetical protein |
NC_015711 (Myxococcus fulvus HW-1) |
4e-34 |
44 |
|
type VI secretion protein, VC_A0107 family |
NC_013592 (Dickeya dadantii Ech586) |
5e-34 |
52 |
|
type VI secretion protein |
NC_012912 (Dickeya zeae Ech1591) |
5e-34 |
52 |
|
protein ImpB |
NC_014500 (Dickeya dadantii 3937) |
1e-33 |
51 |
|
hypothetical protein |
NC_009348 (Aeromonas salmonicida A449) |
8e-34 |
49 |
|
hypothetical protein |
NC_017731 (Providencia stuartii MRSN 2154) |
2e-33 |
58 |
|
type VI secretion protein, VC_A0107 family |
NC_020304 (Desulfocapsa sulfexigens DSM 10523) |
2e-33 |
44 |
|
hypothetical protein |
NC_018177 (Pseudomonas stutzeri DSM 10701) |
4e-33 |
42 |
|
hypothetical protein |
NC_008570 (Aeromonas hydrophila ATCC 7966) |
1e-32 |
47 |
|
hypothetical protein |
NC_008027 (Pseudomonas entomophila L48) |
2e-32 |
41 |
|
hypothetical protein |
NC_010162 (Sorangium cellulosum So ce 56) |
1e-31 |
44 |
|
hypothetical protein |
NC_021658 (Sorangium cellulosum So0157-2) |
1e-31 |
43 |
|
hypothetical protein |
NC_008340 (Alkalilimnicola ehrlichii MLHE-1) |
2e-31 |
48 |
|
hypothetical protein |
NC_014532 (Halomonas elongata DSM 2581) |
3e-31 |
47 |
|
hypothetical protein |
NC_008709 (Psychromonas ingrahamii 37) |
6e-31 |
41 |
|
hypothetical protein |
NC_004578 (Pseudomonas syringae DC3000) |
7e-31 |
42 |
|
type VI secretion lipoprotein |
NC_015559 (Marinomonas posidonica IVIA-Po-181) |
1e-30 |
50 |
|
hypothetical protein |
NC_015458 (Pusillimonas sp. T7-7) |
8e-31 |
46 |
|
VC_A0107 family type VI secretion protein |
NC_020555 (Helicobacter cinaedi ATCC BAA-847) |
5e-30 |
50 |
|
type VI secretion protein VC_A0107 family |
NC_017761 (Helicobacter cinaedi PAGU611) |
5e-30 |
50 |
|
type VI secretion protein |
NC_015968 (Enterobacter asburiae LF7a) |
1e-29 |
49 |
|
hypothetical protein |
NC_009439 (Pseudomonas mendocina ymp) |
9e-30 |
42 |
|
hypothetical protein |
NC_010170 (Bordetella petrii DSM 12804) |
2e-29 |
44 |
|
type VI secretion protein |
NC_009802 (Campylobacter concisus 13826) |
5e-29 |
43 |
|
type VI secretion protein |
NC_012913 (Aggregatibacter aphrophilus NJ8700) |
7e-29 |
49 |
|
hypothetical protein |
NC_017094 (Leptospirillum ferrooxidans C2-3) |
3e-28 |
41 |
|
hypothetical protein |
NC_020126 (Myxococcus stipitatus DSM 14675) |
1e-27 |
44 |
|
type VI secretion system needle sheath protein TssB |
NC_007517 (Geobacter metallireducens GS-15) |
2e-27 |
44 |
|
hypothetical protein |
NC_004917 (Helicobacter hepaticus ATCC 51449) |
7e-27 |
48 |
|
Type VI secretion protein, VC_A0107 family |
NC_020055 (Desulfovibrio hydrothermalis DSM 14728) |
1e-26 |
45 |
|
type VI secretion protein |
NC_012881 (Desulfovibrio salexigens DSM 2638) |
3e-26 |
45 |
|
type VI secretion protein |
NC_012691 (Tolumonas auensis DSM 9187) |
2e-25 |
43 |
|
hypothetical protein |
NC_013855 (Azospirillum sp. B510) |
1e-24 |
44 |
|
type VI secretion system needle sheath protein TssB |
NC_017454 (Geobacter sulfurreducens KN400) |
3e-22 |
43 |
|
type VI secretion system needle sheath protein TssB |
NC_002939 (Geobacter sulfurreducens PCA) |
3e-22 |
43 |
SELECT distinct ph.genome_accn, ph.id_genome_orf, ph.position_begin_pai, ph.position_end_pai, ph.position_begin_genome, ph.position_end_genome, ph.identity, ph.qcoverage, ph.tcoverage,
ph.evalue, ph.score, ph.multi_hsp, ph.multi_strand, ph.source_class, hsp, go.name, go.name_alt, go.pid
FROM pai_homolog as ph, genome_orf as go
WHERE ph.pai_accn='NC_008563_P1' AND ph.id_pai_orf='17' AND match_level='P'
AND go.genome_accn=ph.genome_accn AND ph.id_genome_orf=go.id_genome_orf
ORDER BY ph.score desc, ph.evalue asc, ph.identity desc