Schema for gnfAtlas2Distance
  Database: mm8    Primary Table: gnfAtlas2Distance    Row Count: 22,937,000   Data last updated: 2006-03-09
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query NM_009126varchar(255) Query gene. Indexed
target NM_009126varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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)
      mm8.affyGnfU74ADistance.query (via gnfAtlas2Distance.query)
      mm8.affyGnfU74ADistance.target (via gnfAtlas2Distance.query)
      mm8.affyGnfU74BDistance.query (via gnfAtlas2Distance.query)
      mm8.affyGnfU74BDistance.target (via gnfAtlas2Distance.query)
      mm8.affyGnfU74CDistance.query (via gnfAtlas2Distance.query)
      mm8.affyGnfU74CDistance.target (via gnfAtlas2Distance.query)
      mm8.ccdsKgMap.geneId (via gnfAtlas2Distance.query)
      mm8.ceBlastTab.query (via gnfAtlas2Distance.query)
      mm8.dmBlastTab.query (via gnfAtlas2Distance.query)
      mm8.drBlastTab.query (via gnfAtlas2Distance.query)
      mm8.dupSpMrna.mrnaID (via gnfAtlas2Distance.query)
      mm8.foldUtr3.name (via gnfAtlas2Distance.query)
      mm8.foldUtr5.name (via gnfAtlas2Distance.query)
      mm8.hgBlastTab.query (via gnfAtlas2Distance.query)
      mm8.keggPathway.kgID (via gnfAtlas2Distance.query)
      mm8.kgAlias.kgID (via gnfAtlas2Distance.query)
      mm8.kgProtAlias.kgID (via gnfAtlas2Distance.query)
      mm8.kgSpAlias.kgID (via gnfAtlas2Distance.query)
      mm8.kgTargetAli.qName (via gnfAtlas2Distance.query)
      mm8.kgXref.kgID (via gnfAtlas2Distance.query)
      mm8.knownBlastTab.query (via gnfAtlas2Distance.query)
      mm8.knownBlastTab.target (via gnfAtlas2Distance.query)
      mm8.knownCanonical.transcript (via gnfAtlas2Distance.query)
      mm8.knownGene.name (via gnfAtlas2Distance.query)
      mm8.knownGeneMrna.name (via gnfAtlas2Distance.query)
      mm8.knownGenePep.name (via gnfAtlas2Distance.query)
      mm8.knownIsoforms.transcript (via gnfAtlas2Distance.query)
      mm8.knownToAllenBrain.name (via gnfAtlas2Distance.query)
      mm8.knownToEnsembl.name (via gnfAtlas2Distance.query)
      mm8.knownToGnfAtlas2.name (via gnfAtlas2Distance.query)
      mm8.knownToKeggEntrez.name (via gnfAtlas2Distance.query)
      mm8.knownToLocusLink.name (via gnfAtlas2Distance.query)
      mm8.knownToPfam.name (via gnfAtlas2Distance.query)
      mm8.knownToRefSeq.name (via gnfAtlas2Distance.query)
      mm8.knownToSuper.gene (via gnfAtlas2Distance.query)
      mm8.knownToVisiGene.name (via gnfAtlas2Distance.query)
      mm8.rnBlastTab.query (via gnfAtlas2Distance.query)
      mm8.scBlastTab.query (via gnfAtlas2Distance.query)

Sample Rows
 
querytargetdistance
NM_009126NM_0091260
NM_009126AK0432660.829262
NM_009126AB0875050.829262
NM_009126NM_0271320.829262
NM_009126NM_0084760.840066
NM_009126AK1326400.849557
NM_009126NM_0196450.861361
NM_009126NM_0198210.863131
NM_009126NM_0010180790.865
NM_009126BC0590930.869656

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