Schema for affyGnfU74ADistance

Database: mm9 Primary Table: affyGnfU74ADistance Row Count: 18,090,000 Data last updated: 2011-03-03
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

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

Connected Tables and Joining Fields


	knownGeneV39.bioCycPathway.kgID (via affyGnfU74ADistance.query) knownGeneV39.ceBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.dmBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.drBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.foldUtr3.name (via affyGnfU74ADistance.query) knownGeneV39.foldUtr5.name (via affyGnfU74ADistance.query) knownGeneV39.gnfAtlas2Distance.query (via affyGnfU74ADistance.query) knownGeneV39.gnfAtlas2Distance.target (via affyGnfU74ADistance.query) knownGeneV39.kgAlias.kgID (via affyGnfU74ADistance.query) knownGeneV39.kgColor.kgID (via affyGnfU74ADistance.query) knownGeneV39.kgProtAlias.kgID (via affyGnfU74ADistance.query) knownGeneV39.kgSpAlias.kgID (via affyGnfU74ADistance.query) knownGeneV39.kgTargetAli.qName (via affyGnfU74ADistance.query) knownGeneV39.kgXref.kgID (via affyGnfU74ADistance.query) knownGeneV39.knownAttrs.kgID (via affyGnfU74ADistance.query) knownGeneV39.knownBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.knownBlastTab.target (via affyGnfU74ADistance.query) knownGeneV39.knownCanonical.protein (via affyGnfU74ADistance.query) knownGeneV39.knownCanonical.transcript (via affyGnfU74ADistance.query) knownGeneV39.knownCds.name (via affyGnfU74ADistance.query) knownGeneV39.knownGene.name (via affyGnfU74ADistance.query) knownGeneV39.knownGeneMrna.name (via affyGnfU74ADistance.query) knownGeneV39.knownGenePep.name (via affyGnfU74ADistance.query) knownGeneV39.knownIsoforms.transcript (via affyGnfU74ADistance.query) knownGeneV39.knownToEnsembl.name (via affyGnfU74ADistance.query) knownGeneV39.knownToGnfAtlas2.name (via affyGnfU74ADistance.query) knownGeneV39.knownToHprd.name (via affyGnfU74ADistance.query) knownGeneV39.knownToLocusLink.name (via affyGnfU74ADistance.query) knownGeneV39.knownToMrna.name (via affyGnfU74ADistance.query) knownGeneV39.knownToMrnaSingle.name (via affyGnfU74ADistance.query) knownGeneV39.knownToMupit.name (via affyGnfU74ADistance.query) knownGeneV39.knownToPfam.name (via affyGnfU74ADistance.query) knownGeneV39.knownToRefSeq.name (via affyGnfU74ADistance.query) knownGeneV39.knownToSuper.gene (via affyGnfU74ADistance.query) knownGeneV39.knownToTag.name (via affyGnfU74ADistance.query) knownGeneV39.knownToU133.name (via affyGnfU74ADistance.query) knownGeneV39.knownToU95.name (via affyGnfU74ADistance.query) knownGeneV39.knownToVisiGene.name (via affyGnfU74ADistance.query) knownGeneV39.knownToWikipedia.name (via affyGnfU74ADistance.query) knownGeneV39.mmBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.rnBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.scBlastTab.query (via affyGnfU74ADistance.query) knownGeneV39.ucscScop.ucscId (via affyGnfU74ADistance.query) mm9.affyGnfU74BDistance.query (via affyGnfU74ADistance.query) mm9.affyGnfU74BDistance.target (via affyGnfU74ADistance.query) mm9.affyGnfU74CDistance.query (via affyGnfU74ADistance.query) mm9.affyGnfU74CDistance.target (via affyGnfU74ADistance.query) mm9.bioCycPathway.kgID (via affyGnfU74ADistance.query) mm9.ccdsKgMap.geneId (via affyGnfU74ADistance.query) mm9.ceBlastTab.query (via affyGnfU74ADistance.query) mm9.dmBlastTab.query (via affyGnfU74ADistance.query) mm9.drBlastTab.query (via affyGnfU74ADistance.query) mm9.foldUtr3.name (via affyGnfU74ADistance.query) mm9.foldUtr5.name (via affyGnfU74ADistance.query) mm9.gnfAtlas2Distance.query (via affyGnfU74ADistance.query) mm9.gnfAtlas2Distance.target (via affyGnfU74ADistance.query) mm9.hgBlastTab.query (via affyGnfU74ADistance.query) mm9.keggPathway.kgID (via affyGnfU74ADistance.query) mm9.kgAlias.kgID (via affyGnfU74ADistance.query) mm9.kgColor.kgID (via affyGnfU74ADistance.query) mm9.kgProtAlias.kgID (via affyGnfU74ADistance.query) mm9.kgProtMap2.qName (via affyGnfU74ADistance.query) mm9.kgSpAlias.kgID (via affyGnfU74ADistance.query) mm9.kgTargetAli.qName (via affyGnfU74ADistance.query) mm9.kgTxInfo.name (via affyGnfU74ADistance.query) mm9.kgXref.kgID (via affyGnfU74ADistance.query) mm9.knownBlastTab.query (via affyGnfU74ADistance.query) mm9.knownBlastTab.target (via affyGnfU74ADistance.query) mm9.knownCanonical.protein (via affyGnfU74ADistance.query) mm9.knownCanonical.transcript (via affyGnfU74ADistance.query) mm9.knownGene.name (via affyGnfU74ADistance.query) mm9.knownGeneMrna.name (via affyGnfU74ADistance.query) mm9.knownGenePep.name (via affyGnfU74ADistance.query) mm9.knownIsoforms.transcript (via affyGnfU74ADistance.query) mm9.knownToAllenBrain.name (via affyGnfU74ADistance.query) mm9.knownToEnsembl.name (via affyGnfU74ADistance.query) mm9.knownToGnfAtlas2.name (via affyGnfU74ADistance.query) mm9.knownToKeggEntrez.name (via affyGnfU74ADistance.query) mm9.knownToLocusLink.name (via affyGnfU74ADistance.query) mm9.knownToPfam.name (via affyGnfU74ADistance.query) mm9.knownToRefSeq.name (via affyGnfU74ADistance.query) mm9.knownToSuper.gene (via affyGnfU74ADistance.query) mm9.knownToVisiGene.name (via affyGnfU74ADistance.query) mm9.rnBlastTab.query (via affyGnfU74ADistance.query) mm9.scBlastTab.query (via affyGnfU74ADistance.query) mm9.ucscScop.ucscId (via affyGnfU74ADistance.query)

Sample Rows

query	target	distance
uc009cfv.1	uc009cfv.1	0
uc009cfv.1	uc012enc.1	0.751126
uc009cfv.1	uc012end.1	0.790967
uc009cfv.1	uc008grx.1	0.798083
uc009cfv.1	uc008grw.1	0.798083
uc009cfv.1	uc007hnh.1	0.811893
uc009cfv.1	uc007hng.1	0.811893
uc009cfv.1	uc008cbs.1	0.826945
uc009cfv.1	uc007kpi.2	0.855592
uc009cfv.1	uc008sps.2	0.884606

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