Dietary Restriction Transgenerational Fitness
Three-Generational Study in *Caenorhabditis elegans*
@kaggle.thedevastator_dietary_restriction_transgenerational_fitness
Three-Generational Study in *Caenorhabditis elegans*
@kaggle.thedevastator_dietary_restriction_transgenerational_fitness
CREATE TABLE f1 (
"worm" BIGINT,
"treatment" VARCHAR,
"parent_no" BIGINT,
"f0_treat" VARCHAR,
"lineage" VARCHAR,
"block" BIGINT,
"set_up" VARCHAR,
"death_date" VARCHAR,
"cause" VARCHAR,
"death" BIGINT,
"observed" BIGINT,
"matricide" BIGINT,
"total_rep" BIGINT,
"na_start" DOUBLE,
"n_1" DOUBLE,
"n_2" DOUBLE,
"n_3" DOUBLE,
"n_4" DOUBLE,
"n_5" DOUBLE,
"n_6" DOUBLE,
"n_7" DOUBLE,
"n_8" DOUBLE
);
CREATE TABLE f2 (
"worm" VARCHAR,
"treatment" VARCHAR,
"parent_no" BIGINT,
"f1_treat" VARCHAR,
"g_parent_no" VARCHAR,
"f0_treat" VARCHAR,
"worm_order" BIGINT,
"lineage" VARCHAR,
"block" BIGINT,
"set_up" VARCHAR,
"death_date" VARCHAR,
"cause" VARCHAR,
"death" BIGINT,
"observed" BIGINT,
"matricide" BIGINT,
"total_rep" BIGINT,
"na_start" DOUBLE,
"day2_unadded" DOUBLE,
"setup_f1d2" DOUBLE,
"day4_unadded" DOUBLE,
"setup_f1d4" DOUBLE,
"n_1" DOUBLE,
"n_2" DOUBLE,
"n_3" DOUBLE,
"n_4" DOUBLE,
"n_5" DOUBLE,
"n_6" DOUBLE,
"n_7" DOUBLE,
"n_8" DOUBLE
);
CREATE TABLE f3 (
"worm" VARCHAR,
"treatment" VARCHAR,
"parent_no" VARCHAR,
"f2_treat" VARCHAR,
"g_parent_no" VARCHAR,
"f1_treat" VARCHAR,
"g_g_parent_no" VARCHAR,
"f0_treat" VARCHAR,
"worm_order" BIGINT,
"lineage" VARCHAR,
"block" BIGINT,
"set_up" VARCHAR,
"death_date" VARCHAR,
"cause" VARCHAR,
"death" BIGINT,
"observed" BIGINT,
"matricide" BIGINT,
"na_start" DOUBLE,
"total_rep" DOUBLE,
"n_1" DOUBLE,
"n_2" DOUBLE,
"n_3" DOUBLE,
"n_4" DOUBLE,
"n_5" DOUBLE,
"n_6" DOUBLE,
"n_7" DOUBLE,
"n_8" DOUBLE
);
CREATE TABLE p0 (
"worm" BIGINT,
"treatment" VARCHAR,
"founder" BIGINT,
"exp_block" BIGINT,
"setup_date" VARCHAR,
"death_date" VARCHAR,
"cause" VARCHAR,
"death" BIGINT,
"observed" BIGINT,
"matricide" BIGINT,
"total_rep" BIGINT,
"na_start" DOUBLE,
"n_1" DOUBLE,
"n_2" DOUBLE,
"n_3" DOUBLE,
"n_4" DOUBLE,
"n_5" DOUBLE,
"n_6" DOUBLE,
"n_7" DOUBLE,
"n_8" DOUBLE
);
CREATE TABLE wormlength (
"worm" VARCHAR,
"plate" BIGINT,
"measure" BIGINT,
"treatment" VARCHAR,
"length_pixel" DOUBLE,
"length_mm" DOUBLE,
"period" VARCHAR,
"stage" VARCHAR,
"generation" VARCHAR
);
Anyone who has the link will be able to view this.