1	\N	schema_type	variation
2	\N	schema_version	113
3	\N	patch	patch_109_110_a.sql|schema version
4	\N	patch	patch_109_110_b.sql|Add DDG2P data_source_attrib to variation_citation
5	\N	patch	patch_109_110_c.sql|Add new clinical_significance values to variation, variation_feature and structural_variation
6	\N	patch	patch_110_111_a.sql|schema version
7	\N	patch	patch_110_111_b.sql|Update transcript_variation primary key
8	1	polyphen_version	2.2.3
9	1	sift_protein_db_version	uniref90.fasta
10	1	sift_version	6.2.1
11	1	species.production_name	homo_sapiens
12	1	variation_source.database	1
13	1	variation_source.vcf	0
14	1	ploidy	2
15	1	pairwise_ld.default_population	373514
16	1	dbnsfp_version	4.4a
18	1	species.division	EnsemblVertebrates
19	1	TranscriptEffect_run_date	2023-05-07
20	1	web_config	menu#Arrays and other##var_other#
21	1	web_config	menu#Failed variants##failed#
22	1	web_config	menu#Phenotype, disease and curated variants##phenotype#
23	1	web_config	menu#Sequence variants##variants#
24	1	web_config	menu_sub#1000 Genomes##1000g#variants
25	1	web_config	menu_sub#LSDB-associated variants##lsdb#phenotype
26	1	web_config	menu_sub#Phenotype/disease variants by source##phe#phenotype
27	1	web_config	menu_sub#Sequence variants##var#variants
28	1	web_config	set#1000 Genomes - AFR - common#1KG AFR common#variation_set_1kg_3_afr_com#1000g
29	1	web_config	set#1000 Genomes - AFR#1KG AFR#variation_set_1kg_3_afr#1000g
30	1	web_config	set#1000 Genomes - All - common#1KG All common#variation_set_1kg_3_com#1000g
31	1	web_config	set#1000 Genomes - All#1KG All#variation_set_1kg_3#1000g
32	1	web_config	set#1000 Genomes - AMR - common#1KG AMR common#variation_set_1kg_3_amr_com#1000g
33	1	web_config	set#1000 Genomes - AMR#1KG AMR#variation_set_1kg_3_amr#1000g
34	1	web_config	set#1000 Genomes - EAS - common#1KG EAS common#variation_set_1kg_3_eas_com#1000g
35	1	web_config	set#1000 Genomes - EAS#1KG EAS#variation_set_1kg_3_eas#1000g
36	1	web_config	set#1000 Genomes - EUR - common#1KG EUR common#variation_set_1kg_3_eur_com#1000g
37	1	web_config	set#1000 Genomes - EUR#1KG EUR#variation_set_1kg_3_eur#1000g
38	1	web_config	set#1000 Genomes - SAS - common#1KG SAS common#variation_set_1kg_3_sas_com#1000g
39	1	web_config	set#1000 Genomes - SAS#1KG SAS#variation_set_1kg_3_sas#1000g
40	1	web_config	set#Affy GeneChip 500K#Affy GeneChip 500K#variation_set_Affy_500K#var_other
41	1	web_config	set#Affy GenomeWideSNP_6.0#Affy GenomeWideSNP_6.0#variation_set_Affy_SNP6#var_other
42	1	web_config	set#All ClinVar variant annotations#All ClinVar#variation_set_ClinVar#phe
43	1	web_config	set#All failed variants#All failed variants#variation_set_fail_all#failed
44	1	web_config	set#All LSDB-associated variants#All LSDB-assoc.#variation_set_lsdb_variants#lsdb
45	1	web_config	set#All phenotype-associated variants#All phenotype-assoc.#variation_set_ph_variants#phe
46	1	web_config	set#All variants on genotyping chips#All genotyping chips#variation_set_all_chips#var_other
47	1	web_config	set#ClinVar variants described as being probable-pathogenic, pathogenic, drug-response or histocompatibility#ClinVar clinically assoc.#variation_set_clin_assoc#phe
48	1	web_config	set#dbPEX variants#dbPEX#variation_set_dbPEX#lsdb
49	1	web_config	set#ExAC variants#ExAC variants#variation_set_exac#var
50	1	web_config	set#gnomAD variants#gnomAD variants#variation_set_gnomAD#var
51	1	web_config	set#HbVar variants#HbVar#variation_set_HbVar#lsdb
52	1	web_config	set#HGMD-PUBLIC variants#HGMD-PUBLIC#variation_set_ph_hgmd_pub#phe
53	1	web_config	set#Illumina_1M-duo#Illumina_1M-duo#variation_set_Illumina_1M-duo#var_other
54	1	web_config	set#Illumina_Cardio-Metabo_Chip#Illumina_Cardio-Metabo_Chip#variation_set_Cardio-Metabo_Chip#var_other
55	1	web_config	set#Illumina_CytoSNP12v1#Illumina_CytoSNP12v1#variation_set_Illumina_CytoSNP12v1#var_other
56	1	web_config	set#Illumina_ExomeChip#Illumina_ExomeChip#variation_set_ExomeChip#var_other
57	1	web_config	set#Illumina_Human610_Quad#Illumina_Human610_Quad#variation_set_Human610_Quad#var_other
58	1	web_config	set#Illumina_Human660W-quad#Illumina_Human660W-quad#variation_set_Illumina_660Q#var_other
59	1	web_config	set#Illumina_HumanCoreExome-12#Illumina_HumanCoreExome-12#variation_set_HumanCoreExome#var_other
60	1	web_config	set#Illumina_HumanHap550#Illumina_HumanHap550#variation_set_HumanHap550#var_other
61	1	web_config	set#Illumina_HumanHap650Y#Illumina_HumanHap650Y#variation_set_HumanHap650Y#var_other
62	1	web_config	set#Illumina_HumanOmni1-Quad#Illumina_HumanOmni1-Quad#variation_set_HumanOmni1-Quad#var_other
63	1	web_config	set#Illumina_HumanOmni2.5#Illumina_HumanOmni2.5#variation_set_HumanOmni2.5#var_other
64	1	web_config	set#Illumina_HumanOmni5#Illumina_HumanOmni5#variation_set_HumanOmni5#var_other
65	1	web_config	set#Illumina_HumanOmniExpress#Illumina_HumanOmniExpress#variation_set_HumanOmniExpress#var_other
66	1	web_config	set#Illumina_ImmunoChip#Illumina_ImmunoChip#variation_set_ImmunoChip#var_other
67	1	web_config	set#Infevers variants#Infevers#variation_set_Infevers#lsdb
68	1	web_config	set#KAT6BDB variants#KAT6BDB#variation_set_KAT6BDB#lsdb
69	1	web_config	set#LMDD variants#LMDD#variation_set_LMDD#lsdb
70	1	web_config	set#LSDB variants#LSDB#variation_set_LSDB#lsdb
71	1	web_config	set#NHGRI-EBI GWAS catalog phenotype variants#NHGRI-EBI GWAS phenotype#variation_set_ph_nhgri#phe
72	1	web_config	set#OIVD variants#OIVD#variation_set_OIVD#lsdb
73	1	web_config	set#OMIM phenotype variants#OMIM phenotype#variation_set_ph_omim#phe
74	1	web_config	set#PAHdb variants#PAHdb#variation_set_PAHdb#lsdb
75	1	web_config	set#PhenCode#PhenCode#variation_set_phencode#phe
76	1	web_config	set#UniProt variants#UniProt variants#variation_set_ph_uniprot#var
77	1	web_config	source#dbSNP variants#dbSNP#variation_feature_variation_dbSNP#var
78	1	web_config	source#Sequence variants (dbSNP and all other sources)#All sequence variants#variation_feature_variation#var
79	1	web_config	sv_set#1000 Genomes 3 - AFR#1KG AFR#sv_set_1kg_3_afr
80	1	web_config	sv_set#1000 Genomes 3 - All#1KG All#sv_set_1kg_3
81	1	web_config	sv_set#1000 Genomes 3 - AMR#1KG AMR#sv_set_1kg_3_amr
82	1	web_config	sv_set#1000 Genomes 3 - EAS#1KG EAS#sv_set_1kg_3_eas
83	1	web_config	sv_set#1000 Genomes 3 - EUR#1KG EUR#sv_set_1kg_3_eur
84	1	web_config	sv_set#1000 Genomes 3 - SAS#1KG SAS#sv_set_1kg_3_sas
85	1	web_config	sv_study#1000 Genomes Project Consortium - Phase 1 (DGVa study estd199)#1KG phase1#estd199
86	1	web_config	sv_study#1000 Genomes Project Consortium - Phase 3 (DGVa study estd214)#1KG phase3#estd214
87	1	web_config	sv_study#Audano 2019 (dbVar study nstd162)#Audano 2019#nstd162
88	1	web_config	sv_study#Byrska-Bishop 2022 (dbVar study nstd206)#Byrska-Bishop 2022#nstd206
89	1	web_config	sv_study#Chaisson 2018 (dbVar study nstd152)#Chaisson 2018#nstd152
90	1	web_config	sv_study#ClinVar-SV (dbVar study nstd102)#ClinVar SV#nstd102
91	1	web_config	sv_study#Conrad & Hurles 2010 (DGVa study estd20)#Conrad & Hurles 2010#estd20
92	1	web_config	sv_study#Ebert 2021 (dbVar study nstd207)#Ebert 2021#nstd207
93	1	web_config	sv_study#gnomAD-SV (dbVar study nstd166)#gnomAD SV#nstd166
94	1	web_config	sv_study#NCBI Curated Common Structural Variants (dbVar study nstd186)#Common SV#nstd186
95	1	web_config	sv_study#Sedlazeck 2020 (dbVar study nstd223)#Sedlazeck 2020#nstd223
96	1	web_config	sv_study#Vogler 2010 (DGVa study estd203)#Vogler 2010#estd203
97	1	web_config	sv_study#Xu 2011 (DGVa study nstd71)#Xu 2011#nstd71
98	1	EquivalentAlleles_run_date	2023-06-27
99	1	PhenotypeAnnotation_run_date_GWAS	2023-07-06
100	1	PhenotypeAnnotation_run_date_EGA	2023-07-06
101	1	PhenotypeAnnotation_run_date_Orphanet	2023-07-06
102	1	PhenotypeAnnotation_run_date_MIMmorbid	2023-07-06
103	1	PhenotypeAnnotation_run_date_G2P	2023-07-06
104	1	PhenotypeAnnotation_run_date_CGC	2023-07-06
105	1	EPMC_citation_update	2023-07-08
106	1	UCSC_citation_update	2023-07-11
107	1	TranscriptEffect_run_date	2023-07-29
108	1	AncestralAlleles_run_date	2023-08-04
109	\N	patch	patch_111_112_a.sql|schema version
110	1	EquivalentAlleles_run_date	2023-10-29
111	1	EPMC_citation_update	2023-11-03
112	1	PhenotypeAnnotation_run_date_GWAS	2023-11-04
113	1	PhenotypeAnnotation_run_date_EGA	2023-11-04
114	1	ClinGen_Allele_Registry_update	2024-05-23
115	1	ClinGen_Allele_Registry_source	 http://reg.genome.network
116	1	ClinGen_Allele_Registry_CAR_version	4.22.1
117	1	PhenotypeAnnotation_run_date_Orphanet	2023-11-09
118	1	PhenotypeAnnotation_run_date_MIMmorbid	2023-11-09
119	1	PhenotypeAnnotation_run_date_G2P	2023-11-09
120	1	PhenotypeAnnotation_run_date_CGC	2023-11-09
121	1	TranscriptEffect_run_date	2023-11-23
122	\N	patch	patch_112_113_a.sql|schema version
123	\N	patch	patch_112_113_b.sql|Update meta_key length
124	1	EquivalentAlleles_run_date	2024-05-23
125	1	EPMC_citation_update	2024-05-24
126	1	PhenotypeAnnotation_run_date_GWAS	2024-05-28
127	1	PhenotypeAnnotation_run_date_EGA	2024-05-28
128	1	dbnsfp_version	4.7c
129	1	cadd_version	v1.7
130	1	TranscriptEffect_run_date	2024-06-17
131	1	PhenotypeAnnotation_run_date_Orphanet	2024-06-20
132	1	PhenotypeAnnotation_run_date_MIMmorbid	2024-06-20
133	1	PhenotypeAnnotation_run_date_G2P	2024-06-20
134	1	PhenotypeAnnotation_run_date_CGC	2024-06-20
135	1	AncestralAlleles_run_date	2024-06-28
136	1	AncestralAlleles_run_date	2024-07-03