Schema for gnfHumanAtlas2MedianRatio
  Database: hgFixed    Primary Table: gnfHumanAtlas2MedianRatio    Row Count: 44,696   Data last updated: 2004-03-29
Format description: Expression data (no mapping, just spots)
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name 1007_s_atvarchar(255) values Name of gene/target/probe etc.
expCount 79int(10) unsigned range Number of scores
expScores 1.230,1.134,-0.124,0.811,0....longblob   Scores. May be absolute or relative ratio

Connected Tables and Joining Fields
        hg16.gnfAtlas2.expScores (gnfHumanAtlas2MedianRatio.expScores and gnfAtlas2.expScores are arrays sharing an index)
      hg17.gnfAtlas2.expScores (gnfHumanAtlas2MedianRatio.expScores and gnfAtlas2.expScores are arrays sharing an index)
      hg18.gnfAtlas2.expScores (gnfHumanAtlas2MedianRatio.expScores and gnfAtlas2.expScores are arrays sharing an index)
      hg19.gnfAtlas2.expScores (gnfHumanAtlas2MedianRatio.expScores and gnfAtlas2.expScores are arrays sharing an index)
      hg38.gnfAtlas2.expScores (gnfHumanAtlas2MedianRatio.expScores and gnfAtlas2.expScores are arrays sharing an index)
      hgFixed.gnfHumanAtlas2Median.expScores (gnfHumanAtlas2MedianRatio.expScores and gnfHumanAtlas2Median.expScores are arrays sharing an index)
      hgFixed.gnfHumanAtlas2MedianExps.id (which is an array index into gnfHumanAtlas2MedianRatio.expScores)
      hg16.affyGnf1h.qName (via gnfHumanAtlas2MedianRatio.name)
      hg16.gnfAtlas2.name (via gnfHumanAtlas2MedianRatio.name)
      hg16.knownToGnfAtlas2.value (via gnfHumanAtlas2MedianRatio.name)
      hg17.affyGnf1h.qName (via gnfHumanAtlas2MedianRatio.name)
      hg17.gnfAtlas2.name (via gnfHumanAtlas2MedianRatio.name)
      hg17.knownToGnfAtlas2.value (via gnfHumanAtlas2MedianRatio.name)
      hg18.affyGnf1h.qName (via gnfHumanAtlas2MedianRatio.name)
      hg18.gnfAtlas2.name (via gnfHumanAtlas2MedianRatio.name)
      hg18.knownToGnfAtlas2.value (via gnfHumanAtlas2MedianRatio.name)
      hg19.affyGnf1h.qName (via gnfHumanAtlas2MedianRatio.name)
      hg19.gnfAtlas2.name (via gnfHumanAtlas2MedianRatio.name)
      hg19.knownToGnfAtlas2.value (via gnfHumanAtlas2MedianRatio.name)
      hg38.affyGnf1h.qName (via gnfHumanAtlas2MedianRatio.name)
      hg38.gnfAtlas2.name (via gnfHumanAtlas2MedianRatio.name)
      hg38.knownToGnfAtlas2.value (via gnfHumanAtlas2MedianRatio.name)
      hgFixed.gladHumESOtherData.name (via gnfHumanAtlas2MedianRatio.name)
      hgFixed.gnfHumanAtlas2All.name (via gnfHumanAtlas2MedianRatio.name)
      hgFixed.gnfHumanAtlas2AllRatio.name (via gnfHumanAtlas2MedianRatio.name)
      hgFixed.gnfHumanAtlas2Median.name (via gnfHumanAtlas2MedianRatio.name)

Sample Rows
 
nameexpCountexpScores
1007_s_at791.230,1.134,-0.124,0.811,0.728,0.958,0.361,0.746,0.599,0.982,1.801,1.260,-0.058,1.075,0.072,0.883,0.249,0.628,2.241,-1.135,-0.87 ...
1053_at79-0.231,0.253,-1.828,-0.835,-1.105,-0.983,-1.407,-0.735,-0.068,0.143,-0.528,-0.598,-1.655,-0.273,-1.200,-2.643,-0.752,-1.071,0.06 ...
117_at790.248,-0.256,-1.205,0.260,-0.276,-0.167,0.000,-0.141,0.264,-0.299,-0.070,0.651,-1.118,-0.804,-0.106,0.823,-0.385,-0.531,0.882,-0 ...
121_at790.148,-0.024,-0.061,-0.124,-0.424,-0.218,-0.182,0.467,-0.088,0.075,-0.046,-0.045,-0.739,-0.016,-0.579,0.479,-0.223,-0.311,0.264, ...
1255_g_at790.539,-0.038,1.304,0.148,-0.079,0.005,0.384,-0.331,-0.316,0.716,0.752,-0.087,0.445,0.752,-0.372,-0.655,0.470,0.583,0.246,0.390,1 ...
1294_at79-0.316,-0.625,-0.547,-0.342,-0.230,-0.492,-0.306,-0.232,-0.427,-0.738,-0.225,0.113,-0.920,-0.364,0.028,0.593,-0.166,-0.384,-0.08 ...
1316_at790.456,-0.051,-0.353,0.104,-0.159,0.383,0.319,-0.091,-0.142,0.302,-0.303,0.080,-0.589,0.851,0.304,0.780,-0.415,-0.241,0.112,-0.29 ...
1320_at790.948,-1.490,-0.008,-0.678,-1.478,-0.711,-0.235,0.340,-0.233,-0.880,-0.162,-0.994,-1.028,-1.267,-2.439,-0.147,-0.651,-1.138,-0.6 ...
1405_i_at79-2.240,-1.579,-0.236,-0.176,-2.240,-2.240,-0.654,-0.455,-0.277,-0.656,0.156,-0.090,-1.609,-0.443,-1.316,1.161,0.062,0.360,0.007, ...
1431_at790.976,-0.040,0.326,0.249,0.227,-0.059,-0.949,-0.412,0.131,0.279,-0.319,-0.609,-0.086,0.224,-0.592,0.362,-0.202,0.417,0.167,0.246 ...

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