-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 22, 2018 at 02:22 PM
-- Server version: 5.5.58-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.22

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `spneu`
--
CREATE DATABASE IF NOT EXISTS `spneu` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `spneu`;

-- --------------------------------------------------------

--
-- Table structure for table `SPV_cond_legend`
--

CREATE TABLE IF NOT EXISTS `SPV_cond_legend` (
  `recordID` int(11) NOT NULL AUTO_INCREMENT,
  `cond_rs` varchar(4) NOT NULL,
  `sample1` varchar(3) NOT NULL,
  `sample2` varchar(3) NOT NULL,
  `description` text NOT NULL,
  `cond_order` tinyint(4) NOT NULL,
  PRIMARY KEY (`recordID`),
  UNIQUE KEY `recordID` (`recordID`),
  KEY `recordID_2` (`recordID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Table structure for table `SPV_cond_significance`
--

CREATE TABLE IF NOT EXISTS `SPV_cond_significance` (
  `recordID` int(11) NOT NULL AUTO_INCREMENT,
  `cond_V` varchar(4) NOT NULL,
  `base` varchar(4) NOT NULL,
  `comparison` varchar(4) NOT NULL,
  `complement` varchar(2) NOT NULL,
  PRIMARY KEY (`recordID`),
  UNIQUE KEY `recordID` (`recordID`),
  KEY `recordID_2` (`recordID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=463 ;

-- --------------------------------------------------------

--
-- Table structure for table `SPV_cond_sign_matrix`
--

CREATE TABLE IF NOT EXISTS `SPV_cond_sign_matrix` (
  `recordID` int(11) NOT NULL AUTO_INCREMENT,
  `gene_id` text NOT NULL,
  `V001` text NOT NULL,
  `V002` text NOT NULL,
  `V003` text NOT NULL,
  `V004` text NOT NULL,
  `V005` text NOT NULL,
  `V006` text NOT NULL,
  `V007` text NOT NULL,
  `V008` text NOT NULL,
  `V009` text NOT NULL,
  `V010` text NOT NULL,
  `V011` text NOT NULL,
  `V012` text NOT NULL,
  `V013` text NOT NULL,
  `V014` text NOT NULL,
  `V015` text NOT NULL,
  `V016` text NOT NULL,
  `V017` text NOT NULL,
  `V018` text NOT NULL,
  `V019` text NOT NULL,
  `V020` text NOT NULL,
  `V021` text NOT NULL,
  `V022` text NOT NULL,
  `V023` text NOT NULL,
  `V024` text NOT NULL,
  `V025` text NOT NULL,
  `V026` text NOT NULL,
  `V027` text NOT NULL,
  `V028` text NOT NULL,
  `V029` text NOT NULL,
  `V030` text NOT NULL,
  `V031` text NOT NULL,
  `V032` text NOT NULL,
  `V033` text NOT NULL,
  `V034` text NOT NULL,
  `V035` text NOT NULL,
  `V036` text NOT NULL,
  `V037` text NOT NULL,
  `V038` text NOT NULL,
  `V039` text NOT NULL,
  `V040` text NOT NULL,
  `V041` text NOT NULL,
  `V042` text NOT NULL,
  `V043` text NOT NULL,
  `V044` text NOT NULL,
  `V045` text NOT NULL,
  `V046` text NOT NULL,
  `V047` text NOT NULL,
  `V048` text NOT NULL,
  `V049` text NOT NULL,
  `V050` text NOT NULL,
  `V051` text NOT NULL,
  `V052` text NOT NULL,
  `V053` text NOT NULL,
  `V054` text NOT NULL,
  `V055` text NOT NULL,
  `V056` text NOT NULL,
  `V057` text NOT NULL,
  `V058` text NOT NULL,
  `V059` text NOT NULL,
  `V060` text NOT NULL,
  `V061` text NOT NULL,
  `V062` text NOT NULL,
  `V063` text NOT NULL,
  `V064` text NOT NULL,
  `V065` text NOT NULL,
  `V066` text NOT NULL,
  `V067` text NOT NULL,
  `V068` text NOT NULL,
  `V069` text NOT NULL,
  `V070` text NOT NULL,
  `V071` text NOT NULL,
  `V072` text NOT NULL,
  `V073` text NOT NULL,
  `V074` text NOT NULL,
  `V075` text NOT NULL,
  `V076` text NOT NULL,
  `V077` text NOT NULL,
  `V078` text NOT NULL,
  `V079` text NOT NULL,
  `V080` text NOT NULL,
  `V081` text NOT NULL,
  `V082` text NOT NULL,
  `V083` text NOT NULL,
  `V084` text NOT NULL,
  `V085` text NOT NULL,
  `V086` text NOT NULL,
  `V087` text NOT NULL,
  `V088` text NOT NULL,
  `V089` text NOT NULL,
  `V090` text NOT NULL,
  `V091` text NOT NULL,
  `V092` text NOT NULL,
  `V093` text NOT NULL,
  `V094` text NOT NULL,
  `V095` text NOT NULL,
  `V096` text NOT NULL,
  `V097` text NOT NULL,
  `V098` text NOT NULL,
  `V099` text NOT NULL,
  `V100` text NOT NULL,
  `V101` text NOT NULL,
  `V102` text NOT NULL,
  `V103` text NOT NULL,
  `V104` text NOT NULL,
  `V105` text NOT NULL,
  `V106` text NOT NULL,
  `V107` text NOT NULL,
  `V108` text NOT NULL,
  `V109` text NOT NULL,
  `V110` text NOT NULL,
  `V111` text NOT NULL,
  `V112` text NOT NULL,
  `V113` text NOT NULL,
  `V114` text NOT NULL,
  `V115` text NOT NULL,
  `V116` text NOT NULL,
  `V117` text NOT NULL,
  `V118` text NOT NULL,
  `V119` text NOT NULL,
  `V120` text NOT NULL,
  `V121` text NOT NULL,
  `V122` text NOT NULL,
  `V123` text NOT NULL,
  `V124` text NOT NULL,
  `V125` text NOT NULL,
  `V126` text NOT NULL,
  `V127` text NOT NULL,
  `V128` text NOT NULL,
  `V129` text NOT NULL,
  `V130` text NOT NULL,
  `V131` text NOT NULL,
  `V132` text NOT NULL,
  `V133` text NOT NULL,
  `V134` text NOT NULL,
  `V135` text NOT NULL,
  `V136` text NOT NULL,
  `V137` text NOT NULL,
  `V138` text NOT NULL,
  `V139` text NOT NULL,
  `V140` text NOT NULL,
  `V141` text NOT NULL,
  `V142` text NOT NULL,
  `V143` text NOT NULL,
  `V144` text NOT NULL,
  `V145` text NOT NULL,
  `V146` text NOT NULL,
  `V147` text NOT NULL,
  `V148` text NOT NULL,
  `V149` text NOT NULL,
  `V150` text NOT NULL,
  `V151` text NOT NULL,
  `V152` text NOT NULL,
  `V153` text NOT NULL,
  `V154` text NOT NULL,
  `V155` text NOT NULL,
  `V156` text NOT NULL,
  `V157` text NOT NULL,
  `V158` text NOT NULL,
  `V159` text NOT NULL,
  `V160` text NOT NULL,
  `V161` text NOT NULL,
  `V162` text NOT NULL,
  `V163` text NOT NULL,
  `V164` text NOT NULL,
  `V165` text NOT NULL,
  `V166` text NOT NULL,
  `V167` text NOT NULL,
  `V168` text NOT NULL,
  `V169` text NOT NULL,
  `V170` text NOT NULL,
  `V171` text NOT NULL,
  `V172` text NOT NULL,
  `V173` text NOT NULL,
  `V174` text NOT NULL,
  `V175` text NOT NULL,
  `V176` text NOT NULL,
  `V177` text NOT NULL,
  `V178` text NOT NULL,
  `V179` text NOT NULL,
  `V180` text NOT NULL,
  `V181` text NOT NULL,
  `V182` text NOT NULL,
  `V183` text NOT NULL,
  `V184` text NOT NULL,
  `V185` text NOT NULL,
  `V186` text NOT NULL,
  `V187` text NOT NULL,
  `V188` text NOT NULL,
  `V189` text NOT NULL,
  `V190` text NOT NULL,
  `V191` text NOT NULL,
  `V192` text NOT NULL,
  `V193` text NOT NULL,
  `V194` text NOT NULL,
  `V195` text NOT NULL,
  `V196` text NOT NULL,
  `V197` text NOT NULL,
  `V198` text NOT NULL,
  `V199` text NOT NULL,
  `V200` text NOT NULL,
  `V201` text NOT NULL,
  `V202` text NOT NULL,
  `V203` text NOT NULL,
  `V204` text NOT NULL,
  `V205` text NOT NULL,
  `V206` text NOT NULL,
  `V207` text NOT NULL,
  `V208` text NOT NULL,
  `V209` text NOT NULL,
  `V210` text NOT NULL,
  `V211` text NOT NULL,
  `V212` text NOT NULL,
  `V213` text NOT NULL,
  `V214` text NOT NULL,
  `V215` text NOT NULL,
  `V216` text NOT NULL,
  `V217` text NOT NULL,
  `V218` text NOT NULL,
  `V219` text NOT NULL,
  `V220` text NOT NULL,
  `V221` text NOT NULL,
  `V222` text NOT NULL,
  `V223` text NOT NULL,
  `V224` text NOT NULL,
  `V225` text NOT NULL,
  `V226` text NOT NULL,
  `V227` text NOT NULL,
  `V228` text NOT NULL,
  `V229` text NOT NULL,
  `V230` text NOT NULL,
  `V231` text NOT NULL,
  PRIMARY KEY (`recordID`),
  UNIQUE KEY `recordID` (`recordID`),
  KEY `recordID_2` (`recordID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2142 ;

-- --------------------------------------------------------

--
-- Table structure for table `SPV_cond_spwt`
--

CREATE TABLE IF NOT EXISTS `SPV_cond_spwt` (
  `recordID` int(11) NOT NULL AUTO_INCREMENT,
  `locustag` text NOT NULL,
  `A01` text NOT NULL,
  `A02` text NOT NULL,
  `A03` text NOT NULL,
  `A04` text NOT NULL,
  `A05` text NOT NULL,
  `A06` text NOT NULL,
  `A07` text NOT NULL,
  `A08` text NOT NULL,
  `A09` text NOT NULL,
  `A10` text NOT NULL,
  `B05` text NOT NULL,
  `B06` text NOT NULL,
  `B07` text NOT NULL,
  `B08` text NOT NULL,
  `B09` text NOT NULL,
  `B10` text NOT NULL,
  `B11` text NOT NULL,
  `B12` text NOT NULL,
  `C01` text NOT NULL,
  `C02` text NOT NULL,
  `C07` text NOT NULL,
  `C08` text NOT NULL,
  `D03` text NOT NULL,
  `D04` text NOT NULL,
  `D05` text NOT NULL,
  `D06` text NOT NULL,
  `D07` text NOT NULL,
  `D08` text NOT NULL,
  `D11` text NOT NULL,
  `D12` text NOT NULL,
  `E03` text NOT NULL,
  `E04` text NOT NULL,
  `E05` text NOT NULL,
  `E06` text NOT NULL,
  `F01` text NOT NULL,
  `F02` text NOT NULL,
  `F03` text NOT NULL,
  `F04` text NOT NULL,
  `F05` text NOT NULL,
  `F06` text NOT NULL,
  `F07` text NOT NULL,
  `F08` text NOT NULL,
  `F09` text NOT NULL,
  `TA01` text NOT NULL,
  `TA02` text NOT NULL,
  `TA03` text NOT NULL,
  `TA04` text NOT NULL,
  `TA05` text NOT NULL,
  `TA06` text NOT NULL,
  `TA07` text NOT NULL,
  `TA08` text NOT NULL,
  `TA09` text NOT NULL,
  `TA10` text NOT NULL,
  `TB05` text NOT NULL,
  `TB06` text NOT NULL,
  `TB07` text NOT NULL,
  `TB08` text NOT NULL,
  `TB09` text NOT NULL,
  `TB10` text NOT NULL,
  `TB11` text NOT NULL,
  `TB12` text NOT NULL,
  `TC01` text NOT NULL,
  `TC02` text NOT NULL,
  `TC07` text NOT NULL,
  `TC08` text NOT NULL,
  `TD03` text NOT NULL,
  `TD04` text NOT NULL,
  `TD05` text NOT NULL,
  `TD06` text NOT NULL,
  `TD07` text NOT NULL,
  `TD08` text NOT NULL,
  `TD11` text NOT NULL,
  `TD12` text NOT NULL,
  `TE03` text NOT NULL,
  `TE04` text NOT NULL,
  `TE05` text NOT NULL,
  `TE06` text NOT NULL,
  `TF01` text NOT NULL,
  `TF02` text NOT NULL,
  `TF03` text NOT NULL,
  `TF04` text NOT NULL,
  `TF05` text NOT NULL,
  `TF06` text NOT NULL,
  `TF07` text NOT NULL,
  `TF08` text NOT NULL,
  `TF09` text NOT NULL,
  PRIMARY KEY (`recordID`),
  UNIQUE KEY `recordID` (`recordID`),
  KEY `recordID_2` (`recordID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2154 ;

-- --------------------------------------------------------

--
-- Table structure for table `SPV_sp_coexpressed`
--

CREATE TABLE IF NOT EXISTS `SPV_sp_coexpressed` (
  `recordID` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(10) NOT NULL,
  `target` varchar(10) NOT NULL,
  `value` varchar(15) NOT NULL,
  `number` varchar(15) NOT NULL,
  PRIMARY KEY (`recordID`),
  UNIQUE KEY `recordID` (`recordID`),
  KEY `recordID_2` (`recordID`),
  KEY `recordID_3` (`recordID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4825346 ;

-- --------------------------------------------------------

--
-- Table structure for table `SPV_sp_geneset`
--

CREATE TABLE IF NOT EXISTS `SPV_sp_geneset` (
  `recordID` int(11) NOT NULL AUTO_INCREMENT,
  `gene` text NOT NULL,
  `locustag` text NOT NULL,
  `start` text NOT NULL,
  `end` text NOT NULL,
  `strand` text NOT NULL,
  `length` int(11) NOT NULL,
  `link` text NOT NULL,
  `comb_name` text NOT NULL,
  `remark` text NOT NULL,
  `remark2` text NOT NULL,
  `type` varchar(30) NOT NULL,
  `R6_equivalent` varchar(20) NOT NULL,
  `essential` varchar(1) NOT NULL,
  `class` varchar(10) NOT NULL,
  `low_var` varchar(15) NOT NULL,
  PRIMARY KEY (`recordID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4305 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;