Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_007168 (Staphylococcus haemolyticus JCSC1435) |
4e-39 |
100 |
|
hypothetical protein |
NC_016894 (Acetobacterium woodii DSM 1030) |
5e-22 |
48 |
|
hypothetical protein |
NC_006322 (Bacillus licheniformis DSM 13) |
8e-21 |
46 |
|
hypothetical protein |
NC_006270 (Bacillus licheniformis DSM 13) |
8e-21 |
46 |
|
hypothetical protein |
NC_009328 (Geobacillus thermodenitrificans NG80-2) |
1e-20 |
49 |
|
hypothetical protein |
NC_021362 (Bacillus licheniformis 9945A) |
1e-20 |
45 |
|
hypothetical protein |
NC_007355 (Methanosarcina barkeri Fusaro) |
1e-20 |
44 |
|
hypothetical protein |
NC_014651 (Geobacillus sp. Y4.1MC1) |
1e-19 |
47 |
|
hypothetical protein |
NC_014644 (Gardnerella vaginalis ATCC 14019) |
6e-19 |
48 |
|
hypothetical protein |
NC_017456 (Gardnerella vaginalis HMP9231) |
6e-19 |
48 |
|
hypothetical protein |
NC_012658 (Clostridium botulinum 657) |
6e-19 |
45 |
|
hypothetical protein |
NC_018664 (Clostridium acidurici 9a) |
1e-18 |
46 |
|
hypothetical protein |
NC_013721 (Gardnerella vaginalis 409-05) |
2e-18 |
48 |
|
hypothetical protein |
NC_018017 (Desulfitobacterium dehalogenans ATCC 51507) |
6e-18 |
49 |
|
hypothetical protein |
NC_009785 (Streptococcus gordonii Challis) |
8e-18 |
41 |
|
hypothetical protein |
NC_016627 (Clostridium clariflavum DSM 19732) |
2e-17 |
46 |
|
hypothetical protein |
NC_010001 (Clostridium phytofermentans ISDg) |
2e-17 |
44 |
|
hypothetical protein |
NC_015172 (Syntrophobotulus glycolicus DSM 8271) |
2e-17 |
43 |
|
hypothetical protein |
NC_018017 (Desulfitobacterium dehalogenans ATCC 51507) |
3e-17 |
42 |
|
Conserved hypothetical protein with helix-turn-helix motif |
NC_020517 (Bifidobacterium breve UCC2003) |
3e-17 |
44 |
|
hypothetical protein |
NC_011593 (Bifidobacterium longum JCM 1222) |
3e-17 |
44 |
|
hypothetical protein |
NC_017219 (Bifidobacterium longum JCM 1222) |
3e-17 |
44 |
|
hypothetical protein |
NC_004604 (Bacillus megaterium QM B1551) |
4e-17 |
44 |
|
hypothetical protein |
NC_021514 (Lactobacillus plantarum 16) |
5e-17 |
51 |
|
hypothetical protein |
NC_012984 (Lactobacillus plantarum JDM1) |
5e-17 |
51 |
|
hypothetical protein |
NC_021224 (Lactobacillus plantarum P-8) |
5e-17 |
51 |
|
hypothetical protein |
NC_014554 (Lactobacillus plantarum ST-III) |
5e-17 |
51 |
|
hypothetical protein |
NC_004567 (Lactobacillus plantarum WCFS1) |
5e-17 |
51 |
|
Hypothetical protein |
NC_020229 (Lactobacillus plantarum ZJ316) |
5e-17 |
51 |
|
hypothetical protein |
NC_014656 (Bifidobacterium longum BBMN68) |
5e-17 |
44 |
|
hypothetical protein |
NC_017221 (Bifidobacterium longum KACC 91563) |
5e-17 |
44 |
|
hypothetical protein |
NC_011593 (Bifidobacterium longum JCM 1222) |
6e-17 |
43 |
|
hypothetical protein |
NC_014169 (Bifidobacterium longum JDM301) |
7e-17 |
42 |
|
hypothetical protein |
NC_010471 (Leuconostoc citreum KM20) |
3e-15 |
45 |
|
hypothetical protein |
NC_016837 (Streptococcus infantarius CJ18) |
6e-13 |
47 |
|
hypothetical protein |
NC_017219 (Bifidobacterium longum JCM 1222) |
6e-13 |
44 |
|
hypothetical protein |
NC_018081 (Enterococcus hirae ATCC 9790) |
2e-12 |
50 |
|
hypothetical protein |
NC_009004 (Lactococcus lactis MG1363) |
4e-11 |
45 |
|
hypothetical protein |
NC_017949 (Lactococcus lactis NZ9000) |
4e-11 |
45 |
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_007168_R3' AND ph.id_pai_orf='23' 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