Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_008563 (Escherichia coli APEC O1) |
0.0 |
100 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
0.0 |
100 |
|
hypothetical protein |
NC_017628 (Escherichia coli IHE3034) |
0.0 |
100 |
|
hypothetical protein |
NC_022370 (Escherichia coli PMV-1) |
0.0 |
100 |
|
hypothetical protein |
NC_011742 (Escherichia coli S88) |
0.0 |
100 |
|
type VI secretion protein |
NC_017632 (Escherichia coli UM146) |
0.0 |
100 |
|
hypothetical protein |
NC_007946 (Escherichia coli UTI89) |
0.0 |
100 |
|
hypothetical protein |
NC_011993 (Escherichia coli LF82) |
0.0 |
99 |
|
hypothetical protein |
NC_017634 (Escherichia coli NRG 857C) |
0.0 |
99 |
|
hypothetical protein |
NC_008253 (Escherichia coli 536) |
0.0 |
99 |
|
putative type VI secretion system protein |
NC_017626 (Escherichia coli 042) |
0.0 |
99 |
|
hypothetical protein |
NC_011751 (Escherichia coli UMN026) |
0.0 |
99 |
|
type VI secretion protein, VC_A0114 family |
NC_020063 (Enterobacteriaceae bacterium FGI 57) |
7e-157 |
74 |
|
hypothetical protein |
NC_011740 (Escherichia fergusonii ATCC 35469) |
5e-152 |
73 |
|
hypothetical protein |
NC_011741 (Escherichia coli IAI1) |
2e-138 |
63 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
4e-138 |
63 |
|
hypothetical protein |
NC_009800 (Escherichia coli HS) |
4e-138 |
62 |
|
type VI secretion protein |
NC_016902 (Escherichia coli KO11FL) |
4e-138 |
62 |
|
hypothetical protein |
NC_017660 (Escherichia coli KO11FL) |
4e-138 |
62 |
|
hypothetical protein |
NC_022364 (Escherichia coli LY180) |
4e-138 |
62 |
|
T6SS-associated protein |
NC_017635 (Escherichia coli W) |
4e-138 |
62 |
|
hypothetical protein |
NC_017664 (Escherichia coli W) |
4e-138 |
62 |
|
hypothetical protein |
NC_011353 (Escherichia coli EC4115) |
5e-138 |
62 |
|
hypothetical protein |
NC_002655 (Escherichia coli EDL933) |
5e-138 |
62 |
|
hypothetical protein |
NC_002695 (Escherichia coli Sakai) |
5e-138 |
62 |
|
hypothetical protein |
NC_011415 (Escherichia coli SE11) |
5e-138 |
62 |
|
hypothetical protein |
NC_013008 (Escherichia coli TW14359) |
5e-138 |
62 |
|
hypothetical protein |
NC_017906 (Escherichia coli Xuzhou21) |
5e-138 |
62 |
|
hypothetical protein |
NC_013364 (Escherichia coli 11128) |
1e-137 |
62 |
|
hypothetical protein |
NC_018650 (Escherichia coli 2009EL-2050) |
1e-137 |
62 |
|
hypothetical protein |
NC_018661 (Escherichia coli 2009EL-2071) |
1e-137 |
62 |
|
hypothetical protein |
NC_018658 (Escherichia coli 2011C-3493) |
1e-137 |
62 |
|
hypothetical protein |
NC_011748 (Escherichia coli 55989) |
1e-137 |
62 |
|
hypothetical protein |
NC_009801 (Escherichia coli E24377A) |
1e-137 |
62 |
|
hypothetical protein |
NC_013941 (Escherichia coli CB9615) |
2e-137 |
62 |
|
hypothetical protein |
NC_017656 (Escherichia coli RM12579) |
2e-137 |
62 |
|
hypothetical protein |
NC_013353 (Escherichia coli 12009) |
5e-137 |
62 |
|
hypothetical protein |
NC_016822 (Shigella sonnei 53G) |
2e-136 |
62 |
|
hypothetical protein |
NC_011205 (Salmonella enterica CT_02021853) |
2e-129 |
62 |
|
hypothetical protein |
NC_011149 (Salmonella enterica SL483) |
2e-129 |
62 |
|
hypothetical protein |
NC_011274 (Salmonella enterica 287/91) |
4e-129 |
62 |
|
hypothetical protein |
NC_022221 (Salmonella enterica CDC1983-67) |
4e-129 |
62 |
|
hypothetical protein |
NC_016831 (Salmonella enterica RKS5078) |
4e-129 |
62 |
|
hypothetical protein |
NC_021984 (Salmonella enterica S06004) |
4e-129 |
62 |
|
hypothetical protein |
NC_005810 (Yersinia pestis 91001) |
1e-109 |
52 |
|
hypothetical protein |
NC_017168 (Yersinia pestis A1122) |
1e-109 |
52 |
|
hypothetical protein |
NC_008150 (Yersinia pestis Antiqua) |
1e-109 |
52 |
|
hypothetical protein |
NC_003143 (Yersinia pestis CO92) |
1e-109 |
52 |
|
hypothetical protein |
NC_017154 (Yersinia pestis D106004) |
1e-109 |
52 |
|
hypothetical protein |
NC_017160 (Yersinia pestis D182038) |
1e-109 |
52 |
|
hypothetical protein |
NC_017265 (Yersinia pestis Harbin 35) |
1e-109 |
52 |
|
hypothetical protein |
NC_008149 (Yersinia pestis Nepal516) |
1e-109 |
52 |
|
hypothetical protein |
NC_009381 (Yersinia pestis Pestoides F) |
1e-109 |
52 |
|
hypothetical protein |
NC_014029 (Yersinia pestis Z176003) |
1e-109 |
52 |
|
hypothetical protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
1e-109 |
52 |
|
hypothetical protein |
NC_006155 (Yersinia pseudotuberculosis IP 32953) |
1e-109 |
52 |
|
type VI secretion protein |
NC_010634 (Yersinia pseudotuberculosis PB1/+) |
1e-109 |
52 |
|
type VI secretion protein |
NC_010465 (Yersinia pseudotuberculosis YPIII) |
1e-109 |
52 |
|
hypothetical protein |
NC_004088 (Yersinia pestis KIM) |
2e-109 |
52 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
2e-107 |
50 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
6e-107 |
50 |
|
hypothetical protein |
NC_012962 (Photorhabdus asymbiotica ATCC 43949) |
2e-104 |
49 |
|
TssH |
NC_022000 (Proteus mirabilis BB2000) |
8e-100 |
48 |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
8e-100 |
48 |
|
hypothetical protein |
NC_005126 (Photorhabdus luminescens TTO1) |
5e-98 |
47 |
|
hypothetical protein |
NC_009348 (Aeromonas salmonicida A449) |
7e-94 |
48 |
|
hypothetical protein |
NC_008570 (Aeromonas hydrophila ATCC 7966) |
9e-94 |
48 |
|
hypothetical protein |
NC_017067 (Marinobacter hydrocarbonoclasticus ATCC 49840) |
5e-93 |
44 |
|
hypothetical protein |
NC_008740 (Marinobacter aquaeolei VT8) |
7e-93 |
44 |
|
hypothetical protein |
NC_017506 (Marinobacter adhaerens HP15) |
4e-92 |
43 |
|
type VI secretion protein |
NC_010506 (Shewanella woodyi ATCC 51908) |
5e-91 |
42 |
|
hypothetical protein |
NC_018525 (Pectobacterium carotovorum PCC21) |
6e-91 |
47 |
|
type VI secretion protein |
NC_012917 (Pectobacterium carotovorum PC1) |
1e-90 |
47 |
|
Type VI secretion protein, VC_A0114 family |
NC_017845 (Pectobacterium sp. SCC3193) |
1e-90 |
47 |
|
hypothetical protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
1e-90 |
47 |
|
hypothetical protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
9e-91 |
47 |
|
type VI secretion protein |
NC_015968 (Enterobacter asburiae LF7a) |
2e-90 |
45 |
|
type VI secretion protein |
NC_020802 (Psychromonas sp. CNPT3) |
2e-90 |
44 |
|
type VI secretion protein |
NC_012912 (Dickeya zeae Ech1591) |
7e-90 |
46 |
|
protein ImpJ |
NC_014500 (Dickeya dadantii 3937) |
1e-89 |
46 |
|
hypothetical protein |
NC_017731 (Providencia stuartii MRSN 2154) |
2e-87 |
46 |
|
type VI secretion protein, VC_A0114 family |
NC_013592 (Dickeya dadantii Ech586) |
1e-85 |
47 |
|
hypothetical protein |
NC_014532 (Halomonas elongata DSM 2581) |
7e-82 |
43 |
|
hypothetical protein |
NC_008340 (Alkalilimnicola ehrlichii MLHE-1) |
9e-78 |
44 |
|
hypothetical protein |
NC_009654 (Marinomonas sp. MWYL1) |
3e-77 |
41 |
|
hypothetical protein |
NC_015410 (Pseudomonas mendocina NK-01) |
1e-76 |
41 |
|
hypothetical protein |
NC_012660 (Pseudomonas fluorescens SBW25) |
4e-76 |
42 |
|
type VI secretion lipoprotein |
NC_015559 (Marinomonas posidonica IVIA-Po-181) |
7e-76 |
42 |
|
type VI secretion protein |
NC_010322 (Pseudomonas putida GB-1) |
1e-72 |
41 |
|
hypothetical protein |
NC_015379 (Pseudomonas brassicacearum NFM421) |
2e-71 |
41 |
|
protein ImpJ |
NC_016830 (Pseudomonas fluorescens F113) |
4e-71 |
41 |
|
type VI secretion protein TssK1 |
NC_017911 (Pseudomonas fluorescens A506) |
5e-71 |
42 |
|
hypothetical protein |
NC_020209 (Pseudomonas poae RE*1-1-14) |
1e-70 |
41 |
|
hypothetical protein |
NC_002947 (Pseudomonas putida KT2440) |
4e-66 |
41 |
|
hypothetical protein |
NC_018220 (Pseudomonas putida DOT-T1E) |
5e-66 |
41 |
|
hypothetical protein |
NC_018220 (Pseudomonas putida DOT-T1E) |
9e-66 |
41 |
|
hypothetical protein |
NC_009512 (Pseudomonas putida F1) |
3e-65 |
41 |
|
hypothetical protein |
NC_017986 (Pseudomonas putida ND6) |
3e-65 |
41 |
|
hypothetical protein |
NC_002947 (Pseudomonas putida KT2440) |
4e-65 |
41 |
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='10' 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