Schema for dbSNP 155 - Short Genetic Variants from dbSNP release 155
Database: hg38 Primary Table: dbSnp155Common Data last updated: 2023-03-27|
Big Bed File Download: /gbdb/hg38/snp/dbSnp155Common.bb
Item Count: 15,162,080
Format description: Variant summary data extracted from dbSNP, 2019 and later
|chrom||chr1||Reference sequence chromosome or scaffold|
|chromStart||165970954||Start position in chrom|
|chromEnd||165970955||End position in chrom|
|name||rs35625097||dbSNP Reference SNP (rs) identifier|
|ref||G||Reference allele; usually major allele, but may be minor allele|
|altCount||1||Number of alternate alleles (usually 1)|
|alts||A,||Alternate (non-reference) alleles; may include major allele|
|shiftBases||0||Bases by which an indel placement could be shifted left or right (display shows thin line over uncertain region, shifts minimal representation right)|
|freqSourceCount||31||Number of projects reporting frequencies in current dbSNP build|
|minorAlleleFreq||0.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|
|majorAllele||A,A,,G,A,A,,,,G,,,A,,,,G,,,,,,,,,,,,,,,||Allele most frequently observed by each source|
|minorAllele||G,G,,A,G,G,,,,A,,,G,,,,A,,,,,,,,,,,,,,,||Allele second most frequently observed by each source|
|maxFuncImpact||0||Sequence Ontology (SO) ID number for greatest functional impact on gene; 0 if no SO terms are annotated|
|ucscNotes||refIsMinor,diffMajor,commonSome,commonAll,||Interesting or anomalous properties noted by UCSC|
|_dataOffset||138081374548||Offset into bigDbSnpDetails file for line with more info|
|_dataLen||454||Length of line in bigDbSnpDetails|
|chr1||165974736||165974749||rs201868192||CCTTCCTTCCTTC||1||CCTTCCTTC,||9||31||0.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,,,,,,,,,,,,,,,,,,||0||delins||commonSome,rareSome,overlapDiffClass,||127853515627||598|
dbSNP 155 (dbSnp155Composite) Track Description
This track shows short genetic variants
(up to approximately 50 base pairs) from
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
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
Synonymous codon variants are
Non-coding transcript or Untranslated Region (UTR) variants are
On the track controls page, several variant properties can be included or excluded from
the item labels:
rs# identifier assigned by dbSNP,
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):
The 1000 Genomes dataset contains data for 2,504 individuals from 26 populations.
The new source of dbGaP aggregated frequency data (>1 Million Subjects) provided by dbSNP.
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.
The Korean Reference Genome Database contains data for 1,465 Korean individuals.
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.
The dataset contains initial mappings of the genomes of more than 1,000 Qatari nationals.
The dataset contains 300 whole-genome sequenced human samples from the county of Vasterbotten in
The dataset contains paired-end whole-genome sequencing data of 28 modern-day humans from Siberia
and Western Russia.
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.
The Tohoku Medical Megabank Project contains an allele frequency panel of 3552 Japanese individuals,
including the X chromosome.
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.
The dataset contains the sequencing of Danish parent-offspring trios to determine genomic variation
within the Danish population.
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.
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).
The dataset contains genetic variation in the Estonian population: pharmacogenomics study of adverse
drug effects using electronic health records.
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.
The dataset contains 1,094 Korean personal genomes with clinical information.
(HapMap is being retired.) The International HapMap Project contains samples from African, Asian,
or European populations.
The dataset contains ancient Sardinia genome-wide 1240k capture data from 70 ancient Sardinians.
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
The dataset contains genotypes of >550 000 autosomal single-nucleotide polymorphisms (SNPs) in a
set of 14 population isolates speaking Nakh-Daghestanian (ND) languages.
The PAGE Study: How Genetic Diversity Improves Our Understanding of the Architecture of Complex Traits.
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 contains aggregated information on 267 healthy individuals, representative of the Spanish population that were used as controls in the MGP (Medical Genome Project).
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.
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.
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.
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.
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.
The dataset contains aggregated frequency data for all PharmGKB submissions.
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 hg38||description|
||Variant is in ClinVar.
||Variant is in ClinVar with clinical significance of benign and/or likely benign.
||Variant is in ClinVar with reports of both benign and pathogenic significance.
||Variant is in ClinVar with clinical significance of pathogenic and/or likely pathogenic.
||Variant is "common", i.e. has a Minor Allele Frequency of at least 1% in all projects reporting frequencies.
||Variant is "common", i.e. has a Minor Allele Frequency of at least 1% in some, but not all, projects reporting frequencies.
||Different frequency sources have different major alleles.
||This variant overlaps another variant with a different type/class.
||This variant overlaps another with the same type/class but different start/end.
||Variant is "rare", i.e. has a Minor Allele Frequency of less than 1% in all projects reporting frequencies, or has no frequency data.
||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.
||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 hg38||description|
||The reference genome allele contains an IUPAC ambiguous base (e.g. 'R' for 'A or G', or 'N' for 'any base').
||The reference genome allele is not the major allele in at least one project.
||The reference genome allele is rare (i.e. allele frequency < 1%).
||The reference genome allele has never been observed in a population sequencing project reporting frequencies.
||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 hg38||description|
||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.
||Variation class/type is inconsistent with alleles mapped to this genome assembly.
||This variant has the same start, end and class as another variant; they probably should have been merged into one variant.
||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.
||At least one allele reported by at least one project that reports frequencies contains an IUPAC ambiguous base.
||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.
||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.
||This variant has been mapped to more than one distinct genomic location.
||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
We downloaded JSON files available from dbSNP at
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
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
Since dbSNP has grown to include over 1 billion variants, the size of the All dbSNP (155)
subtrack can cause the
Table Browser and
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
||All dbSNP (155)
||ClinVar dbSNP (155)
||Common dbSNP (155)
||Mult. dbSNP (155)
||Map Err (155)
||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
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
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
For columns that contain lists of allele frequency data, the order of projects
providing the data listed is as follows:
The functional effect (maxFuncImpact) for each variant contains the
ID for the greatest functional impact on the gene. This field
contains a 0 when no SO terms are annotated on the variant.
UCSC also has an
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.
Holmes JB, Moyer E, Phan L, Maglott D, Kattman B.
SPDI: Data Model for Variants and Applications at NCBI.
Bioinformatics. 2019 Nov 18;.
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.