Hit (GenBank Accn) |
Product |
Source Genome |
Eval. |
Ident.(%) |
|
hypothetical protein |
NC_007793 (Staphylococcus aureus FPR3757) |
1e-47 |
100 |
|
hypothetical protein |
NC_017340 (Staphylococcus aureus 04-02981) |
2e-47 |
100 |
|
hypothetical protein |
NC_017673 (Staphylococcus aureus 71193) |
2e-47 |
100 |
|
hypothetical protein |
NC_021670 (Staphylococcus aureus Bmb9393) |
2e-47 |
100 |
|
hypothetical protein |
NC_021554 (Staphylococcus aureus CA-347) |
2e-47 |
100 |
|
hypothetical protein |
NC_017343 (Staphylococcus aureus ECT-R 2) |
2e-47 |
100 |
|
phage protein |
NC_017763 (Staphylococcus aureus HO 5096 0412) |
2e-47 |
100 |
|
hypothetical protein |
NC_009632 (Staphylococcus aureus JH1) |
2e-47 |
100 |
|
hypothetical protein |
NC_017341 (Staphylococcus aureus JKD6008) |
2e-47 |
100 |
|
hypothetical protein |
NC_017338 (Staphylococcus aureus JKD6159) |
2e-47 |
100 |
|
hypothetical protein |
NC_016928 (Staphylococcus aureus M013) |
2e-47 |
100 |
|
hypothetical protein |
NC_002952 (Staphylococcus aureus MRSA252) |
2e-47 |
100 |
|
phage protein |
NC_016941 (Staphylococcus aureus MSHR1132) |
2e-47 |
100 |
|
hypothetical protein |
NC_009782 (Staphylococcus aureus Mu3) |
2e-47 |
100 |
|
hypothetical protein |
NC_002758 (Staphylococcus aureus Mu50) |
2e-47 |
100 |
|
hypothetical protein |
NC_002745 (Staphylococcus aureus N315) |
2e-47 |
100 |
|
hypothetical protein |
NC_009641 (Staphylococcus aureus Newman) |
2e-47 |
100 |
|
hypothetical protein |
NC_022442 (Staphylococcus aureus SA957) |
2e-47 |
100 |
|
hypothetical protein |
NC_017347 (Staphylococcus aureus T0131) |
2e-47 |
100 |
|
hypothetical protein |
NC_010079 (Staphylococcus aureus TCH1516) |
2e-47 |
100 |
|
phage protein |
NC_017331 (Staphylococcus aureus TW20) |
2e-47 |
100 |
|
hypothetical protein |
NC_022226 (Staphylococcus aureus CN1) |
3e-47 |
100 |
|
phage protein |
NC_017337 (Staphylococcus aureus ED133) |
3e-47 |
100 |
|
hypothetical protein |
NC_009487 (Staphylococcus aureus JH9) |
3e-47 |
100 |
|
phage protein |
NC_022113 (Staphylococcus aureus 55/2053) |
4e-43 |
99 |
|
hypothetical protein |
NC_012121 (Staphylococcus carnosus TM300) |
1e-32 |
67 |
|
hypothetical protein |
NC_018500 (Bacillus thuringiensis HD-771) |
4e-31 |
67 |
|
hypothetical protein |
NC_018500 (Bacillus thuringiensis HD-771) |
4e-31 |
67 |
|
hypothetical protein |
NC_018508 (Bacillus thuringiensis HD-789) |
4e-31 |
67 |
|
hypothetical protein |
NC_010183 (Bacillus weihenstephanensis KBAB4) |
2e-16 |
42 |
|
hypothetical protein |
NC_012659 (Bacillus anthracis A0248) |
5e-10 |
42 |
|
hypothetical protein |
NC_003997 (Bacillus anthracis Ames) |
5e-10 |
42 |
|
hypothetical protein |
NC_007530 (Bacillus anthracis Ames Ancestor) |
5e-10 |
42 |
|
hypothetical protein |
NC_012581 (Bacillus anthracis CDC 684) |
5e-10 |
42 |
|
hypothetical protein |
NC_017729 (Bacillus anthracis H9401) |
5e-10 |
42 |
|
hypothetical protein |
NC_005945 (Bacillus anthracis Sterne) |
5e-10 |
42 |
|
hypothetical protein |
NC_006274 (Bacillus cereus E33L) |
6e-10 |
42 |
|
hypothetical protein |
NC_012659 (Bacillus anthracis A0248) |
6e-10 |
42 |
|
hypothetical protein |
NC_003997 (Bacillus anthracis Ames) |
6e-10 |
42 |
|
hypothetical protein |
NC_007530 (Bacillus anthracis Ames Ancestor) |
6e-10 |
42 |
|
hypothetical protein |
NC_012581 (Bacillus anthracis CDC 684) |
6e-10 |
42 |
|
hypothetical protein |
NC_017729 (Bacillus anthracis H9401) |
6e-10 |
42 |
|
hypothetical protein |
NC_005945 (Bacillus anthracis Sterne) |
6e-10 |
42 |
|
hypothetical protein |
NC_010184 (Bacillus weihenstephanensis KBAB4) |
9e-10 |
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_002745_P4' AND ph.id_pai_orf='31' 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