2 biosample(uri, payload, parent_of, part_of, d) as (
4 jsonb_array_elements_text(payload->'parent_of') as parent_of,
5 payload->>'part_of' as part_of,
8 where object_type = 'Biosample'
10 select child.uri, child.payload,
11 jsonb_array_elements_text(child.payload->'parent_of') as parent_of,
12 child.payload->>'part_of' as part_of,
14 from biosample, item child
15 where biosample.uri = child.payload->>'part_of'
17 select part_of, uri, parent_of, d