Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
5e-55 |
100 |
|
membrane protein |
NC_021818 (Salmonella enterica CFSAN002050) |
1e-22 |
51 |
|
hypothetical protein |
NC_015567 (Serratia plymuthica AS9) |
1e-22 |
54 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
1e-22 |
54 |
|
hypothetical protein |
NC_015566 (Serratia sp. AS12) |
1e-22 |
54 |
|
hypothetical protein |
NC_017573 (Serratia sp. AS13) |
1e-22 |
54 |
|
hypothetical protein |
NC_014029 (Yersinia pestis Z176003) |
1e-22 |
54 |
|
hypothetical protein |
NC_012779 (Edwardsiella ictaluri 93-146) |
4e-22 |
55 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
9e-22 |
54 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
7e-21 |
55 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
1e-20 |
55 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
2e-20 |
55 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
1e-19 |
55 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
2e-19 |
50 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
7e-19 |
44 |
|
hypothetical protein |
NC_017554 (Pantoea ananatis PA13) |
8e-18 |
48 |
|
putative transmembrane protein |
NC_016816 (Pantoea ananatis LMG 5342) |
2e-17 |
48 |
|
hypothetical protein |
NC_014121 (Enterobacter cloacae ATCC 13047) |
6e-17 |
46 |
|
Hypothetical protein |
NC_017845 (Pectobacterium sp. SCC3193) |
4e-16 |
48 |
|
hypothetical protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
1e-15 |
45 |
|
hypothetical protein |
NC_014304 (Erwinia billingiae Eb661) |
2e-15 |
46 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
3e-15 |
52 |
|
conjugative transfer region protein, TIGR03750 family |
NC_022268 (Serratia sp. ATCC 39006) |
4e-15 |
44 |
|
hypothetical protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
5e-15 |
44 |
|
putative inner membrane protein |
NC_008800 (Yersinia enterocolitica 8081) |
6e-15 |
42 |
|
hypothetical protein |
NC_017390 (Erwinia pyrifoliae DSM 12163) |
1e-14 |
43 |
|
hypothetical protein |
NC_017390 (Erwinia pyrifoliae DSM 12163) |
1e-14 |
43 |
|
hypothetical protein |
NC_012214 (Erwinia pyrifoliae Ep1/96) |
1e-14 |
43 |
|
hypothetical protein |
NC_012214 (Erwinia pyrifoliae Ep1/96) |
1e-14 |
43 |
|
hypothetical protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
2e-14 |
56 |
|
hypothetical protein |
NC_021176 (Salmonella enterica Ty21a) |
2e-12 |
44 |
|
hypothetical protein |
NC_010501 (Pseudomonas putida W619) |
5e-06 |
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_010554_P1' AND ph.id_pai_orf='37' 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