About this Dataset

Development Of Integrated Screening, Cultivar Optimization, And Verification Research (DISCOVR)

The objective of the DISCOVR consortia is to develop an integrated algae strain screening platform for the discovery of high-productivity and resilient strains of algae that can be cultivated outdoors year-round via crop rotation. The data includes annual weather data, algae cultivation composition data, and pond water chemistry data between 2018 and 2021. This year-over-year cultivation data provides the underlying data in direct support of the annual State of Technology (SOT) analysis effort. These field experimental data and SOT reports are of interest to the U.S. Department of Energys (DOE) Energy Efficiency and Renewable Energys (EERE) Bioenergy Technologies office (BETO) in understanding current best algae agronomic practices in demonstrating progress towards future algae biomass productivity goals as outlined in the BETO Multi-Year Program Plan.
Organization: Department of Energy
Last updated: 2022-04-26T23:18:12.905896
Tags: algae, algae-cultivation, algae-strain-screening, alternative-fuel, bioenergy, biofuel, chemistry, composition, crop-rotation, cultivation, data, energy, outdoor-cultivation, pond-water, power, raw-data, sot, weather

Tables

DISCOVR SOT Cultivation Composition 2020

@usgov.doe_gov_discovr.discovr_sot_cultivation_composition_2020

683.71 kB
6,117 rows
130 columns

CREATE TABLE discovr_sot_cultivation_composition_2020 (
  "datetime" TIMESTAMP,
  "pondid" VARCHAR,
  "siteid" VARCHAR,
  "sot_year" BIGINT,
  "sot_season" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "experiment_duration_days" DOUBLE  -- Experiment.Duration..Days.,
  "treatmentid" VARCHAR,
  "harvest_number" VARCHAR,
  "days_between_harvest_days" VARCHAR  -- Days.Between.Harvest..days.,
  "depth_at_sampling_cm" VARCHAR  -- Depth.at.sampling..cm.,
  "pond_depth_after_harvest_cm" VARCHAR  -- Pond.Depth.After.Harvest..cm.,
  "estimated_volume_harvested_l" VARCHAR  -- Estimated.Volume.Harvested..L.,
  "concentration_at_harvest_g_l_afdw" VARCHAR  -- Concentration.at.Harvest..g.L.AFDW.,
  "estimated_biomass_harvested_g" VARCHAR  -- Estimated.Biomass.Harvested..g.,
  "x_volume_harvested" VARCHAR  -- X..Volume.Harvested,
  "x_change_in_od_after_harvest" VARCHAR  -- X..Change.in.OD.after.Harvest,
  "x_change_in_afdw_after_harvest" VARCHAR  -- X..Change.in.AFDW.after.Harvest,
  "pond_crash" VARCHAR,
  "please_use_this_to_note_what_is_happening_in_the_ponds_101c6e76" VARCHAR  -- Please.use.this.column.to.note.what.is.happening.in.the.ponds.from.a.harvest.and.or.contamination.perspective,
  "ahyp_all_ponds" VARCHAR,
  "ahyp_h2h_all_ponds" VARCHAR  -- AHYP.H2H..all.ponds,
  "dw_ave" VARCHAR,
  "dw_stdev" VARCHAR,
  "dw_rsd" VARCHAR  -- DW..RSD,
  "afdw_ave" VARCHAR,
  "afdw_stdev" VARCHAR,
  "afdw_rsd" VARCHAR  -- AFDW..RSD,
  "x_ash_ave" VARCHAR  -- X..ASH.AVE,
  "asp_all_ponds" VARCHAR  -- ASP........all.ponds,
  "od750_ave" VARCHAR,
  "od750_rsd" VARCHAR  -- OD750..RSD,
  "od680_ave" VARCHAR,
  "od680_rsd" VARCHAR  -- OD680..RSD,
  "od750_680_ratio" VARCHAR,
  "week_of_year" BIGINT,
  "event" VARCHAR,
  "duration_per_event_days" VARCHAR  -- Duration.per.Event..Days.,
  "trackingid" VARCHAR,
  "nh4_ave" VARCHAR,
  "nh4_stdev" VARCHAR,
  "nh4_rsd" VARCHAR  -- NH4..RSD,
  "ph" VARCHAR,
  "salinity_g_l" VARCHAR  -- Salinity..g.L.,
  "pond_temp_c" VARCHAR  -- Pond.Temp..C.,
  "po4_ave" VARCHAR,
  "po4_stdev" VARCHAR,
  "po4_rsd" VARCHAR  -- PO4..RSD,
  "n_p_ratio" VARCHAR,
  "depth_cm" VARCHAR  -- Depth..cm.,
  "daily_evaporation" VARCHAR,
  "analyticalid" VARCHAR,
  "freeze_dried_biomass_for_analytical_g" VARCHAR,
  "ash" VARCHAR,
  "fame" VARCHAR,
  "protein" VARCHAR,
  "carbohydrates" VARCHAR,
  "sum" VARCHAR,
  "replicates" VARCHAR,
  "manitol" VARCHAR,
  "fucose" VARCHAR,
  "rhamose" VARCHAR,
  "galactosamine" VARCHAR,
  "arabinose" VARCHAR,
  "glucosamine" VARCHAR,
  "galactose" VARCHAR,
  "glucose" VARCHAR,
  "manose" VARCHAR,
  "xylose" VARCHAR,
  "ribose" VARCHAR,
  "total_carbohydrates" VARCHAR,
  "total_carbohydrates_stdev" VARCHAR,
  "percent_carbon" VARCHAR,
  "percent_hydrogen" VARCHAR,
  "percent_nitrogen" VARCHAR,
  "percent_protein" VARCHAR,
  "mean_fame" VARCHAR,
  "fame_stdev" VARCHAR,
  "fame_rsd" VARCHAR,
  "replicate" VARCHAR,
  "c8_0" VARCHAR,
  "c10_0" VARCHAR,
  "c12_0" VARCHAR,
  "c14_0" VARCHAR,
  "c14_1" VARCHAR,
  "c15_0" VARCHAR,
  "c16_0" VARCHAR,
  "c16_1_n11" VARCHAR,
  "c16_1n9" VARCHAR,
  "c16_1n7" VARCHAR,
  "c16_1n6" VARCHAR,
  "c16_n5" VARCHAR,
  "c16_unknown" VARCHAR  -- C16..Unknown,
  "c16_2" VARCHAR,
  "c17_0" VARCHAR,
  "c16_3" VARCHAR,
  "c16_3_1" VARCHAR,
  "c17_1" VARCHAR,
  "c16_4" VARCHAR
);

