Schema for ccdsKgMap
  Database: mm9    Primary Table: ccdsKgMap    Row Count: 30,190   Data last updated: 2019-03-13
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 uc007aeu.1varchar(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
        mm9.ccdsGene.name (via ccdsKgMap.ccdsId)
      mm9.ccdsInfo.ccds (via ccdsKgMap.ccdsId)
      mm9.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)
      mm9.affyGnfU74ADistance.query (via ccdsKgMap.geneId)
      mm9.affyGnfU74ADistance.target (via ccdsKgMap.geneId)
      mm9.affyGnfU74BDistance.query (via ccdsKgMap.geneId)
      mm9.affyGnfU74BDistance.target (via ccdsKgMap.geneId)
      mm9.affyGnfU74CDistance.query (via ccdsKgMap.geneId)
      mm9.affyGnfU74CDistance.target (via ccdsKgMap.geneId)
      mm9.bioCycPathway.kgID (via ccdsKgMap.geneId)
      mm9.ceBlastTab.query (via ccdsKgMap.geneId)
      mm9.dmBlastTab.query (via ccdsKgMap.geneId)
      mm9.drBlastTab.query (via ccdsKgMap.geneId)
      mm9.foldUtr3.name (via ccdsKgMap.geneId)
      mm9.foldUtr5.name (via ccdsKgMap.geneId)
      mm9.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      mm9.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      mm9.hgBlastTab.query (via ccdsKgMap.geneId)
      mm9.keggPathway.kgID (via ccdsKgMap.geneId)
      mm9.kgAlias.kgID (via ccdsKgMap.geneId)
      mm9.kgColor.kgID (via ccdsKgMap.geneId)
      mm9.kgProtAlias.kgID (via ccdsKgMap.geneId)
      mm9.kgProtMap2.qName (via ccdsKgMap.geneId)
      mm9.kgSpAlias.kgID (via ccdsKgMap.geneId)
      mm9.kgTargetAli.qName (via ccdsKgMap.geneId)
      mm9.kgTxInfo.name (via ccdsKgMap.geneId)
      mm9.kgXref.kgID (via ccdsKgMap.geneId)
      mm9.knownBlastTab.query (via ccdsKgMap.geneId)
      mm9.knownBlastTab.target (via ccdsKgMap.geneId)
      mm9.knownCanonical.protein (via ccdsKgMap.geneId)
      mm9.knownCanonical.transcript (via ccdsKgMap.geneId)
      mm9.knownGene.name (via ccdsKgMap.geneId)
      mm9.knownGeneMrna.name (via ccdsKgMap.geneId)
      mm9.knownGenePep.name (via ccdsKgMap.geneId)
      mm9.knownIsoforms.transcript (via ccdsKgMap.geneId)
      mm9.knownToAllenBrain.name (via ccdsKgMap.geneId)
      mm9.knownToEnsembl.name (via ccdsKgMap.geneId)
      mm9.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      mm9.knownToKeggEntrez.name (via ccdsKgMap.geneId)
      mm9.knownToLocusLink.name (via ccdsKgMap.geneId)
      mm9.knownToPfam.name (via ccdsKgMap.geneId)
      mm9.knownToRefSeq.name (via ccdsKgMap.geneId)
      mm9.knownToSuper.gene (via ccdsKgMap.geneId)
      mm9.knownToVisiGene.name (via ccdsKgMap.geneId)
      mm9.rnBlastTab.query (via ccdsKgMap.geneId)
      mm9.scBlastTab.query (via ccdsKgMap.geneId)
      mm9.ucscScop.ucscId (via ccdsKgMap.geneId)

Sample Rows
 
ccdsIdgeneIdchromchromStartchromEndcdsSimilarity
CCDS14803.1uc007aeu.1chr1320456236615791
CCDS14804.1uc007aex.2chr1433358743503951
CCDS14805.1uc007aey.1chr1448100844838161
CCDS14805.1uc007aez.1chr1448100844864941
CCDS14805.1uc007afc.1chr1448100844864941
CCDS35504.1uc007afd.2chr1476327847758071
CCDS48211.1uc007aff.2chr1476327847758071
CCDS14806.1uc007afh.1chr1479797348368161
CCDS35505.1uc007afi.2chr1484777448879901
CCDS35505.1uc011wht.1chr1484777448879900.996689

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