
DROP TABLE IF EXISTS `Job`;
CREATE TABLE `Job` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `uuid` char(36) NOT NULL,
  `status` varchar(255) NOT NULL,
  `timeCreated` datetime DEFAULT NULL,
  `timeStarted` datetime DEFAULT NULL,
  `timeCompleted` datetime DEFAULT NULL,
  `efi_db_version` varchar(255) DEFAULT NULL,
  `results` longtext DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `isPublic` tinyint(1) NOT NULL,
  `parentJob_id` int(11) DEFAULT NULL,
  `job_type` varchar(255) NOT NULL,
  `blastQuery` text DEFAULT NULL,
  `blastMaxSequences` int(11) DEFAULT NULL,
  `blastDatabase` varchar(255) DEFAULT NULL,
  `blastEValue` int(11) DEFAULT NULL,
  `domain` tinyint(1) DEFAULT NULL,
  `domainRegion` varchar(255) DEFAULT NULL,
  `inputFasta` longtext DEFAULT NULL,
  `filterByFamilies` varchar(255) DEFAULT NULL,
  `accessionIds` varchar(255) DEFAULT NULL,
  `domainFamily` varchar(255) DEFAULT NULL,
  `uploadedFilename` varchar(255) DEFAULT NULL,
  `sequenceDatabase` varchar(255) DEFAULT NULL,
  `exclude_fragments` tinyint(1) DEFAULT NULL,
  `minLength` int(11) DEFAULT NULL,
  `maxLength` int(11) DEFAULT NULL,
  `maxBlastSequences` int(11) DEFAULT NULL,
  `blastSequence` longtext DEFAULT NULL,
  `eValue` int(11) DEFAULT NULL,
  `maxSeqMSA` int(11) DEFAULT NULL,
  `minSeqMSA` int(11) DEFAULT NULL,
  `cooccurrence` double DEFAULT NULL,
  `neighborhood_size` int(11) DEFAULT NULL,
  `referenceDatabase` varchar(255) DEFAULT NULL,
  `cdhitSequenceIdentity` int(11) DEFAULT NULL,
  `searchType` varchar(255) DEFAULT NULL,
  `allByAllBlastEValue` int(11) DEFAULT NULL,
  `jobName` varchar(255) DEFAULT NULL,
  `excludeFragments` tinyint(1) DEFAULT NULL,
  `families` text DEFAULT NULL,
  `sequence_version` varchar(255) DEFAULT NULL,
  `fraction` int(11) DEFAULT NULL,
  `taxSearch` varchar(255) DEFAULT NULL,
  `taxSearchName` varchar(255) DEFAULT NULL,
  `alignmentScore` double DEFAULT NULL,
  `alignmentScoreThreshold` double DEFAULT NULL,
  `computeNeighborhoodConnectivity` tinyint(1) DEFAULT NULL,
  `fastaInput` varchar(255) DEFAULT NULL,
  `metagenomes` longtext DEFAULT NULL,
  `isExample` tinyint(1) DEFAULT NULL,
  `numBlastSeqRetr` int(11) DEFAULT NULL,
  `numMatchedIds` int(11) DEFAULT NULL,
  `numUnmatchedIds` int(11) DEFAULT NULL,
  `numFamilyOverlap` int(11) DEFAULT NULL,
  `numNonFamily` int(11) DEFAULT NULL,
  `numUnirefFamilyOverlap` int(11) DEFAULT NULL,
  `numComputedSequences` int(11) DEFAULT NULL,
  `numUniqueSequences` int(11) DEFAULT NULL,
  `numBlastEdges` int(11) DEFAULT NULL,
  `numUnirefClusters` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

--
-- Dumping data for table `Job`
--

INSERT INTO `Job` VALUES (1,1,'1f040bce-14b7-6ec4-80ce-0f5bbdf66bfa','new','2025-06-03 20:54:02',NULL,NULL,NULL,NULL,'noberg@illinois.edu',0,NULL,'est_generate_families',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,'test',1,'pf05544',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

