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

--
-- Table structure for table `tss_summary`
--

CREATE TABLE tss_summary (
  tss_id varchar(24) NOT NULL default '',
  tss_type varchar(12) NOT NULL default '',
  priming_type varchar(10) default '[NULL]',
  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',
  represent_type varchar(12) NOT NULL default '',
  represent_pos int(11) NOT NULL default '0',
  CTSSs int(11) NOT NULL default '0',
  cage_tags int(11) NOT NULL default '0',
  gis_di_tags int(11) NOT NULL default '0',
  gsc_di_tags int(11) NOT NULL default '0',
  EPD_TSSs int(11) NOT NULL default '0',
  DBTSSs int(11) NOT NULL default '0',
  long_SAGEs int(11) NOT NULL default '0',
  mRNA_five_primes int(11) NOT NULL default '0',
  mRNA_EST_five_primes int(11) NOT NULL default '0',
  gis_di_tag_regions int(11) NOT NULL default '0',
  gsc_di_tag_regions int(11) NOT NULL default '0',
  mRNA_regions int(11) NOT NULL default '0',
  mRNA_up1000s int(11) NOT NULL default '0',
  mRNA_first_exons int(11) NOT NULL default '0',
  mRNA_other_exons int(11) NOT NULL default '0',
  mRNA_introns int(11) NOT NULL default '0',
  mRNA_EST_regions int(11) NOT NULL default '0',
  mRNA_EST_up1000s int(11) NOT NULL default '0',
  mRNA_EST_first_exons int(11) NOT NULL default '0',
  mRNA_EST_other_exons int(11) NOT NULL default '0',
  mRNA_EST_introns int(11) NOT NULL default '0',
  is_TATA tinyint(1) NOT NULL default '0',
  is_Initiator tinyint(1) NOT NULL default '0',
  is_BRE tinyint(1) NOT NULL default '0',
  is_DPE tinyint(1) NOT NULL default '0',
  is_PSE tinyint(1) NOT NULL default '0',
  percent_cpg_island float default NULL,
  percent_conserved_region float default NULL,
  CDSs int(11) NOT NULL default '0',
  PRIMARY KEY  (tss_id),
  KEY chr_id (chr_id),
  KEY gsc_di_tag_regions (gsc_di_tag_regions),
  KEY chr_no (chr_no),
  KEY mRNA_EST_first_exons (mRNA_EST_first_exons),
  KEY gis_di_tags (gis_di_tags),
  KEY represent_type (represent_type),
  KEY mRNA_five_primes (mRNA_five_primes),
  KEY mRNA_up1000s (mRNA_up1000s),
  KEY gis_di_tag_regions (gis_di_tag_regions),
  KEY mRNA_first_exons (mRNA_first_exons),
  KEY mRNA_EST_other_exons (mRNA_EST_other_exons),
  KEY start_pos (start_pos),
  KEY gsc_di_tags (gsc_di_tags),
  KEY mRNA_introns (mRNA_introns),
  KEY tss_type (tss_type),
  KEY mRNA_EST_up1000s (mRNA_EST_up1000s),
  KEY represent_pos (represent_pos),
  KEY DBTSSs (DBTSSs),
  KEY mRNA_other_exons (mRNA_other_exons),
  KEY strand (strand),
  KEY cage_tags (cage_tags),
  KEY mRNA_EST_introns (mRNA_EST_introns),
  KEY mRNA_regions (mRNA_regions),
  KEY CTSSs (CTSSs),
  KEY end_pos (end_pos),
  KEY EPD_TSSs (EPD_TSSs),
  KEY long_SAGEs (long_SAGEs),
  KEY priming_type (priming_type),
  KEY mRNA_EST_five_primes (mRNA_EST_five_primes),
  KEY mRNA_EST_regions (mRNA_EST_regions)
) TYPE=MyISAM;

