Révision f78441a4

b/README
1
*****************************************
2
Readme / Documentation for `MyLabsStocks`
3
*****************************************
4 1

  
5
`MyLabsStocks` offers Python API and R package allowing to perform 
6
quantitative analysis of nucleosomal epigenome. It is especially well 
7
suited for scripting to extract natural Single-Nucleosome Epi-
8
Polymorphisms (SNEP) from ChIP-Seq data.
2
Readme / Documentation for *MyLabStocks*
3
****************************************
4

  
5
*MyLabStocks* is a web application allowing to easily store, share and
6
retrieve information about molecular biology materials stored in a
7
laboratory.
8

  
9 9

  
10 10
License
11 11
=======
12 12

  
13
Copyright CNRS 2012-2013                                                 
14
                                                                          
15
- Florent CHUFFART                                                         
16
- Gael YVERT                                                               
17
                                                                          
18
This software is a computer program which purpose is to perform quanti-
19
tative analysis of epigenetic marks at single nucleosome resolution.     
20
                                                                          
21
The Software is provided “as is” without warranty of any kind, either 
22
express or implied, including without lim- itation any implied warranties 
23
of condition, uninterrupted use, merchantability, fitness for a particular 
24
purpose, or non-infringement. You use this software at your own risk.
25

  
26
This software is governed by the CeCILL license under French law and     
27
abiding by the rules of distribution of free software.  You can  use,    
28
modify and/ or redistribute the software under the terms of the CeCILL   
29
license as circulated by CEA, CNRS and INRIA at the following URL        
30
"http://www.cecill.info".                                                
31
                                                                          
32
As a counterpart to the access to the source code and  rights to copy,   
33
modify and redistribute granted by the license, users are provided only  
34
with a limited warranty  and the software's author,  the holder of the   
35
economic rights,  and the successive licensors  have only  limited       
36
liability.                                                               
37
                                                                          
38
In this respect, the user's attention is drawn to the risks associated   
39
with loading,  using,  modifying and/or developing or reproducing the    
40
software by the user in light of its specific status of free software,   
41
that may mean  that it is complicated to manipulate,  and  that  also    
42
therefore means  that it is reserved for developers  and  experienced    
43
professionals having in-depth computer knowledge. Users are therefore    
44
encouraged to load and test the software's suitability as regards their  
45
requirements in conditions enabling the security of their systems and/or 
46
data to be ensured and,  more generally, to use and operate it in the    
47
same conditions as regards security.                                     
48
                                                                          
49
The fact that you are presently reading this means that you have had     
50
knowledge of the CeCILL license and that you accept its terms.           
13
Copyright CNRS 2012-2013
14

  
15
* Florent CHUFFART
16

  
17
* Gael YVERT
18

  
19
This software is a computer program which purpose is to perform
20
quantitative analysis of epigenetic marks at single nucleosome
21
resolution.
22

  
23
The Software is provided “as is” without warranty of any kind, either
24
express or implied, including without limitation any implied
25
warranties of condition, uninterrupted use, merchantability, fitness
26
for a particular purpose, or non-infringement. You use this software
27
at your own risk.
28

  
29
This software is governed by the CeCILL license under French law and
30
abiding by the rules of distribution of free software.  You can  use,
31
modify and/ or redistribute the software under the terms of the CeCILL
32
license as circulated by CEA, CNRS and INRIA at the following URL
33
"http://www.cecill.info".
34

  
35
As a counterpart to the access to the source code and  rights to copy,
36
modify and redistribute granted by the license, users are provided
37
only  with a limited warranty  and the software's author,  the holder
38
of the economic rights,  and the successive licensors  have only
39
limited liability.
40

  
41
In this respect, the user's attention is drawn to the risks associated
42
with loading,  using,  modifying and/or developing or reproducing the
43
software by the user in light of its specific status of free software,
44
that may mean  that it is complicated to manipulate,  and  that  also
45
therefore means  that it is reserved for developers  and  experienced
46
professionals having in-depth computer knowledge. Users are therefore
47
encouraged to load and test the software's suitability as regards
48
their requirements in conditions enabling the security of their
49
systems and/or data to be ensured and,  more generally, to use and
50
operate it in the same conditions as regards security.
51

  
52
The fact that you are presently reading this means that you have had
53
knowledge of the CeCILL license and that you accept its terms.
54

  
51 55

  
52 56
Installation Instructions
53 57
=========================
54 58

  
55
Links
56
-----
59
This installation has been fully tested on:
60
   * Debian 7.2.0 amd64 netinst [1], running on virtual machine using
61
     Oracle VM VirtualBox [2] for macosx (dev)
62

  
63
   * Ubuntu Server 12.04.3 LTSUbuntu server LTS [3], running on
64
     physical machine (prod)
65

  
66
[1] http://cdimage.debian.org/debian-cd/7.2.0/amd64/iso-
67
cd/debian-7.2.0-amd64-netinst.iso
68

  
69
[2] https://www.virtualbox.org
70

  
71
[3] http://www.ubuntu.com/download/server
72

  
73

  
74
Prerequisites
75
-------------
76

  
77
   sudo apt-get install git mysql-server apache2 php5 phpmyadmin php5-curl csh blast2 tomcat ant openjdk-6-jdk
78

  
79

  
80
Get MyLabStocks Sources
81
-----------------------
82

  
83
   git clone http://forge.cbp.ens-lyon.fr/git/mylabstocks
57 84

  
58
`MyLabsStocks` home page: http://www.ens-lyon.fr/LBMC/gisv/
59 85

  
60
`MyLabsStocks` documentation: http://www.ens-lyon.fr/LBMC/gisv/
86
Install wwwBlast
87
----------------
88

  
89
MyLabStocks is distributed with wwwblast working on a x64
90
architecture. For other architectures refer to the NCBI repositories h
91
ttp://mirrors.vbi.vt.edu/mirrors/ftp.ncbi.nih.gov/blast/executables/re
92
lease/LATEST
61 93

  
94
   cd mylabstocks/opts/
95
   tar xfvz wwwblast-2.2.26-x64-linux.tar.gz
96
   sudo cp -r blast /var/www/.
