Schema for affyExps

Database: hgFixed Primary Table: affyExps Row Count: 85 Data last updated: 2002-02-27
Format description: minimal descriptive data for an experiment in the browser
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`id`	84	`int(10) unsigned`	range	internal id of experiment
`name`	H9SGK99092001_HUVEC3	`varchar(255)`	values	name of experiment
`description`	HUVEC3	`longblob`		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`	3	`int(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

id	name	description	url	ref	credit	numExtras	extras
84	H9SGK99092001_HUVEC3	HUVEC3	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9SGK99092001,HUVEC3,
83	H9SGK99091504_HL60	HL60	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9SGK99091504,HL60,
82	H9SGK99091503_MOLT4	MOLT4	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9SGK99091503,MOLT4,
81	H9SGK99091502_HUVEC2	HUVEC2	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9SGK99091502,HUVEC2,
80	H9RGV99031201_HepG2	HepG2	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9RGV99031201,HepG2,
79	H9RGV00112206_PITUARY_GLAND	PITUARY_GLAND	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9RGV00112206,PITUARY_GLAND,
78	H9RGV00111502_THALAMUS	THALAMUS	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9RGV00111502,THALAMUS,
77	H9RGV00111404_CORPUS_CALLOSUM	CORPUS_CALLOSUM	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9RGV00111404,CORPUS_CALLOSUM,
76	H9RGV00111403_FETAL_BRAIN	FETAL_BRAIN	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9RGV00111403,FETAL_BRAIN,
75	H9RGV00111402_FETAL_LIVER	FETAL_LIVER	https://www.netaffx.com/index2.jsp	http://www.gnf.org/	http://www.gnf.org/	3	HG-U95,H9RGV00111402,FETAL_LIVER,

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