Skip to main content
Schema for affyGnfU74CDistance
  Database: mm8    Primary Table: affyGnfU74CDistance    Row Count: 2,181,000   Data last updated: 2006-03-10
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_173868varchar(255) Name of one gene
target NM_173868varchar(255) Name of other gene
distance 0float 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)
      mm8.affyGnfU74ADistance.query (via affyGnfU74CDistance.query)
      mm8.affyGnfU74ADistance.target (via affyGnfU74CDistance.query)
      mm8.affyGnfU74BDistance.query (via affyGnfU74CDistance.query)
      mm8.affyGnfU74BDistance.target (via affyGnfU74CDistance.query)
      mm8.ccdsKgMap.geneId (via affyGnfU74CDistance.query)
      mm8.ceBlastTab.query (via affyGnfU74CDistance.query)
      mm8.dmBlastTab.query (via affyGnfU74CDistance.query)
      mm8.drBlastTab.query (via affyGnfU74CDistance.query)
      mm8.dupSpMrna.mrnaID (via affyGnfU74CDistance.query)
      mm8.foldUtr3.name (via affyGnfU74CDistance.query)
      mm8.foldUtr5.name (via affyGnfU74CDistance.query)
      mm8.gnfAtlas2Distance.query (via affyGnfU74CDistance.query)
      mm8.gnfAtlas2Distance.target (via affyGnfU74CDistance.query)
      mm8.hgBlastTab.query (via affyGnfU74CDistance.query)
      mm8.keggPathway.kgID (via affyGnfU74CDistance.query)
      mm8.kgAlias.kgID (via affyGnfU74CDistance.query)
      mm8.kgProtAlias.kgID (via affyGnfU74CDistance.query)
      mm8.kgSpAlias.kgID (via affyGnfU74CDistance.query)
      mm8.kgTargetAli.qName (via affyGnfU74CDistance.query)
      mm8.kgXref.kgID (via affyGnfU74CDistance.query)
      mm8.knownBlastTab.query (via affyGnfU74CDistance.query)
      mm8.knownBlastTab.target (via affyGnfU74CDistance.query)
      mm8.knownCanonical.transcript (via affyGnfU74CDistance.query)
      mm8.knownGene.name (via affyGnfU74CDistance.query)
      mm8.knownGeneMrna.name (via affyGnfU74CDistance.query)
      mm8.knownGenePep.name (via affyGnfU74CDistance.query)
      mm8.knownIsoforms.transcript (via affyGnfU74CDistance.query)
      mm8.knownToAllenBrain.name (via affyGnfU74CDistance.query)
      mm8.knownToEnsembl.name (via affyGnfU74CDistance.query)
      mm8.knownToGnfAtlas2.name (via affyGnfU74CDistance.query)
      mm8.knownToKeggEntrez.name (via affyGnfU74CDistance.query)
      mm8.knownToLocusLink.name (via affyGnfU74CDistance.query)
      mm8.knownToPfam.name (via affyGnfU74CDistance.query)
      mm8.knownToRefSeq.name (via affyGnfU74CDistance.query)
      mm8.knownToSuper.gene (via affyGnfU74CDistance.query)
      mm8.knownToVisiGene.name (via affyGnfU74CDistance.query)
      mm8.rnBlastTab.query (via affyGnfU74CDistance.query)
      mm8.scBlastTab.query (via affyGnfU74CDistance.query)

Sample Rows
 
querytargetdistance
NM_173868NM_1738680
NM_173868NM_1445570.597561
NM_173868NM_1831560.619989
NM_173868NM_1392930.639217
NM_173868AF4895710.639217
NM_173868AF4895690.639217
NM_173868AF4895700.639217
NM_173868NM_1451230.645707
NM_173868NM_0281120.651781
NM_173868NM_1781430.654369

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