Schema for snp150OrthoPt5Pa2Rm8
  Database: hg38    Primary Table: snp150OrthoPt5Pa2Rm8    Row Count: 297,851,202   Data last updated: 2017-04-27
Format description: Orthologous alleles in chimp, orangutan and rhesus macaque (human only)
fieldexampleSQL type description
bin 585smallint(6) Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Chromosome
chromStart 10926int(10) unsigned Start position in chrom
chromEnd 10927int(10) unsigned End position in chrom
name rs10218527varchar(255) Reference SNP identifier from dbSnp
humanObserved A/Gvarchar(255) Observed alleles in human SNP
humanAllele Achar(1) Reference allele for human SNP
humanStrand +char(1) Strand of human SNP annotation
chimpChrom chrUn_NW_015974624v1varchar(255) Chimp chromosome to which the human SNP is mapped
chimpStart 5924int(10) unsigned Start position on chimpChrom
chimpEnd 5925int(10) unsigned End position on chimpChrom
chimpAllele Achar(1) Reference allele for chimp SNP
chimpStrand -char(1) Strand of chimp SNP annotation
orangChrom ?varchar(255) Orang chromosome to which the human SNP is mapped
orangStart 0int(10) unsigned Start position on orangChrom
orangEnd 0int(10) unsigned End position on orangChrom
orangAllele ?char(1) Reference allele for orang SNP
orangStrand ?char(1) Strand of orang SNP annotation
macaqueChrom ?varchar(255) Macaque chromosome to which the human SNP is mapped
macaqueStart 0int(10) unsigned Start position on macaqueChrom
macaqueEnd 0int(10) unsigned End position on macaqueChrom
macaqueAllele ?char(1) Reference allele for macaque SNP
macaqueStrand ?char(1) Strand of macaque SNP annotation

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.