I am trying to get sample info from the public low-coverage 1000 genomes project data, which is stored in a bigquery table. I have followed the instructions here: https://support.terra.bio/hc/en-us/articles/360034954811-Accessing-and-analysing-custom-cohorts-with-Data-Explorer
exported the data to my own workspace, gone to the cohort table, select the (only) row, and triple-clicked the 'query' cell. a circular/spinning icon appears briefly and appears to be 'thinking' but nothing happens.
It appears that this is the query i want to run, but I am not sure how:
SELECT DISTINCT participant_id FROM (SELECT participant_id FROM `verily-public-data.human_genome_variants.1000_genomes_participant_info` UNION DISTINCT SELECT participant_id FROM `verily-public-data.human_genome_variants.1000_genomes_sample_info`)
Please sign in to leave a comment.