1
SELECT trait_component.cvterm_id AS trait_component_id,
2
trialdesign.value AS trial_design_id
3
FROM ((((materialized_phenoview
4
JOIN cvterm trait ON ((materialized_phenoview.trait_id = trait.cvterm_id)))
5
JOIN cvterm_relationship ON (((trait.cvterm_id = cvterm_relationship.object_id) AND (cvterm_relationship.type_id = ( SELECT cvterm.cvterm_id
6
FROM cvterm
7
WHERE ((cvterm.name)::text = 'contains'::text))))))
8
JOIN cvterm trait_component ON ((cvterm_relationship.subject_id = trait_component.cvterm_id)))
9
JOIN projectprop trialdesign ON (((materialized_phenoview.trial_id = trialdesign.project_id) AND (trialdesign.type_id = ( SELECT cvterm.cvterm_id
10
FROM cvterm
11
WHERE ((cvterm.name)::text = 'design'::text))))))
12
GROUP BY trait_component.cvterm_id, trialdesign.value;