Schema for gnfRatAtlas2MedianExps
  Database: hgFixed    Primary Table: gnfRatAtlas2MedianExps    Row Count: 44   Data last updated: 2004-05-17
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 ventral tegmental area spraguevarchar(255) values name of experiment
description ventral tegmental area spraguelongblob   description of experiment
url http://www.affymetrix.com/a...longblob   url relevant to experiment
ref http://expression.gnf.org/r...longblob   reference for experiment
credit http://www.gnf.orglongblob   who to credit with experiment
numExtras 3int(10) unsigned range number of extra things
extras RG-U34A,n/a,brain,longblob   extra things of interest, i.e. classifications

Connected Tables and Joining Fields
        hgFixed.gnfRatAtlas2Median.expScores (gnfRatAtlas2MedianExps.id is an array index into gnfRatAtlas2Median.expScores)
      hgFixed.gnfRatAtlas2MedianRatio.expScores (gnfRatAtlas2MedianExps.id is an array index into gnfRatAtlas2MedianRatio.expScores)
      rn3.gnfAtlas2.expScores (gnfRatAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)
      rn4.gnfAtlas2.expScores (gnfRatAtlas2MedianExps.id is an array index into gnfAtlas2.expScores)

Sample Rows
 
idnamedescriptionurlrefcreditnumExtrasextras
0ventral tegmental area spragueventral tegmental area spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,brain,
1hippocampus wistarhippocampus wistarhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,brain,
2small intestine spraguesmall intestine spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,digestion,
3hippocampus spraguehippocampus spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,brain,
4amygdala spragueamygdala spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,brain,
5pineal spraguepineal spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,gland,
6large intestine spraguelarge intestine spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,digestion,
7frontal cortex spraguefrontal cortex spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,brain,
8cerebellum spraguecerebellum spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,brain,
9skeletal muscle spragueskeletal muscle spraguehttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.org/ratlashttp://www.gnf.org3RG-U34A,n/a,muscle,

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