-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathupdate_data_sources.sql
85 lines (83 loc) · 6.5 KB
/
update_data_sources.sql
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
-- see insert_data_sources.sql to see list of data source IDs
-- NCBI Taxonomy
update dataSource set releaseDate = '2020-12-14', releaseVersion = '', displayOrder = 1 where dataSourceId = 1;
-- Ensembl
update dataSource set releaseDate = '2020-12-01', releaseVersion = '102', displayOrder = 1 where dataSourceId = 2;
-- EMBL (taken from Ensembl xrefs)
update dataSource set releaseDate = null, releaseVersion = '' where dataSourceId = 3;
-- Uniprot/trEMBL (taken from Ensembl xrefs)
update dataSource set releaseDate = null, releaseVersion = '' where dataSourceId = 4;
-- Uniprot/SwissProt (taken from Ensembl xrefs)
update dataSource set releaseDate = null, releaseVersion = '' where dataSourceId = 5;
-- mirbase
update dataSource set releaseDate = '2018-11-03', releaseVersion = '22.1', displayOrder = 9 where dataSourceId = 6;
-- 4DXpress
update dataSource set releaseDate = null, releaseVersion = '' where dataSourceId = 7;
-- ZFIN
update dataSource set releaseDate = '2021-03-02', releaseVersion = '', displayOrder = 5 where dataSourceId = 8;
-- MGI
update dataSource set releaseDate = '2021-03-02', releaseVersion = '', displayOrder = 6 where dataSourceId = 9;
-- FlyBase
update dataSource set releaseDate = '2021-03-02', releaseVersion = '' where dataSourceId = 10;
-- ArrayExpress Affymetrix
update dataSource set releaseDate = '2016-08-21', releaseVersion = '', displayOrder = 4 where dataSourceId = 11;
-- ArrayExpress RNA-Seq
update dataSource set releaseDate = '2021-02-08', releaseVersion = '', displayOrder = 255 where dataSourceId = 101;
-- Unigene
update dataSource set releaseDate = '2016-12-05', releaseVersion = '', displayOrder = 9 where dataSourceId = 12;
-- smiRNAdb
update dataSource set releaseDate = '2009-04-23', releaseVersion = '2', displayOrder = 11 where dataSourceId = 13;
-- BDGP
update dataSource set releaseDate = '2020-11-22', releaseVersion = '', displayOrder = 8 where dataSourceId = 14;
-- Xenbase
update dataSource set releaseDate = '2021-03-11', releaseVersion = '', displayOrder = 7 where dataSourceId = 15;
-- neXtProt
update dataSource set releaseDate = null, releaseVersion = '' where dataSourceId = 16;
-- GEO (Affymetrix)
update dataSource set releaseDate = '2016-08-22', releaseVersion = '', displayOrder = 3 where dataSourceId = 17;
-- GEO (RNASeq)
update dataSource set releaseDate = '2021-02-08', releaseVersion = '', displayOrder = 2 where dataSourceId = 100;
-- GO
update dataSource set releaseDate = '2021-02-08', releaseVersion = '' where dataSourceId = 18;
-- SRA (RNA-Seq)
update dataSource set releaseDate = '2023-04-04', releaseVersion = '', displayOrder = 2 where dataSourceId = 19;
-- SRA (scRNA-Seq)
update dataSource set releaseDate = '2023-04-04', releaseVersion = '', displayOrder = 1 where dataSourceId = 102;
-- HGNC (taken from Ensembl xrefs)
update dataSource set releaseDate = null, releaseVersion = '', displayOrder = 1 where dataSourceId = 20;
-- CCDS (taken from Ensembl xrefs)
update dataSource set releaseDate = null, releaseVersion = '', displayOrder = 1 where dataSourceId = 21;
-- RGD (taken from Ensembl xrefs)
update dataSource set releaseDate = null, releaseVersion = '', displayOrder = 1 where dataSourceId = 22;
-- WormBase
update dataSource set releaseDate = '2020-12-13', releaseVersion = '', displayOrder = 1 where dataSourceId = 23;
-- EnsemblMetazoa
update dataSource set releaseDate = '2020-12-01', releaseVersion = '49', displayOrder = 1 where dataSourceId = 24;
-- Bgee
update dataSource set releaseDate = '2023-11-21', releaseVersion = '15.1', displayOrder = 1 where dataSourceId = 25;
-- Uberon
update dataSource set releaseDate = '2020-09-16', releaseVersion = '', displayOrder = 1 where dataSourceId = 26;
-- Developmental stage ontologies
update dataSource set releaseDate = '2021-03-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 27;
-- OMA
update dataSource set releaseDate = '2021-04-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 28;
-- Anatomical similarity annotations
update dataSource set releaseDate = '2016-07-14', releaseVersion = '', displayOrder = 1 where dataSourceId = 29;
-- CIO
update dataSource set releaseDate = '2015-03-10', releaseVersion = '', displayOrder = 1 where dataSourceId = 30;
-- GTEx-dbGAP
update dataSource set releaseDate = '2015-10-03', releaseVersion = '6.p1', displayOrder = 3 where dataSourceId = 31;
-- RefSeq genomic
update dataSource set releaseDate = '2020-12-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 37;
-- GenBank
update dataSource set releaseDate = '2020-12-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 38;
-- Amphiencode
update dataSource set releaseDate = '2021-07-15', releaseVersion = '', displayOrder = 7 where dataSourceId = 39;
-- RefSeq nucleotide
update dataSource set releaseDate = '2020-12-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 41;
-- RefSeq protein
update dataSource set releaseDate = '2020-12-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 42;
-- NCBI Gene ID
update dataSource set releaseDate = '2020-12-01', releaseVersion = '', displayOrder = 1 where dataSourceId = 43;
-- Alliance of Genome Resources
update dataSource set releaseDate = '2020-12-01', releaseVersion = '3.2', displayOrder = 1 where dataSourceId = 44;