vcf

Identifier

dbsnp.vcf

Description

dbSNP variant catalog with genomic coordinates.

Always reflects the most recent build materialized from NCBI.

Use to look up rsIDs, validate variant positions, or cross-reference alleles.

One row per (assembly, rsid, chromosome, position, ref_allele, alt_allele) tuple — a single dbSNP variant record in one genome assembly.

Always filter on assembly.

Use rsid as the primary lookup key.

The build column records the dbSNP build used for the current snapshot.

Related tables: ukb_ppp.variants (join on rsid, chromosome, position); eqtlgen.variants (join on rsid, chromosome); eqtlgen.eqtls (join on rsid, chromosome); pan_ukbb.ld_variants (join on rsid, chromosome); pan_ukbb.ld_scores (join on rsid, chromosome).

Partitions

• build
  • 'b157'
• assembly
  • 'GRCh37'
  • 'GRCh38'
• chromosome
  • '1'
  • '10'
  • '11'
  • '12'
  • '13'
  • '14'
  • '15'
  • '16'
  • '17'
  • '18'
  • '19'
  • '2'
  • '20'
  • '21'
  • '22'
  • '3'
  • '4'
  • '5'
  • '6'
  • '7'
  • '8'
  • '9'
  • 'MT'
  • 'X'
  • 'Y'

Schema

Column	Type	Description
build	TEXT	Partition column. dbSNP build version (e.g. b157).
assembly	TEXT	Partition column. Genome assembly.
chromosome	TEXT	Partition column. Chromosome on which the variant is located.
position	INT	Variant position within the chromosome.
rsid	TEXT	Unique NCBI variant identifier (e.g. rs123456, rs7412).
ref_allele	TEXT	Reference allele.
alt_allele	TEXT	Alternate allele.