| Hit (GenBank Accn) | Product | Source Genome | Eval. | Ident.(%) | 
|  | putative transposase (partial) | NC_017626 (Escherichia coli 042)
 | 2e-32 | 96 | 
|  | transposase ORF1, IS3 family (fragment) | NC_011748 (Escherichia coli 55989)
 | 2e-32 | 96 | 
|  | putative transposase | NC_017631 (Escherichia coli ABU 83972)
 | 2e-32 | 96 | 
|  | hypothetical protein | NC_013654 (Escherichia coli SE15)
 | 2e-32 | 96 | 
|  | putative transposase | NC_017633 (Escherichia coli ETEC H10407)
 | 8e-30 | 100 | 
|  | ISSfl4 ORF1 | NC_007613 (Shigella boydii Sb227)
 | 3e-28 | 82 | 
|  | Putative transposase | NC_017644 (Escherichia coli NA114)
 | 2e-26 | 96 | 
|  | hypothetical protein | NC_018654 (Escherichia coli 2009EL-2050)
 | 2e-26 | 95 | 
|  | hypothetical protein | NC_018662 (Escherichia coli 2009EL-2071)
 | 2e-26 | 95 | 
|  | hypothetical protein | NC_018666 (Escherichia coli 2011C-3493)
 | 2e-26 | 95 | 
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='AF286670' AND ph.id_pai_orf='3' 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