Skip to content

Instantly share code, notes, and snippets.

@kekeke29341

kekeke29341/Sample Query of Google Genomics

Created August 5, 2014 01:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kekeke29341/07bd5944c75438581b07 to your computer and use it in GitHub Desktop.
Save kekeke29341/07bd5944c75438581b07 to your computer and use it in GitHub Desktop.
Download ZIP
Sample Query of Google Genomics
Raw
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