LBMC » MyLabStocks

Reporting Bugs

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

If you think you have found a bug and would like to report the

problem, then please ensure you have applied all applicable updates.

If this is the case, send a description of your problem and some

screenshot to florent.chuffart on its ens-lyon.fr email. Thank you for

your contribution.

We HIGHLY RECOMMEND THAT YOU REGULARLY BACKUP you MyLabStocks

database. We provide two levels of backup. The first only dump the

mySQL database and the second also add the uploaded files

(plasmid_files raw_dirs directories in your /var/www/labstocks

directory). These two features are available on the *home* page. The

two links in the sentence *Backup the entire system or only the

database NOW!* allow any user to download the requested backups. It

could be useful for an administrator to integrate it in a robust file

backup system using for example a cron that regularly pull the

archives (*wget http://.../labstocks/backup.php?FULL_BACK=1*).

How To Restore System From Backup

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

On the targeted server, you can restore database from the last backup

(file ''labstocks_db.sql'') by typing the following command in a

terminal. It drops existing tables, creates new one and restore data.

You have to adapt user password and database name according to your

setting.

   sudo mysql --user=root --password=root labstocks_db < labstocks_db.sql

To restore uploaded file, you have to copy backuped directories

(''plasmid_files'' and ''raw_dirs'') to your labstocks directory. To

do that, on the targeted server type the following commands in a

terminal.

   sudo cp -r plasmid_files raw_dirs /var/www/labstocks/.

Extend Database

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

MyLabstock is delivrer under a free licence. Feel free to modify and

extend it as to adapt it to your your own lab. To do that you could

easily create new table using phpMyAdmin

(http://your_server/phpmyadmin)

http://http://your_server/yourserver)ou mysql command line tool

(documentation here

http://dev.mysql.com/doc/refman/5.6/en/mysql.html). MyLabStocks uses

the  framework phpMyEdit to manaeg the user interface. Use the

provided tool http://your_server/phpMyEditSetup.php to generate code.

For any question please refer to the embeded documention

(http://your_server/labstocks/doc/html/).

version = '0.1.4'

release = '0.1.4'

Reporting Bugs

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

If you think you have found a bug and would like to report the problem, then please ensure you have applied all applicable updates. If this is the case, send a description of your problem and some screenshot to florent.chuffart on its ens-lyon.fr email. Thank you for your contribution.

We HIGHLY RECOMMEND THAT YOU REGULARLY BACKUP you MyLabStocks database. We provide two levels of backup. The first only dump the mySQL database and the second also add the uploaded files (plasmid_files raw_dirs directories in your /var/www/labstocks directory). These two features are available on the *home* page. The two links in the sentence *Backup the entire system or only the database NOW!* allow any user to download the requested backups. It could be useful for an administrator to integrate it in a robust file backup system using for example a cron that regularly pull the archives (*wget http://.../labstocks/backup.php?FULL_BACK=1*). 

How To Restore System From Backup

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

On the targeted server, you can restore database from the last backup (file ''labstocks_db.sql'') by typing the following command in a terminal. It drops existing tables, creates new one and restore data. You have to adapt user password and database name according to your setting.

.. code:: bash

  sudo mysql --user=root --password=root labstocks_db < labstocks_db.sql 

..

To restore uploaded file, you have to copy backuped directories (''plasmid_files'' and ''raw_dirs'') to your labstocks directory. To do that, on the targeted server type the following commands in a terminal.

.. code:: bash

  sudo cp -r plasmid_files raw_dirs /var/www/labstocks/. 

..

Extend Database

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

MyLabstock is delivrer under a free licence. Feel free to modify and extend it as to adapt it to your your own lab. To do that you could easily create new table using phpMyAdmin (http://your_server/phpmyadmin) http://http://your_server/yourserver)ou mysql command line tool (documentation here http://dev.mysql.com/doc/refman/5.6/en/mysql.html). MyLabStocks uses the  framework phpMyEdit to manaeg the user interface. Use the provided tool http://your_server/phpMyEditSetup.php to generate code. For any question please refer to the embeded documention (http://your_server/labstocks/doc/html/).

if ($tb != "home" & $tb != "rack" ) {

            <li id="cl_name"><span><a href="cl_name.php"> Cell Line Names </a></span></li>

            <li id="cl_passages"><span><a href="cl_passages.php"> Cell Line Passages </a></span></li>

            <li id="cl_storage"><span><a href="cl_storage.php"> Cell Line Storage </a></span></li>

            <li id="rack"><span><a href="rack.php"> Box Manager </a></span></li>

            <li id="wwwblast"><span><a href="wwwblast.php"> wwwBLAST </a></span></li>

			echo $this->timer->end(),' milliseconds';

-- 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;