Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Sample Query of Google Genomics
# Count SNPs by type
SELECT
reference_bases,
alternate_bases AS allele,
COUNT(alternate_bases) AS num_snps
FROM
[google.com:biggene:1000genomes.variants1kG]
WHERE
vt ='SNP'
GROUP BY
reference_bases,
allele
ORDER BY
num_snps;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment