Schema for affyGnfU74CDistance

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

Sample Rows

query	target	distance
uc007rsx.1	uc007rsy.1	0
uc007rsx.1	uc011zeg.1	0
uc007rsx.1	uc007rsx.1	0
uc007rsx.1	uc007fab.1	0.589761
uc007rsx.1	uc007fac.1	0.589761
uc007rsx.1	uc011xdp.1	0.589761
uc007rsx.1	uc007faa.2	0.589761
uc007rsx.1	uc009rrc.1	0.643265
uc007rsx.1	uc009rrb.1	0.643265
uc007rsx.1	uc007cpc.1	0.65489

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