Schema for ccdsKgMap
  Database: mm8    Primary Table: ccdsKgMap    Row Count: 13,992   Data last updated: 2008-05-03
Format description: mapping between CCDS ids and Known Genes by similarity
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ccdsId CCDS14803.1varchar(32) values CCDS id with version
geneId NM_001011874varchar(255) values Id of other gene
chrom chr1varchar(255) values Chromosome or scaffold of other gene
chromStart 3204562int(10) unsigned range Chromosome start of other gene
chromEnd 3661579int(10) unsigned range Chromosome end of other gene
cdsSimilarity 1float range CDS similarity by genomic overlap

Connected Tables and Joining Fields
        mm8.ccdsGene.name (via ccdsKgMap.ccdsId)
      mm8.ccdsInfo.ccds (via ccdsKgMap.ccdsId)
      knownGeneV39.bioCycPathway.kgID (via ccdsKgMap.geneId)
      knownGeneV39.ceBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.dmBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.drBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.foldUtr3.name (via ccdsKgMap.geneId)
      knownGeneV39.foldUtr5.name (via ccdsKgMap.geneId)
      knownGeneV39.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      knownGeneV39.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      knownGeneV39.kgAlias.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgColor.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgProtAlias.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgSpAlias.kgID (via ccdsKgMap.geneId)
      knownGeneV39.kgTargetAli.qName (via ccdsKgMap.geneId)
      knownGeneV39.kgXref.kgID (via ccdsKgMap.geneId)
      knownGeneV39.knownAttrs.kgID (via ccdsKgMap.geneId)
      knownGeneV39.knownBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.knownBlastTab.target (via ccdsKgMap.geneId)
      knownGeneV39.knownCanonical.protein (via ccdsKgMap.geneId)
      knownGeneV39.knownCanonical.transcript (via ccdsKgMap.geneId)
      knownGeneV39.knownCds.name (via ccdsKgMap.geneId)
      knownGeneV39.knownGene.name (via ccdsKgMap.geneId)
      knownGeneV39.knownGeneMrna.name (via ccdsKgMap.geneId)
      knownGeneV39.knownGenePep.name (via ccdsKgMap.geneId)
      knownGeneV39.knownIsoforms.transcript (via ccdsKgMap.geneId)
      knownGeneV39.knownToEnsembl.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToHprd.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToLocusLink.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToMrna.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToMrnaSingle.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToMupit.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToPfam.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToRefSeq.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToSuper.gene (via ccdsKgMap.geneId)
      knownGeneV39.knownToTag.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToU133.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToU95.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToVisiGene.name (via ccdsKgMap.geneId)
      knownGeneV39.knownToWikipedia.name (via ccdsKgMap.geneId)
      knownGeneV39.mmBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.rnBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.scBlastTab.query (via ccdsKgMap.geneId)
      knownGeneV39.ucscScop.ucscId (via ccdsKgMap.geneId)
      mm8.affyGnfU74ADistance.query (via ccdsKgMap.geneId)
      mm8.affyGnfU74ADistance.target (via ccdsKgMap.geneId)
      mm8.affyGnfU74BDistance.query (via ccdsKgMap.geneId)
      mm8.affyGnfU74BDistance.target (via ccdsKgMap.geneId)
      mm8.affyGnfU74CDistance.query (via ccdsKgMap.geneId)
      mm8.affyGnfU74CDistance.target (via ccdsKgMap.geneId)
      mm8.ceBlastTab.query (via ccdsKgMap.geneId)
      mm8.dmBlastTab.query (via ccdsKgMap.geneId)
      mm8.drBlastTab.query (via ccdsKgMap.geneId)
      mm8.dupSpMrna.mrnaID (via ccdsKgMap.geneId)
      mm8.foldUtr3.name (via ccdsKgMap.geneId)
      mm8.foldUtr5.name (via ccdsKgMap.geneId)
      mm8.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      mm8.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      mm8.hgBlastTab.query (via ccdsKgMap.geneId)
      mm8.keggPathway.kgID (via ccdsKgMap.geneId)
      mm8.kgAlias.kgID (via ccdsKgMap.geneId)
      mm8.kgProtAlias.kgID (via ccdsKgMap.geneId)
      mm8.kgSpAlias.kgID (via ccdsKgMap.geneId)
      mm8.kgTargetAli.qName (via ccdsKgMap.geneId)
      mm8.kgXref.kgID (via ccdsKgMap.geneId)
      mm8.knownBlastTab.query (via ccdsKgMap.geneId)
      mm8.knownBlastTab.target (via ccdsKgMap.geneId)
      mm8.knownCanonical.transcript (via ccdsKgMap.geneId)
      mm8.knownGene.name (via ccdsKgMap.geneId)
      mm8.knownGeneMrna.name (via ccdsKgMap.geneId)
      mm8.knownGenePep.name (via ccdsKgMap.geneId)
      mm8.knownIsoforms.transcript (via ccdsKgMap.geneId)
      mm8.knownToAllenBrain.name (via ccdsKgMap.geneId)
      mm8.knownToEnsembl.name (via ccdsKgMap.geneId)
      mm8.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      mm8.knownToKeggEntrez.name (via ccdsKgMap.geneId)
      mm8.knownToLocusLink.name (via ccdsKgMap.geneId)
      mm8.knownToPfam.name (via ccdsKgMap.geneId)
      mm8.knownToRefSeq.name (via ccdsKgMap.geneId)
      mm8.knownToSuper.gene (via ccdsKgMap.geneId)
      mm8.knownToVisiGene.name (via ccdsKgMap.geneId)
      mm8.rnBlastTab.query (via ccdsKgMap.geneId)
      mm8.scBlastTab.query (via ccdsKgMap.geneId)

Sample Rows
 
ccdsIdgeneIdchromchromStartchromEndcdsSimilarity
CCDS14803.1NM_001011874chr1320456236615791
CCDS14804.1NM_011283chr1433422543504731
CCDS14805.1NM_011441chr1448100844864941
CCDS14806.1NM_008866chr1479797348368151
CCDS14807.1NM_021374chr1490032550095071
CCDS14808.1NM_133826chr1507325351526301
CCDS14809.1NM_011011chr1557857355929471
CCDS14810.1NM_173868chr1672013168510211
CCDS14811.1NM_021511chr1953065595326651
CCDS14812.1NM_175236chr1953329395631821

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