-- MySQL dump 9.11
--
-- Host: localhost    Database: cage_analysis
-- ------------------------------------------------------
-- Server version	4.0.20-log

--
-- Table structure for table `te_summary`
--

CREATE TABLE te_summary (
  te_id int(11) NOT NULL default '0',
  chr_no varchar(6) NOT NULL default '',
  chr_id tinyint(4) NOT NULL default '0',
  strand char(1) NOT NULL default '',
  start_pos int(11) NOT NULL default '0',
  end_pos int(11) NOT NULL default '0',
  cage_tags int(11) NOT NULL default '0',
  CTSSs int(11) NOT NULL default '0',
  basic_TSSs int(11) NOT NULL default '0',
  library_TSSs int(11) NOT NULL default '0',
  riken_TSSs int(11) NOT NULL default '0',
  represent_gene_id varchar(49) NOT NULL default '',
  PRIMARY KEY  (te_id),
  KEY represent_gene_id (represent_gene_id),
  KEY chr_no (chr_no),
  KEY end_pos (end_pos),
  KEY basic_TSSs (basic_TSSs),
  KEY CTSSs (CTSSs),
  KEY strand (strand),
  KEY library_TSSs (library_TSSs),
  KEY chr_id (chr_id),
  KEY start_pos (start_pos),
  KEY riken_TSSs (riken_TSSs),
  KEY cage_tags (cage_tags)
) TYPE=MyISAM;
