-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathdata.txt
376 lines (302 loc) · 32.4 KB
/
data.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
-- Inserting data into GENES table
select * from genes;
-- Modify the "GENE_NAME" column in the "genes" table
ALTER TABLE genes
MODIFY GENE_NAME VARCHAR2(500);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (6563, 'Homo sapiens Kidd blood group protein', 'solute carrier family 14 member 1; previously known as JK, HUT11 of the urea-transporter gene family; contains two mutations which may lead to Kidd blood group JK null', 'genomic DNA', 1, 1);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (8675, 'Homo sapiens syntaxin 16 isoform C-like protein', 'syntaxin 16 isoform C-like protein; aminopeptidase-like 1-like protein', 'mRNA', 2, 2);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (169026, 'Homo sapiens isolate Belqis-S6 proton-coupled zinc antiporter', 'Sequencing Technology :: Sanger dideoxy sequencing', 'genomic DNA', 3, 3);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (6934, 'Homo sapiens isolate Belqis-B6', 'Sequencing Technology :: Sanger dideoxy sequencing', 'genomic DNA', 4, 4);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (23768, 'Homo sapiens fibronectin leucine rich transmembrane protein 2', 'fibronectin leucine rich transmembrane protein 2', 'transcribed RNA', 5, 5);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (74386, 'recQ-mediated genome instability protein 1 isoform X1', 'Recq-mediated genome instability protein 1, C-terminal OB-fold; pfam16099', 'Protien', 6, 6);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (74528, 'mitochondrial genome maintenance exonuclease 1', 'This variant (2) differs in the 5'' UTR compared to variant 1. All four variants encode the same protein.', 'Mitochondrion', 7, 7);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (7256398, 'ATP synthase F0 subunit 8', 'Method: conceptual translation', 'Mitochondrion', 8, 8);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (111814982, 'serine/threonine-protein kinase/endoribonuclease', 'Protein Kinases, catalytic domain', 'Protien', 9, 9);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (101561532, 'LOW QUALITY PROTEIN: T-complex protein 1 subunit gamma-like', 'The sequence of the model RefSeq protein was modified relative to its source genomic sequence to represent the inferred CDS: substituted 1 base at 1 genomic stop codon', 'Protien', 10, 10);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('WP_194293132.1', 'Klebsiella pneumoniae ABHI1 blaAAK gene for class A beta-lactamase', 'This record has been chosen as a reference for antimicrobial resistance.', 'genomic DNA', 11, 11);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('AAX29564.1', 'Synthetic construct Homo sapiens clone FLH029330.01L polymerase', 'derived from MGC template', 'RNA', 12, 12);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('Contig45496', 'Ovis aries unplaced genomic scaffold Contig45496, whole genome shotgun sequence', 'breed: mixed', 'genomic DNA', 13, 13);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('12SrRNA', 'Physeter catodon mitochondrion', NULL, 'genomic DNA', 14, 14);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('AAC48452.1', 'Physeter catodon mitochondrion cytochrome b gene', NULL, 'genomic DNA', 15, 15);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('AAV54194.1', 'Triticum aestivum chloroplast acetyl-CoA carboxylase genes, partial cds; nuclear genes for chloroplast products', 'involved in fatty acid biosynthesis; ACCase', 'genomic DNA', 16, 16);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('QKV50459.1', 'Loxodonta africana clone Loxodonta_africana_type_3_BR cytochrome b', 'Sequencing Technology :: Sanger dideoxy sequencing', 'genomic DNA', 17, 17);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (3630, 'Homo sapiens insulin (INS), transcript variant 1, mRNA', 'proinsulin; preproinsulin', 'mRNA', 18, 18);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (55521, 'Homo sapiens tripartite motif containing 36', 'isoform 2 is encoded by transcript variant 2', 'mRNA', 19, 19);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('MG100', 'Kosakonia cowanii strain MG100 16S ribosomal RNA gene', 'Sequences were screened for chimeras by the submitter using DECIPHER''s Find Chimeras 2.26.0.', 'genomic DNA', 20, 20);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('z1_z-f', 'Helicobacter pylori z1_z-f gene for 16S rRNA', NULL, 'genomic RNA', 21, 21);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('Aarely-1e', 'Neurospora crassa strain Aarely-1e maranhar gene', NULL, 'genomic DNA', 22, 22);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (116408221, 'Xenopus tropicalis strain Nigerian unplaced genomic scaffold', 'Derived by automated computational analysis using gene prediction method: Gnomon.', 'genomic DNA', 23, 23);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('CAG46711.1', 'Homo sapiens full open reading frame cDNA clone RZPDo834E0633D for gene HBB, hemoglobin, beta', NULL, 'mRNA', 24, 24);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('UJI58659.1', 'Borreliella garinii subsp. bavariensis strain Hs-55 Hbb (hbb) gene', 'Sequencing Technology :: Sanger dideoxy sequencing', 'genomic DNA', 25, 25);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('Hbb', 'Homo sapiens isolate NA27660 beta-globin (Hbb) gene, promoter region and 5'' UTR', 'Sequencing Technology :: Sanger dideoxy sequencing', 'genomic DNA', 26, 26);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (59272, 'Homo sapiens isolate Slemani-8-S-E2R angiotensin-converting enzyme 2', 'angiotensin-converting enzyme 2', 'genomic DNA', 27, 27);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (38126466, 'Aspergillus thermomutatus mitochondrion', NULL, 'mRNA', 28, 28);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES ('HUMHBC3078', 'Human pancreatic islet Homo sapiens cDNA similar to mitochondrion', 'mRNA was prepared from normal adult human islets', 'mRNA', 29, 29);
INSERT INTO GENES (GENE_ID, GENE_NAME, COMMENTS, GENE_TYPE, ORGANISM_ID, REF_ID)
VALUES (11124009, 'Human pancreatic islet Homo sapiens cDNA clone', 'mRNA was prepared from normal adult human islets.', 'mRNA', 30, 30);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (1, 'Homo sapiens', 9606, 6563);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (2, 'Homo sapiens', 9606, 8675);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (3, 'Homo sapiens', 9606, 169026);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (4, 'Homo sapiens', 9606, 6934);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (5, 'Homo sapiens', 9606, 23768);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (6, 'Mus musculus', 10090, 74386);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (7, 'Mus musculus', 10090, 74528);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (8, 'Nothobranchius furzeri', 105023, 7256398);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (9, 'Octodon degus', 10160, 111814982);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (10, 'Octodon degus', 10160, 101561532);
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (11, 'Klebsiella pneumoniae', 573, 'WP_194293132.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (12, 'synthetic construct', 32630, 'AAX29564.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (13, 'Ovis aries', 9940, 'Contig45496');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (14, 'Physeter catodon', 9755, '12SrRNA');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (15, 'Physeter catodon', 9755, 'AAC48452.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (16, 'Triticum aestivum', 4565, 'AAV54194.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (17, 'Loxodonta africana', 9785, 'QKV50459.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (18, 'Homo sapiens', 9606, '3630');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (19, 'Homo sapiens', 9606, '55521');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (20, 'Kosakonia cowanii', 208223, 'MG100');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (21, 'Helicobacter pylori', 210, 'z1_z-f');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (22, 'Neurospora crassa', 5141, 'Aarely-1e');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (23, 'Xenopus tropicalis', 8364, '116408221');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (24, 'Homo sapiens', 9606, 'CAG46711.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (25, 'Borreliella bavariensis', 664662, 'UJI58659.1');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (26, 'Homo sapiens', 9606, 'Hbb');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (27, 'Homo sapiens', 9606, '59272');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (28, 'Aspergillus thermomutatus', 41047, '38126466');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (29, 'Homo sapiens', 9606, 'HUMHBC3078');
INSERT INTO ORGANISMS (ORGANISM_ID, ORGANISM_NAME, TAXONOMY_ID, GENE_ID) VALUES (30, 'Homo sapiens', 9606, '11124009');
select * from ORGANISMS;
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('KJ946236.1', 6563, 'ATGGAGGACAGCCCCACTATGGTTAGAGTGGACAGCCCCACTATGGTTAGGGGTGAAAACCAGGTTTCGC
CATGTCAAGGGAGAAGGTGCTTCCCCAAAGCTCTTGGCTATGTCACCGGTGACATGAAAAAACTTGCCAA
CCAGCTTAAAGNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNACAAACCCGTGGTGCTCCAGTTCATTGAC
TGGATTCTCCGGGGCATATCCCAAGTGGTGTTCGTCAACGACCCCGTCAGTGGAATCCTGATTCTGGTAG
GACTTCTTGTTCAGAACCCCTGGTGGGCTCTCACTGGCTGGCTGGGAACAGTGGTCTCCACTCTGATGGC
CCTCTTGCTCAGCCAGGACAG', 441);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('DQ268529.1', '8675', 'TTATATACTAACTACATAATGACCTGTTCAAACCAGACTCTATTTAATGAACTGTGAATTTACACAGAGG
CCATTTTAAATGGGTCACCCCATTTAGGATTAGTGGATCTCAAATTATTAACCAAACATCACTCCATTTC
AAAGTAAAATATTACGCCACCAGCGATTTGATTTATTGGCTCTTCCATTGCCACTGAGCAATGCCCAGGA
AGCAGGCACATTGCCAAGGACTGGGGGCATCTTGACTAGGAAGCTCCTCGTTTGTGTGAGCGTGGGTCAG
ACCGCCAAAGTAGGACTTCATCGTTTACCTACCTATTATCAATATGGTGCTTGAATATATTCCTATAACT
GTAGAACAGTGTGGAAAGTGATGGTAACTTTGAAGTTGTTCATGTTTTATTGGCTTTGTTTTAATTGACA
CTAGTAGAGTTTTATGGTCTTTGTGTAATTTTATGGCTTTTCATTGTTTTTGCTCTCTAAAAGTTTAGAG
ATATGACTCATTAATGTGCTGTTATTGGACAGTCACACAAATGTCTCTCTAGAGTGACTTAAGTGTTACA
GAATTAACTCATCAGAGATGAGTGTCAACAGCTCATGGCTAGTGTCAA', 608);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('OR965958.1', '169026', 'GGAGTCAGAGCAGTCGCCCATGCGTGTGCAATCAGTGCTAATCTCCCTGTGCTTCTTTATCAACAGCAGC
CAGCCGGGACAGCCAAGTGGTTCGGAGAGAAATTGCTAAAGCCCTTAGCAAAAGCTTTACGATGCACTCA
CTCACCATTCAGATGGAATCTCCAGTTGACCAGGACCCCGACTGCCTTTTCTGTGAAGACCCCTGTGACT
AGCTCAGTCACACCGTCAGT', 230);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('OR965952.1', '6934', 'TCATAGGGGTCTGGCTTGGAAAGTGTATTGCTATGTCCAGTTTACACATAAGGATGTGCAAATCCAGCAG
GTTAGCTGAGCTGCCCAGGAATATCCAGGCAAGAATGACCATATTCTGATAATTACTCAGGCCTCTGCCT
CATCTCCGCTGCCCCCCCGCCCCCTGACTCTCTTCTGAGTGCCAGATTCAGCCTCCATTTGAATGCCAAA
TAGACAGGAAATTAGCATGCCCAGAATCCACGTCTTTAGTGCACTCTCTCCCCAGCTCCAAA', 272);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('NR_144386.2', '23768', 'AGTTGTACGTTCGAAACCTGTCGCCGTCACTTGCGCGTTTGGCATTATCCATTGTCACCGCGGAGGAACG
AGCGCTCGAGATATCATCAGTGCCCGCAAATCTCCGCGCCAAGGCGCTGAGCTACTCCTTTCCGAGGTGC
GCCTCTGGTCCTCCGTCCCTGGTGCCCAGCAGCGGCGAGGCGGCATCTCCGCTCCCGCCGCCGTGTCCAC
CGAGCCCTGGGATCAGGGTGGCAGTTCTCAACGATGGGCAGGAGGGACCTCGGCGGCGACCCCTAAAACA
ATACCATGCCCCGGGATCCCCGCTGCTGCCGCGCCAGCGTCTTCCCTTTCCACCTCCCTGACCCTGTCGG
ATTCGGATGAGCCCATTGCAAGGAGAAGACGCAGCCGTCAGTTTCAGAAGCTATCTCCTGAGCAGTGTGT
AATTCTCTCCTGGCTGTTTGATGGTAATGGGAGCTGTACATGTATCTGGAGAGAGGAGAACCAGCCTGGG
GACTCAAGATATATTAAAGACTATGCTCATGGACATCAATTCTTTCCTGTCCTTTAGGGCAGTATTCAGG
CCACACGGTTCAATAACGGGAAAGAATGTCGTCACATGATTGCATCATGTTCTTCAAAATGAAATCTATT
GAACAGTATAAACAACAAAGAACATCATTTGTCAGAATGACCTGGGGGAAATAGTCCAGTGAAACTAAGC
AAAGGGAACTTTATACCGTGAGGGAAAATCAATGGATTGTAACAGAACCCTGCAAGAAGAGACATAGCTT
TCAAGTTCCAGAGACCTAGAGGTGACTGAGAAGCAGGATGTACCAGAAACTGGGCTTCTTGTTCTACTTA
TCTAGCGCCCTTTTCACAGTGTTGTATATGTAAATAAATAATAAAGCAGTGTGATTTTTAA', 901);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('XP_036014091.1', '74386', 'MSVASAVLRVETWLLATWHVKVPPMWLEACVNWIQEENNNATLSQAQINKQVLEQWLLTDLRDLEHPLLP
DDILELPKGELNGFYALQINSLVDVSQPAYSQIQKLRGKNTTNDLVSAETQSTPKPWEVRPSRMLMLQLT
DGVTHIQGMEYQSIPALHSGLPPGTKILVRGCILFRLGVLLLKPENVKVLGGEVDGLSEENAQEKVLARL
IGELDPTVPVIPNNSIHNVPKVSGGLDAVLGPSDEELLASLDESEESAANNDVAMERSCFSTGTSSNTTP
TNPSGFEPGCNISSRPKEKPPNQPTHFTDGEFDDFSLEEALLLEETVQKEQMETKASQPLTLKENTGKCM
EIFSHKPSSLNHTALIHKQGNSNFDEKTSEQMIHEDKFFDCASTRNHHKRFSAHDFTNDSKISEVDDAAQ
QTLSSSNVHCLRNKILNRKLDLSEKSSQISKENGHPFQACSSRSFENNTYLSIGMDLHSPPFIYLSVLMA
RKPKEVTTVTVKAFIVTLTGNLSSSGGFWGVTAKVSDGTAYLDVDFIDEILTSMIGYSVPEMKQLRKDPL
KYKTFLEGLQKCQRDLIDLCCLMTISYDPSSCKGVVLELQDVGMEHVENLKKRLNK', 616);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('NP_083260.1', '74528', 'MKLPLTFCRLLSRLNRFSVKASPPVSFSTFSYLCSQKKKNSYEAVDQAKYSRLVRSVLSRGPAQTPESLF
KEDDVLYGPVSKHKAAEPEPQARVPQHCFPIFNEERTGKPHTDASSSPLKIPLQRNSIPSVTRILQQTMP
PEQSFFLERWKERMVLELGEDGFAEYTSNVFLQGKQFHKALESILSPQENLTGGEEHPQCGYIESIQHIL
TEISGVQALESAVQHEALKYVGLLDCVAEYRGKLCVIDWKTSEKPKPLIRNTYDNPLQVVAYMGAVNHDA
HYSFQVQCGLIVVAYKDGSPAHPHFMDEELCSKYWAKWLLRLEEYTEKQKNLSAPEPA', 338);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('YP_002456260.1', '7256398', 'MPQLNPNPWFMIMTFAWLLFLIVIPPKVLAHTTPNNALPQKVVCSRTESWVWPWY', 55);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('XP_023564589', '111814982', 'MLSTLPQARPSALQVLAHPLFWSTAKQLQFFQDVSDWLEKESEQGALVRALEAGGDKVVRDNWHQHISMP
LQTDLRKFRSYRGTSVRDLLRAMRNKKHHYRELPATVRRALGPMPDSFVGYFTSRFPRLLLHTHRTMRSC
ASEGLFSSYYSPASKAMDLCQAARPVAKDGPL', 172);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('XP_012368891.2', '101561532', 'MMKMLLDPMGGIVMTNDGNAILREIQVQHPAAKSMIEISRTQDEEVGDGTTSVIILAGEMLSVAEHFLEQ
QMHPTVVISAYRKALDDVISTLKKISTPVDINNCDMMLNIINSSITTKVISRWSSLACNIALDAVKTVQL
EENGRKEIDIKKYAKVEKIPGGIIEDSCVLRGVMINKDVTHSRMRRHIKNPRITLLDSSLEYKKGESQTD
IEITXEEDFARVLQMEEEYIQQLCEDIIQLKPDVVITEKGISDLAQHYLLWANITAIRRVRKTDNNRIAR
ACGARIVSRPEELREDDVGTGAGLLEIKKIGDEYFTFITECKDPKACTILLRGANKEILSEVERNLQDAM
QVCHNVLLDPQLVPGGGASEMAVAHALTEKSKAMTGVEQWPYRAVAQALEVIPRTLIQNCGASTIRLLTS
LRAKHTQEGCETWDVNGETGALVDMKELGIWEPLAVKLQTYKTAVETAVLLLRIDDIVSGHKKKGDDQSR
QGGAPDAGQE', 500);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('NG_070893.1', 'WP_194293132.1', 'ATGCGTTATATTCGCCTGTGTATTATCTCCCTGTTCGCCACCCTGCCGCTGGCGGTACACGCCAGCCCGC
AGCCGCTTCAGCAAATTACACTACGCGAAAGCCAGCTGTCGGGCCGCGTCGGCACGATCGAAATGGATCT
GGCCAGCGGCCGCACGCTCACCGCCTGGCGCGCCGATCAACGCTTTCCCATCATGCGCACCTTTACAGTC
GTGCTCTGCGGCGCAGTGCTGGCGCGGGTGGATGCCGGTGACGAACAGCTGGAGCGAAAGATCCACTATC
GCCAGCAGGATCTGGTGGACTACTCGCCGGTCAGCGAAAAACACCTTGCCGACGGCATGCCGGTCGGCGA
ACTCTGCGCCGCCGCCATTACCATCAGCGATACCAGCGCCGCCAATCTGCTGCTGGCCACCGTCGGCGGC
CCCGCAGGATTCACTGCCTTTTTGCGCCAGATCGGCGACAACGTCACCCGCCTTCACCGCTGGGAAACGG
AACTGCATGCGGCGCTTCCCGGCGACGCCCGCGACACCACTACCCCGGCCAGCATGGCCGCGACCCTGCG
CAAGCTGCTCACCAGCCAGCGTCTCAGCGCCCGTTCGCAACGGCAGCTGCTGCAGTGGATGGTGGACGAT
CGGGTCGCCGGACCGTTGCTCCGCTCCGTGCTGCCGGCGGGCTGGTTTATCGCCGACAAGACCGGAGCTG
GCGAGCGGGGTGCGCGCGGCATTGTCGCCCTGCTTGGCCCGAATCACAAAGCAGAGCGCATTGTGGTCAT
TTATCTGCGGGATACGCCGGCGAGCATGGCCGAGCGAAATCAGCAAATCGCCGGGATCGGCGCGGCGCTG
CTCGAGCACTGGCAACAATGA', 861);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('AY892647.1', 'AAX29564.1', 'ATGATCATCCCTGTACGCTGCTTCACTTGTGGCAAGATCGTCGGCAACAAGTGGGAGGCTTACCTGGGGC
TGCTGCAGGCCGAGTACACCGAGGGGGACGCGCTGGATGCCCTGGGCCTGAAGCGCTACTGCTGCCGCCG
GATGCTGCTGGCCCACGTGGACCTGATCGAGAAGCTGCTCAATTATGCACCCCTGGAGAAGTTG', 204);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('GL339607.1', 'Contig45496', 'NNNNNNNNNNNNNNNNNNNNNNNCCATCCCTCTGGGTCATCCCAGTGCACCAGCCCTGTCTCATGCATCG
AACCTGGACTTGCGATCTGTTTCATATATGATAATATACATGTTTCAATGCTGACAGAATAGCGATGACT
GTTTAAGCAGTTGTTTTATTCACACCAGGAGCCAGGGCCCCAGCAACTGATGAAGCTCCTCCAGGCCTCC
TGATG', 215);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('U13096.1', '12SrRNA', 'CCGTAAACCCAGGTAGTCATAAAACAAGACTATTCGCCAGAGTACTACTAGCAACAGCCTAAAACTCAAA
GGACTTGGCGGTGCTTCATACCCCCCTAGAGGAGCCTGTTCTATAACCGATAAACCCCGATCAACCTCAC
CAACCCTTGCTACTTCAGTCTATATACCGCCATCTTCAGCAAACCCTAAAAAGGAATGAAAGTAAGCATA
ACTATCCTACGTAAAAACGTTAGGTCAAGGTGTAACCCATGGGATGGGAAGAAATGGGCTACATTTTCTA
CACCATAGAACACCCTATACCCCACGAAAGTTTTTATGAAACCTAAAAACCAAAGGAGGATTTAGCAGTA
AATTAAGAACAGAGTGCTTAATTGAATAAGGCCA', 384);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('U13142.1', 'AAC48452.1', 'TTATTCAACTACAAGAACACTAATGACCAACATCCGAAAATCACACCCATTAATAAAAATCATTAACAAT
GCATTCATCGACCTCCCTACCCCATCAAACATTTCCTCATGATGAAACTTCGGCTCCCTACTTGGACTCT
GCCTGATCATACAAATCCTAACAGGCCTATTCCTAGCAATACACTACACACCAGACACAACAACCGCTTT
CTCATCAATCACACACATTTGCCGAGACGTCAATTACGGCTGGACCATCCGATACCTACATGCAAACGGA
GCTTCCATATTTTTCATTTGCCTTTACACTCACATGGGCCGTGGYCTGTACTACGGCTCCTACATCTTCC
AAGAAACATGAAACGTTGGAAYGATACTCCTAATCACAGTAATAGCCACCGCATTCGTAGGTTACGTACT
GCCC', 424);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH) VALUES ('AH014490.2', 'AAV54194.1', 'GAATGGACTGATGATGGCAACCCTGAACGTGGATTTGATTACATTTATCTGACTGAAGAAGACTATGGTC
GTATTAGCTCTTCTGTTATAGCGCACAAGACGCAGCTTGATAATGGCGAAATAAGGTGGGTTATCGATTC
TGTTGTGGGCAAGGAGGATGGACTAGGTGTGGAGAACATACATGGAAGTGCTGCTATTGCCAGTGCTTAT
TCTAGGGCATATGANNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNAGGCTTCTCTGGTGGGCAAAGAGACC
TTTTTGAAGGAATTCTGCAGGCTGGATCAACAATTGTTGAGAACCTTAGGACATACAATCAGCCTGCCTT
TGTATATATCCCCAAGGCTGCAGAGCTACGTGGAGGGGCTTGGGTCGTGATTGATAG', 477);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('MN148748.1', 'QKV50459.1', 'CCATCCAACATCTCAGCATGATGAAATTTCGGCTCACTACTAGGAGCATGCCTAATTACCCAAATCCTAACAGGATTATTCCTAGCCATACATTATACACCCGACACAATAACTGCATTTTCATCTATATCCCATATTTGCCGAGATGTGAACTACGGCTGAATTATTCGACAACTACACTCAAACGGAGCATCCATTTTCTTCCTCTGCCTATACACACACATTGGACGAAACATCTACTATGGGTCCTACCTATACTCGGAAACTTGAAATACCGGCA
TTATATTACTACTAATCACCATAGCCACCGCCTTCATAGGATATGTCCTTCCGTGAGGACAAATATCATTCTGAGGGGC', 204);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('NM_000207.3', '3630', 'AGCCCTCCAGGACAGGCTGCATCAGAAGAGGCCATCAAGCAGATCACTGTCCTTCTGCCATGGCCCTGTGGATGCGCCTCCTGCCCCTGCTGGCGCTGCTGGCCCTCTGGGGACCTGACCCAGCCGCAGCCTTTGTGAACCAACACCTGTGCGGCTCACACCTGGTGGAAGCTCTCTACCTAGTGTGCGGGGAACGAGGCTTCTTCTACACCCAAGACCCGCCGGGAGGCAGAGGACCTGCAGGTGGGGCAGGTGGAGCTGGGCGGGGGCCCTGGTGCAGGCAGCCTGCAGCCCTTGGCCCTGGAGGGGTCCCTGCAGAAGCGTGGCATTGTGGAACAATGCTGTACCAGCATCTGCTCCCTCTACCAGCTGGAGAACTACTGCAACTAGACGCAGCCCGCAGGCAGCCCCACACCCGCCGCCTCCTGCACCGAGAGAGATGGAATAAAGCCCTTGAACCAGC', 465);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('NM_001017397.2', '55521', 'GTTCCGTTAGATCGCGCAGCCCCGACCGCTGCACCCGGATCCTAGCAAGCCGGGCGAGGCTGCCCGGGAGCCCTCGATGGCCTTCATTTCACCCAAGCCCGCTTCTTGCTTTCCCCGGCGCTTCCCCTCTTTTCCTGGTTAACAGCTTATGGGCGGGGAGCTCGGCAAAACTCAGACTAAAAACAGAAAAAGAGAAAAGAAAGGACAAATTCGATACACCCGCGTCGGTCCTCCAGAGTTTGTGAAGGGGTGTAAACATGTCGGAGTCTGGGGAGATGAGTGAATTTGGCTACATCATGGAATTGATAGCTAAAGGCAAGATGCCGGATTGGAGACGAGGCTACCGCTGCAGACAGGGCTGTGGGAAGACGACGGAACTTGCCACAGCGACAGACTTCTCCCAAACAGGAAATAAAAGTGGGAAGCATTTTAAAACCTAAA', 441);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('OP919018.1', 'MG100', 'AAACTGCCTGATGGAGGGGGATAACTACTGGAAACGGTAGCTAATACCGCATAACGTCGCARGACCAAAGAGGGGGACCTTCGGGCCTCTTGCCATCAGATGTGCCCRGATGGGATTAGCTAGTACGTGGGGTAACGGCTCCCCTAGGCGACGATCCCTAGCTGGTCTGAGAGGATGACCAGCCACACTGGAACTGAKACACGGTCCAGACTCCTACGGGAGGCAGCAGTGGGGAATATTGCACAATGGGSGCCAGCCTGATGCAGCCATGCCGGGTGTATGAAGAAGGCCTTCTGGTTGAAAAGTACTTTCACCGGGGAGGAAGGAGATGSGGTTAATAACCGCGTCGATTGATYTTACCCGCAGAASAAGCCCCGGCCAACTCCGTGCCACCATCC', 398);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('LC643482.1', 'z1_z-f', 'ACTTGCGAAGGTTGGGGGAAGCAAACAGGGATTAGAATACCCTGGGTAGTCCACGCCCTAAACGGATGGGATGCTAGTTGTTGGGAGGGCTTAGTCTCTCCAGTAATGCAGCTAACG', 117);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('AH003710.2', 'Aarely-1e', 'CTGCAGGTGTATATTTATTAATGCGTAGTTCACCATTAATTGAATATAGTAGTACTGTCTTACTATTANN
NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN
NNNNNNNNNNNNNNNNNNNNNNNNNNNNTTATAATAAATATATTACAAATTTAGTTTTAGATTTAGGTGG
GGGGGGGGATCGGGTAAAGCCCTTCTT', 237);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('NW_022279501.1', '116408221', 'CAAATACGCCCCGACGCCCGTCACTGCTGAGTAGAGAAGACATTCAGCCATAGAAATGCTGCTTTAATAT
ATAAAATAAATCAGTCCATATCTCCGGCACTATAACCCCCCCCAGGTTCGGTTTCCCACAAATCAATGCAGAATAGGGCCCCCCCCCCCCCTCCTTAAAACTCAAAGTTGCCAAACTGGGAGGCGTGGCTGTTGGGCTTGGGCTGCGGCCTGTAGCCAATCCGCTCGTGGATGCTTTGCTCCCGCCCCTTGGGGTCGCTGCTGAGGGCCACGGCCGCGTCCGTTTCTGTCGCTGATAAATCCACCTCTTCCCGCTGCTTTTTGCGCCCCTGTAGGGAGGAGGCGGAGCCAGGCATTAAAGGGACAGTGTACCCATTGGTGCTGATGAGTGTTACTGGGGGAGGGGGAAAGTCCAACTCACCTCTAAATCCTTTTTGATGCTCTCAAACTCCTCAATGTCGTCCAGTTTCAGCTCCAGGCGGGTCGGCTTCCTGCGCAGCATCGTTACCTGCCCCGGGGCAACAAGGGAGATCGGCTCAGGCATTATAAGTGGCTCATATTCCTGGCCCCGCCCTATAAAGTAACC', 593);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('CR541913.1', 'CAG46711.1', 'ATGGTGCACCTGACTCCTGAGGAGAAGTCTGCCGTTACTGCCCTGTGGGGCAAGGTGAACGTGGATGAAGTTGGTGGTGAGGCCCTGGGCAGGCTGCTGGTGGTCTACCCTTGGACCCAGAGGTTCTTTGAGTCCTTTGGGGATCTGTCCACTCCTGATGCTGTTATGGGCAACCCTAAGGTGAAGGCTCATGGCAAGAAAGTGCTCGGTGCCTTTAGTGATGGCCTGGCTCACCTGGACAACCTCAAGGGCACCTTTGCCACACTGAGTGAGCTGCACTGTGACAAGCTGCACGTGGATCCTGAGAACTTCAGGCTCCTGGGCAACGTGCTGGTCTGTGTGCTGGCCCATCACTTTGGCAAAGAATTCACCCCACCAGTGCAGGCTGCCTATCAGAAAGTGGTGGCTGGTGTGGCTAATGCCCTGGCCCACAAGTATCAC', 441);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('MZ427325.1', 'UJI58659.1', 'ATGTCTTTTTCAAGAAGACCGAAGATTACTAAATCAGATATTGTTGATCAAATATCTTTGAATATTAGAAATAATAATCTAAAATTAGAAAAAAAATACATAAGACTTGTGATAGATGCTTTTTTTGAAGAGCTTAAAGGTAATCTTTGTTTAAATAATGTTATTGAGTTTAGATCTTTTGGTACATTTGAAGTTAGAAAAAGAAAGGGGCGTTTAAATGCGCGCAATCCTCAAACAGGGGAATATGTTAAGGTTTTAGATCATCATGTTGCGTATTTTCGTCCAGGCAAGGATTTGAAAGAGAGAGTGTGGGGTATTAAAGGTTAA', 327);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('MK050959.1', 'Hbb', 'GGGCCAAGAGATATATCTTAGAGGGAGGGCTGAGGGTTTGAAGTCCAACTCCTAAGCCAGTGCCAGAAGAGCCAAGGACAGGTACGGCTGTCATCACTTAGACCTCACCCTGTGGAGCCACACCCTAGGGTTGGCCAATCTACTCCCAGGAGCAGGGAGGGCAGGAGCCAGGGCTGGGCATAAAAGTCAGGGCAGAGCCATCTATTGCTTACATTTGCTTCTGACACAACTGTGTTCACTAGCAACCTCAAAGAGACACC', 260);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('OM246557.1', '59272', 'GAGTAGAGGACTAAATCACTCAGGAAATATTAAATGTTTCACCAGATATTATTTGGACTATATCTTCTGT
TCTATCTCTTCAAGCAATGCCATTCCAACTTCAATTTTCTTTTCTGTCATTTCAGAATAATGCTGGGGAC
AAATGGTCTGCCTTTTTAAAGGAACAGTCCACACTTGCCCAAATGTATCCACTACAAGAAATTCAGAATC
TCACAGTCAAGCTTCAGCTGCAGGCTCTTCAGCAAAATGGGTCTTCAGTGCTCTCAGAAGACAAGAGCAA
ACGGGTACGTTTGTGAACATTTTAGCATTGATCCCAAGAGTTGAAATATTTGGGAAATATTAAACATTAA
TATCACCCACAGCAGCTGCCTTTATTGAAAAAATAGTAATGCTGATGTTAGAAAAATCTCTCTCTA', 416);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('XM_026758111.1', '38126466', 'ATGGCCTCGCAAACCGCAGTCTCAGCGCGCAGCGCCTACCGACAGATCCTCCGCGCTACCCGCATCGCTT
TCCAAGACGACTTCCGTGTTCTGATCGCTGCTCGTCAGGAAGCCCGTCGCCAGTTTGACGCACACCGCCG
CGAGGGGATTGATACGCCAATGCACATCAACCATGCCAAAGAGGTGGCCGACATTCTCCGACACAACATT
GTACAAGGCGTAAGGGATAGTAACGACGAGAATGCCAAATGGGAGCTCCGCATTCACGACGATATCGAGC
GTGGAGATAATGATTCGATCAGAGTTGCTGGGAAGAAGGTCAAAGTTGATAAGCCGTGCTCCGCATGA', 348);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('D82631.1', 'HUMHBC3078', 'CAAAACTACCCCCCTAATAAAATTANTTAACCACTCATTCATCGAGCTCCCCACCCCATCCAATATCTCC
GTATGATGAAACTTCGGNTCACTCNTTGGGGCCTGCCTGATCCTCCAAATCACCACAGGACTATTCCTAG
CCATGNACTACTCACCAGACGCCTCAACCGCCTTTTCATCANTCGCCCACATCACTCGAGACGTNAATTA
TGGATGAATCATCCGCTACCTTCACGNCAATGGCGCCTCAATATTCTTTATCTGCCTCTTCCNACACATC
GGGCGAGGNCTATATTACGGATCATTTCTCTACTCA', 316);
INSERT INTO SEQUENCES (SEQ_ID, GENE_ID, DNA_SEQ, SEQ_LENGTH)
VALUES
('C75666.1', '11124009', 'TTTTTTTAACCTTTCCTTATGAGCATGCCTGTGTTGGGTTGACAGTGAGGGTAATAATGACTTGTTGGTT
GATTGTAGATATTGGGCTGTTAATTGTCAGTTCAGTGTTTTAATCTGACGCAGGCTTATGCGGAGGAGAA
TGTTTTCATGTTACTTATACTAACATTAGTTCTTCTATAGGGTGATAGATTGGTCCAATTGGGTGTGAGG
AATTCANTTATATGTTTGGGATTTTTTAGGTAGTGGGTGTTGAACTTGAGCGCTTTCTTAATTGGTGGCT
GCTTTTAGGCCTACTATGGGTGTTAAATTTTTTACTCTCTCTACAAGGTTTTTTCCTAATGTCCAAA', 347);
ALTER TABLE SEQUENCES
MODIFY DNA_SEQ VARCHAR2(3000);
select * from SEQUENCES;
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (1, 'Zhang,A. and Chi,Q.', TO_DATE('2014', 'YYYY'), 'NCBI Direct Submission', 6563);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (2, 'Anton,B., Matus,M., Canseco,J., Calva,J.C., Gonzaga,R., Flores,A., Salazar,A., Aguilera,P., Barbosa,S. and Leff,P.', TO_DATE('2005', 'YYYY'), 'Cloning of Homo sapiens mRNA coding for the human brain syntaxin 16 isoform c/amonopeptidase-like 1 protein', 8675);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (3, 'Rabie,B.H., Kamil,Z.H. and Hasan,A.H.', TO_DATE('2023', 'YYYY'), 'NCBI Direct Submission', 169026);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (4, 'Rabie,B.H., Kamil,Z.H. and Hasan,Ah.', TO_DATE('2023', 'YYYY'), 'NCBI Direct Submission', 6934);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (5, 'Jackson VA, Mehmood S, Chavent M, Roversi P, Carrasquero M, Del Toro D, Seyit-Bremer G, Ranaivoson FM, Comoletti D, Sansom MS, Robinson CV, Klein R and Seiradake E.', TO_DATE('2016', 'YYYY'), 'Super-complexes of adhesion GPCRs and neural guidance receptors', 23768);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (6, 'NCBI', TO_DATE('2023', 'YYYY'), 'NCBI', 74386);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (7, 'Milenkovic D, Sanz-Moreno A, Calzada-Wack J, Rathkolb B, Veronica Amarie O, Gerlini R, Aguilar-Pimentel A, Misic J, Simard ML, Wolf E, Fuchs H, Gailus-Durner V, de Angelis MH and Larsson NG.', TO_DATE('2022', 'YYYY'), 'Mice lacking the mitochondrial exonuclease MGME1 develop inflammatory kidney disease with glomerular dysfunction', 74528);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (8, 'Reichwald,K., Lauber,C., Heinze,I., Mueller,O. and Gausmann,U.', TO_DATE('2008', 'YYYY'), 'NCBI Direct Submission', 7256398);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (9, 'NCBI', TO_DATE('2018', 'YYYY'), 'NCBI', 111814982);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (10, 'NCBI', TO_DATE('2018', 'YYYY'), 'NCBI', 101561532);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (11, 'Singh,A.D., Banerjee,A. and Batabyal,K.', TO_DATE('2020', 'YYYY'), 'Klebsiella pneumoniae blaSHV-148 gene', 'WP_194293132.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (12, 'Hines,L., Rolfs,A., Jepson,D., Moreira,D., Raphael,J., Kelley,F., Shen,B., Halleck,A., Koundinya,M., Hu,Y., Zuo,D., Taycher,E., Williamson,J. and LaBaer,J.', TO_DATE('2016', 'YYYY'), 'Cloning of human full-length CDS in Creator (TM) recombinational vector system', 'AAX29564.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (13, 'Kijas,J.W., McEwan,J.C. and Dalrymple,B.P.', TO_DATE('2015', 'YYYY'), 'NCBI Direct Submission', 'Contig45496');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (14, 'Milinkovitch,M.C., Meyer,A. and Powell,J.R.', TO_DATE('1995', 'YYYY'), 'Phylogeny of all major groups of cetaceans based on DNA sequences from three mitochondrial genes', '12SrRNA');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (15, 'Milinkovitch,M.C.', TO_DATE('1995', 'YYYY'), 'NCBI Direct Submission', 'AAC48452.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (16, 'Canovas-Conesa,B., De Prado,R. and Rodriguez,A.', TO_DATE('2016', 'YYYY'), 'NCBI Direct Submission', 'AAV54194.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (17, 'Channumsin,M., Ciosi,M. and Mable,B.K.', TO_DATE('2020', 'YYYY'), 'NCBI Direct Submission', 'QKV50459.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (18, 'Lubenia PVN, Mendoza ER and Lao AR.', TO_DATE('2023', 'YYYY'), 'Comparative analysis of kinetic realizations of insulin signaling', '3630');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (19, 'Liu X, Yan C, Chang C, Meng F, Shen W, Wang S and Zhang Y.', TO_DATE('2023', 'YYYY'), 'FOXA2 Suppression by TRIM36 Exerts Anti-Tumor Role in Colorectal Cancer Via Inducing NRF2/GPX4-Regulated Ferroptosis', 55521);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (20, 'Rosini,B., Bulla,A.M., Polonio,J.C., Polli,A.D., Silva,A.A., Schoffen,R.P., Oliveira-Junior,V.A., Santos,S.S., Golias,H.C., Azevedo,J.L. and Pamphile,J.A.', TO_DATE('2022', 'YYYY'), 'Cultivable endophytic bacterial community associated with Mikania glomerata (Spreng.) and the use of Pseudomonas spp. as soybean plant-promoters', 'MG100');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (21, 'Allaith,Z. and Naser,L.', TO_DATE('2021', 'YYYY'), 'Isolation,identification and screening of virulence factors for Helicobacter pylori', 'z1_z-f');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (22, 'Court,D.A., Griffiths,A.J., Kraus,S.R., Russell,P.J. and Bertrand,H.', TO_DATE('2016', 'YYYY'), 'A new senescence-inducing mitochondrial linear plasmid in field-isolated Neurospora crassa strains from India', 'Aarely-1e');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (23, 'Hellsten,U., Harland,R.M., Gilchrist,M.J., Hendrix,D., Jurka,J., Kapitonov,V., Ovcharenko,I., Putnam,N.H., Shu,S., Taher,L., Blitz,I.L.', TO_DATE('2019', 'YYYY'), 'The genome of the Western clawed frog Xenopus tropicalis', 116408221);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (24, 'Halleck,A., Ebert,L., Mkoundinya,M., Schick,M., Eisenstein,S., Neubert,P., Kstrang,K., Schatten,R., Shen,B., Henze,S., Mar,W., Korn,B., Zuo,D., Hu,Y. and LaBaer,J.', TO_DATE('2016', 'YYYY'), 'NCBI Direct Submission', 'CAG46711.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (25, 'Golidonova,K.A. and Korenberg,E.I.', TO_DATE('2022', 'YYYY'), 'NCBI Direct Submission', 'UJI58659.1');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (26, 'Hamid,M.', TO_DATE('2019', 'YYYY'), 'NCBI Direct Submission', 'Hbb');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (27, 'Mohammed Ameen,H.R., Othman,G.O. and Mahmood,Z.H.', TO_DATE('2022', 'YYYY'), 'NCBI Direct Submission', 59272);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (28, 'Dufresne,P.J., Fournier,E., Martineau,C., de Repentigny,L. and Dufresne,S.F.', TO_DATE('2023', 'YYYY'), 'NCBI Direct Submission', 38126466);
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (29, 'Takeda,J.', TO_DATE('2006', 'YYYY'), 'Human pancreatic islet ESTs', 'HUMHBC3078');
INSERT INTO REFS (REF_ID, AUTHORS, PUB_DATE, REF_TITLE, GENE_ID) VALUES (30, 'Takeda,J.', TO_DATE('2006', 'YYYY'), 'Large scale collection of expressed sequence tags (ESTs) from human pancreatic islet cDNA library', '11124009');
-- Modify the "authors" column
ALTER TABLE REFS
MODIFY AUTHORS VARCHAR2(500);
-- Modify the "ref_title" column
ALTER TABLE refs
MODIFY ref_title VARCHAR2(500);