Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
cytoplasmic protein |
NC_013353 (Escherichia coli 12009) |
6e-117 |
100 |
|
hypothetical protein |
NC_008563 (Escherichia coli APEC O1) |
6e-117 |
100 |
|
hypothetical protein |
NC_011745 (Escherichia coli ED1a) |
6e-117 |
100 |
|
hypothetical protein |
NC_011742 (Escherichia coli S88) |
6e-117 |
100 |
|
hypothetical protein |
NC_010498 (Escherichia coli SMS-3-5) |
6e-117 |
100 |
|
hypothetical protein |
NC_008253 (Escherichia coli 536) |
6e-117 |
99 |
|
hypothetical protein |
NC_017631 (Escherichia coli ABU 83972) |
6e-117 |
99 |
|
hypothetical protein |
NC_017646 (Escherichia coli CE10) |
6e-117 |
99 |
|
hypothetical protein |
NC_004431 (Escherichia coli CFT073) |
6e-117 |
99 |
|
hypothetical protein |
NC_017652 (Escherichia coli clone D i14) |
6e-117 |
99 |
|
hypothetical protein |
NC_017651 (Escherichia coli clone D i2) |
6e-117 |
99 |
|
hypothetical protein |
NC_011750 (Escherichia coli IAI39) |
6e-117 |
99 |
|
hypothetical protein |
NC_017628 (Escherichia coli IHE3034) |
6e-117 |
99 |
|
hypothetical protein |
NC_017632 (Escherichia coli UM146) |
6e-117 |
99 |
|
hypothetical protein |
NC_007946 (Escherichia coli UTI89) |
6e-117 |
99 |
|
hypothetical protein |
NC_017641 (Escherichia coli UMNK88) |
1e-116 |
99 |
|
hypothetical protein |
NC_018650 (Escherichia coli 2009EL-2050) |
2e-116 |
99 |
|
hypothetical protein |
NC_018661 (Escherichia coli 2009EL-2071) |
2e-116 |
99 |
|
hypothetical protein |
NC_018658 (Escherichia coli 2011C-3493) |
2e-116 |
99 |
|
hypothetical protein |
NC_011748 (Escherichia coli 55989) |
2e-116 |
99 |
|
hypothetical protein |
NC_013654 (Escherichia coli SE15) |
2e-116 |
99 |
|
hypothetical protein |
NC_022370 (Escherichia coli PMV-1) |
4e-107 |
99 |
|
hypothetical protein |
NC_021820 (Salmonella enterica 08-1736) |
1e-103 |
82 |
|
putative cytoplasmic protein |
NC_016856 (Salmonella enterica 14028S) |
1e-103 |
82 |
|
hypothetical protein |
NC_011274 (Salmonella enterica 287/91) |
1e-103 |
82 |
|
hypothetical protein |
NC_021810 (Salmonella enterica 41578) |
1e-103 |
82 |
|
hypothetical protein |
NC_017046 (Salmonella enterica 798) |
1e-103 |
82 |
|
hypothetical protein |
NC_017623 (Salmonella enterica B182) |
1e-103 |
82 |
|
hypothetical protein |
NC_022221 (Salmonella enterica CDC1983-67) |
1e-103 |
82 |
|
hypothetical protein |
NC_021844 (Salmonella enterica CFSAN000189) |
1e-103 |
82 |
|
hypothetical protein |
NC_021814 (Salmonella enterica CFSAN001921) |
1e-103 |
82 |
|
hypothetical protein |
NC_020307 (Salmonella enterica CFSAN001992) |
1e-103 |
82 |
|
hypothetical protein |
NC_021812 (Salmonella enterica CFSAN002069) |
1e-103 |
82 |
|
hypothetical protein |
NC_011205 (Salmonella enterica CT_02021853) |
1e-103 |
82 |
|
hypothetical protein |
NC_011094 (Salmonella enterica CVM19633) |
1e-103 |
82 |
|
hypothetical protein |
NC_016854 (Salmonella enterica D23580) |
1e-103 |
82 |
|
hypothetical protein |
NC_003197 (Salmonella enterica LT2) |
1e-103 |
82 |
|
hypothetical protein |
NC_016831 (Salmonella enterica RKS5078) |
1e-103 |
82 |
|
hypothetical protein |
NC_021984 (Salmonella enterica S06004) |
1e-103 |
82 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
1e-103 |
82 |
|
hypothetical protein |
NC_016810 (Salmonella enterica SL1344) |
1e-103 |
82 |
|
hypothetical protein |
NC_011080 (Salmonella enterica SL254) |
1e-103 |
82 |
|
hypothetical protein |
NC_011083 (Salmonella enterica SL476) |
1e-103 |
82 |
|
hypothetical protein |
NC_011149 (Salmonella enterica SL483) |
1e-103 |
82 |
|
putative cytoplasmic protein |
NC_016857 (Salmonella enterica ST4/74) |
1e-103 |
82 |
|
hypothetical protein |
NC_016860 (Salmonella enterica T000240) |
1e-103 |
82 |
|
putative cytoplasmic protein |
NC_016863 (Salmonella enterica UK-1) |
1e-103 |
82 |
|
Cytoplasmic protein |
NC_021902 (Salmonella enterica USMARC-S3124.1) |
1e-103 |
82 |
|
hypothetical protein |
NC_011294 (Salmonella enterica P125109) |
1e-103 |
81 |
|
hypothetical protein |
NC_006905 (Salmonella enterica SC-B67) |
1e-103 |
81 |
|
conserved hypothetical protein |
NC_022241 (Salmonella enterica 3114) |
2e-103 |
81 |
|
hypothetical protein |
NC_003198 (Salmonella enterica CT18) |
2e-103 |
81 |
|
hypothetical protein |
NC_016832 (Salmonella enterica P-stx-12) |
2e-103 |
81 |
|
hypothetical protein |
NC_004631 (Salmonella enterica Ty2) |
2e-103 |
81 |
|
hypothetical protein |
NC_021176 (Salmonella enterica Ty21a) |
2e-103 |
81 |
|
hypothetical protein |
NC_021818 (Salmonella enterica CFSAN002050) |
3e-103 |
82 |
|
Putative cytoplasmic protein |
NC_021870 (Salmonella bongori N268-08) |
1e-102 |
82 |
|
hypothetical protein |
NC_015761 (Salmonella bongori NCTC 12419) |
1e-102 |
82 |
|
hypothetical protein |
NC_021151 (Salmonella enterica U288) |
1e-102 |
82 |
|
hypothetical protein |
NC_011147 (Salmonella enterica AKU12601) |
2e-102 |
81 |
|
hypothetical protein |
NC_006511 (Salmonella enterica ATCC 9150) |
2e-102 |
81 |
|
hypothetical protein |
NC_012125 (Salmonella enterica RKS4594) |
2e-102 |
81 |
|
hypothetical protein |
NC_017731 (Providencia stuartii MRSN 2154) |
7e-92 |
73 |
|
hypothetical protein |
NC_022000 (Proteus mirabilis BB2000) |
6e-91 |
72 |
|
hypothetical protein |
NC_010554 (Proteus mirabilis HI4320) |
6e-91 |
72 |
|
hypothetical protein |
NC_017644 (Escherichia coli NA114) |
2e-82 |
98 |
|
hypothetical protein |
NC_021820 (Salmonella enterica 08-1736) |
3e-79 |
66 |
|
putative cytoplasmic protein |
NC_016856 (Salmonella enterica 14028S) |
3e-79 |
66 |
|
hypothetical protein |
NC_022241 (Salmonella enterica 3114) |
3e-79 |
66 |
|
hypothetical protein |
NC_017046 (Salmonella enterica 798) |
3e-79 |
66 |
|
hypothetical protein |
NC_021844 (Salmonella enterica CFSAN000189) |
3e-79 |
66 |
|
hypothetical protein |
NC_021814 (Salmonella enterica CFSAN001921) |
3e-79 |
66 |
|
hypothetical protein |
NC_021818 (Salmonella enterica CFSAN002050) |
3e-79 |
66 |
|
Orf 245 protein |
NC_016854 (Salmonella enterica D23580) |
3e-79 |
66 |
|
hypothetical protein |
NC_003197 (Salmonella enterica LT2) |
3e-79 |
66 |
|
hypothetical protein |
NC_012125 (Salmonella enterica RKS4594) |
3e-79 |
66 |
|
hypothetical protein |
NC_006905 (Salmonella enterica SC-B67) |
3e-79 |
66 |
|
hypothetical protein |
NC_010102 (Salmonella enterica SGSC4150; SPB7) |
3e-79 |
66 |
|
hypothetical protein |
NC_016810 (Salmonella enterica SL1344) |
3e-79 |
66 |
|
hypothetical protein |
NC_011080 (Salmonella enterica SL254) |
3e-79 |
66 |
|
hypothetical protein |
NC_011149 (Salmonella enterica SL483) |
3e-79 |
66 |
|
putative cytoplasmic protein |
NC_016857 (Salmonella enterica ST4/74) |
3e-79 |
66 |
|
hypothetical protein |
NC_016860 (Salmonella enterica T000240) |
3e-79 |
66 |
|
hypothetical protein |
NC_021151 (Salmonella enterica U288) |
3e-79 |
66 |
|
putative cytoplasmic protein |
NC_016863 (Salmonella enterica UK-1) |
3e-79 |
66 |
|
Cytoplasmic protein |
NC_021902 (Salmonella enterica USMARC-S3124.1) |
3e-79 |
66 |
|
hypothetical protein |
NC_011094 (Salmonella enterica CVM19633) |
4e-79 |
67 |
|
hypothetical protein |
NC_021810 (Salmonella enterica 41578) |
4e-79 |
66 |
|
hypothetical protein |
NC_017623 (Salmonella enterica B182) |
4e-79 |
66 |
|
hypothetical protein |
NC_021812 (Salmonella enterica CFSAN002069) |
4e-79 |
66 |
|
hypothetical protein |
NC_011083 (Salmonella enterica SL476) |
4e-79 |
66 |
|
hypothetical protein |
NC_011205 (Salmonella enterica CT_02021853) |
5e-79 |
66 |
|
Orf 245 protein |
NC_011294 (Salmonella enterica P125109) |
5e-79 |
66 |
|
Orf 245 protein |
NC_003198 (Salmonella enterica CT18) |
7e-79 |
66 |
|
hypothetical protein |
NC_016832 (Salmonella enterica P-stx-12) |
7e-79 |
66 |
|
hypothetical protein |
NC_004631 (Salmonella enterica Ty2) |
7e-79 |
66 |
|
hypothetical protein |
NC_021176 (Salmonella enterica Ty21a) |
7e-79 |
66 |
|
hypothetical protein |
NC_020307 (Salmonella enterica CFSAN001992) |
9e-79 |
66 |
|
hypothetical protein |
NC_011147 (Salmonella enterica AKU12601) |
2e-78 |
66 |
|
hypothetical protein |
NC_006511 (Salmonella enterica ATCC 9150) |
2e-78 |
66 |
|
pathogenicity island protein |
NC_015761 (Salmonella bongori NCTC 12419) |
1e-76 |
65 |
|
hypothetical protein |
NC_009832 (Serratia proteamaculans 568) |
3e-75 |
64 |
|
hypothetical protein |
NC_013315 (Clostridium difficile CD196) |
2e-62 |
51 |
|
hypothetical protein |
NC_013316 (Clostridium difficile R20291) |
2e-62 |
51 |
|
hypothetical protein |
NC_009089 (Clostridium difficile 630) |
4e-62 |
51 |
|
hypothetical protein |
NC_014150 (Brachyspira murdochii DSM 12563) |
3e-55 |
48 |
|
hypothetical protein |
NC_018607 (Brachyspira pilosicoli B2904) |
4e-55 |
47 |
|
putative cytoplasmic protein |
NC_018604 (Brachyspira pilosicoli WesB) |
4e-55 |
47 |
|
hypothetical protein |
NC_013517 (Sebaldella termitidis ATCC 33386) |
5e-54 |
47 |
|
hypothetical protein |
NC_015312 (Pseudonocardia dioxanivorans CB1190) |
5e-52 |
47 |
|
hypothetical protein |
NC_015312 (Pseudonocardia dioxanivorans CB1190) |
5e-52 |
47 |
|
hypothetical protein |
NC_016048 (Oscillibacter valericigenes Sjm18-20) |
1e-51 |
44 |
|
hypothetical protein |
NC_014376 (Clostridium saccharolyticum WM1) |
9e-52 |
43 |
|
hypothetical protein |
NC_022115 (Rhodococcus erythropolis CCM2595) |
1e-49 |
46 |
|
hypothetical protein |
NC_012490 (Rhodococcus erythropolis PR4) |
1e-49 |
46 |
|
hypothetical protein |
NC_016943 (Blastococcus saxobsidens DD2) |
9e-48 |
44 |
|
hypothetical protein |
NC_021252 (Amycolatopsis orientalis HCCB10007) |
3e-47 |
46 |
|
hypothetical protein |
NC_018000 (Sinorhizobium fredii USDA 257) |
4e-46 |
44 |
|
hypothetical protein |
NC_020819 (Lactobacillus brevis KB290) |
5e-45 |
44 |
|
hypothetical protein |
NC_014165 (Thermobispora bispora DSM 43833) |
5e-45 |
43 |
|
hypothetical protein |
NC_012852 (Rhizobium leguminosarum WSM1325) |
4e-44 |
44 |
|
hypothetical protein |
NC_017456 (Gardnerella vaginalis HMP9231) |
4e-44 |
43 |
|
hypothetical protein |
NC_015389 (Coriobacterium glomerans PW2) |
5e-44 |
42 |
|
Uncharacterized membrane protein |
NC_021024 (butyrate-producing bacterium SM4/1) |
5e-44 |
41 |
|
Uncharacterized membrane protein |
NC_021047 (Clostridium saccharolyticum K10) |
5e-44 |
41 |
|
hypothetical protein |
NC_008379 (Rhizobium leguminosarum 3841) |
7e-44 |
44 |
|
Uncharacterized membrane protein |
NC_021022 ([Ruminococcus] obeum A2-162) |
1e-43 |
44 |
|
hypothetical protein |
NC_014306 (Erwinia billingiae Eb661) |
2e-43 |
42 |
|
hypothetical protein |
NC_011283 (Klebsiella pneumoniae 342) |
2e-43 |
41 |
|
hypothetical protein |
NC_013850 (Klebsiella variicola At-22) |
2e-43 |
41 |
|
putative cytoplasmic protein |
NC_014644 (Gardnerella vaginalis ATCC 14019) |
3e-43 |
43 |
|
hypothetical protein |
NC_018106 (Klebsiella oxytoca E718) |
3e-43 |
41 |
|
hypothetical protein |
NC_017540 (Klebsiella pneumoniae KCTC 2242) |
4e-43 |
41 |
|
hypothetical protein |
NC_021066 (Raoultella ornithinolytica B6) |
5e-43 |
42 |
|
hypothetical protein |
NC_016845 (Klebsiella pneumoniae HS11286) |
5e-43 |
41 |
|
hypothetical protein |
NC_022082 (Klebsiella pneumoniae JM45) |
5e-43 |
41 |
|
hypothetical protein |
NC_016612 (Klebsiella oxytoca KCTC 1686) |
1e-42 |
41 |
|
hypothetical protein |
NC_018522 (Klebsiella pneumoniae 1084) |
8e-43 |
41 |
|
hypothetical protein |
NC_012731 (Klebsiella pneumoniae NTUH-K2044) |
8e-43 |
41 |
|
hypothetical protein |
NC_008786 (Verminephrobacter eiseniae EF01-2) |
2e-42 |
46 |
|
cytoplasmic protein |
NC_017531 (Pantoea ananatis AJ13355) |
2e-42 |
41 |
|
hypothetical Protein |
NC_013956 (Pantoea ananatis LMG 20103) |
2e-42 |
41 |
|
hypothetical protein |
NC_016816 (Pantoea ananatis LMG 5342) |
2e-42 |
41 |
|
putative cytoplasmic protein |
NC_017554 (Pantoea ananatis PA13) |
2e-42 |
41 |
|
hypothetical protein |
NC_015675 (Mesorhizobium opportunistum WSM2075) |
4e-42 |
48 |
|
hypothetical protein |
NC_002678 (Mesorhizobium loti MAFF303099) |
1e-41 |
48 |
|
hypothetical protein |
NC_011981 (Agrobacterium vitis S4) |
8e-41 |
43 |
|
hypothetical protein |
NC_007005 (Pseudomonas syringae B728a) |
2e-39 |
41 |
|
hypothetical protein |
NC_014923 (Mesorhizobium ciceri WSM1271) |
4e-39 |
41 |
|
hypothetical protein |
NC_015675 (Mesorhizobium opportunistum WSM2075) |
1e-38 |
41 |
|
hypothetical protein |
NC_022049 (Paracoccus aminophilus JCM 7686) |
3e-37 |
42 |
|
hypothetical protein |
NC_014562 (Pantoea vagans C9-1) |
5e-37 |
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_008563_P3' AND ph.id_pai_orf='33' 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