Schema for snp150
  Database: hg38    Primary Table: snp150    Row Count: 335,322,261   Data last updated: 2020-06-15
fieldexampleSQL type
bin 585smallint(5) unsigned
chrom chr1varchar(31)
chromStart 10019int(10) unsigned
chromEnd 10020int(10) unsigned
name rs775809821varchar(15)
score 0smallint(5) unsigned
strand +enum('+', '-')
refNCBI Ablob
refUCSC Ablob
observed -/Avarchar(255)
molType genomicenum('unknown', 'genomic', 'cDNA', 'mito')
class deletionenum('single', 'in-del', 'microsatellite', 'named', 'mnp', 'insertion', 'deletion')
valid unknownset('unknown', 'by-cluster', 'by-frequency', 'by-submitter', 'by-2hit-2allele', 'by-hapmap', 'by-1000genomes')
avHet 0float
avHetSE 0float
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')
locType exactenum('range', 'exact', 'between', 'rangeInsertion', 'rangeSubstitution', 'rangeDeletion', 'fuzzy')
weight 1int(10) unsigned
exceptions  set('RefAlleleMismatch', 'DuplicateObserved', 'MixedObserved', 'FlankMismatchGenomeLonger', 'FlankMismatchGenomeEqual', 'FlankMismatchGenomeShorter', 'NamedDeletionZeroSpan', 'NamedInsertionNonzeroSpan', 'SingleClassLongerSpan', 'SingleClassZeroSpan', 'SingleClassTriAllelic', 'SingleClassQuadAllelic', 'ObservedWrongFormat', 'ObservedTooLong', 'ObservedContainsIupac', 'ObservedMismatch', 'MultipleAlignments', 'NonIntegerChromCount', 'AlleleFreqSumNot1', 'SingleAlleleFreq', 'InconsistentAlleles')
submitterCount 1smallint(5) unsigned
submitters SSMP,longblob
alleleFreqCount 0smallint(5) unsigned
alleles  longblob
alleleNs  longblob
alleleFreqs  longblob
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')

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.