Schema for snp130OrthoPt2Pa2Rm2
  Database: hg18    Primary Table: snp130OrthoPt2Pa2Rm2    Row Count: 11,797,184   Data last updated: 2009-07-07
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 491int(10) unsigned Start position in chrom
chromEnd 492int(10) unsigned End position in chrom
name rs55998931varchar(255) Reference SNP identifier from dbSnp
humanObserved C/Tvarchar(255) Observed alleles in human SNP
humanAllele Cchar(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 100050033int(10) unsigned Start position on chimpChrom
chimpEnd 100050034int(10) unsigned End position on chimpChrom
chimpAllele Cchar(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
        hg18.gwasCatalog.name (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snp130.name (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snp130CodingDbSnp.name (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snp130Exceptions.name (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snp130Seq.acc (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snpArrayIlluminaHuman660W_Quad.name (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snpArrayIlluminaHumanCytoSNP_12.name (via snp130OrthoPt2Pa2Rm2.name)
      hg18.snpArrayIlluminaHumanOmni1_Quad.name (via snp130OrthoPt2Pa2Rm2.name)

Sample Rows
 
binchromchromStartchromEndnamehumanObservedhumanAllelehumanStrandchimpChromchimpStartchimpEndchimpAllelechimpStrandorangChromorangStartorangEndorangAlleleorangStrandmacaqueChrommacaqueStartmacaqueEndmacaqueAllelemacaqueStrand
585chr1491492rs55998931C/TC+chr15100050033100050034C-?00???00??
585chr1518519rs62636508C/GG+chr15100050006100050007C-?00???00??
585chr1582583rs58108140A/GG+chr15100049942100049943G-?00???00??
585chr1690691rs10218492A/GG+chr15100049866100049867G-?00???00??
585chr1789790rs10218527A/GA+chr15100049806100049807A-?00???00??
585chr1800801rs28853987A/GG+chr15100049795100049796G-?00???00??
585chr1876877rs28484712A/GG+chr15100049727100049728G-?00???00??
585chr1884885rs28775022A/GG+chr15100049719100049720G-?00???00??
585chr11000310004rs56336884A/GG+chr15100039770100039771G-?00??chr13113700693113700694G-
585chr11006810069rs71262675A/GC-chr15100039705100039706G+chr2b2114262421142625G-chr13113700628113700629G+

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