Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
1e-103 |
100 |
|
hypothetical protein |
NC_014563 (Pantoea vagans C9-1) |
1e-58 |
54 |
|
integrating conjugative element membrane protein, PFL_4697 family |
NC_022268 (Serratia sp. ATCC 39006) |
2e-57 |
58 |
|
hypothetical protein |
NC_005126 (Photorhabdus luminescens TTO1) |
4e-57 |
59 |
|
Hypothetical protein |
NC_017845 (Pectobacterium sp. SCC3193) |
2e-56 |
58 |
|
hypothetical protein |
NC_014304 (Erwinia billingiae Eb661) |
2e-55 |
58 |
|
hypothetical protein |
NC_011993 (Escherichia coli LF82) |
1e-53 |
59 |
|
hypothetical protein |
NC_017634 (Escherichia coli NRG 857C) |
1e-53 |
59 |
|
inner membrane protein |
NC_013421 (Pectobacterium wasabiae WPP163) |
5e-53 |
60 |
|
putative inner membrane protein |
NC_008800 (Yersinia enterocolitica 8081) |
1e-52 |
59 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
8e-53 |
58 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
7e-52 |
53 |
|
integrating conjugative element membrane protein |
NC_015567 (Serratia plymuthica AS9) |
1e-50 |
60 |
|
integrating conjugative element membrane protein |
NC_015566 (Serratia sp. AS12) |
1e-50 |
60 |
|
integrating conjugative element membrane protein |
NC_017573 (Serratia sp. AS13) |
1e-50 |
60 |
|
hypothetical protein |
NC_009708 (Yersinia pseudotuberculosis IP 31758) |
1e-50 |
59 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
8e-51 |
60 |
|
hypothetical protein |
NC_014228 (Xenorhabdus nematophila ATCC 19061) |
1e-50 |
52 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
2e-50 |
60 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
7e-50 |
56 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
7e-50 |
53 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
2e-49 |
56 |
|
putative inner membrane protein |
NC_016816 (Pantoea ananatis LMG 5342) |
9e-50 |
53 |
|
hypothetical protein |
NC_016845 (Klebsiella pneumoniae HS11286) |
1e-48 |
60 |
|
hypothetical protein |
NC_004547 (Pectobacterium atrosepticum SCRI1043) |
8e-49 |
58 |
|
integrating conjugative element membrane protein, PFL_4697 family |
NC_022082 (Klebsiella pneumoniae JM45) |
6e-48 |
60 |
|
hypothetical protein |
NC_013892 (Xenorhabdus bovienii SS-2004) |
7e-47 |
51 |
|
hypothetical protein |
NC_014029 (Yersinia pestis Z176003) |
7e-46 |
62 |
|
putative membrane protein |
NC_003198 (Salmonella enterica CT18) |
4e-44 |
56 |
|
hypothetical protein |
NC_004631 (Salmonella enterica Ty2) |
4e-44 |
56 |
|
hypothetical protein |
NC_012779 (Edwardsiella ictaluri 93-146) |
8e-44 |
57 |
|
membrane protein |
NC_021818 (Salmonella enterica CFSAN002050) |
9e-44 |
58 |
|
integrating conjugative element membrane protein |
NC_017554 (Pantoea ananatis PA13) |
2e-43 |
53 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
3e-40 |
56 |
|
hypothetical protein |
NC_016832 (Salmonella enterica P-stx-12) |
1e-39 |
58 |
|
hypothetical protein |
NC_017445 (Erwinia sp. Ejp617) |
8e-36 |
57 |
|
hypothetical protein |
NC_002940 (Haemophilus ducreyi 35000HP) |
2e-35 |
45 |
|
putative inner membrane protein |
NC_014121 (Enterobacter cloacae ATCC 13047) |
3e-34 |
55 |
|
integrating conjugative element membrane protein |
NC_015460 (Gallibacterium anatis UMN179) |
4e-34 |
44 |
|
hypothetical protein |
NC_008309 (Haemophilus somnus 129PT) |
5e-33 |
42 |
|
hypothetical protein |
NC_012660 (Pseudomonas fluorescens SBW25) |
9e-33 |
42 |
|
hypothetical protein |
NC_008739 (Marinobacter aquaeolei VT8) |
1e-32 |
42 |
|
hypothetical protein |
NC_014532 (Halomonas elongata DSM 2581) |
2e-32 |
46 |
|
hypothetical protein |
NC_012125 (Salmonella enterica RKS4594) |
2e-32 |
57 |
|
hypothetical protein |
NC_007492 (Pseudomonas fluorescens Pf0-1) |
8e-31 |
42 |
|
hypothetical protein |
NC_016809 (Haemophilus influenzae 10810) |
9e-30 |
43 |
|
hypothetical protein |
NC_007146 (Haemophilus influenzae 86-028NP) |
9e-30 |
43 |
|
conserved hypothetical protein p37 |
NC_017451 (Haemophilus influenzae R2866) |
9e-30 |
43 |
|
hypothetical protein |
NC_015964 (Haemophilus parainfluenzae T3T1) |
9e-30 |
43 |
|
hypothetical protein |
NC_010519 (Haemophilus somnus 2336) |
3e-28 |
42 |
|
integrating conjugative element membrane protein |
NC_021082 (Mannheimia haemolytica M42548) |
3e-28 |
42 |
|
integrating conjugative element membrane protein, PFL family |
NC_016808 (Pasteurella multocida 36950) |
3e-28 |
42 |
|
membrane protein |
NC_021743 (Mannheimia haemolytica D153) |
4e-28 |
42 |
|
membrane protein |
NC_021739 (Mannheimia haemolytica D174) |
4e-28 |
42 |
|
membrane protein |
NC_020833 (Mannheimia haemolytica USDA-ARS-USMARC-183) |
4e-28 |
42 |
|
membrane protein |
NC_021883 (Mannheimia haemolytica USMARC_2286) |
4e-28 |
42 |
|
membrane protein |
NC_020834 (Mannheimia haemolytica USDA-ARS-USMARC-185) |
6e-28 |
41 |
|
hypothetical protein |
NC_015733 (Pseudomonas putida S16) |
5e-27 |
42 |
|
hypothetical protein |
NC_010501 (Pseudomonas putida W619) |
6e-27 |
42 |
|
membrane protein |
NC_021491 (Pseudomonas putida H8234) |
7e-27 |
42 |
|
hypothetical protein |
NC_017986 (Pseudomonas putida ND6) |
3e-26 |
42 |
|
hypothetical protein |
NC_018220 (Pseudomonas putida DOT-T1E) |
7e-26 |
42 |
|
hypothetical protein |
NC_009512 (Pseudomonas putida F1) |
7e-26 |
42 |
|
hypothetical protein |
NC_018691 (Alcanivorax dieselolei B5) |
3e-24 |
41 |
|
hypothetical protein |
NC_006513 (Aromatoleum aromaticum EbN1) |
2e-22 |
41 |
|
hypothetical protein |
NC_011662 (Thauera sp. MZ1T) |
1e-21 |
41 |
|
membrane protein |
NC_018828 (Bordetella parapertussis Bpp5) |
1e-21 |
42 |
|
hypothetical protein |
NC_008825 (Methylibium petroleiphilum PM1) |
2e-21 |
41 |
|
hypothetical protein |
NC_015740 (Pseudomonas stutzeri ATCC 17588) |
2e-21 |
41 |
|
integrating conjugative element membrane protein |
NC_015422 (Alicycliphilus denitrificans K601) |
2e-21 |
41 |
|
hypothetical protein |
NC_008782 (Acidovorax sp. JS42) |
4e-21 |
41 |
|
hypothetical protein |
NC_016147 (Pseudoxanthomonas spadix BD-a59) |
1e-20 |
42 |
|
hypothetical protein |
NC_006513 (Aromatoleum aromaticum EbN1) |
1e-20 |
42 |
|
hypothetical protein |
NC_008752 (Acidovorax citrulli AAC00-1) |
1e-19 |
41 |
|
membrane protein |
NC_021491 (Pseudomonas putida H8234) |
2e-18 |
43 |
|
hypothetical protein |
NC_012691 (Tolumonas auensis DSM 9187) |
2e-18 |
42 |
|
hypothetical protein |
NC_010170 (Bordetella petrii DSM 12804) |
3e-18 |
43 |
|
hypothetical protein |
NC_021285 (Achromobacter xylosoxidans NH44784-1996) |
6e-18 |
42 |
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='42' 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