Take your query from the previous question and add columns to show what

'assembly' feature type the polypeptides are located on, as well as the fmin, fmax and strand

coordinates of each row. Again, attach your query and result rows as a text file to your

homework submission.

so far I have:

SELECT f.uniquename, product.value AS product, srcassembly.name, location.fmin, location.fmax, location.strand

FROM feature f

JOIN cvterm polypeptide ON f.type_id = polypeptide.cvterm_id

JOIN featureprop product ON f.feature_id = product.feature_id

JOIN cvterm productprop ON product.type_id = productprop.cvterm_id

JOIN featureloc location ON f.feature_id = location.feature_id

JOIN feature srcfeature ON location.srcfeature_id = srcfeature.feature_id

JOIN cvterm srcassembly ON srcfeature.type_id = srcassembly.cvterm_id

WHERE polypeptide.name = 'polypeptide'

AND productprop.name = 'gene_product_name'

And product.value like '%bifunctional%'

order by product.value;

I still need a uniquename collumn for assemly feature type.