Skip to main content
Schema for gnfHumanAtlas2AllExps
  Database: hgFixed    Primary Table: gnfHumanAtlas2AllExps    Row Count: 158   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 ColorectalAdenocarcinomavarchar(255) values name of experiment
description ColorectalAdenocarcinomalongblob   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,ColorectalA...longblob   extra things of interest, i.e. classifications

Connected Tables and Joining Fields
        hgFixed.gnfHumanAtlas2All.expScores (gnfHumanAtlas2AllExps.id is an array index into gnfHumanAtlas2All.expScores)
      hgFixed.gnfHumanAtlas2AllRatio.expScores (gnfHumanAtlas2AllExps.id is an array index into gnfHumanAtlas2AllRatio.expScores)

Sample Rows
 
idnamedescriptionurlrefcreditnumExtrasextras
0ColorectalAdenocarcinomaColorectalAdenocarcinomahttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,ColorectalAdenocarcinoma,
1ColorectalAdenocarcinoma 2ColorectalAdenocarcinoma 2http://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,ColorectalAdenocarcinoma,
2WHOLEBLOODWHOLEBLOODhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,WHOLEBLOOD,
3WHOLEBLOOD 2WHOLEBLOOD 2http://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,WHOLEBLOOD,
4BM-CD33+MyeloidBM-CD33+Myeloidhttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,BM-CD33+Myeloid,
5BM-CD33+Myeloid 2BM-CD33+Myeloid 2http://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,BM-CD33+Myeloid,
6PB-CD14+MonocytesPB-CD14+Monocyteshttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,PB-CD14+Monocytes,
7PB-CD14+Monocytes 2PB-CD14+Monocytes 2http://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,PB-CD14+Monocytes,
8PB-BDCA4+Dentritic CellsPB-BDCA4+Dentritic Cellshttp://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,PB-BDCA4+Dentritic Cells,
9PB-BDCA4+Dentritic Cells 2PB-BDCA4+Dentritic Cells 2http://www.affymetrix.com/analysis/index.affxhttp://expression.gnf.orghttp://www.gnf.org3U133A+GNF1B,n/a,PB-BDCA4+Dentritic Cells,

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