Schema for dbSNP 155 - Short Genetic Variants from dbSNP release 155
  Database: hg38    Primary Table: dbSnp155Common Data last updated: 2022-05-22
Big Bed File: /gbdb/hg38/snp/dbSnp155Common.bb
Item Count: 15,162,080
Format description: Variant summary data extracted from dbSNP, 2019 and later
fieldexampledescription
chromchr1Reference sequence chromosome or scaffold
chromStart165970954Start position in chrom
chromEnd165970955End position in chrom
namers35625097dbSNP Reference SNP (rs) identifier
refGReference allele; usually major allele, but may be minor allele
altCount1Number of alternate alleles (usually 1)
altsA,Alternate (non-reference) alleles; may include major allele
shiftBases0Bases by which an indel placement could be shifted left or right (display shows thin line over uncertain region, shifts minimal representation right)
freqSourceCount31Number of projects reporting frequencies in current dbSNP build
minorAlleleFreq0.447883,0.478587,-inf,0.415353,0.334158,0.333333,-inf,-inf,-inf,0.385378,-inf,-inf,0.449525,-inf,-inf,-inf,0.420131,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,Minor allele frequency, i.e. second highest allele frequency, from each frequency source; NaN if no data from project
majorAlleleA,A,,G,A,A,,,,G,,,A,,,,G,,,,,,,,,,,,,,,Allele most frequently observed by each source
minorAlleleG,G,,A,G,G,,,,A,,,G,,,,A,,,,,,,,,,,,,,,Allele second most frequently observed by each source
maxFuncImpact0Sequence Ontology (SO) ID number for greatest functional impact on gene; 0 if no SO terms are annotated
classsnvVariation class/type
ucscNotesrefIsMinor,diffMajor,commonSome,commonAll,Interesting or anomalous properties noted by UCSC
_dataOffset138081374240Offset into bigDbSnpDetails file for line with more info
_dataLen454Length of line in bigDbSnpDetails

Sample Rows
 
