| Hit (GenBank Accn) | Product | Source Genome | Eval. | Ident.(%) | 
|  | type III effector HrpK1 | NC_005773 (Pseudomonas syringae 1448A)
 | 0.0 | 96 | 
|  | type III helper protein HrpK1 | NC_007005 (Pseudomonas syringae  B728a)
 | 0.0 | 98 | 
|  | type III helper protein HrpK1 | NC_004578 (Pseudomonas syringae  DC3000)
 | 0.0 | 82 | 
|  | Pathogenicity locus protein hrpK | NC_017445 (Erwinia sp. Ejp617)
 | 7e-121 | 44 | 
|  | hrp/hrc type III secretion system-type III effector HrpK | NC_012214 (Erwinia pyrifoliae Ep1/96)
 | 6e-119 | 44 | 
|  | Pathogenicity locus protein hrpK | NC_017390 (Erwinia pyrifoliae DSM 12163)
 | 1e-118 | 44 | 
|  | type III secretion system protein | NC_013971 (Erwinia amylovora ATCC 49946)
 | 5e-106 | 42 | 
|  | Pathogenicity locus protein hrpK | NC_013961 (Erwinia amylovora CFBP1430)
 | 5e-106 | 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='EF514224' 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