1 """We have many accessions for our libraries,
3 our data isn't really part of the htsworkflow project
4 so it seemed unnecessary to put it in the normal migrations
6 from datetime import datetime
10 from samples.models import (
17 def load_encode3_accessions():
19 ('02973', 'ENCLB661EBH', '2013-12-31T01:24:29.450163+0000'),
20 ('10007', 'ENCLB372ZZZ', '2013-09-13T13:31:00.667863-0800'),
21 ('10065', 'ENCLB350ZZZ', '2013-09-13T13:31:00.711427-0800'),
22 ('10135', 'ENCLB371ZZZ', '2013-09-13T13:31:00.800862-0800'),
23 ('10150', 'ENCLB375ZZZ', '2013-09-13T13:31:00.845686-0800'),
24 ('10158', 'ENCLB349ZZZ', '2013-09-13T13:31:00.888358-0800'),
25 ('10296', 'ENCLB326ZZZ', '2013-09-13T13:31:01.050362-0800'),
26 ('10330', 'ENCLB316ZZZ', '2013-09-13T13:31:01.094821-0800'),
27 ('10331', 'ENCLB312ZZZ', '2013-09-13T13:31:01.138188-0800'),
28 ('10333', 'ENCLB348ZZZ', '2013-09-13T13:31:01.182426-0800'),
29 ('10335', 'ENCLB325ZZZ', '2013-09-13T13:31:01.226356-0800'),
30 ('10409', 'ENCLB335ZZZ', '2013-09-13T13:31:01.268879-0800'),
31 ('10409', 'ENCLB373ZZZ', '2013-09-13T13:31:03.237846-0800'),
32 ('10481', 'ENCLB328ZZZ', '2013-09-13T13:31:01.312917-0800'),
33 ('10502', 'ENCLB322ZZZ', '2013-09-13T13:31:01.357314-0800'),
34 ('10506', 'ENCLB354ZZZ', '2013-09-13T13:31:01.402055-0800'),
35 ('10515', 'ENCLB150CGC', '2013-12-31T01:24:31.329052+0000'),
36 ('10516', 'ENCLB858EYY', '2014-02-11T04:54:55.778298+0000'),
37 ('10517', 'ENCLB296STQ', '2013-12-31T01:24:31.650260+0000'),
38 ('10536', 'ENCLB317ZZZ', '2013-09-13T13:31:01.484966-0800'),
39 ('10565', 'ENCLB700LMU', '2013-12-31T01:24:31.490950+0000'),
40 ('10567', 'ENCLB912OTZ', '2013-12-31T01:24:31.813954+0000'),
41 ('10599', 'ENCLB329ZZZ', '2013-09-13T13:31:01.589610-0800'),
42 ('10703', 'ENCLB347ZZZ', '2013-09-13T13:31:01.634288-0800'),
43 ('10704', 'ENCLB353ZZZ', '2013-09-13T13:31:01.678096-0800'),
44 ('10874', 'ENCLB211VHB', '2013-12-31T00:56:50.185938+0000'),
45 ('10876', 'ENCLB827ADT', '2014-02-11T04:54:56.056039+0000'),
46 ('10878', 'ENCLB596OCH', '2013-12-31T01:24:32.312287+0000'),
47 ('10879', 'ENCLB285RFV', '2013-12-31T01:24:32.481428+0000'),
48 ('10881', 'ENCLB928ZOL', '2013-12-31T01:24:31.988425+0000'),
49 ('10882', 'ENCLB070EUV', '2013-12-31T01:24:32.157600+0000'),
50 ('10883', 'ENCLB553XIA', '2013-12-31T00:56:50.961345+0000'),
51 ('10884', 'ENCLB439WFS', '2013-12-31T01:24:32.695166+0000'),
52 ('10885', 'ENCLB369MMK', '2013-12-31T00:56:51.214725+0000'),
53 ('10947', 'ENCLB184USD', '2014-02-11T04:54:52.964669+0000'),
54 ('10985', 'ENCLB359ZZZ', '2013-09-13T13:31:02.337847-0800'),
55 ('10986', 'ENCLB356ZZZ', '2013-09-13T13:31:02.556929-0800'),
56 ('11007', 'ENCLB866SQE', '2014-02-11T04:54:52.164787+0000'),
57 ('11008', 'ENCLB424IFK', '2014-02-11T04:54:51.864439+0000'),
58 ('11009', 'ENCLB205QXO', '2015-01-15T19:40:15.525219+0000'),
59 ('11010', 'ENCLB529ELW', '2014-02-11T04:54:51.647823+0000'),
60 ('11011', 'ENCLB732DFW', '2014-02-11T04:54:51.042384+0000'),
61 ('11038', 'ENCLB857ING', '2013-12-31T01:24:29.125690+0000'),
62 ('11039', 'ENCLB637FKG', '2013-12-31T01:24:29.779715+0000'),
63 ('11154', 'ENCLB358ZZZ', '2013-09-13T13:31:02.792781-0800'),
64 ('11155', 'ENCLB357ZZZ', '2013-09-13T13:31:02.954320-0800'),
65 ('11204', 'ENCLB625YJM', '2014-02-11T04:54:55.290109+0000'),
66 ('11206', 'ENCLB043WCL', '2014-02-11T04:54:53.934271+0000'),
67 ('11207', 'ENCLB540GQH', '2014-02-11T04:54:54.151840+0000'),
68 ('11208', 'ENCLB267LXR', '2014-02-11T04:54:54.367250+0000'),
69 ('11209', 'ENCLB334AQY', '2014-02-11T04:54:54.659774+0000'),
70 ('11210', 'ENCLB267HUY', '2014-02-11T04:54:54.901232+0000'),
71 ('11286', 'ENCLB227WEO', '2013-12-31T00:56:50.365755+0000'),
72 ('11288', 'ENCLB764TBI', '2013-12-31T00:56:50.539923+0000'),
73 ('11289', 'ENCLB221REA', '2013-12-31T00:56:50.771930+0000'),
74 ('11565', 'ENCLB332ZZZ', '2013-09-13T13:31:03.112170-0800'),
75 ('11581', 'ENCLB794RXE', '2013-12-31T01:24:31.159562+0000'),
76 ('11582', 'ENCLB445LWQ', '2013-12-31T01:24:30.715684+0000'),
77 ('11584', 'ENCLB866FVU', '2013-12-31T01:24:30.539689+0000'),
78 ('11585', 'ENCLB415HFJ', '2013-12-31T01:24:30.323719+0000'),
79 ('11586', 'ENCLB170HBR', '2013-12-31T01:24:32.842478+0000'),
80 ('11587', 'ENCLB271DFX', '2013-12-31T00:56:49.784310+0000'),
81 ('11588', 'ENCLB224GWZ', '2013-12-31T00:56:50.002023+0000'),
82 ('11612', 'ENCLB370ZZZ', '2013-09-13T13:31:03.835164-0800'),
83 ('11612', 'ENCLB370ZZZ', '2013-09-13T13:31:03.835164-0800'),
84 ('11621', 'ENCLB282WJS', '2013-12-31T00:56:49.527454+0000'),
85 ('11622', 'ENCLB379BUZ', '2013-12-31T00:56:49.274381+0000'),
86 ('11638', 'ENCLB507FSU', '2015-03-12T23:49:04.901543+0000'),
87 ('11644', 'ENCLB341ZZZ', '2013-09-13T13:31:04.092318-0800'),
88 ('11653', 'ENCLB344ZZZ', '2013-09-13T13:31:04.212140-0800'),
89 ('11669', 'ENCLB321ZZZ', '2013-09-13T13:31:04.327003-0800'),
90 ('11670', 'ENCLB715BMJ', '2015-03-12T23:18:09.561375+0000'),
91 ('11682', 'ENCLB331ZZZ', '2013-09-13T13:31:04.445816-0800'),
92 ('11697', 'ENCLB314ZZZ', '2013-09-13T13:31:04.621147-0800'),
93 ('11718', 'ENCLB327ZZZ', '2013-09-13T13:31:04.713973-0800'),
94 ('11719', 'ENCLB330ZZZ', '2013-09-13T13:31:04.755910-0800'),
95 ('11719', 'ENCLB373ZZZ', '2013-09-13T13:31:03.237846-0800'),
96 ('11832', 'ENCLB318ZZZ', '2013-09-13T13:31:04.798657-0800'),
97 ('11847', 'ENCLB345ZZZ', '2013-09-13T13:31:04.842142-0800'),
98 ('11905', 'ENCLB320ZZZ', '2013-09-13T13:31:04.885807-0800'),
99 ('11906', 'ENCLB315ZZZ', '2013-09-13T13:31:04.927936-0800'),
100 ('11907', 'ENCLB313ZZZ', '2013-09-13T13:31:04.970793-0800'),
101 ('11923', 'ENCLB346ZZZ', '2013-09-13T13:31:05.014078-0800'),
102 ('11924', 'ENCLB343ZZZ', '2013-09-13T13:31:05.057237-0800'),
103 ('11926', 'ENCLB342ZZZ', '2013-09-13T13:31:05.098878-0800'),
104 ('11927', 'ENCLB351ZZZ', '2013-09-13T13:31:05.142104-0800'),
105 ('11942', 'ENCLB340ZZZ', '2013-09-13T13:31:05.185199-0800'),
106 ('11942', 'ENCLB374ZZZ', '2013-09-13T13:31:00.932762-0800'),
107 ('11956', 'ENCLB323ZZZ', '2013-09-13T13:31:05.229141-0800'),
108 ('11957', 'ENCLB319ZZZ', '2013-09-13T13:31:05.271096-0800'),
109 ('12096', 'ENCLB330KCB', '2013-12-31T01:24:29.929490+0000'),
110 ('12097', 'ENCLB308ZDI', '2013-12-31T01:24:30.117992+0000'),
111 ('12098', 'ENCLB849ZXB', '2013-12-31T01:24:30.951897+0000'),
112 ('12517', 'ENCLB482LEX', '2014-04-17T22:46:52.690510+0000'),
113 ('12518', 'ENCLB898RJN', '2014-04-17T22:46:52.789971+0000'),
114 ('13024', 'ENCLB386HBI', '2014-04-17T22:46:51.828778+0000'),
115 ('13025', 'ENCLB976CMA', '2014-04-17T22:46:51.909420+0000'),
116 ('13262', 'ENCLB164LQL', '2014-04-17T22:46:51.996269+0000'),
117 ('13263', 'ENCLB621DLJ', '2014-04-17T22:46:52.081511+0000'),
118 ('13274', 'ENCLB036MBQ', '2014-04-17T22:46:52.331729+0000'),
119 ('13275', 'ENCLB284CYK', '2014-04-17T22:46:52.424102+0000'),
120 ('13280', 'ENCLB187EEQ', '2014-04-17T22:46:56.606142+0000'),
121 ('13281', 'ENCLB146LAW', '2014-04-17T22:46:56.763676+0000'),
122 ('13282', 'ENCLB267CXI', '2014-04-17T22:46:57.686887+0000'),
123 ('13283', 'ENCLB198OUV', '2014-04-17T22:46:57.765163+0000'),
124 ('13284', 'ENCLB319PGU', '2014-04-17T22:46:57.859868+0000'),
125 ('13285', 'ENCLB391GZT', '2014-04-17T22:46:57.942156+0000'),
126 ('13286', 'ENCLB714NCU', '2014-04-17T22:46:58.029639+0000'),
127 ('13287', 'ENCLB868NQU', '2014-04-17T22:46:58.123540+0000'),
128 ('13288', 'ENCLB264YKE', '2014-04-17T22:46:58.206637+0000'),
129 ('13289', 'ENCLB206JYT', '2014-04-17T22:46:58.292642+0000'),
130 ('13290', 'ENCLB476CZO', '2014-04-17T22:46:58.374543+0000'),
131 ('13291', 'ENCLB402YMB', '2014-04-17T22:46:58.456242+0000'),
132 ('13292', 'ENCLB211FCW', '2014-04-17T22:46:56.889940+0000'),
133 ('13294', 'ENCLB283IJI', '2014-04-17T22:46:57.082795+0000'),
134 ('13295', 'ENCLB720ZUM', '2014-04-17T22:46:57.198472+0000'),
135 ('13296', 'ENCLB108EAP', '2014-04-17T22:46:57.341596+0000'),
136 ('13297', 'ENCLB882HPA', '2014-04-17T22:46:57.428995+0000'),
137 ('13298', 'ENCLB804XTY', '2014-04-17T22:46:57.507323+0000'),
138 ('13299', 'ENCLB242XIT', '2014-04-17T22:46:57.604855+0000'),
139 ('13300', 'ENCLB550GYC', '2014-04-17T22:46:52.512366+0000'),
140 ('13301', 'ENCLB576ZGP', '2014-04-17T22:46:52.601612+0000'),
141 ('13347', 'ENCLB928LID', '2014-04-17T22:46:52.162858+0000'),
142 ('13349', 'ENCLB532KHK', '2014-04-17T22:46:52.248810+0000'),
143 ('13413', 'ENCLB510UJB', '2014-12-16T00:45:13.360830+0000'),
144 ('13414', 'ENCLB414SJG', '2014-12-16T00:45:13.800356+0000'),
145 ('13415', 'ENCLB569DAO', '2014-12-16T00:45:14.213313+0000'),
146 ('13416', 'ENCLB193ILA', '2014-12-16T00:45:14.431853+0000'),
147 ('13417', 'ENCLB578MIX', '2014-12-16T00:45:14.860425+0000'),
148 ('13418', 'ENCLB322YDP', '2014-12-16T00:45:15.320136+0000'),
149 ('13419', 'ENCLB921XPI', '2014-12-16T00:45:16.561156+0000'),
150 ('13420', 'ENCLB133ICO', '2014-12-16T00:45:16.784349+0000'),
151 ('13421', 'ENCLB541QCS', '2014-12-16T00:45:17.049659+0000'),
152 ('13422', 'ENCLB711HMD', '2014-12-16T00:45:17.306141+0000'),
153 ('13423', 'ENCLB036AMX', '2014-12-16T00:45:17.587710+0000'),
154 ('13424', 'ENCLB641AYP', '2014-12-16T00:45:18.075095+0000'),
155 ('13425', 'ENCLB042QFS', '2014-12-16T00:45:18.620202+0000'),
156 ('13426', 'ENCLB507MOC', '2014-12-16T00:45:19.791431+0000'),
157 ('13427', 'ENCLB442ZCO', '2014-12-16T00:45:20.402307+0000'),
158 ('13428', 'ENCLB714KUY', '2014-12-16T00:45:20.848934+0000'),
159 ('13429', 'ENCLB243CVS', '2014-12-16T00:45:21.329370+0000'),
160 ('13430', 'ENCLB204EWE', '2014-12-16T00:45:22.235057+0000'),
161 ('13431', 'ENCLB751POF', '2014-12-16T00:45:23.092374+0000'),
162 ('13432', 'ENCLB729FQY', '2014-12-16T00:45:23.458123+0000'),
163 ('13433', 'ENCLB988OPM', '2014-12-16T00:45:23.707750+0000'),
164 ('13435', 'ENCLB981WTU', '2014-12-16T00:45:24.273572+0000'),
165 ('13436', 'ENCLB364NZB', '2014-12-16T00:45:25.243385+0000'),
166 ('13437', 'ENCLB461BIJ', '2014-12-16T00:45:25.696471+0000'),
167 ('13438', 'ENCLB580JUS', '2014-12-16T00:45:26.678862+0000'),
168 ('13439', 'ENCLB318YQB', '2014-12-16T00:45:27.109024+0000'),
169 ('13440', 'ENCLB407NSA', '2014-12-16T00:45:27.519366+0000'),
170 ('13619', 'ENCLB901PGF', '2014-04-17T22:46:51.257931+0000'),
171 ('13620', 'ENCLB392ZIG', '2014-04-17T22:46:51.468689+0000'),
172 ('13622', 'ENCLB426EUN', '2014-04-17T22:46:51.379932+0000'),
173 ('13623', 'ENCLB036TZY', '2014-04-17T22:46:51.581073+0000'),
174 ('13625', 'ENCLB331AUZ', '2014-04-17T22:46:52.874393+0000'),
175 ('13626', 'ENCLB327MTR', '2014-04-17T22:46:52.954204+0000'),
176 ('13627', 'ENCLB228BIT', '2014-04-17T22:46:53.033480+0000'),
177 ('13628', 'ENCLB641KNK', '2014-04-17T22:46:53.114120+0000'),
178 ('13629', 'ENCLB403JBC', '2014-04-17T22:46:53.192762+0000'),
179 ('13630', 'ENCLB804XKW', '2014-04-17T22:46:53.273136+0000'),
180 ('13631', 'ENCLB087SVF', '2014-04-17T22:46:53.371845+0000'),
181 ('13632', 'ENCLB747ZHK', '2014-04-17T22:46:53.457184+0000'),
182 ('13633', 'ENCLB710XHU', '2014-04-17T22:46:53.538836+0000'),
183 ('13634', 'ENCLB211OUD', '2014-04-17T22:46:53.615476+0000'),
184 ('13635', 'ENCLB222MSP', '2014-04-17T22:46:53.715943+0000'),
185 ('13636', 'ENCLB619TYA', '2014-04-17T22:46:53.884920+0000'),
186 ('13637', 'ENCLB350NUB', '2014-04-17T22:46:53.980565+0000'),
187 ('13638', 'ENCLB257OVB', '2014-04-17T22:46:54.073274+0000'),
188 ('13639', 'ENCLB218HBM', '2014-04-17T22:46:54.155566+0000'),
189 ('13640', 'ENCLB617JJG', '2014-04-17T22:46:54.244908+0000'),
190 ('13641', 'ENCLB876ZIU', '2014-04-17T22:46:54.340786+0000'),
191 ('13642', 'ENCLB552DLJ', '2014-04-17T22:46:54.430325+0000'),
192 ('13643', 'ENCLB509KSM', '2014-04-17T22:46:54.529638+0000'),
193 ('13644', 'ENCLB632SOL', '2014-04-17T22:46:54.617599+0000'),
194 ('13645', 'ENCLB678KFT', '2014-04-17T22:46:54.699948+0000'),
195 ('13646', 'ENCLB432EQY', '2014-04-17T22:46:54.778444+0000'),
196 ('13647', 'ENCLB546SWD', '2014-04-17T22:46:54.858448+0000'),
197 ('13648', 'ENCLB151CUN', '2014-04-17T22:46:54.937278+0000'),
198 ('13649', 'ENCLB340FFP', '2014-04-17T22:46:55.022324+0000'),
199 ('13650', 'ENCLB205HHN', '2014-04-17T22:46:55.098461+0000'),
200 ('13651', 'ENCLB452IVF', '2014-04-17T22:46:55.184097+0000'),
201 ('13652', 'ENCLB294BYK', '2014-04-17T22:46:55.262903+0000'),
202 ('13653', 'ENCLB078UJF', '2014-04-17T22:46:55.341750+0000'),
203 ('13654', 'ENCLB614VPZ', '2014-04-17T22:46:55.416400+0000'),
204 ('13655', 'ENCLB611KGC', '2014-04-17T22:46:55.540595+0000'),
205 ('13656', 'ENCLB462FVS', '2014-04-17T22:46:55.622867+0000'),
206 ('13657', 'ENCLB562SNL', '2014-04-17T22:46:55.701402+0000'),
207 ('13658', 'ENCLB147KNI', '2014-04-17T22:46:55.786033+0000'),
208 ('13659', 'ENCLB904FTO', '2014-04-17T22:46:55.881860+0000'),
209 ('13660', 'ENCLB857XKO', '2014-04-17T22:46:55.967510+0000'),
210 ('13661', 'ENCLB720FXC', '2014-04-17T22:46:56.045285+0000'),
211 ('13662', 'ENCLB632CVX', '2014-04-17T22:46:56.126475+0000'),
212 ('13663', 'ENCLB229ENW', '2014-04-17T22:46:56.202064+0000'),
213 ('13664', 'ENCLB912XSU', '2014-04-17T22:46:56.461112+0000'),
214 ('13665', 'ENCLB915IHV', '2014-04-17T22:46:51.664093+0000'),
215 ('13666', 'ENCLB204VYG', '2014-04-17T22:46:51.747073+0000'),
216 ('13711', 'ENCLB043ZZZ', '2013-09-13T13:31:21.704089-0800'),
217 ('13712', 'ENCLB044ZZZ', '2013-09-13T13:31:21.995955-0800'),
218 ('13713', 'ENCLB045ZZZ', '2013-09-13T13:31:21.121478-0800'),
219 ('13714', 'ENCLB046ZZZ', '2013-09-13T13:31:19.986238-0800'),
220 ('13715', 'ENCLB061ZZZ', '2013-09-13T13:31:26.233894-0800'),
221 ('13716', 'ENCLB062ZZZ', '2013-09-13T13:31:21.394322-0800'),
222 ('13717', 'ENCLB063ZZZ', '2013-09-13T13:31:22.543146-0800'),
223 ('13718', 'ENCLB064ZZZ', '2013-09-13T13:31:26.615177-0800'),
224 ('14485', 'ENCLB463KOX', '2014-07-30T22:13:29.658606+0000'),
225 ('14486', 'ENCLB941VYE', '2014-07-30T22:13:30.865419+0000'),
226 ('14487', 'ENCLB237OAE', '2014-07-30T22:13:32.006665+0000'),
227 ('14488', 'ENCLB171NYD', '2014-07-30T22:13:32.876751+0000'),
228 ('14495', 'ENCLB719BQO', '2014-07-30T22:13:34.234738+0000'),
229 ('14499', 'ENCLB356IIP', '2014-07-30T22:13:35.356726+0000'),
230 ('14501', 'ENCLB304LFK', '2014-07-30T22:13:36.682522+0000'),
231 ('14626', 'ENCLB766UOB', '2014-07-30T22:13:37.751613+0000'),
232 ('14627', 'ENCLB238LIR', '2014-07-30T22:13:38.488612+0000'),
233 ('14628', 'ENCLB652HKH', '2014-07-30T22:13:39.079002+0000'),
234 ('14629', 'ENCLB181TCJ', '2014-07-30T22:13:39.612566+0000'),
235 ('14630', 'ENCLB669AEL', '2014-07-30T22:13:40.373455+0000'),
236 ('14631', 'ENCLB765HDK', '2014-07-30T22:13:41.017277+0000'),
237 ('14632', 'ENCLB348BMH', '2014-07-30T22:13:41.597441+0000'),
238 ('14633', 'ENCLB791CRT', '2014-07-30T22:13:42.145408+0000'),
239 ('14634', 'ENCLB096HAH', '2014-07-30T22:13:42.871555+0000'),
240 ('14635', 'ENCLB005HHX', '2014-07-30T22:13:43.673544+0000'),
241 ('14636', 'ENCLB185MNU', '2014-07-30T22:13:44.242558+0000'),
242 ('14653', 'ENCLB917PKP', '2014-07-22T21:16:09.466969+0000'),
243 ('14654', 'ENCLB026BHP', '2014-07-22T21:16:36.206892+0000'),
244 ('14655', 'ENCLB449LBZ', '2014-07-22T21:17:23.464962+0000'),
245 ('14656', 'ENCLB905LVV', '2014-07-22T21:18:02.970100+0000'),
246 ('15007', 'ENCLB835LVO', '2014-10-23T21:25:29.431984+0000'),
247 ('15008', 'ENCLB471QMM', '2014-10-23T21:25:30.115849+0000'),
248 ('15009', 'ENCLB659UFY', '2014-10-23T21:25:30.756915+0000'),
249 ('15010', 'ENCLB426JKF', '2014-10-23T21:25:31.349525+0000'),
250 ('15011', 'ENCLB454ZUS', '2014-10-23T21:25:32.065385+0000'),
251 ('15012', 'ENCLB061TDP', '2014-10-23T21:25:32.733245+0000'),
252 ('15013', 'ENCLB331VAA', '2014-10-23T21:25:33.732239+0000'),
253 ('15014', 'ENCLB761PCA', '2014-10-23T21:25:34.879860+0000'),
254 ('15015', 'ENCLB601XLL', '2014-10-23T21:25:35.898934+0000'),
255 ('15016', 'ENCLB347FRI', '2014-10-23T21:25:36.765768+0000'),
256 ('15017', 'ENCLB055KYV', '2014-10-23T21:25:37.604795+0000'),
257 ('15018', 'ENCLB357KYA', '2014-10-23T21:25:38.564710+0000'),
258 ('15019', 'ENCLB495FUZ', '2014-10-23T21:25:39.571864+0000'),
259 ('15020', 'ENCLB979DZW', '2014-10-23T21:25:40.266492+0000'),
260 ('15021', 'ENCLB162EJJ', '2014-10-23T21:25:41.173920+0000'),
261 ('15022', 'ENCLB627LDZ', '2014-10-23T21:25:42.094283+0000'),
262 ('15072', 'ENCLB336GOL', '2014-12-10T23:00:17.177956+0000'),
263 ('15073', 'ENCLB964APA', '2014-12-10T23:00:17.550508+0000'),
264 ('15074', 'ENCLB000EUQ', '2014-12-10T23:00:17.847597+0000'),
265 ('15075', 'ENCLB597GRF', '2014-12-10T23:00:18.331925+0000'),
266 ('15076', 'ENCLB989QNS', '2014-12-10T23:00:18.850689+0000'),
267 ('15077', 'ENCLB567WFL', '2014-12-10T23:00:19.145366+0000'),
268 ('15078', 'ENCLB254AMJ', '2014-12-10T23:00:19.420436+0000'),
269 ('15079', 'ENCLB015WCJ', '2014-12-10T23:00:19.713321+0000'),
270 ('15080', 'ENCLB200EFP', '2014-12-10T23:00:20.013418+0000'),
271 ('15081', 'ENCLB278MMD', '2014-12-10T23:00:20.516203+0000'),
272 ('15082', 'ENCLB819PZM', '2014-12-10T23:00:21.265192+0000'),
273 ('15083', 'ENCLB220DVX', '2014-12-10T23:00:21.537679+0000'),
274 ('15084', 'ENCLB906TKN', '2014-12-10T23:00:21.824807+0000'),
275 ('15085', 'ENCLB949YQN', '2014-12-10T23:00:22.369090+0000'),
276 ('15086', 'ENCLB584VFZ', '2014-12-10T23:00:23.080355+0000'),
277 ('15087', 'ENCLB931ORG', '2014-12-10T23:00:23.626841+0000'),
278 ('15088', 'ENCLB409LKR', '2014-12-10T23:00:24.173237+0000'),
279 ('15089', 'ENCLB595PNG', '2014-12-10T23:00:24.554339+0000'),
280 ('15090', 'ENCLB156EMG', '2014-12-10T23:00:25.382334+0000'),
281 ('15091', 'ENCLB030NEC', '2014-12-10T23:00:26.743561+0000'),
282 ('15092', 'ENCLB377PCX', '2014-12-10T23:00:28.034636+0000'),
283 ('15093', 'ENCLB214UZM', '2014-12-10T23:00:28.526626+0000'),
284 ('15094', 'ENCLB813BQB', '2014-12-10T23:00:29.029220+0000'),
285 ('15095', 'ENCLB949WIO', '2014-12-10T23:00:29.343030+0000'),
286 ('15241', 'ENCLB604HVJ', '2014-12-15T23:31:51.819207+0000'),
287 ('15242', 'ENCLB357UPR', '2014-12-16T01:03:11.301778+0000'),
288 ('15243', 'ENCLB521CXU', '2014-12-16T01:03:12.409916+0000'),
289 ('15244', 'ENCLB969JPS', '2014-12-16T01:03:12.638218+0000'),
290 ('15245', 'ENCLB893OOW', '2014-12-16T01:03:12.851385+0000'),
291 ('15246', 'ENCLB730HDZ', '2014-12-16T01:03:13.532201+0000'),
292 ('15247', 'ENCLB229LFR', '2014-12-16T01:03:13.888442+0000'),
293 ('15248', 'ENCLB700NFV', '2014-12-16T01:03:14.123376+0000'),
294 ('15256', 'ENCLB253LOZ', '2014-12-16T01:15:42.800855+0000'),
295 ('15257', 'ENCLB857GUO', '2014-12-16T01:15:43.062548+0000'),
296 ('15258', 'ENCLB891HIS', '2014-12-16T01:15:44.686534+0000'),
297 ('15259', 'ENCLB587ZYP', '2014-12-16T01:15:45.407813+0000'),
298 ('15260', 'ENCLB183ZSO', '2014-12-16T01:15:46.051548+0000'),
299 ('15261', 'ENCLB809LQF', '2014-12-16T01:15:46.336850+0000'),
300 ('15262', 'ENCLB112DAD', '2014-12-16T01:15:47.111994+0000'),
301 ('15263', 'ENCLB417MEI', '2014-12-16T01:15:47.354094+0000'),
302 ('15264', 'ENCLB035MJZ', '2014-12-16T01:15:47.581360+0000'),
303 ('15265', 'ENCLB663WPK', '2014-12-16T01:15:47.823408+0000'),
304 ('15266', 'ENCLB640QPM', '2014-12-16T01:15:48.094692+0000'),
305 ('15267', 'ENCLB708TZF', '2014-12-16T01:15:48.518860+0000'),
306 ('15268', 'ENCLB678FAD', '2014-12-16T01:15:49.637634+0000'),
307 ('15269', 'ENCLB284YTS', '2014-12-16T01:15:50.317441+0000'),
308 ('15270', 'ENCLB108LLJ', '2014-12-16T01:15:50.793306+0000'),
309 ('15271', 'ENCLB518MNF', '2014-12-16T01:15:51.255098+0000'),
310 ('15288', 'ENCLB435TVJ', '2014-12-16T01:15:53.184310+0000'),
311 ('15289', 'ENCLB337IRK', '2014-12-16T01:15:54.829508+0000'),
312 ('15290', 'ENCLB863GTU', '2014-12-16T01:15:56.220924+0000'),
313 ('15291', 'ENCLB033OYZ', '2014-12-16T01:15:56.821935+0000'),
314 ('15292', 'ENCLB577KCS', '2014-12-16T01:15:57.362521+0000'),
315 ('15293', 'ENCLB950QWJ', '2014-12-16T01:15:58.109787+0000'),
316 ('15294', 'ENCLB219UWV', '2014-12-16T01:15:58.782565+0000'),
317 ('15295', 'ENCLB196QXY', '2014-12-16T01:15:59.455275+0000'),
318 ('15296', 'ENCLB430RUN', '2014-12-16T01:16:00.122073+0000'),
319 ('15297', 'ENCLB384GBY', '2014-12-16T01:16:00.929045+0000'),
320 ('15298', 'ENCLB030QYZ', '2014-12-16T01:16:01.373251+0000'),
321 ('15299', 'ENCLB721WMG', '2014-12-16T01:16:01.597127+0000'),
322 ('15300', 'ENCLB359XUW', '2014-12-16T01:16:01.825260+0000'),
323 ('15301', 'ENCLB807MQE', '2014-12-16T01:16:02.132204+0000'),
324 ('15302', 'ENCLB462UWC', '2014-12-16T01:16:03.048372+0000'),
325 ('15303', 'ENCLB296VEF', '2014-12-16T01:16:03.815641+0000'),
326 ('15475', 'ENCLB266LCY', '2015-03-27T22:01:32.864613+0000'),
327 ('15476', 'ENCLB055JUC', '2015-03-27T22:01:33.316038+0000'),
328 ('15477', 'ENCLB080NNG', '2015-03-27T22:01:33.809928+0000'),
329 ('15478', 'ENCLB180OTB', '2015-03-27T22:01:34.281900+0000'),
330 ('15479', 'ENCLB274VUA', '2015-03-27T22:01:34.760956+0000'),
331 ('15480', 'ENCLB441AFS', '2015-03-27T22:01:35.242213+0000'),
332 ('15481', 'ENCLB790ZKD', '2015-03-27T22:01:35.693423+0000'),
333 ('15482', 'ENCLB319NLX', '2015-03-27T22:01:36.114223+0000'),
334 ('15483', 'ENCLB074REG', '2015-03-27T22:01:36.679913+0000'),
335 ('15484', 'ENCLB415KPR', '2015-03-27T22:01:37.266549+0000'),
336 ('15485', 'ENCLB658ICO', '2015-03-27T22:01:37.835601+0000'),
337 ('15486', 'ENCLB741KQB', '2015-03-27T22:01:38.396352+0000'),
338 ('15487', 'ENCLB810TRL', '2015-03-27T22:01:38.910449+0000'),
339 ('15488', 'ENCLB544VIE', '2015-03-27T22:01:39.534590+0000'),
340 ('15489', 'ENCLB370ZFK', '2015-03-27T22:01:40.115768+0000'),
341 ('15490', 'ENCLB273BPC', '2015-03-27T22:01:40.746450+0000'),
342 ('15491', 'ENCLB847UDV', '2015-03-27T22:01:41.366532+0000'),
343 ('15492', 'ENCLB704CYQ', '2015-03-27T22:01:41.934480+0000'),
344 ('15493', 'ENCLB318WHF', '2015-03-27T22:01:42.583021+0000'),
345 ('15494', 'ENCLB590UZK', '2015-03-27T22:01:43.220918+0000'),
346 ('15495', 'ENCLB260QNG', '2015-03-27T22:01:43.823840+0000'),
347 ('15496', 'ENCLB817LXB', '2015-03-27T22:01:44.356874+0000'),
348 ('15497', 'ENCLB169SNA', '2015-03-27T22:01:44.903888+0000'),
349 ('15498', 'ENCLB459OYG', '2015-03-27T22:01:45.457150+0000'),
350 ('15499', 'ENCLB217DSV', '2015-03-27T22:01:46.051760+0000'),
351 ('15500', 'ENCLB159SLV', '2015-03-27T22:01:46.609807+0000'),
352 ('15501', 'ENCLB022VFG', '2015-03-27T22:01:47.188586+0000'),
353 ('15502', 'ENCLB416HZP', '2015-03-27T22:01:47.742894+0000'),
354 ('15503', 'ENCLB556YSG', '2015-03-27T22:01:48.360245+0000'),
355 ('15504', 'ENCLB803HJK', '2015-03-27T22:01:48.918921+0000'),
356 ('SL2970', 'ENCLB871LCB', '2013-12-31T01:24:29.617351+0000'),
357 ('SL2971', 'ENCLB503AOQ', '2013-12-31T01:24:29.290708+0000'),
359 encode = AccessionAgency.objects.get(name="ENCODE3")
360 for jumpgate_id, accession, created in data:
365 }.get(jumpgate_id, jumpgate_id)
366 jumpgate = Library.objects.get(pk=jumpgate_id)
367 date_created = datetime.strptime(created, '%Y-%m-%dT%H:%M:%S.%f%z')
368 o = LibraryAccession(agency=encode,
371 created=date_created,)
376 print('loading encode3 accessions')
377 load_encode3_accessions()
379 if __name__ == '__main__':
381 os.environ.setdefault(
382 "DJANGO_SETTINGS_MODULE",
383 "htsworkflow.settings.{}".format(socket.gethostname()))