Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_004431 (Escherichia coli CFT073) |
3e-32 |
100 |
|
hypothetical protein |
NC_009801 (Escherichia coli E24377A) |
1e-31 |
99 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
3e-31 |
98 |
|
hypothetical protein |
NC_011750 (Escherichia coli IAI39) |
3e-31 |
98 |
|
hypothetical protein |
NC_008253 (Escherichia coli 536) |
8e-31 |
97 |
|
hypothetical protein |
NC_011748 (Escherichia coli 55989) |
8e-31 |
97 |
|
hypothetical protein |
NC_017631 (Escherichia coli ABU 83972) |
8e-31 |
97 |
|
hypothetical protein |
NC_004431 (Escherichia coli CFT073) |
8e-31 |
97 |
|
hypothetical protein |
NC_011742 (Escherichia coli S88) |
8e-31 |
97 |
|
hypothetical protein |
NC_010498 (Escherichia coli SMS-3-5) |
8e-31 |
97 |
|
hypothetical protein |
NC_017632 (Escherichia coli UM146) |
2e-30 |
95 |
|
hypothetical protein |
NC_007946 (Escherichia coli UTI89) |
2e-30 |
95 |
|
hypothetical protein |
NC_017646 (Escherichia coli CE10) |
2e-29 |
91 |
|
hypothetical protein |
NC_011750 (Escherichia coli IAI39) |
2e-29 |
91 |
|
hypothetical protein |
NC_011742 (Escherichia coli S88) |
2e-29 |
91 |
|
hypothetical protein |
NC_017626 (Escherichia coli 042) |
4e-29 |
91 |
|
hypothetical protein |
NC_008253 (Escherichia coli 536) |
8e-28 |
89 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
8e-28 |
89 |
|
hypothetical protein |
NC_017644 (Escherichia coli NA114) |
1e-22 |
100 |
|
hypothetical protein |
NC_011083 (Salmonella enterica SL476) |
7e-20 |
90 |
|
hypothetical protein |
NC_017625 (Escherichia coli DH1) |
5e-19 |
61 |
|
CP4-6 prophage; hypothetical protein |
NC_017638 (Escherichia coli DH1) |
5e-19 |
61 |
|
CP4-6 prophage; hypothetical protein |
NC_010473 (Escherichia coli K-12) |
5e-19 |
61 |
|
CP4-6 prophage protein |
NC_012759 (Escherichia coli K-12) |
5e-19 |
61 |
|
hypothetical protein |
NC_007779 (Escherichia coli K-12) |
5e-19 |
61 |
|
CP4-6 prophage; predicted protein |
NC_000913 (Escherichia coli K12) |
5e-19 |
61 |
|
hypothetical protein |
NC_011274 (Salmonella enterica 287/91) |
1e-17 |
66 |
|
hypothetical protein |
NC_022221 (Salmonella enterica CDC1983-67) |
1e-17 |
66 |
|
hypothetical protein |
NC_016831 (Salmonella enterica RKS5078) |
1e-17 |
66 |
|
hypothetical protein |
NC_021984 (Salmonella enterica S06004) |
1e-17 |
66 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
1e-17 |
66 |
|
hypothetical protein |
NC_021844 (Salmonella enterica CFSAN000189) |
2e-17 |
66 |
|
hypothetical protein |
NC_004431 (Escherichia coli CFT073) |
2e-17 |
67 |
|
hypothetical protein |
NC_017652 (Escherichia coli clone D i14) |
2e-17 |
67 |
|
hypothetical protein |
NC_017651 (Escherichia coli clone D i2) |
2e-17 |
67 |
|
hypothetical protein |
NC_017626 (Escherichia coli 042) |
7e-17 |
65 |
|
putative plasmid-like protein |
NC_017626 (Escherichia coli 042) |
7e-17 |
65 |
|
hypothetical protein |
NC_013361 (Escherichia coli 11368) |
7e-17 |
65 |
|
hypothetical protein |
NC_013361 (Escherichia coli 11368) |
7e-17 |
65 |
|
hypothetical protein |
NC_018650 (Escherichia coli 2009EL-2050) |
7e-17 |
65 |
|
hypothetical protein |
NC_018661 (Escherichia coli 2009EL-2071) |
7e-17 |
65 |
|
hypothetical protein |
NC_018658 (Escherichia coli 2011C-3493) |
7e-17 |
65 |
|
hypothetical protein |
NC_011748 (Escherichia coli 55989) |
7e-17 |
65 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
7e-17 |
65 |
|
hypothetical protein |
NC_017633 (Escherichia coli ETEC H10407) |
7e-17 |
65 |
|
hypothetical protein |
NC_004431 (Escherichia coli CFT073) |
2e-16 |
65 |
|
hypothetical protein |
NC_014618 (Enterobacter cloacae SCF1) |
2e-16 |
57 |
|
hypothetical protein |
NC_021814 (Salmonella enterica CFSAN001921) |
2e-16 |
56 |
|
hypothetical protein |
NC_017631 (Escherichia coli ABU 83972) |
4e-16 |
65 |
|
hypothetical protein |
NC_017652 (Escherichia coli clone D i14) |
4e-16 |
65 |
|
hypothetical protein |
NC_017651 (Escherichia coli clone D i2) |
4e-16 |
65 |
|
hypothetical protein |
NC_017644 (Escherichia coli NA114) |
4e-16 |
65 |
|
hypothetical protein |
NC_021659 (Serratia plymuthica S13) |
4e-16 |
58 |
|
YkfF protein |
NC_017675 (Salmonella enterica ST4/74) |
7e-16 |
57 |
|
hypothetical protein |
NC_010468 (Escherichia coli ATCC 8739) |
2e-15 |
56 |
|
hypothetical protein |
NC_021818 (Salmonella enterica CFSAN002050) |
2e-15 |
55 |
|
hypothetical protein |
NC_020260 (Cronobacter sakazakii Sp291) |
2e-15 |
53 |
|
hypothetical protein |
NC_014121 (Enterobacter cloacae ATCC 13047) |
2e-15 |
53 |
|
hypothetical protein |
NC_020181 (Enterobacter aerogenes EA1509E) |
3e-15 |
57 |
|
prophage protein |
NC_015761 (Salmonella bongori NCTC 12419) |
3e-15 |
54 |
|
hypothetical protein |
NC_018106 (Klebsiella oxytoca E718) |
8e-15 |
60 |
|
hypothetical protein |
NC_013366 (Escherichia coli 11128) |
1e-14 |
57 |
|
hypothetical protein |
NC_018659 (Escherichia coli 2011C-3493) |
1e-14 |
57 |
|
hypothetical protein |
NC_009837 (Escherichia coli APEC O1) |
1e-14 |
57 |
|
hypothetical protein |
NC_022371 (Escherichia coli PMV-1) |
1e-14 |
57 |
|
hypothetical protein |
NC_010488 (Escherichia coli SMS-3-5) |
1e-14 |
57 |
|
hypothetical protein |
NC_021811 (Salmonella enterica 41578) |
1e-14 |
57 |
|
hypothetical protein |
NC_021813 (Salmonella enterica CFSAN002069) |
1e-14 |
57 |
|
YkfF |
NC_006856 (Salmonella enterica SC-B67) |
1e-14 |
57 |
|
hypothetical protein |
NC_021501 (Klebsiella oxytoca E718) |
3e-14 |
55 |
|
hypothetical protein |
NC_013655 (Escherichia coli SE15) |
3e-14 |
57 |
|
hypothetical protein |
NC_017630 (Escherichia coli UM146) |
3e-14 |
57 |
|
hypothetical protein |
NC_007941 (Escherichia coli UTI89) |
3e-14 |
57 |
|
hypothetical protein |
NC_011749 (Escherichia coli UMN026) |
4e-14 |
57 |
|
hypothetical protein |
NC_011413 (Escherichia coli SE11) |
6e-14 |
57 |
|
hypothetical protein |
NC_017627 (Escherichia coli 042) |
6e-14 |
56 |
|
hypothetical protein |
NC_017644 (Escherichia coli NA114) |
6e-14 |
56 |
|
hypothetical protein |
NC_017722 (Escherichia coli ETEC H10407) |
7e-14 |
54 |
|
hypothetical protein |
NC_009788 (Escherichia coli E24377A) |
2e-13 |
54 |
|
conserved putative protein |
NC_013362 (Escherichia coli 11368) |
2e-13 |
52 |
|
hypothetical protein |
NC_011081 (Salmonella enterica SL476) |
3e-13 |
53 |
|
hypothetical protein |
NC_021155 (Salmonella enterica U288) |
3e-13 |
53 |
|
hypothetical protein |
NC_017659 (Escherichia coli NRG 857C) |
5e-13 |
50 |
|
hypothetical protein |
NC_005815 (Yersinia pestis 91001) |
6e-13 |
53 |
|
hypothetical protein |
NC_017169 (Yersinia pestis A1122) |
6e-13 |
53 |
|
hypothetical protein |
NC_010158 (Yersinia pestis Angola) |
6e-13 |
53 |
|
hypothetical protein |
NC_008120 (Yersinia pestis Antiqua) |
6e-13 |
53 |
|
hypothetical protein |
NC_003134 (Yersinia pestis CO92) |
6e-13 |
53 |
|
putative cytoplasmic protein |
NC_017266 (Yersinia pestis Harbin 35) |
6e-13 |
53 |
|
hypothetical protein |
NC_004838 (Yersinia pestis KIM) |
6e-13 |
53 |
|
hypothetical protein |
NC_008118 (Yersinia pestis Nepal516) |
6e-13 |
53 |
|
hypothetical protein |
NC_009378 (Yersinia pestis Pestoides F) |
6e-13 |
53 |
|
hypothetical protein |
NC_011415 (Escherichia coli SE11) |
7e-13 |
64 |
|
hypothetical protein |
NC_011747 (Escherichia coli S88) |
7e-13 |
50 |
|
hypothetical protein |
NC_015063 (Rahnella sp. Y9602) |
1e-12 |
54 |
|
hypothetical protein |
NC_011350 (Escherichia coli EC4115) |
1e-12 |
48 |
|
hypothetical protein |
NC_002128 (Escherichia coli Sakai) |
1e-12 |
48 |
|
hypothetical protein |
NC_013010 (Escherichia coli TW14359) |
1e-12 |
48 |
|
hypothetical protein |
NC_017907 (Escherichia coli Xuzhou21) |
1e-12 |
48 |
|
hypothetical protein |
NC_007414 (Escherichia coli EDL933) |
2e-12 |
48 |
|
hypothetical protein |
NC_017309 (Edwardsiella tarda FL6-60) |
2e-12 |
64 |
|
hypothetical protein |
NC_021844 (Salmonella enterica CFSAN000189) |
2e-12 |
61 |
|
hypothetical protein |
NC_016612 (Klebsiella oxytoca KCTC 1686) |
3e-12 |
60 |
|
hypothetical protein |
NC_016904 (Escherichia coli KO11FL) |
6e-12 |
60 |
|
hypothetical protein |
NC_011419 (Escherichia coli SE11) |
6e-12 |
60 |
|
hypothetical protein |
NC_017637 (Escherichia coli W) |
6e-12 |
60 |
|
hypothetical protein |
NC_017665 (Escherichia coli W) |
6e-12 |
60 |
|
hypothetical protein |
NC_015663 (Enterobacter aerogenes KCTC 2190) |
9e-12 |
56 |
|
hypothetical protein |
NC_009650 (Klebsiella pneumoniae subsp. pneumoniae MGH 78578) |
9e-12 |
55 |
|
putative cytoplasmic protein |
NC_016855 (Salmonella enterica 14028S) |
1e-11 |
55 |
|
cytoplasmic protein |
NC_017054 (Salmonella enterica 798) |
1e-11 |
55 |
|
putative cytoplasmic protein |
NC_003277 (Salmonella enterica LT2) |
1e-11 |
55 |
|
hypothetical protein |
NC_017720 (Salmonella enterica SL1344) |
1e-11 |
55 |
|
putative cytoplasmic protein |
NC_016858 (Salmonella enterica ST4/74) |
1e-11 |
55 |
|
putative cytoplasmic protein |
NC_016861 (Salmonella enterica T000240) |
1e-11 |
55 |
|
putative cytoplasmic protein |
NC_021155 (Salmonella enterica U288) |
1e-11 |
55 |
|
putative cytoplasmic protein |
NC_016864 (Salmonella enterica UK-1) |
1e-11 |
55 |
|
hypothetical protein |
NC_016846 (Klebsiella pneumoniae HS11286) |
2e-10 |
54 |
|
hypothetical protein |
NC_022078 (Klebsiella pneumoniae JM45) |
2e-10 |
54 |
|
hypothetical protein |
NC_009649 (Klebsiella pneumoniae subsp. pneumoniae MGH 78578) |
2e-10 |
54 |
|
hypothetical protein |
NC_016825 (Salmonella enterica P-stx-12) |
1e-08 |
41 |
|
hypothetical protein |
NC_013365 (Escherichia coli 11128) |
1e-08 |
41 |
|
hypothetical protein |
NC_003384 (Salmonella enterica CT18) |
1e-08 |
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_004431_P2' AND ph.id_pai_orf='18' 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