7wFRqgDR

1CREATE KEYSPACE IF NOT EXISTS ha_bioinformatica WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor' : 1};
2
3USE ha_bioinformatica;
4
5CREATE TABLE IF NOT EXISTS hg19_abraom
6(
7    chromosome VARCHAR,
8    start INT,
9    end INT,
10    ref VARCHAR,
11    alt VARCHAR,
12    abraom_freq DECIMAL,
13    abraom_filter VARCHAR,
14    abraom_cegh_filter VARCHAR,
15    PRIMARY KEY((chromosome, ref, alt), start, end, abraom_freq)
16);
17
18CREATE TABLE IF NOT EXISTS hg19_avsnp150
19(
20    chromosome VARCHAR,
21    start INT,
22    end INT,
23    ref VARCHAR,
24    alt VARCHAR,
25    human_varianty VARCHAR,
26    PRIMARY KEY ((chromosome, ref, alt), start, end, human_varianty)
27);
28
29CREATE TABLE IF NOT EXISTS hg19_cadd13
30(
31    chromosome VARCHAR,
32    start INT,
33    end INT,
34    ref VARCHAR,
35    alt VARCHAR,
36    cadd13_rawscore DECIMAL,
37    cadd13_phred DECIMAL,
38    PRIMARY KEY ((chromosome, ref, alt), start, end, cadd13_rawscore, cadd13_phred)
39);
40
41CREATE TABLE IF NOT EXISTS hg19_clinvar
42(
43  chromosome VARCHAR,
44  start INT,
45  end INT,
46  ref VARCHAR,
47  alt VARCHAR,
48  clinsig VARCHAR,
49  clndbn VARCHAR,
50  clnacc VARCHAR,
51  clndsdb VARCHAR,
52  clndsdbid VARCHAR,
53  PRIMARY KEY((chromosome, ref, alt), start, end, clndsdb, clndsdbid)
54);
55
56CREATE TABLE IF NOT EXISTS hg19_gerp_elem
57(
58    chromosome VARCHAR,
59    start INT,
60    end INT,
61    rs_score DECIMAL,
62    p_value DECIMAL,
63    PRIMARY KEY (chromosome, start, end, rs_score, p_value)
64);
65
66CREATE TABLE IF NOT EXISTS hg19_gnomad_exome
67(
68    chromosome VARCHAR,
69    start INT,
70    end INT,
71    ref VARCHAR,
72    alt VARCHAR,
73    gnomad_exome_all VARCHAR,
74    gnomad_exome_afr VARCHAR,
75    gnomad_exome_amr VARCHAR,
76    gnomad_exome_asj VARCHAR,
77    gnomad_exome_eas VARCHAR,
78    gnomad_exome_fin VARCHAR,
79    gnomad_exome_nfe VARCHAR,
80    gnomad_exome_oth VARCHAR,
81    gnomad_exome_sas VARCHAR,
82    PRIMARY KEY ((chromosome, ref, alt), start, end, gnomad_exome_all, gnomad_exome_afr, gnomad_exome_amr, gnomad_exome_asj, gnomad_exome_eas,
83    gnomad_exome_fin, gnomad_exome_nfe, gnomad_exome_oth, gnomad_exome_sas)
84);
85
86CREATE TABLE IF NOT EXISTS hg19_mcap
87(
88  chromosome VARCHAR,
89  start INT,
90  end INT,
91  ref VARCHAR,
92  alt VARCHAR,
93  mcap DECIMAL,
94  PRIMARY KEY((chromosome, ref, alt), start, end, mcap)
95);
96
97CREATE TABLE IF NOT EXISTS hg19_revel
98(
99    chromosome VARCHAR,
100    start INT,
101    end INT,
102    ref VARCHAR,
103    alt VARCHAR,
104    revel DECIMAL,
105    PRIMARY KEY ((chromosome, ref, alt), start, end, revel)
106);