gfffeatureatts(integer)

SELECT feature_id, 'cvterm' AS type,  s.name AS attribute

FROM cvterm s, feature_cvterm fs

WHERE fs.feature_id= $1 AND fs.cvterm_id = s.cvterm_id

UNION

SELECT feature_id, 'dbxref' AS type, d.name || ':' || s.accession AS attribute

FROM dbxref s, feature_dbxref fs, db d

WHERE fs.feature_id= $1 AND fs.dbxref_id = s.dbxref_id AND s.db_id = d.db_id

--UNION

--SELECT feature_id, 'expression' AS type, s.description AS attribute

--FROM expression s, feature_expression fs

--WHERE fs.feature_id= $1 AND fs.expression_id = s.expression_id

--UNION

--SELECT fg.feature_id, 'genotype' AS type, g.uniquename||': '||g.description AS attribute

--FROM gcontext g, feature_gcontext fg

--WHERE fg.feature_id= $1 AND g.gcontext_id = fg.gcontext_id

--UNION

--SELECT feature_id, 'genotype' AS type, s.description AS attribute

--FROM genotype s, feature_genotype fs

--WHERE fs.feature_id= $1 AND fs.genotype_id = s.genotype_id

--UNION

--SELECT feature_id, 'phenotype' AS type, s.description AS attribute

--FROM phenotype s, feature_phenotype fs

--WHERE fs.feature_id= $1 AND fs.phenotype_id = s.phenotype_id

UNION

SELECT feature_id, 'synonym' AS type, s.name AS attribute

FROM synonym s, feature_synonym fs

WHERE fs.feature_id= $1 AND fs.synonym_id = s.synonym_id

UNION

SELECT fp.feature_id,cv.name,fp.value

FROM featureprop fp, cvterm cv

WHERE fp.feature_id= $1 AND fp.type_id = cv.cvterm_id 

UNION

SELECT feature_id, 'pub' AS type, s.series_name || ':' || s.title AS attribute

FROM pub s, feature_pub fs

WHERE fs.feature_id= $1 AND fs.pub_id = s.pub_id