Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
putative exported protein |
NC_003198 (Salmonella enterica CT18) |
6e-105 |
100 |
|
hypothetical protein |
NC_016832 (Salmonella enterica P-stx-12) |
6e-105 |
100 |
|
hypothetical protein |
NC_004631 (Salmonella enterica Ty2) |
6e-105 |
100 |
|
hypothetical protein |
NC_012125 (Salmonella enterica RKS4594) |
3e-104 |
99 |
|
Conserved protein, putatively exported |
NC_017845 (Pectobacterium sp. SCC3193) |
5e-68 |
70 |
|
hypothetical protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
7e-68 |
68 |
|
hypothetical protein |
NC_016816 (Pantoea ananatis LMG 5342) |
7e-67 |
62 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
5e-66 |
70 |
|
hypothetical protein |
NC_012779 (Edwardsiella ictaluri 93-146) |
2e-65 |
59 |
|
hypothetical protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
2e-65 |
57 |
|
integrating conjugative element protein |
NC_021818 (Salmonella enterica CFSAN002050) |
4e-65 |
69 |
|
hypothetical protein |
NC_017445 (Erwinia sp. Ejp617) |
5e-65 |
70 |
|
hypothetical protein |
NC_014029 (Yersinia pestis Z176003) |
2e-64 |
60 |
|
hypothetical protein |
NC_005126 (Photorhabdus luminescens TTO1) |
3e-64 |
55 |
|
integrating conjugative element protein, PFL_4693 family |
NC_022268 (Serratia sp. ATCC 39006) |
4e-64 |
67 |
|
hypothetical protein |
NC_014304 (Erwinia billingiae Eb661) |
5e-64 |
69 |
|
integrating conjugative element protein |
NC_015567 (Serratia plymuthica AS9) |
7e-63 |
67 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
7e-63 |
67 |
|
integrating conjugative element protein |
NC_015566 (Serratia sp. AS12) |
7e-63 |
67 |
|
integrating conjugative element protein |
NC_017573 (Serratia sp. AS13) |
7e-63 |
67 |
|
integrating conjugative element protein TraG |
NC_017554 (Pantoea ananatis PA13) |
8e-63 |
68 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
8e-63 |
66 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
1e-61 |
57 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
2e-61 |
66 |
|
hypothetical protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
2e-61 |
57 |
|
hypothetical protein |
NC_008800 (Yersinia enterocolitica 8081) |
1e-60 |
53 |
|
hypothetical protein |
NC_014121 (Enterobacter cloacae ATCC 13047) |
4e-60 |
68 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
4e-59 |
55 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
7e-59 |
56 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
1e-58 |
57 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
3e-58 |
55 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
1e-54 |
53 |
|
hypothetical protein |
NC_011993 (Escherichia coli LF82) |
1e-50 |
50 |
|
hypothetical protein |
NC_017634 (Escherichia coli NRG 857C) |
1e-50 |
50 |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
2e-48 |
46 |
|
hypothetical protein |
NC_016845 (Klebsiella pneumoniae HS11286) |
9e-48 |
54 |
|
hypothetical protein |
NC_022082 (Klebsiella pneumoniae JM45) |
9e-48 |
54 |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
7e-47 |
43 |
|
FIG00509784: hypothetical protein |
NC_020181 (Enterobacter aerogenes EA1509E) |
3e-40 |
45 |
|
hypothetical protein |
NC_010067 (Salmonella enterica RSK2980) |
5e-40 |
46 |
|
integrating conjugative element protein |
NC_015460 (Gallibacterium anatis UMN179) |
6e-40 |
45 |
|
hypothetical protein |
NC_021870 (Salmonella bongori N268-08) |
1e-39 |
49 |
|
conjugative transfer system protein TraG |
NC_013716 (Citrobacter rodentium ICC168) |
1e-39 |
45 |
|
integrating conjugative element protein |
NC_015422 (Alicycliphilus denitrificans K601) |
2e-39 |
45 |
|
probable exported protein STY4558 |
NC_021285 (Achromobacter xylosoxidans NH44784-1996) |
1e-38 |
42 |
|
hypothetical protein |
NC_007005 (Pseudomonas syringae B728a) |
1e-38 |
46 |
|
hypothetical protein |
NC_015740 (Pseudomonas stutzeri ATCC 17588) |
2e-38 |
42 |
|
hypothetical protein |
NC_008752 (Acidovorax citrulli AAC00-1) |
3e-38 |
46 |
|
hypothetical protein |
NC_018522 (Klebsiella pneumoniae 1084) |
4e-38 |
44 |
|
hypothetical protein |
NC_012731 (Klebsiella pneumoniae NTUH-K2044) |
4e-38 |
44 |
|
hypothetical protein |
NC_008309 (Haemophilus somnus 129PT) |
3e-35 |
42 |
|
putative secreted protein |
NC_012691 (Tolumonas auensis DSM 9187) |
7e-34 |
42 |
|
hypothetical protein |
NC_008825 (Methylibium petroleiphilum PM1) |
8e-33 |
42 |
|
hypothetical protein |
NC_011662 (Thauera sp. MZ1T) |
1e-32 |
42 |
|
hypothetical protein |
NC_010501 (Pseudomonas putida W619) |
2e-32 |
45 |
|
hypothetical protein |
NC_018028 (Pseudomonas stutzeri CCUG 29243) |
4e-32 |
43 |
|
integrating conjugative element protein |
NC_021491 (Pseudomonas putida H8234) |
4e-32 |
41 |
|
hypothetical protein |
NC_008782 (Acidovorax sp. JS42) |
7e-32 |
43 |
|
hypothetical protein |
NC_018828 (Bordetella parapertussis Bpp5) |
2e-31 |
42 |
|
hypothetical protein |
NC_009512 (Pseudomonas putida F1) |
2e-31 |
41 |
|
hypothetical protein |
NC_018220 (Pseudomonas putida DOT-T1E) |
2e-31 |
41 |
|
integrating conjugative element protein |
NC_021491 (Pseudomonas putida H8234) |
3e-31 |
43 |
|
hypothetical protein |
NC_015740 (Pseudomonas stutzeri ATCC 17588) |
6e-31 |
42 |
|
Hypothetical Protein |
NC_020815 (Xanthomonas citri Aw12879) |
1e-30 |
42 |
|
hypothetical protein |
NC_007086 (Xanthomonas campestris 8004) |
7e-31 |
41 |
|
hypothetical protein |
NC_007492 (Pseudomonas fluorescens Pf0-1) |
2e-30 |
42 |
|
hypothetical protein |
NC_016147 (Pseudoxanthomonas spadix BD-a59) |
2e-30 |
42 |
|
integrating conjugative element protein |
NC_004129 (Pseudomonas protegens Pf-5) |
1e-29 |
47 |
|
hypothetical protein |
NC_020912 (Pseudomonas aeruginosa B136-33) |
4e-29 |
44 |
|
hypothetical protein |
NC_018080 (Pseudomonas aeruginosa DK2) |
1e-28 |
44 |
|
hypothetical protein |
NC_009656 (Pseudomonas aeruginosa PA7) |
1e-28 |
44 |
|
hypothetical protein |
NC_021577 (Pseudomonas aeruginosa RP73) |
1e-28 |
44 |
|
hypothetical protein |
NC_014532 (Halomonas elongata DSM 2581) |
3e-28 |
41 |
|
hypothetical protein |
NC_008463 (Pseudomonas aeruginosa UCBPP-PA14) |
8e-28 |
44 |
|
hypothetical protein |
NC_006513 (Aromatoleum aromaticum EbN1) |
2e-27 |
42 |
|
hypothetical protein |
NC_008344 (Nitrosomonas eutropha C91) |
2e-27 |
41 |
|
hypothetical protein |
NC_017549 (Pseudomonas aeruginosa NCGM2.S1) |
3e-27 |
44 |
|
secreted protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
5e-27 |
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_004631_P3' AND ph.id_pai_orf='30' 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