Schema for snp144OrthoPt4Pa2Rm3
  Database: hg38    Primary Table: snp144OrthoPt4Pa2Rm3    Row Count: 133,119,727   Data last updated: 2015-09-09
Format description: Orthologous alleles in chimp, orangutan and rhesus macaque (human only)
On download server: MariaDB table dump directory
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 chr15varchar(255) Chimp chromosome to which the human SNP is mapped
chimpStart 99534702int(10) unsigned Start position on chimpChrom
chimpEnd 99534703int(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.gwasCatalog.name (via snp144OrthoPt4Pa2Rm3.name)
      hg38.snp144.name (via snp144OrthoPt4Pa2Rm3.name)
      hg38.snp144CodingDbSnp.name (via snp144OrthoPt4Pa2Rm3.name)
      hg38.snp144Common.name (via snp144OrthoPt4Pa2Rm3.name)
      hg38.snp144Flagged.name (via snp144OrthoPt4Pa2Rm3.name)
      hg38.snp144Mult.name (via snp144OrthoPt4Pa2Rm3.name)
      hg38.snp144Seq.acc (via snp144OrthoPt4Pa2Rm3.name)

Sample Rows
 
binchromchromStartchromEndnamehumanObservedhumanAllelehumanStrandchimpChromchimpStartchimpEndchimpAllelechimpStrandorangChromorangStartorangEndorangAlleleorangStrandmacaqueChrommacaqueStartmacaqueEndmacaqueAllelemacaqueStrand
585chr11092610927rs10218527A/GA+chr159953470299534703A-?00???00??
585chr11093710938rs28853987A/GG+chr159953469199534692G-?00???00??
585chr11100711008rs575272151C/GC+chr159953462999534630T-?00???00??
585chr11101111012rs544419019C/GC+chr159953462599534626C-?00???00??
585chr11101311014rs28484712A/GG+chr159953462399534624G-?00???00??
585chr11102111022rs28775022A/GG+chr159953461599534616G-?00???00??
585chr11106211063rs561109771G/TT+chr159953457599534576T-?00???00??
585chr11108011081rs10218495G/TG+chr159953456299534563G-?00???00??
585chr11115311154rs62635278A/CA+chr159953448999534490A-?00???00??
585chr11116611167rs62635279A/CC+chr159953447699534477C-?00???00??

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