Schema for ccdsInfo
  Database: mm10    Primary Table: ccdsInfo    Row Count: 95,025   Data last updated: 2019-10-03
Format description: Consensus CDS information, links CCDS ids to NCBI and Hinxton accessions
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
        mm10.ccdsGene.name (via ccdsInfo.ccds)
      mm10.ccdsKgMap.ccdsId (via ccdsInfo.ccds)
      mm10.ccdsNotes.ccds (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)
      mm10.kgXref.refseq (via ccdsInfo.mrnaAcc)
      mm10.knownToRefSeq.value (via ccdsInfo.mrnaAcc)
      mm10.mrnaOrientInfo.name (via ccdsInfo.mrnaAcc)
      mm10.refFlat.name (via ccdsInfo.mrnaAcc)
      mm10.refGene.name (via ccdsInfo.mrnaAcc)
      mm10.refSeqAli.qName (via ccdsInfo.mrnaAcc)

Sample Rows
 
ccdssrcDbmrnaAccprotAcc
CCDS14803.1HENSMUST00000070533ENSMUSP00000070648
CCDS14803.1NNM_001011874.1NP_001011874.1
CCDS14803.1HOTTMUST00000065166OTTMUSP00000032437
CCDS14803.1NXM_006495550.3XP_006495613.1
CCDS14804.1HENSMUST00000027032ENSMUSP00000027032
CCDS14804.1NNM_011283.2NP_035413.1
CCDS14804.1HOTTMUST00000127195OTTMUSP00000068684
CCDS14805.1HENSMUST00000027035ENSMUSP00000027035
CCDS14805.1HENSMUST00000116652ENSMUSP00000112351
CCDS14805.1NNM_001289464.1NP_001276393.1

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