Schema for ccdsKgMap
  Database: hg17    Primary Table: ccdsKgMap    Row Count: 17,230   Data last updated: 2008-02-01
Format description: mapping between CCDS ids and Known Genes by similarity
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ccdsId CCDS2.1varchar(32) values CCDS id with version
geneId BC024295varchar(255) values Id of other gene
chrom chr1varchar(255) values Chromosome or scaffold of other gene
chromStart 911288int(10) unsigned range Chromosome start of other gene
chromEnd 920097int(10) unsigned range Chromosome end of other gene
cdsSimilarity 0.967807float range CDS similarity by genomic overlap

Connected Tables and Joining Fields
        hg17.ccdsGene.name (via ccdsKgMap.ccdsId)
      hg17.ccdsInfo.ccds (via ccdsKgMap.ccdsId)
      hg17.bioCycPathway.kgID (via ccdsKgMap.geneId)
      hg17.ceBlastTab.query (via ccdsKgMap.geneId)
      hg17.dmBlastTab.query (via ccdsKgMap.geneId)
      hg17.drBlastTab.query (via ccdsKgMap.geneId)
      hg17.dupSpMrna.mrnaID (via ccdsKgMap.geneId)
      hg17.foldUtr3.name (via ccdsKgMap.geneId)
      hg17.foldUtr5.name (via ccdsKgMap.geneId)
      hg17.gladHumESDistance.query (via ccdsKgMap.geneId)
      hg17.gladHumESDistance.target (via ccdsKgMap.geneId)
      hg17.gnfAtlas2Distance.query (via ccdsKgMap.geneId)
      hg17.gnfAtlas2Distance.target (via ccdsKgMap.geneId)
      hg17.gnfU95Distance.query (via ccdsKgMap.geneId)
      hg17.gnfU95Distance.target (via ccdsKgMap.geneId)
      hg17.humanHprdP2P.query (via ccdsKgMap.geneId)
      hg17.humanHprdP2P.target (via ccdsKgMap.geneId)
      hg17.humanVidalP2P.query (via ccdsKgMap.geneId)
      hg17.humanVidalP2P.target (via ccdsKgMap.geneId)
      hg17.humanWankerP2P.query (via ccdsKgMap.geneId)
      hg17.humanWankerP2P.target (via ccdsKgMap.geneId)
      hg17.keggPathway.kgID (via ccdsKgMap.geneId)
      hg17.kgAlias.kgID (via ccdsKgMap.geneId)
      hg17.kgProtAlias.kgID (via ccdsKgMap.geneId)
      hg17.kgSpAlias.kgID (via ccdsKgMap.geneId)
      hg17.kgTargetAli.qName (via ccdsKgMap.geneId)
      hg17.kgXref.kgID (via ccdsKgMap.geneId)
      hg17.knownBlastTab.query (via ccdsKgMap.geneId)
      hg17.knownBlastTab.target (via ccdsKgMap.geneId)
      hg17.knownCanonical.transcript (via ccdsKgMap.geneId)
      hg17.knownExpDistance.query (via ccdsKgMap.geneId)
      hg17.knownExpDistance.target (via ccdsKgMap.geneId)
      hg17.knownGene.name (via ccdsKgMap.geneId)
      hg17.knownGeneLink.name (via ccdsKgMap.geneId)
      hg17.knownGeneMrna.name (via ccdsKgMap.geneId)
      hg17.knownGenePep.name (via ccdsKgMap.geneId)
      hg17.knownIsoforms.transcript (via ccdsKgMap.geneId)
      hg17.knownToAllenBrain.name (via ccdsKgMap.geneId)
      hg17.knownToEnsembl.name (via ccdsKgMap.geneId)
      hg17.knownToGnf1h.name (via ccdsKgMap.geneId)
      hg17.knownToGnfAtlas2.name (via ccdsKgMap.geneId)
      hg17.knownToHInv.name (via ccdsKgMap.geneId)
      hg17.knownToHprd.name (via ccdsKgMap.geneId)
      hg17.knownToKeggEntrez.name (via ccdsKgMap.geneId)
      hg17.knownToLocusLink.name (via ccdsKgMap.geneId)
      hg17.knownToPfam.name (via ccdsKgMap.geneId)
      hg17.knownToRefSeq.name (via ccdsKgMap.geneId)
      hg17.knownToSuper.gene (via ccdsKgMap.geneId)
      hg17.knownToU133.name (via ccdsKgMap.geneId)
      hg17.knownToU133Plus2.name (via ccdsKgMap.geneId)
      hg17.knownToU95.name (via ccdsKgMap.geneId)
      hg17.knownToVisiGene.name (via ccdsKgMap.geneId)
      hg17.mmBlastTab.query (via ccdsKgMap.geneId)
      hg17.rankProp.query (via ccdsKgMap.geneId)
      hg17.rankProp.target (via ccdsKgMap.geneId)
      hg17.rnBlastTab.query (via ccdsKgMap.geneId)
      hg17.scBlastTab.query (via ccdsKgMap.geneId)
      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)

Sample Rows
 
ccdsIdgeneIdchromchromStartchromEndcdsSimilarity
CCDS2.1BC024295chr19112889200970.967807
CCDS2.1NM_152486chr19148329201041
CCDS3.1NM_015658chr19197389347741
CCDS4.1NM_032129chr19419439505491
CCDS5.1NM_021170chr19744119755371
CCDS6.1NM_005101chr19889459899861
CCDS7.1NM_017891chr1105712710913921
CCDS8.1NM_153254chr1115499911611641
CCDS9.1NM_148901chr1117881111820121
CCDS10.1NM_004195chr1117881111820121

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