Schema for gnfHumanAtlas2MedianExps
  Database: hgFixed    Primary Table: gnfHumanAtlas2MedianExps    Row Count: 79   Data last updated: 2004-03-29
Format description: minimal descriptive data for an experiment in the browser
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 0int(10) unsigned range internal id of experiment
name fetal brainvarchar(255) values name of experiment
description fetal brainlongblob   description of experiment
url http://www.affymetrix.com/a...longblob   url relevant to experiment
ref http://expression.gnf.orglongblob   reference for experiment
credit http://www.gnf.orglongblob   who to credit with experiment
numExtras 3int(10) unsigned range number of extra things
extras U133A+GNF1B,n/a,brain,longblob   extra things of interest, i.e. classifications

Connected Tables and Joining Fields
        hg16.gnfAtlas2.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)
      hg17.gnfAtlas2.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)
      hg18.gnfAtlas2.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)
      hg19.gnfAtlas2.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)
      hg38.gnfAtlas2.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)
      hgFixed.gnfHumanAtlas2Median.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfHumanAtlas2Median.expScores)
      hgFixed.gnfHumanAtlas2MedianRatio.expScores (gnfHumanAtlas2MedianExps.id is an array index into gnfHumanAtlas2MedianRatio.expScores)

Sample Rows
 
idnamedescriptionurlrefcreditnumExtrasextras
0fetal brainfetal brainhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
1whole brainwhole brainhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
2temporal lobetemporal lobehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
3parietal lobeparietal lobehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
4occipital lobeoccipital lobehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
5prefrontal cortexprefrontal cortexhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
6cingulate cortexcingulate cortexhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
7cerebellumcerebellumhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
8cerebellum pedunclescerebellum peduncleshttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,
9amygdalaamygdalahttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,brain,

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