trait_components

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

trait_component_id

int4

10

√

null

trait_component_name

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

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;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views