
--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `jobid` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `ip` varchar(16) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `seqid` varchar(100) NOT NULL DEFAULT '',
  `status` enum('incomplete','queued','processing','done','failed','deleted') NOT NULL DEFAULT 'incomplete',
  `host` varchar(40) NOT NULL,
  `seq` text NOT NULL,
  `offset` smallint(6) NOT NULL DEFAULT '0',
  `public` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`jobid`),
  KEY `email` (`email`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=125106 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `job_pdbs`
--

DROP TABLE IF EXISTS `job_pdbs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_pdbs` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `pdbid` varchar(4) NOT NULL DEFAULT '',
  `ref` int(11) NOT NULL DEFAULT '0',
  `identity` float(5,3) NOT NULL DEFAULT '0.000',
  `pdb` text NOT NULL,
  `dss` text NOT NULL,
  `annotation` text NOT NULL,
  `dss_raw` longtext,
  KEY `jobid` (`jobid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `job_prolinks`
--

DROP TABLE IF EXISTS `job_prolinks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_prolinks` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `hit` int(11) NOT NULL DEFAULT '0',
  `seq_id` int(11) NOT NULL DEFAULT '0',
  `gene_id` int(11) NOT NULL DEFAULT '0',
  `gene_id_b` int(11) NOT NULL DEFAULT '0',
  `p` double NOT NULL DEFAULT '0',
  `confidence` double NOT NULL DEFAULT '0',
  `method` enum('PP','GN','RS','GC','TL','CE','MP') NOT NULL DEFAULT 'PP',
  `annotation` varchar(100) NOT NULL DEFAULT '',
  `seq_id_b` int(11) NOT NULL DEFAULT '0',
  `hit_b` int(11) NOT NULL DEFAULT '0',
  `gene_name` varchar(10) NOT NULL DEFAULT '',
  KEY `jobid` (`jobid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `job_psipred`
--

DROP TABLE IF EXISTS `job_psipred`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_psipred` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `pred` text NOT NULL,
  PRIMARY KEY (`jobid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;





--
-- Table structure for table `job_graphs`
--

DROP TABLE IF EXISTS `job_graphs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_graphs` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `type` enum('ss','ss_all','entropy','score','blast') NOT NULL DEFAULT 'ss',
  `data` mediumblob NOT NULL,
  `added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`jobid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;



--
-- Table structure for table `job_clusters`
--

DROP TABLE IF EXISTS `job_clusters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_clusters` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `score` float NOT NULL DEFAULT '0',
  `start` smallint(6) NOT NULL DEFAULT '0',
  `end` smallint(6) NOT NULL DEFAULT '0',
  `selstart` smallint(6) NOT NULL DEFAULT '0',
  `selend` smallint(6) NOT NULL DEFAULT '0',
  `scoring` text NOT NULL,
  `best` varchar(200) NOT NULL DEFAULT '',
  `bscore` float(10,4) NOT NULL DEFAULT '0.0000',
  KEY `jobid` (`jobid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;



--
-- Table structure for table `job_blocks`
--

DROP TABLE IF EXISTS `job_blocks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_blocks` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `family` varchar(10) NOT NULL DEFAULT '',
  `annotation` varchar(80) NOT NULL DEFAULT '',
  `matched_blocks` smallint(6) NOT NULL DEFAULT '0',
  `total_blocks` smallint(6) NOT NULL DEFAULT '0',
  `e_value` double NOT NULL DEFAULT '0',
  `hits` text NOT NULL,
  KEY `jobid` (`jobid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `job_blast`
--

DROP TABLE IF EXISTS `job_blast`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_blast` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `hit` int(11) NOT NULL DEFAULT '0',
  `seqid` float(5,2) NOT NULL DEFAULT '0.00',
  `accession` varchar(80) NOT NULL DEFAULT '',
  `def` text,
  `bits` float NOT NULL DEFAULT '0',
  `score` float NOT NULL DEFAULT '0',
  `evalue` double NOT NULL DEFAULT '0',
  `qfrom` smallint(6) NOT NULL DEFAULT '0',
  `qto` smallint(6) NOT NULL DEFAULT '0',
  `hfrom` smallint(6) NOT NULL DEFAULT '0',
  `hto` smallint(6) NOT NULL DEFAULT '0',
  `identity` smallint(6) NOT NULL DEFAULT '0',
  `positive` smallint(6) NOT NULL DEFAULT '0',
  `gaps` tinyint(4) NOT NULL DEFAULT '0',
  `alignlen` smallint(6) NOT NULL DEFAULT '0',
  `len` smallint(6) NOT NULL DEFAULT '0',
  `qseq` text NOT NULL,
  `hseq` text NOT NULL,
  `midline` text NOT NULL,
  `refs` text NOT NULL,
  `main_ref` varchar(200) NOT NULL DEFAULT '',
  UNIQUE KEY `jobid` (`jobid`,`hit`),
  KEY `jobid_2` (`jobid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY LINEAR HASH (jobid)
PARTITIONS 10 */;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `job_blast_pdb`
--

DROP TABLE IF EXISTS `job_blast_pdb`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_blast_pdb` (
  `jobid` int(11) NOT NULL DEFAULT '0',
  `hit` int(11) NOT NULL DEFAULT '0',
  `seqid` float(5,2) NOT NULL DEFAULT '0.00',
  `accession` varchar(80) NOT NULL DEFAULT '',
  `def` longtext,
  `bits` float NOT NULL DEFAULT '0',
  `score` float NOT NULL DEFAULT '0',
  `evalue` double NOT NULL DEFAULT '0',
  `qfrom` smallint(6) NOT NULL DEFAULT '0',
  `qto` smallint(6) NOT NULL DEFAULT '0',
  `hfrom` smallint(6) NOT NULL DEFAULT '0',
  `hto` smallint(6) NOT NULL DEFAULT '0',
  `identity` smallint(6) NOT NULL DEFAULT '0',
  `positive` smallint(6) NOT NULL DEFAULT '0',
  `gaps` tinyint(4) NOT NULL DEFAULT '0',
  `alignlen` smallint(6) NOT NULL DEFAULT '0',
  `len` smallint(6) NOT NULL DEFAULT '0',
  `qseq` text NOT NULL,
  `hseq` text NOT NULL,
  `midline` text NOT NULL,
  `refs` text NOT NULL,
  `main_ref` varchar(200) NOT NULL DEFAULT '',
  UNIQUE KEY `jobid` (`jobid`,`hit`),
  KEY `jobid_2` (`jobid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY LINEAR HASH (jobid)
PARTITIONS 10 */;
/*!40101 SET character_set_client = @saved_cs_client */;




