1
SELECT materialized_genoview.genotyping_project_id,
2
trait_component.cvterm_id AS trait_component_id
3
FROM ((((materialized_genoview
4
JOIN materialized_phenoview USING (accession_id))
5
JOIN cvterm trait ON ((materialized_phenoview.trait_id = trait.cvterm_id)))
6
JOIN cvterm_relationship ON (((trait.cvterm_id = cvterm_relationship.object_id) AND (cvterm_relationship.type_id = ( SELECT cvterm.cvterm_id
7
FROM cvterm
8
WHERE ((cvterm.name)::text = 'contains'::text))))))
9
JOIN cvterm trait_component ON ((cvterm_relationship.subject_id = trait_component.cvterm_id)))
10
GROUP BY materialized_genoview.genotyping_project_id, trait_component.cvterm_id;