Schema for gnfAtlas2Distance

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

Sample Rows

query	target	distance
uc007otg.1	uc007otg.1	0
uc007otg.1	uc007otf.1	0
uc007otg.1	uc011yqd.1	0
uc007otg.1	uc007ote.1	0
uc007otg.1	uc007icu.1	0.215197
uc007otg.1	uc009elb.2	0.21918
uc007otg.1	uc009ela.2	0.21918
uc007otg.1	uc012hgs.1	0.219869
uc007otg.1	uc009tce.2	0.219869
uc007otg.1	uc008kpw.1	0.225738

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