List the field names that are available from the ECOTOX database
Source:R/database_access.r
list_ecotox_fields.Rd![[Stable]](figures/lifecycle-stable.svg)
List the field names (table headers) that are available from the ECOTOX database
Usage
list_ecotox_fields(
which = c("default", "extended", "full", "all"),
include_table = TRUE
)Arguments
- which
A
characterstring that specifies which fields to return. Can be any of: 'default': returns default output field names; 'all': returns all fields; 'extended': returns all fields of the default tables; or 'full': returns all fields except those from tables 'chemical_carriers', 'media_characteristics', 'doses', 'dose_responses', 'dose_response_details', 'dose_response_links' and 'dose_stat_method_codes'.- include_table
A
logicalvalue indicating whether the table name should be included as prefix. Default isTRUE.
Details
This can be useful when specifying a search_ecotox(), to identify which fields
are available from the database, for searching and output.
Not that when requesting 'all' fields, you will get all fields available from the
latest EPA release of the ECOTOX database. This means that not necessarily all
fields are available in your local build of the database.
Examples
## Fields that are included in search results by default:
list_ecotox_fields("default")
#> [1] "tests.test_cas"
#> [2] "tests.test_grade"
#> [3] "tests.test_grade_comments"
#> [4] "tests.test_purity_mean_op"
#> [5] "tests.test_purity_mean"
#> [6] "tests.test_purity_min_op"
#> [7] "tests.test_purity_min"
#> [8] "tests.test_purity_max_op"
#> [9] "tests.test_purity_max"
#> [10] "tests.test_purity_comments"
#> [11] "tests.organism_lifestage"
#> [12] "tests.organism_age_mean_op"
#> [13] "tests.organism_age_mean"
#> [14] "tests.organism_age_min_op"
#> [15] "tests.organism_age_min"
#> [16] "tests.organism_age_max_op"
#> [17] "tests.organism_age_max"
#> [18] "tests.exposure_duration_mean_op"
#> [19] "tests.exposure_duration_mean"
#> [20] "tests.exposure_duration_min_op"
#> [21] "tests.exposure_duration_min"
#> [22] "tests.exposure_duration_max_op"
#> [23] "tests.exposure_duration_max"
#> [24] "tests.test_location"
#> [25] "tests.exposure_type"
#> [26] "tests.media_type"
#> [27] "tests.num_doses_mean_op"
#> [28] "tests.num_doses_mean"
#> [29] "tests.num_doses_min_op"
#> [30] "tests.num_doses_min"
#> [31] "tests.num_doses_max_op"
#> [32] "tests.num_doses_max"
#> [33] "dose_responses.response_site"
#> [34] "references.reference_type"
#> [35] "references.author"
#> [36] "references.title"
#> [37] "references.source"
#> [38] "references.publication_year"
#> [39] "references.doi"
#> [40] "results.endpoint"
#> [41] "results.effect"
#> [42] "results.measurement"
#> [43] "results.conc1_mean_op"
#> [44] "results.conc1_mean"
#> [45] "results.conc1_min_op"
#> [46] "results.conc1_min"
#> [47] "results.conc1_max_op"
#> [48] "results.conc1_max"
#> [49] "results.conc1_unit"
#> [50] "results.conc1_comments"
#> [51] "results.conc2_type"
#> [52] "results.conc2_mean_op"
#> [53] "results.conc2_mean"
#> [54] "results.conc2_min_op"
#> [55] "results.conc2_min"
#> [56] "results.conc2_max_op"
#> [57] "results.conc2_max"
#> [58] "results.conc2_unit"
#> [59] "results.conc2_comments"
#> [60] "results.conc3_type"
#> [61] "results.conc3_mean_op"
#> [62] "results.conc3_mean"
#> [63] "results.conc3_min_op"
#> [64] "results.conc3_min"
#> [65] "results.conc3_max_op"
#> [66] "results.conc3_max"
#> [67] "results.conc3_unit"
#> [68] "results.conc3_comments"
#> [69] "results.bcf1_mean_op"
#> [70] "results.bcf1_mean"
#> [71] "results.bcf1_min_op"
#> [72] "results.bcf1_min"
#> [73] "results.bcf1_max_op"
#> [74] "results.bcf1_max"
#> [75] "results.bcf1_unit"
#> [76] "results.bcf1_comments"
#> [77] "results.bcf2_mean_op"
#> [78] "results.bcf2_mean"
#> [79] "results.bcf2_min_op"
#> [80] "results.bcf2_min"
#> [81] "results.bcf2_max_op"
#> [82] "results.bcf2_max"
#> [83] "results.bcf2_unit"
#> [84] "results.bcf2_comments"
#> [85] "results.bcf3_mean_op"
#> [86] "results.bcf3_mean"
#> [87] "results.bcf3_min_op"
#> [88] "results.bcf3_min"
#> [89] "results.bcf3_max_op"
#> [90] "results.bcf3_max"
#> [91] "results.bcf3_unit"
#> [92] "results.chem_analysis_method"
#> [93] "results.chem_analysis_method_comments"
#> [94] "species.species_number"
#> [95] "species.common_name"
#> [96] "species.latin_name"
#> [97] "species.ecotox_group"
#> [98] "chemicals.cas_number"
#> [99] "chemicals.chemical_name"
## All fields that are available from the ECOTOX database:
list_ecotox_fields("all")
#> [1] "chemical_carriers.carrier_id"
#> [2] "chemical_carriers.test_id"
#> [3] "chemical_carriers.cas_number"
#> [4] "chemical_carriers.chem_name"
#> [5] "chemical_carriers.purpose"
#> [6] "chemical_carriers.grade"
#> [7] "chemical_carriers.grade_comments"
#> [8] "chemical_carriers.formulation"
#> [9] "chemical_carriers.formulation_comments"
#> [10] "chemical_carriers.radiolabel"
#> [11] "chemical_carriers.radiolabel_comments"
#> [12] "chemical_carriers.purity_mean_op"
#> [13] "chemical_carriers.purity_mean"
#> [14] "chemical_carriers.purity_min_op"
#> [15] "chemical_carriers.purity_min"
#> [16] "chemical_carriers.purity_max_op"
#> [17] "chemical_carriers.purity_max"
#> [18] "chemical_carriers.purity_comments"
#> [19] "chemical_carriers.characteristics"
#> [20] "tests.test_id"
#> [21] "tests.reference_number"
#> [22] "tests.test_cas"
#> [23] "tests.test_grade"
#> [24] "tests.test_grade_comments"
#> [25] "tests.test_formulation"
#> [26] "tests.test_formulation_comments"
#> [27] "tests.test_radiolabel"
#> [28] "tests.test_radiolabel_comments"
#> [29] "tests.test_purity_mean_op"
#> [30] "tests.test_purity_mean"
#> [31] "tests.test_purity_min_op"
#> [32] "tests.test_purity_min"
#> [33] "tests.test_purity_max_op"
#> [34] "tests.test_purity_max"
#> [35] "tests.test_purity_comments"
#> [36] "tests.test_characteristics"
#> [37] "tests.species_number"
#> [38] "tests.organism_habitat"
#> [39] "tests.organism_source"
#> [40] "tests.organism_source_comments"
#> [41] "tests.organism_lifestage"
#> [42] "tests.organism_lifestage_comments"
#> [43] "tests.organism_age_mean_op"
#> [44] "tests.organism_age_mean"
#> [45] "tests.organism_age_min_op"
#> [46] "tests.organism_age_min"
#> [47] "tests.organism_age_max_op"
#> [48] "tests.organism_age_max"
#> [49] "tests.organism_age_unit"
#> [50] "tests.organism_init_wt_mean_op"
#> [51] "tests.organism_init_wt_mean"
#> [52] "tests.organism_init_wt_min_op"
#> [53] "tests.organism_init_wt_min"
#> [54] "tests.organism_init_wt_max_op"
#> [55] "tests.organism_init_wt_max"
#> [56] "tests.organism_init_wt_unit"
#> [57] "tests.organism_characteristics"
#> [58] "tests.organism_gender"
#> [59] "tests.organism_length_mean_op"
#> [60] "tests.organism_length_mean"
#> [61] "tests.organism_length_min_op"
#> [62] "tests.organism_length_min"
#> [63] "tests.organism_length_max_op"
#> [64] "tests.organism_length_max"
#> [65] "tests.organism_length_unit"
#> [66] "tests.organism_length_type"
#> [67] "tests.organism_strain"
#> [68] "tests.experimental_design"
#> [69] "tests.study_duration_mean_op"
#> [70] "tests.study_duration_mean"
#> [71] "tests.study_duration_min_op"
#> [72] "tests.study_duration_min"
#> [73] "tests.study_duration_max_op"
#> [74] "tests.study_duration_max"
#> [75] "tests.study_duration_unit"
#> [76] "tests.study_duration_comments"
#> [77] "tests.exposure_duration_mean_op"
#> [78] "tests.exposure_duration_mean"
#> [79] "tests.exposure_duration_min_op"
#> [80] "tests.exposure_duration_min"
#> [81] "tests.exposure_duration_max_op"
#> [82] "tests.exposure_duration_max"
#> [83] "tests.exposure_duration_unit"
#> [84] "tests.exposure_duration_comments"
#> [85] "tests.study_type"
#> [86] "tests.study_type_comments"
#> [87] "tests.test_type"
#> [88] "tests.test_type_comments"
#> [89] "tests.test_location"
#> [90] "tests.test_location_comments"
#> [91] "tests.test_method"
#> [92] "tests.test_method_comments"
#> [93] "tests.exposure_type"
#> [94] "tests.exposure_type_comments"
#> [95] "tests.control_type"
#> [96] "tests.control_type_comments"
#> [97] "tests.media_type"
#> [98] "tests.media_type_comments"
#> [99] "tests.num_doses_mean_op"
#> [100] "tests.num_doses_mean"
#> [101] "tests.num_doses_min_op"
#> [102] "tests.num_doses_min"
#> [103] "tests.num_doses_max_op"
#> [104] "tests.num_doses_max"
#> [105] "tests.num_doses_comments"
#> [106] "tests.other_effect_comments"
#> [107] "tests.application_freq_mean_op"
#> [108] "tests.application_freq_mean"
#> [109] "tests.application_freq_min_op"
#> [110] "tests.application_freq_min"
#> [111] "tests.application_freq_max_op"
#> [112] "tests.application_freq_max"
#> [113] "tests.application_freq_unit"
#> [114] "tests.application_freq_comments"
#> [115] "tests.application_type"
#> [116] "tests.application_type_comments"
#> [117] "tests.application_rate"
#> [118] "tests.application_rate_unit"
#> [119] "tests.application_date"
#> [120] "tests.application_date_comments"
#> [121] "tests.application_season"
#> [122] "tests.application_season_comments"
#> [123] "tests.subhabitat"
#> [124] "tests.subhabitat_description"
#> [125] "tests.substrate"
#> [126] "tests.substrate_description"
#> [127] "tests.water_depth_mean_op"
#> [128] "tests.water_depth_mean"
#> [129] "tests.water_depth_min_op"
#> [130] "tests.water_depth_min"
#> [131] "tests.water_depth_max_op"
#> [132] "tests.water_depth_max"
#> [133] "tests.water_depth_unit"
#> [134] "tests.water_depth_comments"
#> [135] "tests.geographic_code"
#> [136] "tests.geographic_location"
#> [137] "tests.latitude"
#> [138] "tests.longitude"
#> [139] "tests.halflife_mean_op"
#> [140] "tests.halflife_mean"
#> [141] "tests.halflife_min_op"
#> [142] "tests.halflife_min"
#> [143] "tests.halflife_max_op"
#> [144] "tests.halflife_max"
#> [145] "tests.halflife_unit"
#> [146] "tests.halflife_comments"
#> [147] "tests.additional_comments"
#> [148] "tests.created_date"
#> [149] "tests.modified_date"
#> [150] "tests.published_date"
#> [151] "dose_response_details.dose_resp_detail_id"
#> [152] "dose_response_details.dose_resp_id"
#> [153] "dose_response_details.dose_id"
#> [154] "dose_response_details.response_mean_op"
#> [155] "dose_response_details.response_mean"
#> [156] "dose_response_details.response_min_op"
#> [157] "dose_response_details.response_min"
#> [158] "dose_response_details.response_max_op"
#> [159] "dose_response_details.response_max"
#> [160] "dose_response_details.statistical_method"
#> [161] "dose_response_details.statistical_method_comments"
#> [162] "dose_response_details.response_stat_value"
#> [163] "dose_response_details.response_stat_value_comments"
#> [164] "dose_response_details.sample_size_mean_op"
#> [165] "dose_response_details.sample_size_mean"
#> [166] "dose_response_details.sample_size_min_op"
#> [167] "dose_response_details.sample_size_min"
#> [168] "dose_response_details.sample_size_max_op"
#> [169] "dose_response_details.sample_size_max"
#> [170] "dose_response_details.significance_code"
#> [171] "dose_response_details.significance_type"
#> [172] "dose_response_details.significance_level_mean_op"
#> [173] "dose_response_details.significance_level_mean"
#> [174] "dose_response_details.significance_level_min_op"
#> [175] "dose_response_details.significance_level_min"
#> [176] "dose_response_details.significance_level_max_op"
#> [177] "dose_response_details.significance_level_max"
#> [178] "dose_response_details.significance_comments"
#> [179] "dose_response_details.chem_analysis_method"
#> [180] "dose_response_details.chem_analysis_method_comments"
#> [181] "dose_response_details.dry_wet"
#> [182] "dose_response_details.dry_wet_pct_mean_op"
#> [183] "dose_response_details.dry_wet_pct_mean"
#> [184] "dose_response_details.dry_wet_pct_min_op"
#> [185] "dose_response_details.dry_wet_pct_min"
#> [186] "dose_response_details.dry_wet_pct_max_op"
#> [187] "dose_response_details.dry_wet_pct_max"
#> [188] "dose_response_details.dry_wet_pct_comments"
#> [189] "dose_response_details.lipid_pct_mean_op"
#> [190] "dose_response_details.lipid_pct_mean"
#> [191] "dose_response_details.lipid_pct_min_op"
#> [192] "dose_response_details.lipid_pct_min"
#> [193] "dose_response_details.lipid_pct_max_op"
#> [194] "dose_response_details.lipid_pct_max"
#> [195] "dose_response_details.lipid_pct_comments"
#> [196] "dose_response_details.dose_resp_detail_comment"
#> [197] "dose_response_links.dose_resp_link_id"
#> [198] "dose_response_links.result_id"
#> [199] "dose_response_links.dose_resp_id"
#> [200] "dose_responses.dose_resp_id"
#> [201] "dose_responses.test_id"
#> [202] "dose_responses.sample_size_unit"
#> [203] "dose_responses.sample_size_comments"
#> [204] "dose_responses.effect_code"
#> [205] "dose_responses.measurement_code"
#> [206] "dose_responses.measurement_comments"
#> [207] "dose_responses.response_site"
#> [208] "dose_responses.response_site_comments"
#> [209] "dose_responses.obs_duration_mean_op"
#> [210] "dose_responses.obs_duration_mean"
#> [211] "dose_responses.obs_duration_min_op"
#> [212] "dose_responses.obs_duration_min"
#> [213] "dose_responses.obs_duration_max_op"
#> [214] "dose_responses.obs_duration_max"
#> [215] "dose_responses.obs_duration_unit"
#> [216] "dose_responses.obs_duration_comments"
#> [217] "dose_responses.response_unit"
#> [218] "dose_responses.response_comments"
#> [219] "dose_responses.additional_comments"
#> [220] "doses.dose_id"
#> [221] "doses.test_id"
#> [222] "doses.dose_number"
#> [223] "doses.dose_conc_unit"
#> [224] "doses.dose_comments"
#> [225] "doses.control_type"
#> [226] "doses.number_organisms_mean_op"
#> [227] "doses.number_organisms_mean"
#> [228] "doses.number_organisms_min_op"
#> [229] "doses.number_organisms_min"
#> [230] "doses.number_organisms_max_op"
#> [231] "doses.number_organisms_max"
#> [232] "doses.number_replicates"
#> [233] "doses.dose1_conc_type"
#> [234] "doses.dose1_mean_op"
#> [235] "doses.dose1_mean"
#> [236] "doses.dose1_min_op"
#> [237] "doses.dose1_min"
#> [238] "doses.dose1_max_op"
#> [239] "doses.dose1_max"
#> [240] "doses.dose1_stat_method"
#> [241] "doses.dose1_stat_value"
#> [242] "doses.dose2_conc_type"
#> [243] "doses.dose2_mean_op"
#> [244] "doses.dose2_mean"
#> [245] "doses.dose2_min_op"
#> [246] "doses.dose2_min"
#> [247] "doses.dose2_max_op"
#> [248] "doses.dose2_max"
#> [249] "doses.dose2_stat_method"
#> [250] "doses.dose2_stat_value"
#> [251] "doses.dose3_conc_type"
#> [252] "doses.dose3_mean_op"
#> [253] "doses.dose3_mean"
#> [254] "doses.dose3_min_op"
#> [255] "doses.dose3_min"
#> [256] "doses.dose3_max_op"
#> [257] "doses.dose3_max"
#> [258] "doses.dose3_stat_method"
#> [259] "doses.dose3_stat_value"
#> [260] "media_characteristics.result_id"
#> [261] "media_characteristics.soil_type"
#> [262] "media_characteristics.media_texture_sand_mean_op"
#> [263] "media_characteristics.media_texture_sand_mean"
#> [264] "media_characteristics.media_texture_sand_min_op"
#> [265] "media_characteristics.media_texture_sand_min"
#> [266] "media_characteristics.media_texture_sand_max_op"
#> [267] "media_characteristics.media_texture_sand_max"
#> [268] "media_characteristics.media_texture_silt_mean_op"
#> [269] "media_characteristics.media_texture_silt_mean"
#> [270] "media_characteristics.media_texture_silt_min_op"
#> [271] "media_characteristics.media_texture_silt_min"
#> [272] "media_characteristics.media_texture_silt_max_op"
#> [273] "media_characteristics.media_texture_silt_max"
#> [274] "media_characteristics.media_texture_clay_mean_op"
#> [275] "media_characteristics.media_texture_clay_mean"
#> [276] "media_characteristics.media_texture_clay_min_op"
#> [277] "media_characteristics.media_texture_clay_min"
#> [278] "media_characteristics.media_texture_clay_max_op"
#> [279] "media_characteristics.media_texture_clay_max"
#> [280] "media_characteristics.media_texture_comments"
#> [281] "media_characteristics.media_conc_measured"
#> [282] "media_characteristics.media_conc_dry_wet"
#> [283] "media_characteristics.media_conc_comments"
#> [284] "media_characteristics.media_moisture_pct_mean_op"
#> [285] "media_characteristics.media_moisture_pct_mean"
#> [286] "media_characteristics.media_moisture_pct_min_op"
#> [287] "media_characteristics.media_moisture_pct_min"
#> [288] "media_characteristics.media_moisture_pct_max_op"
#> [289] "media_characteristics.media_moisture_pct_max"
#> [290] "media_characteristics.media_moisture_comments"
#> [291] "media_characteristics.media_cec_mean_op"
#> [292] "media_characteristics.media_cec_mean"
#> [293] "media_characteristics.media_cec_min_op"
#> [294] "media_characteristics.media_cec_min"
#> [295] "media_characteristics.media_cec_max_op"
#> [296] "media_characteristics.media_cec_max"
#> [297] "media_characteristics.media_cec_unit"
#> [298] "media_characteristics.media_cec_comments"
#> [299] "media_characteristics.media_ph_mean_op"
#> [300] "media_characteristics.media_ph_mean"
#> [301] "media_characteristics.media_ph_min_op"
#> [302] "media_characteristics.media_ph_min"
#> [303] "media_characteristics.media_ph_max_op"
#> [304] "media_characteristics.media_ph_max"
#> [305] "media_characteristics.media_ph_comments"
#> [306] "media_characteristics.media_org_matter_mean_op"
#> [307] "media_characteristics.media_org_matter_mean"
#> [308] "media_characteristics.media_org_matter_min_op"
#> [309] "media_characteristics.media_org_matter_min"
#> [310] "media_characteristics.media_org_matter_max_op"
#> [311] "media_characteristics.media_org_matter_max"
#> [312] "media_characteristics.media_org_matter_unit"
#> [313] "media_characteristics.media_org_matter_type"
#> [314] "media_characteristics.media_org_matter_comments"
#> [315] "media_characteristics.media_temperature_mean_op"
#> [316] "media_characteristics.media_temperature_mean"
#> [317] "media_characteristics.media_temperature_min_op"
#> [318] "media_characteristics.media_temperature_min"
#> [319] "media_characteristics.media_temperature_max_op"
#> [320] "media_characteristics.media_temperature_max"
#> [321] "media_characteristics.media_temperature_unit"
#> [322] "media_characteristics.media_temperature_comments"
#> [323] "media_characteristics.media_alkalinity_mean_op"
#> [324] "media_characteristics.media_alkalinity_mean"
#> [325] "media_characteristics.media_alkalinity_min_op"
#> [326] "media_characteristics.media_alkalinity_min"
#> [327] "media_characteristics.media_alkalinity_max_op"
#> [328] "media_characteristics.media_alkalinity_max"
#> [329] "media_characteristics.media_alkalinity_unit"
#> [330] "media_characteristics.media_alkalinity_comments"
#> [331] "media_characteristics.media_hardness_mean_op"
#> [332] "media_characteristics.media_hardness_mean"
#> [333] "media_characteristics.media_hardness_min_op"
#> [334] "media_characteristics.media_hardness_min"
#> [335] "media_characteristics.media_hardness_max_op"
#> [336] "media_characteristics.media_hardness_max"
#> [337] "media_characteristics.media_hardness_unit"
#> [338] "media_characteristics.media_hardness_comments"
#> [339] "media_characteristics.dissolved_oxygen_mean_op"
#> [340] "media_characteristics.dissolved_oxygen_mean"
#> [341] "media_characteristics.dissolved_oxygen_min_op"
#> [342] "media_characteristics.dissolved_oxygen_min"
#> [343] "media_characteristics.dissolved_oxygen_max_op"
#> [344] "media_characteristics.dissolved_oxygen_max"
#> [345] "media_characteristics.dissolved_oxygen_unit"
#> [346] "media_characteristics.dissolved_oxygen_comments"
#> [347] "media_characteristics.media_salinity_mean_op"
#> [348] "media_characteristics.media_salinity_mean"
#> [349] "media_characteristics.media_salinity_min_op"
#> [350] "media_characteristics.media_salinity_min"
#> [351] "media_characteristics.media_salinity_max_op"
#> [352] "media_characteristics.media_salinity_max"
#> [353] "media_characteristics.media_salinity_unit"
#> [354] "media_characteristics.media_salinity_comments"
#> [355] "media_characteristics.media_conductivity_mean_op"
#> [356] "media_characteristics.media_conductivity_mean"
#> [357] "media_characteristics.media_conductivity_min_op"
#> [358] "media_characteristics.media_conductivity_min"
#> [359] "media_characteristics.media_conductivity_max_op"
#> [360] "media_characteristics.media_conductivity_max"
#> [361] "media_characteristics.media_conductivity_unit"
#> [362] "media_characteristics.media_conductivity_comments"
#> [363] "media_characteristics.media_org_carbon_mean_op"
#> [364] "media_characteristics.media_org_carbon_mean"
#> [365] "media_characteristics.media_org_carbon_min_op"
#> [366] "media_characteristics.media_org_carbon_min"
#> [367] "media_characteristics.media_org_carbon_max_op"
#> [368] "media_characteristics.media_org_carbon_max"
#> [369] "media_characteristics.media_org_carbon_unit"
#> [370] "media_characteristics.media_org_carbon_comments"
#> [371] "media_characteristics.media_humic_acid_mean_op"
#> [372] "media_characteristics.media_humic_acid_mean"
#> [373] "media_characteristics.media_humic_acid_min_op"
#> [374] "media_characteristics.media_humic_acid_min"
#> [375] "media_characteristics.media_humic_acid_max_op"
#> [376] "media_characteristics.media_humic_acid_max"
#> [377] "media_characteristics.media_humic_acid_unit"
#> [378] "media_characteristics.media_humic_acid_comments"
#> [379] "media_characteristics.media_calcium_mean_op"
#> [380] "media_characteristics.media_calcium_mean"
#> [381] "media_characteristics.media_calcium_min_op"
#> [382] "media_characteristics.media_calcium_min"
#> [383] "media_characteristics.media_calcium_max_op"
#> [384] "media_characteristics.media_calcium_max"
#> [385] "media_characteristics.media_calcium_unit"
#> [386] "media_characteristics.media_calcium_comments"
#> [387] "media_characteristics.media_magnesium_mean_op"
#> [388] "media_characteristics.media_magnesium_mean"
#> [389] "media_characteristics.media_magnesium_min_op"
#> [390] "media_characteristics.media_magnesium_min"
#> [391] "media_characteristics.media_magnesium_max_op"
#> [392] "media_characteristics.media_magnesium_max"
#> [393] "media_characteristics.media_magnesium_unit"
#> [394] "media_characteristics.media_magnesium_comments"
#> [395] "media_characteristics.media_sodium_mean_op"
#> [396] "media_characteristics.media_sodium_mean"
#> [397] "media_characteristics.media_sodium_min_op"
#> [398] "media_characteristics.media_sodium_min"
#> [399] "media_characteristics.media_sodium_max_op"
#> [400] "media_characteristics.media_sodium_max"
#> [401] "media_characteristics.media_sodium_unit"
#> [402] "media_characteristics.media_sodium_comments"
#> [403] "media_characteristics.media_potassium_mean_op"
#> [404] "media_characteristics.media_potassium_mean"
#> [405] "media_characteristics.media_potassium_min_op"
#> [406] "media_characteristics.media_potassium_min"
#> [407] "media_characteristics.media_potassium_max_op"
#> [408] "media_characteristics.media_potassium_max"
#> [409] "media_characteristics.media_potassium_unit"
#> [410] "media_characteristics.media_potassium_comments"
#> [411] "media_characteristics.media_sulfate_mean_op"
#> [412] "media_characteristics.media_sulfate_mean"
#> [413] "media_characteristics.media_sulfate_min_op"
#> [414] "media_characteristics.media_sulfate_min"
#> [415] "media_characteristics.media_sulfate_max_op"
#> [416] "media_characteristics.media_sulfate_max"
#> [417] "media_characteristics.media_sulfate_unit"
#> [418] "media_characteristics.media_sulfate_comments"
#> [419] "media_characteristics.media_chlorine_mean_op"
#> [420] "media_characteristics.media_chlorine_mean"
#> [421] "media_characteristics.media_chlorine_min_op"
#> [422] "media_characteristics.media_chlorine_min"
#> [423] "media_characteristics.media_chlorine_max_op"
#> [424] "media_characteristics.media_chlorine_max"
#> [425] "media_characteristics.media_chlorine_unit"
#> [426] "media_characteristics.media_chlorine_comments"
#> [427] "media_characteristics.media_diss_carbon_mean_op"
#> [428] "media_characteristics.media_diss_carbon_mean"
#> [429] "media_characteristics.media_diss_carbon_min_op"
#> [430] "media_characteristics.media_diss_carbon_min"
#> [431] "media_characteristics.media_diss_carbon_max_op"
#> [432] "media_characteristics.media_diss_carbon_max"
#> [433] "media_characteristics.media_diss_carbon_unit"
#> [434] "media_characteristics.media_diss_carbon_comments"
#> [435] "media_characteristics.media_sulfur_mean_op"
#> [436] "media_characteristics.media_sulfur_mean"
#> [437] "media_characteristics.media_sulfur_min_op"
#> [438] "media_characteristics.media_sulfur_min"
#> [439] "media_characteristics.media_sulfur_max_op"
#> [440] "media_characteristics.media_sulfur_max"
#> [441] "media_characteristics.media_sulfur_unit"
#> [442] "media_characteristics.media_sulfur_comments"
#> [443] "references.reference_number"
#> [444] "references.reference_db"
#> [445] "references.reference_type"
#> [446] "references.author"
#> [447] "references.title"
#> [448] "references.source"
#> [449] "references.publication_year"
#> [450] "references.doi"
#> [451] "results.result_id"
#> [452] "results.test_id"
#> [453] "results.sample_size_mean_op"
#> [454] "results.sample_size_mean"
#> [455] "results.sample_size_min_op"
#> [456] "results.sample_size_min"
#> [457] "results.sample_size_max_op"
#> [458] "results.sample_size_max"
#> [459] "results.sample_size_unit"
#> [460] "results.sample_size_comments"
#> [461] "results.obs_duration_mean_op"
#> [462] "results.obs_duration_mean"
#> [463] "results.obs_duration_min_op"
#> [464] "results.obs_duration_min"
#> [465] "results.obs_duration_max_op"
#> [466] "results.obs_duration_max"
#> [467] "results.obs_duration_unit"
#> [468] "results.obs_duration_comments"
#> [469] "results.endpoint"
#> [470] "results.endpoint_comments"
#> [471] "results.trend"
#> [472] "results.effect"
#> [473] "results.effect_comments"
#> [474] "results.measurement"
#> [475] "results.measurement_comments"
#> [476] "results.response_site"
#> [477] "results.response_site_comments"
#> [478] "results.effect_pct_mean_op"
#> [479] "results.effect_pct_mean"
#> [480] "results.effect_pct_min_op"
#> [481] "results.effect_pct_min"
#> [482] "results.effect_pct_max_op"
#> [483] "results.effect_pct_max"
#> [484] "results.effect_pct_comments"
#> [485] "results.conc1_type"
#> [486] "results.ion1"
#> [487] "results.conc1_mean_op"
#> [488] "results.conc1_mean"
#> [489] "results.conc1_min_op"
#> [490] "results.conc1_min"
#> [491] "results.conc1_max_op"
#> [492] "results.conc1_max"
#> [493] "results.conc1_unit"
#> [494] "results.conc1_comments"
#> [495] "results.conc2_type"
#> [496] "results.ion2"
#> [497] "results.conc2_mean_op"
#> [498] "results.conc2_mean"
#> [499] "results.conc2_min_op"
#> [500] "results.conc2_min"
#> [501] "results.conc2_max_op"
#> [502] "results.conc2_max"
#> [503] "results.conc2_unit"
#> [504] "results.conc2_comments"
#> [505] "results.conc3_type"
#> [506] "results.ion3"
#> [507] "results.conc3_mean_op"
#> [508] "results.conc3_mean"
#> [509] "results.conc3_min_op"
#> [510] "results.conc3_min"
#> [511] "results.conc3_max_op"
#> [512] "results.conc3_max"
#> [513] "results.conc3_unit"
#> [514] "results.conc3_comments"
#> [515] "results.bcf1_mean_op"
#> [516] "results.bcf1_mean"
#> [517] "results.bcf1_min_op"
#> [518] "results.bcf1_min"
#> [519] "results.bcf1_max_op"
#> [520] "results.bcf1_max"
#> [521] "results.bcf1_unit"
#> [522] "results.bcf1_comments"
#> [523] "results.bcf2_mean_op"
#> [524] "results.bcf2_mean"
#> [525] "results.bcf2_min_op"
#> [526] "results.bcf2_min"
#> [527] "results.bcf2_max_op"
#> [528] "results.bcf2_max"
#> [529] "results.bcf2_unit"
#> [530] "results.bcf2_comments"
#> [531] "results.bcf3_mean_op"
#> [532] "results.bcf3_mean"
#> [533] "results.bcf3_min_op"
#> [534] "results.bcf3_min"
#> [535] "results.bcf3_max_op"
#> [536] "results.bcf3_max"
#> [537] "results.bcf3_unit"
#> [538] "results.bcf3_comments"
#> [539] "results.significance_code"
#> [540] "results.significance_type"
#> [541] "results.significance_level_mean_op"
#> [542] "results.significance_level_mean"
#> [543] "results.significance_level_min_op"
#> [544] "results.significance_level_min"
#> [545] "results.significance_level_max_op"
#> [546] "results.significance_level_max"
#> [547] "results.significance_comments"
#> [548] "results.chem_analysis_method"
#> [549] "results.chem_analysis_method_comments"
#> [550] "results.endpoint_assigned"
#> [551] "results.organism_final_wt_mean_op"
#> [552] "results.organism_final_wt_mean"
#> [553] "results.organism_final_wt_min_op"
#> [554] "results.organism_final_wt_min"
#> [555] "results.organism_final_wt_max_op"
#> [556] "results.organism_final_wt_max"
#> [557] "results.organism_final_wt_unit"
#> [558] "results.organism_final_wt_comments"
#> [559] "results.intake_rate_mean_op"
#> [560] "results.intake_rate_mean"
#> [561] "results.intake_rate_min_op"
#> [562] "results.intake_rate_min"
#> [563] "results.intake_rate_max_op"
#> [564] "results.intake_rate_max"
#> [565] "results.intake_rate_unit"
#> [566] "results.intake_rate_comments"
#> [567] "results.lipid_pct_mean_op"
#> [568] "results.lipid_pct_mean"
#> [569] "results.lipid_pct_min_op"
#> [570] "results.lipid_pct_min"
#> [571] "results.lipid_pct_max_op"
#> [572] "results.lipid_pct_max"
#> [573] "results.lipid_pct_comments"
#> [574] "results.dry_wet"
#> [575] "results.dry_wet_pct_mean_op"
#> [576] "results.dry_wet_pct_mean"
#> [577] "results.dry_wet_pct_min_op"
#> [578] "results.dry_wet_pct_min"
#> [579] "results.dry_wet_pct_max_op"
#> [580] "results.dry_wet_pct_max"
#> [581] "results.dry_wet_pct_comments"
#> [582] "results.steady_state"
#> [583] "results.additional_comments"
#> [584] "results.companion_tag"
#> [585] "results.old_terretox_result_number"
#> [586] "results.created_date"
#> [587] "results.modified_date"
#> [588] "species.species_number"
#> [589] "species.common_name"
#> [590] "species.latin_name"
#> [591] "species.kingdom"
#> [592] "species.phylum_division"
#> [593] "species.subphylum_div"
#> [594] "species.superclass"
#> [595] "species.class"
#> [596] "species.tax_order"
#> [597] "species.family"
#> [598] "species.genus"
#> [599] "species.species"
#> [600] "species.subspecies"
#> [601] "species.variety"
#> [602] "species.ecotox_group"
#> [603] "species.ncbi_taxid"
#> [604] "species_synonyms.species_number"
#> [605] "species_synonyms.latin_name"
#> [606] "chemicals.cas_number"
#> [607] "chemicals.chemical_name"
#> [608] "chemicals.ecotox_group"
#> [609] "chemicals.dtxsid"
#> [610] "application_frequency_codes.code"
#> [611] "application_frequency_codes.description"
#> [612] "application_type_codes.code"
#> [613] "application_type_codes.description"
#> [614] "chemical_analysis_codes.code"
#> [615] "chemical_analysis_codes.description"
#> [616] "chemical_formulation_codes.code"
#> [617] "chemical_formulation_codes.description"
#> [618] "chemical_grade_codes.code"
#> [619] "chemical_grade_codes.description"
#> [620] "concentration_type_codes.code"
#> [621] "concentration_type_codes.description"
#> [622] "concentration_unit_codes.code"
#> [623] "concentration_unit_codes.description"
#> [624] "control_type_codes.code"
#> [625] "control_type_codes.description"
#> [626] "dose_stat_method_codes.code"
#> [627] "dose_stat_method_codes.description"
#> [628] "duration_unit_codes.code"
#> [629] "duration_unit_codes.description"
#> [630] "effect_codes.code"
#> [631] "effect_codes.description"
#> [632] "endpoint_assigned_codes.code"
#> [633] "endpoint_assigned_codes.description"
#> [634] "endpoint_codes.code"
#> [635] "endpoint_codes.description"
#> [636] "exposure_type_codes.code"
#> [637] "exposure_type_codes.description"
#> [638] "field_study_type_codes.code"
#> [639] "field_study_type_codes.description"
#> [640] "gender_codes.code"
#> [641] "gender_codes.description"
#> [642] "geographic_codes.code"
#> [643] "geographic_codes.description"
#> [644] "habitat_codes.code"
#> [645] "habitat_codes.description"
#> [646] "ion_codes.code"
#> [647] "ion_codes.description"
#> [648] "lifestage_codes.code"
#> [649] "lifestage_codes.description"
#> [650] "measurement_codes.code"
#> [651] "measurement_codes.description"
#> [652] "media_char_unit_codes.code"
#> [653] "media_char_unit_codes.description"
#> [654] "media_type_codes.code"
#> [655] "media_type_codes.description"
#> [656] "organic_matter_type_codes.code"
#> [657] "organic_matter_type_codes.description"
#> [658] "organism_source_codes.code"
#> [659] "organism_source_codes.description"
#> [660] "radio_label_codes.code"
#> [661] "radio_label_codes.description"
#> [662] "response_site_codes.code"
#> [663] "response_site_codes.description"
#> [664] "sample_size_unit_codes.code"
#> [665] "sample_size_unit_codes.description"
#> [666] "season_codes.code"
#> [667] "season_codes.description"
#> [668] "statistical_significance_codes.code"
#> [669] "statistical_significance_codes.description"
#> [670] "substrate_codes.code"
#> [671] "substrate_codes.description"
#> [672] "test_location_codes.code"
#> [673] "test_location_codes.description"
#> [674] "test_method_codes.code"
#> [675] "test_method_codes.description"
#> [676] "test_type_codes.code"
#> [677] "test_type_codes.description"
#> [678] "trend_codes.code"
#> [679] "trend_codes.description"
#> [680] "weight_unit_codes.code"
#> [681] "weight_unit_codes.description"
#> [682] "length_unit_codes.code"
#> [683] "length_unit_codes.description"
#> [684] "length_type_codes.code"
#> [685] "length_type_codes.description"
## All except fields from the tables 'chemical_carriers', 'media_characteristics',
## 'doses', 'dose_responses', 'dose_response_details', 'dose_response_links' and
## 'dose_stat_method_codes' that are available from the ECOTOX database:
list_ecotox_fields("full")
#> [1] "tests.test_id"
#> [2] "tests.reference_number"
#> [3] "tests.test_cas"
#> [4] "tests.test_grade"
#> [5] "tests.test_grade_comments"
#> [6] "tests.test_formulation"
#> [7] "tests.test_formulation_comments"
#> [8] "tests.test_radiolabel"
#> [9] "tests.test_radiolabel_comments"
#> [10] "tests.test_purity_mean_op"
#> [11] "tests.test_purity_mean"
#> [12] "tests.test_purity_min_op"
#> [13] "tests.test_purity_min"
#> [14] "tests.test_purity_max_op"
#> [15] "tests.test_purity_max"
#> [16] "tests.test_purity_comments"
#> [17] "tests.test_characteristics"
#> [18] "tests.species_number"
#> [19] "tests.organism_habitat"
#> [20] "tests.organism_source"
#> [21] "tests.organism_source_comments"
#> [22] "tests.organism_lifestage"
#> [23] "tests.organism_lifestage_comments"
#> [24] "tests.organism_age_mean_op"
#> [25] "tests.organism_age_mean"
#> [26] "tests.organism_age_min_op"
#> [27] "tests.organism_age_min"
#> [28] "tests.organism_age_max_op"
#> [29] "tests.organism_age_max"
#> [30] "tests.organism_age_unit"
#> [31] "tests.organism_init_wt_mean_op"
#> [32] "tests.organism_init_wt_mean"
#> [33] "tests.organism_init_wt_min_op"
#> [34] "tests.organism_init_wt_min"
#> [35] "tests.organism_init_wt_max_op"
#> [36] "tests.organism_init_wt_max"
#> [37] "tests.organism_init_wt_unit"
#> [38] "tests.organism_characteristics"
#> [39] "tests.organism_gender"
#> [40] "tests.organism_length_mean_op"
#> [41] "tests.organism_length_mean"
#> [42] "tests.organism_length_min_op"
#> [43] "tests.organism_length_min"
#> [44] "tests.organism_length_max_op"
#> [45] "tests.organism_length_max"
#> [46] "tests.organism_length_unit"
#> [47] "tests.organism_length_type"
#> [48] "tests.organism_strain"
#> [49] "tests.experimental_design"
#> [50] "tests.study_duration_mean_op"
#> [51] "tests.study_duration_mean"
#> [52] "tests.study_duration_min_op"
#> [53] "tests.study_duration_min"
#> [54] "tests.study_duration_max_op"
#> [55] "tests.study_duration_max"
#> [56] "tests.study_duration_unit"
#> [57] "tests.study_duration_comments"
#> [58] "tests.exposure_duration_mean_op"
#> [59] "tests.exposure_duration_mean"
#> [60] "tests.exposure_duration_min_op"
#> [61] "tests.exposure_duration_min"
#> [62] "tests.exposure_duration_max_op"
#> [63] "tests.exposure_duration_max"
#> [64] "tests.exposure_duration_unit"
#> [65] "tests.exposure_duration_comments"
#> [66] "tests.study_type"
#> [67] "tests.study_type_comments"
#> [68] "tests.test_type"
#> [69] "tests.test_type_comments"
#> [70] "tests.test_location"
#> [71] "tests.test_location_comments"
#> [72] "tests.test_method"
#> [73] "tests.test_method_comments"
#> [74] "tests.exposure_type"
#> [75] "tests.exposure_type_comments"
#> [76] "tests.control_type"
#> [77] "tests.control_type_comments"
#> [78] "tests.media_type"
#> [79] "tests.media_type_comments"
#> [80] "tests.num_doses_mean_op"
#> [81] "tests.num_doses_mean"
#> [82] "tests.num_doses_min_op"
#> [83] "tests.num_doses_min"
#> [84] "tests.num_doses_max_op"
#> [85] "tests.num_doses_max"
#> [86] "tests.num_doses_comments"
#> [87] "tests.other_effect_comments"
#> [88] "tests.application_freq_mean_op"
#> [89] "tests.application_freq_mean"
#> [90] "tests.application_freq_min_op"
#> [91] "tests.application_freq_min"
#> [92] "tests.application_freq_max_op"
#> [93] "tests.application_freq_max"
#> [94] "tests.application_freq_unit"
#> [95] "tests.application_freq_comments"
#> [96] "tests.application_type"
#> [97] "tests.application_type_comments"
#> [98] "tests.application_rate"
#> [99] "tests.application_rate_unit"
#> [100] "tests.application_date"
#> [101] "tests.application_date_comments"
#> [102] "tests.application_season"
#> [103] "tests.application_season_comments"
#> [104] "tests.subhabitat"
#> [105] "tests.subhabitat_description"
#> [106] "tests.substrate"
#> [107] "tests.substrate_description"
#> [108] "tests.water_depth_mean_op"
#> [109] "tests.water_depth_mean"
#> [110] "tests.water_depth_min_op"
#> [111] "tests.water_depth_min"
#> [112] "tests.water_depth_max_op"
#> [113] "tests.water_depth_max"
#> [114] "tests.water_depth_unit"
#> [115] "tests.water_depth_comments"
#> [116] "tests.geographic_code"
#> [117] "tests.geographic_location"
#> [118] "tests.latitude"
#> [119] "tests.longitude"
#> [120] "tests.halflife_mean_op"
#> [121] "tests.halflife_mean"
#> [122] "tests.halflife_min_op"
#> [123] "tests.halflife_min"
#> [124] "tests.halflife_max_op"
#> [125] "tests.halflife_max"
#> [126] "tests.halflife_unit"
#> [127] "tests.halflife_comments"
#> [128] "tests.additional_comments"
#> [129] "tests.created_date"
#> [130] "tests.modified_date"
#> [131] "tests.published_date"
#> [132] "dose_responses.dose_resp_id"
#> [133] "dose_responses.test_id"
#> [134] "dose_responses.sample_size_unit"
#> [135] "dose_responses.sample_size_comments"
#> [136] "dose_responses.effect_code"
#> [137] "dose_responses.measurement_code"
#> [138] "dose_responses.measurement_comments"
#> [139] "dose_responses.response_site"
#> [140] "dose_responses.response_site_comments"
#> [141] "dose_responses.obs_duration_mean_op"
#> [142] "dose_responses.obs_duration_mean"
#> [143] "dose_responses.obs_duration_min_op"
#> [144] "dose_responses.obs_duration_min"
#> [145] "dose_responses.obs_duration_max_op"
#> [146] "dose_responses.obs_duration_max"
#> [147] "dose_responses.obs_duration_unit"
#> [148] "dose_responses.obs_duration_comments"
#> [149] "dose_responses.response_unit"
#> [150] "dose_responses.response_comments"
#> [151] "dose_responses.additional_comments"
#> [152] "references.reference_number"
#> [153] "references.reference_db"
#> [154] "references.reference_type"
#> [155] "references.author"
#> [156] "references.title"
#> [157] "references.source"
#> [158] "references.publication_year"
#> [159] "references.doi"
#> [160] "results.result_id"
#> [161] "results.test_id"
#> [162] "results.sample_size_mean_op"
#> [163] "results.sample_size_mean"
#> [164] "results.sample_size_min_op"
#> [165] "results.sample_size_min"
#> [166] "results.sample_size_max_op"
#> [167] "results.sample_size_max"
#> [168] "results.sample_size_unit"
#> [169] "results.sample_size_comments"
#> [170] "results.obs_duration_mean_op"
#> [171] "results.obs_duration_mean"
#> [172] "results.obs_duration_min_op"
#> [173] "results.obs_duration_min"
#> [174] "results.obs_duration_max_op"
#> [175] "results.obs_duration_max"
#> [176] "results.obs_duration_unit"
#> [177] "results.obs_duration_comments"
#> [178] "results.endpoint"
#> [179] "results.endpoint_comments"
#> [180] "results.trend"
#> [181] "results.effect"
#> [182] "results.effect_comments"
#> [183] "results.measurement"
#> [184] "results.measurement_comments"
#> [185] "results.response_site"
#> [186] "results.response_site_comments"
#> [187] "results.effect_pct_mean_op"
#> [188] "results.effect_pct_mean"
#> [189] "results.effect_pct_min_op"
#> [190] "results.effect_pct_min"
#> [191] "results.effect_pct_max_op"
#> [192] "results.effect_pct_max"
#> [193] "results.effect_pct_comments"
#> [194] "results.conc1_type"
#> [195] "results.ion1"
#> [196] "results.conc1_mean_op"
#> [197] "results.conc1_mean"
#> [198] "results.conc1_min_op"
#> [199] "results.conc1_min"
#> [200] "results.conc1_max_op"
#> [201] "results.conc1_max"
#> [202] "results.conc1_unit"
#> [203] "results.conc1_comments"
#> [204] "results.conc2_type"
#> [205] "results.ion2"
#> [206] "results.conc2_mean_op"
#> [207] "results.conc2_mean"
#> [208] "results.conc2_min_op"
#> [209] "results.conc2_min"
#> [210] "results.conc2_max_op"
#> [211] "results.conc2_max"
#> [212] "results.conc2_unit"
#> [213] "results.conc2_comments"
#> [214] "results.conc3_type"
#> [215] "results.ion3"
#> [216] "results.conc3_mean_op"
#> [217] "results.conc3_mean"
#> [218] "results.conc3_min_op"
#> [219] "results.conc3_min"
#> [220] "results.conc3_max_op"
#> [221] "results.conc3_max"
#> [222] "results.conc3_unit"
#> [223] "results.conc3_comments"
#> [224] "results.bcf1_mean_op"
#> [225] "results.bcf1_mean"
#> [226] "results.bcf1_min_op"
#> [227] "results.bcf1_min"
#> [228] "results.bcf1_max_op"
#> [229] "results.bcf1_max"
#> [230] "results.bcf1_unit"
#> [231] "results.bcf1_comments"
#> [232] "results.bcf2_mean_op"
#> [233] "results.bcf2_mean"
#> [234] "results.bcf2_min_op"
#> [235] "results.bcf2_min"
#> [236] "results.bcf2_max_op"
#> [237] "results.bcf2_max"
#> [238] "results.bcf2_unit"
#> [239] "results.bcf2_comments"
#> [240] "results.bcf3_mean_op"
#> [241] "results.bcf3_mean"
#> [242] "results.bcf3_min_op"
#> [243] "results.bcf3_min"
#> [244] "results.bcf3_max_op"
#> [245] "results.bcf3_max"
#> [246] "results.bcf3_unit"
#> [247] "results.bcf3_comments"
#> [248] "results.significance_code"
#> [249] "results.significance_type"
#> [250] "results.significance_level_mean_op"
#> [251] "results.significance_level_mean"
#> [252] "results.significance_level_min_op"
#> [253] "results.significance_level_min"
#> [254] "results.significance_level_max_op"
#> [255] "results.significance_level_max"
#> [256] "results.significance_comments"
#> [257] "results.chem_analysis_method"
#> [258] "results.chem_analysis_method_comments"
#> [259] "results.endpoint_assigned"
#> [260] "results.organism_final_wt_mean_op"
#> [261] "results.organism_final_wt_mean"
#> [262] "results.organism_final_wt_min_op"
#> [263] "results.organism_final_wt_min"
#> [264] "results.organism_final_wt_max_op"
#> [265] "results.organism_final_wt_max"
#> [266] "results.organism_final_wt_unit"
#> [267] "results.organism_final_wt_comments"
#> [268] "results.intake_rate_mean_op"
#> [269] "results.intake_rate_mean"
#> [270] "results.intake_rate_min_op"
#> [271] "results.intake_rate_min"
#> [272] "results.intake_rate_max_op"
#> [273] "results.intake_rate_max"
#> [274] "results.intake_rate_unit"
#> [275] "results.intake_rate_comments"
#> [276] "results.lipid_pct_mean_op"
#> [277] "results.lipid_pct_mean"
#> [278] "results.lipid_pct_min_op"
#> [279] "results.lipid_pct_min"
#> [280] "results.lipid_pct_max_op"
#> [281] "results.lipid_pct_max"
#> [282] "results.lipid_pct_comments"
#> [283] "results.dry_wet"
#> [284] "results.dry_wet_pct_mean_op"
#> [285] "results.dry_wet_pct_mean"
#> [286] "results.dry_wet_pct_min_op"
#> [287] "results.dry_wet_pct_min"
#> [288] "results.dry_wet_pct_max_op"
#> [289] "results.dry_wet_pct_max"
#> [290] "results.dry_wet_pct_comments"
#> [291] "results.steady_state"
#> [292] "results.additional_comments"
#> [293] "results.companion_tag"
#> [294] "results.old_terretox_result_number"
#> [295] "results.created_date"
#> [296] "results.modified_date"
#> [297] "species.species_number"
#> [298] "species.common_name"
#> [299] "species.latin_name"
#> [300] "species.kingdom"
#> [301] "species.phylum_division"
#> [302] "species.subphylum_div"
#> [303] "species.superclass"
#> [304] "species.class"
#> [305] "species.tax_order"
#> [306] "species.family"
#> [307] "species.genus"
#> [308] "species.species"
#> [309] "species.subspecies"
#> [310] "species.variety"
#> [311] "species.ecotox_group"
#> [312] "species.ncbi_taxid"
#> [313] "species_synonyms.species_number"
#> [314] "species_synonyms.latin_name"
#> [315] "chemicals.cas_number"
#> [316] "chemicals.chemical_name"
#> [317] "chemicals.ecotox_group"
#> [318] "chemicals.dtxsid"
#> [319] "application_frequency_codes.code"
#> [320] "application_frequency_codes.description"
#> [321] "application_type_codes.code"
#> [322] "application_type_codes.description"
#> [323] "chemical_analysis_codes.code"
#> [324] "chemical_analysis_codes.description"
#> [325] "chemical_formulation_codes.code"
#> [326] "chemical_formulation_codes.description"
#> [327] "chemical_grade_codes.code"
#> [328] "chemical_grade_codes.description"
#> [329] "concentration_type_codes.code"
#> [330] "concentration_type_codes.description"
#> [331] "concentration_unit_codes.code"
#> [332] "concentration_unit_codes.description"
#> [333] "control_type_codes.code"
#> [334] "control_type_codes.description"
#> [335] "duration_unit_codes.code"
#> [336] "duration_unit_codes.description"
#> [337] "effect_codes.code"
#> [338] "effect_codes.description"
#> [339] "endpoint_assigned_codes.code"
#> [340] "endpoint_assigned_codes.description"
#> [341] "endpoint_codes.code"
#> [342] "endpoint_codes.description"
#> [343] "exposure_type_codes.code"
#> [344] "exposure_type_codes.description"
#> [345] "field_study_type_codes.code"
#> [346] "field_study_type_codes.description"
#> [347] "gender_codes.code"
#> [348] "gender_codes.description"
#> [349] "geographic_codes.code"
#> [350] "geographic_codes.description"
#> [351] "habitat_codes.code"
#> [352] "habitat_codes.description"
#> [353] "ion_codes.code"
#> [354] "ion_codes.description"
#> [355] "lifestage_codes.code"
#> [356] "lifestage_codes.description"
#> [357] "measurement_codes.code"
#> [358] "measurement_codes.description"
#> [359] "media_char_unit_codes.code"
#> [360] "media_char_unit_codes.description"
#> [361] "media_type_codes.code"
#> [362] "media_type_codes.description"
#> [363] "organic_matter_type_codes.code"
#> [364] "organic_matter_type_codes.description"
#> [365] "organism_source_codes.code"
#> [366] "organism_source_codes.description"
#> [367] "radio_label_codes.code"
#> [368] "radio_label_codes.description"
#> [369] "response_site_codes.code"
#> [370] "response_site_codes.description"
#> [371] "sample_size_unit_codes.code"
#> [372] "sample_size_unit_codes.description"
#> [373] "season_codes.code"
#> [374] "season_codes.description"
#> [375] "statistical_significance_codes.code"
#> [376] "statistical_significance_codes.description"
#> [377] "substrate_codes.code"
#> [378] "substrate_codes.description"
#> [379] "test_location_codes.code"
#> [380] "test_location_codes.description"
#> [381] "test_method_codes.code"
#> [382] "test_method_codes.description"
#> [383] "test_type_codes.code"
#> [384] "test_type_codes.description"
#> [385] "trend_codes.code"
#> [386] "trend_codes.description"
#> [387] "weight_unit_codes.code"
#> [388] "weight_unit_codes.description"
#> [389] "length_unit_codes.code"
#> [390] "length_unit_codes.description"
#> [391] "length_type_codes.code"
#> [392] "length_type_codes.description"