chromchromStartchromEndnamerefaltCountaltsshiftBasesfreqSourceCountminorAlleleFreqmajorAlleleminorAllelemaxFuncImpactclassucscNotes_dataOffset_dataLen
chr1165970954165970955rs35625097G1A,0310.447883,0.478587,-inf,0.415353,0.334158,0.333333,-inf,-inf,-inf,0.385378,-inf,-inf,0.449525,-inf,-inf,-inf,0.420131,-inf,-inf,- ...A,A,,G,A,A,,,,G,,,A,,,,G,,,,,,,,,,,,,,,G,G,,A,G,G,,,,A,,,G,,,,A,,,,,,,,,,,,,,,0snvrefIsMinor,diffMajor,commonSome,commonAll,138081374240454
chr1165974092165974093rs199524624A1G,0310.389377,0.382814,-inf,0.427347,0.372832,0.453704,-inf,-inf,-inf,0.388179,-inf,0.45,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf ...A,A,,A,G,G,,,,A,,G,,,,,,,,,,,,,,,,,,,,G,G,,G,A,A,,,,G,,A,,,,,,,,,,,,,,,,,,,,0snvrefIsMinor,diffMajor,commonSome,commonAll,127051498100397
chr1165974173165974174rs546857179C2A,T,0310.0103834,0.00748256,-inf,0.000342231,0.5,0.00925926,-inf,-inf,-inf,0.000178998,-inf,-inf,1.73536e-05,-inf,-inf,-inf,0.000545852 ...C,C,,C,C,C,,,,C,,,C,,,,C,,,,,,,,,,,,,,,T,T,,T,T,T,,,,T,,,A,,,,T,,,,,,,,,,,,,,,0snvcommonSome,rareSome,145124164804358
chr1165974344165974345rs61836718G1C,0310.0866613,0.127051,0.123616,-inf,0.419355,0.0740741,0.116667,0.5,-inf,-inf,-inf,0.05,0.127674,0.0971944,0.122991,-inf,0.00054585 ...G,G,G,,C,G,G,G,,,,G,G,G,G,,G,,,,,,,,,,,,,,,C,C,C,,G,C,C,C,,,,C,C,C,C,,C,,,,,,,,,,,,,,,0snvrefIsMinor,diffMajor,commonSome,rareSome,153080071400511
chr1165974387165974388rs115014648T1C,0310.0251597,0.0185853,0.0244739,-inf,0.5,0.0185185,-inf,-inf,-inf,-inf,-inf,-inf,0.0233232,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf ...T,T,T,,T,T,,,,,,,T,,,,,,,,,,,,,,,,,,,C,C,C,,C,C,,,,,,,C,,,,,,,,,,,,,,,,,,,0snvcommonSome,commonAll,overlapDiffClass,11934102735320
chr1165974691165974692rs114133856A1T,0310.0101837,0.00790569,0.0118818,-inf,0.5,-inf,-inf,-inf,-inf,-inf,-inf,-inf,0.0110057,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-inf,-in ...A,A,A,,A,,,,,,,,A,,,,,,,,,,,,,,,,,,,T,T,T,,T,,,,,,,,T,,,,,,,,,,,,,,,,,,,0snvcommonSome,rareSome,11701905841289
chr1165974736165974749rs201868192CCTTCCTTCCTTC1CCTTCCTTC,9310.0255591,0.0134705,0.0221882,-inf,-inf,-inf,0.005,-inf,0.00296656,0.00727924,0.00259471,-inf,0.0164676,0.00200401,-inf,-inf,-in ...CCTTCCTTCCTTC,CCTTCCTTCCTTC,CCTTCCTTCCTTC,,,,CCTTCCTTCCTTC,,CCTTCCTTCCTTC,CCTTCCTTCCTTC,CCTTCCTTCCTTC,,CCTTCCTTCCTTC,CCTTCCTTCCT ...CCTTCCTTC,CCTTCCTTC,CCTTCCTTC,,,,CCTTCCTTC,,CCTTCCTTC,CCTTCCTTC,CCTTCCTTC,,CCTTCCTTC,CCTTCCTTC,,,,,,,,,,,,,,,,,,0delinscommonSome,rareSome,overlapDiffClass,127853515403598
chr1165974998165974999rs116457810C2G,T,0310.0191693,0.0161948,0.0396766,-inf,0.5,0.0324074,0.04,-inf,0.0652643,-inf,0.0718734,0.025,0.0451933,0.0691383,-inf,-inf,-inf,-in ...C,C,C,,C,C,C,,C,,C,C,C,C,,,,,,,,,,,,,,,,,,G,G,G,,G,G,G,,G,,G,G,G,G,,,,,,,,,,,,,,,,,,0snvcommonSome,commonAll,overlapDiffClass,13821455686467
chr1165975054165975055rs111063742A2C,T,0310.420927,0.273368,-inf,0.459358,0.367347,0.416667,0.405,0.366667,0.454962,0.396038,0.445771,0.425,-inf,0.473948,-inf,-inf,0.4524 ...A,A,,A,T,T,A,T,A,A,A,T,,A,,,A,,,,,,,,,,,,,,,T,T,,T,A,A,T,A,T,T,T,A,,T,,,T,,,,,,,,,,,,,,,0snvrefIsMinor,diffMajor,commonSome,commonAll,overlapDiffClass,10793740286655
chr1165975124165975125rs113402919C2A,T,0310.0157748,0.000304358,-inf,-inf,0.416667,0.0231481,-inf,-inf,0.000809061,-inf,0.00129735,-inf,-inf,0.001002,-inf,-inf,-inf,-inf, ...C,C,,,T,C,,,C,,C,,,C,,,,,,,,,,,,,,,,,,T,T,,,C,T,,,T,,T,,,T,,,,,,,,,,,,,,,,,,0snvrefIsMinor,diffMajor,commonSome,rareSome,overlapDiffClass,11490024662387

