Best Annotation  | UniProtKB/Swiss-Prot:LTAE_ECOLI (RecName: Full=Low specificity L-threonine aldolase; Short=Low specificity L-TA; EC=4.1.2.5;) |
|---|
SQL query:
SELECT params_id, pstart, pstop, pct_ident, pct_cov, L.genasm_id, G.tax_id, T.latin, G.name as genome_name, chr, strand, gstart, gstop
FROM pmap_mv L
JOIN genasm G ON L.genasm_id=G.genasm_id
JOIN tax.spspec T on G.tax_id=T.tax_id
WHERE L.genasm_id=G.genasm_id AND L.params_id=48 AND L.pseq_id=64007
ORDER BY tax_id, genasm_id, chr
SELECT params_id, pstart, pstop, pct_ident, pct_cov, L.genasm_id, G.tax_id, T.latin, G.name as genome_name, chr, strand, gstart, gstop
FROM pmap_mv L
JOIN genasm G ON L.genasm_id=G.genasm_id
JOIN tax.spspec T on G.tax_id=T.tax_id
WHERE L.genasm_id=G.genasm_id AND L.params_id=48 AND L.pseq_id=64007
ORDER BY tax_id, genasm_id, chr
page generated in 0 seconds