Schema for affyExonTissuesGsMedianDist

Database: hg18 Primary Table: affyExonTissuesGsMedianDist Row Count: 64,010,000 Data last updated: 2009-03-10
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

field	example	SQL type	description
`query`	uc001aaa.2	`varchar(255)`	Name of one gene
`target`	uc001aaa.2	`varchar(255)`	Name of other gene
`distance`	0	`float`	Distance in expression space, always >= 0

Connected Tables and Joining Fields


	hg18.knownGene.name (via affyExonTissuesGsMedianDist.query)

Sample Rows

query	target	distance
uc001aaa.2	uc001aaa.2	0
uc001aaa.2	uc009vip.1	0.049
uc001aaa.2	uc001ncx.1	0.053091
uc001aaa.2	uc001lrl.1	0.053273
uc001aaa.2	uc003fbu.1	0.058091
uc001aaa.2	uc003pxq.1	0.059
uc001aaa.2	uc002ugu.2	0.059091
uc001aaa.2	uc010gbd.1	0.06
uc001aaa.2	uc001lrm.1	0.061182
uc001aaa.2	uc001ncw.1	0.062545

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