Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_002976 (Staphylococcus epidermidis RP62A) |
5e-38 |
100 |
|
hypothetical protein |
NC_020164 (Staphylococcus warneri SG1) |
6e-30 |
80 |
|
hypothetical protein |
NC_007168 (Staphylococcus haemolyticus JCSC1435) |
8e-20 |
60 |
|
hypothetical protein |
NC_006361 (Nocardia farcinica IFM 10152) |
4e-15 |
47 |
|
hypothetical protein |
NC_014551 (Bacillus amyloliquefaciens DSM 7) |
1e-13 |
48 |
|
hypothetical protein |
NC_009706 (Clostridium kluyveri DSM 555) |
5e-13 |
47 |
|
hypothetical protein |
NC_011837 (Clostridium kluyveri NBRC 12016) |
5e-13 |
47 |
|
hypothetical protein |
NC_009343 (Corynebacterium glutamicum R) |
9e-13 |
44 |
|
hypothetical protein |
NC_009706 (Clostridium kluyveri DSM 555) |
2e-12 |
46 |
|
hypothetical protein |
NC_011837 (Clostridium kluyveri NBRC 12016) |
2e-12 |
46 |
|
prophage P2a protein 33 |
NC_004567 (Lactobacillus plantarum WCFS1) |
1e-11 |
49 |
|
prophage Lp2 protein 33 |
NC_014498 (Streptococcus pneumoniae 670-6B) |
2e-11 |
46 |
|
phage-associated protein |
NC_018594 (Streptococcus pneumoniae A45) |
2e-11 |
46 |
|
phage protein |
NC_015516 (Melissococcus plutonius ATCC 35311) |
3e-11 |
54 |
|
hypothetical protein |
NC_017950 (Streptococcus suis ST1) |
3e-11 |
47 |
|
hypothetical protein |
NC_013853 (Streptococcus mitis B6) |
9e-11 |
48 |
|
hypothetical protein |
NC_015717 (Hyphomicrobium sp. MC1) |
1e-10 |
44 |
|
hypothetical protein |
NC_003485 (Streptococcus pyogenes MGAS8232) |
1e-10 |
49 |
|
hypothetical protein |
NC_017297 (Clostridium botulinum 230613) |
1e-10 |
45 |
|
hypothetical protein |
NC_009699 (Clostridium botulinum Langeland) |
1e-10 |
45 |
|
hypothetical protein |
NC_009332 (Streptococcus pyogenes Manfredo) |
2e-10 |
49 |
|
phage protein |
NC_017299 (Clostridium botulinum H04402 065) |
3e-10 |
44 |
|
hypothetical protein |
NC_012466 (Streptococcus pneumoniae JJA) |
5e-10 |
52 |
|
hypothetical protein |
NC_015589 (Desulfotomaculum ruminis DSM 2154) |
6e-10 |
47 |
|
prophage P2a protein 33 |
NC_021514 (Lactobacillus plantarum 16) |
6e-10 |
46 |
|
gp9 |
NC_012658 (Clostridium botulinum 657) |
7e-10 |
44 |
|
hypothetical protein |
NC_015683 (Corynebacterium ulcerans BR-AD22) |
2e-09 |
48 |
|
prophage Lp2 protein 33 |
NC_017190 (Bacillus amyloliquefaciens LL3) |
3e-09 |
42 |
|
prophage Lp2 protein 33 |
NC_017188 (Bacillus amyloliquefaciens TA208) |
3e-09 |
42 |
|
prophage Lp2 protein 33 |
NC_017191 (Bacillus amyloliquefaciens XH7) |
3e-09 |
42 |
|
hypothetical protein |
NC_007406 (Nitrobacter winogradskyi Nb-255) |
5e-09 |
41 |
|
phage protein |
NC_019770 (Enterococcus faecalis Symbioflor 1) |
3e-08 |
46 |
|
hypothetical protein |
NC_014834 (Rhodopseudomonas palustris DX-1) |
3e-08 |
46 |
|
hypothetical protein |
NC_017619 (Streptococcus suis SS12) |
8e-08 |
41 |
|
phage protein |
NC_006086 (Streptococcus pyogenes MGAS10394) |
2e-07 |
45 |
|
hypothetical protein |
NC_004070 (Streptococcus pyogenes MGAS315) |
2e-07 |
45 |
|
hypothetical protein |
NC_004606 (Streptococcus pyogenes SSI-1) |
3e-07 |
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_002976_P2' AND ph.id_pai_orf='67' 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