gff3atts

SELECT fs.feature_id,

    'Ontology_term'::text AS type,

        CASE

            WHEN ((db.name)::text ~~ '%Gene Ontology%'::text) THEN (('GO:'::text || (dbx.accession)::text))::character varying

            WHEN ((db.name)::text ~~ 'Sequence Ontology%'::text) THEN (('SO:'::text || (dbx.accession)::text))::character varying

            ELSE ((((db.name)::text || ':'::text) || (dbx.accession)::text))::character varying

        END AS attribute

   FROM cvterm s,

    dbxref dbx,

    feature_cvterm fs,

    db

  WHERE ((fs.cvterm_id = s.cvterm_id) AND (s.dbxref_id = dbx.dbxref_id) AND (db.db_id = dbx.db_id))

UNION ALL

 SELECT fs.feature_id,

    'Dbxref'::text AS type,

    (((d.name)::text || ':'::text) || (s.accession)::text) AS attribute

   FROM dbxref s,

    feature_dbxref fs,

    db d

  WHERE ((fs.dbxref_id = s.dbxref_id) AND (s.db_id = d.db_id) AND ((d.name)::text <> 'GFF_source'::text))

UNION ALL

 SELECT f.feature_id,

    'Alias'::text AS type,

    s.name AS attribute

   FROM synonym s,

    feature_synonym fs,

    feature f

  WHERE ((fs.synonym_id = s.synonym_id) AND (f.feature_id = fs.feature_id) AND ((f.name)::text <> (s.name)::text) AND (f.uniquename <> (s.name)::text))

UNION ALL

 SELECT fp.feature_id,

    cv.name AS type,

    fp.value AS attribute

   FROM featureprop fp,

    cvterm cv

  WHERE (fp.type_id = cv.cvterm_id)

UNION ALL

 SELECT fs.feature_id,

    'pub'::text AS type,

    (((s.series_name)::text || ':'::text) || s.title) AS attribute

   FROM pub s,

    feature_pub fs

  WHERE (fs.pub_id = s.pub_id)

UNION ALL

 SELECT fr.subject_id AS feature_id,

    'Parent'::text AS type,

    parent.uniquename AS attribute

   FROM feature_relationship fr,

    feature parent

  WHERE (fr.object_id = parent.feature_id)

UNION ALL

 SELECT feature.feature_id,

    'ID'::text AS type,

    feature.uniquename AS attribute

   FROM feature

  WHERE (NOT (feature.type_id IN ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'CDS'::text))))

UNION ALL

 SELECT feature.feature_id,

    'chado_feature_id'::text AS type,

    (feature.feature_id)::character varying AS attribute

   FROM feature

UNION ALL

 SELECT feature.feature_id,

    'Name'::text AS type,

    feature.name AS attribute

   FROM feature;