-- MySQL dump 9.11
--
-- Host: localhost    Database: hg16
-- ------------------------------------------------------
-- Server version	4.0.24

--
-- Table structure for table `encodeEgaspFullGeneIdU12`
--

CREATE TABLE encodeEgaspFullGeneIdU12 (
  name varchar(255) NOT NULL default '',
  chrom varchar(255) NOT NULL default '',
  strand char(1) NOT NULL default '',
  txStart int(10) unsigned NOT NULL default '0',
  txEnd int(10) unsigned NOT NULL default '0',
  cdsStart int(10) unsigned NOT NULL default '0',
  cdsEnd int(10) unsigned NOT NULL default '0',
  exonCount int(10) unsigned NOT NULL default '0',
  exonStarts longblob NOT NULL,
  exonEnds longblob NOT NULL,
  id int(10) unsigned NOT NULL auto_increment,
  name2 varchar(255) NOT NULL default '',
  cdsStartStat enum('none','unk','incmpl','cmpl') NOT NULL default 'none',
  cdsEndStat enum('none','unk','incmpl','cmpl') NOT NULL default 'none',
  exonFrames longblob NOT NULL,
  PRIMARY KEY  (id),
  KEY name2 (name2(10)),
  KEY name (name(12)),
  KEY chrom (chrom(6),txStart),
  KEY chrom_2 (chrom(6),txEnd)
) ENGINE=MyISAM;
