# MySQL dump 8.14
#
# Host: localhost    Database: hg12
#--------------------------------------------------------
# Server version	3.23.41

#
# Table structure for table 'stsInfo2'
#

CREATE TABLE stsInfo2 (
  identNo int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  gbCount int(10) unsigned NOT NULL default '0',
  genbank longblob,
  gdbCount int(10) unsigned NOT NULL default '0',
  gdb longblob,
  nameCount int(10) unsigned NOT NULL default '0',
  otherNames longblob,
  dbSTSid int(10) unsigned default NULL,
  otherDbstsCount int(10) unsigned NOT NULL default '0',
  otherDbSTS longblob,
  leftPrimer varchar(255) default NULL,
  rightPrimer varchar(255) default NULL,
  distance varchar(255) default NULL,
  organism varchar(255) NOT NULL default '',
  sequence int(10) unsigned NOT NULL default '0',
  otherUCSCcount int(10) unsigned NOT NULL default '0',
  otherUCSC longblob,
  mergeUCSCcount int(10) unsigned NOT NULL default '0',
  mergeUCSC longblob,
  genethonName varchar(255) default NULL,
  genethonChr varchar(255) default NULL,
  genethonPos float default NULL,
  genethonLOD float default NULL,
  marshfieldName varchar(255) default NULL,
  marshfieldChr varchar(255) default NULL,
  marshfieldPos float default NULL,
  marshfieldLOD float default NULL,
  wiyacName varchar(255) default NULL,
  wiyacChr varchar(255) default NULL,
  wiyacPos float default NULL,
  wiyacLOD float default NULL,
  wirhName varchar(255) default NULL,
  wirhChr varchar(255) default NULL,
  wirhPos float default NULL,
  wirhLOD float default NULL,
  gm99gb4Name varchar(255) default NULL,
  gm99gb4Chr varchar(255) default NULL,
  gm99gb4Pos float default NULL,
  gm99gb4LOD float default NULL,
  gm99g3Name varchar(255) default NULL,
  gm99g3Chr varchar(255) default NULL,
  gm99g3Pos float default NULL,
  gm99g3LOD float default NULL,
  tngName varchar(255) default NULL,
  tngChr varchar(255) default NULL,
  tngPos float default NULL,
  tngLOD float default NULL,
  decodeName varchar(255) default NULL,
  decodeChr varchar(255) default NULL,
  decodePos float default NULL,
  decodeLOD float default NULL,
  PRIMARY KEY  (identNo)
) TYPE=MyISAM;
