Explore how to query for large regions of deletions in NCI Cancer Data stored in BigQuery

[DavidPotCanuck]

For the FASP Hackathon ISB-CGC Bioinformaticians will create example BigQuery queries that identify in NCI public datasets deleted regions of chromosomes. Examples will be provided of these explorations.

[kabdilleh1]

ISB-CGC team notes from our hackathon exercise here: https://docs.google.com/document/d/1wzB-SDkCVaASYQN31QSG0lgnqt4GB1dVmf4kaAwcTW8/edit
We explore various ways to query ISB-CGC BigQuery tables to identify deleted regions from open-access cancer data. Here we show examples of the sql queries.