traits

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

trait_id

int4

10

√

null

trait_name

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT cvterm.cvterm_id AS trait_id,
    (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text) AS trait_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 = 'trait_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_variable ON (((cvterm.cvterm_id = is_variable.subject_id) AND (is_variable.type_id = ( SELECT cvterm_1.cvterm_id
           FROM cvterm cvterm_1
          WHERE ((cvterm_1.name)::text = 'VARIABLE_OF'::text))))))
  WHERE (is_variable.subject_id IS NOT NULL)
  GROUP BY cvterm.cvterm_id, (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text)
UNION
 SELECT cvterm.cvterm_id AS trait_id,
    (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text) AS trait_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 = 'composed_trait_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)))
  WHERE (is_subject.subject_id IS NOT NULL)
  GROUP BY cvterm.cvterm_id, (((((cvterm.name)::text || '|'::text) || (db.name)::text) || ':'::text) || (dbxref.accession)::text)
  ORDER BY 2;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views