gff3view

SELECT f.feature_id,

    sf.name AS ref,

    gffdbx.accession AS source,

    cv.name AS type,

    (fl.fmin + 1) AS fstart,

    fl.fmax AS fend,

    af.significance AS score,

    fl.strand,

    fl.phase,

    f.seqlen,

    f.name,

    f.organism_id

   FROM (((((feature f

     LEFT JOIN featureloc fl ON ((f.feature_id = fl.feature_id)))

     LEFT JOIN feature sf ON ((fl.srcfeature_id = sf.feature_id)))

     LEFT JOIN ( SELECT fd.feature_id,

            d.accession

           FROM ((feature_dbxref fd

             JOIN dbxref d USING (dbxref_id))

             JOIN db USING (db_id))

          WHERE ((db.name)::text = 'GFF_source'::text)) gffdbx ON ((f.feature_id = gffdbx.feature_id)))

     LEFT JOIN cvterm cv ON ((f.type_id = cv.cvterm_id)))

     LEFT JOIN analysisfeature af ON ((f.feature_id = af.feature_id)));