DISCOVR SOT Cultivation Composition 2021

@usgov.doe_gov_discovr.discovr_sot_cultivation_composition_2021

368.76 kB
3,068 rows
72 columns

CREATE TABLE discovr_sot_cultivation_composition_2021 (
  "analyticalid" VARCHAR,
  "datetime" TIMESTAMP,
  "pondid" VARCHAR,
  "siteid" VARCHAR,
  "sot_year" BIGINT,
  "sot_season" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "experiment_duration_days" DOUBLE  -- Experiment.Duration..Days.,
  "treatmentid" VARCHAR,
  "harvest_number" VARCHAR,
  "days_between_harvest_days" VARCHAR  -- Days.Between.Harvest..days.,
  "depth_at_sampling_cm" VARCHAR  -- Depth.at.sampling..cm.,
  "pond_depth_after_harvest_cm" VARCHAR  -- Pond.Depth.After.Harvest..cm.,
  "estimated_volume_harvested_l" VARCHAR  -- Estimated.Volume.Harvested..L.,
  "concentration_at_harvest_g_l_afdw" VARCHAR  -- Concentration.at.Harvest..g.L.AFDW.,
  "estimated_biomass_harvested_g" VARCHAR  -- Estimated.Biomass.Harvested..g.,
  "x_volume_harvested" VARCHAR  -- X..Volume.Harvested,
  "x_change_in_od_after_harvest" VARCHAR  -- X..Change.in.OD.after.Harvest,
  "x_change_in_afdw_after_harvest" VARCHAR  -- X..Change.in.AFDW.after.Harvest,
  "pond_crash" VARCHAR,
  "please_use_this_to_note_what_is_happening_in_the_ponds_101c6e76" VARCHAR  -- Please.use.this.column.to.note.what.is.happening.in.the.ponds.from.a.harvest.and.or.contamination.perspective,
  "ahyp_all_ponds" VARCHAR,
  "ahyp_h2h_all_ponds" VARCHAR  -- AHYP.H2H..all.ponds,
  "dw_ave" VARCHAR,
  "dw_stdev" VARCHAR,
  "dw_rsd" VARCHAR  -- DW..RSD,
  "afdw_ave" VARCHAR,
  "afdw_stdev" VARCHAR,
  "afdw_rsd" VARCHAR  -- AFDW..RSD,
  "x_ash_ave" VARCHAR  -- X..ASH.AVE,
  "asp_all_ponds" VARCHAR  -- ASP........all.ponds,
  "od750_ave" VARCHAR,
  "od750_rsd" VARCHAR  -- OD750..RSD,
  "od680_ave" VARCHAR,
  "od680_rsd" VARCHAR  -- OD680..RSD,
  "od750_680_ratio" VARCHAR,
  "week_of_year" BIGINT,
  "event" VARCHAR,
  "duration_per_event_days" VARCHAR  -- Duration.per.Event..Days.,
  "trackingid" VARCHAR,
  "freeze_dried_biomass_for_analytical_g" VARCHAR  -- Freeze.dried.biomass.for.analytical..g.,
  "nh4_ave" VARCHAR,
  "nh4_stdev" VARCHAR,
  "nh4_rsd" VARCHAR  -- NH4..RSD,
  "ph" VARCHAR,
  "salinity_g_l" VARCHAR  -- Salinity..g.L.,
  "pond_temp_c" VARCHAR  -- Pond.Temp..C.,
  "po4_ave" VARCHAR,
  "po4_stdev" VARCHAR,
  "po4_rsd" VARCHAR  -- PO4..RSD,
  "n_p_ratio" VARCHAR,
  "depth_cm" VARCHAR  -- Depth..cm.,
  "daily_evaporation" VARCHAR,
  "no3_rsd" VARCHAR,
  "no3_ave" VARCHAR,
  "no3_stdev" VARCHAR,
  "ash" VARCHAR,
  "fame" VARCHAR,
  "protein" VARCHAR,
  "carbs" VARCHAR,
  "sum" VARCHAR,
  "c" VARCHAR,
  "h" VARCHAR,
  "n" VARCHAR,
  "carbs_ashfree" VARCHAR,
  "fame_ashfree" VARCHAR,
  "protein_ashfree" VARCHAR,
  "c_ashfree" VARCHAR,
  "h_ashfree" VARCHAR,
  "n_ashfree" VARCHAR,
  "mass_balance" VARCHAR
);

