Schema for snp144ExceptionDesc
  Database: hg38    Primary Table: snp144ExceptionDesc    Row Count: 22   Data last updated: 2015-09-06
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 10int(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
        hg38.snp144.exceptions (via snp144ExceptionDesc.exception)
      hg38.snp144Common.exceptions (via snp144ExceptionDesc.exception)
      hg38.snp144Flagged.exceptions (via snp144ExceptionDesc.exception)
      hg38.snp144Mult.exceptions (via snp144ExceptionDesc.exception)

Sample Rows
 
exceptioncountdescription
RefAlleleMismatch10The 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.
DuplicateObserved587927There are other rsIds at this position with identical variation.
MixedObserved3841382There are other rsIds at this position with different variation.
FlankMismatchGenomeLonger64255NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
FlankMismatchGenomeEqual187748NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
FlankMismatchGenomeShorter132948NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
NamedDeletionZeroSpan0A deletion (from the genome) was observed but the annotation spans 0 bases.  (UCSC's re-alignment of flanking sequences to the g ...
NamedInsertionNonzeroSpan0An insertion (into the genome) was observed but the annotation spans more than 0 bases.  (UCSC's re-alignment of flanking sequen ...
SingleClassLongerSpan64988All 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.