Schema for Mult. SNPs(147) - Simple Nucleotide Polymorphisms (dbSNP 147) That Map to Multiple Genomic Loci
Database: hg38 Primary Table: snp147Mult Row Count: 107   Data last updated: 2016-07-30|
Format description: Polymorphism data from dbSNP
|field||example||SQL type ||info ||description |
|bin ||1539||smallint(5) unsigned ||range ||Indexing field to speed chromosome range queries.|
|chrom ||chr1||varchar(31) ||values ||Reference sequence chromosome or scaffold|
|chromStart ||125119086||int(10) unsigned ||range ||Start position in chrom|
|chromEnd ||125119087||int(10) unsigned ||range ||End position in chrom|
|name ||rs78552787||varchar(15) ||values ||dbSNP Reference SNP (rs) identifier|
|score ||0||smallint(5) unsigned ||range ||Not used|
|strand ||+||enum('+', '-') ||values ||Which DNA strand contains the observed alleles|
|refNCBI ||C||blob ||values ||Reference genomic sequence from dbSNP|
|refUCSC ||C||blob ||values ||Reference genomic sequence from UCSC lookup of chrom,chromStart,chromEnd|
|observed ||C/G||varchar(255) ||values ||The sequences of the observed alleles from rs-fasta files|
|molType ||genomic||enum('unknown', 'genomic', 'cDNA') ||values ||Sample type from exemplar submitted SNPs (ss)|
|class ||single||enum('single', 'in-del', 'microsatellite', 'named', 'mnp', 'insertion', 'deletion') ||values ||Class of variant (single, in-del, named, mixed, etc.)|
|valid ||unknown||set('unknown', 'by-cluster', 'by-frequency', 'by-submitter', 'by-2hit-2allele', 'by-hapmap', 'by-1000genomes') ||values ||Validation status of the SNP|
|avHet ||0.5||float ||range ||Average heterozygosity from all observations. Note: may be computed on small number of samples.|
|avHetSE ||0||float ||range ||Standard Error for the average heterozygosity|
|func ||unknown||set('unknown', 'coding-synon', 'intron', 'near-gene-3', 'near-gene-5', 'ncRNA', 'nonsense', 'missense', 'stop-loss', 'frameshift', 'cds-indel', 'untranslated-3', 'untranslated-5', 'splice-3', 'splice-5') ||values ||Functional category of the SNP (coding-synon, coding-nonsynon, intron, etc.)|
|locType ||exact||enum('range', 'exact', 'between', 'rangeInsertion', 'rangeSubstitution', 'rangeDeletion', 'fuzzy') ||values ||Type of mapping inferred from size on reference; may not agree with class|
|weight ||1||int(10) unsigned ||range ||The quality of the alignment: 1 = unique mapping, 2 = non-unique, 3 = many matches|
|exceptions ||MultipleAlignments||set('RefAlleleMismatch', 'DuplicateObserved', 'MixedObserved', 'FlankMismatchGenomeLonger', 'FlankMismatchGenomeEqual', 'FlankMismatchGenomeShorter', 'SingleClassLongerSpan', 'SingleClassZeroSpan', 'SingleClassTriAllelic', 'SingleClassQuadAllelic', 'ObservedWrongFormat', 'ObservedTooLong', 'ObservedContainsIupac', 'ObservedMismatch', 'MultipleAlignments', 'NonIntegerChromCount', 'AlleleFreqSumNot1', 'SingleAlleleFreq', 'InconsistentAlleles') ||values ||Unusual conditions noted by UCSC that may indicate a problem with the data|
|submitterCount ||1||smallint(5) unsigned ||range ||Number of distinct submitter handles for submitted SNPs for this ref SNP|
|submitters ||ENSEMBL,||longblob || ||List of submitter handles|
|alleleFreqCount ||2||smallint(5) unsigned ||range ||Number of observed alleles with frequency data|
|alleles ||C,G,||longblob || ||Observed alleles for which frequency data are available|
|alleleNs ||1.000000,1.000000,||longblob || ||Count of chromosomes (2N) on which each allele was observed. Note: this is extrapolated by dbSNP from submitted frequencies and total sample 2N, and is not always an integer.|
|alleleFreqs ||0.500000,0.500000,||longblob || ||Allele frequencies|
|bitfields || ||set('clinically-assoc', 'maf-5-some-pop', 'maf-5-all-pops', 'has-omim-omia', 'microattr-tpa', 'submitted-by-lsdb', 'genotype-conflict', 'rs-cluster-nonoverlapping-alleles', 'observed-mismatch') ||values ||SNP attributes extracted from dbSNP's SNP_bitfield table|
Connected Tables and Joining Fields
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
Mult. SNPs(147) (snp147Mult) Track Description
This track contains information about a subset of the
single nucleotide polymorphisms
and small insertions and deletions (indels) — collectively Simple
Nucleotide Polymorphisms — from
build 147, available from
Only SNPs that have been mapped to multiple locations in the reference
genome assembly are included in this subset. When a SNP's flanking sequences
map to multiple locations in the reference genome, it calls into question
whether there is true variation at those sites, or whether the sequences
at those sites are merely highly similar but not identical.
The default maximum weight for this track is 3,
unlike the other dbSNP build 147 tracks which have a maximum weight of 1.
That enables these multiply-mapped SNPs to appear in the display, while
by default they will not appear in the All SNPs(147) track because of its
maximum weight filter.
The remainder of this page is identical on the following tracks:
- Common SNPs(147) - SNPs with >= 1% minor allele frequency (MAF), mapping
only once to reference assembly.
- Flagged SNPs(147) - SNPs < 1% minor allele frequency (MAF) (or unknown),
mapping only once to reference assembly,
flagged in dbSnp as "clinically associated"
-- not necessarily a risk allele!
- Mult. SNPs(147) - SNPs mapping in more than one place on reference assembly.
- All SNPs(147) - all SNPs from dbSNP mapping to reference assembly.
Interpreting and Configuring the Graphical Display
Variants are shown as single tick marks at most zoom levels.
When viewing the track at or near base-level resolution, the displayed
width of the SNP corresponds to the width of the variant in the reference
sequence. Insertions are indicated by a single tick mark displayed between
two nucleotides, single nucleotide polymorphisms are displayed as the width
of a single base, and multiple nucleotide variants are represented by a
block that spans two or more bases.
On the track controls page, SNPs can be colored and/or filtered from the
display according to several attributes:
Class: Describes the observed alleles
- Single - single nucleotide variation: all observed alleles are single nucleotides
(can have 2, 3 or 4 alleles)
- In-del - insertion/deletion
- Heterozygous - heterozygous (undetermined) variation: allele contains string '(heterozygous)'
- Microsatellite - the observed allele from dbSNP is a variation in counts of short tandem repeats
- Named - the observed allele from dbSNP is given as a text name instead of raw sequence, e.g., (Alu)/-
- No Variation - the submission reports an invariant region in the surveyed sequence
- Mixed - the cluster contains submissions from multiple classes
- Multiple Nucleotide Polymorphism (MNP) - the alleles are all of the same length, and length > 1
- Insertion - the polymorphism is an insertion relative to the reference assembly
- Deletion - the polymorphism is a deletion relative to the reference assembly
- Unknown - no classification provided by data contributor
Validation: Method used to validate
the variant (each variant may be validated by more than one method)
- By Frequency - at least one submitted SNP in cluster has frequency data submitted
- By Cluster - cluster has at least 2 submissions, with at least one submission assayed with a non-computational method
- By Submitter - at least one submitter SNP in cluster was validated by independent assay
- By 2 Hit/2 Allele - all alleles have been observed in at least 2 chromosomes
- By HapMap (human only) - submitted by HapMap project
- By 1000Genomes (human only) - submitted by
- Unknown - no validation has been reported for this variant
Function: dbSNP's predicted functional effect of variant on RefSeq transcripts,
both curated (NM_* and NR_*) as in the RefSeq Genes track and predicted (XM_* and XR_*),
not shown in UCSC Genome Browser.
A variant may have more than one functional role if it overlaps
These terms and definitions are from the Sequence Ontology (SO); click on a term to view it in the
MISO Sequence Ontology Browser.
In the Coloring Options section of the track controls page,
function terms are grouped into several categories, shown here with default colors:
(nc_transcript_variant) are always colored blue.
- Unknown - no functional classification provided (possibly intergenic)
- synonymous_variant -
A sequence variant where there is no resulting change to the encoded amino acid
(dbSNP term: coding-synon)
- intron_variant -
A transcript variant occurring within an intron
(dbSNP term: intron)
- downstream_gene_variant -
A sequence variant located 3' of a gene
(dbSNP term: near-gene-3)
- upstream_gene_variant -
A sequence variant located 5' of a gene
(dbSNP term: near-gene-5)
- nc_transcript_variant -
A transcript variant of a non coding RNA gene
(dbSNP term: ncRNA)
- stop_gained -
A sequence variant whereby at least one base of a codon is changed, resulting in
a premature stop codon, leading to a shortened transcript
(dbSNP term: nonsense)
- missense_variant -
A sequence variant, where the change may be longer than 3 bases, and at least
one base of a codon is changed resulting in a codon that encodes for a
different amino acid
(dbSNP term: missense)
- stop_lost -
A sequence variant where at least one base of the terminator codon (stop)
is changed, resulting in an elongated transcript
(dbSNP term: stop-loss)
- frameshift_variant -
A sequence variant which causes a disruption of the translational reading frame,
because the number of nucleotides inserted or deleted is not a multiple of three
(dbSNP term: frameshift)
- inframe_indel -
A coding sequence variant where the change does not alter the frame
of the transcript
(dbSNP term: cds-indel)
- 3_prime_UTR_variant -
A UTR variant of the 3' UTR
(dbSNP term: untranslated-3)
- 5_prime_UTR_variant -
A UTR variant of the 5' UTR
(dbSNP term: untranslated-5)
- splice_acceptor_variant -
A splice variant that changes the 2 base region at the 3' end of an intron
(dbSNP term: splice-3)
- splice_donor_variant -
A splice variant that changes the 2 base region at the 5' end of an intron
(dbSNP term: splice-5)
Molecule Type: Sample used to find this variant
- Genomic - variant discovered using a genomic template
- cDNA - variant discovered using a cDNA template
- Unknown - sample type not known
Unusual Conditions (UCSC): UCSC checks for several anomalies
that may indicate a problem with the mapping, and reports them in the
Annotations section of the SNP details page if found:
Another condition, which does not necessarily imply any problem,
- AlleleFreqSumNot1 - Allele frequencies do not sum
to 1.0 (+-0.01). This SNP's allele frequency data are
MixedObserved - Multiple distinct insertion SNPs have
been mapped to this location, with either the same inserted
sequence (Duplicate) or different inserted sequence (Mixed).
FlankMismatchGenomeShorter - NCBI's alignment of
the flanking sequences had at least one mismatch or gap
near the mapped SNP position.
(UCSC's re-alignment of flanking sequences to the genome may
- MultipleAlignments - This SNP's flanking sequences
align to more than one location in the reference assembly.
- NamedDeletionZeroSpan - A deletion (from the
genome) was observed but the annotation spans 0 bases.
(UCSC's re-alignment of flanking sequences to the genome may
- NamedInsertionNonzeroSpan - An insertion (into the
genome) was observed but the annotation spans more than 0
bases. (UCSC's re-alignment of flanking sequences to the
genome may be informative.)
- NonIntegerChromCount - At least one allele
frequency corresponds to a non-integer (+-0.010000) count of
chromosomes on which the allele was observed. The reported
total sample count for this SNP is probably incorrect.
- ObservedContainsIupac - At least one observed allele
from dbSNP contains an IUPAC ambiguous base (e.g., R, Y, N).
- ObservedMismatch - UCSC reference allele does not
match any observed allele from dbSNP. This is tested only
for SNPs whose class is single, in-del, insertion, deletion,
mnp or mixed.
- ObservedTooLong - Observed allele not given (length
- ObservedWrongFormat - Observed allele(s) from dbSNP
have unexpected format for the given class.
- RefAlleleMismatch - The reference allele from dbSNP
does not match the UCSC reference allele, i.e., the bases in
the mapped position range.
- RefAlleleRevComp - The reference allele from dbSNP
matches the reverse complement of the UCSC reference
- SingleClassLongerSpan - All observed alleles are
single-base, but the annotation spans more than 1 base.
(UCSC's re-alignment of flanking sequences to the genome may
- SingleClassZeroSpan - All observed alleles are
single-base, but the annotation spans 0 bases. (UCSC's
re-alignment of flanking sequences to the genome may be
- SingleClassTriAllelic, SingleClassQuadAllelic -
Class is single and three or four different bases have been
observed (usually there are only two).
Miscellaneous Attributes (dbSNP): several properties extracted
from dbSNP's SNP_bitfield table
(see dbSNP_BitField_v5.pdf for details)
- Clinically Associated (human only) - SNP is in OMIM and/or at
least one submitter is a Locus-Specific Database. This does
not necessarily imply that the variant causes any disease,
only that it has been observed in clinical studies.
- Appears in OMIM/OMIA - SNP is mentioned in
Online Mendelian Inheritance in Man for
human SNPs, or Online Mendelian Inheritance in Animals for
non-human animal SNPs. Some of these SNPs are quite common,
others are known to cause disease; see OMIM/OMIA for more
- Has Microattribution/Third-Party Annotation - At least
one of the SNP's submitters studied this SNP in a biomedical
setting, but is not a Locus-Specific Database or OMIM/OMIA.
- Submitted by Locus-Specific Database - At least one of
the SNP's submitters is associated with a database of variants
associated with a particular gene. These variants may or may
not be known to be causative.
- MAF >= 5% in Some Population - Minor Allele Frequency is
at least 5% in at least one population assayed.
- MAF >= 5% in All Populations - Minor Allele Frequency is
at least 5% in all populations assayed.
- Genotype Conflict - Quality check: different genotypes
have been submitted for the same individual.
- Ref SNP Cluster has Non-overlapping Alleles - Quality
check: this reference SNP was clustered from submitted SNPs
with non-overlapping sets of observed alleles.
- Some Assembly's Allele Does Not Match Observed -
Quality check: at least one assembly mapped by dbSNP has an allele
at the mapped position that is not present in this SNP's observed
Several other properties do not have coloring options, but do have
some filtering options:
Average heterozygosity: Calculated by dbSNP as described in
Computation of Average
Heterozygosity and Standard Error for dbSNP RefSNP Clusters.
- Average heterozygosity should not exceed 0.5 for bi-allelic
Weight: Alignment quality assigned by dbSNP. Before dbSNP build
147, weight had values 1, 2 or 3, with 1 being the highest quality
(mapped to a single genomic location). As of dbSNP build 147, dbSNP
now releases only the variants with weight 1.
Submitter handles: These are short, single-word identifiers of
labs or consortia that submitted SNPs that were clustered into this
reference SNP by dbSNP (e.g., 1000GENOMES, ENSEMBL, KWOK). Some SNPs
have been observed by many different submitters, and some by only a
single submitter (although that single submitter may have tested a
large number of samples).
AlleleFrequencies: Some submissions to dbSNP include
allele frequencies and the study's sample size
(i.e., the number of distinct chromosomes, which is two times the
number of individuals assayed, a.k.a. 2N). dbSNP combines all
available frequencies and counts from submitted SNPs that are
clustered together into a reference SNP.
You can configure this track such that the details page displays
the function and coding differences relative to
particular gene sets. Choose the gene sets from the list on the SNP
configuration page displayed beneath this heading: On details page,
show function and coding differences relative to.
When one or more gene tracks are selected, the SNP details page
lists all genes that the SNP hits (or is close to), with the same keywords
used in the function category. The function usually
agrees with NCBI's function, except when NCBI's functional annotation is
relative to an XM_* predicted RefSeq (not included in the UCSC Genome
Browser's RefSeq Genes track) and/or UCSC's functional annotation is
relative to a transcript that is not in RefSeq.
dbSNP uses a class called 'in-del'. We compare the length of the
reference allele to the length(s) of observed alleles; if the
reference allele is shorter than all other observed alleles, we change
'in-del' to 'insertion'. Likewise, if the reference allele is longer
than all other observed alleles, we change 'in-del' to 'deletion'.
UCSC Re-alignment of flanking sequences
dbSNP determines the genomic locations of SNPs by aligning their flanking
sequences to the genome.
UCSC displays SNPs in the locations determined by dbSNP, but does not
have access to the alignments on which dbSNP based its mappings.
Instead, UCSC re-aligns the flanking sequences
to the neighboring genomic sequence for display on SNP details pages.
While the recomputed alignments may differ from dbSNP's alignments,
they often are informative when UCSC has annotated an unusual condition.
Non-repetitive genomic sequence is shown in upper case like the flanking
sequence, and a "|" indicates each match between genomic and flanking bases.
Repetitive genomic sequence (annotated by RepeatMasker and/or the
Tandem Repeats Finder with period >= 12) is shown in lower case, and matching
bases are indicated by a "+".
Data Sources and Methods
The data that comprise this track were extracted from database dump files
and headers of fasta files downloaded from NCBI.
The database dump files were downloaded from
for hg19 and from
The fasta files were downloaded from
for hg19 and from
- Coordinates, orientation, location type and dbSNP reference allele data
were obtained from b147_SNPContigLoc_N.bcp.gz and
b147_ContigInfo_N.bcp.gz. (N = 105 for hg19, 107 for hg38)
- b147_SNPMapInfo_N.bcp.gz provided the alignment weights.
- Functional classification was obtained from
b147_SNPContigLocusId_N.bcp.gz. The internal database representation
uses dbSNP's function terms, but for display in SNP details pages,
these are translated into
Sequence Ontology terms.
- Validation status and heterozygosity were obtained from SNP.bcp.gz.
- SNPAlleleFreq.bcp.gz and ../shared/Allele.bcp.gz provided allele frequencies.
For the human assembly, allele frequencies were also taken from
- Submitter handles were extracted from Batch.bcp.gz, SubSNP.bcp.gz and
- SNP_bitfield.bcp.gz provided miscellaneous properties annotated by dbSNP,
such as clinically-associated. See the document
dbSNP_BitField_v5.pdf for details.
- The header lines in the rs_fasta files were used for molecule type,
class and observed polymorphism.
The raw data can be explored interactively with the Table Browser,
Data Integrator, or Variant Annotation Integrator.
For automated analysis, the genome annotation can be downloaded from the downloads server for hg38 and
hg19 (snp147*.txt.gz) or the public MySQL server.
Please refer to our mailing list archives
for questions and example queries, or our Data Access FAQ for more information.
Orthologous Alleles (human assemblies only)
For the human assembly, we provide a related table that contains
orthologous alleles in the chimpanzee, orangutan and rhesus macaque
reference genome assemblies.
We use our liftOver utility to identify the orthologous alleles.
The candidate human SNPs are a filtered list that meet the criteria:
- class = 'single'
- mapped position in the human reference genome is one base long
- aligned to only one location in the human reference genome
- not aligned to a chrN_random chrom
- biallelic (not tri- or quad-allelic)
In some cases the orthologous allele is unknown; these are set to 'N'.
If a lift was not possible, we set the orthologous allele to '?' and the
orthologous start and end position to 0 (zero).
Masked FASTA Files (human assemblies only)
FASTA files that have been modified to use
ambiguous nucleotide characters at
each base covered by a single-base substitution are available for download:
Note that only single-base substitutions (no insertions or deletions) were used
to mask the sequence, and these were filtered to exclude problematic SNPs.
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