Homec4science
Diffusion SHRINE MedCo Fork (riccardo) Browse

shrine-medco/shrine-webclient/src/main/tools/create_tables/postgres_load_tables
5575e0d60ecdriccardo

Last Change
Raw File

postgres_load_tables
View Options

create schema shrine_ont
-- --- ANNOTATIONS METADATA ---
create table shrine_ont.genomic_annotations_metadata
(
annotation_id character varying(255) NOT NULL PRIMARY KEY,
annotation_values text NOT NULL
);
ALTER TABLE shrine_ont.genomic_annotations_metadata OWNER TO shrine_ont;
-- ALTER TABLE ONLY shrine_ont.genomic_annotations_metadata ADD CONSTRAINT annotation_id_pk PRIMARY KEY (annotation_id);
truncate shrine_ont.genomic_annotations_metadata;
\copy shrine_ont.genomic_annotations_metadata FROM '/home/niccolo/Downloads/createAnnoMetadata/SHRINE_ONT_ANNOTATIONS_METADATA.csv' ESCAPE '"' DELIMITER ',' CSV;
-- --- NEW ONTOLOGY GENOMIC ---
create table shrine_ont.genomic_annotations_new
(
variant_id character varying(255) NOT NULL PRIMARY KEY,
variant_name character varying(255) NOT NULL,
annotations text NOT NULL,
t_depth numeric NOT NULL
);
ALTER TABLE shrine_ont.genomic_annotations_new OWNER TO shrine_ont;
-- ALTER TABLE ONLY shrine_ont.genomic_annotations_new ADD CONSTRAINT variant_id_pk PRIMARY KEY (variant_id);
truncate shrine_ont.genomic_annotations_new;
\copy shrine_ont.genomic_annotations_new FROM '/home/niccolo/SHRINE/SHRINE_ONT_GENOMIC_ANNOTATIONS_NEW.csv' ESCAPE '"' DELIMITER ',' CSV;
-- --- GENE VALUES ---
create table shrine_ont.gene_values
(
gene_value character varying(255) NOT NULL PRIMARY KEY
);
ALTER TABLE shrine_ont.gene_values OWNER TO shrine_ont;
-- ALTER TABLE ONLY shrine_ont.gene_values ADD CONSTRAINT variant_id_pk PRIMARY KEY (variant_id);
truncate shrine_ont.gene_values;
\copy shrine_ont.gene_values FROM '/home/niccolo/SHRINE/SHRINE_GENES.csv' ESCAPE '"' DELIMITER ',' CSV;
-- --- VARIANT NAMES ---
create table shrine_ont.variant_names
(
variant_name character varying(255) NOT NULL PRIMARY KEY
);
ALTER TABLE shrine_ont.variant_names OWNER TO shrine_ont;
-- ALTER TABLE ONLY shrine_ont.genomic_annotations_new ADD CONSTRAINT variant_id_pk PRIMARY KEY (variant_id);
truncate shrine_ont.variant_names;
\copy shrine_ont.variant_names FROM '/home/niccolo/SHRINE/SHRINE_VARIANTS_NAMES.csv' ESCAPE '"' DELIMITER ',' CSV;
c4science · Help