97
   sudo chown www-data:www-data /var/www/blast/TmpGifs /var/www/blast/*.log /var/www/blast/db/
98
   echo "<Directory /var/www/blast/>" > /tmp/blast.conf
99
   echo "   Options +ExecCGI" >> /tmp/blast.conf
100
   echo "</Directory>" >> /tmp/blast.conf
101
   echo "AddHandler cgi-script .cgi" >> /tmp/blast.conf
102
   sudo cp /tmp/blast.conf /etc/apache2/conf.d/blast.conf
103
   rm /tmp/blast.conf
104
   sudo /etc/init.d/apache2 restart
105
   sudo sed -i 's/<option VALUE.*test_na_db/<option VALUE=oligostock_db>oligostock_db<option VALUE=plasmidstock_db>plasmidstock_db<option VALUE=plfeatstock_db>plfeatstock_db/g' /var/www/blast/blast.html
106
   sudo sed -i 's/<option VALUE.*test_aa_db//g' /var/www/blast/blast.html
107
   cat /var/www/blast/blast.rc > /tmp/blast.rc
108
   echo "blastn oligostock_db" >> /tmp/blast.rc
109
   echo "tblastn oligostock_db" >> /tmp/blast.rc
110
   echo "tblastx oligostock_db" >> /tmp/blast.rc
111
   echo "blastn plasmidstock_db" >> /tmp/blast.rc
112
   echo "tblastn plasmidstock_db" >> /tmp/blast.rc
113
   echo "tblastx plasmidstock_db" >> /tmp/blast.rc
114
   echo "blastn plfeatstock_db" >> /tmp/blast.rc
115
   echo "tblastn plfeatstock_db" >> /tmp/blast.rc
116
   echo "tblastx plfeatstock_db" >> /tmp/blast.rc
117
   sudo cp /tmp/blast.rc /var/www/blast/blast.rc
118
   rm /tmp/blast.rc
119
   cd ../..
62 120

  
63
Installation
64
------------
65 121

  
66
rsync -cauvz  --exclude="formatdb.log" --exclude=".DS_Store" ../src/ root@cremone:/var/www/labstocks/
122
Install PlasMapper
123
------------------
67 124

  
68
cd /var/www/labstocks
69
# sudo vi connect_entry.php 
70
sudo touch formatdb.log
71
sudo chmod 440 connect_entry.php 
72
sudo chown -R www-data:www-data connect_entry.php formatdb.log  plasmid_files raw_dirs
125
   cd mylabstocks/opts/
126
   tar xfvz PlasMapper_download.tar.gz
127
   cd PlasMapper
128
   # modify installdir as /var/lib/tomcat6
129
   sed -i 's/\/home\/tomcat/\/var\/lib\/tomcat6/g' build.xml
130
   # modify servletjar as /usr/share/tomcat6/lib/servlet-api.jar
131
   sed -i 's/${installdir}\/common\/lib\/servlet-api.jar/\/usr\/share\/tomcat6\/lib\/servlet-api.jar/g' build.xml
132
   # change /home/tomcat for /var/lib/tomcat6
133
   sed -i 's/\/home\/tomcat/\/var\/lib\/tomcat6/g' src/ca/ualberta/xdong/plasMapper/annotate/plasMapConfiguration_en_CA.properties
134
   # and set blastallDir=/usr/bin/
135
   sed -i 's/\/usr\/local\/bin\//\/usr\/bin\//g' src/ca/ualberta/xdong/plasMapper/annotate/plasMapConfiguration_en_CA.properties
136
   # Here PlasMapper is ready to be configured
73 137

  
138
   ant clean
139
   ant build
140
   sudo ant install
141
   sudo rm -Rf /var/lib/tomcat6/webapps/PlasMapper/tmp
142
   sudo ln -s /tmp/tomcat6-tomcat6-tmp/ /var/lib/tomcat6/webapps/PlasMapper/tmp
143
   echo '<?xml version="1.0" encoding="UTF-8"?><Context path="/myapp" allowLinking="true"></Context>' > context.xml
144
   sudo mv context.xml /var/lib/tomcat6/webapps/PlasMapper/META-INF/
145
   sudo /etc/init.d/tomcat6 restart
146
   # Here PlasMapper works on your server at the url http://myserver:8080/PlasMapper
74 147

  
75
Migration
76
cd /var/www/labstocks
77
sudo cp -r ../labstocks.bck2/plasmid_files/*.gb.gz plasmid_files/.
78
sudo chmod -R a+r plasmid_files
79
sudo chown -R www-data:www-data plasmid_files
80
sudo cp -r ../labstocks.bck2/collections collections/.
81
cd raw_dirs/antibodies/
82
sudo mkdir `for ((a=1; a <= 24 ; a++)); do echo $a ; done`
83
cd ../..
84
sudo cp ../labstocks.bck2/antibody_files/10.Anti-H3K14ac\(07-353\).pdf                raw_dirs/antibodies/10/Anti-H3K14ac\(07-353\).pdf                            
85
sudo cp ../labstocks.bck2/antibody_files/11.Anti-H3ac\(06-599\).pdf                   raw_dirs/antibodies/11/Anti-H3ac\(06-599\).pdf                               
86
sudo cp ../labstocks.bck2/antibody_files/12.Anti-H3\(ab1791\).pdf                     raw_dirs/antibodies/12/Anti-H3\(ab1791\).pdf                                 
87
sudo cp ../labstocks.bck2/antibody_files/13.Anti-FLAG\(F7425\).pdf                    raw_dirs/antibodies/13/Anti-FLAG\(F7425\).pdf                                
88
sudo cp ../labstocks.bck2/antibody_files/14.Cre-Recombinase\(PRB-106C\).pdf           raw_dirs/antibodies/14/Cre-Recombinase\(PRB-106C\).pdf                        
89
sudo cp ../labstocks.bck2/antibody_files/15.GAPDH-HRP\(ab85760\).pdf                  raw_dirs/antibodies/15/GAPDH-HRP\(ab85760\).pdf                              
90
sudo cp ../labstocks.bck2/antibody_files/16.Anti-H3K9ac\(ab10812\).pdf                raw_dirs/antibodies/16/Anti-H3K9ac\(ab10812\).pdf                            
91
sudo cp ../labstocks.bck2/antibody_files/17.Anti-H3K4me3\(CS-003-100\).pdf            raw_dirs/antibodies/17/Anti-H3K4me3\(CS-003-100\).pdf                         
92
sudo cp ../labstocks.bck2/antibody_files/18.Anti-H3\(ab1791\).pdf                     raw_dirs/antibodies/18/Anti-H3\(ab1791\).pdf                                 
93
sudo cp ../labstocks.bck2/antibody_files/19.Anti-H3K4me1\(07-436\).pdf                raw_dirs/antibodies/19/Anti-H3K4me1\(07-436\).pdf                            
94
sudo cp ../labstocks.bck2/antibody_files/1.Anti-Actin-C4\(69100\).pdf                 raw_dirs/antibodies/1/Anti-Actin-C4\(69100\).pdf                             
95
sudo cp ../labstocks.bck2/antibody_files/20.Anti-H3K14ac\(07-353\).pdf                raw_dirs/antibodies/20/Anti-H3K14ac\(07-353\).pdf                            
96
sudo cp ../labstocks.bck2/antibody_files/21.Anti-H4K12ac\(07-595\).pdf                raw_dirs/antibodies/21/Anti-H4K12ac\(07-595\).pdf                            
97
sudo cp ../labstocks.bck2/antibody_files/22.Anti-Htz1\(39647\).pdf                    raw_dirs/antibodies/22/Anti-Htz1\(39647\).pdf                                
98
sudo cp ../labstocks.bck2/antibody_files/23.Anti-H2AFZ\(ab4626\).pdf                  raw_dirs/antibodies/23/Anti-H2AFZ\(ab4626\).pdf                              
99
sudo cp ../labstocks.bck2/antibody_files/24.Anti-LexA-DBD\(39185\).pdf                raw_dirs/antibodies/24/Anti-LexA-DBD\(39185\).pdf                            
100
sudo cp ../labstocks.bck2/antibody_files/2.Anti-Myc\(06-340\).pdf                     raw_dirs/antibodies/2/Anti-Myc\(06-340\).pdf                                 
101
sudo cp ../labstocks.bck2/antibody_files/3.Anti-H3\(ab10799\).pdf                     raw_dirs/antibodies/3/Anti-H3\(ab10799\).pdf                                 
102
sudo cp ../labstocks.bck2/antibody_files/4.Anti-H3\(ab24834\).pdf                     raw_dirs/antibodies/4/Anti-H3\(ab24834\).pdf                                 
103
sudo cp ../labstocks.bck2/antibody_files/5.Anti-H3K4me2\(ab7766\).pdf                 raw_dirs/antibodies/5/Anti-H3K4me2\(ab7766\).pdf                             
104
sudo cp ../labstocks.bck2/antibody_files/6.Anti-H3K4me3\(ab8580\).pdf                 raw_dirs/antibodies/6/Anti-H3K4me3\(ab8580\).pdf                             
105
sudo cp ../labstocks.bck2/antibody_files/7.Anti-H3K27me3\(07-449\).pdf                raw_dirs/antibodies/7/Anti-H3K27me3\(07-449\).pdf                            
106
sudo cp ../labstocks.bck2/antibody_files/8.Anti-H4K12ac\(06-761\).pdf                 raw_dirs/antibodies/8/Anti-H4K12ac\(06-761\).pdf                             
107
sudo cp ../labstocks.bck2/antibody_files/9.Beta-Actin-AC74\(A2228\).pdf               raw_dirs/antibodies/9/Beta-Actin-AC74\(A2228\).pdf                           
108
sudo chmod -R a+r raw_dirs
109
sudo chown -R www-data:www-data raw_dirs
110
# upload gene_synthesis_reports_pGY247.zip and gene_synthesis_reports_pGY248.zip
148
   sudo chown root:www-data /var/lib/tomcat6/webapps/PlasMapper/dataBase/db_vectorFeature/*.*
149
   sudo chmod 664 /var/lib/tomcat6/webapps/PlasMapper/dataBase/db_vectorFeature/*.*
150
   sudo chown root:www-data /var/lib/tomcat6/webapps/PlasMapper/dataBase/db_vectorFeature/
151
   sudo chmod 775 /var/lib/tomcat6/webapps/PlasMapper/dataBase/db_vectorFeature/
152
   sudo chown root:www-data /var/lib/tomcat6/webapps/PlasMapper/html/feature.html
153
   sudo chmod 664 /var/lib/tomcat6/webapps/PlasMapper/html/feature.html
154
   # Here plasmids feature could be blasted by MyLabStock
111 155

  
156
   cd ../../..
112 157

  
113 158

  
159
Install MyLabStocks
160
-------------------
114 161

  
162
   sudo cp -r mylabstocks/src /var/www/labstocks
163
   sudo rm /var/www/labstocks/
164
   sudo touch /var/www/labstocks/formatdb.log
165
   sudo chmod 440 /var/www/labstocks/connect_entry.php
166
   sudo mkdir /var/www/labstocks/plasmid_files
167
   sudo mkdir /var/www/labstocks/raw_dirs
168
   sudo mkdir /var/www/labstocks/collections
169
   sudo chown -R www-data:www-data /var/www/labstocks/connect_entry.php /var/www/labstocks/formatdb.log  /var/www/labstocks/plasmid_files /var/www/labstocks/raw_dirs
115 170

  
116
scp -r stainer:Desktop/LBMC/projects/plasmapper/src/plasmid_files labstocks
117
vi labstocks/connect_entry.php
118
sudo cp -r labstocks /var/www/
119
sudo chmod 440 /var/www/labstocks/connect_entry.php 
120
sudo chown www-data:www-data /var/www/labstocks/connect_entry.php
121
sudo chown -R www-data:www-data /var/www/labstocks/plasmid_files
122
sudo chown -R www-data:www-data /var/www/labstocks/raw_dirs
123
sudo touch /var/www/labstocks/formatdb.log
124
sudo chown www-data:www-data /var/www/labstocks/formatdb.log
171

  
172
Configurate MyLabStocks
173
-----------------------
174

  
175
Now you have to update connexion params in
176
/var/www/labstocks/connect_entry.php
177

  
178
   sudo vi /var/www/labstocks/connect_entry.php
179

  
180
finally run the following script to  define passwords and instantiate
181
db.
182

  
183
   php mylabstocks/src/install_db.phpsh
184

  
185
Congratulation your LabStocks instance is available on the url
186
http://your_server/labstocks.
125 187

  
126 188

  
189
Links
190
-----
127 191

  
192
*MyLabStocks* home, repository and documentation: http://forge.cbp
193
.ens-lyon.fr/redmine/projects/mylabstocks
128 194

  
195
Gael Yvert lab: http://www.ens-lyon.fr/LBMC/gisv/
129 196

  
130 197

  
131 198
Usage
132 199
=====
133 200

  
134
In the strain section, the form `Search in genotype` filters strains where the 
135
fields `locus1`, `locus2`, `locus3`, `locus4`, `locus5`, `ADE2`, `HIS3`, `LEU2`, 
136
`LYS2`, `MET15`, `TRP1`, `URA3`, `HO_`, `Cytoplasmic_Character` or 
137
`extrachromosomal_plasmid` contain the given expression. This filter is case 
138
insensitive.
139

  
140
Even in edit mode, users are not granted permission to directly edit a plasmid 
141
sequence, nor the URL to the plasmid sequence file. If a new sequence must be 
142
entered instead of the current one, users must upload a new sequence file, in 
143
.gb or .gb.gz format. MyLabStocks then automatically reads the file and update 
144
the sequence field and the URL. This ensures consistency between URL, sequence 
145
and the file itself.
146

  
147
TODO
148
====
149

  
150
  - Upload a .gb file, gzip it on fly for plasmids.
151
  - Bug with plasmid 246, having a look on log file: tail -f /var/log/tomcat6/catalina.out
152
  - Add persistence on advanced search form conditions.
153
  - Remove file field for antibodies
154
  - More error msg when an uploaded file is too big. (>2Mo).
201

  
202
Advanced Search
203
---------------
204

  
205
In the strain section, the form *Search in genotype* filters strains
206
where the fields *locus1*, *locus2*, *locus3*, *locus4*, *locus5*,
207
*ADE2*, *HIS3*, *LEU2*, *LYS2*, *MET15*, *TRP1*, *URA3*, *HO_*,
208
*Cytoplasmic_Character* or *extrachromosomal_plasmid* contain the
209
given expression. This filter is case insensitive.
210

  
211

  
212
Plasmids Sequences Management
213
-----------------------------
214

  
215
Even in edit mode, users are not granted permission to directly edit a
216
plasmid sequence, nor the URL to the plasmid sequence file. If a new
217
sequence must be entered instead of the current one, users must upload
218
a new sequence file, in .gb or .gb.gz format. MyLabStocks then
219
automatically reads the file and update the sequence field and the
220
URL. This ensures consistency between URL, sequence and the file
221
itself.
b/doc/index.rst
95 95
  cd ../..
96 96
..
97 97

  
98

  
99
Now you have a wwwBlast instance available here: http://your_server/blast.
100

  
101

  
98 102
Install PlasMapper
99 103
------------------
100 104

  
......
134 138
  cd ../../..
135 139
..
136 140

  
141
Now you have a PlasMapper instance available here: http://your_server:8080/PlasMapper.
142

  
137 143

  
138 144
Install MyLabStocks
139 145
-------------------
......
141 147
.. code:: bash
142 148

  
143 149
  sudo cp -r mylabstocks/src /var/www/labstocks
144
  sudo rm /var/www/labstocks/
150
  sudo rm /var/www/labstocks/install_db.phpsh
145 151
  sudo touch /var/www/labstocks/formatdb.log
146 152
  sudo chmod 440 /var/www/labstocks/connect_entry.php 
147 153
  sudo mkdir /var/www/labstocks/plasmid_files 
......
150 156
  sudo chown -R www-data:www-data /var/www/labstocks/connect_entry.php /var/www/labstocks/formatdb.log  /var/www/labstocks/plasmid_files /var/www/labstocks/raw_dirs
151 157
..
152 158

  
153
Configurate MyLabStocks
154
-----------------------
159
Configure MyLabStocks
160
---------------------
155 161

  
156 162
Now you have to update connexion params in /var/www/labstocks/connect_entry.php
157 163

  
......
167 173
  php mylabstocks/src/install_db.phpsh 
168 174
..
169 175

  
170
Congratulation your LabStocks instance is available on the url http://your_server/labstocks.
176
Congratulation your LabStocks instance is available here: http://your_server/labstocks.
171 177

  
178
Go to http://your_server/labstocks/wwwblast.php to initialize blast dbs.
172 179

  
173 180
Links
174 181
-----
b/src/plasmids.php
180 180
  	'table'  => 'pl_type',
181 181
	'column' => 'type')
182 182
);
183
$opts['fdd']['Yeast_selection_1'] = array(
184
  'name'     => 'Yeast selection 1',
183
$opts['fdd']['Marker_1'] = array(
184
  'name'     => 'Marker 1',
185 185
  'select'   => 'D',
186 186
  'maxlen'   => 25,
187 187
  'sort'     => true,
......
189 189
  	'table'  => 'pl_yeast_marker',
190 190
	'column' => 'type')
191 191
);
192
$opts['fdd']['Yeast_selection_2'] = array(
193
  'name'     => 'Yeast selection 2',
192
$opts['fdd']['Marker_2'] = array(
193
  'name'     => 'Marker 2',
194 194
  'select'   => 'D',
195 195
  'maxlen'   => 25,
196 196
  'sort'     => true,
b/src/sql/labstocks_db.sql
27 27
--
28 28

  
29 29
CREATE TABLE IF NOT EXISTS `ab_avail` (
30
  `Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
30
  `Type` varchar(50) COLLATE utf8_general_ci NOT NULL,
31 31
  PRIMARY KEY (`Type`)
32
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
33 33

  
34 34
--
35 35
-- Dumping data for table `ab_avail`
......
46 46
--
47 47

  
48 48
CREATE TABLE IF NOT EXISTS `ab_host` (
49
  `Host` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
49
  `Host` varchar(50) COLLATE utf8_general_ci NOT NULL,
50 50
  PRIMARY KEY (`Host`)
51
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
51
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
52 52

  
53 53
--
54 54
-- Dumping data for table `ab_host`
......
67 67
--
68 68

  
69 69
CREATE TABLE IF NOT EXISTS `ab_monopoly` (
70
  `Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
70
  `Type` varchar(50) COLLATE utf8_general_ci NOT NULL,
71 71
  PRIMARY KEY (`Type`)
72
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
72
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
73 73

  
74 74
--
75 75
-- Dumping data for table `ab_monopoly`
......
86 86
--
87 87

  
88 88
CREATE TABLE IF NOT EXISTS `ab_supplier` (
89
  `Supplier` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
89
  `Supplier` varchar(50) COLLATE utf8_general_ci NOT NULL,
90 90
  PRIMARY KEY (`Supplier`)
91
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
91
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
92 92

  
93 93
--
94 94
-- Dumping data for table `ab_supplier`
......
110 110
--
111 111

  
112 112
CREATE TABLE IF NOT EXISTS `ab_type` (
113
  `Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
113
  `Type` varchar(50) COLLATE utf8_general_ci NOT NULL,
114 114
  PRIMARY KEY (`Type`)
115
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
115
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
116 116

  
117 117
--
118 118
-- Dumping data for table `ab_type`
......
152 152
--
153 153

  
154 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');
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.Y', 'monoclonal', '9045J', 'MPBiomedicals', 'Boite Ac Primaires#1 / Tiroir #3', '1:20000', '', '69100');
156 156

  
157 157
-- --------------------------------------------------------
158 158

  
......
170 170
--
171 171

  
172 172
INSERT INTO `lab_members` (`id`) VALUES
173
('Christelle.Damon'),
174
('Florent.Chuffart'),
175
('Gael.Yvert'),
173
('Christelle.D'),
174
('Florent.C'),
175
('Gael.Y'),
176 176
('Gift.or.Purchased'),
177
('Helene.Bottin');
177
('Helene.B');
178 178

  
179 179
-- --------------------------------------------------------
180 180

  
......
198 198
--
199 199

  
200 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');
201
(1, '2005-04-01', '2006-01-31', 'Gael.Y', 'GY8'),
202
(2, '2005-05-24', '2005-12-07', 'Christelle.D', 'CD1'),
203
(3, '2008-01-16', '0000-00-00', 'Helene.B', 'EVO'),
204
(4, '2009-07-06', '2010-01-19', 'Helene.B', 'B49069'),
205
(5, '2012-09-03', '0000-00-00', 'Florent.C', 'E002933');
206 206

  
207 207
--
208 208
-- Table structure for table `oligos`
......
225 225
--
226 226

  
227 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');
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.Y', ''),
229
('1F14', 'gtgatgacggtgaaaacctc', '2009-09-07', 'Upstream selection marker in pSH* plasmids.', '', 'Gael.Y', ''),
230
('1F19', 'ataagggcgacacggaaatg', '2009-10-12', 'To sequence CEN/ARS of pCEN-AdeAru', '', 'Gael.Y', ''),
231
('1F97', 'tgtaacccactcgtgcac', '2010-03-01', 'To sequence any plasmid from the AmpR coding sequence.', '', 'Gael.Y', 'SePoP'),
232
('1H75', 'cactatagggcgaattgg', '2011-01-06', 'To amplify yEGFP-CYC1term from pGY8 and clone it into pCM183 by homologous recombination in yeast.', '', 'Gael.Y', '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.B', 'SePoP');
234 234

  
235 235
-- --------------------------------------------------------
236 236

  
......
239 239
--
240 240

  
241 241
CREATE TABLE IF NOT EXISTS `olig_purif` (
242
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
242
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
243 243
  PRIMARY KEY (`type`)
244 244
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
245 245

  
......
261 261
--
262 262

  
263 263
CREATE TABLE IF NOT EXISTS `pip_events` (
264
  `Events` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
264
  `Events` varchar(100) COLLATE utf8_general_ci NOT NULL,
265 265
  PRIMARY KEY (`Events`)
266
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
266
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;
267 267

  
268 268
--
269 269
-- Dumping data for table `pip_events`
......
284 284
--
285 285

  
286 286
CREATE TABLE IF NOT EXISTS `pip_generic_user` (
287
  `User` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
287
  `User` varchar(100) COLLATE utf8_general_ci NOT NULL,
288 288
  PRIMARY KEY (`User`)
289
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
289
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
290 290

  
291 291
--
292 292
-- Dumping data for table `pip_generic_user`
293 293
--
294 294

  
295 295
INSERT INTO `pip_generic_user` (`User`) VALUES
296
('Christelle.Damon'),
296
('Christelle.D'),
297 297
('Everybody'),
298 298
('Standby'),
299 299
('Student');
......
306 306

  
307 307
CREATE TABLE IF NOT EXISTS `pip_history` (
308 308
  `ID` int(10) NOT NULL AUTO_INCREMENT,
309
  `Serial_Number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
309
  `Serial_Number` varchar(50) COLLATE utf8_general_ci NOT NULL,
310 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,
311
  `Owner_fromNowOn` varchar(50) COLLATE utf8_general_ci NOT NULL,
312
  `Usage_fromNowOn` varchar(50) COLLATE utf8_general_ci NOT NULL,
313
  `Event_Type` varchar(100) COLLATE utf8_general_ci NOT NULL,
314
  `Comments` text COLLATE utf8_general_ci NOT NULL,
315 315
  PRIMARY KEY (`ID`)
316
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=90 ;
316
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=90 ;
317 317

  
318 318
--
319 319
-- Dumping data for table `pip_history`
320 320
--
321 321

  
322 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');
323
(1, 'Y60538M', '2005-00-00', 'Christelle.D', 'Misc', 'Purchase', ''),
324
(2, 'Y60538M', '2006-00-00', 'Helene.B', 'Misc', 'Change User', 'Previous user: Christelle Damon'),
325
(3, 'Y60538M', '2009-03-04', 'Helene.B', 'Misc', 'Maintenance', 'Change of parts (spring was broken 2009_02_12)'),
326
(4, 'Y58817M', '2005-00-00', 'Christelle.D', 'Misc', 'Purchase', ''),
327
(5, 'Y58817M', '2006-00-00', 'Helene.B', 'Misc', 'Change User', 'Previous user: Christelle Damon'),
328
(6, 'Y58817M', '2009-03-04', 'Helene.B', 'Misc', 'Maintenance', 'Change of parts '),
329
(7, 'Y63235M', '2005-00-00', 'Christelle.D', 'Misc', 'Purchase', ''),
330
(8, 'Y63235M', '2009-03-04', 'Helene.B', 'Misc', 'Maintenance', ''),
331
(9, 'Y63235M', '2006-00-00', 'Helene.B', 'Misc', 'Change User', 'Previous user: Christelle Damon'),
332
(10, 'Z64108A', '2005-00-00', 'Christelle.D', 'Misc', 'Purchase', ''),
333
(11, 'Z64108A', '2006-00-00', 'Helene.B', 'Misc', 'Change User', 'Previous user: Christelle Damon'),
334
(12, 'Z64108A', '2009-03-04', 'Helene.B', 'Misc', 'Maintenance', ''),
335
(13, '2102895', '2005-09-01', 'Everybody', 'Misc', 'Purchase', ''),
336
(14, '6133327', '2007-03-02', 'Everybody', 'Misc', 'Purchase', ''),
337
(15, 'Z64108A', '2011-02-18', 'Andri.Leonidou', 'Misc', 'Change User', 'Previous user: Christelle Damon');
338 338

  
339 339
-- --------------------------------------------------------
340 340

  
......
343 343
--
344 344

  
345 345
CREATE TABLE IF NOT EXISTS `pip_marque` (
346
  `Marque` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
346
  `Marque` varchar(100) COLLATE utf8_general_ci NOT NULL,
347 347
  PRIMARY KEY (`Marque`)
348
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
348
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;
349 349

  
350 350
--
351 351
-- Dumping data for table `pip_marque`
......
363 363
--
364 364

  
365 365
CREATE TABLE IF NOT EXISTS `pip_nonusers` (
366
  `User` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
366
  `User` varchar(100) COLLATE utf8_general_ci NOT NULL,
367 367
  PRIMARY KEY (`User`)
368
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
368
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
369 369

  
370 370
--
371 371
-- Dumping data for table `pip_nonusers`
372 372
--
373 373

  
374 374
INSERT INTO `pip_nonusers` (`User`) VALUES
375
('Florent.Chuffart'),
375
('Florent.C'),
376 376
('Gift.or.Purchased');
377 377

  
378 378
-- --------------------------------------------------------
......
383 383

  
384 384
CREATE TABLE IF NOT EXISTS `pip_stock` (
385 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,
386
  `Serial_Number` varchar(40) COLLATE utf8_general_ci NOT NULL,
387
  `Marque` varchar(40) COLLATE utf8_general_ci NOT NULL,
388
  `Type` varchar(50) COLLATE utf8_general_ci NOT NULL,
389 389
  PRIMARY KEY (`ID`),
390 390
  UNIQUE KEY `Serial_Number` (`Serial_Number`)
391
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=228 ;
391
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=228 ;
392 392

  
393 393
--
394 394
-- Dumping data for table `pip_stock`
......
396 396

  
397 397
INSERT INTO `pip_stock` (`ID`, `Serial_Number`, `Marque`, `Type`) VALUES
398 398
(1, 'Y60538M', 'Gilson', 'P1000'),
399
(6, '6133327', 'BioHit', 'multicanaux_02-10ul'),
400
(5, '2102895', 'Eppendorf', 'multicanaux_10-100ul'),
401
(4, 'Z64108A', 'Gilson', 'P2'),
399
(2, 'Y58817M', 'Gilson', 'P200'),
402 400
(3, 'Y63235M', 'Gilson', 'P20'),
403
(2, 'Y58817M', 'Gilson', 'P200');
401
(4, 'Z64108A', 'Gilson', 'P2'),
402
(5, '2102895', 'Eppendorf', 'multicanaux_10-100ul'),
403
(6, '6133327', 'BioHit', 'multicanaux_02-10ul');
404 404

  
405 405
-- --------------------------------------------------------
406 406

  
......
409 409
--
410 410

  
411 411
CREATE TABLE IF NOT EXISTS `pip_type` (
412
  `Type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
412
  `Type` varchar(50) COLLATE utf8_general_ci NOT NULL,
413 413
  PRIMARY KEY (`Type`)
414
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
414
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
415 415

  
416 416
--
417 417
-- Dumping data for table `pip_type`
......
433 433
--
434 434

  
435 435
CREATE TABLE IF NOT EXISTS `pip_usage` (
436
  `Usage` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
436
  `Usage` varchar(100) COLLATE utf8_general_ci NOT NULL,
437 437
  PRIMARY KEY (`Usage`)
438
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
438
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;
439 439

  
440 440
--
441 441
-- Dumping data for table `pip_usage`
......
453 453
--
454 454

  
455 455
CREATE TABLE IF NOT EXISTS `pip_users` (
456
  `User` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
456
  `User` varchar(100) COLLATE utf8_general_ci NOT NULL,
457 457
  PRIMARY KEY (`User`)
458
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
458
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
459 459

  
460 460
--
461 461
-- Dumping data for table `pip_users`
462 462
--
463 463

  
464 464
INSERT INTO `pip_users` (`User`) VALUES
465
('Christelle.Damon'),
466
('Helene.Bottin');
465
('Christelle.D'),
466
('Helene.B');
467 467

  
468 468
-- --------------------------------------------------------
469 469

  
......
478 478
  `date_` date DEFAULT NULL,
479 479
  `Checkings` varchar(200) DEFAULT NULL,
480 480
  `Type_` varchar(25) DEFAULT NULL,
481
  `Yeast_selection_1` varchar(25) DEFAULT NULL,
482
  `Yeast_selection_2` varchar(25) DEFAULT NULL,
481
  `Marker_1` varchar(25) DEFAULT NULL,
482
  `Marker_2` varchar(25) DEFAULT NULL,
483 483
  `Bacterial_selection` varchar(25) DEFAULT NULL,
484 484
  `Tags` varchar(25) DEFAULT NULL,
485 485
  `parent_vector` varchar(50) DEFAULT NULL,
......
503 503
-- Dumping data for table `plasmids`
504 504
--
505 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');
506
INSERT INTO `plasmids` (`id`, `Name_`, `Other_names`, `date_`, `Checkings`, `Type_`, `Marker_1`, `Marker_2`, `Bacterial_selection`, `Tags`, `parent_vector`, `Insert_`, `Insert_Type`, `Construction_Description`, `Reference_`, `Reporter`, `Promoter`, `Link_to_file`, `sequence`, `image_file`, `Author`) VALUES
507
(1, '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
(2, '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
(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'),
510
(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'),
511
(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');
512 512

  
513 513
-- --------------------------------------------------------
514 514

  
......
517 517
--
518 518

  
519 519
CREATE TABLE IF NOT EXISTS `pl_bacterial_selection` (
520
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
520
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
521 521
  PRIMARY KEY (`type`)
522 522
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
523 523

  
......
542 542
  `Sequence` longtext NOT NULL,
543 543
  `Date_` date DEFAULT NULL,
544 544
  `Description` longtext,
545
  `Comments` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
545
  `Comments` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
546 546
  `Author` varchar(50) DEFAULT NULL,
547 547
  `Category` varchar(15) NOT NULL DEFAULT 'OTH',
548 548
  PRIMARY KEY (`id`),
......
555 555
--
556 556

  
557 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');
558
(1, 'CGCTTGCCTGTAACTTACACGCGCCTCGTATCTTTTAATGATGGAATAATTTGGGAATTTACTCTGTGTTTATTTATTTTTATGTTTTGTATTTGGATTTTAGAAAGTAAATAAAGAAGGTAGAAGAGTTACGGAATGAAGAAAAAAAAATAAACAAAGGTTTAAAAAATTTCAACAAAAAGCGTACTTTACATATATATTTATTAGACAAGAAAAGCAGATTAAATAGATATACATTCGATTAACGATAAGTAAAATGTAAAATCACAGGATTTTCGTGTGTGGTCTTCTACACAGACAAGATGAAACAATTCGGCATTAATACCTGAGAGCAGGAAGAGCAAGATAAAAGGTAGTATTTGTTGGCGATCCCCCTAGAGTCTTTTACATCTTCGGAAAACAAAAACTATTTTTTCTTTAATTTCTTTTTTTACTTTCTATTTTTAATTTATATATTTATATTAAAAAATTTAAATTATAATTATTTTTATAGCACGTGATGAAAAGGACC', '2013-06-11', 'CEN6/ARSH4', '', 'Gael.Y', 'ORI'),
559
(2, 'ATAACTTCGTATAATGTATGCTATACGAAGTTAT', '2013-06-11', 'LoxP', '', 'Gael.Y', 'OTH'),
560
(3, 'ATGTCTAAAGGTGAAGAATTATTCACTGGTGTTGTCCCAATTTTGGTTGAATTAGATGGTGATGTTAATGGTCACAAATTTTCTGTCTCCGGTGAAGGTGAAGGTGATGCTACTTACGGTAAATTGACCTTAAAATTTATTTGTACTACTGGTAAATTGCCAGTTCCATGGCCAACCTTAGTCACTACTTTCGGTTATGGTGTTCAATGTTTTGCTAGATACCCAGATCATATGAAACAACATGACTTTTTCAAGTCTGCCATGCCAGAAGGTTATGTTCAAGAAAGAACTATTTTTTTCAAAGATGACGGTAACTACAAGACCAGAGCTGAAGTCAAGTTTGAAGGTGATACCTTAGTTAATAGAATCGAATTAAAAGGTATTGATTTTAAAGAAGATGGTAACATTTTAGGTCACAAATTGGAATACAACTATAACTCTCACAATGTTTACATCATGGCTGACAAACAAAAGAATGGTATCAAAGTTAACTTCAAAATTAGACACAACATTGAAGATGGTTCTGTTCAATTAGCTGACCATTATCAACAAAATACTCCAATTGGTGATGGTCCAGTCTTGTTACCAGACAACCATTACTTATCCACTCAATCTGCCTTATCCAAAGATCCAAACGAAAAGAGAGACCACATGGTCTTGTTAGAATTTGTTACTGCTGCTGGTATTACCCATGGTATGGATGAATTGTACAAA', '2013-06-11', 'yEGFP3-CDS', '', 'Gael.Y', 'REP'),
561
(4, 'atgacagagcagaaagccctagtaaagcgtattacaaatgaaaccaagattcagattgcgatctctttaaagggtggtcccctagcgatagagcactcgatcttcccagaaaaagaggcagaagcagtagcagaacaggccacacaatcgcaagtgattaacgtccacacaggtatagggtttctggaccatatgatacatgctctggccaagcattccggctggtcgctaatcgttgagtgcattggtgacttacacatagacgaccatcacaccactgaagactgcgggattgctctcggtcaagcttttaaagaggccctactggcgcgtggagtaaaaaggtttggatcaggatttgcgcctttggatgaggcactttccagagcggtggtagatctttcgaacaggccgtacgcagttgtcgaacttggtttgcaaagggagaaagtaggagatctctcttgcgagatgatcccgcattttcttgaaagctttgcagaggctagcagaattaccctccacgttgattgtctgcgaggcaagaatgatcatcaccgtagtgagagtgcgttcaaggctcttgcggttgccataagagaagccacctcgcccaatggtaccaacgatgttccctccaccaaaggtgttcttatgtag', '2013-07-19', 'HIS3-CDS', '', 'Gael.Y', 'SEL'),
562
(5, 'cgttttaagagcttggtgagcgctaggagtcactgccaggtatcgtttgaacacggcattagtcagggaagtcataacacagtcctttcccgcaattttctttttctattactcttggcctcctctagtacactctatatttttttatgcctcggtaatgattttcatttttttttttcccctagcggatgactctttttttttcttagcgattggcattatcacataatgaattatacattatataaagtaatgtgatttcttcgaagaatatactaaaaaatgagcaggcaagataaacgaaggcaaag', '2013-07-19', 'HIS3-prom', '', 'Gael.Y', 'PRO'),
563
(6, 'tgacaccgattatttaaagctgcagcatacgatatatatacatgtgtatatatgtatacctatgaatgtcagtaagtatgtatacgaacagtatgatactgaagatgacaaggtaatgcatcattctatacgtgtcattctgaacgaggcgcgctttccttttttctttttgctttttctttttttttctcttgaactcga', '2013-07-19', 'HIS3-term', '', 'Gael.Y', 'TER');
564 564

  
565 565
-- --------------------------------------------------------
566 566

  
......
569 569
--
570 570

  
571 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,
572
  `Category` varchar(15) COLLATE utf8_general_ci NOT NULL,
573
  `Name` varchar(50) COLLATE utf8_general_ci DEFAULT NULL,
574 574
  PRIMARY KEY (`Category`)
575
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
575
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
576 576

  
577 577
--
578 578
-- Dumping data for table `pl_features_catname`
......
597 597
--
598 598

  
599 599
CREATE TABLE IF NOT EXISTS `pl_tag` (
600
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
600
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
601 601
  PRIMARY KEY (`type`)
602 602
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
603 603

  
......
623 623
--
624 624

  
625 625
CREATE TABLE IF NOT EXISTS `pl_type` (
626
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
626
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
627 627
  PRIMARY KEY (`type`)
628 628
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
629 629

  
......
644 644
--
645 645

  
646 646
CREATE TABLE IF NOT EXISTS `pl_yeast_marker` (
647
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
647
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
648 648
  PRIMARY KEY (`type`)
649 649
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
650 650

  
......
685 685
--
686 686

  
687 687
CREATE TABLE IF NOT EXISTS `pl_yeast_promoter` (
688
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
688
  `type` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
689 689
  PRIMARY KEY (`type`)
690 690
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
691 691

  
......
714 714

  
715 715
CREATE TABLE IF NOT EXISTS `strains` (
716 716
  `id` int(10) unsigned NOT NULL,
717
  `Name_` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
717
  `Name_` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
718 718
  `Date_` date DEFAULT NULL,
719
  `Comments` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
719
  `Comments` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
720 720
  `General_Background` varchar(25) NOT NULL,
721 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,
722
  `ADE2` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
723
  `HIS3` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
724
  `LEU2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
725
  `LYS2` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
726
  `TRP1` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
727
  `URA3` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
728
  `HO_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
729
  `locus1` varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
730
  `locus2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
731
  `locus3` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
732 732
  `Parental_strain` varchar(25) DEFAULT NULL,
733 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,
734
  `Checkings` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
735
  `extrachromosomal_plasmid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
736 736
  `Other_names` varchar(25) DEFAULT NULL,
737 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,
738
  `locus4` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
739
  `locus5` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
740
  `Cytoplasmic_Character` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
741 741
  `Last_modified` date DEFAULT NULL,
742
  `MET15` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
742
  `MET15` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
743 743
  `Author` varchar(50) DEFAULT NULL,
744 744
  PRIMARY KEY (`id`),
745 745
  KEY `Author` (`Author`)
......
750 750
--
751 751

  
752 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');
753
(1, '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
(2, '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
(3, '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
(4, '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
(5, '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
(6, '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
(7, '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
(8, '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
(9, '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
(10, '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
(11, '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
(12, '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
(13, '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
(14, '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
(15, '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
(16, '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
(17, '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
(18, '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
(19, '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 772

  
773 773
-- --------------------------------------------------------
774 774

  
......
777 777
--
778 778

  
779 779
CREATE TABLE IF NOT EXISTS `st_ADE2` (
780
  `alleles` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
780
  `alleles` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
781 781
  PRIMARY KEY (`alleles`)
782 782
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
783 783

  
......
803 803
--
804 804

  
805 805
CREATE TABLE IF NOT EXISTS `st_general_backgrounds` (
806
  `background` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
806
  `background` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
807 807
  PRIMARY KEY (`background`)
808 808
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
809 809

  
......
920 920
--
921 921

  
922 922
CREATE TABLE IF NOT EXISTS `st_HIS3` (
923
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
923
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
924 924
  PRIMARY KEY (`alleles`)
925 925
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
926 926

  
......
950 950
--
951 951

  
952 952
CREATE TABLE IF NOT EXISTS `st_LEU2` (
953
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
953
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
954 954
  PRIMARY KEY (`alleles`)
955 955
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
956 956

  
......
986 986
--
987 987

  
988 988
CREATE TABLE IF NOT EXISTS `st_LYS2` (
989
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
989
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
990 990
  PRIMARY KEY (`alleles`)
991 991
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
992 992

  
......
1016 1016
--
1017 1017

  
1018 1018
CREATE TABLE IF NOT EXISTS `st_MAT` (
1019
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1019
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1020 1020
  PRIMARY KEY (`alleles`)
1021 1021
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1022 1022

  
......
1041 1041
--
1042 1042

  
1043 1043
CREATE TABLE IF NOT EXISTS `st_MET15` (
1044
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1044
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1045 1045
  PRIMARY KEY (`alleles`)
1046 1046
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1047 1047

  
......
1064 1064
--
1065 1065

  
1066 1066
CREATE TABLE IF NOT EXISTS `st_TRP1` (
1067
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1067
  `alleles` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1068 1068
  PRIMARY KEY (`alleles`)
1069 1069
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1070 1070

  
......
1103 1103
--
1104 1104

  
1105 1105
CREATE TABLE IF NOT EXISTS `st_URA3` (
1106
  `alleles` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
1106
  `alleles` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
1107 1107
  PRIMARY KEY (`alleles`)
1108 1108
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1109 1109

  
b/src/stylesheet.css
4 4
  font:normal 87.5%/1.4 Arial,sans-serif;
5 5
}
6 6

  
7
td {
8
 font:normal 87.5%/1.4 Arial,sans-serif;
9
}
7 10

  
8 11
a:link, a:visited , a:active, a:hover {
9 12
  text-decoration: none;  

Formats disponibles : Unified diff