Schema for gnfRatAtlas2AllExps

Database: hgFixed Primary Table: gnfRatAtlas2AllExps Row Count: 122 Data last updated: 2004-05-17
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`	0	`int(10) unsigned`	range	internal id of experiment
`name`	frontal cortex wistar 3658	`varchar(255)`	values	name of experiment
`description`	frontal cortex wistar 3658	`longblob`		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.org	`longblob`		who to credit with experiment
`numExtras`	3	`int(10) unsigned`	range	number of extra things
`extras`	RG-U34A,n/a,frontal cortex ...	`longblob`		extra things of interest, i.e. classifications

Connected Tables and Joining Fields


	hgFixed.gnfRatAtlas2All.expScores (gnfRatAtlas2AllExps.id is an array index into gnfRatAtlas2All.expScores) hgFixed.gnfRatAtlas2AllRatio.expScores (gnfRatAtlas2AllExps.id is an array index into gnfRatAtlas2AllRatio.expScores)

Sample Rows

id	name	description	url	ref	credit	numExtras	extras
0	frontal cortex wistar 3658	frontal cortex wistar 3658	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,frontal cortex wistar 3658,
1	frontal cortex wistar 3659	frontal cortex wistar 3659	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,frontal cortex wistar 3659,
2	frontal cortex wistar 3660	frontal cortex wistar 3660	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,frontal cortex wistar 3660,
3	frontal cortex wistar 3662	frontal cortex wistar 3662	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,frontal cortex wistar 3662,
4	amygdala wistar 3722	amygdala wistar 3722	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,amygdala wistar 3722,
5	amygdala wistar 3723	amygdala wistar 3723	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,amygdala wistar 3723,
6	amygdala wistar 3724	amygdala wistar 3724	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,amygdala wistar 3724,
7	amygdala wistar 3942	amygdala wistar 3942	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,amygdala wistar 3942,
8	amygdala- central nucleus sprague1	amygdala- central nucleus sprague1	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,amygdala- central nucleus sprague1,
9	hippocampus wistar 3772	hippocampus wistar 3772	http://www.affymetrix.com/analysis/index.affx	http://expression.gnf.org/ratlas	http://www.gnf.org	3	RG-U34A,n/a,hippocampus wistar 3772,

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