DISCOVR SOT Weather 2018

@usgov.doe_gov_discovr.discovr_sot_weather_2018

830.85 kB
54,769 rows
11 columns

CREATE TABLE discovr_sot_weather_2018 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" TIMESTAMP,
  "airtemp_oc" VARCHAR  -- AIRTEMP (oC),
  "humid_rh" VARCHAR  -- HUMID (RH %),
  "global_light_energy_w_m2" VARCHAR  -- Global Light Energy (W/m2),
  "wddir_degrees" VARCHAR  -- WDDIR (degrees),
  "hobo_par" VARCHAR,
  "precip_mm" VARCHAR  -- PRECIP (mm),
  "wdspd_m_s" VARCHAR  -- WDSPD (m/s)
);

DISCOVR SOT Weather 2019

@usgov.doe_gov_discovr.discovr_sot_weather_2019

1.64 MB
123,230 rows
11 columns

CREATE TABLE discovr_sot_weather_2019 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" TIMESTAMP,
  "airtemp_oc" DOUBLE  -- AIRTEMP (oC),
  "humid_rh" DOUBLE  -- HUMID (RH %),
  "global_light_energy_w_m2" BIGINT  -- Global Light Energy (W/m2),
  "wddir_degrees" BIGINT  -- WDDIR (degrees),
  "hobo_par" BIGINT,
  "precip_mm" DOUBLE  -- PRECIP (mm),
  "wdspd_m_s" DOUBLE  -- WDSPD (m/s)
);

DISCOVR SOT Weather 2020

@usgov.doe_gov_discovr.discovr_sot_weather_2020

2.65 MB
226,856 rows
11 columns

CREATE TABLE discovr_sot_weather_2020 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" TIMESTAMP,
  "airtemp_oc" VARCHAR  -- AIRTEMP (oC),
  "humid_rh" DOUBLE  -- HUMID (RH %),
  "global_light_energy_w_m2" DOUBLE  -- Global Light Energy (W/m2),
  "wddir_degrees" VARCHAR  -- WDDIR (degrees),
  "hobo_par" VARCHAR,
  "precip_mm" DOUBLE  -- PRECIP (mm),
  "wdspd_m_s" DOUBLE  -- WDSPD (m/s)
);

DISCOVR SOT Weather 2021

@usgov.doe_gov_discovr.discovr_sot_weather_2021

2.81 MB
116,864 rows
19 columns

