Data From: Exploring Soil Ecology Gradient Concepts: Sensitivity Of Ecosystem Properties To Symbiotic Fungi In Semiarid Prairie
Department of Agriculture
@usgov.usda_gov_data_from_exploring_soil_ecology_gradient_con_5c5465e8
Department of Agriculture
@usgov.usda_gov_data_from_exploring_soil_ecology_gradient_con_5c5465e8
CREATE TABLE amf_treatments (
"plot" BIGINT,
"block" BIGINT,
"treatment_0_water_only_1_amf_fungicide_2_pathogen_fungicide" BIGINT,
"year" BIGINT
);
CREATE TABLE annex_exper_1_2_2012_shoot_biomass_na (
"n" BIGINT,
"experiment" BIGINT,
"treatment" VARCHAR,
"soil" BIGINT,
"pot" BIGINT,
"spp" VARCHAR,
"shoot" VARCHAR
);
CREATE TABLE annex_experiments_1_2_2012_foliar_nutrients_ver_2 (
"n" BIGINT,
"exper" BIGINT,
"pots" BIGINT,
"treatment" VARCHAR,
"spp" VARCHAR,
"n_02e762" DOUBLE,
"p" DOUBLE,
"k" DOUBLE,
"mg" DOUBLE,
"ca" DOUBLE,
"s" DOUBLE,
"na" DOUBLE,
"fe" BIGINT,
"mn" BIGINT,
"b" BIGINT,
"cu" BIGINT,
"zn" BIGINT,
"np" DOUBLE
);
CREATE TABLE biomass_summary_amf_r (
"n" BIGINT,
"block" BIGINT,
"treatment" BIGINT,
"plot" BIGINT,
"year" BIGINT,
"y" BIGINT,
"biomcac" DOUBLE,
"biom" DOUBLE
);
CREATE TABLE biomass_summary_pathogens_r (
"n" BIGINT,
"block" BIGINT,
"treatment" BIGINT,
"plots" BIGINT,
"year" BIGINT,
"biomcac" DOUBLE,
"biom" DOUBLE
);
CREATE TABLE control_vs_amf (
"n" BIGINT,
"heco" DOUBLE,
"cafi" DOUBLE,
"arfr" DOUBLE,
"koma" DOUBLE,
"pose" DOUBLE,
"lipu" DOUBLE,
"ardr" DOUBLE,
"pasm" DOUBLE,
"brja" DOUBLE,
"arca" BIGINT,
"spco" DOUBLE,
"bogr" DOUBLE,
"trdu" DOUBLE,
"ungr" DOUBLE,
"oppo" DOUBLE,
"arlo" BIGINT,
"pees" DOUBLE,
"chju" DOUBLE,
"navi" DOUBLE,
"ansp" BIGINT,
"unfo" DOUBLE,
"vuoc" DOUBLE,
"rosp" DOUBLE,
"budo" DOUBLE,
"arpu" DOUBLE,
"lodi" DOUBLE,
"depi" DOUBLE,
"cain" BIGINT,
"hehi" DOUBLE,
"esmi" BIGINT,
"plpa" DOUBLE,
"taof" DOUBLE,
"gaco" DOUBLE,
"pear" DOUBLE,
"ascr" DOUBLE,
"phho" DOUBLE,
"ciun" DOUBLE,
"agcr" DOUBLE,
"loar" DOUBLE,
"liri" DOUBLE,
"eras" DOUBLE,
"hasp" DOUBLE,
"poco" BIGINT
);
CREATE TABLE control_vs_path (
"n" BIGINT,
"heco" DOUBLE,
"cafi" DOUBLE,
"arfr" DOUBLE,
"koma" DOUBLE,
"pose" DOUBLE,
"lipu" DOUBLE,
"ardr" DOUBLE,
"pasm" DOUBLE,
"brja" DOUBLE,
"arca" DOUBLE,
"spco" DOUBLE,
"bogr" DOUBLE,
"trdu" DOUBLE,
"ungr" DOUBLE,
"oppo" DOUBLE,
"arlo" BIGINT,
"pees" DOUBLE,
"chju" DOUBLE,
"navi" BIGINT,
"ansp" DOUBLE,
"unfo" DOUBLE,
"vuoc" DOUBLE,
"rosp" BIGINT,
"budo" BIGINT,
"arpu" DOUBLE,
"lodi" DOUBLE,
"depi" BIGINT,
"cain" DOUBLE,
"hehi" DOUBLE,
"esmi" DOUBLE,
"plpa" DOUBLE,
"taof" DOUBLE,
"gaco" DOUBLE,
"pear" DOUBLE,
"ascr" BIGINT,
"phho" DOUBLE,
"ciun" DOUBLE,
"agcr" DOUBLE,
"loar" DOUBLE,
"liri" DOUBLE,
"eras" DOUBLE,
"hasp" BIGINT,
"poco" DOUBLE
);
CREATE TABLE cover_3_spp (
"n" BIGINT,
"plot" BIGINT,
"block" BIGINT,
"treatment" BIGINT,
"experiment" VARCHAR,
"year" BIGINT,
"spp" VARCHAR,
"cover" DOUBLE
);
CREATE TABLE covermaster (
"n" BIGINT,
"plot" BIGINT,
"block" BIGINT,
"treatment" BIGINT,
"experiment" VARCHAR,
"year" BIGINT,
"heco" DOUBLE,
"cafi" DOUBLE,
"arfr" DOUBLE,
"koma" DOUBLE,
"pose" DOUBLE,
"lipu" DOUBLE,
"ardr" DOUBLE,
"pasm" DOUBLE,
"brja" DOUBLE,
"arca" DOUBLE,
"spco" DOUBLE,
"bogr" DOUBLE,
"trdu" DOUBLE,
"ungr" DOUBLE,
"oppo" DOUBLE,
"arlo" BIGINT,
"pees" DOUBLE,
"chju" DOUBLE,
"navi" DOUBLE,
"ansp" DOUBLE,
"unfo" DOUBLE,
"vuoc" DOUBLE,
"rosp" DOUBLE,
"budo" DOUBLE,
"arpu" DOUBLE,
"lodi" DOUBLE,
"depi" DOUBLE,
"cain" DOUBLE,
"hehi" DOUBLE,
"esmi" DOUBLE,
"plpa" DOUBLE,
"taof" DOUBLE,
"gaco" DOUBLE,
"pear" DOUBLE,
"ascr" DOUBLE,
"phho" DOUBLE,
"ciun" DOUBLE,
"agcr" DOUBLE,
"loar" DOUBLE,
"liri" DOUBLE,
"eras" DOUBLE,
"hasp" DOUBLE,
"poco" DOUBLE
);
CREATE TABLE diversity_and_richness_amf_r (
"n" BIGINT,
"plot" BIGINT,
"n__rep" BIGINT,
"treatment" BIGINT,
"year" BIGINT,
"year2" BIGINT,
"rich" BIGINT,
"diversity" DOUBLE
);
CREATE TABLE leaf_nutrients_2010_2013c (
"n" BIGINT,
"subj" BIGINT,
"plot" BIGINT,
"block" BIGINT,
"treatment" BIGINT,
"spp" VARCHAR,
"year" BIGINT,
"np" VARCHAR,
"mn" VARCHAR
);
CREATE TABLE lichen_moss_wsa_amf_r (
"n" BIGINT,
"exp" VARCHAR,
"locatn" VARCHAR,
"plot" BIGINT,
"block" BIGINT,
"treatment" BIGINT,
"infilt" DOUBLE,
"smwsa" DOUBLE,
"medwsa" DOUBLE,
"moss" DOUBLE,
"lichen" DOUBLE
);
CREATE TABLE log_response_ratios_of_cover_data_2010_to_2014_cleaned (
"n" BIGINT,
"block" BIGINT,
"year" BIGINT,
"heco" DOUBLE,
"heco_fun" DOUBLE,
"lrrheco" DOUBLE,
"cafi" DOUBLE,
"cafi_fun" DOUBLE,
"lrrcafi" DOUBLE,
"arfr" DOUBLE,
"arfr_fun" DOUBLE,
"lrrarfr" VARCHAR,
"koma" DOUBLE,
"koma_fun" DOUBLE,
"lrrkoma" DOUBLE,
"pose" DOUBLE,
"pose_fun" DOUBLE,
"lrrpose" VARCHAR,
"ardr" DOUBLE,
"ardr_fun" DOUBLE,
"lrrardr" VARCHAR,
"pasm" DOUBLE,
"pasm_fun" DOUBLE,
"lrrpasm" VARCHAR,
"spco" DOUBLE,
"spco_fun" DOUBLE,
"lrrspco" VARCHAR,
"bogr" DOUBLE,
"bogr_fun" DOUBLE,
"lrrbogr" VARCHAR,
"trdu" DOUBLE,
"trdu_fun" DOUBLE,
"lrrtrdu" VARCHAR,
"oppo" DOUBLE,
"oppo_fun" DOUBLE,
"lrroppo" VARCHAR,
"arpu" DOUBLE,
"arpu_fun" DOUBLE,
"lrrarpu" VARCHAR
);
CREATE TABLE path_treatments (
"plot" BIGINT,
"block" BIGINT,
"treatment_0_water_only_1_amf_fungicide_2_pathogen_fungicide" BIGINT,
"year" BIGINT
);
Anyone who has the link will be able to view this.