Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_008800 (Yersinia enterocolitica 8081) |
2e-171 |
100 |
|
hypothetical protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
1e-149 |
79 |
|
hypothetical protein |
NC_022268 (Serratia sp. ATCC 39006) |
1e-126 |
69 |
|
hypothetical protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
2e-123 |
60 |
|
Hypothetical protein |
NC_017845 (Pectobacterium sp. SCC3193) |
3e-117 |
59 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
3e-110 |
58 |
|
hypothetical protein |
NC_017445 (Erwinia sp. Ejp617) |
5e-104 |
56 |
|
hypothetical protein |
NC_016816 (Pantoea ananatis LMG 5342) |
3e-101 |
54 |
|
hypothetical protein |
NC_014121 (Enterobacter cloacae ATCC 13047) |
9e-101 |
61 |
|
hypothetical protein |
NC_017554 (Pantoea ananatis PA13) |
9e-100 |
55 |
|
hypothetical protein |
NC_005126 (Photorhabdus luminescens TTO1) |
4e-97 |
51 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
6e-93 |
52 |
|
hypothetical protein |
NC_014029 (Yersinia pestis Z176003) |
3e-91 |
55 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
8e-91 |
50 |
|
hypothetical protein |
NC_015567 (Serratia plymuthica AS9) |
2e-90 |
50 |
|
hypothetical protein |
NC_015566 (Serratia sp. AS12) |
2e-90 |
50 |
|
hypothetical protein |
NC_017573 (Serratia sp. AS13) |
2e-90 |
50 |
|
hypothetical protein |
NC_011993 (Escherichia coli LF82) |
4e-90 |
50 |
|
hypothetical protein |
NC_017634 (Escherichia coli NRG 857C) |
4e-90 |
50 |
|
hypothetical protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
2e-88 |
51 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
2e-85 |
50 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
8e-84 |
54 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
2e-83 |
47 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
3e-83 |
49 |
|
hypothetical protein |
NC_016845 (Klebsiella pneumoniae HS11286) |
2e-81 |
53 |
|
hypothetical protein |
NC_022082 (Klebsiella pneumoniae JM45) |
2e-81 |
53 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
1e-79 |
56 |
|
hypothetical protein |
NC_021818 (Salmonella enterica CFSAN002050) |
5e-79 |
50 |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
3e-78 |
44 |
|
hypothetical protein |
NC_003198 (Salmonella enterica CT18) |
6e-78 |
45 |
|
hypothetical protein |
NC_016832 (Salmonella enterica P-stx-12) |
6e-78 |
45 |
|
hypothetical protein |
NC_012125 (Salmonella enterica RKS4594) |
6e-78 |
45 |
|
hypothetical protein |
NC_004631 (Salmonella enterica Ty2) |
6e-78 |
45 |
|
hypothetical protein |
NC_021176 (Salmonella enterica Ty21a) |
6e-78 |
45 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
5e-78 |
48 |
|
hypothetical protein |
NC_014304 (Erwinia billingiae Eb661) |
6e-76 |
47 |
|
hypothetical protein |
NC_012779 (Edwardsiella ictaluri 93-146) |
7e-65 |
55 |
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_008800_P2' AND ph.id_pai_orf='64' 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