bigquery on 1000 genomes

snp.sql

SELECT
  reference_name,
  names,
  start,
  END,
  reference_bases,
  alt,
  sample_id,
  genotype from(
  SELECT
    reference_name,
    names,
    start,
    END,
    reference_bases,
    GROUP_CONCAT(alternate_bases) WITHIN RECORD AS alt,
    call.call_set_name AS sample_id,
    GROUP_CONCAT(STRING(call.genotype)) WITHIN call AS genotype
  FROM
    FLATTEN([genomics-public-data:1000_genomes.variants],names)
  WHERE
    names = 'rs13266634')
WHERE
  sample_id = "NA18525"