extract data from bigquery table in terra
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`)
Comments
4 comments
Hi Haley,
The triple-click step is a hint for how to select the entirety of the cell's contents for copying (useful if the query is quite long). The query for that row is simply what BigQuery query for the data you selected in the Data Explorer.
Just so I'm clear on what you are looking for, you are trying to understand how to get access to the actual sample files, like bams, correct?
Kind regards,
Jason
Hi Haley,
Apologies for the delay on this; the message got caught in our spam filter. We've adjusted the settings to avoid this happening in the future.
Are you still experiencing this issue?
Kind regards,
Jason
Please sign in to leave a comment.