Unified Field Study 6 (UFS-6)
Department of Energy
@usgov.doe_gov_unified_field_study_6_ufs_6
Department of Energy
@usgov.doe_gov_unified_field_study_6_ufs_6
The Unified Field Studies (UFS), established by the Algae Testbed Public-Private Partnership (ATP3), produced data on the effect of environmental and process conditions on algal growth rates and algal composition. The goal of the sixth Unified Field Study (UFS-6), performed March to June 2015, was to generate a robust inter-testbed dataset in algal biomass and lipid productivity and yield for Nannochloropsis oceanica KA32 and Chlorella vulgaris LRB-AZ-1201 as a function of different regional and environmental conditions among sites by controlling non-geographical-related variables including production systems, production processes, and protocols. The UFS-6 Experiment consisted of two parts. First, a direct comparison of two dilution rates (0.11 and 0.214 per day) with Chlorella vulgaris LRB-AZ-1201 was performed followed by experimentation on optimal nitrogen sources for Nannochloropsis oceanica KA32.
For more information about the UFS experiments see the reference resources 0.0 UFS-1 Experiment OpenEI Wiki Page, 0.1 ATP3 OpenEI Wiki Page, 0.2 Report on the Use of ATP3 UFS Data below, and 0.3 ATP3 UFS Journal Article.
Organization: Department of Energy
Last updated: 2024-03-12T23:57:15.607494
Tags: algae, algal-biomass, algal-composition, algal-growth, algal-productivities, algal-testbed, analysis, atp3, biochemical, bioenergy, biofuel, biomass, chlorella-vulgaris, cultivation-strategies, cultivation-trials, data, energy, environmental-conditions, fuels, harvest-yields, modeling, nannochloropsis-oceanica, pond, ponds, power, process-conditions, regional, renewable-energy, seasonal, strain, testbed, ufs, unified-field-study
CREATE TABLE n_1_2_ufs_6_ka32_pond_operational_and_harvest_summary_data (
"siteid" VARCHAR,
"experimentid" VARCHAR,
"pondid" VARCHAR,
"datetime" VARCHAR,
"strainid" VARCHAR,
"sourceid" VARCHAR,
"batchid" VARCHAR,
"treatmentid" VARCHAR,
"time_between_harvests_days" VARCHAR,
"harvest" VARCHAR -- Harvest.,
"harvest_vol_l" VARCHAR -- Harvest.Vol..L.,
"afdw_g_l" VARCHAR -- AFDW..g.L.,
"afdw_g" VARCHAR -- AFDW..g.,
"crash" VARCHAR,
"comments" VARCHAR,
"duration_days" VARCHAR,
"depth_cm" VARCHAR,
"evaporation_rate_cm_day" VARCHAR,
"ph" VARCHAR,
"salinity" VARCHAR,
"temp_c" VARCHAR,
"no3_mg_l" VARCHAR,
"no3_pct_rsd" VARCHAR,
"nh4_mg_l" VARCHAR,
"nh4_pct_rsd" VARCHAR,
"p_mg_l" VARCHAR,
"p_pct_rsd" VARCHAR,
"n_p_ratio" VARCHAR,
"analytical_sample_id" VARCHAR,
"tracking_id" VARCHAR,
"dw_g_l" VARCHAR,
"dw_rsd" VARCHAR,
"afdw_g_l_52d579" VARCHAR -- AFDW.g.L,
"afdw_rsd" VARCHAR,
"ash" VARCHAR,
"od750" VARCHAR,
"od750_pct_rsd" VARCHAR,
"od680" VARCHAR,
"od680_pct_rsd" VARCHAR,
"no3_supplied_g" VARCHAR,
"no3_utilized_g" VARCHAR,
"no3_efficiency" VARCHAR -- NO3.efficiency..,
"no3_demand_g_n_g_afdw" VARCHAR,
"nh4_supplied_g" VARCHAR,
"nh4_utilized_g" VARCHAR,
"nh4_efficiency" VARCHAR -- NH4.efficiency..,
"nh4_demand_g_n_g_afdw" VARCHAR,
"p_supplied_g" VARCHAR,
"p_utilized_g" VARCHAR,
"p_efficiency" VARCHAR -- P.efficiency..,
"p_demand_g_p_g_afdw" VARCHAR,
"mg_afdw_mol_par_input" VARCHAR,
"mg_afdw_kw_gle_input" VARCHAR
);CREATE TABLE n_1_3_ufs_6_lrb_az_1201_pond_operational_and_harvest_s_c4a7c881 (
"siteid" VARCHAR,
"experimentid" VARCHAR,
"pondid" VARCHAR,
"datetime" VARCHAR,
"strainid" VARCHAR,
"sourceid" VARCHAR,
"batchid" VARCHAR,
"treatmentid" VARCHAR,
"time_between_harvests_days" VARCHAR,
"harvest" VARCHAR -- Harvest.,
"harvest_vol_l" VARCHAR -- Harvest.Vol..L.,
"afdw_g_l" VARCHAR -- AFDW..g.L.,
"afdw_g" VARCHAR -- AFDW..g.,
"crash" VARCHAR,
"comments" VARCHAR,
"duration_days" VARCHAR,
"depth_cm" VARCHAR,
"evaporation_rate_cm_day" VARCHAR,
"ph" VARCHAR,
"salinity" VARCHAR,
"temp_c" VARCHAR,
"no3_mg_l" VARCHAR,
"no3_pct_rsd" VARCHAR,
"nh4_mg_l" VARCHAR,
"nh4_pct_rsd" VARCHAR,
"p_mg_l" VARCHAR,
"p_pct_rsd" VARCHAR,
"n_p_ratio" VARCHAR,
"analytical_sample_id" VARCHAR,
"tracking_id" VARCHAR,
"dw_g_l" VARCHAR,
"dw_rsd" VARCHAR,
"afdw_g_l_52d579" VARCHAR -- AFDW.g.L,
"afdw_rsd" VARCHAR,
"ash" VARCHAR,
"od750" VARCHAR,
"od750_pct_rsd" VARCHAR,
"od680" VARCHAR,
"od680_pct_rsd" VARCHAR,
"no3_supplied_g" VARCHAR,
"no3_utilized_g" VARCHAR,
"no3_efficiency" VARCHAR -- NO3.efficiency..,
"no3_demand_g_n_g_afdw" VARCHAR,
"nh4_supplied_g" VARCHAR,
"nh4_utilized_g" VARCHAR,
"nh4_efficiency" VARCHAR -- NH4.efficiency..,
"nh4_demand_g_n_g_afdw" VARCHAR,
"p_supplied_g" VARCHAR,
"p_utilized_g" VARCHAR,
"p_efficiency" VARCHAR -- P.efficiency..,
"p_demand_g_p_g_afdw" VARCHAR,
"mg_afdw_mol_par_input" VARCHAR,
"mg_afdw_kw_gle_input" VARCHAR
);CREATE TABLE n_2_2_ufs_6_ka32_harvest_data (
"siteid" VARCHAR,
"experimentid" VARCHAR,
"strainid" VARCHAR,
"sourceid" VARCHAR,
"batchid" VARCHAR,
"date" VARCHAR,
"pondid" VARCHAR,
"treatmentid" VARCHAR,
"harvest" BIGINT -- Harvest.,
"time_d" DOUBLE -- Time..d.,
"harvest_vol_l" DOUBLE -- Harvest.Vol..L.,
"afdw_g_l" DOUBLE -- AFDW..g.L.,
"afdw_g" DOUBLE -- AFDW..g.,
"crash" VARCHAR
);CREATE TABLE n_2_3_ufs_6_lrb_az_1201_harvest_data (
"siteid" VARCHAR,
"experimentid" VARCHAR,
"strainid" VARCHAR,
"sourceid" VARCHAR,
"batchid" VARCHAR,
"date" VARCHAR,
"pondid" VARCHAR,
"treatmentid" VARCHAR,
"harvest" BIGINT -- Harvest.,
"time_d" DOUBLE -- Time..d.,
"harvest_vol_l" DOUBLE -- Harvest.Vol..L.,
"afdw_g_l" DOUBLE -- AFDW..g.L.,
"afdw_g" DOUBLE -- AFDW..g.,
"crash" VARCHAR
);CREATE TABLE n_3_2_ufs_6_ka32_instrumentation_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"pondid" VARCHAR,
"strainid" VARCHAR,
"datetime" VARCHAR,
"date" VARCHAR,
"ph" DOUBLE,
"temp_c" DOUBLE -- Temp (C),
"cond_ms_cm" DOUBLE -- Cond (mS.cm),
"do_mg_l" DOUBLE -- DO (mg.L),
"do_sat" DOUBLE -- DO (%sat),
"sal_g_l" DOUBLE -- Sal (g.L),
"par_umol_m2_s" DOUBLE -- PAR (umol.m2.s)
);CREATE TABLE n_3_3_ufs_6_lrb_az_1201_instrumentation_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"pondid" VARCHAR,
"strainid" VARCHAR,
"datetime" VARCHAR,
"date" VARCHAR,
"ph" DOUBLE,
"temp_c" DOUBLE -- Temp (C),
"cond_ms_cm" DOUBLE -- Cond (mS.cm),
"do_mg_l" DOUBLE -- DO (mg.L),
"do_sat" DOUBLE -- DO (%sat),
"sal_g_l" DOUBLE -- Sal (g.L),
"par_umol_m2_s" DOUBLE -- PAR (umol.m2.s)
);CREATE TABLE n_3_5_ufs_6_ka32_daily_averaged_instrumentation_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"pondid" VARCHAR,
"strainid" VARCHAR,
"date" VARCHAR,
"ph" DOUBLE,
"temp_avg_c" DOUBLE -- Temp.avg (C),
"temp_max_c" DOUBLE -- Temp.max (C),
"temp_min_c" DOUBLE -- Temp.min (C),
"cond_ms_cm" DOUBLE -- Cond (mS.cm),
"do_mg_l" DOUBLE -- DO (mg.L),
"do_sat" DOUBLE -- DO (%sat),
"sal_g_l" DOUBLE -- Sal (g.L),
"par_umol_m2_s" DOUBLE -- PAR (umol.m2.s)
);CREATE TABLE n_3_6_ufs_6_lrb_az_1201_daily_averaged_instrumentation_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"pondid" VARCHAR,
"strainid" VARCHAR,
"date" VARCHAR,
"ph" DOUBLE,
"temp_avg_c" DOUBLE -- Temp.avg (C),
"temp_max_c" DOUBLE -- Temp.max (C),
"temp_min_c" DOUBLE -- Temp.min (C),
"cond_ms_cm" DOUBLE -- Cond (mS.cm),
"do_mg_l" DOUBLE -- DO (mg.L),
"do_sat" DOUBLE -- DO (%sat),
"sal_g_l" DOUBLE -- Sal (g.L),
"par_umol_m2_s" DOUBLE -- PAR (umol.m2.s)
);CREATE TABLE n_4_2_ufs_6_ka32_weather_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"strainid" VARCHAR,
"date" VARCHAR,
"airtemp_c" DOUBLE -- AirTemp(C),
"rh" DOUBLE -- RH(%),
"globallightenergy_w_m2" DOUBLE -- GlobalLightEnergy(W.m2),
"windspeed_km_hr" DOUBLE -- WindSpeed(km.hr),
"wdir_deg" DOUBLE -- WDir(deg)
);CREATE TABLE n_4_3_ufs_6_lrb_az_1201_weather_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"strainid" VARCHAR,
"date" VARCHAR,
"airtemp_c" DOUBLE -- AirTemp(C),
"rh" DOUBLE -- RH(%),
"globallightenergy_w_m2" DOUBLE -- GlobalLightEnergy(W.m2),
"windspeed_km_hr" DOUBLE -- WindSpeed(km.hr),
"wdir_deg" DOUBLE -- WDir(deg)
);CREATE TABLE n_4_5_ufs_6_ka32_daily_averaged_weather_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"strainid" VARCHAR,
"date" VARCHAR,
"airtemp_c" DOUBLE -- AirTemp(C),
"rh" DOUBLE -- RH(%),
"globallightenergy_w_m2" DOUBLE -- GlobalLightEnergy(W.m2),
"windspeed_km_hr" DOUBLE -- WindSpeed(km.hr),
"wdir_deg" DOUBLE -- WDir(deg),
"precip_tot_cm" DOUBLE -- Precip.tot(cm)
);CREATE TABLE n_4_6_ufs_6_lrb_az_1201_daily_averaged_weather_data (
"experimentid" VARCHAR,
"siteid" VARCHAR,
"strainid" VARCHAR,
"date" VARCHAR,
"airtemp_c" DOUBLE -- AirTemp(C),
"rh" DOUBLE -- RH(%),
"globallightenergy_w_m2" DOUBLE -- GlobalLightEnergy(W.m2),
"windspeed_km_hr" DOUBLE -- WindSpeed(km.hr),
"wdir_deg" DOUBLE -- WDir(deg),
"precip_tot_cm" DOUBLE -- Precip.tot(cm)
);Anyone who has the link will be able to view this.