Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_017340 (Staphylococcus aureus 04-02981) |
8e-32 |
100 |
|
hypothetical protein |
NC_009632 (Staphylococcus aureus JH1) |
8e-32 |
100 |
|
hypothetical protein |
NC_009487 (Staphylococcus aureus JH9) |
8e-32 |
100 |
|
hypothetical protein |
NC_016928 (Staphylococcus aureus M013) |
8e-32 |
100 |
|
hypothetical protein |
NC_021059 (Staphylococcus aureus M1) |
8e-32 |
100 |
|
hypothetical protein |
NC_009782 (Staphylococcus aureus Mu3) |
8e-32 |
100 |
|
hypothetical protein |
NC_002758 (Staphylococcus aureus Mu50) |
8e-32 |
100 |
|
hypothetical protein |
NC_007795 (Staphylococcus aureus NCTC 8325) |
8e-32 |
100 |
|
hypothetical protein |
NC_022442 (Staphylococcus aureus SA957) |
8e-32 |
100 |
|
hypothetical protein |
NC_019425 (Carnobacterium maltaromaticum LMA28) |
8e-23 |
63 |
|
hypothetical protein |
NC_019425 (Carnobacterium maltaromaticum LMA28) |
3e-22 |
62 |
|
hypothetical protein |
NC_009617 (Clostridium beijerinckii NCIMB 8052) |
2e-14 |
46 |
|
CRISPR associated protein Cas2 |
NC_017022 (Enterococcus faecium Aus0004) |
2e-10 |
43 |
|
CRISPR associated protein, Cas2_1 |
NC_017022 (Enterococcus faecium Aus0004) |
2e-10 |
43 |
|
hypothetical protein |
NC_017960 (Enterococcus faecium DO) |
2e-10 |
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_002758_P3' AND ph.id_pai_orf='20' 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