Schema for snp130ExceptionDesc
  Database: hg18    Primary Table: snp130ExceptionDesc    Row Count: 18   Data last updated: 2009-07-07
Format description: Brief descriptions and counts of the exception types checked in the corresponding SNP track and snp???Exceptions table.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
exception RefAlleleMismatchvarchar(63) values Exception type.
count 4int(10) unsigned range Number of occurrences of this exception.
description The reference allele from d...varchar(255) values Brief description of exception.

Connected Tables and Joining Fields
        hg18.snp130Exceptions.exception (via snp130ExceptionDesc.exception)

Sample Rows
 
exceptioncountdescription
RefAlleleMismatch4The reference allele from dbSNP does not match the UCSC reference allele.
RefAlleleRevComp0The reference allele from dbSNP matches the reverse complement of the UCSC reference allele.
DuplicateObserved4108There are other rsIds at this position with identical variation.
MixedObserved3473There are other rsIds at this position with different variation.
FlankMismatchGenomeLonger6583NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
FlankMismatchGenomeEqual547NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
FlankMismatchGenomeShorter26351NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
NamedDeletionZeroSpan1369A deletion (from the genome) was observed but the annotation spans 0 bases.  (UCSC's re-alignment of flanking sequences to the g ...
NamedInsertionNonzeroSpan355An insertion (into the genome) was observed but the annotation spans more than 0 bases.  (UCSC's re-alignment of flanking sequen ...
SingleClassLongerSpan19089All observed alleles are single-base, but the annotation spans more than 1 base.  (UCSC's re-alignment of flanking sequences to ...

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.