Schema for ccdsInfo
  Database: mm8    Primary Table: ccdsInfo    Row Count: 27,825   Data last updated: 2008-05-03
Format description: Consensus CDS information, links CCDS ids to NCBI and Hinxton accessions
On download server: MariaDB table dump directory
fieldexampleSQL type info description
ccds CCDS14803.1char(12) values CCDS id
srcDb Hchar(1) values source database: N=NCBI, H=Hinxton
mrnaAcc ENSMUST00000070533char(18) values mRNA accession (NCBI or Hinxton)
protAcc ENSMUSP00000070648char(18) values protein accession (NCBI or Hinxton)

Connected Tables and Joining Fields
        mm8.ccdsGene.name (via ccdsInfo.ccds)
      mm8.ccdsKgMap.ccdsId (via ccdsInfo.ccds)
      hgFixed.gbCdnaInfo.acc (via ccdsInfo.mrnaAcc)
      hgFixed.gbSeq.acc (via ccdsInfo.mrnaAcc)
      hgFixed.imageClone.acc (via ccdsInfo.mrnaAcc)
      hgFixed.refLink.mrnaAcc (via ccdsInfo.mrnaAcc)
      hgFixed.refSeqStatus.mrnaAcc (via ccdsInfo.mrnaAcc)
      hgFixed.refSeqSummary.mrnaAcc (via ccdsInfo.mrnaAcc)
      knownGeneV39.kgXref.refseq (via ccdsInfo.mrnaAcc)
      knownGeneV39.knownToRefSeq.value (via ccdsInfo.mrnaAcc)
      mm8.dupSpMrna.dupMrnaID (via ccdsInfo.mrnaAcc)
      mm8.dupSpMrna.mrnaID (via ccdsInfo.mrnaAcc)
      mm8.ensGene.name (via ccdsInfo.mrnaAcc)
      mm8.kgXref.refseq (via ccdsInfo.mrnaAcc)
      mm8.knownToRefSeq.value (via ccdsInfo.mrnaAcc)
      mm8.mrnaOrientInfo.name (via ccdsInfo.mrnaAcc)
      mm8.mrnaRefseq.mrna (via ccdsInfo.mrnaAcc)
      mm8.mrnaRefseq.refseq (via ccdsInfo.mrnaAcc)
      mm8.refFlat.name (via ccdsInfo.mrnaAcc)
      mm8.refGene.name (via ccdsInfo.mrnaAcc)
      mm8.refSeqAli.qName (via ccdsInfo.mrnaAcc)

Sample Rows
 
ccdssrcDbmrnaAccprotAcc
CCDS14803.1HENSMUST00000070533ENSMUSP00000070648
CCDS14803.1NNM_001011874.1NP_001011874.1
CCDS14804.1HENSMUST00000027032ENSMUSP00000027032
CCDS14804.1NNM_011283.1NP_035413.1
CCDS14805.1HENSMUST00000027035ENSMUSP00000027035
CCDS14805.1NNM_011441.4NP_035571.1
CCDS14806.1HENSMUST00000027036ENSMUSP00000027036
CCDS14806.1NNM_008866.2NP_032892.1
CCDS14807.1HENSMUST00000002533ENSMUSP00000002533
CCDS14807.1NNM_021374.3NP_067349.2

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