| Hit (GenBank Accn) |      
      Product |  
      Source Genome |  
      
      Eval. | 
      Ident.(%) | 
    
|  
                   
                | 
               hypothetical protein | 
               NC_002570 (Bacillus halodurans C-125) | 
               3e-13 | 
               81 | 
|  
                   
                | 
               Phospho-beta-galactosidase | 
               NC_017469 (Lactobacillus delbrueckii 2038) | 
               6e-13 | 
               68 | 
|  
                   
                | 
               Beta-glucosidase/6-phospho-beta- glucosidase/beta-galactosid ase | 
               NC_021019 (Eubacterium cylindroides T2-87) | 
               1e-12 | 
               77 | 
|  
                   
                | 
               glycosyl hydrolase family protein | 
               NC_017138 (Bacillus megaterium WSH-002) | 
               1e-12 | 
               86 | 
|  
                   
                | 
               6-phospho-beta-glucosidase | 
               NC_016641 (Paenibacillus terrae HPL-003) | 
               4e-12 | 
               70 | 
|  
                   
                | 
               Beta-glucosidase/6-phospho-beta- glucosidase/beta-galactosid ase | 
               NC_021014 (Ruminococcus sp. SR1/5) | 
               1e-11 | 
               68 | 
|  
                   
                | 
               6-phospho-beta-glucosidase | 
               NC_016052 (Tetragenococcus halophilus NBRC 12172) | 
               3e-11 | 
               65 | 
|  
                   
                | 
               beta-glucosidase | 
               NC_007350 (Staphylococcus saprophyticus ATCC 15305) | 
               8e-10 | 
               62 | 
|  
                   
                | 
               hypothetical protein | 
               NC_021744 (Lactobacillus helveticus CNRZ32) | 
               2e-08 | 
               61 | 
|  
                   
                | 
               6-phospho-beta-glucosidase | 
               NC_004722 (Bacillus cereus ATCC 14579 ) | 
               1e-05 | 
               54 | 
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='AJ007319' AND ph.id_pai_orf='1' 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