LBMC » MyLabStocks

-- MySQL dump 10.13  Distrib 5.5.31, for debian-linux-gnu (x86_64)

-- Host: localhost    Database: labstocks_db

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

-- Server version	5.5.31-0+wheezy1

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

DROP TABLE IF EXISTS `ab_avail`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_avail` (

  `Type` varchar(50) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `ab_avail` WRITE;

/*!40000 ALTER TABLE `ab_avail` DISABLE KEYS */;

INSERT INTO `ab_avail` VALUES ('available'),('out of stock');

/*!40000 ALTER TABLE `ab_avail` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `ab_host`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_host` (

  `Host` varchar(50) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `ab_host` WRITE;

/*!40000 ALTER TABLE `ab_host` DISABLE KEYS */;

INSERT INTO `ab_host` VALUES ('goat'),('horse'),('mouse'),('rabbit');

/*!40000 ALTER TABLE `ab_host` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `ab_monopoly`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_monopoly` (

  `Type` varchar(50) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `ab_monopoly` WRITE;

/*!40000 ALTER TABLE `ab_monopoly` DISABLE KEYS */;

INSERT INTO `ab_monopoly` VALUES ('monoclonal'),('polyclonal');

/*!40000 ALTER TABLE `ab_monopoly` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `ab_supplier`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_supplier` (

  `Supplier` varchar(50) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `ab_supplier` WRITE;

/*!40000 ALTER TABLE `ab_supplier` DISABLE KEYS */;

INSERT INTO `ab_supplier` VALUES ('Abcam'),('ActiveMotif'),('Covance/Eurogentec'),('Diagenode'),('MPBiomedicals'),('Sigma'),('Upstate/Millipore');

/*!40000 ALTER TABLE `ab_supplier` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `ab_type`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `ab_type` (

  `Type` varchar(50) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `ab_type` WRITE;

/*!40000 ALTER TABLE `ab_type` DISABLE KEYS */;

INSERT INTO `ab_type` VALUES ('monoclonal'),('polyclonal');

/*!40000 ALTER TABLE `ab_type` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `antibodies`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `antibodies` (

  `storage_minus20freezers` varchar(100) DEFAULT NULL,

  `storage_minus80freezers` varchar(100) DEFAULT NULL,

  `storage_fridges` varchar(100) DEFAULT NULL,

  `storage_rooms` varchar(100) DEFAULT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `antibodies` WRITE;

/*!40000 ALTER TABLE `antibodies` DISABLE KEYS */;

INSERT INTO `antibodies` VALUES (1,'Actin C4','available','2008-09-11','used for WB control, do not use as control in case of TSA treatment: TSA is known to reduce actin expression.','mouse','Gael.Y','monoclonal','9045J','MPBiomedicals','Boite Ac Primaires#1 / Tiroir #3','1:20000','','69100',NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `antibodies` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_name`

--

DROP TABLE IF EXISTS `cl_name`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_name` (

  `name` varchar(100) NOT NULL,

  `description` longtext,

  `origin` longtext,

  `type` varchar(100) DEFAULT NULL,

  PRIMARY KEY (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `cl_name`

--

LOCK TABLES `cl_name` WRITE;

/*!40000 ALTER TABLE `cl_name` DISABLE KEYS */;

INSERT INTO `cl_name` VALUES ('LCL_e','EBV-transformed B cell from Evelyne Manet','gift from Evelyne Manet','LCL'),('LCL_GFP','LCL with GFP on ...','Home made','LCL');

/*!40000 ALTER TABLE `cl_name` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_passages`

--

DROP TABLE IF EXISTS `cl_passages`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_passages` (

  `ID` int(15) unsigned NOT NULL AUTO_INCREMENT,

  `name` varchar(100) DEFAULT NULL,

  `passage` longtext,

  `date_of_freezing` date DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `cl_passages`

--

LOCK TABLES `cl_passages` WRITE;

/*!40000 ALTER TABLE `cl_passages` DISABLE KEYS */;

INSERT INTO `cl_passages` VALUES (1,'LCL_GFP','3','2014-02-18'),(2,'LCL_e','n+10','2014-02-19');

/*!40000 ALTER TABLE `cl_passages` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_storage`

--

DROP TABLE IF EXISTS `cl_storage`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_storage` (

  `ID` int(15) unsigned NOT NULL AUTO_INCREMENT,

  `container` varchar(50) DEFAULT NULL,

  `rack` varchar(50) DEFAULT NULL,

  `box` varchar(50) DEFAULT NULL,

  `field` varchar(50) DEFAULT NULL,

  `cl_passages` int(15) DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `cl_storage`

--

LOCK TABLES `cl_storage` WRITE;

/*!40000 ALTER TABLE `cl_storage` DISABLE KEYS */;

INSERT INTO `cl_storage` VALUES (1,'1','1','A','1',NULL),(2,'1','1','A','2',NULL),(3,'1','1','B','1',NULL),(4,'1','1','B','2',NULL),(5,'1','1','B','3',NULL),(6,'1','1','C','1',NULL),(7,'1','1','C','2',NULL),(8,'1','1','C','3',NULL),(9,'1','1','C','4',NULL),(10,'1','1','D','1',NULL),(11,'1','1','D','2',NULL),(12,'1','1','D','3',NULL),(13,'1','1','D','4',NULL),(14,'1','1','D','5',NULL),(15,'1','1','E','1',NULL),(16,'1','1','E','2',NULL),(17,'1','1','E','3',NULL),(18,'1','1','E','4',NULL),(19,'1','1','E','5',NULL),(20,'1','1','E','6',NULL),(21,'1','1','F','1',NULL),(22,'1','1','F','2',NULL),(23,'1','1','F','3',NULL),(24,'1','1','F','4',NULL),(25,'1','1','F','5',NULL),(26,'1','1','F','6',NULL),(27,'1','1','F','7',NULL),(28,'1','1','G','1',NULL),(29,'1','1','G','2',NULL),(30,'1','1','G','3',NULL),(31,'1','1','G','4',NULL),(32,'1','1','G','5',NULL),(33,'1','1','G','6',NULL),(34,'1','1','G','7',NULL),(35,'1','1','G','8',NULL),(36,'1','1','H','1',NULL),(37,'1','1','H','2',NULL),(38,'1','1','H','3',NULL),(39,'1','1','H','4',NULL),(40,'1','1','H','5',NULL),(41,'1','1','H','6',NULL),(42,'1','1','H','7',NULL),(43,'1','1','H','8',NULL),(44,'1','1','H','9',NULL),(45,'1','1','I','1',NULL),(46,'1','1','I','2',NULL),(47,'1','1','I','3',NULL),(48,'1','1','I','4',NULL),(49,'1','1','I','5',NULL),(50,'1','1','I','6',NULL),(51,'1','1','I','7',NULL),(52,'1','1','I','8',NULL),(53,'1','1','I','9',NULL),(54,'1','1','I','10',NULL),(55,'1','1','J','1',NULL),(56,'1','1','J','2',NULL),(57,'1','1','J','3',NULL),(58,'1','1','J','4',NULL),(59,'1','1','J','5',NULL),(60,'1','1','J','6',NULL),(61,'1','1','J','7',NULL),(62,'1','1','J','8',NULL),(63,'1','1','J','9',NULL),(64,'1','1','K','1',NULL),(65,'1','1','K','2',NULL),(66,'1','1','K','3',NULL),(67,'1','1','K','4',NULL),(68,'1','2','A','1',NULL),(69,'1','2','A','2',NULL),(70,'1','2','B','1',NULL),(71,'1','2','B','2',NULL),(72,'1','2','B','3',NULL),(73,'1','2','C','1',NULL),(74,'1','2','C','2',NULL),(75,'1','2','C','3',NULL),(76,'1','2','C','4',NULL),(77,'1','2','D','1',NULL),(78,'1','2','D','2',NULL),(79,'1','2','D','3',NULL),(80,'1','2','D','4',NULL),(81,'1','2','D','5',NULL),(82,'1','2','E','1',NULL),(83,'1','2','E','2',NULL),(84,'1','2','E','3',NULL),(85,'1','2','E','4',NULL),(86,'1','2','E','5',NULL),(87,'1','2','E','6',NULL),(88,'1','2','F','1',NULL),(89,'1','2','F','2',NULL),(90,'1','2','F','3',NULL),(91,'1','2','F','4',NULL),(92,'1','2','F','5',NULL),(93,'1','2','F','6',NULL),(94,'1','2','F','7',NULL),(95,'1','2','G','1',NULL),(96,'1','2','G','2',NULL),(97,'1','2','G','3',NULL),(98,'1','2','G','4',NULL),(99,'1','2','G','5',NULL),(100,'1','2','G','6',NULL),(101,'1','2','G','7',NULL),(102,'1','2','G','8',NULL),(103,'1','2','H','1',NULL),(104,'1','2','H','2',NULL),(105,'1','2','H','3',NULL),(106,'1','2','H','4',NULL),(107,'1','2','H','5',NULL),(108,'1','2','H','6',NULL),(109,'1','2','H','7',NULL),(110,'1','2','H','8',NULL),(111,'1','2','H','9',NULL),(112,'1','2','I','1',NULL),(113,'1','2','I','2',NULL),(114,'1','2','I','3',NULL),(115,'1','2','I','4',NULL),(116,'1','2','I','5',NULL),(117,'1','2','I','6',NULL),(118,'1','2','I','7',NULL),(119,'1','2','I','8',NULL),(120,'1','2','I','9',NULL),(121,'1','2','I','10',NULL),(122,'1','2','J','1',NULL),(123,'1','2','J','2',NULL),(124,'1','2','J','3',NULL),(125,'1','2','J','4',NULL),(126,'1','2','J','5',NULL),(127,'1','2','J','6',NULL),(128,'1','2','J','7',NULL),(129,'1','2','J','8',NULL),(130,'1','2','J','9',NULL),(131,'1','2','K','1',NULL),(132,'1','2','K','2',NULL),(133,'1','2','K','3',NULL),(134,'1','2','K','4',NULL),(135,'2','1','A','1',NULL),(136,'2','1','A','2',NULL),(137,'2','1','B','1',NULL),(138,'2','1','B','2',NULL),(139,'2','1','B','3',NULL),(140,'2','1','C','1',NULL),(141,'2','1','C','2',NULL),(142,'2','1','C','3',NULL),(143,'2','1','C','4',NULL),(144,'2','1','D','1',NULL),(145,'2','1','D','2',NULL),(146,'2','1','D','3',NULL),(147,'2','1','D','4',NULL),(148,'2','1','D','5',NULL),(149,'2','1','E','1',NULL),(150,'2','1','E','2',NULL),(151,'2','1','E','3',NULL),(152,'2','1','E','4',NULL),(153,'2','1','E','5',NULL),(154,'2','1','E','6',NULL),(155,'2','1','F','1',NULL),(156,'2','1','F','2',NULL),(157,'2','1','F','3',NULL),(158,'2','1','F','4',NULL),(159,'2','1','F','5',NULL),(160,'2','1','F','6',NULL),(161,'2','1','F','7',NULL),(162,'2','1','G','1',NULL),(163,'2','1','G','2',NULL),(164,'2','1','G','3',NULL),(165,'2','1','G','4',NULL),(166,'2','1','G','5',NULL),(167,'2','1','G','6',NULL),(168,'2','1','G','7',NULL),(169,'2','1','G','8',NULL),(170,'2','1','H','1',NULL),(171,'2','1','H','2',NULL),(172,'2','1','H','3',NULL),(173,'2','1','H','4',NULL),(174,'2','1','H','5',NULL),(175,'2','1','H','6',NULL),(176,'2','1','H','7',NULL),(177,'2','1','H','8',NULL),(178,'2','1','H','9',NULL),(179,'2','1','I','1',NULL),(180,'2','1','I','2',NULL),(181,'2','1','I','3',NULL),(182,'2','1','I','4',NULL),(183,'2','1','I','5',NULL),(184,'2','1','I','6',NULL),(185,'2','1','I','7',NULL),(186,'2','1','I','8',NULL),(187,'2','1','I','9',NULL),(188,'2','1','I','10',NULL),(189,'2','1','J','1',NULL),(190,'2','1','J','2',NULL),(191,'2','1','J','3',NULL),(192,'2','1','J','4',NULL),(193,'2','1','J','5',NULL),(194,'2','1','J','6',NULL),(195,'2','1','J','7',NULL),(196,'2','1','J','8',NULL),(197,'2','1','J','9',NULL),(198,'2','1','K','1',NULL),(199,'2','1','K','2',NULL),(200,'2','1','K','3',NULL),(201,'2','1','K','4',NULL),(202,'2','2','A','1',NULL),(203,'2','2','A','2',NULL),(204,'2','2','B','1',NULL),(205,'2','2','B','2',NULL),(206,'2','2','B','3',NULL),(207,'2','2','C','1',NULL),(208,'2','2','C','2',NULL),(209,'2','2','C','3',NULL),(210,'2','2','C','4',NULL),(211,'2','2','D','1',NULL),(212,'2','2','D','2',NULL),(213,'2','2','D','3',NULL),(214,'2','2','D','4',NULL),(215,'2','2','D','5',NULL),(216,'2','2','E','1',NULL),(217,'2','2','E','2',NULL),(218,'2','2','E','3',NULL),(219,'2','2','E','4',NULL),(220,'2','2','E','5',NULL),(221,'2','2','E','6',NULL),(222,'2','2','F','1',NULL),(223,'2','2','F','2',NULL),(224,'2','2','F','3',NULL),(225,'2','2','F','4',NULL),(226,'2','2','F','5',NULL),(227,'2','2','F','6',NULL),(228,'2','2','F','7',NULL),(229,'2','2','G','1',NULL),(230,'2','2','G','2',NULL),(231,'2','2','G','3',NULL),(232,'2','2','G','4',NULL),(233,'2','2','G','5',NULL),(234,'2','2','G','6',NULL),(235,'2','2','G','7',NULL),(236,'2','2','G','8',NULL),(237,'2','2','H','1',NULL),(238,'2','2','H','2',NULL),(239,'2','2','H','3',NULL),(240,'2','2','H','4',NULL),(241,'2','2','H','5',NULL),(242,'2','2','H','6',NULL),(243,'2','2','H','7',NULL),(244,'2','2','H','8',NULL),(245,'2','2','H','9',NULL),(246,'2','2','I','1',NULL),(247,'2','2','I','2',NULL),(248,'2','2','I','3',NULL),(249,'2','2','I','4',NULL),(250,'2','2','I','5',NULL),(251,'2','2','I','6',NULL),(252,'2','2','I','7',NULL),(253,'2','2','I','8',NULL),(254,'2','2','I','9',NULL),(255,'2','2','I','10',NULL),(256,'2','2','J','1',NULL),(257,'2','2','J','2',NULL),(258,'2','2','J','3',NULL),(259,'2','2','J','4',NULL),(260,'2','2','J','5',NULL),(261,'2','2','J','6',NULL),(262,'2','2','J','7',NULL),(263,'2','2','J','8',NULL),(264,'2','2','J','9',NULL),(265,'2','2','K','1',NULL),(266,'2','2','K','2',NULL),(267,'2','2','K','3',NULL),(268,'2','2','K','4',NULL),(269,'2','3','A','1',NULL),(270,'2','3','A','2',NULL),(271,'2','3','B','1',NULL),(272,'2','3','B','2',NULL),(273,'2','3','B','3',NULL),(274,'2','3','C','1',NULL),(275,'2','3','C','2',NULL),(276,'2','3','C','3',NULL),(277,'2','3','C','4',NULL),(278,'2','3','D','1',NULL),(279,'2','3','D','2',NULL),(280,'2','3','D','3',NULL),(281,'2','3','D','4',NULL),(282,'2','3','D','5',NULL),(283,'2','3','E','1',NULL),(284,'2','3','E','2',NULL),(285,'2','3','E','3',NULL),(286,'2','3','E','4',NULL),(287,'2','3','E','5',NULL),(288,'2','3','E','6',NULL),(289,'2','3','F','1',NULL),(290,'2','3','F','2',NULL),(291,'2','3','F','3',NULL),(292,'2','3','F','4',NULL),(293,'2','3','F','5',NULL),(294,'2','3','F','6',NULL),(295,'2','3','F','7',NULL),(296,'2','3','G','1',NULL),(297,'2','3','G','2',NULL),(298,'2','3','G','3',NULL),(299,'2','3','G','4',NULL),(300,'2','3','G','5',NULL),(301,'2','3','G','6',NULL),(302,'2','3','G','7',NULL),(303,'2','3','G','8',NULL),(304,'2','3','H','1',NULL),(305,'2','3','H','2',NULL),(306,'2','3','H','3',NULL),(307,'2','3','H','4',NULL),(308,'2','3','H','5',NULL),(309,'2','3','H','6',NULL),(310,'2','3','H','7',NULL),(311,'2','3','H','8',NULL),(312,'2','3','H','9',NULL),(313,'2','3','I','1',NULL),(314,'2','3','I','2',NULL),(315,'2','3','I','3',NULL),(316,'2','3','I','4',NULL),(317,'2','3','I','5',NULL),(318,'2','3','I','6',NULL),(319,'2','3','I','7',NULL),(320,'2','3','I','8',NULL),(321,'2','3','I','9',NULL),(322,'2','3','I','10',NULL),(323,'2','3','J','1',NULL),(324,'2','3','J','2',NULL),(325,'2','3','J','3',NULL),(326,'2','3','J','4',NULL),(327,'2','3','J','5',NULL),(328,'2','3','J','6',NULL),(329,'2','3','J','7',NULL),(330,'2','3','J','8',NULL),(331,'2','3','J','9',NULL),(332,'2','3','K','1',NULL),(333,'2','3','K','2',NULL),(334,'2','3','K','3',NULL),(335,'2','3','K','4',NULL);

/*!40000 ALTER TABLE `cl_storage` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `cl_type`

--

DROP TABLE IF EXISTS `cl_type`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `cl_type` (

  `type` varchar(100) NOT NULL,

  PRIMARY KEY (`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `cl_type`

--

LOCK TABLES `cl_type` WRITE;

/*!40000 ALTER TABLE `cl_type` DISABLE KEYS */;

INSERT INTO `cl_type` VALUES ('HEK293'),('HeLa'),('LCL');

/*!40000 ALTER TABLE `cl_type` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `lab_members`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `lab_members` (

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `lab_members` WRITE;

/*!40000 ALTER TABLE `lab_members` DISABLE KEYS */;

INSERT INTO `lab_members` VALUES ('Christelle.D'),('Florent.C'),('Gael.Y'),('Gift.or.Purchased'),('Helene.B');

/*!40000 ALTER TABLE `lab_members` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `notebooks`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `notebooks` (

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `notebooks` WRITE;

/*!40000 ALTER TABLE `notebooks` DISABLE KEYS */;

INSERT INTO `notebooks` VALUES (1,'2005-04-01','2006-01-31','Gael.Y','GY8'),(2,'2005-05-24','2005-12-07','Christelle.D','CD1'),(3,'2008-01-16','0000-00-00','Helene.B','EVO'),(4,'2009-07-06','2010-01-19','Helene.B','B49069'),(5,'2012-09-03','0000-00-00','Florent.C','E002933');

/*!40000 ALTER TABLE `notebooks` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `olig_purif`

--

DROP TABLE IF EXISTS `olig_purif`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `olig_purif` (

  `type` varchar(40) NOT NULL,

  PRIMARY KEY (`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `olig_purif`

--

LOCK TABLES `olig_purif` WRITE;

/*!40000 ALTER TABLE `olig_purif` DISABLE KEYS */;

INSERT INTO `olig_purif` VALUES (''),('Gold'),('HPLC'),('PAGE'),('SePoP');

/*!40000 ALTER TABLE `olig_purif` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `oligos`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `oligos` (

  `storage_minus20freezers` varchar(100) DEFAULT NULL,

  `storage_minus80freezers` varchar(100) DEFAULT NULL,

  `storage_fridges` varchar(100) DEFAULT NULL,

  `storage_rooms` varchar(100) DEFAULT NULL,

  KEY `Author` (`Author`),

  CONSTRAINT `oligos_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `oligos` WRITE;

/*!40000 ALTER TABLE `oligos` DISABLE KEYS */;

INSERT INTO `oligos` VALUES ('1C09','cttaatgcgccgctacaggg','2006-10-05','to screen bacteria for cloning of GAL3 fragment into pRS306','  #1: Product of length 475 (rating: 171)\r\n      Contains region of the molecule from 4048 to 4522\r\n      Tm: 80.5 C  TaOpt: 58.6 C  GC: 53.7\r\n    Sense Primer:\r\n      CTTAATGCGCCGCTACAGGG\r\n      Similarity: 100.0%\r\n      Length: 20  Tm: 57.2 C  GC: 60.0\r\n      dH: -170.4 kcal/mol  dS: -437.5 cal/mol  dG: -38.2 kcal/mol\r\n    Antisense Primer:\r\n      GCTACTGCGACTCTTAGGGCCAAT\r\n      Similarity: 100.0%\r\n      Length: 24  Tm: 58.9 C  GC: 54.17\r\n      dH: -191.8 kcal/mol  dS: -495.6 cal/mol  dG: -42.3 kcal/mol\r\n    Tm Difference: 1.8\r\n    GC Difference: 5.8\r\n','Gael.Y','',NULL,NULL,NULL,NULL),('1F14','gtgatgacggtgaaaacctc','2009-09-07','Upstream selection marker in pSH* plasmids.','','Gael.Y','',NULL,NULL,NULL,NULL),('1F19','ataagggcgacacggaaatg','2009-10-12','To sequence CEN/ARS of pCEN-AdeAru','','Gael.Y','',NULL,NULL,NULL,NULL),('1F97','tgtaacccactcgtgcac','2010-03-01','To sequence any plasmid from the AmpR coding sequence.','','Gael.Y','SePoP',NULL,NULL,NULL,NULL),('1H75','cactatagggcgaattgg','2011-01-06','To amplify yEGFP-CYC1term from pGY8 and clone it into pCM183 by homologous recombination in yeast.','','Gael.Y','SePoP',NULL,NULL,NULL,NULL),('1I97','atttagagcttgacggggaaagcc','2013-03-28','For Laser Game mutagenesis of Cre-VVD II.','Taille du fragment amplifié : 1531 nucl.\r\nGC% : 46%\r\nTempérature d\'hybridation suggérée (TA) : 57°C\r\nAmorce sens : 1I96\r\nAmorce anti-sens : 1I97\r\n\r\nPrimer: 1I96 (1) 5\' tacctgttttgccgggtcagaa 3\' (22)\r\n                    ||||||||||||||||||||||\r\nTarget:   (4077) 5\' tacctgttttgccgggtcagaa 3\' (4099)\r\nscore : 178\r\nTM : 58\r\n\r\n\r\nPrimer: 1I97[compl.] (24)  \r\n3\' ggctttccccgtcaagctctaaat 5\' (1)\r\n                                  ||||||||||||||||||||||||\r\nTarget:              (5584) \r\n5\' ggctttccccgtcaagctctaaat 3\' (5608)\r\nscore : 180\r\nTM : 59\r\n\r\nTarget= pGY286','Helene.B','SePoP',NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `oligos` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_events`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_events` (

  `Events` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_events` WRITE;

/*!40000 ALTER TABLE `pip_events` DISABLE KEYS */;

INSERT INTO `pip_events` VALUES ('Change Usage'),('Change User'),('Discard'),('Maintenance'),('Misc'),('Purchase');

/*!40000 ALTER TABLE `pip_events` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_generic_user`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_generic_user` (

  `User` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_generic_user` WRITE;

/*!40000 ALTER TABLE `pip_generic_user` DISABLE KEYS */;

INSERT INTO `pip_generic_user` VALUES ('Christelle.D'),('Everybody'),('Standby'),('Student');

/*!40000 ALTER TABLE `pip_generic_user` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_history`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_history` (

  `Serial_Number` varchar(50) NOT NULL,

  `Owner_fromNowOn` varchar(50) NOT NULL,

  `Usage_fromNowOn` varchar(50) NOT NULL,

  `Event_Type` varchar(100) NOT NULL,

  `Comments` text NOT NULL,

) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_history` WRITE;

/*!40000 ALTER TABLE `pip_history` DISABLE KEYS */;

INSERT INTO `pip_history` VALUES (1,'Y60538M','2005-00-00','Christelle.D','Misc','Purchase',''),(2,'Y60538M','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(3,'Y60538M','2009-03-04','Helene.B','Misc','Maintenance','Change of parts (spring was broken 2009_02_12)'),(4,'Y58817M','2005-00-00','Christelle.D','Misc','Purchase',''),(5,'Y58817M','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(6,'Y58817M','2009-03-04','Helene.B','Misc','Maintenance','Change of parts '),(7,'Y63235M','2005-00-00','Christelle.D','Misc','Purchase',''),(8,'Y63235M','2009-03-04','Helene.B','Misc','Maintenance',''),(9,'Y63235M','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(10,'Z64108A','2005-00-00','Christelle.D','Misc','Purchase',''),(11,'Z64108A','2006-00-00','Helene.B','Misc','Change User','Previous user: Christelle Damon'),(12,'Z64108A','2009-03-04','Helene.B','Misc','Maintenance',''),(13,'2102895','2005-09-01','Everybody','Misc','Purchase',''),(14,'6133327','2007-03-02','Everybody','Misc','Purchase',''),(15,'Z64108A','2011-02-18','Andri.Leonidou','Misc','Change User','Previous user: Christelle Damon');

/*!40000 ALTER TABLE `pip_history` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_marque`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_marque` (

  `Marque` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_marque` WRITE;

/*!40000 ALTER TABLE `pip_marque` DISABLE KEYS */;

INSERT INTO `pip_marque` VALUES ('BioHit'),('Eppendorf'),('Gilson');

/*!40000 ALTER TABLE `pip_marque` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_nonusers`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_nonusers` (

  `User` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_nonusers` WRITE;

/*!40000 ALTER TABLE `pip_nonusers` DISABLE KEYS */;

INSERT INTO `pip_nonusers` VALUES ('Florent.C'),('Gift.or.Purchased');

/*!40000 ALTER TABLE `pip_nonusers` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_stock`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_stock` (

  `Serial_Number` varchar(40) NOT NULL,

  `Marque` varchar(40) NOT NULL,

  `Type` varchar(50) NOT NULL,

) ENGINE=MyISAM AUTO_INCREMENT=228 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_stock` WRITE;

/*!40000 ALTER TABLE `pip_stock` DISABLE KEYS */;

INSERT INTO `pip_stock` VALUES (1,'Y60538M','Gilson','P1000'),(2,'Y58817M','Gilson','P200'),(3,'Y63235M','Gilson','P20'),(4,'Z64108A','Gilson','P2'),(5,'2102895','Eppendorf','multicanaux_10-100ul'),(6,'6133327','BioHit','multicanaux_02-10ul');

/*!40000 ALTER TABLE `pip_stock` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_type`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_type` (

  `Type` varchar(50) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_type` WRITE;

/*!40000 ALTER TABLE `pip_type` DISABLE KEYS */;

INSERT INTO `pip_type` VALUES ('multicanaux_02-10ul'),('multicanaux_10-100ul'),('multicanaux_50-1200ul'),('P1000'),('P2'),('P20'),('P200');

/*!40000 ALTER TABLE `pip_type` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_usage`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_usage` (

  `Usage` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_usage` WRITE;

/*!40000 ALTER TABLE `pip_usage` DISABLE KEYS */;

INSERT INTO `pip_usage` VALUES ('Cellular'),('Misc'),('RNA');

/*!40000 ALTER TABLE `pip_usage` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pip_users`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pip_users` (

  `User` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pip_users` WRITE;

/*!40000 ALTER TABLE `pip_users` DISABLE KEYS */;

INSERT INTO `pip_users` VALUES ('Christelle.D'),('Helene.B');

/*!40000 ALTER TABLE `pip_users` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_bacterial_selection`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_bacterial_selection` (

  `type` varchar(40) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_bacterial_selection` WRITE;

/*!40000 ALTER TABLE `pl_bacterial_selection` DISABLE KEYS */;

INSERT INTO `pl_bacterial_selection` VALUES (''),('Amp'),('Chloramphenicol'),('Kan');

/*!40000 ALTER TABLE `pl_bacterial_selection` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_features`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_features` (

  `Comments` longtext NOT NULL,

  KEY `Author` (`Author`),

  CONSTRAINT `pl_features_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_features` WRITE;

/*!40000 ALTER TABLE `pl_features` DISABLE KEYS */;

INSERT INTO `pl_features` VALUES (1,'CGCTTGCCTGTAACTTACACGCGCCTCGTATCTTTTAATGATGGAATAATTTGGGAATTTACTCTGTGTTTATTTATTTTTATGTTTTGTATTTGGATTTTAGAAAGTAAATAAAGAAGGTAGAAGAGTTACGGAATGAAGAAAAAAAAATAAACAAAGGTTTAAAAAATTTCAACAAAAAGCGTACTTTACATATATATTTATTAGACAAGAAAAGCAGATTAAATAGATATACATTCGATTAACGATAAGTAAAATGTAAAATCACAGGATTTTCGTGTGTGGTCTTCTACACAGACAAGATGAAACAATTCGGCATTAATACCTGAGAGCAGGAAGAGCAAGATAAAAGGTAGTATTTGTTGGCGATCCCCCTAGAGTCTTTTACATCTTCGGAAAACAAAAACTATTTTTTCTTTAATTTCTTTTTTTACTTTCTATTTTTAATTTATATATTTATATTAAAAAATTTAAATTATAATTATTTTTATAGCACGTGATGAAAAGGACC','2013-06-11','CEN6/ARSH4','','Gael.Y','ORI'),(2,'ATAACTTCGTATAATGTATGCTATACGAAGTTAT','2013-06-11','LoxP','','Gael.Y','OTH'),(3,'ATGTCTAAAGGTGAAGAATTATTCACTGGTGTTGTCCCAATTTTGGTTGAATTAGATGGTGATGTTAATGGTCACAAATTTTCTGTCTCCGGTGAAGGTGAAGGTGATGCTACTTACGGTAAATTGACCTTAAAATTTATTTGTACTACTGGTAAATTGCCAGTTCCATGGCCAACCTTAGTCACTACTTTCGGTTATGGTGTTCAATGTTTTGCTAGATACCCAGATCATATGAAACAACATGACTTTTTCAAGTCTGCCATGCCAGAAGGTTATGTTCAAGAAAGAACTATTTTTTTCAAAGATGACGGTAACTACAAGACCAGAGCTGAAGTCAAGTTTGAAGGTGATACCTTAGTTAATAGAATCGAATTAAAAGGTATTGATTTTAAAGAAGATGGTAACATTTTAGGTCACAAATTGGAATACAACTATAACTCTCACAATGTTTACATCATGGCTGACAAACAAAAGAATGGTATCAAAGTTAACTTCAAAATTAGACACAACATTGAAGATGGTTCTGTTCAATTAGCTGACCATTATCAACAAAATACTCCAATTGGTGATGGTCCAGTCTTGTTACCAGACAACCATTACTTATCCACTCAATCTGCCTTATCCAAAGATCCAAACGAAAAGAGAGACCACATGGTCTTGTTAGAATTTGTTACTGCTGCTGGTATTACCCATGGTATGGATGAATTGTACAAA','2013-06-11','yEGFP3-CDS','','Gael.Y','REP'),(4,'atgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcttttaaagaggccctactggcgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagctttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtaccaacgatgttccctccaccaaaggtgttcttatgtag','2013-07-19','HIS3-CDS','','Gael.Y','SEL'),(5,'cgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttcccctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaag','2013-07-19','HIS3-prom','','Gael.Y','PRO'),(6,'tgacaccgattatttaaagctgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcga','2013-07-19','HIS3-term','','Gael.Y','TER');

/*!40000 ALTER TABLE `pl_features` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_features_catname`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_features_catname` (

  `Category` varchar(15) NOT NULL,

  `Name` varchar(50) DEFAULT NULL,

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_features_catname` WRITE;

/*!40000 ALTER TABLE `pl_features_catname` DISABLE KEYS */;

INSERT INTO `pl_features_catname` VALUES ('PRO','Promoters'),('REG','Regulatory sequences'),('TER','Terminators'),('SEL','Selectable markers'),('ORI','Replication origins'),('REP','Reporter genes'),('TAG','Affinity tags'),('LOC','Localization sequences'),('HYB','Hybrid genes'),('OTH','Miscellaneous features');

/*!40000 ALTER TABLE `pl_features_catname` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_tag`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_tag` (

  `type` varchar(40) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_tag` WRITE;

/*!40000 ALTER TABLE `pl_tag` DISABLE KEYS */;

INSERT INTO `pl_tag` VALUES (''),('FLAG'),('FlAsH'),('GST'),('HA'),('HIS'),('Myc'),('ProA'),('TAP');

/*!40000 ALTER TABLE `pl_tag` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_type`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_type` (

  `type` varchar(40) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_type` WRITE;

/*!40000 ALTER TABLE `pl_type` DISABLE KEYS */;

INSERT INTO `pl_type` VALUES (''),('2-mu'),('centromeric'),('integrative');

/*!40000 ALTER TABLE `pl_type` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_yeast_marker`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_yeast_marker` (

  `type` varchar(40) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_yeast_marker` WRITE;

/*!40000 ALTER TABLE `pl_yeast_marker` DISABLE KEYS */;

INSERT INTO `pl_yeast_marker` VALUES (''),('ADE2'),('bialaphos'),('CaURA3'),('HIS3'),('HIS3MX6'),('HphNT1'),('HygromycinB'),('Kan'),('KanMX'),('KanMX4'),('KlLEU2'),('KlTRP1'),('KlURA3'),('KlURA3MX4'),('LEU2'),('LYS2'),('Nat'),('NatMX'),('NatNT2'),('phleomycin'),('spHIS5'),('TRP1'),('URA3');

/*!40000 ALTER TABLE `pl_yeast_marker` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `pl_yeast_promoter`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `pl_yeast_promoter` (

  `type` varchar(40) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `pl_yeast_promoter` WRITE;

/*!40000 ALTER TABLE `pl_yeast_promoter` DISABLE KEYS */;

INSERT INTO `pl_yeast_promoter` VALUES (''),('ADH'),('CUP1'),('CYC1'),('GAL'),('GAL1'),('GALL'),('GALS'),('GPD'),('MET25'),('TEF');

/*!40000 ALTER TABLE `pl_yeast_promoter` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `plasmids`

DROP TABLE IF EXISTS `plasmids`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `plasmids` (

  `Name_` varchar(50) DEFAULT NULL,

  `Other_names` varchar(50) DEFAULT NULL,

  `date_` date DEFAULT NULL,

  `Checkings` varchar(200) DEFAULT NULL,

  `Type_` varchar(25) DEFAULT NULL,

  `Marker_1` varchar(25) DEFAULT NULL,

  `Marker_2` varchar(25) DEFAULT NULL,

  `Bacterial_selection` varchar(25) DEFAULT NULL,

  `Tags` varchar(25) DEFAULT NULL,

  `parent_vector` varchar(50) DEFAULT NULL,

  `Insert_` varchar(50) DEFAULT NULL,

  `Insert_Type` varchar(25) DEFAULT NULL,

  `Construction_Description` longtext,

  `Reference_` varchar(200) DEFAULT NULL,

  `Reporter` varchar(25) DEFAULT NULL,

  `Promoter` varchar(25) DEFAULT NULL,

  `Link_to_file` varchar(100) DEFAULT NULL,

  `sequence` text,

  `image_file` varchar(100) DEFAULT NULL,

  `storage_minus20freezers` varchar(100) DEFAULT NULL,

  `storage_minus80freezers` varchar(100) DEFAULT NULL,

  `storage_fridges` varchar(100) DEFAULT NULL,

  `storage_rooms` varchar(100) DEFAULT NULL,

  UNIQUE KEY `Link_to_file` (`Link_to_file`),

  UNIQUE KEY `Link_to_file_2` (`Link_to_file`),

  KEY `Author` (`Author`),

  CONSTRAINT `plasmids_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`)

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `plasmids`

LOCK TABLES `plasmids` WRITE;

/*!40000 ALTER TABLE `plasmids` DISABLE KEYS */;

INSERT INTO `plasmids` VALUES (1,'pRSII303',NULL,'2013-05-28','','centromeric','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n\r\n','','Lac Z','','pRSII303.gb.gz','TCGCGCGTTTCGGTGATGACGGTGAAAACCTCTGACACATGCAGCTCCCGGAGACGGTCACAGCTTGTCTGTAAGCGGATGCCGGGAGCAGACAAGCCCGTCAGGGCGCGTCAGCGGGTGTTGGCGGGTGTCGGGGCTGGCTTAACTATGCGGCATCAGAGCAGATTGTACTGAGAGTGCACCATAAATTCCCGTTTTAAGAGCTTGGTGAGCGCTAGGAGTCACTGCCAGGTATCGTTTGAACACGGCATTAGTCAGGGAAGTCATAACACAGTCCTTTCCCGCAATTTTCTTTTTCTATTACTCTTGGCCTCCTCTAGTACACTCTATATTTTTTTATGCCTCGGTAATGATTTTCATTTTTTTTTTTCCACCTAGCGGATGACTCTTTTTTTTTCTTAGCGATTGGCATTATCACATAATGAATTATACATTATATAAAGTAATGTGATTTCTTCGAAGAATATACTAAAAAATGAGCAGGCAAGATAAACGAAGGCAAAGATGACAGAGCAGAAAGCCCTAGTAAAGCGTATTACAAATGAAACCAAGATTCAGATTGCGATCTCTTTAAAGGGTGGTCCCCTAGCGATAGAGCACTCGATCTTCCCAGAAAAAGAGGCAGAAGCAGTAGCAGAACAGGCCACACAATCGCAAGTGATTAACGTCCACACAGGTATAGGGTTTCTGGACCATATGATACATGCTCTGGCCAAGCATTCCGGCTGGTCGCTAATCGTTGAGTGCATTGGTGACTTACACATAGACGACCATCACACCACTGAAGACTGCGGGATTGCTCTCGGTCAAGCATTTAAAGAGGCCCTAGGGGCCGTGCGTGGAGTAAAAAGGTTTGGATCAGGATTTGCGCCTTTGGATGAGGCACTTTCCAGAGCGGTGGTAGATCTTTCGAACAGGCCGTACGCAGTTGTCGAACTTGGTTTGCAAAGGGAGAAAGTAGGAGATCTCTCTTGCGAGATGATCCCGCATTTTCTTGAAAGTTTTGCAGAGGCTAGCAGAATTACCCTCCACGTTGATTGTCTGCGAGGCAAGAATGATCATCACCGTAGTGAGAGTGCGTTCAAGGCTCTTGCGGTTGCCATAAGAGAAGCCACCTCGCCCAATGGTACAAACGATGTTCCCTCCACCAAAGGTGTTCTTATGTAGTGACACCGATTATTTAAAGTTGCAGCATACGATATATATACATGTGTATATATGTATACCTATGAATGTCAGTAAGTATGTATACGAACAGTATGATACTGAAGATGACAAGGTAATGCATCATTCTATACGTGTCATTCTGAACGAGGCGCGCTTTCCTTTTTTCTTTTTGCTTTTTCTTTTTTTTTCTCTTGAACTCGACGGATCTATGCGGTGTGAAATACCGCACAGATGCGTAAGGAGAAAATACCGCATCAGGAAATTGTAAGCGTTAATATTTTGTTAAAATTCGCGTTAAATTTTTGTTAAATCAGCTCATTTTTTAACCAATAGGCCGAAATCGGCAAAATCCCTTATAAATCAAAAGAATAGACCGAGATAGGGTTGAGTGTTGTTCCAGTTTGGAACAAGAGTCCACTATTAAAGAACGTGGACTCCAACGTCAAAGGGCGAAAAACCGTCTATCAGGGCGATGGCCCACTACGTGAACCATCACCCTAATCAAGTTTTTTGGGGTCGAGGTGCCGTAAAGCACTAAATCGGAACCCTAAAGGGAGCCCCCGATTTAGAGCTTGACGGGGAAAGCCGGCGAACGTGGCGAGAAAGGAAGGGAAGAAAGCGAAAGGAGCGGGCGCTAGGGCGCTGGCAAGTGTAGCGGTCACGCTGCGCGTAACCACCACACCCGCCGCGCTTAATGCGCCGCTACAGGGCGCGTCCATTCGCCATTCAGGCTGCGCAACTGTTGGGAAGGGCGATCGGTGCGGGCCTCTTCGCTATTACGCCAGCTGGCGAAAGGGGGATGTGCTGCAAGGCGATTAAGTTGGGTAACGCCAGGGTTTTCCCAGTCACGACGTTGTAAAACGACGGCCAGTGAATTGTAATACGACTCACTATAGGGCGAATTGGAGCTCCACCGCGGTGGCGGCCGCTCTAGAACTAGTGGATCCCCCGGGCTGCAGGAATTCGATATCAAGCTTATCGATACCGTCGACCTCGAGGGGGGGCCCGGTACCAGCTTTTGTTCCCTTTAGTGAGGGTTAATTTCGAGCTTGGCGTAATCATGGTCATAGCTGTTTCCTGTGTGAAATTGTTATCCGCTCACAATTCCACACAACATACGAGCCGGAAGCATAAAGTGTAAAGCCTGGGGTGCCTAATGAGTGAGCTAACTCACATTAATTGCGTTGCGCTCACTGCCCGCTTTCCAGTCGGGAAACCTGTCGTGCCAGCTGCATTAATGAATCGGCCAACGCGCGGGGAGAGGCGGTTTGCGTATTGGGCGCTCTTCCGCTTCCTCGCTCACTGACTCGCTGCGCTCGGTCGTTCGGCTGCGGCGAGCGGTATCAGCTCACTCAAAGGCGGTAATACGGTTATCCACAGAATCAGGGGATAACGCAGGAAAGAACATGTGAGCAAAAGGCCAGCAAAAGGCCAGGAACCGTAAAAAGGCCGCGTTGCTGGCGTTTTTCCATAGGCTCCGCCCCCCTGACGAGCATCACAAAAATCGACGCTCAAGTCAGAGGTGGCGAAACCCGACAGGACTATAAAGATACCAGGCGTTTCCCCCTGGAAGCTCCCTCGTGCGCTCTCCTGTTCCGACCCTGCCGCTTACCGGATACCTGTCCGCCTTTCTCCCTTCGGGAAGCGTGGCGCTTTCTCATAGCTCACGCTGTAGGTATCTCAGTTCGGTGTAGGTCGTTCGCTCCAAGCTGGGCTGTGTGCACGAACCCCCCGTTCAGCCCGACCGCTGCGCCTTATCCGGTAACTATCGTCTTGAGTCCAACCCGGTAAGACACGACTTATCGCCACTGGCAGCAGCCACTGGTAACAGGATTAGCAGAGCGAGGTATGTAGGCGGTGCTACAGAGTTCTTGAAGTGGTGGCCTAACTACGGCTACACTAGAAGAACAGTATTTGGTATCTGCGCTCTGCTGAAGCCAGTTACCTTCGGAAAAAGAGTTGGTAGCTCTTGATCCGGCAAACAAACCACCGCTGGTAGCGGTGGTTTTTTTGTTTGCAAGCAGCAGATTACGCGCAGAAAAAAAGGATCTCAAGAAGATCCTTTGATCTTTTCTACGGGGTCTGACGCTCAGTGGAACGAAAACTCACGTTAAGGGATTTTGGTCATGAGATTATCAAAAAGGATCTTCACCTAGATCCTTTTAAATTAAAAATGAAGTTTTAAATCAATCTAAAGTATATATGAGTAAACTTGGTCTGACAGTTACCAATGCTTAATCAGTGAGGCACCTATCTCAGCGATCTGTCTATTTCGTTCATCCATAGTTGCCTGACTCCCCGTCGTGTAGATAACTACGATACGGGAGGGCTTACCATCTGGCCCCAGTGCTGCAATGATACCGCGAGACCCACGCTCACCGGCTCCAGATTTATCAGCAATAAACCAGCCAGCCGGAAGGGCCGAGCGCAGAAGTGGTCCTGCAACTTTATCCGCCTCCATCCAGTCTATTAATTGTTGCCGGGAAGCTAGAGTAAGTAGTTCGCCAGTTAATAGTTTGCGCAACGTTGTTGCCATTGCTACAGGCATCGTGGTGTCACGCTCGTCGTTTGGTATGGCTTCATTCAGCTCCGGTTCCCAACGATCAAGGCGAGTTACATGATCCCCCATGTTGTGCAAAAAAGCGGTTAGCTCCTTCGGTCCTCCGATCGTTGTCAGAAGTAAGTTGGCCGCAGTGTTATCACTCATGGTTATGGCAGCACTGCATAATTCTCTTACTGTCATGCCATCCGTAAGATGCTTTTCTGTGACTGGTGAGTACTCAACCAAGTCATTCTGAGAATAGTGTATGCGGCGACCGAGTTGCTCTTGCCCGGCGTCAATACGGGATAATACCGCGCCACATAGCAGAACTTTAAAAGTGCTCATCATTGGAAAACGTTCTTCGGGGCGAAAACTCTCAAGGATCTTACCGCTGTTGAGATCCAGTTCGATGTAACCCACTCGTGCACCCAACTGATCTTCAGCATCTTTTACTTTCACCAGCGTTTCTGGGTGAGCAAAAACAGGAAGGCAAAATGCCGCAAAAAAGGGAATAAGGGCGACACGGAAATGTTGAATACTCATACTCTTCCTTTTTCAATATTATTGAAGCATTTATCAGGGTTATTGTCTCATGAGCGGATACATATTTGAATGTATTTAGAAAAATAAACAAATAGGGGTTCCGCGCACATTTCCCCGAAAAGTGCCACCTGACGTCTAAGAAACCATTATTATCATGACATTAACCTATAAAAATAGGCGTATCACGAGGCCCTTTCGTC',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(2,'pRSII403',NULL,'2013-05-28','','centromeric','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n\r\n','','Lac Z','','pRSII403.gb.gz','tcgcgcgtttcggtgatgacggtgaaaacctctgacacatgcagctcccggagacggtcacagcttgtctgtaagcggatgccgggagcagacaagcccgtcagggcgcgtcagcgggtgttggcgggtgtcggggctggcttaactatgcggcatcagagcagattgtactgagagtgcaccataaattcccgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttccAcctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaagatgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcAtttaaagaggccctaGGggcCGTgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagTtttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtacAaacgatgttccctccaccaaaggtgttcttatgtagtgacaccgattatttaaagTtgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcgacggatctatgcggtgtgaaataccgcacagatgcgtaaggagaaaataccgcatcaggaaattgtaaGcgttaatattttgttaaaattcgcgttaaatttttgttaaatcagctcattttttaaccaataggccgaaatcggcaaaatcccttataaatcaaaagaatagaccgagatagggttgagtgttgttccagtttggaacaagagtccactattaaagaacgtggactccaacgtcaaagggcgaaaaaccgtctatcagggcgatggcccactacgtgaaccatcaccctaatcaagttttttggggtcgaggtgccgtaaagcactaaatcggaaccctaaagggagcccccgatttagagcttgacggggaaagccggcgaacgtggcgagaaaggaagggaagaaagcgaaaggagcgggcgctagggcgctggcaagtgtagcggtcacgctgcgcgtaaccaccacacccgccgcgcttaatgcgccgctacagggcgcgtccattcgccattcaggctgcgcaactgttgggaagggcgatcggtgcgggcctcttcgctattacgccagctggcgaaagggggatgtgctgcaaggcgattaagttgggtaacgccagggttttcccagtcacgacgttgtaaaacgacggccagtgagcgcgcgtaatacgactcactatagggcgaattgggtaccgggccccccctcgaggtcgacggtatcgataagcttgatatcgaattcctgcagcccgggggatccactagttctagagcggccgccaccgcggtggagctccagcttttgttccctttagtgagggttaattgcgcgcttggcgtaatcatggtcatagctgtttcctgtgtgaaattgttatccgctcacaattccacacaacataCgagccggaagcataaagtgtaaagcctggggtgcctaatgagtgagCtaactcacattaattgcgttgcgctcactgcccgctttccagtcgggaaacctgtcgtgccagctgcattaatgaatcggccaacgcgcggggagaggcggtttgcgtattgggcgctcttccgcttcctcgctcactgactcgctgcgctcggtcgttcggctgcggcgagcggtatcagctcactcaaaggcggtaatacggttatccacagaatcaggggataacgcaggaaagaacatgtgagcaaaaggccagcaaaaggccaggaaccgtaaaaaggccgcgttgctggcgtttttccataggctccgcccccctgacgagcatcacaaaaatcgacgctcaagtcagaggtggcgaaacccgacaggactataaagataccaggcgtttccccctggaagctccctcgtgcgctctcctgttccgaccctgccgcttaccggatacctgtccgcctttctcccttcgggaagcgtggcgctttctcatagctcacgctgtaggtatctcagttcggtgtaggtcgttcgctccaagctgggctgtgtgcacgaaccccccgttcagcccgaccgctgcgccttatccggtaactatcgtcttgagtccaacccggtaagacacgacttatcgccactggcagcagccactggtaacaggattagcagagcgaggtatgtaggcggtgctacagagttcttgaagtggtggcctaactacggctacactagaagAacagtatttggtatctgcgctctgctgaagccagttaccttcggaaaaagagttggtagctcttgatccggcaaacaaaccaccgctggtagcggtggtttttttgtttgcaagcagcagattacgcgcagaaaaaaaggatctcaagaagatcctttgatcttttctacggggtctgacgctcagtggaacgaaaactcacgttaagggattttggtcatgagattatcaaaaaggatcttcacctagatccttttaaattaaaaatgaagttttaaatcaatctaaagtatatatgagtaaacttggtctgacagttaccaatgcttaatcagtgaggcacctatctcagcgatctgtctatttcgttcatccatagttgcctgactccccgtcgtgtagataactacgatacgggagggcttaccatctggccccagtgctgcaatgataccgcgagacccacgctcaccggctccagatttatcagcaataaaccagccagccggaagggccgagcgcagaagtggtcctgcaactttatccgcctccatccagtctattaattgttgccgggaagctagagtaagtagttcgccagttaatagtttgcgcaacgttgttgccattgctacaggcatcgtggtgtcacgctcgtcgtttggtatggcttcattcagctccggttcccaacgatcaaggcgagttacatgatcccccatgttgtgcaaaaaagcggttagctccttcggtcctccgatcgttgtcagaagtaagttggccgcagtgttatcactcatggttatggcagcactgcataattctcttactgtcatgccatccgtaagatgcttttctgtgactggtgagtactcaaccaagtcattctgagaatagtgtatgcggcgaccgagttgctcttgcccggcgtcaatacgggataataccgcgccacatagcagaactttaaaagtgctcatcattggaaaacgttcttcggggcgaaaactctcaaggatcttaccgctgttgagatccagttcgatgtaacccactcgtgcacccaactgatcttcagcatcttttactttcaccagcgtttctgggtgagcaaaaacaggaaggcaaaatgccgcaaaaaagggaataagggcgacacggaaatgttgaatactcatactcttcctttttcaatattattgaagcatttatcagggttattgtctcatgagcggatacatatttgaatgtatttagaaaaataaacaaataggggttccgcgcacatttccccgaaaagtgccacctgacgtctaagaaaccattattatcatgacattaacctataaaaataggcgtatcacgaggccctttcgtc',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(3,'pRSII313',NULL,'2013-05-28','','integrative','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n','','Lac Z','','pRSII313.gb.gz','TCGCGCGTTTCGGTGATGACGGTGAAAACCTCTGACACATGCAGCTCCCGGAGACGGTCACAGCTTGTCTGTAAGCGGATGCCGGGAGCAGACAAGCCCGTCAGGGCGCGTCAGCGGGTGTTGGCGGGTGTCGGGGCTGGCTTAACTATGCGGCATCAGAGCAGATTGTACTGAGAGTGCACCATAAATTCCCGTTTTAAGAGCTTGGTGAGCGCTAGGAGTCACTGCCAGGTATCGTTTGAACACGGCATTAGTCAGGGAAGTCATAACACAGTCCTTTCCCGCAATTTTCTTTTTCTATTACTCTTGGCCTCCTCTAGTACACTCTATATTTTTTTATGCCTCGGTAATGATTTTCATTTTTTTTTTTCCACCTAGCGGATGACTCTTTTTTTTTCTTAGCGATTGGCATTATCACATAATGAATTATACATTATATAAAGTAATGTGATTTCTTCGAAGAATATACTAAAAAATGAGCAGGCAAGATAAACGAAGGCAAAGATGACAGAGCAGAAAGCCCTAGTAAAGCGTATTACAAATGAAACCAAGATTCAGATTGCGATCTCTTTAAAGGGTGGTCCCCTAGCGATAGAGCACTCGATCTTCCCAGAAAAAGAGGCAGAAGCAGTAGCAGAACAGGCCACACAATCGCAAGTGATTAACGTCCACACAGGTATAGGGTTTCTGGACCATATGATACATGCTCTGGCCAAGCATTCCGGCTGGTCGCTAATCGTTGAGTGCATTGGTGACTTACACATAGACGACCATCACACCACTGAAGACTGCGGGATTGCTCTCGGTCAAGCATTTAAAGAGGCCCTAGGGGCCGTGCGTGGAGTAAAAAGGTTTGGATCAGGATTTGCGCCTTTGGATGAGGCACTTTCCAGAGCGGTGGTAGATCTTTCGAACAGGCCGTACGCAGTTGTCGAACTTGGTTTGCAAAGGGAGAAAGTAGGAGATCTCTCTTGCGAGATGATCCCGCATTTTCTTGAAAGTTTTGCAGAGGCTAGCAGAATTACCCTCCACGTTGATTGTCTGCGAGGCAAGAATGATCATCACCGTAGTGAGAGTGCGTTCAAGGCTCTTGCGGTTGCCATAAGAGAAGCCACCTCGCCCAATGGTACAAACGATGTTCCCTCCACCAAAGGTGTTCTTATGTAGTGACACCGATTATTTAAAGTTGCAGCATACGATATATATACATGTGTATATATGTATACCTATGAATGTCAGTAAGTATGTATACGAACAGTATGATACTGAAGATGACAAGGTAATGCATCATTCTATACGTGTCATTCTGAACGAGGCGCGCTTTCCTTTTTTCTTTTTGCTTTTTCTTTTTTTTTCTCTTGAACTCGACGGATCTATGCGGTGTGAAATACCGCACAGATGCGTAAGGAGAAAATACCGCATCAGGAAATTGTAAGCGTTAATATTTTGTTAAAATTCGCGTTAAATTTTTGTTAAATCAGCTCATTTTTTAACCAATAGGCCGAAATCGGCAAAATCCCTTATAAATCAAAAGAATAGACCGAGATAGGGTTGAGTGTTGTTCCAGTTTGGAACAAGAGTCCACTATTAAAGAACGTGGACTCCAACGTCAAAGGGCGAAAAACCGTCTATCAGGGCGATGGCCCACTACGTGAACCATCACCCTAATCAAGTTTTTTGGGGTCGAGGTGCCGTAAAGCACTAAATCGGAACCCTAAAGGGAGCCCCCGATTTAGAGCTTGACGGGGAAAGCCGGCGAACGTGGCGAGAAAGGAAGGGAAGAAAGCGAAAGGAGCGGGCGCTAGGGCGCTGGCAAGTGTAGCGGTCACGCTGCGCGTAACCACCACACCCGCCGCGCTTAATGCGCCGCTACAGGGCGCGTCCATTCGCCATTCAGGCTGCGCAACTGTTGGGAAGGGCGATCGGTGCGGGCCTCTTCGCTATTACGCCAGCTGGCGAAAGGGGGATGTGCTGCAAGGCGATTAAGTTGGGTAACGCCAGGGTTTTCCCAGTCACGACGTTGTAAAACGACGGCCAGTGAATTGTAATACGACTCACTATAGGGCGAATTGGAGCTCCACCGCGGTGGCGGCCGCTCTAGAACTAGTGGATCCCCCGGGCTGCAGGAATTCGATATCAAGCTTATCGATACCGTCGACCTCGAGGGGGGGCCCGGTACCAGCTTTTGTTCCCTTTAGTGAGGGTTAATTTCGAGCTTGGCGTAATCATGGTCATAGCTGTTTCCTGTGTGAAATTGTTATCCGCTCACAATTCCACACAACATACGAGCCGGAAGCATAAAGTGTAAAGCCTGGGGTGCCTAATGAGTGAGCTAACTCACATTAATTGCGTTGCGCTCACTGCCCGCTTTCCAGTCGGGAAACCTGTCGTGCCAGCTGCATTAATGAATCGGCCAACGCGCGGGGAGAGGCGGTTTGCGTATTGGGCGCTCTTCCGCTTCCTCGCTCACTGACTCGCTGCGCTCGGTCGTTCGGCTGCGGCGAGCGGTATCAGCTCACTCAAAGGCGGTAATACGGTTATCCACAGAATCAGGGGATAACGCAGGAAAGAACATGTGAGCAAAAGGCCAGCAAAAGGCCAGGAACCGTAAAAAGGCCGCGTTGCTGGCGTTTTTCCATAGGCTCCGCCCCCCTGACGAGCATCACAAAAATCGACGCTCAAGTCAGAGGTGGCGAAACCCGACAGGACTATAAAGATACCAGGCGTTTCCCCCTGGAAGCTCCCTCGTGCGCTCTCCTGTTCCGACCCTGCCGCTTACCGGATACCTGTCCGCCTTTCTCCCTTCGGGAAGCGTGGCGCTTTCTCATAGCTCACGCTGTAGGTATCTCAGTTCGGTGTAGGTCGTTCGCTCCAAGCTGGGCTGTGTGCACGAACCCCCCGTTCAGCCCGACCGCTGCGCCTTATCCGGTAACTATCGTCTTGAGTCCAACCCGGTAAGACACGACTTATCGCCACTGGCAGCAGCCACTGGTAACAGGATTAGCAGAGCGAGGTATGTAGGCGGTGCTACAGAGTTCTTGAAGTGGTGGCCTAACTACGGCTACACTAGAAGAACAGTATTTGGTATCTGCGCTCTGCTGAAGCCAGTTACCTTCGGAAAAAGAGTTGGTAGCTCTTGATCCGGCAAACAAACCACCGCTGGTAGCGGTGGTTTTTTTGTTTGCAAGCAGCAGATTACGCGCAGAAAAAAAGGATCTCAAGAAGATCCTTTGATCTTTTCTACGGGGTCTGACGCTCAGTGGAACGAAAACTCACGTTAAGGGATTTTGGTCATGAGATTATCAAAAAGGATCTTCACCTAGATCCTTTTAAATTAAAAATGAAGTTTTAAATCAATCTAAAGTATATATGAGTAAACTTGGTCTGACAGTTACCAATGCTTAATCAGTGAGGCACCTATCTCAGCGATCTGTCTATTTCGTTCATCCATAGTTGCCTGACTCCCCGTCGTGTAGATAACTACGATACGGGAGGGCTTACCATCTGGCCCCAGTGCTGCAATGATACCGCGAGACCCACGCTCACCGGCTCCAGATTTATCAGCAATAAACCAGCCAGCCGGAAGGGCCGAGCGCAGAAGTGGTCCTGCAACTTTATCCGCCTCCATCCAGTCTATTAATTGTTGCCGGGAAGCTAGAGTAAGTAGTTCGCCAGTTAATAGTTTGCGCAACGTTGTTGCCATTGCTACAGGCATCGTGGTGTCACGCTCGTCGTTTGGTATGGCTTCATTCAGCTCCGGTTCCCAACGATCAAGGCGAGTTACATGATCCCCCATGTTGTGCAAAAAAGCGGTTAGCTCCTTCGGTCCTCCGATCGTTGTCAGAAGTAAGTTGGCCGCAGTGTTATCACTCATGGTTATGGCAGCACTGCATAATTCTCTTACTGTCATGCCATCCGTAAGATGCTTTTCTGTGACTGGTGAGTACTCAACCAAGTCATTCTGAGAATAGTGTATGCGGCGACCGAGTTGCTCTTGCCCGGCGTCAATACGGGATAATACCGCGCCACATAGCAGAACTTTAAAAGTGCTCATCATTGGAAAACGTTCTTCGGGGCGAAAACTCTCAAGGATCTTACCGCTGTTGAGATCCAGTTCGATGTAACCCACTCGTGCACCCAACTGATCTTCAGCATCTTTTACTTTCACCAGCGTTTCTGGGTGAGCAAAAACAGGAAGGCAAAATGCCGCAAAAAAGGGAATAAGGGCGACACGGAAATGTTGAATACTCATACTCTTCCTTTTTCAATATTATTGAAGCATTTATCAGGGTTATTGTCTCATGAGCGGATACATATTTGAATGTATTTAGAAAAATAAACAAATAGGGGTTCCGCGCACATTTCCCCGAAAAGTGCCACCTGggtccttttcatcacgtgctataaaaataattataatttaaattttttaatataaatatataaattaaaaatagaaagtaaaaaaagaaattaaagaaaaaatagtttttgttttccgaagatgtaaaagactctagggggatcgccaacaaatactaccttttatcttgctcttcctgctctcaggtattaatgccgaattgtttcatcttgtctgtgtagaagaccacacacgaaaatcctgtgattttacattttacttatcgttaatcgaatgtatatctatttaatctgcttttcttgtctaataaatatatatgtaaagtacgctttttgttgaaattttttaaacctttgtttatttttttttcttcattccgtaactcttctaccttctttatttactttctaaaatccaaatacaaaacataaaaataaataaacacagagtaaattcccaaattattccatcattaaaagatacgaggcgcgtgtaagttacaggcaagcgatcCGTCTAAGAAACCATTATTATCATGACATTAACCTATAAAAATAGGCGTATCACGAGGCCCTTTCGTC',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(4,'pRSII323',NULL,'2013-05-29','','2-mu','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n2 micron origin is from YEplac195, which has had its XbaI site removed.','','Lac Z','','pRSII323.gb.gz','TCGCGCGTTTCGGTGATGACGGTGAAAACCTCTGACACATGCAGCTCCCGGAGACGGTCACAGCTTGTCTGTAAGCGGATGCCGGGAGCAGACAAGCCCGTCAGGGCGCGTCAGCGGGTGTTGGCGGGTGTCGGGGCTGGCTTAACTATGCGGCATCAGAGCAGATTGTACTGAGAGTGCACCATAAATTCCCGTTTTAAGAGCTTGGTGAGCGCTAGGAGTCACTGCCAGGTATCGTTTGAACACGGCATTAGTCAGGGAAGTCATAACACAGTCCTTTCCCGCAATTTTCTTTTTCTATTACTCTTGGCCTCCTCTAGTACACTCTATATTTTTTTATGCCTCGGTAATGATTTTCATTTTTTTTTTTCCACCTAGCGGATGACTCTTTTTTTTTCTTAGCGATTGGCATTATCACATAATGAATTATACATTATATAAAGTAATGTGATTTCTTCGAAGAATATACTAAAAAATGAGCAGGCAAGATAAACGAAGGCAAAGATGACAGAGCAGAAAGCCCTAGTAAAGCGTATTACAAATGAAACCAAGATTCAGATTGCGATCTCTTTAAAGGGTGGTCCCCTAGCGATAGAGCACTCGATCTTCCCAGAAAAAGAGGCAGAAGCAGTAGCAGAACAGGCCACACAATCGCAAGTGATTAACGTCCACACAGGTATAGGGTTTCTGGACCATATGATACATGCTCTGGCCAAGCATTCCGGCTGGTCGCTAATCGTTGAGTGCATTGGTGACTTACACATAGACGACCATCACACCACTGAAGACTGCGGGATTGCTCTCGGTCAAGCATTTAAAGAGGCCCTAGGGGCCGTGCGTGGAGTAAAAAGGTTTGGATCAGGATTTGCGCCTTTGGATGAGGCACTTTCCAGAGCGGTGGTAGATCTTTCGAACAGGCCGTACGCAGTTGTCGAACTTGGTTTGCAAAGGGAGAAAGTAGGAGATCTCTCTTGCGAGATGATCCCGCATTTTCTTGAAAGTTTTGCAGAGGCTAGCAGAATTACCCTCCACGTTGATTGTCTGCGAGGCAAGAATGATCATCACCGTAGTGAGAGTGCGTTCAAGGCTCTTGCGGTTGCCATAAGAGAAGCCACCTCGCCCAATGGTACAAACGATGTTCCCTCCACCAAAGGTGTTCTTATGTAGTGACACCGATTATTTAAAGTTGCAGCATACGATATATATACATGTGTATATATGTATACCTATGAATGTCAGTAAGTATGTATACGAACAGTATGATACTGAAGATGACAAGGTAATGCATCATTCTATACGTGTCATTCTGAACGAGGCGCGCTTTCCTTTTTTCTTTTTGCTTTTTCTTTTTTTTTCTCTTGAACTCGACGGATCTATGCGGTGTGAAATACCGCACAGATGCGTAAGGAGAAAATACCGCATCAGGAAATTGTAAGCGTTAATATTTTGTTAAAATTCGCGTTAAATTTTTGTTAAATCAGCTCATTTTTTAACCAATAGGCCGAAATCGGCAAAATCCCTTATAAATCAAAAGAATAGACCGAGATAGGGTTGAGTGTTGTTCCAGTTTGGAACAAGAGTCCACTATTAAAGAACGTGGACTCCAACGTCAAAGGGCGAAAAACCGTCTATCAGGGCGATGGCCCACTACGTGAACCATCACCCTAATCAAGTTTTTTGGGGTCGAGGTGCCGTAAAGCACTAAATCGGAACCCTAAAGGGAGCCCCCGATTTAGAGCTTGACGGGGAAAGCCGGCGAACGTGGCGAGAAAGGAAGGGAAGAAAGCGAAAGGAGCGGGCGCTAGGGCGCTGGCAAGTGTAGCGGTCACGCTGCGCGTAACCACCACACCCGCCGCGCTTAATGCGCCGCTACAGGGCGCGTCCATTCGCCATTCAGGCTGCGCAACTGTTGGGAAGGGCGATCGGTGCGGGCCTCTTCGCTATTACGCCAGCTGGCGAAAGGGGGATGTGCTGCAAGGCGATTAAGTTGGGTAACGCCAGGGTTTTCCCAGTCACGACGTTGTAAAACGACGGCCAGTGAATTGTAATACGACTCACTATAGGGCGAATTGGAGCTCCACCGCGGTGGCGGCCGCTCTAGAACTAGTGGATCCCCCGGGCTGCAGGAATTCGATATCAAGCTTATCGATACCGTCGACCTCGAGGGGGGGCCCGGTACCAGCTTTTGTTCCCTTTAGTGAGGGTTAATTTCGAGCTTGGCGTAATCATGGTCATAGCTGTTTCCTGTGTGAAATTGTTATCCGCTCACAATTCCACACAACATACGAGCCGGAAGCATAAAGTGTAAAGCCTGGGGTGCCTAATGAGTGAGCTAACTCACATTAATTGCGTTGCGCTCACTGCCCGCTTTCCAGTCGGGAAACCTGTCGTGCCAGCTGCATTAATGAATCGGCCAACGCGCGGGGAGAGGCGGTTTGCGTATTGGGCGCTCTTCCGCTTCCTCGCTCACTGACTCGCTGCGCTCGGTCGTTCGGCTGCGGCGAGCGGTATCAGCTCACTCAAAGGCGGTAATACGGTTATCCACAGAATCAGGGGATAACGCAGGAAAGAACATGTGAGCAAAAGGCCAGCAAAAGGCCAGGAACCGTAAAAAGGCCGCGTTGCTGGCGTTTTTCCATAGGCTCCGCCCCCCTGACGAGCATCACAAAAATCGACGCTCAAGTCAGAGGTGGCGAAACCCGACAGGACTATAAAGATACCAGGCGTTTCCCCCTGGAAGCTCCCTCGTGCGCTCTCCTGTTCCGACCCTGCCGCTTACCGGATACCTGTCCGCCTTTCTCCCTTCGGGAAGCGTGGCGCTTTCTCATAGCTCACGCTGTAGGTATCTCAGTTCGGTGTAGGTCGTTCGCTCCAAGCTGGGCTGTGTGCACGAACCCCCCGTTCAGCCCGACCGCTGCGCCTTATCCGGTAACTATCGTCTTGAGTCCAACCCGGTAAGACACGACTTATCGCCACTGGCAGCAGCCACTGGTAACAGGATTAGCAGAGCGAGGTATGTAGGCGGTGCTACAGAGTTCTTGAAGTGGTGGCCTAACTACGGCTACACTAGAAGAACAGTATTTGGTATCTGCGCTCTGCTGAAGCCAGTTACCTTCGGAAAAAGAGTTGGTAGCTCTTGATCCGGCAAACAAACCACCGCTGGTAGCGGTGGTTTTTTTGTTTGCAAGCAGCAGATTACGCGCAGAAAAAAAGGATCTCAAGAAGATCCTTTGATCTTTTCTACGGGGTCTGACGCTCAGTGGAACGAAAACTCACGTTAAGGGATTTTGGTCATGAGATTATCAAAAAGGATCTTCACCTAGATCCTTTTAAATTAAAAATGAAGTTTTAAATCAATCTAAAGTATATATGAGTAAACTTGGTCTGACAGTTACCAATGCTTAATCAGTGAGGCACCTATCTCAGCGATCTGTCTATTTCGTTCATCCATAGTTGCCTGACTCCCCGTCGTGTAGATAACTACGATACGGGAGGGCTTACCATCTGGCCCCAGTGCTGCAATGATACCGCGAGACCCACGCTCACCGGCTCCAGATTTATCAGCAATAAACCAGCCAGCCGGAAGGGCCGAGCGCAGAAGTGGTCCTGCAACTTTATCCGCCTCCATCCAGTCTATTAATTGTTGCCGGGAAGCTAGAGTAAGTAGTTCGCCAGTTAATAGTTTGCGCAACGTTGTTGCCATTGCTACAGGCATCGTGGTGTCACGCTCGTCGTTTGGTATGGCTTCATTCAGCTCCGGTTCCCAACGATCAAGGCGAGTTACATGATCCCCCATGTTGTGCAAAAAAGCGGTTAGCTCCTTCGGTCCTCCGATCGTTGTCAGAAGTAAGTTGGCCGCAGTGTTATCACTCATGGTTATGGCAGCACTGCATAATTCTCTTACTGTCATGCCATCCGTAAGATGCTTTTCTGTGACTGGTGAGTACTCAACCAAGTCATTCTGAGAATAGTGTATGCGGCGACCGAGTTGCTCTTGCCCGGCGTCAATACGGGATAATACCGCGCCACATAGCAGAACTTTAAAAGTGCTCATCATTGGAAAACGTTCTTCGGGGCGAAAACTCTCAAGGATCTTACCGCTGTTGAGATCCAGTTCGATGTAACCCACTCGTGCACCCAACTGATCTTCAGCATCTTTTACTTTCACCAGCGTTTCTGGGTGAGCAAAAACAGGAAGGCAAAATGCCGCAAAAAAGGGAATAAGGGCGACACGGAAATGTTGAATACTCATACTCTTCCTTTTTCAATATTATTGAAGCATTTATCAGGGTTATTGTCTCATGAGCGGATACATATTTGAATGTATTTAGAAAAATAAACAAATAGGGGTTCCGCGCACATTTCCCCGAAAAGTGCCACCTGAAcgaagcatctgtgcttcattttgtagaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgaaagcgctattttaccaacgaagaatctgtgcttcatttttgtaaaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgagagcgctattttaccaacaaagaatctatacttcttttttgttctacaaaaatgcatcccgagagcgctatttttctaacaaagcatcttagattactttttttctcctttgtgcgctctataatgcagtctcttgataactttttgcactgtaggtccgttaaggttagaagaaggctactttggtgtctattttctcttccataaaaaaagcctgactccacttcccgcgtttactgattactagcgaagctgcgggtgcattttttcaagataaaggcatccccgattatattctataccgatgtggattgcgcatactttgtgaacagaaagtgatagcgttgatgattcttcattggtcagaaaattatgaacggtttcttctattttgtctctatatactacgtataggaaatgtttacattttcgtattgttttcgattcactctatgaatagttcttactacaatttttttgtctaaagagtaatactagagataaacataaaaaatgtagaggtcgagtttagatgcaagttcaaggagcgaaaggtggatgggtaggttatatagggatatagcacagagatatatagcaaagagatacttttgagcaatgtttgtggaagcggtattcgcaatattttagtagctcgttacagtccggtgcgtttttggttttttgaaagtgcgtcttcagagcgcttttggttttcaaaagcgctctgaagttcctatactttctagCTAGagaataggaacttcggaataggaacttcaaagcgtttccgaaaacgagcgcttccgaaaatgcaacgcgagctgcgcacatacagctcactgttcacgtcgcacctatatctgcgtgttgcctgtatatatatatacatgagaagaacggcatagtgcgtgtttatgcttaaatgcgtacttatatgcgtctatttatgtaggatgaaaggtagtctagtacctcctgtgatattatcccattccatgcggggtatcgtatgcttccttcagcactaccctttagctgttctatatgctgccactcctcaattggattagtctcatccttcaatgctatcatttcctttgatattggatcaTCTAAGAAACCATTATTATCATGACATTAACCTATAAAAATAGGCGTATCACGAGGCCCTTTCGTC',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL),(5,'pRSII423',NULL,'2013-05-29','','2-mu','HIS3','','Amp','','','','','Bought from Addgene\r\n\r\nHIS3 has been modified to remove HindIII, KpnI, and PstI sites without altering the amino acid sequence of the His3 protein.\r\n\r\n2 micron replication origin is from YEplac195 and has had its XbaI site removed.','','Lac Z','','pRSII423.gb.gz','tcgcgcgtttcggtgatgacggtgaaaacctctgacacatgcagctcccggagacggtcacagcttgtctgtaagcggatgccgggagcagacaagcccgtcagggcgcgtcagcgggtgttggcgggtgtcggggctggcttaactatgcggcatcagagcagattgtactgagagtgcaccataaattcccgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttccAcctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaagatgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcAtttaaagaggccctaGGggcCGTgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagTtttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtacAaacgatgttccctccaccaaaggtgttcttatgtagtgacaccgattatttaaagTtgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcgacggatctatgcggtgtgaaataccgcacagatgcgtaaggagaaaataccgcatcaggaaattgtaaGcgttaatattttgttaaaattcgcgttaaatttttgttaaatcagctcattttttaaccaataggccgaaatcggcaaaatcccttataaatcaaaagaatagaccgagatagggttgagtgttgttccagtttggaacaagagtccactattaaagaacgtggactccaacgtcaaagggcgaaaaaccgtctatcagggcgatggcccactacgtgaaccatcaccctaatcaagttttttggggtcgaggtgccgtaaagcactaaatcggaaccctaaagggagcccccgatttagagcttgacggggaaagccggcgaacgtggcgagaaaggaagggaagaaagcgaaaggagcgggcgctagggcgctggcaagtgtagcggtcacgctgcgcgtaaccaccacacccgccgcgcttaatgcgccgctacagggcgcgtccattcgccattcaggctgcgcaactgttgggaagggcgatcggtgcgggcctcttcgctattacgccagctggcgaaagggggatgtgctgcaaggcgattaagttgggtaacgccagggttttcccagtcacgacgttgtaaaacgacggccagtgagcgcgcgtaatacgactcactatagggcgaattgggtaccgggccccccctcgaggtcgacggtatcgataagcttgatatcgaattcctgcagcccgggggatccactagttctagagcggccgccaccgcggtggagctccagcttttgttccctttagtgagggttaattgcgcgcttggcgtaatcatggtcatagctgtttcctgtgtgaaattgttatccgctcacaattccacacaacataCgagccggaagcataaagtgtaaagcctggggtgcctaatgagtgagCtaactcacattaattgcgttgcgctcactgcccgctttccagtcgggaaacctgtcgtgccagctgcattaatgaatcggccaacgcgcggggagaggcggtttgcgtattgggcgctcttccgcttcctcgctcactgactcgctgcgctcggtcgttcggctgcggcgagcggtatcagctcactcaaaggcggtaatacggttatccacagaatcaggggataacgcaggaaagaacatgtgagcaaaaggccagcaaaaggccaggaaccgtaaaaaggccgcgttgctggcgtttttccataggctccgcccccctgacgagcatcacaaaaatcgacgctcaagtcagaggtggcgaaacccgacaggactataaagataccaggcgtttccccctggaagctccctcgtgcgctctcctgttccgaccctgccgcttaccggatacctgtccgcctttctcccttcgggaagcgtggcgctttctcatagctcacgctgtaggtatctcagttcggtgtaggtcgttcgctccaagctgggctgtgtgcacgaaccccccgttcagcccgaccgctgcgccttatccggtaactatcgtcttgagtccaacccggtaagacacgacttatcgccactggcagcagccactggtaacaggattagcagagcgaggtatgtaggcggtgctacagagttcttgaagtggtggcctaactacggctacactagaagAacagtatttggtatctgcgctctgctgaagccagttaccttcggaaaaagagttggtagctcttgatccggcaaacaaaccaccgctggtagcggtggtttttttgtttgcaagcagcagattacgcgcagaaaaaaaggatctcaagaagatcctttgatcttttctacggggtctgacgctcagtggaacgaaaactcacgttaagggattttggtcatgagattatcaaaaaggatcttcacctagatccttttaaattaaaaatgaagttttaaatcaatctaaagtatatatgagtaaacttggtctgacagttaccaatgcttaatcagtgaggcacctatctcagcgatctgtctatttcgttcatccatagttgcctgactccccgtcgtgtagataactacgatacgggagggcttaccatctggccccagtgctgcaatgataccgcgagacccacgctcaccggctccagatttatcagcaataaaccagccagccggaagggccgagcgcagaagtggtcctgcaactttatccgcctccatccagtctattaattgttgccgggaagctagagtaagtagttcgccagttaatagtttgcgcaacgttgttgccattgctacaggcatcgtggtgtcacgctcgtcgtttggtatggcttcattcagctccggttcccaacgatcaaggcgagttacatgatcccccatgttgtgcaaaaaagcggttagctccttcggtcctccgatcgttgtcagaagtaagttggccgcagtgttatcactcatggttatggcagcactgcataattctcttactgtcatgccatccgtaagatgcttttctgtgactggtgagtactcaaccaagtcattctgagaatagtgtatgcggcgaccgagttgctcttgcccggcgtcaatacgggataataccgcgccacatagcagaactttaaaagtgctcatcattggaaaacgttcttcggggcgaaaactctcaaggatcttaccgctgttgagatccagttcgatgtaacccactcgtgcacccaactgatcttcagcatcttttactttcaccagcgtttctgggtgagcaaaaacaggaaggcaaaatgccgcaaaaaagggaataagggcgacacggaaatgttgaatactcatactcttcctttttcaatattattgaagcatttatcagggttattgtctcatgagcggatacatatttgaatgtatttagaaaaataaacaaataggggttccgcgcacatttccccgaaaagtgccacctgaAcgaagcatctgtgcttcattttgtagaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgaaagcgctattttaccaacgaagaatctgtgcttcatttttgtaaaacaaaaatgcaacgcgagagcgctaatttttcaaacaaagaatctgagctgcatttttacagaacagaaatgcaacgcgagagcgctattttaccaacaaagaatctatacttcttttttgttctacaaaaatgcatcccgagagcgctatttttctaacaaagcatcttagattactttttttctcctttgtgcgctctataatgcagtctcttgataactttttgcactgtaggtccgttaaggttagaagaaggctactttggtgtctattttctcttccataaaaaaagcctgactccacttcccgcgtttactgattactagcgaagctgcgggtgcattttttcaagataaaggcatccccgattatattctataccgatgtggattgcgcatactttgtgaacagaaagtgatagcgttgatgattcttcattggtcagaaaattatgaacggtttcttctattttgtctctatatactacgtataggaaatgtttacattttcgtattgttttcgattcactctatgaatagttcttactacaatttttttgtctaaagagtaatactagagataaacataaaaaatgtagaggtcgagtttagatgcaagttcaaggagcgaaaggtggatgggtaggttatatagggatatagcacagagatatatagcaaagagatacttttgagcaatgtttgtggaagcggtattcgcaatattttagtagctcgttacagtccggtgcgtttttggttttttgaaagtgcgtcttcagagcgcttttggttttcaaaagcgctctgaagttcctatactttctagCTAGagaataggaacttcggaataggaacttcaaagcgtttccgaaaacgagcgcttccgaaaatgcaacgcgagctgcgcacatacagctcactgttcacgtcgcacctatatctgcgtgttgcctgtatatatatatacatgagaagaacggcatagtgcgtgtttatgcttaaatgcgtacttatatgcgtctatttatgtaggatgaaaggtagtctagtacctcctgtgatattatcccattccatgcggggtatcgtatgcttccttcagcactaccctttagctgttctatatgctgccactcctcaattggattagtctcatccttcaatgctatcatttcctttgatattggatcatctaagaaaccattattatcatgacattaacctataaaaataggcgtatcacgaggccctttcgtc',NULL,'Gift.or.Purchased',NULL,NULL,NULL,NULL);

/*!40000 ALTER TABLE `plasmids` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `st_ADE2`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `st_ADE2` (

  `alleles` varchar(20) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `st_ADE2` WRITE;

/*!40000 ALTER TABLE `st_ADE2` DISABLE KEYS */;

INSERT INTO `st_ADE2` VALUES (''),('ade2-1'),('ade2-1/ADE2'),('ade2-1/ade2-1'),('ADE2.'),('ade2/ade2'),('ade2∆::hisG'),('loxP-ADE2-loxP-HphMX'),('unknown');

/*!40000 ALTER TABLE `st_ADE2` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `st_HIS3`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `st_HIS3` (

  `alleles` varchar(40) NOT NULL,

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `st_HIS3` WRITE;

/*!40000 ALTER TABLE `st_HIS3` DISABLE KEYS */;

INSERT INTO `st_HIS3` VALUES (''),('his3'),('his3-11,15'),('his3-11,15/HIS3'),('his3-11,15/his3-11,15'),('HIS3.'),('his3∆1'),('his3∆1/HIS3'),('his3∆1/his3∆1'),('his3∆200'),('his3∆200/HIS3'),('his3∆200/his3∆200'),('unknown');

/*!40000 ALTER TABLE `st_HIS3` ENABLE KEYS */;

UNLOCK TABLES;