trait_components

SELECT cvterm.cvterm_id AS trait_component_id,

    (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text) AS trait_component_name

   FROM ((((((cv

     JOIN cvprop ON (((cv.cv_id = cvprop.cv_id) AND (cvprop.type_id IN ( SELECT cvterm_1.cvterm_id

           FROM cvterm cvterm_1

          WHERE ((cvterm_1.name)::text = ANY ('{object_ontology,attribute_ontology,method_ontology,unit_ontology,time_ontology}'::text[])))))))

     JOIN cvterm ON ((cvprop.cv_id = cvterm.cv_id)))

     JOIN dbxref USING (dbxref_id))

     JOIN db ON ((dbxref.db_id = db.db_id)))

     LEFT JOIN cvterm_relationship is_subject ON ((cvterm.cvterm_id = is_subject.subject_id)))

     LEFT JOIN cvterm_relationship is_object ON ((cvterm.cvterm_id = is_object.object_id)))

  WHERE ((is_object.object_id IS NULL) AND (is_subject.subject_id IS NOT NULL))

  GROUP BY (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text), cvterm.cvterm_id

  ORDER BY (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text), cvterm.cvterm_id;