Schema for snp146ExceptionDesc
  Database: hg38    Primary Table: snp146ExceptionDesc    Row Count: 22   Data last updated: 2016-03-11
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 65int(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.snp146.exceptions (via snp146ExceptionDesc.exception)
      hg38.snp146Common.exceptions (via snp146ExceptionDesc.exception)
      hg38.snp146Flagged.exceptions (via snp146ExceptionDesc.exception)
      hg38.snp146Mult.exceptions (via snp146ExceptionDesc.exception)

Sample Rows
 
exceptioncountdescription
RefAlleleMismatch65The 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.
DuplicateObserved394371There are other rsIds at this position with identical variation.
MixedObserved4070892There are other rsIds at this position with different variation.
FlankMismatchGenomeLonger71193NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
FlankMismatchGenomeEqual229567NCBI's alignment of the flanking sequences had at least one mismatch or gap.  (UCSC's re-alignment of flanking sequences to the ...
FlankMismatchGenomeShorter93694NCBI'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 ...
SingleClassLongerSpan82All 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.