-- acanthochromis_polyacanthus_core_100_1.analysis definition

CREATE TABLE `analysis` (
  `analysis_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime DEFAULT NULL,
  `logic_name` varchar(128) NOT NULL,
  `db` varchar(120) DEFAULT NULL,
  `db_version` varchar(40) DEFAULT NULL,
  `db_file` varchar(120) DEFAULT NULL,
  `program` varchar(80) DEFAULT NULL,
  `program_version` varchar(40) DEFAULT NULL,
  `program_file` varchar(80) DEFAULT NULL,
  `parameters` text,
  `module` varchar(80) DEFAULT NULL,
  `module_version` varchar(40) DEFAULT NULL,
  `gff_source` varchar(40) DEFAULT NULL,
  `gff_feature` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`analysis_id`),
  UNIQUE KEY `logic_name_idx` (`logic_name`)
) ENGINE=MyISAM AUTO_INCREMENT=179 DEFAULT CHARSET=latin1;

INSERT INTO acanthochromis_polyacanthus_core_100_1.analysis (created,logic_name,db,db_version,db_file,program,program_version,program_file,parameters,module,module_version,gff_source,gff_feature) VALUES
	 ('2018-05-14 17:25:39','repeatmask_repbase_teleost',NULL,NULL,NULL,NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/RepeatMasker','-nolow -species "Teleostei" -engine "crossmatch"','HiveRepeatMasker',NULL,NULL,NULL),
	 ('2018-05-14 21:21:06','dust',NULL,NULL,NULL,NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/dustmasker',NULL,'HiveDust',NULL,NULL,NULL),
	 ('2018-05-14 21:21:49','trf',NULL,NULL,NULL,NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/trf',NULL,'HiveTRF',NULL,NULL,NULL),
	 ('2018-05-14 21:25:06','eponine',NULL,NULL,NULL,NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/java','-epojar => /nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/opt/eponine/libexec/eponine-scan.jar, -threshold => 0.999','HiveEponine',NULL,NULL,NULL),
	 ('2018-05-14 21:25:13','cpg',NULL,NULL,NULL,NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/cpg_lh',NULL,'HiveCPG',NULL,NULL,NULL),
	 ('2018-05-14 21:25:55','trnascan',NULL,NULL,NULL,NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/tRNAscan-SE',NULL,'HiveTRNAScan',NULL,NULL,NULL),
	 ('2018-05-14 21:30:40','genscan','HumanIso.smat',NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/share/HumanIso.smat',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/genscan',NULL,'HiveGenscan',NULL,NULL,NULL),
	 ('2018-05-14 21:37:44','uniprot',NULL,NULL,'/hps/nobackup2/production/ensembl/genebuild/blastdb/uniprot/uniprot_2018_04/uniprot_vertebrate',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/blastp','-num_threads 3 -window_size 40',NULL,NULL,NULL,NULL),
	 ('2018-05-14 21:48:09','vertrna',NULL,NULL,'/hps/nobackup2/production/ensembl/genebuild/blastdb/vertrna/134/embl_vertrna-1',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/tblastn','-num_threads 3 -window_size 40',NULL,NULL,NULL,NULL),
	 ('2018-05-14 21:56:46','unigene',NULL,NULL,'/hps/nobackup2/production/ensembl/genebuild/blastdb/unigene/unigene',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/tblastn','-num_threads 3 -window_size 40',NULL,NULL,NULL,NULL);
INSERT INTO acanthochromis_polyacanthus_core_100_1.analysis (created,logic_name,db,db_version,db_file,program,program_version,program_file,parameters,module,module_version,gff_source,gff_feature) VALUES
	 ('2018-06-29 12:36:10','ensembl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2018-05-16 07:54:18','ncrna',NULL,NULL,'/hps/nobackup2/production/ensembl/genebuild/blastdb/ncrna/ncrna_2016_05/',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/opt/infernal10/bin/cmsearch',NULL,'HiveInfernal',NULL,NULL,NULL),
	 ('2018-05-16 00:55:05','rfamblast',NULL,NULL,'/hps/nobackup2/production/ensembl/genebuild/blastdb/ncrna/ncrna_2016_05/filtered.fasta',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/blastn',' -num_threads 3 -word_size 12 -num_alignments 5000  -num_descriptions 5000 -max_hsps 1 ','HiveBlastRfam',NULL,NULL,NULL),
	 ('2018-05-16 00:39:46','blastmirna',NULL,NULL,'/hps/nobackup2/production/ensembl/genebuild/blastdb/ncrna/mirbase_22/all_mirnas.fa',NULL,NULL,'/nfs/software/ensembl/RHEL7-JUL2017-core2/linuxbrew/bin/blastn',' -num_threads 3 ','HiveBlastmiRNA',NULL,NULL,NULL),
	 ('2018-06-24 08:55:14','merged_rnaseq_ise',NULL,NULL,NULL,NULL,NULL,NULL,'-num_threads 3 -window_size 40','Bio::EnsEMBL::Analysis::Hive::RunnableDB::HiveBlastRNASeqPep',NULL,NULL,NULL),
	 ('2018-05-16 00:25:10','best_targetted',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2018-07-02 17:08:13','other_protein','uniprot',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2018-07-02 17:08:13','projected_transcript','danio_rerio_core_92_11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:09:20','cdd','CDD','3.17',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:23:31','hamap','HAMAP','2019_01',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO acanthochromis_polyacanthus_core_100_1.analysis (created,logic_name,db,db_version,db_file,program,program_version,program_file,parameters,module,module_version,gff_source,gff_feature) VALUES
	 ('2020-01-16 14:15:47','gene3d','Gene3D','4.2.0',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:32:02','pfam','Pfam','32.0',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:22:08','hmmpanther','PANTHER','14.1',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 15:12:10','pirsf','PIRSF','3.02',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:28:03','pfscan','Prosite_profiles','2019_01',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:42:16','scanprosite','Prosite_patterns','2019_01',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:38:14','prints','PRINTS','42.0',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:51:30','smart','Smart','7.1',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:42:26','sfld','SFLD','4',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:48:17','tigrfam','TIGRfam','15.0',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO acanthochromis_polyacanthus_core_100_1.analysis (created,logic_name,db,db_version,db_file,program,program_version,program_file,parameters,module,module_version,gff_source,gff_feature) VALUES
	 ('2020-01-16 14:48:09','superfamily','SuperFamily','1.75',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:58:00','ncoils','ncoils','2.2.1',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:56:46','mobidblite','MobiDBLite','2.0',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 15:01:06','tmhmm','TMHMM','2.0c',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 14:58:48','signalp','SignalP','4.1',NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 15:06:21','seg','Seg',NULL,NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 15:06:48','interpro2go','InterPro2GO',NULL,NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-01-16 15:08:47','interpro2pathway','InterPro2Pathway',NULL,NULL,'InterProScan','5.39-77.0',NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2018-07-25 11:41:10','xrefexoneratedna',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2018-07-25 11:41:10','xrefexonerateprotein',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO acanthochromis_polyacanthus_core_100_1.analysis (created,logic_name,db,db_version,db_file,program,program_version,program_file,parameters,module,module_version,gff_source,gff_feature) VALUES
	 ('2018-07-25 11:42:12','xrefchecksum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-02-20 10:00:50','goa_import','GO',NULL,NULL,'goa_import',NULL,NULL,NULL,NULL,NULL,NULL,NULL),
	 ('2020-02-19 15:09:49','xref_projection',NULL,NULL,NULL,'xref_projection',NULL,NULL,NULL,NULL,NULL,NULL,NULL);