-- MySQL dump 8.22
--
-- Host: localhost    Database: hg12
---------------------------------------------------------
-- Server version	3.23.56

--
-- Table structure for table 'genomicSuperDups'
--

CREATE TABLE genomicSuperDups (
  chrom varchar(255) NOT NULL default '',
  chromStart int(10) unsigned NOT NULL default '0',
  chromEnd int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  score int(10) unsigned NOT NULL default '0',
  strand char(1) NOT NULL default '',
  otherChrom varchar(255) NOT NULL default '',
  otherStart int(10) unsigned NOT NULL default '0',
  otherEnd int(10) unsigned NOT NULL default '0',
  otherSize int(10) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  posBasesHit int(10) unsigned NOT NULL default '0',
  testResult varchar(255) NOT NULL default '',
  verdict varchar(255) NOT NULL default '',
  chits varchar(255) NOT NULL default '',
  ccov varchar(255) NOT NULL default '',
  alignfile varchar(255) NOT NULL default '',
  alignL int(10) unsigned NOT NULL default '0',
  indelN int(10) unsigned NOT NULL default '0',
  indelS int(10) unsigned NOT NULL default '0',
  alignB int(10) unsigned NOT NULL default '0',
  matchB int(10) unsigned NOT NULL default '0',
  mismatchB int(10) unsigned NOT NULL default '0',
  transitionsB int(10) unsigned NOT NULL default '0',
  transversionsB int(10) unsigned NOT NULL default '0',
  fracMatch float NOT NULL default '0',
  fracMatchIndel float NOT NULL default '0',
  jcK float NOT NULL default '0',
  k2K float NOT NULL default '0',
  PRIMARY KEY  (name),
  KEY chrom (chrom),
  KEY chromStart (chromStart),
  KEY chromEnd (chromEnd)
) TYPE=MyISAM;
