Schema for affyExps
  Database: hgFixed    Primary Table: affyExps    Row Count: 85   Data last updated: 2002-02-26
Format description: minimal descriptive data for an experiment in the browser
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 84int(10) unsigned range internal id of experiment
name H9SGK99092001_HUVEC3varchar(255) values name of experiment
description HUVEC3longblob   description of experiment
url https://www.netaffx.com/ind...longblob   url relevant to experiment
ref http://www.gnf.org/longblob   reference for experiment
credit http://www.gnf.org/longblob   who to credit with experiment
numExtras 3int(10) unsigned range number of extra things
extras HG-U95,H9SGK99092001,HUVEC3,longblob   extra things of interest, i.e. classifications

Connected Tables and Joining Fields
        hg16.affyRatio.expIds (via affyExps.id)
      hg16.affyRatio.expScores (affyExps.id is an array index into affyRatio.expScores)
      hg17.affyRatio.expIds (via affyExps.id)
      hg17.affyRatio.expScores (affyExps.id is an array index into affyRatio.expScores)
      hg18.affyRatio.expIds (via affyExps.id)
      hg18.affyRatio.expScores (affyExps.id is an array index into affyRatio.expScores)

Sample Rows
 
idnamedescriptionurlrefcreditnumExtrasextras
84H9SGK99092001_HUVEC3HUVEC3https://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9SGK99092001,HUVEC3,
83H9SGK99091504_HL60HL60https://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9SGK99091504,HL60,
82H9SGK99091503_MOLT4MOLT4https://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9SGK99091503,MOLT4,
81H9SGK99091502_HUVEC2HUVEC2https://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9SGK99091502,HUVEC2,
80H9RGV99031201_HepG2HepG2https://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9RGV99031201,HepG2,
79H9RGV00112206_PITUARY_GLANDPITUARY_GLANDhttps://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9RGV00112206,PITUARY_GLAND,
78H9RGV00111502_THALAMUSTHALAMUShttps://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9RGV00111502,THALAMUS,
77H9RGV00111404_CORPUS_CALLOSUMCORPUS_CALLOSUMhttps://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9RGV00111404,CORPUS_CALLOSUM,
76H9RGV00111403_FETAL_BRAINFETAL_BRAINhttps://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9RGV00111403,FETAL_BRAIN,
75H9RGV00111402_FETAL_LIVERFETAL_LIVERhttps://www.netaffx.com/index2.jsphttp://www.gnf.org/http://www.gnf.org/3HG-U95,H9RGV00111402,FETAL_LIVER,

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