Schema for ccdsKgMap
  Database: mm10    Primary Table: ccdsKgMap    Row Count: 43,477   Data last updated: 2019-09-20
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 ENSMUST00000070533.4varchar(255) values Id of other gene
chrom chr1varchar(255) values Chromosome or scaffold of other gene
chromStart 3214481int(10) unsigned range Chromosome start of other gene
chromEnd 3671498int(10) unsigned range Chromosome end of other gene
cdsSimilarity 1float range CDS similarity by genomic overlap

Connected Tables and Joining Fields
        mm10.ccdsGene.name (via ccdsKgMap.ccdsId)
      mm10.ccdsInfo.ccds (via ccdsKgMap.ccdsId)
      mm10.ccdsNotes.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)
      mm10.bioCycPathway.kgID (via ccdsKgMap.geneId)
      mm10.ceBlastTab.query (via ccdsKgMap.geneId)
      mm10.dmBlastTab.query (via ccdsKgMap.geneId)
      mm10.drBlastTab.query (via ccdsKgMap.geneId)
      mm10.foldUtr3.name (via ccdsKgMap.geneId)
      mm10.foldUtr5.name (via ccdsKgMap.geneId)
      mm10.hgBlastTab.query (via ccdsKgMap.geneId)
      mm10.keggPathway.kgID (via ccdsKgMap.geneId)
      mm10.kgAlias.kgID (via ccdsKgMap.geneId)
      mm10.kgColor.kgID (via ccdsKgMap.geneId)
      mm10.kgProtAlias.kgID (via ccdsKgMap.geneId)
      mm10.kgProtMap2.qName (via ccdsKgMap.geneId)
      mm10.kgSpAlias.kgID (via ccdsKgMap.geneId)
      mm10.kgTargetAli.qName (via ccdsKgMap.geneId)
      mm10.kgTxInfo.name (via ccdsKgMap.geneId)
      mm10.kgXref.kgID (via ccdsKgMap.geneId)
      mm10.knownAttrs.kgID (via ccdsKgMap.geneId)
      mm10.knownBlastTab.query (via ccdsKgMap.geneId)
      mm10.knownBlastTab.target (via ccdsKgMap.geneId)
      mm10.knownCanonical.transcript (via ccdsKgMap.geneId)
      mm10.knownCds.name (via ccdsKgMap.geneId)
      mm10.knownGene.name (via ccdsKgMap.geneId)
      mm10.knownGeneMrna.name (via ccdsKgMap.geneId)
      mm10.knownGenePep.name (via ccdsKgMap.geneId)
      mm10.knownIsoforms.transcript (via ccdsKgMap.geneId)
      mm10.knownToEnsembl.name (via ccdsKgMap.geneId)
      mm10.knownToKeggEntrez.name (via ccdsKgMap.geneId)
      mm10.knownToLocusLink.name (via ccdsKgMap.geneId)
      mm10.knownToLynx.name (via ccdsKgMap.geneId)
      mm10.knownToMrna.name (via ccdsKgMap.geneId)
      mm10.knownToMrnaSingle.name (via ccdsKgMap.geneId)
      mm10.knownToPfam.name (via ccdsKgMap.geneId)
      mm10.knownToRefSeq.name (via ccdsKgMap.geneId)
      mm10.knownToSuper.gene (via ccdsKgMap.geneId)
      mm10.knownToTag.name (via ccdsKgMap.geneId)
      mm10.knownToVisiGene.name (via ccdsKgMap.geneId)
      mm10.knownToWikipedia.name (via ccdsKgMap.geneId)
      mm10.rnBlastTab.query (via ccdsKgMap.geneId)
      mm10.scBlastTab.query (via ccdsKgMap.geneId)
      mm10.ucscScop.ucscId (via ccdsKgMap.geneId)

Sample Rows
 
ccdsIdgeneIdchromchromStartchromEndcdsSimilarity
CCDS14803.1ENSMUST00000070533.4chr1321448136714981
CCDS78537.1ENSMUST00000194992.6chr1429298044091871
CCDS14804.1ENSMUST00000027032.5chr1434414543603141
CCDS78539.1ENSMUST00000192650.5chr1449138944973541
CCDS78538.1ENSMUST00000195555.1chr1449124944967571
CCDS14805.1ENSMUST00000027035.9chr1449093044964131
CCDS14805.1ENSMUST00000116652.7chr1449171244963631
CCDS35504.1ENSMUST00000130201.7chr1477320547857101
CCDS48211.1ENSMUST00000156816.6chr1477321047857391
CCDS14806.1ENSMUST00000027036.10chr1480782248467391

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