Schema for snp150OrthoPt5Pa2Rm8
  Database: hg38    Primary Table: snp150OrthoPt5Pa2Rm8    Row Count: 297,851,202   Data last updated: 2020-06-15
fieldexampleSQL type
bin 585smallint(6)
chrom chr1varchar(255)
chromStart 10926int(10) unsigned
chromEnd 10927int(10) unsigned
name rs10218527varchar(255)
humanObserved A/Gvarchar(255)
humanAllele Achar(1)
humanStrand +char(1)
chimpChrom chrUn_NW_015974624v1varchar(255)
chimpStart 5924int(10) unsigned
chimpEnd 5925int(10) unsigned
chimpAllele Achar(1)
chimpStrand -char(1)
orangChrom ?varchar(255)
orangStart 0int(10) unsigned
orangEnd 0int(10) unsigned
orangAllele ?char(1)
orangStrand ?char(1)
macaqueChrom ?varchar(255)
macaqueStart 0int(10) unsigned
macaqueEnd 0int(10) unsigned
macaqueAllele ?char(1)
macaqueStrand ?char(1)

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

Sample Rows
 
binchromchromStartchromEndnamehumanObservedhumanAllelehumanStrandchimpChromchimpStartchimpEndchimpAllelechimpStrandorangChromorangStartorangEndorangAlleleorangStrandmacaqueChrommacaqueStartmacaqueEndmacaqueAllelemacaqueStrand
585chr11092610927rs10218527A/GA+chrUn_NW_015974624v159245925A-?00???00??
585chr11093010931rs867393882C/TC+chrUn_NW_015974624v159205921C-?00???00??
585chr11093710938rs28853987A/GG+chrUn_NW_015974624v159135914G-?00???00??
585chr11098410985rs866721506A/GG+chrUn_NW_015974624v158735874G-?00???00??
585chr11100711008rs575272151C/GC+chrUn_NW_015974624v158515852T-?00???00??
585chr11101111012rs544419019C/GC+chrUn_NW_015974624v158475848C-?00???00??
585chr11101311014rs28484712A/GG+chrUn_NW_015974624v158455846G-?00???00??
585chr11102111022rs28775022A/GG+chrUn_NW_015974624v158375838G-?00???00??
585chr11106211063rs561109771G/TT+chrUn_NW_015974624v157975798T-?00???00??
585chr11108011081rs10218495G/TG+chrUn_NW_015974624v157845785G-?00???00??

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