9 select uri as Experiment,
10 payload->>'accession' as Experiment_Accession,
11 payload->>'description' as Experiment_Description,
12 payload->>'status' as Experiment_Status,
13 payload->>'date_released' as Experiment_Released,
14 payload->>'lab' as Experiment_Lab,
15 jsonb_array_elements_text(payload->'replicates') as Replicate
17 where object_type = 'Experiment'
20 select uri as Replicate,
21 payload->>'library' as Library
23 where object_type = 'Replicate'
26 select uri as Library,
27 payload->>'accession' as Library_Accession,
28 payload->>'date_created' as Library_Created,
29 payload->>'biosample' as Biosample,
30 jsonb_array_elements_text(payload->'aliases') as Library_Alias
32 where object_type = 'Library'
35 select uri as Biosample,
36 payload->>'accession' as Biosample_Accession,
37 payload->>'date_created' as Biosample_Created,
38 payload->>'donor' as Donor
40 where object_type = 'Biosample'
42 select Experiment_Lab, Experiment_Status, count(Experiment_Accession)
44 LEFT JOIN replicate ON experiment.Replicate = replicate.Replicate
45 LEFT JOIN library on replicate.Library = library.Library
46 LEFT JOIN biosample on library.Biosample = biosample.Biosample
47 where biosample.Donor in ('/human-donors/ENCDO845WKR/','/human-donors/ENCDO451RUA/','/human-donors/ENCDO793LXB/','/human-donors/ENCDO271OUW/')
48 group by Experiment_Lab, Experiment_Status
49 -- order by experiment_released, experiment_status, experiment_accession