dbSNP 155 (dbSnp155Composite) Track Description
 

Description

This track shows short genetic variants (up to approximately 50 base pairs) from dbSNP build 155: single-nucleotide variants (SNVs), small insertions, deletions, and complex deletion/insertions (indels), relative to the reference genome assembly. Most variants in dbSNP are rare, not true polymorphisms, and some variants are known to be pathogenic.

For hg38 (GRCh38), approximately 998 million distinct variants (RefSNP clusters with rs# ids) have been mapped to more than 1.06 billion genomic locations including alternate haplotype and fix patch sequences. dbSNP remapped variants from hg38 to hg19 (GRCh37); approximately 981 million distinct variants were mapped to more than 1.02 billion genomic locations including alternate haplotype and fix patch sequences (not all of which are included in UCSC's hg19).

This track includes four subtracks of variants:

  • All dbSNP (155): the entire set (1.02 billion for hg19, 1.06 billion for hg38)
  • Common dbSNP (155): approximately 15 million variants with a minor allele frequency (MAF) of at least 1% (0.01) in the 1000 Genomes Phase 3 dataset. Variants in the Mult. subset (below) are excluded.
  • ClinVar dbSNP (155): approximately 820,000 variants mentioned in ClinVar. Note: that includes both benign and pathogenic (as well as uncertain) variants. Variants in the Mult. subset (below) are excluded.
  • Mult. dbSNP (155): variants that have been mapped to multiple chromosomes, for example chr1 and chr2, raising the question of whether the variant is really a variant or just a difference between duplicated sequences. There are some exceptions in which a variant is mapped to more than one reference sequence, but not culled into this set:
    • A variant may appear in both X and Y pseudo-autosomal regions (PARs) without being included in this set.
    • A variant may also appear in a main chromosome as well as an alternate haplotype or fix patch sequence assigned to that chromosome.

A fifth subtrack highlights coordinate ranges to which dbSNP mapped a variant but with genomic coordinates that are not internally consistent, i.e. different coordinate ranges were provided when describing different alleles. This can occur due to a bug with mapping variants from one assembly sequence to another when there is an indel difference between the assembly sequences:

  • Map Err (155): around 134,000 mappings of 88,000 distinct rsIDs for hg19 and 178,000 mappings of 108,000 distinct rsIDs for hg38.

Interpreting and Configuring the Graphical Display

SNVs and pure deletions are displayed as boxes covering the affected base(s). Pure insertions are drawn as single-pixel tickmarks between the base before and the base after the insertion.

Insertions and/or deletions in repetitive regions may be represented by a half-height box showing uncertainty in placement, followed by a full-height box showing the number of deleted bases, or a full-height tickmark to indicate an insertion. When an insertion or deletion falls in a repetitive region, the placement may be ambiguous. For example, if the reference genome contains "TAAAG" but some individuals have "TAAG" at the same location, then the variant is a deletion of a single A relative to the reference genome. However, which A was deleted? There is no way to tell whether the first, second or third A was removed. Different variant mapping tools may place the deletion at different bases in the reference genome. To reduce errors in merging variant calls made with different left vs. right biases, dbSNP made a major change in its representation of deletion/insertion variants in build 152. Now, instead of assigning a single-base genomic location at one of the A's, dbSNP expands the coordinates to encompass the whole repetitive region, so the variant is represented as a deletion of 3 A's combined with an insertion of 2 A's. In the track display, there will be a half-height box covering the first two A's, followed by a full-height box covering the third A, to show a net loss of one base but an uncertain placement within the three A's.

Variants are colored according to functional effect on genes annotated by dbSNP:

Protein-altering variants and splice site variants are red.
Synonymous codon variants are green.
Non-coding transcript or Untranslated Region (UTR) variants are blue.

On the track controls page, several variant properties can be included or excluded from the item labels: rs# identifier assigned by dbSNP, reference/alternate alleles, major/minor alleles (when available) and minor allele frequency (when available). Allele frequencies are reported independently by the project (some of which may have overlapping sets of samples):

  • 1000Genomes: The 1000 Genomes dataset contains data for 2,504 individuals from 26 populations.
  • dbGaP_PopFreq: The new source of dbGaP aggregated frequency data (>1 Million Subjects) provided by dbSNP.
  • TOPMED: The TOPMED dataset contains freeze 8 panel that includes about 158,000 individuals. The approximate ethnic breakdown is European(41%), African (31%), Hispanic or Latino (15%), East Asian (9%), and unknown (4%) ancestry.
  • KOREAN: The Korean Reference Genome Database contains data for 1,465 Korean individuals.
  • SGDP_PRJ: The Simons Genome Diversity Project dataset contains 263 C-panel fully public samples and 16 B-panel fully public samples for a total of 279 samples.
  • Qatari: The dataset contains initial mappings of the genomes of more than 1,000 Qatari nationals.
  • NorthernSweden: The dataset contains 300 whole-genome sequenced human samples from the county of Vasterbotten in northern Sweden.
  • Siberian: The dataset contains paired-end whole-genome sequencing data of 28 modern-day humans from Siberia and Western Russia.
  • TWINSUK: The UK10K - TwinsUK project contains 1854 samples from the Department of Twin Research and Genetic Epidemiology (DTR). The dataset contains data obtained from the 11,000 identical and non-identical twins between the ages of 16 and 85 years old.
  • TOMMO: The Tohoku Medical Megabank Project contains an allele frequency panel of 3552 Japanese individuals, including the X chromosome.
  • ALSPAC: The UK10K - Avon Longitudinal Study of Parents and Children project contains 1927 sample including individuals obtained from the ALSPAC population. This population contains more than 14,000 mothers enrolled during pregnancy in 1991 and 1992.
  • GENOME_DK: The dataset contains the sequencing of Danish parent-offspring trios to determine genomic variation within the Danish population.
  • GnomAD: The gnomAD genome dataset includes a catalog containing 602M SNVs and 105M indels based on the whole-genome sequencing of 71,702 samples mapped to the GRCh38 build of the human reference genome.
  • GoNL: The Genome of the Netherlands (GoNL) Project characterizes DNA sequence variation, common and rare, for SNVs and short insertions and deletions (indels) and large deletions in 769 individuals of Dutch ancestry selected from five biobanks under the auspices of the Dutch hub of the Biobanking and Biomolecular Research Infrastructure (BBMRI-NL).
  • Estonian: The dataset contains genetic variation in the Estonian population: pharmacogenomics study of adverse drug effects using electronic health records.
  • Vietnamese: The Kinh Vietnamese database contains 24.81 million variants (22.47 million single nucleotide polymorphisms (SNPs) and 2.34 million indels), of which 0.71 million variants are novel.
  • Korea1K: The dataset contains 1,094 Korean personal genomes with clinical information.
  • HapMap: (HapMap is being retired.) The International HapMap Project contains samples from African, Asian, or European populations.
  • PRJEB36033: The dataset contains ancient Sardinia genome-wide 1240k capture data from 70 ancient Sardinians.
  • HGDP_Stanford: The Stanford HGDP SNP genotyping data consists of ~660,918 tag SNPs in autosomes, chromosome X and Y, the pseudoautosomal region, and mitochondrial DNA, typed across 1043 individuals from all panel populations.
  • Daghestan: The dataset contains genotypes of >550 000 autosomal single-nucleotide polymorphisms (SNPs) in a set of 14 population isolates speaking Nakh-Daghestanian (ND) languages.
  • PAGE_STUDY: The PAGE Study: How Genetic Diversity Improves Our Understanding of the Architecture of Complex Traits.
  • Chileans: The dataset consists of genetic variation on the Chileans using genotype data on ~685,944 SNPs from 313 individuals across the whole-continental country.
  • MGP: MGP contains aggregated information on 267 healthy individuals, representative of the Spanish population that were used as controls in the MGP (Medical Genome Project).
  • PRJEB37584: The dataset contains genome-wide genotype analysis that identified copy number variations in cranial meningiomas in Chinese patients, and demonstrated diverse CNV burdens among individuals with diverse clinical features.
  • GoESP: The NHLBI Grand Opportunity Exome Sequencing Project (GO-ESP) dataset contains 6503 samples drawn from multiple ESP cohorts and represents all of the ESP exome variant data.
  • ExAC: The Exome Aggregation Consortium (ExAC) dataset contains 60,706 unrelated individuals sequenced as part of various disease-specific and population genetic studies. Individuals affected by severe pediatric disease have been removed.
  • GnomAD_exomes: The gnomAD v2.1 exome dataset comprises a total of 16 million SNVs and 1.2 million indels from 125,748 exomes in 14 populations.
  • FINRISK: The FINRISK cohorts comprise the respondents of representative, cross-sectional population surveys that are carried out every 5 years since 1972, to assess the risk factors of chronic diseases (e.g. CVD, diabetes, obesity, cancer) and health behavior in the working age population.
  • PharmGKB: The dataset contains aggregated frequency data for all PharmGKB submissions.
  • PRJEB37766: The Mexican Genomic Database for Addiction Research.
The project from which to take allele frequency data defaults to 1000 Genomes but can be set to any of those projects.

Using the track controls, variants can be filtered by

  • minimum minor allele frequency (MAF)
  • variation class/type (e.g. SNV, insertion, deletion)
  • functional effect on a gene (e.g. synonymous, frameshift, intron, upstream)
  • assorted features and anomalies noted by UCSC during processing of dbSNP's data

Interesting and anomalous conditions noted by UCSC

While processing the information downloaded from dbSNP, UCSC annotates some properties of interest. These are noted on the item details page, and may be useful to include or exclude affected variants.

Some are purely informational:

keyword in data file (dbSnp155.bb) # in hg19# in hg38description
clinvar 627817 630503 Variant is in ClinVar.
clinvarBenign 275541 276409 Variant is in ClinVar with clinical significance of benign and/or likely benign.
clinvarConflicting 16925 16834 Variant is in ClinVar with reports of both benign and pathogenic significance.
clinvarPathogenic 56373 56475 Variant is in ClinVar with clinical significance of pathogenic and/or likely pathogenic.
commonAll 14904503 15862783 Variant is "common", i.e. has a Minor Allele Frequency of at least 1% in all projects reporting frequencies.
commonSome 59633864 62095091 Variant is "common", i.e. has a Minor Allele Frequency of at least 1% in some, but not all, projects reporting frequencies.
diffMajor 12748733 13073288 Different frequency sources have different major alleles.
overlapDiffClass 198945442 207101421 This variant overlaps another variant with a different type/class.
overlapSameClass 29281958 30301090 This variant overlaps another with the same type/class but different start/end.
rareAll 906113910 938985356 Variant is "rare", i.e. has a Minor Allele Frequency of less than 1% in all projects reporting frequencies, or has no frequency data.
rareSome 950843271 985217664 Variant is "rare", i.e. has a Minor Allele Frequency of less than 1% in some, but not all, projects reporting frequencies, or has no frequency data.
revStrand 5540864 6770772 Alleles are displayed on the + strand at the current position. dbSNP's alleles are displayed on the + strand of a different assembly sequence, so dbSNP's variant page shows alleles that are reverse-complemented with respect to the alleles displayed above.

while others may indicate that the reference genome contains a rare variant or sequencing issue:

keyword in data file (dbSnp155.bb) # in hg19# in hg38description
refIsAmbiguous 19 41 The reference genome allele contains an IUPAC ambiguous base (e.g. 'R' for 'A or G', or 'N' for 'any base').
refIsMinor 14950212 15386394 The reference genome allele is not the major allele in at least one project.
refIsRare 793081 822757 The reference genome allele is rare (i.e. allele frequency < 1%).
refIsSingleton 694310 712794 The reference genome allele has never been observed in a population sequencing project reporting frequencies.
refMismatch 1 18 The reference genome allele reported by dbSNP differs from the GenBank assembly sequence. This is very rare and in all cases observed so far, the GenBank assembly has an 'N' while the RefSeq assembly used by dbSNP has a less ambiguous character such as 'R'.

and others may indicate an anomaly or problem with the variant data:

keyword in data file (dbSnp155.bb) # in hg19# in hg38description
altIsAmbiguous 5294 5361 At least one alternate allele contains an IUPAC ambiguous base (e.g. 'R' for 'A or G'). For alleles containing more than one ambiguous base, this may create a combinatoric explosion of possible alleles.
classMismatch 13289 18475 Variation class/type is inconsistent with alleles mapped to this genome assembly.
clusterError 373258 459130 This variant has the same start, end and class as another variant; they probably should have been merged into one variant.
freqIncomplete 0 0 At least one project reported counts for only one allele which implies that at least one allele is missing from the report; that project's frequency data are ignored.
freqIsAmbiguous 4332 4399 At least one allele reported by at least one project that reports frequencies contains an IUPAC ambiguous base.
freqNotMapped 1149972 1141935 At least one project reported allele frequencies relative to a different assembly; However, dbSNP does not include a mapping of this variant to that assembly, which implies a problem with mapping the variant across assemblies. The mapping on this assembly may have an issue; evaluate carefully vs. original submissions, which you can view by clicking through to dbSNP above.
freqNotRefAlt 74139 110646 At least one allele reported by at least one project that reports frequencies does not match any of the reference or alternate alleles listed by dbSNP.
multiMap 799777 286666 This variant has been mapped to more than one distinct genomic location.
otherMapErr 91260 195051 At least one other mapping of this variant has erroneous coordinates. The mapping(s) with erroneous coordinates are excluded from this track and are included in the Map Err subtrack. Sometimes despite this mapping having legal coordinates, there may still be an issue with this mapping's coordinates and alleles; you may want to click through to dbSNP to compare the initial submission's coordinates and alleles. In hg19, 55454 distinct rsIDs are affected; in hg38, 86636.

Data Sources and Methods

dbSNP has collected genetic variant reports from researchers worldwide for more than 20 years. Since the advent of next-generation sequencing methods and the population sequencing efforts that they enable, dbSNP has grown exponentially, requiring a new data schema, computational pipeline, web infrastructure, and download files. (Holmes et al.) The same challenges of exponential growth affected UCSC's presentation of dbSNP variants, so we have taken the opportunity to change our internal representation and import pipeline. Most notably, flanking sequences are no longer provided by dbSNP, because most submissions have been genomic variant calls in VCF format as opposed to independent sequences.

We downloaded JSON files available from dbSNP at http://ftp.ncbi.nlm.nih.gov/snp/archive/b155/JSON/, extracted a subset of the information about each variant, and collated it into a bigBed file using the bigDbSnp.as schema with the information necessary for filtering and displaying the variants, as well as a separate file containing more detailed information to be displayed on each variant's details page (dbSnpDetails.as schema).

Data Access

Note: It is not recommeneded to use LiftOver to convert SNPs between assemblies, and more information about how to convert SNPs between assemblies can be found on the following FAQ entry.

Since dbSNP has grown to include over 1 billion variants, the size of the All dbSNP (155) subtrack can cause the Table Browser and Data Integrator to time out, leading to a blank page or truncated output, unless queries are restricted to a chromosomal region, to particular defined regions, to a specific set of rs# IDs (which can be pasted/uploaded into the Table Browser), or to one of the subset tracks such as Common (~15 million variants) or ClinVar (~0.8M variants).

For automated analysis, the track data files can be downloaded from the downloads server for hg19 and hg38.

file format subtrack
dbSnp155.bb hg19 hg38 bigDbSnp (bigBed4+13) All dbSNP (155)
dbSnp155ClinVar.bb hg19 hg38 bigDbSnp (bigBed4+13) ClinVar dbSNP (155)
dbSnp155Common.bb hg19 hg38 bigDbSnp (bigBed4+13) Common dbSNP (155)
dbSnp155Mult.bb hg19 hg38 bigDbSnp (bigBed4+13) Mult. dbSNP (155)
dbSnp155BadCoords.bb hg19 hg38 bigBed4 Map Err (155)
dbSnp155Details.tab.gz gzip-compressed tab-separated text Detailed variant properties, independent of genome assembly version

Several utilities for working with bigBed-formatted binary files can be downloaded here. Run a utility with no arguments to see a brief description of the utility and its options.

  • bigBedInfo provides summary statistics about a bigBed file including the number of items in the file. With the -as option, the output includes an autoSql definition of data columns, useful for interpreting the column values.
  • bigBedToBed converts the binary bigBed data to tab-separated text. Output can be restricted to a particular region by using the -chrom, -start and -end options.
  • bigBedNamedItems extracts rows for one or more rs# IDs.

Example: retrieve all variants in the region chr1:200001-200400

bigBedToBed http://hgdownload.soe.ucsc.edu/gbdb/hg38/snp/dbSnp155.bb -chrom=chr1 -start=200000 -end=200400 stdout

Example: retrieve variant rs6657048

bigBedNamedItems dbSnp155.bb rs6657048 stdout

Example: retrieve all variants with rs# IDs in file myIds.txt

bigBedNamedItems -nameFile dbSnp155.bb myIds.txt dbSnp155.myIds.bed

The columns in the bigDbSnp/bigBed files and dbSnp155Details.tab.gz file are described in bigDbSnp.as and dbSnpDetails.as respectively. For columns that contain lists of allele frequency data, the order of projects providing the data listed is as follows:

  1. 1000Genomes
  2. dbGaP_PopFreq
  3. TOPMED
  4. KOREAN
  5. SGDP_PRJ
  6. Qatari
  7. NorthernSweden
  8. Siberian
  9. TWINSUK
  10. TOMMO
  11. ALSPAC
  12. GENOME_DK
  13. GnomAD
  14. GoNL
  15. Estonian
  16. Vietnamese
  17. Korea1K
  18. HapMap
  19. PRJEB36033
  20. HGDP_Stanford
  21. Daghestan
  22. PAGE_STUDY
  23. Chileans
  24. MGP
  25. PRJEB37584
  26. GoESP
  27. ExAC
  28. GnomAD_exomes
  29. FINRISK
  30. PharmGKB
  31. PRJEB37766

UCSC also has an API that can be used to retrieve values from a particular chromosome range.

A list of rs# IDs can be pasted/uploaded in the Variant Annotation Integrator tool to find out which genes (if any) the variants are located in, as well as functional effect such as intron, coding-synonymous, missense, frameshift, etc.

Please refer to our searchable mailing list archives for more questions and example queries, or our Data Access FAQ for more information.

References

Holmes JB, Moyer E, Phan L, Maglott D, Kattman B. SPDI: Data Model for Variants and Applications at NCBI. Bioinformatics. 2019 Nov 18;. PMID: 31738401

Sayers EW, Agarwala R, Bolton EE, Brister JR, Canese K, Clark K, Connor R, Fiorini N, Funk K, Hefferon T et al. Database resources of the National Center for Biotechnology Information. Nucleic Acids Res. 2019 Jan 8;47(D1):D23-D28. PMID: 30395293; PMC: PMC6323993

Sherry ST, Ward MH, Kholodov M, Baker J, Phan L, Smigielski EM, Sirotkin K. dbSNP: the NCBI database of genetic variation. Nucleic Acids Res. 2001 Jan 1;29(1):308-11. PMID: 11125122; PMC: PMC29783