Schema for snp150
  Database: hg38    Primary Table: snp150    Row Count: 335,322,261   Data last updated: 2017-04-16
Format description: Polymorphism data from dbSNP
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1varchar(31) Reference sequence chromosome or scaffold
chromStart 10019int(10) unsigned Start position in chrom
chromEnd 10020int(10) unsigned End position in chrom
name rs775809821varchar(15) dbSNP Reference SNP (rs) identifier
score 0smallint(5) unsigned Not used
strand +enum('+', '-') Which DNA strand contains the observed alleles
refNCBI Ablob Reference genomic sequence from dbSNP
refUCSC Ablob Reference genomic sequence from UCSC lookup of chrom,chromStart,chromEnd
observed -/Avarchar(255) The sequences of the observed alleles from rs-fasta files
molType genomicenum('unknown', 'genomic', 'cDNA', 'mito') Sample type from exemplar submitted SNPs (ss)
class deletionenum('single', 'in-del', 'microsatellite', 'named', 'mnp', 'insertion', 'deletion') Class of variant (single, in-del, named, mixed, etc.)
valid unknownset('unknown', 'by-cluster', 'by-frequency', 'by-submitter', 'by-2hit-2allele', 'by-hapmap', 'by-1000genomes') Validation status of the SNP
avHet 0float Average heterozygosity from all observations. Note: may be computed on small number of samples.
avHetSE 0float Standard Error for the average heterozygosity
func near-gene-5set('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') Functional category of the SNP (coding-synon, coding-nonsynon, intron, etc.)
locType exactenum('range', 'exact', 'between', 'rangeInsertion', 'rangeSubstitution', 'rangeDeletion', 'fuzzy') Type of mapping inferred from size on reference; may not agree with class
weight 1int(10) unsigned The quality of the alignment: 1 = unique mapping, 2 = non-unique, 3 = many matches
exceptions  set('RefAlleleMismatch', 'DuplicateObserved', 'MixedObserved', 'FlankMismatchGenomeLonger', 'FlankMismatchGenomeEqual', 'FlankMismatchGenomeShorter', 'NamedDeletionZeroSpan', 'NamedInsertionNonzeroSpan', 'SingleClassLongerSpan', 'SingleClassZeroSpan', 'SingleClassTriAllelic', 'SingleClassQuadAllelic', 'ObservedWrongFormat', 'ObservedTooLong', 'ObservedContainsIupac', 'ObservedMismatch', 'MultipleAlignments', 'NonIntegerChromCount', 'AlleleFreqSumNot1', 'SingleAlleleFreq', 'InconsistentAlleles') Unusual conditions noted by UCSC that may indicate a problem with the data
submitterCount 1smallint(5) unsigned Number of distinct submitter handles for submitted SNPs for this ref SNP
submitters SSMP,longblob List of submitter handles
alleleFreqCount 0smallint(5) unsigned Number of observed alleles with frequency data
alleles  longblob Observed alleles for which frequency data are available
alleleNs  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  longblob Allele frequencies
bitfields  set('unknown', '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') SNP attributes extracted from dbSNP's SNP_bitfield table

Connected Tables and Joining Fields
        hg38.snp150Common.exceptions (via snp150.exceptions)
      hg38.snp150ExceptionDesc.exception (via snp150.exceptions)
      hg38.snp150Flagged.exceptions (via snp150.exceptions)
      hg38.snp150Mult.exceptions (via snp150.exceptions)
      hg38.snp150CodingDbSnp.name (via snp150.name)
      hg38.snp150Common.name (via snp150.name)
      hg38.snp150Flagged.name (via snp150.name)
      hg38.snp150Mult.name (via snp150.name)
      hg38.snp150OrthoPt5Pa2Rm8.name (via snp150.name)
      hg38.snp150Seq.acc (via snp150.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandrefNCBIrefUCSCobservedmolTypeclassvalidavHetavHetSEfunclocTypeweightexceptionssubmitterCountsubmittersalleleFreqCountallelesalleleNsalleleFreqsbitfields
585chr11001910020rs7758098210+AA-/Agenomicdeletionunknown00near-gene-5exact11SSMP,0
585chr11003810039rs9787608280+AAA/Cgenomicsingleunknown00near-gene-5exact11USC_VALOUEV,0
585chr11004210043rs10088296510+TTA/Tgenomicsingleunknown00near-gene-5exact11USC_VALOUEV,0
585chr11005010051rs10523735740+AAA/Ggenomicsingleunknown00near-gene-5exact11USC_VALOUEV,0
585chr11005410055rs8925018640+TTA/Tgenomicsingleunknown00near-gene-5exact11USC_VALOUEV,0
585chr11005510055rs7680191420+---/Agenomicinsertionunknown00near-gene-5between11SSMP,0
585chr11006210063rs10109893430+AAA/Cgenomicsingleunknown00near-gene-5exact11USC_VALOUEV,0
585chr11007610077rs10228053580+CCC/Ggenomicsingleunknown00near-gene-5exact11USC_VALOUEV,0
585chr11010710108rs626510260+CCC/Tgenomicsingleunknown00near-gene-5exact11BCMHGSC_JDW,0
585chr11010810109rs3760075220+AAA/Tgenomicsingleby-cluster00near-gene-5exact12BILGI_BIOE,WEILL_CORNELL_DGM,0

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