Révision 73b5ba45
| b/src/sql/labstocks_db.sql | ||
|---|---|---|
| 1 |
-- phpMyAdmin SQL Dump |
|
| 2 |
-- version 3.4.11.1deb2 |
|
| 3 |
-- http://www.phpmyadmin.net |
|
| 4 |
-- |
|
| 5 |
-- Host: localhost |
|
| 6 |
-- Generation Time: Oct 23, 2013 at 06:24 AM |
|
| 7 |
-- Server version: 5.5.31 |
|
| 8 |
-- PHP Version: 5.4.4-14+deb7u5 |
|
| 9 |
|
|
| 10 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
| 11 |
SET time_zone = "+00:00"; |
|
| 12 |
|
|
| 13 |
|
|
| 14 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|
| 15 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
|
| 16 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
|
| 17 |
/*!40101 SET NAMES utf8 */; |
|
| 18 |
|
|
| 19 |
-- |
|
| 20 |
-- Database: `labstocks_db` |
|
| 21 |
-- |
|
| 22 |
|
|
| 23 |
-- -------------------------------------------------------- |
|
| 24 |
|
|
| 25 |
-- |
|
| 26 |
-- Table structure for table `ab_avail` |
|
| 27 |
-- |
|
| 28 |
|
|
| 29 |
CREATE TABLE IF NOT EXISTS `ab_avail` ( |
|
| 30 |
`Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 31 |
PRIMARY KEY (`Type`) |
|
| 32 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 33 |
|
|
| 34 |
-- |
|
| 35 |
-- Dumping data for table `ab_avail` |
|
| 36 |
-- |
|
| 37 |
|
|
| 38 |
INSERT INTO `ab_avail` (`Type`) VALUES |
|
| 39 |
('available'),
|
|
| 40 |
('out of stock');
|
|
| 41 |
|
|
| 42 |
-- -------------------------------------------------------- |
|
| 43 |
|
|
| 44 |
-- |
|
| 45 |
-- Table structure for table `ab_host` |
|
| 46 |
-- |
|
| 47 |
|
|
| 48 |
CREATE TABLE IF NOT EXISTS `ab_host` ( |
|
| 49 |
`Host` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 50 |
PRIMARY KEY (`Host`) |
|
| 51 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 52 |
|
|
| 53 |
-- |
|
| 54 |
-- Dumping data for table `ab_host` |
|
| 55 |
-- |
|
| 56 |
|
|
| 57 |
INSERT INTO `ab_host` (`Host`) VALUES |
|
| 58 |
('goat'),
|
|
| 59 |
('horse'),
|
|
| 60 |
('mouse'),
|
|
| 61 |
('rabbit');
|
|
| 62 |
|
|
| 63 |
-- -------------------------------------------------------- |
|
| 64 |
|
|
| 65 |
-- |
|
| 66 |
-- Table structure for table `ab_monopoly` |
|
| 67 |
-- |
|
| 68 |
|
|
| 69 |
CREATE TABLE IF NOT EXISTS `ab_monopoly` ( |
|
| 70 |
`Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 71 |
PRIMARY KEY (`Type`) |
|
| 72 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 73 |
|
|
| 74 |
-- |
|
| 75 |
-- Dumping data for table `ab_monopoly` |
|
| 76 |
-- |
|
| 77 |
|
|
| 78 |
INSERT INTO `ab_monopoly` (`Type`) VALUES |
|
| 79 |
('monoclonal'),
|
|
| 80 |
('polyclonal');
|
|
| 81 |
|
|
| 82 |
-- -------------------------------------------------------- |
|
| 83 |
|
|
| 84 |
-- |
|
| 85 |
-- Table structure for table `ab_supplier` |
|
| 86 |
-- |
|
| 87 |
|
|
| 88 |
CREATE TABLE IF NOT EXISTS `ab_supplier` ( |
|
| 89 |
`Supplier` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 90 |
PRIMARY KEY (`Supplier`) |
|
| 91 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 92 |
|
|
| 93 |
-- |
|
| 94 |
-- Dumping data for table `ab_supplier` |
|
| 95 |
-- |
|
| 96 |
|
|
| 97 |
INSERT INTO `ab_supplier` (`Supplier`) VALUES |
|
| 98 |
('Abcam'),
|
|
| 99 |
('ActiveMotif'),
|
|
| 100 |
('Covance/Eurogentec'),
|
|
| 101 |
('Diagenode'),
|
|
| 102 |
('MPBiomedicals'),
|
|
| 103 |
('Sigma'),
|
|
| 104 |
('Upstate/Millipore');
|
|
| 105 |
|
|
| 106 |
-- -------------------------------------------------------- |
|
| 107 |
|
|
| 108 |
-- |
|
| 109 |
-- Table structure for table `ab_type` |
|
| 110 |
-- |
|
| 111 |
|
|
| 112 |
CREATE TABLE IF NOT EXISTS `ab_type` ( |
|
| 113 |
`Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 114 |
PRIMARY KEY (`Type`) |
|
| 115 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 116 |
|
|
| 117 |
-- |
|
| 118 |
-- Dumping data for table `ab_type` |
|
| 119 |
-- |
|
| 120 |
|
|
| 121 |
INSERT INTO `ab_type` (`Type`) VALUES |
|
| 122 |
('monoclonal'),
|
|
| 123 |
('polyclonal');
|
|
| 124 |
|
|
| 125 |
-- -------------------------------------------------------- |
|
| 126 |
|
|
| 127 |
-- |
|
| 128 |
-- Table structure for table `antibodies` |
|
| 129 |
-- |
|
| 130 |
|
|
| 131 |
CREATE TABLE IF NOT EXISTS `antibodies` ( |
|
| 132 |
`id` int(15) NOT NULL, |
|
| 133 |
`Antigen` varchar(150) NOT NULL, |
|
| 134 |
`InStock` varchar(25) NOT NULL, |
|
| 135 |
`Date` date DEFAULT NULL, |
|
| 136 |
`Comments` longtext, |
|
| 137 |
`Host` varchar(40) DEFAULT NULL, |
|
| 138 |
`Ordered_by` varchar(50) DEFAULT NULL, |
|
| 139 |
`Type` varchar(40) NOT NULL, |
|
| 140 |
`Batch_Reference` varchar(40) DEFAULT NULL, |
|
| 141 |
`Supplier` varchar(40) NOT NULL, |
|
| 142 |
`Location` varchar(40) NOT NULL, |
|
| 143 |
`Dilution-WB` text NOT NULL, |
|
| 144 |
`Volume-ChIP` text NOT NULL, |
|
| 145 |
`ProductID` varchar(20) NOT NULL, |
|
| 146 |
PRIMARY KEY (`id`), |
|
| 147 |
KEY `Author` (`Ordered_by`) |
|
| 148 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
|
| 149 |
|
|
| 150 |
-- |
|
| 151 |
-- Dumping data for table `antibodies` |
|
| 152 |
-- |
|
| 153 |
|
|
| 154 |
INSERT INTO `antibodies` (`id`, `Antigen`, `InStock`, `Date`, `Comments`, `Host`, `Ordered_by`, `Type`, `Batch_Reference`, `Supplier`, `Location`, `Dilution-WB`, `Volume-ChIP`, `ProductID`) VALUES |
|
| 155 |
(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.Yvert', 'monoclonal', '9045J', 'MPBiomedicals', 'Boite Ac Primaires#1 / Tiroir #3', '1:20000', '', '69100'); |
|
| 156 |
|
|
| 157 |
-- -------------------------------------------------------- |
|
| 158 |
|
|
| 159 |
-- |
|
| 160 |
-- Table structure for table `lab_members` |
|
| 161 |
-- |
|
| 162 |
|
|
| 163 |
CREATE TABLE IF NOT EXISTS `lab_members` ( |
|
| 164 |
`id` varchar(50) NOT NULL, |
|
| 165 |
PRIMARY KEY (`id`) |
|
| 166 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; |
|
| 167 |
|
|
| 168 |
-- |
|
| 169 |
-- Dumping data for table `lab_members` |
|
| 170 |
-- |
|
| 171 |
|
|
| 172 |
INSERT INTO `lab_members` (`id`) VALUES |
|
| 173 |
('Christelle.Damon'),
|
|
| 174 |
('Florent.Chuffart'),
|
|
| 175 |
('Gael.Yvert'),
|
|
| 176 |
('Gift.or.Purchased'),
|
|
| 177 |
('Helene.Bottin');
|
|
| 178 |
|
|
| 179 |
-- -------------------------------------------------------- |
|
| 180 |
|
|
| 181 |
-- |
|
| 182 |
-- Table structure for table `notebooks` |
|
| 183 |
-- |
|
| 184 |
|
|
| 185 |
CREATE TABLE IF NOT EXISTS `notebooks` ( |
|
| 186 |
`ID` int(15) unsigned NOT NULL, |
|
| 187 |
`Begin_Date` date DEFAULT NULL, |
|
| 188 |
`End_Date` date DEFAULT NULL, |
|
| 189 |
`Author` varchar(50) NOT NULL, |
|
| 190 |
`Serial_Number` varchar(20) NOT NULL, |
|
| 191 |
PRIMARY KEY (`ID`), |
|
| 192 |
UNIQUE KEY `Serial_Number` (`Serial_Number`), |
|
| 193 |
KEY `Author` (`Author`) |
|
| 194 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
|
| 195 |
|
|
| 196 |
-- |
|
| 197 |
-- Dumping data for table `notebooks` |
|
| 198 |
-- |
|
| 199 |
|
|
| 200 |
INSERT INTO `notebooks` (`ID`, `Begin_Date`, `End_Date`, `Author`, `Serial_Number`) VALUES |
|
| 201 |
(1, '2005-04-01', '2006-01-31', 'Gael.Yvert', 'GY8'), |
|
| 202 |
(2, '2005-05-24', '2005-12-07', 'Christelle.Damon', 'CD1'), |
|
| 203 |
(3, '2008-01-16', '0000-00-00', 'Helene.Bottin', 'EVO'), |
|
| 204 |
(4, '2009-07-06', '2010-01-19', 'Helene.Bottin', 'B49069'), |
|
| 205 |
(5, '2012-09-03', '0000-00-00', 'Florent.Chuffart', 'E002933'); |
|
| 206 |
|
|
| 207 |
-- |
|
| 208 |
-- Table structure for table `oligos` |
|
| 209 |
-- |
|
| 210 |
|
|
| 211 |
CREATE TABLE IF NOT EXISTS `oligos` ( |
|
| 212 |
`id` char(15) NOT NULL, |
|
| 213 |
`Sequence` varchar(150) NOT NULL, |
|
| 214 |
`Date_` date DEFAULT NULL, |
|
| 215 |
`Description` longtext, |
|
| 216 |
`PCR_conditions_predicted` longtext, |
|
| 217 |
`Author` varchar(50) DEFAULT NULL, |
|
| 218 |
`Purif` varchar(40) NOT NULL, |
|
| 219 |
PRIMARY KEY (`id`), |
|
| 220 |
KEY `Author` (`Author`) |
|
| 221 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
|
| 222 |
|
|
| 223 |
-- |
|
| 224 |
-- Dumping data for table `oligos` |
|
| 225 |
-- |
|
| 226 |
|
|
| 227 |
INSERT INTO `oligos` (`id`, `Sequence`, `Date_`, `Description`, `PCR_conditions_predicted`, `Author`, `Purif`) VALUES |
|
| 228 |
('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.Yvert', ''),
|
|
| 229 |
('1F14', 'gtgatgacggtgaaaacctc', '2009-09-07', 'Upstream selection marker in pSH* plasmids.', '', 'Gael.Yvert', ''),
|
|
| 230 |
('1F19', 'ataagggcgacacggaaatg', '2009-10-12', 'To sequence CEN/ARS of pCEN-AdeAru', '', 'Gael.Yvert', ''),
|
|
| 231 |
('1F97', 'tgtaacccactcgtgcac', '2010-03-01', 'To sequence any plasmid from the AmpR coding sequence.', '', 'Gael.Yvert', 'SePoP'),
|
|
| 232 |
('1H75', 'cactatagggcgaattgg', '2011-01-06', 'To amplify yEGFP-CYC1term from pGY8 and clone it into pCM183 by homologous recombination in yeast.', '', 'Gael.Yvert', 'SePoP'),
|
|
| 233 |
('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.Bottin', 'SePoP');
|
|
| 234 |
|
|
| 235 |
-- -------------------------------------------------------- |
|
| 236 |
|
|
| 237 |
-- |
|
| 238 |
-- Table structure for table `olig_purif` |
|
| 239 |
-- |
|
| 240 |
|
|
| 241 |
CREATE TABLE IF NOT EXISTS `olig_purif` ( |
|
| 242 |
`type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 243 |
PRIMARY KEY (`type`) |
|
| 244 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 245 |
|
|
| 246 |
-- |
|
| 247 |
-- Dumping data for table `olig_purif` |
|
| 248 |
-- |
|
| 249 |
|
|
| 250 |
INSERT INTO `olig_purif` (`type`) VALUES |
|
| 251 |
(''),
|
|
| 252 |
('Gold'),
|
|
| 253 |
('HPLC'),
|
|
| 254 |
('PAGE'),
|
|
| 255 |
('SePoP');
|
|
| 256 |
|
|
| 257 |
-- -------------------------------------------------------- |
|
| 258 |
|
|
| 259 |
-- |
|
| 260 |
-- Table structure for table `pip_events` |
|
| 261 |
-- |
|
| 262 |
|
|
| 263 |
CREATE TABLE IF NOT EXISTS `pip_events` ( |
|
| 264 |
`Events` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 265 |
PRIMARY KEY (`Events`) |
|
| 266 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT; |
|
| 267 |
|
|
| 268 |
-- |
|
| 269 |
-- Dumping data for table `pip_events` |
|
| 270 |
-- |
|
| 271 |
|
|
| 272 |
INSERT INTO `pip_events` (`Events`) VALUES |
|
| 273 |
('Change Usage'),
|
|
| 274 |
('Change User'),
|
|
| 275 |
('Discard'),
|
|
| 276 |
('Maintenance'),
|
|
| 277 |
('Misc'),
|
|
| 278 |
('Purchase');
|
|
| 279 |
|
|
| 280 |
-- -------------------------------------------------------- |
|
| 281 |
|
|
| 282 |
-- |
|
| 283 |
-- Table structure for table `pip_generic_user` |
|
| 284 |
-- |
|
| 285 |
|
|
| 286 |
CREATE TABLE IF NOT EXISTS `pip_generic_user` ( |
|
| 287 |
`User` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 288 |
PRIMARY KEY (`User`) |
|
| 289 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 290 |
|
|
| 291 |
-- |
|
| 292 |
-- Dumping data for table `pip_generic_user` |
|
| 293 |
-- |
|
| 294 |
|
|
| 295 |
INSERT INTO `pip_generic_user` (`User`) VALUES |
|
| 296 |
('Christelle.Damon'),
|
|
| 297 |
('Everybody'),
|
|
| 298 |
('Standby'),
|
|
| 299 |
('Student');
|
|
| 300 |
|
|
| 301 |
-- -------------------------------------------------------- |
|
| 302 |
|
|
| 303 |
-- |
|
| 304 |
-- Table structure for table `pip_history` |
|
| 305 |
-- |
|
| 306 |
|
|
| 307 |
CREATE TABLE IF NOT EXISTS `pip_history` ( |
|
| 308 |
`ID` int(10) NOT NULL AUTO_INCREMENT, |
|
| 309 |
`Serial_Number` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 310 |
`Date` date NOT NULL, |
|
| 311 |
`Owner_fromNowOn` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 312 |
`Usage_fromNowOn` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 313 |
`Event_Type` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 314 |
`Comments` text COLLATE utf8_unicode_ci NOT NULL, |
|
| 315 |
PRIMARY KEY (`ID`) |
|
| 316 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=90 ; |
|
| 317 |
|
|
| 318 |
-- |
|
| 319 |
-- Dumping data for table `pip_history` |
|
| 320 |
-- |
|
| 321 |
|
|
| 322 |
INSERT INTO `pip_history` (`ID`, `Serial_Number`, `Date`, `Owner_fromNowOn`, `Usage_fromNowOn`, `Event_Type`, `Comments`) VALUES |
|
| 323 |
(8, 'Y60538M', '2005-00-00', 'Christelle.Damon', 'Misc', 'Purchase', ''), |
|
| 324 |
(9, 'Y60538M', '2006-00-00', 'Helene.Bottin', 'Misc', 'Change User', 'Previous user: Christelle Damon'), |
|
| 325 |
(10, 'Y60538M', '2009-03-04', 'Helene.Bottin', 'Misc', 'Maintenance', 'Change of parts (spring was broken 2009_02_12)'), |
|
| 326 |
(11, 'Y58817M', '2005-00-00', 'Christelle.Damon', 'Misc', 'Purchase', ''), |
|
| 327 |
(12, 'Y58817M', '2006-00-00', 'Helene.Bottin', 'Misc', 'Change User', 'Previous user: Christelle Damon'), |
|
| 328 |
(13, 'Y58817M', '2009-03-04', 'Helene.Bottin', 'Misc', 'Maintenance', 'Change of parts '), |
|
| 329 |
(14, 'Y63235M', '2005-00-00', 'Christelle.Damon', 'Misc', 'Purchase', ''), |
|
| 330 |
(15, 'Y63235M', '2009-03-04', 'Helene.Bottin', 'Misc', 'Maintenance', ''), |
|
| 331 |
(16, 'Y63235M', '2006-00-00', 'Helene.Bottin', 'Misc', 'Change User', 'Previous user: Christelle Damon'), |
|
| 332 |
(17, 'Z64108A', '2005-00-00', 'Christelle.Damon', 'Misc', 'Purchase', ''), |
|
| 333 |
(18, 'Z64108A', '2006-00-00', 'Helene.Bottin', 'Misc', 'Change User', 'Previous user: Christelle Damon'), |
|
| 334 |
(19, 'Z64108A', '2009-03-04', 'Helene.Bottin', 'Misc', 'Maintenance', ''), |
|
| 335 |
(53, '2102895', '2005-09-01', 'Everybody', 'Misc', 'Purchase', ''), |
|
| 336 |
(54, '6133327', '2007-03-02', 'Everybody', 'Misc', 'Purchase', ''), |
|
| 337 |
(63, 'Z64108A', '2011-02-18', 'Andri.Leonidou', 'Misc', 'Change User', 'Previous user: Christelle Damon'); |
|
| 338 |
|
|
| 339 |
-- -------------------------------------------------------- |
|
| 340 |
|
|
| 341 |
-- |
|
| 342 |
-- Table structure for table `pip_marque` |
|
| 343 |
-- |
|
| 344 |
|
|
| 345 |
CREATE TABLE IF NOT EXISTS `pip_marque` ( |
|
| 346 |
`Marque` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 347 |
PRIMARY KEY (`Marque`) |
|
| 348 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT; |
|
| 349 |
|
|
| 350 |
-- |
|
| 351 |
-- Dumping data for table `pip_marque` |
|
| 352 |
-- |
|
| 353 |
|
|
| 354 |
INSERT INTO `pip_marque` (`Marque`) VALUES |
|
| 355 |
('BioHit'),
|
|
| 356 |
('Eppendorf'),
|
|
| 357 |
('Gilson');
|
|
| 358 |
|
|
| 359 |
-- -------------------------------------------------------- |
|
| 360 |
|
|
| 361 |
-- |
|
| 362 |
-- Table structure for table `pip_nonusers` |
|
| 363 |
-- |
|
| 364 |
|
|
| 365 |
CREATE TABLE IF NOT EXISTS `pip_nonusers` ( |
|
| 366 |
`User` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 367 |
PRIMARY KEY (`User`) |
|
| 368 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 369 |
|
|
| 370 |
-- |
|
| 371 |
-- Dumping data for table `pip_nonusers` |
|
| 372 |
-- |
|
| 373 |
|
|
| 374 |
INSERT INTO `pip_nonusers` (`User`) VALUES |
|
| 375 |
('Florent.Chuffart'),
|
|
| 376 |
('Gift.or.Purchased');
|
|
| 377 |
|
|
| 378 |
-- -------------------------------------------------------- |
|
| 379 |
|
|
| 380 |
-- |
|
| 381 |
-- Table structure for table `pip_stock` |
|
| 382 |
-- |
|
| 383 |
|
|
| 384 |
CREATE TABLE IF NOT EXISTS `pip_stock` ( |
|
| 385 |
`ID` int(10) NOT NULL AUTO_INCREMENT, |
|
| 386 |
`Serial_Number` varchar(40) COLLATE utf8_unicode_ci NOT NULL, |
|
| 387 |
`Marque` varchar(40) COLLATE utf8_unicode_ci NOT NULL, |
|
| 388 |
`Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 389 |
PRIMARY KEY (`ID`), |
|
| 390 |
UNIQUE KEY `Serial_Number` (`Serial_Number`) |
|
| 391 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=228 ; |
|
| 392 |
|
|
| 393 |
-- |
|
| 394 |
-- Dumping data for table `pip_stock` |
|
| 395 |
-- |
|
| 396 |
|
|
| 397 |
INSERT INTO `pip_stock` (`ID`, `Serial_Number`, `Marque`, `Type`) VALUES |
|
| 398 |
(1, 'Y60538M', 'Gilson', 'P1000'), |
|
| 399 |
(6, '6133327', 'BioHit', 'multicanaux_02-10ul'), |
|
| 400 |
(5, '2102895', 'Eppendorf', 'multicanaux_10-100ul'), |
|
| 401 |
(4, 'Z64108A', 'Gilson', 'P2'), |
|
| 402 |
(3, 'Y63235M', 'Gilson', 'P20'), |
|
| 403 |
(2, 'Y58817M', 'Gilson', 'P200'); |
|
| 404 |
|
|
| 405 |
-- -------------------------------------------------------- |
|
| 406 |
|
|
| 407 |
-- |
|
| 408 |
-- Table structure for table `pip_type` |
|
| 409 |
-- |
|
| 410 |
|
|
| 411 |
CREATE TABLE IF NOT EXISTS `pip_type` ( |
|
| 412 |
`Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL, |
|
| 413 |
PRIMARY KEY (`Type`) |
|
| 414 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 415 |
|
|
| 416 |
-- |
|
| 417 |
-- Dumping data for table `pip_type` |
|
| 418 |
-- |
|
| 419 |
|
|
| 420 |
INSERT INTO `pip_type` (`Type`) VALUES |
|
| 421 |
('multicanaux_02-10ul'),
|
|
| 422 |
('multicanaux_10-100ul'),
|
|
| 423 |
('multicanaux_50-1200ul'),
|
|
| 424 |
('P1000'),
|
|
| 425 |
('P2'),
|
|
| 426 |
('P20'),
|
|
| 427 |
('P200');
|
|
| 428 |
|
|
| 429 |
-- -------------------------------------------------------- |
|
| 430 |
|
|
| 431 |
-- |
|
| 432 |
-- Table structure for table `pip_usage` |
|
| 433 |
-- |
|
| 434 |
|
|
| 435 |
CREATE TABLE IF NOT EXISTS `pip_usage` ( |
|
| 436 |
`Usage` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 437 |
PRIMARY KEY (`Usage`) |
|
| 438 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT; |
|
| 439 |
|
|
| 440 |
-- |
|
| 441 |
-- Dumping data for table `pip_usage` |
|
| 442 |
-- |
|
| 443 |
|
|
| 444 |
INSERT INTO `pip_usage` (`Usage`) VALUES |
|
| 445 |
('Cellular'),
|
|
| 446 |
('Misc'),
|
|
| 447 |
('RNA');
|
|
| 448 |
|
|
| 449 |
-- -------------------------------------------------------- |
|
| 450 |
|
|
| 451 |
-- |
|
| 452 |
-- Table structure for table `pip_users` |
|
| 453 |
-- |
|
| 454 |
|
|
| 455 |
CREATE TABLE IF NOT EXISTS `pip_users` ( |
|
| 456 |
`User` varchar(100) COLLATE utf8_unicode_ci NOT NULL, |
|
| 457 |
PRIMARY KEY (`User`) |
|
| 458 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 459 |
|
|
| 460 |
-- |
|
| 461 |
-- Dumping data for table `pip_users` |
|
| 462 |
-- |
|
| 463 |
|
|
| 464 |
INSERT INTO `pip_users` (`User`) VALUES |
|
| 465 |
('Christelle.Damon'),
|
|
| 466 |
('Helene.Bottin');
|
|
| 467 |
|
|
| 468 |
-- -------------------------------------------------------- |
|
| 469 |
|
|
| 470 |
-- |
|
| 471 |
-- Table structure for table `plasmids` |
|
| 472 |
-- |
|
| 473 |
|
|
| 474 |
CREATE TABLE IF NOT EXISTS `plasmids` ( |
|
| 475 |
`id` int(10) unsigned NOT NULL, |
|
| 476 |
`Name_` varchar(50) DEFAULT NULL, |
|
| 477 |
`Other_names` varchar(50) DEFAULT NULL, |
|
| 478 |
`date_` date DEFAULT NULL, |
|
| 479 |
`Checkings` varchar(200) DEFAULT NULL, |
|
| 480 |
`Type_` varchar(25) DEFAULT NULL, |
|
| 481 |
`Yeast_selection_1` varchar(25) DEFAULT NULL, |
|
| 482 |
`Yeast_selection_2` varchar(25) DEFAULT NULL, |
|
| 483 |
`Bacterial_selection` varchar(25) DEFAULT NULL, |
|
| 484 |
`Tags` varchar(25) DEFAULT NULL, |
|
| 485 |
`parent_vector` varchar(50) DEFAULT NULL, |
|
| 486 |
`Insert_` varchar(50) DEFAULT NULL, |
|
| 487 |
`Insert_Type` varchar(25) DEFAULT NULL, |
|
| 488 |
`Construction_Description` longtext, |
|
| 489 |
`Reference_` varchar(200) DEFAULT NULL, |
|
| 490 |
`Reporter` varchar(25) DEFAULT NULL, |
|
| 491 |
`Promoter` varchar(25) DEFAULT NULL, |
|
| 492 |
`Link_to_file` varchar(100) DEFAULT NULL, |
|
| 493 |
`sequence` text, |
|
| 494 |
`image_file` varchar(100) DEFAULT NULL, |
|
| 495 |
`Author` varchar(50) DEFAULT NULL, |
|
| 496 |
PRIMARY KEY (`id`), |
|
| 497 |
UNIQUE KEY `Link_to_file` (`Link_to_file`), |
|
| 498 |
UNIQUE KEY `Link_to_file_2` (`Link_to_file`), |
|
| 499 |
KEY `Author` (`Author`) |
|
| 500 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
|
| 501 |
|
|
| 502 |
-- |
|
| 503 |
-- Dumping data for table `plasmids` |
|
| 504 |
-- |
|
| 505 |
|
|
| 506 |
INSERT INTO `plasmids` (`id`, `Name_`, `Other_names`, `date_`, `Checkings`, `Type_`, `Yeast_selection_1`, `Yeast_selection_2`, `Bacterial_selection`, `Tags`, `parent_vector`, `Insert_`, `Insert_Type`, `Construction_Description`, `Reference_`, `Reporter`, `Promoter`, `Link_to_file`, `sequence`, `image_file`, `Author`) VALUES |
|
| 507 |
(306, 'pRSII303', NULL, '2013-05-28', '', 'integrative', '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'), |
|
| 508 |
(307, 'pRSII403', NULL, '2013-05-28', '', 'integrative', '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'), |
|
| 509 |
(314, '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'), |
|
| 510 |
(322, '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'), |
|
| 511 |
(323, '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'); |
|
| 512 |
|
|
| 513 |
-- -------------------------------------------------------- |
|
| 514 |
|
|
| 515 |
-- |
|
| 516 |
-- Table structure for table `pl_bacterial_selection` |
|
| 517 |
-- |
|
| 518 |
|
|
| 519 |
CREATE TABLE IF NOT EXISTS `pl_bacterial_selection` ( |
|
| 520 |
`type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 521 |
PRIMARY KEY (`type`) |
|
| 522 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 523 |
|
|
| 524 |
-- |
|
| 525 |
-- Dumping data for table `pl_bacterial_selection` |
|
| 526 |
-- |
|
| 527 |
|
|
| 528 |
INSERT INTO `pl_bacterial_selection` (`type`) VALUES |
|
| 529 |
(''),
|
|
| 530 |
('Amp'),
|
|
| 531 |
('Chloramphenicol'),
|
|
| 532 |
('Kan');
|
|
| 533 |
|
|
| 534 |
-- -------------------------------------------------------- |
|
| 535 |
|
|
| 536 |
-- |
|
| 537 |
-- Table structure for table `pl_features` |
|
| 538 |
-- |
|
| 539 |
|
|
| 540 |
CREATE TABLE IF NOT EXISTS `pl_features` ( |
|
| 541 |
`id` int(10) NOT NULL AUTO_INCREMENT, |
|
| 542 |
`Sequence` longtext NOT NULL, |
|
| 543 |
`Date_` date DEFAULT NULL, |
|
| 544 |
`Description` longtext, |
|
| 545 |
`Comments` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 546 |
`Author` varchar(50) DEFAULT NULL, |
|
| 547 |
`Category` varchar(15) NOT NULL DEFAULT 'OTH', |
|
| 548 |
PRIMARY KEY (`id`), |
|
| 549 |
UNIQUE KEY `Sequence` (`Sequence`(128)), |
|
| 550 |
KEY `Author` (`Author`) |
|
| 551 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=25 ; |
|
| 552 |
|
|
| 553 |
-- |
|
| 554 |
-- Dumping data for table `pl_features` |
|
| 555 |
-- |
|
| 556 |
|
|
| 557 |
INSERT INTO `pl_features` (`id`, `Sequence`, `Date_`, `Description`, `Comments`, `Author`, `Category`) VALUES |
|
| 558 |
(4, 'CGCTTGCCTGTAACTTACACGCGCCTCGTATCTTTTAATGATGGAATAATTTGGGAATTTACTCTGTGTTTATTTATTTTTATGTTTTGTATTTGGATTTTAGAAAGTAAATAAAGAAGGTAGAAGAGTTACGGAATGAAGAAAAAAAAATAAACAAAGGTTTAAAAAATTTCAACAAAAAGCGTACTTTACATATATATTTATTAGACAAGAAAAGCAGATTAAATAGATATACATTCGATTAACGATAAGTAAAATGTAAAATCACAGGATTTTCGTGTGTGGTCTTCTACACAGACAAGATGAAACAATTCGGCATTAATACCTGAGAGCAGGAAGAGCAAGATAAAAGGTAGTATTTGTTGGCGATCCCCCTAGAGTCTTTTACATCTTCGGAAAACAAAAACTATTTTTTCTTTAATTTCTTTTTTTACTTTCTATTTTTAATTTATATATTTATATTAAAAAATTTAAATTATAATTATTTTTATAGCACGTGATGAAAAGGACC', '2013-06-11', 'CEN6/ARSH4', '', 'Gael.Yvert', 'ORI'), |
|
| 559 |
(5, 'ATAACTTCGTATAATGTATGCTATACGAAGTTAT', '2013-06-11', 'LoxP', '', 'Gael.Yvert', 'OTH'), |
|
| 560 |
(10, 'ATGTCTAAAGGTGAAGAATTATTCACTGGTGTTGTCCCAATTTTGGTTGAATTAGATGGTGATGTTAATGGTCACAAATTTTCTGTCTCCGGTGAAGGTGAAGGTGATGCTACTTACGGTAAATTGACCTTAAAATTTATTTGTACTACTGGTAAATTGCCAGTTCCATGGCCAACCTTAGTCACTACTTTCGGTTATGGTGTTCAATGTTTTGCTAGATACCCAGATCATATGAAACAACATGACTTTTTCAAGTCTGCCATGCCAGAAGGTTATGTTCAAGAAAGAACTATTTTTTTCAAAGATGACGGTAACTACAAGACCAGAGCTGAAGTCAAGTTTGAAGGTGATACCTTAGTTAATAGAATCGAATTAAAAGGTATTGATTTTAAAGAAGATGGTAACATTTTAGGTCACAAATTGGAATACAACTATAACTCTCACAATGTTTACATCATGGCTGACAAACAAAAGAATGGTATCAAAGTTAACTTCAAAATTAGACACAACATTGAAGATGGTTCTGTTCAATTAGCTGACCATTATCAACAAAATACTCCAATTGGTGATGGTCCAGTCTTGTTACCAGACAACCATTACTTATCCACTCAATCTGCCTTATCCAAAGATCCAAACGAAAAGAGAGACCACATGGTCTTGTTAGAATTTGTTACTGCTGCTGGTATTACCCATGGTATGGATGAATTGTACAAA', '2013-06-11', 'yEGFP3-CDS', '', 'Gael.Yvert', 'REP'), |
|
| 561 |
(19, 'atgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcttttaaagaggccctactggcgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagctttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtaccaacgatgttccctccaccaaaggtgttcttatgtag', '2013-07-19', 'HIS3-CDS', '', 'Gael.Yvert', 'SEL'), |
|
| 562 |
(20, 'cgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttcccctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaag', '2013-07-19', 'HIS3-prom', '', 'Gael.Yvert', 'PRO'), |
|
| 563 |
(21, 'tgacaccgattatttaaagctgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcga', '2013-07-19', 'HIS3-term', '', 'Gael.Yvert', 'TER'); |
|
| 564 |
|
|
| 565 |
-- -------------------------------------------------------- |
|
| 566 |
|
|
| 567 |
-- |
|
| 568 |
-- Table structure for table `pl_features_catname` |
|
| 569 |
-- |
|
| 570 |
|
|
| 571 |
CREATE TABLE IF NOT EXISTS `pl_features_catname` ( |
|
| 572 |
`Category` varchar(15) COLLATE utf8_unicode_ci NOT NULL, |
|
| 573 |
`Name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 574 |
PRIMARY KEY (`Category`) |
|
| 575 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
| 576 |
|
|
| 577 |
-- |
|
| 578 |
-- Dumping data for table `pl_features_catname` |
|
| 579 |
-- |
|
| 580 |
|
|
| 581 |
INSERT INTO `pl_features_catname` (`Category`, `Name`) VALUES |
|
| 582 |
('PRO', 'Promoters'),
|
|
| 583 |
('REG', 'Regulatory sequences'),
|
|
| 584 |
('TER', 'Terminators'),
|
|
| 585 |
('SEL', 'Selectable markers'),
|
|
| 586 |
('ORI', 'Replication origins'),
|
|
| 587 |
('REP', 'Reporter genes'),
|
|
| 588 |
('TAG', 'Affinity tags'),
|
|
| 589 |
('LOC', 'Localization sequences'),
|
|
| 590 |
('HYB', 'Hybrid genes'),
|
|
| 591 |
('OTH', 'Miscellaneous features');
|
|
| 592 |
|
|
| 593 |
-- -------------------------------------------------------- |
|
| 594 |
|
|
| 595 |
-- |
|
| 596 |
-- Table structure for table `pl_tag` |
|
| 597 |
-- |
|
| 598 |
|
|
| 599 |
CREATE TABLE IF NOT EXISTS `pl_tag` ( |
|
| 600 |
`type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 601 |
PRIMARY KEY (`type`) |
|
| 602 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 603 |
|
|
| 604 |
-- |
|
| 605 |
-- Dumping data for table `pl_tag` |
|
| 606 |
-- |
|
| 607 |
|
|
| 608 |
INSERT INTO `pl_tag` (`type`) VALUES |
|
| 609 |
(''),
|
|
| 610 |
('FLAG'),
|
|
| 611 |
('FlAsH'),
|
|
| 612 |
('GST'),
|
|
| 613 |
('HA'),
|
|
| 614 |
('HIS'),
|
|
| 615 |
('Myc'),
|
|
| 616 |
('ProA'),
|
|
| 617 |
('TAP');
|
|
| 618 |
|
|
| 619 |
-- -------------------------------------------------------- |
|
| 620 |
|
|
| 621 |
-- |
|
| 622 |
-- Table structure for table `pl_type` |
|
| 623 |
-- |
|
| 624 |
|
|
| 625 |
CREATE TABLE IF NOT EXISTS `pl_type` ( |
|
| 626 |
`type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 627 |
PRIMARY KEY (`type`) |
|
| 628 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 629 |
|
|
| 630 |
-- |
|
| 631 |
-- Dumping data for table `pl_type` |
|
| 632 |
-- |
|
| 633 |
|
|
| 634 |
INSERT INTO `pl_type` (`type`) VALUES |
|
| 635 |
(''),
|
|
| 636 |
('2-mu'),
|
|
| 637 |
('centromeric'),
|
|
| 638 |
('integrative');
|
|
| 639 |
|
|
| 640 |
-- -------------------------------------------------------- |
|
| 641 |
|
|
| 642 |
-- |
|
| 643 |
-- Table structure for table `pl_yeast_marker` |
|
| 644 |
-- |
|
| 645 |
|
|
| 646 |
CREATE TABLE IF NOT EXISTS `pl_yeast_marker` ( |
|
| 647 |
`type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 648 |
PRIMARY KEY (`type`) |
|
| 649 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 650 |
|
|
| 651 |
-- |
|
| 652 |
-- Dumping data for table `pl_yeast_marker` |
|
| 653 |
-- |
|
| 654 |
|
|
| 655 |
INSERT INTO `pl_yeast_marker` (`type`) VALUES |
|
| 656 |
(''),
|
|
| 657 |
('ADE2'),
|
|
| 658 |
('bialaphos'),
|
|
| 659 |
('CaURA3'),
|
|
| 660 |
('HIS3'),
|
|
| 661 |
('HIS3MX6'),
|
|
| 662 |
('HphNT1'),
|
|
| 663 |
('HygromycinB'),
|
|
| 664 |
('Kan'),
|
|
| 665 |
('KanMX'),
|
|
| 666 |
('KanMX4'),
|
|
| 667 |
('KlLEU2'),
|
|
| 668 |
('KlTRP1'),
|
|
| 669 |
('KlURA3'),
|
|
| 670 |
('KlURA3MX4'),
|
|
| 671 |
('LEU2'),
|
|
| 672 |
('LYS2'),
|
|
| 673 |
('Nat'),
|
|
| 674 |
('NatMX'),
|
|
| 675 |
('NatNT2'),
|
|
| 676 |
('phleomycin'),
|
|
| 677 |
('spHIS5'),
|
|
| 678 |
('TRP1'),
|
|
| 679 |
('URA3');
|
|
| 680 |
|
|
| 681 |
-- -------------------------------------------------------- |
|
| 682 |
|
|
| 683 |
-- |
|
| 684 |
-- Table structure for table `pl_yeast_promoter` |
|
| 685 |
-- |
|
| 686 |
|
|
| 687 |
CREATE TABLE IF NOT EXISTS `pl_yeast_promoter` ( |
|
| 688 |
`type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 689 |
PRIMARY KEY (`type`) |
|
| 690 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 691 |
|
|
| 692 |
-- |
|
| 693 |
-- Dumping data for table `pl_yeast_promoter` |
|
| 694 |
-- |
|
| 695 |
|
|
| 696 |
INSERT INTO `pl_yeast_promoter` (`type`) VALUES |
|
| 697 |
(''),
|
|
| 698 |
('ADH'),
|
|
| 699 |
('CUP1'),
|
|
| 700 |
('CYC1'),
|
|
| 701 |
('GAL'),
|
|
| 702 |
('GAL1'),
|
|
| 703 |
('GALL'),
|
|
| 704 |
('GALS'),
|
|
| 705 |
('GPD'),
|
|
| 706 |
('MET25'),
|
|
| 707 |
('TEF');
|
|
| 708 |
|
|
| 709 |
-- -------------------------------------------------------- |
|
| 710 |
|
|
| 711 |
-- |
|
| 712 |
-- Table structure for table `strains` |
|
| 713 |
-- |
|
| 714 |
|
|
| 715 |
CREATE TABLE IF NOT EXISTS `strains` ( |
|
| 716 |
`id` int(10) unsigned NOT NULL, |
|
| 717 |
`Name_` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 718 |
`Date_` date DEFAULT NULL, |
|
| 719 |
`Comments` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, |
|
| 720 |
`General_Background` varchar(25) NOT NULL, |
|
| 721 |
`Mating_Type` varchar(25) DEFAULT NULL, |
|
| 722 |
`ADE2` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 723 |
`HIS3` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 724 |
`LEU2` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 725 |
`LYS2` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 726 |
`TRP1` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 727 |
`URA3` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 728 |
`HO_` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 729 |
`locus1` varchar(75) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 730 |
`locus2` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 731 |
`locus3` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 732 |
`Parental_strain` varchar(25) DEFAULT NULL, |
|
| 733 |
`Obtained_by` varchar(25) DEFAULT NULL, |
|
| 734 |
`Checkings` varchar(225) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 735 |
`extrachromosomal_plasmid` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 736 |
`Other_names` varchar(25) DEFAULT NULL, |
|
| 737 |
`Reference_` varchar(125) DEFAULT NULL, |
|
| 738 |
`locus4` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 739 |
`locus5` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 740 |
`Cytoplasmic_Character` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 741 |
`Last_modified` date DEFAULT NULL, |
|
| 742 |
`MET15` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, |
|
| 743 |
`Author` varchar(50) DEFAULT NULL, |
|
| 744 |
PRIMARY KEY (`id`), |
|
| 745 |
KEY `Author` (`Author`) |
|
| 746 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
|
| 747 |
|
|
| 748 |
-- |
|
| 749 |
-- Dumping data for table `strains` |
|
| 750 |
-- |
|
| 751 |
|
|
| 752 |
INSERT INTO `strains` (`id`, `Name_`, `Date_`, `Comments`, `General_Background`, `Mating_Type`, `ADE2`, `HIS3`, `LEU2`, `LYS2`, `TRP1`, `URA3`, `HO_`, `locus1`, `locus2`, `locus3`, `Parental_strain`, `Obtained_by`, `Checkings`, `extrachromosomal_plasmid`, `Other_names`, `Reference_`, `locus4`, `locus5`, `Cytoplasmic_Character`, `Last_modified`, `MET15`, `Author`) VALUES |
|
| 753 |
(6, 'BY4700', '2005-02-01', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, NULL, NULL, NULL, NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 754 |
(7, 'BY4709', '2005-02-01', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATb', NULL, NULL, NULL, NULL, NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 755 |
(8, 'BY4719', '2005-02-01', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, NULL, NULL, NULL, 'trp1∆63', 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 756 |
(9, 'BY4724', '2005-02-01', 'Gift from Gottschling Lab. Strain from ', 'S288c', 'MATa', NULL, NULL, NULL, 'lys2∆0', NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 757 |
(10, 'BY4720', '2003-05-06', NULL, 'S288c', 'MATb', NULL, NULL, NULL, 'lys2∆0', 'trp1∆63', 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann et al; Yeast 1998 14:115-132.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 758 |
(42, 'BY4716', NULL, 'Gift from Hartwell Lab, who got it from Brachmann et al. Yeast 1998 14:115-132.', 'S288c', 'MATb', NULL, NULL, NULL, 'lys2∆0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann et al. Yeast 1998 14:115-132.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 759 |
(128, 'BY4741', '2005-10-11', 'Gift from Gilson Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, 'his3∆1', 'leu2∆0', NULL, NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', 'met15∆0', 'Gift.or.Purchased'), |
|
| 760 |
(129, 'BY4742', '2005-10-11', 'Gift from Gilson Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATb', NULL, 'his3∆1', 'leu2∆0', 'lys2∆0', NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 761 |
(142, 'BY4706', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', 'met15∆0', 'Gift.or.Purchased'), |
|
| 762 |
(143, 'BY4707', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATb', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', 'met15∆0', 'Gift.or.Purchased'), |
|
| 763 |
(144, 'BY4710', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, NULL, NULL, NULL, 'trp1∆63', NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 764 |
(145, 'BY4711', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATb', NULL, NULL, NULL, NULL, 'trp1∆63', NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 765 |
(146, 'BY4712', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, NULL, 'leu2∆0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 766 |
(147, 'BY4713', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATb', NULL, NULL, 'leu2∆0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 767 |
(148, 'BY4714', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, 'his3∆200', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 768 |
(149, 'BY4715', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', NULL, NULL, NULL, 'lys2∆0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 769 |
(150, 'BY4717', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', 'ade2∆::hisG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 770 |
(151, 'BY4725', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATa', 'ade2∆::hisG', NULL, NULL, NULL, NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'), |
|
| 771 |
(152, 'BY4726', '2005-11-03', 'Gift from Gottschling Lab. Strain from Brachmann Yeast 14:115-132, 1998.', 'S288c', 'MATb', 'ade2∆::hisG', NULL, NULL, NULL, NULL, 'ura3∆0', NULL, NULL, NULL, NULL, NULL, 'Gift', NULL, NULL, NULL, 'Brachmann Yeast 14:115-132, 1998.', NULL, NULL, NULL, '2006-11-02', NULL, 'Gift.or.Purchased'); |
|
| 772 |
|
|
| 773 |
-- -------------------------------------------------------- |
|
| 774 |
|
|
| 775 |
-- |
|
| 776 |
-- Table structure for table `st_ADE2` |
|
| 777 |
-- |
|
| 778 |
|
|
| 779 |
CREATE TABLE IF NOT EXISTS `st_ADE2` ( |
|
| 780 |
`alleles` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 781 |
PRIMARY KEY (`alleles`) |
|
| 782 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 783 |
|
|
| 784 |
-- |
|
| 785 |
-- Dumping data for table `st_ADE2` |
|
| 786 |
-- |
|
| 787 |
|
|
| 788 |
INSERT INTO `st_ADE2` (`alleles`) VALUES |
|
| 789 |
(''),
|
|
| 790 |
('ade2-1'),
|
|
| 791 |
('ade2-1/ADE2'),
|
|
| 792 |
('ade2-1/ade2-1'),
|
|
| 793 |
('ADE2.'),
|
|
| 794 |
('ade2/ade2'),
|
|
| 795 |
('ade2∆::hisG'),
|
|
| 796 |
('loxP-ADE2-loxP-HphMX'),
|
|
| 797 |
('unknown');
|
|
| 798 |
|
|
| 799 |
-- -------------------------------------------------------- |
|
| 800 |
|
|
| 801 |
-- |
|
| 802 |
-- Table structure for table `st_general_backgrounds` |
|
| 803 |
-- |
|
| 804 |
|
|
| 805 |
CREATE TABLE IF NOT EXISTS `st_general_backgrounds` ( |
|
| 806 |
`background` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 807 |
PRIMARY KEY (`background`) |
|
| 808 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 809 |
|
|
| 810 |
-- |
|
| 811 |
-- Dumping data for table `st_general_backgrounds` |
|
| 812 |
-- |
|
| 813 |
|
|
| 814 |
INSERT INTO `st_general_backgrounds` (`background`) VALUES |
|
| 815 |
('273614X'),
|
|
| 816 |
('322134S'),
|
|
| 817 |
('378604X'),
|
|
| 818 |
('A364A'),
|
|
| 819 |
('AJA2'),
|
|
| 820 |
('CBS2888_1'),
|
|
| 821 |
('CBS3093_1'),
|
|
| 822 |
('CBS403_1'),
|
|
| 823 |
('CBS7960_1'),
|
|
| 824 |
('CECT10109_1'),
|
|
| 825 |
('CECT10266_1'),
|
|
| 826 |
('CEN.PK'),
|
|
| 827 |
('CLIB154_1'),
|
|
| 828 |
('CLIB157_1'),
|
|
| 829 |
('CLIB192_1'),
|
|
| 830 |
('CLIB208_1'),
|
|
| 831 |
('CLIB215_1'),
|
|
| 832 |
('CLIB219_2'),
|
|
| 833 |
('CLIB272_2'),
|
|
| 834 |
('CLIB274_1'),
|
|
| 835 |
('CLIB294_1'),
|
|
| 836 |
('CLIB318_1'),
|
|
| 837 |
('CLIB324_2'),
|
|
| 838 |
('CLIB326_1'),
|
|
| 839 |
('CLIB328'),
|
|
| 840 |
('CLIB382_1'),
|
|
| 841 |
('CLIB413_1'),
|
|
| 842 |
('CLIB483_1'),
|
|
| 843 |
('DBVPG1373_1'),
|
|
| 844 |
('DBVPG1399_1'),
|
|
| 845 |
('DBVPG1788_1'),
|
|
| 846 |
('DBVPG1794_1'),
|
|
| 847 |
('DBVPG1853_1'),
|
|
| 848 |
('DBVPG3591_1'),
|
|
| 849 |
('DBVPG4651_1'),
|
|
| 850 |
('DBVPG6041_1'),
|
|
| 851 |
('DBVPG6861'),
|
|
| 852 |
('EM93_3'),
|
|
| 853 |
('FL100'),
|
|
| 854 |
('FL200'),
|
|
| 855 |
('FY3'),
|
|
| 856 |
('I14_a'),
|
|
| 857 |
('IL-01'),
|
|
| 858 |
('industrial'),
|
|
| 859 |
('JAY270'),
|
|
| 860 |
('JAY291'),
|
|
| 861 |
('K1_1'),
|
|
| 862 |
('K12_2'),
|
|
| 863 |
('L9-4A'),
|
|
| 864 |
('M22_a'),
|
|
| 865 |
('mixture'),
|
|
| 866 |
('NC-02'),
|
|
| 867 |
('PW5'),
|
|
| 868 |
('RM11'),
|
|
| 869 |
('RM12'),
|
|
| 870 |
('RM13'),
|
|
| 871 |
('RM3'),
|
|
| 872 |
('RM5'),
|
|
| 873 |
('RM9'),
|
|
| 874 |
('S288c'),
|
|
| 875 |
('SK1'),
|
|
| 876 |
('T73_1'),
|
|
| 877 |
('TL229S2.2'),
|
|
| 878 |
('UC1_a'),
|
|
| 879 |
('UC5'),
|
|
| 880 |
('UC8_1'),
|
|
| 881 |
('unknown'),
|
|
| 882 |
('V5'),
|
|
| 883 |
('VL1'),
|
|
| 884 |
('W303'),
|
|
| 885 |
('WE372_1'),
|
|
| 886 |
('Y10_a'),
|
|
| 887 |
('Y12_1'),
|
|
| 888 |
('Y3_a'),
|
|
| 889 |
('Y4_1'),
|
|
| 890 |
('Y5_1'),
|
|
| 891 |
('Y55'),
|
|
| 892 |
('Y6_b'),
|
|
| 893 |
('Y8_1'),
|
|
| 894 |
('Y9_4'),
|
|
| 895 |
('Y9J_1'),
|
|
| 896 |
('YJM269_a'),
|
|
| 897 |
('YJM280'),
|
|
| 898 |
('YJM320'),
|
|
| 899 |
('YJM326'),
|
|
| 900 |
('YJM413'),
|
|
| 901 |
('YJM421'),
|
|
| 902 |
('YJM428'),
|
|
| 903 |
('YJM434_1'),
|
|
| 904 |
('YJM436_a'),
|
|
| 905 |
('YJM440_d'),
|
|
| 906 |
('YJM454_a'),
|
|
| 907 |
('YJM653_1'),
|
|
| 908 |
('YJM678_1'),
|
|
| 909 |
('YJM789'),
|
|
| 910 |
('YJM978'),
|
|
| 911 |
('YJM981'),
|
|
| 912 |
('YPS1000_a'),
|
|
| 913 |
('YPS1009'),
|
|
| 914 |
('YPS163_a');
|
|
| 915 |
|
|
| 916 |
-- -------------------------------------------------------- |
|
| 917 |
|
|
| 918 |
-- |
|
| 919 |
-- Table structure for table `st_HIS3` |
|
| 920 |
-- |
|
| 921 |
|
|
| 922 |
CREATE TABLE IF NOT EXISTS `st_HIS3` ( |
|
| 923 |
`alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 924 |
PRIMARY KEY (`alleles`) |
|
| 925 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 926 |
|
|
| 927 |
-- |
|
| 928 |
-- Dumping data for table `st_HIS3` |
|
| 929 |
-- |
|
| 930 |
|
|
| 931 |
INSERT INTO `st_HIS3` (`alleles`) VALUES |
|
| 932 |
(''),
|
|
| 933 |
('his3'),
|
|
| 934 |
('his3-11,15'),
|
|
| 935 |
('his3-11,15/HIS3'),
|
|
| 936 |
('his3-11,15/his3-11,15'),
|
|
| 937 |
('HIS3.'),
|
|
| 938 |
('his3∆1'),
|
|
| 939 |
('his3∆1/HIS3'),
|
|
| 940 |
('his3∆1/his3∆1'),
|
|
| 941 |
('his3∆200'),
|
|
| 942 |
('his3∆200/HIS3'),
|
|
| 943 |
('his3∆200/his3∆200'),
|
|
| 944 |
('unknown');
|
|
| 945 |
|
|
| 946 |
-- -------------------------------------------------------- |
|
| 947 |
|
|
| 948 |
-- |
|
| 949 |
-- Table structure for table `st_LEU2` |
|
| 950 |
-- |
|
| 951 |
|
|
| 952 |
CREATE TABLE IF NOT EXISTS `st_LEU2` ( |
|
| 953 |
`alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 954 |
PRIMARY KEY (`alleles`) |
|
| 955 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 956 |
|
|
| 957 |
-- |
|
| 958 |
-- Dumping data for table `st_LEU2` |
|
| 959 |
-- |
|
| 960 |
|
|
| 961 |
INSERT INTO `st_LEU2` (`alleles`) VALUES |
|
| 962 |
(''),
|
|
| 963 |
('leu2'),
|
|
| 964 |
('leu2-3,112'),
|
|
| 965 |
('leu2-3,112/LEU2'),
|
|
| 966 |
('leu2-3,112/leu2-3,112'),
|
|
| 967 |
('leu2::hisG'),
|
|
| 968 |
('leu2::hisG/LEU2'),
|
|
| 969 |
('leu2::hisG/leu2::hisG'),
|
|
| 970 |
('LEU2.'),
|
|
| 971 |
('leu2∆(asp781-EcoRI)'),
|
|
| 972 |
('leu2∆(asp781-EcoRI)/LEU2'),
|
|
| 973 |
('leu2∆(asp781-EcoRI)/leu2∆(asp781-EcoRI)'),
|
|
| 974 |
('leu2∆0'),
|
|
| 975 |
('leu2∆0/LEU2'),
|
|
| 976 |
('leu2∆0/leu2∆0'),
|
|
| 977 |
('leu2∆1'),
|
|
| 978 |
('leu2∆1/LEU2'),
|
|
| 979 |
('leu2∆1/leu2∆1'),
|
|
| 980 |
('unknown');
|
|
| 981 |
|
|
| 982 |
-- -------------------------------------------------------- |
|
| 983 |
|
|
| 984 |
-- |
|
| 985 |
-- Table structure for table `st_LYS2` |
|
| 986 |
-- |
|
| 987 |
|
|
| 988 |
CREATE TABLE IF NOT EXISTS `st_LYS2` ( |
|
| 989 |
`alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 990 |
PRIMARY KEY (`alleles`) |
|
| 991 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 992 |
|
|
| 993 |
-- |
|
| 994 |
-- Dumping data for table `st_LYS2` |
|
| 995 |
-- |
|
| 996 |
|
|
| 997 |
INSERT INTO `st_LYS2` (`alleles`) VALUES |
|
| 998 |
(''),
|
|
| 999 |
('lys2'),
|
|
| 1000 |
('lys2-128d'),
|
|
| 1001 |
('LYS2.'),
|
|
| 1002 |
('lys2/lys2'),
|
|
| 1003 |
('lys2∆0'),
|
|
| 1004 |
('lys2∆0::lox-ADEaru-xol'),
|
|
| 1005 |
('lys2∆0/LYS2'),
|
|
| 1006 |
('lys2∆0/lys2∆0'),
|
|
| 1007 |
('lys2∆202'),
|
|
| 1008 |
('lys2∆202/LYS2'),
|
|
| 1009 |
('lys2∆202/lys2∆202'),
|
|
| 1010 |
('unknown');
|
|
| 1011 |
|
|
| 1012 |
-- -------------------------------------------------------- |
|
| 1013 |
|
|
| 1014 |
-- |
|
| 1015 |
-- Table structure for table `st_MAT` |
|
| 1016 |
-- |
|
| 1017 |
|
|
| 1018 |
CREATE TABLE IF NOT EXISTS `st_MAT` ( |
|
| 1019 |
`alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 1020 |
PRIMARY KEY (`alleles`) |
|
| 1021 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 1022 |
|
|
| 1023 |
-- |
|
| 1024 |
-- Dumping data for table `st_MAT` |
|
| 1025 |
-- |
|
| 1026 |
|
|
| 1027 |
INSERT INTO `st_MAT` (`alleles`) VALUES |
|
| 1028 |
('MATa'),
|
|
| 1029 |
('MATa/MATa'),
|
|
| 1030 |
('MATa/MATa/MATb/MATb'),
|
|
| 1031 |
('MATa/MATb'),
|
|
| 1032 |
('MATb'),
|
|
| 1033 |
('MATb/MATb'),
|
|
| 1034 |
('MATb/MATb/MATa'),
|
|
| 1035 |
('unknown');
|
|
| 1036 |
|
|
| 1037 |
-- -------------------------------------------------------- |
|
| 1038 |
|
|
| 1039 |
-- |
|
| 1040 |
-- Table structure for table `st_MET15` |
|
| 1041 |
-- |
|
| 1042 |
|
|
| 1043 |
CREATE TABLE IF NOT EXISTS `st_MET15` ( |
|
| 1044 |
`alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 1045 |
PRIMARY KEY (`alleles`) |
|
| 1046 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 1047 |
|
|
| 1048 |
-- |
|
| 1049 |
-- Dumping data for table `st_MET15` |
|
| 1050 |
-- |
|
| 1051 |
|
|
| 1052 |
INSERT INTO `st_MET15` (`alleles`) VALUES |
|
| 1053 |
(''),
|
|
| 1054 |
('MET15.'),
|
|
| 1055 |
('met15∆0'),
|
|
| 1056 |
('met15∆0/MET15'),
|
|
| 1057 |
('met15∆0/met15∆0'),
|
|
| 1058 |
('unknown');
|
|
| 1059 |
|
|
| 1060 |
-- -------------------------------------------------------- |
|
| 1061 |
|
|
| 1062 |
-- |
|
| 1063 |
-- Table structure for table `st_TRP1` |
|
| 1064 |
-- |
|
| 1065 |
|
|
| 1066 |
CREATE TABLE IF NOT EXISTS `st_TRP1` ( |
|
| 1067 |
`alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 1068 |
PRIMARY KEY (`alleles`) |
|
| 1069 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 1070 |
|
|
| 1071 |
-- |
|
| 1072 |
-- Dumping data for table `st_TRP1` |
|
| 1073 |
-- |
|
| 1074 |
|
|
| 1075 |
INSERT INTO `st_TRP1` (`alleles`) VALUES |
|
| 1076 |
(''),
|
|
| 1077 |
('trp1'),
|
|
| 1078 |
('trp1-1'),
|
|
| 1079 |
('trp1-1/TRP1'),
|
|
| 1080 |
('trp1-1/trp1-1'),
|
|
| 1081 |
('trp1-289'),
|
|
| 1082 |
('trp1-289/TRP1'),
|
|
| 1083 |
('trp1-289/trp1-289'),
|
|
| 1084 |
('TRP1.'),
|
|
| 1085 |
('trp1∆::KanMX4'),
|
|
| 1086 |
('trp1∆::KanMX4/TRP1'),
|
|
| 1087 |
('trp1∆::KanMX4/trp1∆::KanMX4'),
|
|
| 1088 |
('trp1∆1'),
|
|
| 1089 |
('trp1∆1/TRP1'),
|
|
| 1090 |
('trp1∆1/trp1∆1'),
|
|
| 1091 |
('trp1∆2'),
|
|
| 1092 |
('trp1∆2/TRP1'),
|
|
| 1093 |
('trp1∆2/trp1∆2'),
|
|
| 1094 |
('trp1∆63'),
|
|
| 1095 |
('trp1∆63/TRP1'),
|
|
| 1096 |
('trp1∆63/trp1∆63'),
|
|
| 1097 |
('unknown');
|
|
| 1098 |
|
|
| 1099 |
-- -------------------------------------------------------- |
|
| 1100 |
|
|
| 1101 |
-- |
|
| 1102 |
-- Table structure for table `st_URA3` |
|
| 1103 |
-- |
|
| 1104 |
|
|
| 1105 |
CREATE TABLE IF NOT EXISTS `st_URA3` ( |
|
| 1106 |
`alleles` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL, |
|
| 1107 |
PRIMARY KEY (`alleles`) |
|
| 1108 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 1109 |
|
|
| 1110 |
-- |
|
| 1111 |
-- Dumping data for table `st_URA3` |
|
| 1112 |
-- |
|
| 1113 |
|
|
| 1114 |
INSERT INTO `st_URA3` (`alleles`) VALUES |
|
| 1115 |
(''),
|
|
| 1116 |
('unknown'),
|
|
| 1117 |
('URA::CMV-tTA'),
|
|
| 1118 |
('ura3'),
|
|
| 1119 |
('ura3-1'),
|
|
| 1120 |
('ura3-52'),
|
|
| 1121 |
('ura3-52/URA3'),
|
|
| 1122 |
('ura3-52/ura3-52'),
|
|
| 1123 |
('ura3::KanMX'),
|
|
| 1124 |
('ura3::KanMX/URA3'),
|
|
| 1125 |
('URA3.'),
|
|
| 1126 |
('ura3/ura3'),
|
|
| 1127 |
('ura3∆::hphNT1'),
|
|
| 1128 |
('ura3∆0'),
|
|
| 1129 |
('ura3∆0::TRP1'),
|
|
| 1130 |
('ura3∆0/URA3'),
|
|
| 1131 |
('ura3∆0/ura3∆0');
|
|
| 1132 |
|
|
| 1133 |
-- -------------------------------------------------------- |
|
| 1134 |
|
|
| 1135 |
-- |
|
| 1136 |
-- Table structure for table `visitors` |
|
| 1137 |
-- |
|
| 1138 |
|
|
| 1139 |
CREATE TABLE IF NOT EXISTS `visitors` ( |
|
| 1140 |
`login` varchar(20) NOT NULL, |
|
| 1141 |
`pwd` varchar(100) NOT NULL, |
|
| 1142 |
`target_table` varchar(40) NOT NULL, |
|
| 1143 |
`mode` varchar(40) NOT NULL, |
|
| 1144 |
PRIMARY KEY (`login`) |
|
| 1145 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
| 1146 |
|
|
| 1147 |
-- |
|
| 1148 |
-- Dumping data for table `visitors` |
|
| 1149 |
-- |
|
| 1150 |
|
|
| 1151 |
INSERT INTO `visitors` (`login`, `pwd`, `target_table`, `mode`) VALUES |
|
| 1152 |
('add', 'c1f9f01b503af30a9a3d55ca04fd1690', 'dyn', 'add'),
|
|
| 1153 |
('edit', '4aa96e9b91aadc291aa9a9eaabfd61ff', 'dyn', 'edit'),
|
|
| 1154 |
('superuser', '52d7aef81185625af3d8af159fbcb589', 'all', 'super'),
|
|
| 1155 |
('view', '3343cc43daba25f43c6999f219db376b', 'all', 'view');
|
|
| 1156 |
|
|
| 1157 |
-- -------------------------------------------------------- |
|
| 1158 |
|
|
| 1159 |
-- |
|
| 1160 |
-- Table structure for table `websession` |
|
| 1161 |
-- |
|
| 1162 |
|
|
| 1163 |
CREATE TABLE IF NOT EXISTS `websession` ( |
|
| 1164 |
`id_session` varchar(100) NOT NULL, |
|
| 1165 |
`login` varchar(40) NOT NULL, |
|
| 1166 |
`time_limit` decimal(10,0) NOT NULL, |
|
| 1167 |
`target_table` varchar(40) DEFAULT NULL, |
|
| 1168 |
`mode` varchar(40) DEFAULT NULL, |
|
| 1169 |
PRIMARY KEY (`id_session`), |
|
| 1170 |
KEY `login` (`login`) |
|
| 1171 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|
| 1172 |
|
|
| 1173 |
-- |
|
| 1174 |
-- Constraints for dumped tables |
|
| 1175 |
-- |
|
| 1176 |
|
|
| 1177 |
-- |
|
| 1178 |
-- Constraints for table `oligos` |
|
| 1179 |
-- |
|
| 1180 |
ALTER TABLE `oligos` |
|
| 1181 |
ADD CONSTRAINT `oligos_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`); |
|
| 1182 |
|
|
| 1183 |
-- |
|
| 1184 |
-- Constraints for table `plasmids` |
|
| 1185 |
-- |
|
| 1186 |
ALTER TABLE `plasmids` |
|
| 1187 |
ADD CONSTRAINT `plasmids_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`); |
|
| 1188 |
|
|
| 1189 |
-- |
|
| 1190 |
-- Constraints for table `pl_features` |
|
| 1191 |
-- |
|
| 1192 |
ALTER TABLE `pl_features` |
|
| 1193 |
ADD CONSTRAINT `pl_features_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`); |
|
| 1194 |
|
|
| 1195 |
-- |
|
| 1196 |
-- Constraints for table `strains` |
|
| 1197 |
-- |
|
| 1198 |
ALTER TABLE `strains` |
|
| 1199 |
ADD CONSTRAINT `strains_ibfk_1` FOREIGN KEY (`Author`) REFERENCES `lab_members` (`id`); |
|
| 1200 |
|
|
| 1201 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
|
| 1202 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
|
| 1203 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
Formats disponibles : Unified diff