Schema for ccdsGene
  Database: hg17    Primary Table: ccdsGene    Row Count: 14,332   Data last updated: 2008-02-01
Format description: A gene prediction.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 73smallint(5) unsigned range Indexing field to speed chromosome range queries.
name CCDS2.1varchar(255) values Name of gene
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
strand +char(1) values + or - for strand
txStart 914832int(10) unsigned range Transcription start position (or end position for minus strand item)
txEnd 919676int(10) unsigned range Transcription end position (or start position for minus strand item)
cdsStart 914832int(10) unsigned range Coding region start (or end position for minus strand item)
cdsEnd 919676int(10) unsigned range Coding region end (or start position for minus strand item)
exonCount 8int(10) unsigned range Number of exons
exonStarts 914832,916666,917658,917932...longblob   Exon start positions (or end positions for minus strand item)
exonEnds 914983,916829,917774,918011...longblob   Exon end positions (or start positions for minus strand item)
id 1int(10) unsigned range  
name2  varchar(255) values  
cdsStartStat cmplenum('none', 'unk', 'incmpl', 'cmpl') values  
cdsEndStat cmplenum('none', 'unk', 'incmpl', 'cmpl') values  
exonFrames 0,1,2,1,2,1,0,0,longblob    

Connected Tables and Joining Fields
        hg17.ccdsInfo.ccds (via ccdsGene.name)
      hg17.ccdsKgMap.ccdsId (via ccdsGene.name)

Sample Rows
 
binnamechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsidname2cdsStartStatcdsEndStatexonFrames
73CCDS2.1chr1+9148329196769148329196768914832,916666,917658,917932,918081,918775,919220,919430,914983,916829,917774,918011,918581,918900,919331,919676,1cmplcmpl0,1,2,1,2,1,0,0,
592CCDS3.1chr1-92021693476392021693476319920216,920579,921040,921695,921924,923653,924012,926649,927522,927934,928697,929304,929526,931445,931617,932416,932621,934451,93 ...920323,920669,921176,921809,922068,923755,924126,926761,927662,928123,928811,929415,929605,931536,931738,932548,932796,934604,93 ...2cmplcmpl1,1,0,0,0,0,0,2,0,0,0,0,2,1,0,0,2,2,0,
592CCDS4.1chr1+94197895002294197895002216941978,942150,945723,945967,946132,946325,946559,946770,947521,947734,948307,948632,948946,949279,949762,949888,942061,942250,945870,946048,946205,946453,946655,946851,947597,947871,948457,948773,949087,949498,949811,950022,3cmplcmpl0,2,0,0,0,1,0,0,0,1,0,0,0,0,0,1,
592CCDS5.1chr1-9745059754209745059754204974505,974972,975138,975312,974879,975060,975234,975420,4cmplcmpl1,0,0,0,
592CCDS6.1chr1+9890209899259890209899252989020,989430,989023,989925,5cmplcmpl0,0,
593CCDS7.1chr1-105819510624811058195106248151058195,1059217,1059783,1061180,1062441,1058290,1059686,1059809,1061315,1062481,6cmplcmpl1,0,1,1,0,
593CCDS8.1chr1+115535611604451155356116044581155356,1155785,1156033,1157043,1157663,1158178,1159222,1160271,1155643,1155904,1156163,1157118,1157749,1158350,1159394,1160445,7cmplcmpl0,2,1,2,2,1,2,0,
74CCDS9.1chr1-117889311818741178893118187441178893,1179701,1180672,1181687,1179263,1179789,1180795,1181874,8cmplcmpl2,1,1,0,
74CCDS10.1chr1-117914611818741179146118187451179146,1179336,1179701,1180672,1181687,1179271,1179539,1179789,1180795,1181874,9cmplcmpl1,2,1,1,0,
594CCDS11.1chr1-118685711894301186857118943071186857,1187006,1187244,1187940,1188294,1188965,1189285,1186928,1187135,1187441,1188007,1188396,1189088,1189430,10cmplcmpl1,1,2,1,1,1,0,

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