CREATE TABLE discovr_sot_weather_2021 (
  "experimentid" VARCHAR,
  "siteid" VARCHAR,
  "datetime" TIMESTAMP,
  "rain_mm" DOUBLE,
  "par_ue" DOUBLE,
  "air_temp_c" DOUBLE  -- Air Temp *C,
  "rh" DOUBLE  -- RH %,
  "dew_point_c" VARCHAR  -- Dew Point *C,
  "wind_speed_m_s" DOUBLE,
  "gust_speed_m_s" DOUBLE,
  "solar_radiation_w_m_2" DOUBLE,
  "wind_direction" DOUBLE  -- Wind Direction *,
  "day_of_year" DOUBLE,
  "week" BIGINT,
  "cy" BIGINT,
  "day" BIGINT,
  "date" TIMESTAMP,
  "month" BIGINT,
  "unnamed_18" VARCHAR  -- Unnamed: 18
);

DISCOVR SOT YSI 2018

@usgov.doe_gov_discovr.discovr_sot_ysi_2018

3.11 MB
133,196 rows
13 columns

CREATE TABLE discovr_sot_ysi_2018 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "pondid" VARCHAR,
  "datetime" TIMESTAMP,
  "ph" VARCHAR,
  "orp_mv" VARCHAR  -- ORP (mV),
  "temperature_oc" VARCHAR  -- Temperature (oC),
  "conductivity_ms_cm" VARCHAR  -- Conductivity (mS/cm),
  "dissolved_oxygen_mg_l" VARCHAR  -- Dissolved Oxygen (mg/L),
  "oxygen_sat" VARCHAR  -- Oxygen Sat%,
  "salinity_g_l" VARCHAR  -- Salinity (g/L),
  "par_umol_photons_m2_s" VARCHAR  -- PAR (umol Photons/m2 S)
);

DISCOVR SOT YSI 2019

@usgov.doe_gov_discovr.discovr_sot_ysi_2019

3.84 MB
175,479 rows
13 columns

CREATE TABLE discovr_sot_ysi_2019 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "pondid" VARCHAR,
  "datetime" TIMESTAMP,
  "ph" VARCHAR,
  "orp_mv" VARCHAR  -- ORP (mV),
  "temperature_oc" VARCHAR  -- Temperature (oC),
  "conductivity_ms_cm" VARCHAR  -- Conductivity (mS/cm),
  "dissolved_oxygen_mg_l" VARCHAR  -- Dissolved Oxygen (mg/L),
  "oxygen_sat" VARCHAR  -- Oxygen Sat%,
  "salinity_g_l" VARCHAR  -- Salinity (g/L),
  "par_umol_photons_m2_s" VARCHAR  -- PAR (umol Photons/m2 S)
);

DISCOVR SOT YSI 2020

@usgov.doe_gov_discovr.discovr_sot_ysi_2020

4.76 MB
258,927 rows
13 columns

CREATE TABLE discovr_sot_ysi_2020 (
  "siteid" VARCHAR,
  "experimentid" VARCHAR,
  "strainid" VARCHAR,
  "pondid" VARCHAR,
  "datetime" VARCHAR,
  "ph" VARCHAR,
  "orp_mv" VARCHAR  -- ORP (mV),
  "temperature_oc" VARCHAR  -- Temperature (oC),
  "conductivity_ms_cm" VARCHAR  -- Conductivity (mS/cm),
  "dissolved_oxygen_mg_l" VARCHAR  -- Dissolved Oxygen (mg/L),
  "oxygen_sat" VARCHAR  -- Oxygen Sat%,
  "salinity_g_l" VARCHAR  -- Salinity (g/L),
  "par_umol_photons_m2_s" VARCHAR  -- PAR (umol Photons/m2 S)
);

DISCOVR SOT YSI 2021

@usgov.doe_gov_discovr.discovr_sot_ysi_2021

2.66 MB
132,263 rows
12 columns

CREATE TABLE discovr_sot_ysi_2021 (
  "pondid" VARCHAR,
  "strainid" VARCHAR,
  "datetime" VARCHAR,
  "ph" VARCHAR,
  "orp_mv" VARCHAR  -- ORP (mV),
  "temperature_oc" VARCHAR  -- Temperature (oC),
  "conductivity_ms_cm" VARCHAR  -- Conductivity (mS/cm),
  "dissolved_oxygen_mg_l" VARCHAR  -- Dissolved Oxygen (mg/L),
  "oxygen_sat" VARCHAR  -- Oxygen Sat%,
  "salinity_g_l" VARCHAR  -- Salinity (g/L),
  "experimentid" VARCHAR,
  "siteid" VARCHAR
);