Schema for affyGnfU74BDistance

Database: mm9 Primary Table: affyGnfU74BDistance Row Count: 12,478,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`	uc012eje.1	`varchar(255)`	Name of one gene
`target`	uc011wjc.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 affyGnfU74BDistance.query) knownGeneV39.ceBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.dmBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.drBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.foldUtr3.name (via affyGnfU74BDistance.query) knownGeneV39.foldUtr5.name (via affyGnfU74BDistance.query) knownGeneV39.gnfAtlas2Distance.query (via affyGnfU74BDistance.query) knownGeneV39.gnfAtlas2Distance.target (via affyGnfU74BDistance.query) knownGeneV39.kgAlias.kgID (via affyGnfU74BDistance.query) knownGeneV39.kgColor.kgID (via affyGnfU74BDistance.query) knownGeneV39.kgProtAlias.kgID (via affyGnfU74BDistance.query) knownGeneV39.kgSpAlias.kgID (via affyGnfU74BDistance.query) knownGeneV39.kgTargetAli.qName (via affyGnfU74BDistance.query) knownGeneV39.kgXref.kgID (via affyGnfU74BDistance.query) knownGeneV39.knownAttrs.kgID (via affyGnfU74BDistance.query) knownGeneV39.knownBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.knownBlastTab.target (via affyGnfU74BDistance.query) knownGeneV39.knownCanonical.protein (via affyGnfU74BDistance.query) knownGeneV39.knownCanonical.transcript (via affyGnfU74BDistance.query) knownGeneV39.knownCds.name (via affyGnfU74BDistance.query) knownGeneV39.knownGene.name (via affyGnfU74BDistance.query) knownGeneV39.knownGeneMrna.name (via affyGnfU74BDistance.query) knownGeneV39.knownGenePep.name (via affyGnfU74BDistance.query) knownGeneV39.knownIsoforms.transcript (via affyGnfU74BDistance.query) knownGeneV39.knownToEnsembl.name (via affyGnfU74BDistance.query) knownGeneV39.knownToGnfAtlas2.name (via affyGnfU74BDistance.query) knownGeneV39.knownToHprd.name (via affyGnfU74BDistance.query) knownGeneV39.knownToLocusLink.name (via affyGnfU74BDistance.query) knownGeneV39.knownToMrna.name (via affyGnfU74BDistance.query) knownGeneV39.knownToMrnaSingle.name (via affyGnfU74BDistance.query) knownGeneV39.knownToMupit.name (via affyGnfU74BDistance.query) knownGeneV39.knownToPfam.name (via affyGnfU74BDistance.query) knownGeneV39.knownToRefSeq.name (via affyGnfU74BDistance.query) knownGeneV39.knownToSuper.gene (via affyGnfU74BDistance.query) knownGeneV39.knownToTag.name (via affyGnfU74BDistance.query) knownGeneV39.knownToU133.name (via affyGnfU74BDistance.query) knownGeneV39.knownToU95.name (via affyGnfU74BDistance.query) knownGeneV39.knownToVisiGene.name (via affyGnfU74BDistance.query) knownGeneV39.knownToWikipedia.name (via affyGnfU74BDistance.query) knownGeneV39.mmBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.rnBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.scBlastTab.query (via affyGnfU74BDistance.query) knownGeneV39.ucscScop.ucscId (via affyGnfU74BDistance.query) mm9.affyGnfU74ADistance.query (via affyGnfU74BDistance.query) mm9.affyGnfU74ADistance.target (via affyGnfU74BDistance.query) mm9.affyGnfU74CDistance.query (via affyGnfU74BDistance.query) mm9.affyGnfU74CDistance.target (via affyGnfU74BDistance.query) mm9.bioCycPathway.kgID (via affyGnfU74BDistance.query) mm9.ccdsKgMap.geneId (via affyGnfU74BDistance.query) mm9.ceBlastTab.query (via affyGnfU74BDistance.query) mm9.dmBlastTab.query (via affyGnfU74BDistance.query) mm9.drBlastTab.query (via affyGnfU74BDistance.query) mm9.foldUtr3.name (via affyGnfU74BDistance.query) mm9.foldUtr5.name (via affyGnfU74BDistance.query) mm9.gnfAtlas2Distance.query (via affyGnfU74BDistance.query) mm9.gnfAtlas2Distance.target (via affyGnfU74BDistance.query) mm9.hgBlastTab.query (via affyGnfU74BDistance.query) mm9.keggPathway.kgID (via affyGnfU74BDistance.query) mm9.kgAlias.kgID (via affyGnfU74BDistance.query) mm9.kgColor.kgID (via affyGnfU74BDistance.query) mm9.kgProtAlias.kgID (via affyGnfU74BDistance.query) mm9.kgProtMap2.qName (via affyGnfU74BDistance.query) mm9.kgSpAlias.kgID (via affyGnfU74BDistance.query) mm9.kgTargetAli.qName (via affyGnfU74BDistance.query) mm9.kgTxInfo.name (via affyGnfU74BDistance.query) mm9.kgXref.kgID (via affyGnfU74BDistance.query) mm9.knownBlastTab.query (via affyGnfU74BDistance.query) mm9.knownBlastTab.target (via affyGnfU74BDistance.query) mm9.knownCanonical.protein (via affyGnfU74BDistance.query) mm9.knownCanonical.transcript (via affyGnfU74BDistance.query) mm9.knownGene.name (via affyGnfU74BDistance.query) mm9.knownGeneMrna.name (via affyGnfU74BDistance.query) mm9.knownGenePep.name (via affyGnfU74BDistance.query) mm9.knownIsoforms.transcript (via affyGnfU74BDistance.query) mm9.knownToAllenBrain.name (via affyGnfU74BDistance.query) mm9.knownToEnsembl.name (via affyGnfU74BDistance.query) mm9.knownToGnfAtlas2.name (via affyGnfU74BDistance.query) mm9.knownToKeggEntrez.name (via affyGnfU74BDistance.query) mm9.knownToLocusLink.name (via affyGnfU74BDistance.query) mm9.knownToPfam.name (via affyGnfU74BDistance.query) mm9.knownToRefSeq.name (via affyGnfU74BDistance.query) mm9.knownToSuper.gene (via affyGnfU74BDistance.query) mm9.knownToVisiGene.name (via affyGnfU74BDistance.query) mm9.rnBlastTab.query (via affyGnfU74BDistance.query) mm9.scBlastTab.query (via affyGnfU74BDistance.query) mm9.ucscScop.ucscId (via affyGnfU74BDistance.query)

Sample Rows

query	target	distance
uc012eje.1	uc011wjc.1	0
uc012eje.1	uc007bes.1	0
uc012eje.1	uc011wlz.1	0
uc012eje.1	uc011wmi.1	0
uc012eje.1	uc007bhm.1	0
uc012eje.1	uc007bjq.1	0
uc012eje.1	uc007bjp.1	0
uc012eje.1	uc011wmq.1	0
uc012eje.1	uc007bjs.2	0
uc012eje.1	uc011wms.1	0

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