EPA/600/R-21/082
ECOTOX
ECOTOXicology Knowledgebase System
User Guide - Version 5.4
Prepared by: Colleen M. Elonen and Jennifer H. Olker
U.S. Environmental Protection Agency (EPA)
Office of Research and Development (ORD)
Center for Computational Toxicology and Exposure (CCTE)
Great Lakes Toxicology and Ecology Division (GLTED) Duluth, Minnesota
In Conjunction with:
General Dynamics Information Technology (GDIT), Duluth, Minnesota
Contract CIO-SP3, HHSN316201200013W
Task Order: EP-G16H-01256, SMAVCS3
TDD 2-8 ECOTOX Application Development and Support
March 2021
-------
ECOTOX 5.4 User Guide
DISCLAIMER
ECOTOX attempts to be comprehensive, but the searches may not locate all relevant
literature to a research program. In addition, the time lag from conducting a literature
search, acquiring the publication, and extracting the data into the ECOTOX
Knowledgebase can be up to, or exceed, six months. For this reason, it is suggested
that users conduct searches of the most recent publication year to ensure data may
be captured which has not been entered in to the ECOTOX Knowledgebase or met
the criteria for inclusion.
Reference herein to any specific commercial product, process, or service by trade
name, trademark, manufacturer, or otherwise, does not necessarily constitute or imply
its endorsement, recommendation, or favoring by the U. S. government.
Researchers or managers using ECOTOX for analyses or summary projects
should consult the original scientific paper to ensure an understanding of the
context of the data retrieved from ECOTOX.
i
-------
ECOTOX 5.4 User Guide
Table of Contents
INTRODUCTION 1
GETTING STARTED 2
Access 2
Navigating within ECOTOX 2
Home 2
Search 3
Explore 3
OVERVIEW OF SEARCH OPTIONS FOR DATA IN ECOTOX 5
Search Strategy Basics 5
Overview of Search and Explore Pages 6
Moving Within Pages and Target Menu 6
Selection Box and Types 6
Key Functions 6
Options for Searching in ECOTOX 7
ECOTOX DATA SEARCHES 10
USING 'SEARCH' TO LOCATE DATA 10
Chemical Searches 10
Chemical Entry 11
Predefined Chemical Groups 11
Search Tips for Chemicals 11
Search by Effect Measurements 12
Search by Endpoints 13
Search by Taxonomy 13
Taxonomic Entry 13
Predefined Species Groups 14
Search Tips for Taxonomic Searches 15
Search by Test Conditions 15
Test Location 15
Exposure Media 16
Exposure Type 16
Control Type 16
Chemical Analysis 17
Search by Publication Options 17
Publication Year(s) 17
Author(s) 17
Reference Number 17
Independently Compiled Data 18
Recent Modifications and Additions 18
Output and Report Format Options 18
Delimited Output 18
Display Fields 19
USING 'EXPLORE' TO LOCATE DATA 19
ii
-------
ECOTOX 5.4 User Guide
Explore by Chemical 19
Predefined Chemical Groups 19
Refining/Filtering data using Query filters 20
Data Visualization Plots 20
Explore by Species 21
Predefined and Custom Species Groups 21
Refining/Filtering data using Query filters 22
Data Visualization Plots 22
Explore by Effects 23
Predefined Effects Groups 23
Refining/Filtering data using Query filters 24
Data Visualization Plots 24
Exporting Data in Explore 25
EXITING ECOTOX 25
APPENDIX A: ECOTOX SEARCH PLANNING FORM 26
Chemicals 26
Species 27
Test Results 27
Test Conditions 28
Publications 28
Report Output 29
APPENDIX B: PRACTICE SEARCHES 31
Example A 31
Example B 31
Example C 32
Example D 32
ADDITIONAL SEARCH and EXPLORE EXAMPLES 33
APPENDIX C: ECOTOX KNOWLEDGEBASE OVERVIEW 36
Data Sources 36
Quality Assurance 37
Test and Result Identification 37
Aquatic Data Elements 37
Terrestrial Data Elements 38
References 39
APPENDIX D: SPECIES AND CHEMICAL VERIFICATION 40
Species Verification 40
Taxonomic Hierarchy 40
Predefined Special Interest Sources 41
Chemical Verification 42
APPENDIX E: ECOTOX DATA FIELD DESCRIPTIONS 43
Bibliographic Fields 43
Author 43
Reference Number 43
Title 43
Source 43
Publication Year 43
iii
-------
ECOTOX 5.4 User Guide
Reference Citation 43
Chemical Fields 43
CAS Number 43
Chemical Name 43
Chemical DTXSID 43
Chemical Grade 43
Chemical Purity 44
Chemical Formulation 44
Chemical Comment 44
Chemical Radiolabel 44
Chemical Carrier 44
Species Fields 44
Species Number 44
Species Scientific Name 44
Species Common Name 44
Species NCBI TaxlD 44
Organism Source 44
Organism Lifestage 44
Organism Age 44
Gender 44
Organism Initial Weight 45
Species Final Weight 45
Organism Comment 45
Species Group 45
Species Taxonomic Information 45
Kingdom 45
Test Condition Fields 45
Media Type 45
Test Location 45
Exposure Duration 46
Study Duration 46
Exposure Type 47
Habitat 47
Chemical Analysis 47
Application Frequency 47
Study Type 47
Test Type 47
Test Method 47
Control 47
Number of Doses 47
Doses 48
Experimental Design 48
Exposure Sample Number 48
Gender 48
Ionic Fraction 48
Test Result Parameters 48
iv
-------
ECOTOX 5.4 User Guide
Test Number 48
Result (Record) Number 49
Endpoint 49
Effect 49
Effect Measurement 50
Trend 50
Response Site 50
EE_Comment 50
Effect % 51
Statistical Level 51
Bioconcentration 51
Concentration Type 51
Endpoint Assignment 51
Concentration/Dose 51
Result Sample Number 52
Observed Duration 52
Intake Rate 52
Result % Dry/Wet Weight 52
Result Percent Lipid 52
Other Effects 52
Result Comment 52
General Comment 53
Water Chemistry Fields (Aquatic only) 53
Outdoor Test Fields 54
Sub-Habitat Term/Description 54
Sub-Habitat Comment 54
Latitude/Longitude 54
Substrate Term/Description 54
Water Depth 54
Geographic Term 54
Geographic Location 54
Application Type 54
Application Rate 54
Chemical Half-Life 54
Application Date/Season 55
Terrestrial Only Data Elements 55
(Dose) Statistical Method 55
Test Comment 55
Exposure Comment 55
Observed Response Mean/Min/Max 55
Result Statistical Method/Observed Response Value 55
Soil Parameter Fields (Terrestrial only) 56
Temperature 56
Soil Type 56
Soil Sand %, Soil Silt %, Soil Clay % 56
Soil pH 56
v
-------
ECOTOX 5.4 User Guide
Media Organic Matter 56
Media Moisture 56
Media Cation Exchange Capacity 56
Soil Dose Measured 56
Media Measurement (wet/dry) 56
APPENDIX F: INDEPENDENTLY COMPILED DATA FILES 57
APPENDIX G: COMMENT FIELD HEADER NAMES 61
Aquatic Comment Abbreviations 61
Terrestrial Comment Abbreviations 63
APPENDIX H: DELIMITED OUTPUT HEADER NAMES 66
Aquatic Report Output Fields 66
Terrestrial Delimited Report Output Fields 79
vi
-------
ECOTOX 5.4 User Guide
INTRODUCTION
In the development and implementation for ecosystem management decisions there
is the need to establish scientifically credible risk assessments for chemical stressors.
Ecological assessments are required to characterize and diagnose the relative risk of
chemical pollutants and to predict future risk as a function of environmental
management options.
The U.S. EPA's ECOTOXicology Knowledgebase (ECOTOX) is a source for locating
single chemical toxicity data for aquatic life, terrestrial plants and wildlife. ECOTOX was
created and is maintained by the Office of Research and Development's (ORD's) Duluth
Minnesota laboratory.
ECOTOX integrates toxicity data derived predominantly from the peer-reviewed
literature, for aquatic life, terrestrial plants, and terrestrial wildlife. Not all data published
in the peer review ecotoxicology literature are included in ECOTOX. Users are
encouraged to refer to the Limitations and Minimum Data Requirements section of this
document to understand test results that are not considered for inclusion in the
database.
Researchers or managers using ECOTOX for analyses or summary projects
should consult the original scientific paper to ensure an understanding of the
context of the data retrieved from ECOTOX.
For more information on the ECOTOX Knowledgebase or
to report anything that you feel may be in error:
ECOTOX Support
Office of Research and Development (ORD)
Center for Computational Toxicology and Exposure (CCTE)
Great Lakes Toxicology and Ecology Division (GLTED)
6201 Congdon Boulevard
Duluth, Minnesota 55804
Telephone: 218-529-5225
Fax: 218-529-5003
E-mail: ecotox.support@epa.gov
1
-------
ECOTOX 5.4 User Guide
GETTING STARTED
Access
To access the ECOTOX website, users need a computer equipped with a JavaScript
enabled browser and internet connectivity. Start browser software and type in the
Internet address http://www.epa.gov/ecotox/ to be connected to the ECOTOX Home
page.
ECOTOX has the following browser limitations:
• The query pages require that browser support JavaScript and this feature must be
activated in browser preferences.
• ECOTOX has been tested using FireFox, Internet Explorer and Google Chrome. Chrome or
Firefox are currently the preferred browser programs for optimal performance.
• If a popup blocker program is activated, ECOTOX Reports, Help and Browse
features will not display. Please add the ECOTOX website to popup browser
exception list to ensure full usability.
Navigating within ECOTOX
Home
The Home page provides a general overview of the ECOTOX Knowledgebase with links
to the other pages within the application ('Search', 'Explore', and 'Help') and links to
more information for statistics and other databases. These selections will open the
requested information. To avoid losing your current 'Explore' and 'Search' selections,
left click the link and open tab in a new window.
About ECOTOX: This section of the website provides a general overview of the
ECOTOX Knowledgebase, including the history of the system's development, and
Help Center linkages which describes the ECOTOX website contents and navigational
resources available.
This printable User Guide is available in PDF (Portable Document Format) under the
ECOTOX Documentation section as "ECOTOX User Guide".
The Help center resources are listed in one of four web pages:
Starting Out - Information on how to begin navigating and searching the ECOTOX
website. This page also provides links to the limitations associated with the
ECOTOX Knowledgebase, Recent additions, Navigational help, Frequent questions
and PDF versions of the ECOTOX User Guide (this document), and the "ECOTOX
Terms Appendix", which provides detailed information regarding terms used in the
aquatic and terrestrial reports.
How do I... - Provides information on how to perform searches, select
'Search' parameters and Report format, and Navigate or retrieve outputs in
ECOTOX.
2
-------
ECOTOX 5.4 User Guide
What is... - Provides links to Data Field definitions and terms for each field available
within ECOTOX searches and output. It also provides a Database overview on data
sources, including Species and Chemical verification sources used by ECOTOX
staff. For a brief overview of data extraction processes used within ECOTOX see
Appendix C.
More Resources - Includes a glossary of terms and links to related websites.
Providing these links does not imply endorsement by the U.S. EPA.
Search
The ECOTOX Knowledgebase 'Search' feature provides a direct method to retrieve
data that can be refined by limiting the search parameters, e.g. Chemicals, Effects,
Endpoints or Species. Users can refine or filter selections before continuing a search.
Once search options have been selected or updated, users can view the report in the
browser, change the data fields, or export the report in an Excel or delimited format.
'Search' utilizes all available search and output features.
Explore
The ECOTOX Knowledgebase 'Explore' feature is an interactive way to examine search
paths by Chemicals, Species, or Effects via Groups. Once a Group is selected to
explore, query filters will be displayed to refine data via drop down boxes.
During the exploration there are also options to examine the data visually via plotting
functions. Once data exploration is complete, users are able to select report output
options or forward 'Explore' parameters to the ECOTOX 'Search' for further
refinement.
Note: ECOTOX Limitations: The following restrictions are placed on data included in
the ECOTOX Knowledgebase. Data not satisfying these requirements are excluded
from the ECOTOX Knowledgebase.
3
-------
ECOTOX 5.4 User Guide
Minimum Data Requirements
Criteria
Requirement/Inclusions
Lim itations/Exclusions
Chemical
Single chemicals relevant to
environmental exposure
Verifiable Chemical Abstract
Services (CAS) number
Mixtures (petroleum fuels)
Air pollution (CO2 and ozone)
Species
Ecologically relevant
species
Priority species are wild (test
results for terrestrial domestic
and laboratory species are
used to fill data gaps when
needed)
Organism taxonomic
information verifiable against
standard taxonomic sources
Human, monkey, bacteria,
viral and yeast
Effect/
Response
Biological adverse or
neutral response of an
acceptable organism to a
chemical toxicant.
Adverse effects are priority
(beneficial or nutritional
effects are lower priority)
Exposure
Amount
(Concentration
/ Dose)
Concurrent environmental
chemical concentration or
dose reported as
concentration, dose, or
application rate.
Sediment studies which have a
reported water concentration
Inhalation dose route
(including intratracheal
instillation)
Lead shot
Sediment only concentration
Concentration only reported as a
log value
Exposure
Duration
Known duration from the time
of initial exposure to the time
of measurement for a
biological effect
Publication /Data
Format
Primary data source
Full text in English (some Non-
English papers with an English
abstract have data extracted)
Reviews
Full text foreign language
Abstract only format
4
-------
ECOTOX 5.4 User Guide
ECOTOX system limitations:
• In 'Explore' there is a maximum of 3,000 Records that can be viewed but
unlimited data records can be retrieved.
• If popup blocker program is used, ECOTOX report exports may not display. Please
add the ECOTOX website to popup browser exception list to ensure full usability.
Data Downloads: Users can download delimited ASCII files of the entire database into
windows.exe or .zip files. This does not include any software and will require combining
various files together to view entire data records. The data are divided into two sections:
Aquatic and Terrestrial. Within these sections you will find data tables, field descriptions,
and graphical relations of the data structure.
OVERVIEW OF SEARCH OPTIONS FOR DATA IN ECOTOX
Database retrievals can be conducted using either 'Search' or 'Explore' options.
'Search' supports queries on Species, Chemicals, Effects, Endpoints, Test Conditions,
or by Publication Options. 'Search' includes all options under 'Explore' and enables
users to focus on additional criteria such as study site type (e.g., laboratory, field),
exposure media (e.g., freshwater, soil), route of chemical exposure (e.g., oral, diet),
and statistically-derived endpoints (e.g., LD50, NOEL). 'Search' results can be
downloaded either as a Microsoft (MS) Excel spreadsheet or delimited file format as
.txt with pipe delimiter (|), which can be transferred into a database or spreadsheet.
Within the 'Search' page, the inside of a text entry box or output display field has
context-sensitive help or information will display in a separate window. Users may
navigate within the 'Help' window without affecting the session in 'Search'.
Search Strategy Basics
The 'Search' or 'Explore' pages are each designed to search on all data, unless users
restrict the search by choosing specific search criteria (e.g., adding the check in the
checkbox, enter text in a text entry field). Searches may be performed at any time after
specific search criteria have been selected. Users do not need to enter something in
every 'Search' criteria area.
The search logic includes two basic strategies: combination/union and intersection.
Within a 'Search' area (e.g., Chemicals), the search will combine all search selections.
Between each 'Search' area, the search will intersect selections (e.g., intersection
between chemical and taxonomic selections). Users may want to use the ECOTOX
Search Planner located in Appendix A to plan searches. Appendix B describes practice
searches to assist users in using the ECOTOX system.
Before searching, users should read Appendix C to find out more about the
ECOTOX Knowledgebase and Appendix E for specific data field descriptions.
5
-------
ECOTOX 5.4 User Guide
Overview of Search and Explore Pages
Moving Within Pages and Target Menu
Users may move within an ECOTOX output table by using the scroll bar located at
the right of computer screen; the output table has top and bottom scroll bars to move
left and right in the table.
Selection Box and Types
All search and report selection options will be displayed in a box using multiple
selection methods: radio button, checkbox, drop-down lists, typing in text (one entry
per line).
Green buttons are used for general changes when new items are applied. Red buttons
are used for removing or resetting information. Blue buttons are used for general
functionality and switching among sections in ECOTOX.
Users must search at least one parameter. Any additional selections made using
multiple parameter search boxes within 'Search' or 'Explore' page will narrow the
search result.
Key Functions
There are some functions that can aid in searching. These Key Functions include:
Update Search - Updates query to most recently selected parameters in 'Search' page
Reset or Reset All - Erases previously selected criteria within a 'Search' area (Reset)
or across all 'Search' or 'Explore' areas (Reset All).
Aquatic Button - Loads or filters Aquatic data records.
Terrestrial Button - Loads or filters Terrestrial data records.
Customize Output Fields - A popup window that allows users to change or add data fields
to display in the search results. This allows selection of all available fields for display
and export (the default includes a limited number of the most commonly requested
fields). Note: option will only be available once a search has been conducted.
Export as... - A drop-down menu which allows export of results data to Excel or
Delimited files, or structured for use in developing Species Sensitivity Distributions.
Note: Under this button, users can choose to have full output version of test
results or "Condensed". "Excel (Full)" outputs six Excel columns for each numeric
field selection: mean operator (~, <, <=, >, >=), mean value, min operator, min value,
max operator, and max value. "Excel (Condensed)" outputs one Excel column for
each numeric field (mean operator + mean value) and summarizes other values in a
separate column at the far right.
View All Applied - A popup window showing parameters applied to specific search.
Users can export this criteria list for documentation purposes.
6
-------
ECOTOX 5.4 User Guide
References - Bv selecting the references buttonHlusers can view and export all
reference citations for the data searched.
Options for Searching in ECOTOX
ECOTOX offers the following search options: 'Search' or 'Explore'.
'Search' provides a broader range of query parameters than those available in
'Explore'. The default for each selection box is All Data will be searched. As selections
are added to Search criteria, the number of records that can be retrieved from the
ECOTOX Knowledgebase may be reduced.
Users must search at least one parameter. Any additional selections made using
multiple parameter search boxes within 'Search' or 'Explore' page will narrow the
search result.
Search Page Menu: The main 'Search' page provides an overview of how to
navigate within 'Search' and has a navigational tool bar located at the left of the page,
which allows users to navigate to different search parameters and enter specific
search criteria based on parameter field.
All Chemicals - Specific or Multiple Chemical Entry using either the Chemical
Abstract Services (CAS) Registry number or chemical name to identify the
substance(s) or select one or more predefined "Any Chemical Group"
All Effects - Specific or Multiple Effects or Measurements or select one or
more Any Effect Group
All Endpoints- Specific or Multiple Concentration Based Endpoints, Time Based
Endpoints, Bioaccumulation/Bioconcentration Factor Endpoints, or No
Endpoints
All Species - Specific or Multiple Taxonomic Entry using either the scientific
name, common name, or ECOTOX species number to identify the
organism(s) or select one or more predefined "Any Species Group"
All Test Conditions - Select any Test Location, Exposure Media, Exposure Type,
Control Type, Chemical Analysis or group within
All Publication Options - Enter Author, Reference Number, Publication
Year, or select grouped data under Independently Compiled Data and
Recent Modifications/Additions
As selections are made, they will appear in the left frame navigation tool. Users may
also review search selections using the "View All Applied" button after "Update Search'"
has been applied. Each parameter selection box also includes a 'Reset'button in the
7
-------
ECOTOX 5.4 User Guide
upper right-hand corner of the box. When you click on 'Reset', all
selections within the box are removed, however selections remain in the other boxes.
In summary, the ECOTOX 'Search' feature is designed to lead users through a search
session using multiple forms. The left frame provides a menu and navigational search
forms containing search parameter selections. Users must use the navigation tool bar
to move from form to form within 'Search.' To reset all data fields and start over, select
'Reset All'.
Note: Using your browser's Back button will result in the loss of all entries
made in any of the ECOTOX forms.
'Search' selection types may include:
Checkbox: To select an item, click on the checkbox to include. To remove a selection,
click on the checkbox again. One or more items may be selected.
D Any Test Locations
Q Lab
Not Reported
Q All Field Tests
Q Field, Artificial
Q Field, Natural
I Field, Undeterminable
Radio button: To select an option, click on the radio button box to include. To unselect,
click on the radio button again. Only one option listed may be chosen.
< Species
Specific Species
Enter each species name on separate lines.
Species name(s)
Q Contains Q Exact Match
Kingdom For Name Searches
O Animals Q Genus/Species Name
O Plants O Common Name
O Both O Other Taxonomic Names
8
-------
ECOTOX 5.4 User Guide
Drop-down List: To modify searches using the drop-down list, click on the arrow icon on
the right side. Clicking on this icon drops down a list immediately below the field and
shows which values can be chosen. Click on the entry item to select.
< Publication Options
Publication Years
1915 V to 2017 V
Author(s): All
Text Entry: Chemical, Effects, Species, Author, or Reference Number searches may
require typing the search criteria into the selection box. Each entry must be on a single
line, followed by clicking "Enter" on keyboard. The text must match the type of data
within ECOTOX, either as a sub-string search (Contains) or exactly (Exact Match).
Users may enter both text and numeric data into text boxes.
< Chemicals x
Q, 50000
121755
dioxin
cupric chloride
O Contains (_) Exact Match
filter eocfi chemical name and/orCAS registry number on separate lines.
View/Edit: For predefined groups within the 'Search' parameters, users can view and/or
further edit selected lists after "Update Search" has been completed. To access the
view and edit feature, click on the button located at the bottom for the search box
labeled "View/Modify Entries for Selected Groups." This displays a popup window with
detailed list(s) for selections. Changes can be made by deselecting any search
selection and clicking on 'Save Modifications', and selecting 'Update Search' to change
the data output. A 'Restore All' link is also provided to return the parameter to the
default selections, or select the 'Cancel' button to return to original search parameters.
If you click on your browser "Back" button, your edits will not be saved.
9
-------
ECOTOX 5.4 User Guide
Explore Page Menu
The 'Explore' feature supports searches for Predefined or Custom groups for
Chemicals, Species or Effects Groups. The 'Explore' menu includes a more limited set
of filter options and sort the data fields in the displayed tables cannot be modified. The
query options within 'Explore' are also available in 'Search', but the 'Search' contains
more search and output options.
A directory path noting the location in 'Explore' appears in the top banner. Users can move up
the path by closing the level using the mM button. Selecting the back button returns you to the
main 'Explore' page.
< Explore <£¦ Chemicals Beryllium©
Q Aquatic Terrestrial Group Summary
In summary, ECOTOX offers the following 'Explore' options:
• Chemical: Within the Chemical Entry search box, users may select any or
multiple Chemicals Groups to explore available data.
• Species: Within the Species Group, users may select any or multiple Species
Groups or develop a custom list to explore available data.
• Effects: Within the Effects Group, users may select any or multiple Effect Groups
in the Group list to explore available data.
ECOTOX DATA SEARCHES
To retrieve ECOTOX data, select either the 'Search' or 'Explore' on the Home page
banner. The query page will then load, however transferring between the 'Search' and
'Explore' features will lose your current search strategy.
USING 'SEARCH' TO LOCATE DATA
Chemical Searches
Under the 'All Chemicals' search tab, users can conduct queries on CAS
Registry numbers, partial or complete chemical names, and predefined groups
of chemicals. The default within ECOTOX is that all chemicals are selected for
searching. All chemicals within ECOTOX include a CAS Registry number and a
chemical name, typically a Collective Indices name. This information is verified
in reliable sources. Appendix D describes the verification process for chemicals
in the ECOTOX system. The Collective Indices name is identified as the
preferred name within the ECOTOX Knowledgebase, and this is the name
displayed on the report even if the search was conducted using a common or
10
-------
ECOTOX 5.4 User Guide
trade name of a substance. ECOTOX includes chemical synonym searching as
an option; however, if a synonym is used by more than one CAS number, both
chemicals will be queried.
Chemical Entry
To conduct a search, type in the CAS Registry number(s) and/or chemical name(s).
Users may enter the CAS Registry number with or without hyphens and leading zeroes.
CAS number queries are always exact matches.
Users can search for an unlimited number of entries and each entry must be entered on
a separate line and users can mix numbers and name entries.
Chemical Name: Users can now search ECOTOX for chemical synonyms. Enter the
names of the chemicals, placing each name in a separate field.
Note: If the term benzene is entered with the "Contains" radio button, all
chemicals that contain the sub-string benzene will be retrieved. Selecting the "Exact
Match" will return only results for benzene. It is recommended to search on CAS
Registry numbers (CASRN) to specifically restrict search to selected chemical(s).
Chemical Dashboard: On the 'All Chemicals' searching parameter, a link directs users
to the U.S. EPA's "CompTox Chemicals Dashboard" to search by CASRN for more
information on a chemical.
Note: CAS Registry number with or without hyphens made be entered for
ECOTOX searches, but exact CAS Registry number with hyphens is preferred for the
CompTox Chemicals Dashboard searches.
Predefined Chemical Groups
The option to select from predefined lists is available in the 'Search' function. Chemical
lists have been provided to effectively search a variety of Metal/Organometal or Organic
compounds chemical groups. To select a chemical group or specific chemical(s) of
interest, click on the checkbox to search. To unselect, click on the checkbox again.
Search Tips for Chemicals
Some guidance when conducting a chemical search:
Metal Compounds: It may be more effective to search metal compounds by chemical
name, i.e. entering cupr and copper as chemical names will find copper and several
copper compounds with fewer keystrokes than typing all the individual CAS Registry
numbers. Users may also search a group of copper compounds using the ECOTOX
Predefined Chemical Group option.
Organic Compounds: These compounds may be searched by chemical name, i.e.
entering dioxin as a chemical name will be more efficient than entering all the specific
dioxin chemical names or CAS Registry numbers. Remember, though, entering some
chemical names may identify many non-applicable chemicals (e.g., benzene will result
in all compounds with the sub-string 'benzene' in the chemical name), therefore it is
recommended to search by CAS Registry number if a specific chemical is required.
11
-------
ECOTOX 5.4 User Guide
Pesticides: Pesticides are usually found by typing the common synonym name or trade
name. Chemical CAS Registry numbers may be located via link to U.S. EPA's
"Chemicals Dashboard" or other chemical indexing resources.
Search by Effect Measurements
Under the "All Effects" search tab, users can conduct queries on specific effect measurements
(including Post-exposure results), or by predefined groups of effects.
Note: If the term vitellogenin is entered with the "Contains" radio button, all
effects that contain that sub-string will be retrieved. Selecting the "Exact Match" will
return only results for vitellogenin.
The default within the ECOTOX Knowledgebase is that All effects are selected for searching. All
coded effects are categorized into one of 11 major effect groupings such as Accumulation,
Growth, Mortality, etc.
Each effect includes a list of observed measurements. For instance, the Effect
Measurement "Biochemical Group" includes three effect categories: biochemical,
enzyme, and hormone. Within each of these effects there are multiple measurements
located under "View/Modify Entries for the Selected Group(s)".
For further refinement of observed effect information, users may click on the
"View/Modify Entries" button located at the bottom of the 'Effect Measurements'
selection box. A new window will open and display the list of specific measurements for
each of the selected effect(s) and/or effect group(s). Measurements include quantitative
observations that describe and evaluate biological responses to toxicants. Each effect
(e.g., Growth) can have several associated measurements (e.g., length, weight). The
"ECOTOX Terms Appendix" located in the "What Is..." section of the Help web page
provides definitions of the effect measurement codes used in ECOTOX.
The 'View/Modify Entries' window allows users to view and edit Effect Measurements to
include in search. To remove a specific measurement, click on the highlighted blue box
to remove the effect, and more than one measurement may be removed at a time.
Measurements may be restored by clicking on the "Restore AN" default button.
Note: If only a few effect measurements are desired, select "Clear AN" and reselect only
those measurements of interest. When complete, click on the "Save Modifications"
button to close the window and return the 'Search' page. If you click on "Back" button,
edits will not be saved.
Select "Update Search "to apply changes to the output.
Post-exposure Measurements: Within the "AN Effects" tab, this option allows users to
exclude results of responses observed during a post exposure period. If a study
includes observations of organisms after the chemical exposure has been
discontinued, these measurements are identified as 'Post-exposure Measurements'
and are included in the search results.
Records for Post-exposure Measurements can be recognized by clicking the
'Customize Output Fields' button and selecting the 'Display lookup codes instead of
descriptions' checkbox at the bottom of the pop-up window. Post Exposure
12
-------
ECOTOX 5.4 User Guide
Measurements will be displayed with a tilde (~) in front of the Effect Code. For example,
a post exposure measurement mortality effect would have ~MOR for the Effect Code.
Note: When using the 'Explore' feature, Post-exposure Measurements are also
automatically included in a query but currently cannot be separated.
Search by Endpoints
Under the "All Endpoints" search tab, users can conduct queries on any or all
specific endpoints or by predefined group of effects.
The default within the ECOTOX Knowledgebase is that "All Endpoints" are selected for
searching. For the purposes of ECOTOX, an endpoint is defined as the quantification of
an observed effect obtained through statistics or other means of calculation for the
express purpose of comparing equivalent effects (e.g., LC50).
For each toxicity test, pertinent information on test results presented by the authors are
encoded within the database. Endpoint information is included if it is reported by the
author.
Within the "Any Endpoints" tab, users can choose one or more endpoints within the
checkbox by clicking to select endpoints to include in query. The Endpoint selection
box is divided into the following sections: Concentration-Based or Time-Based
Endpoints, Bioaccumulation / Bioconcentration Factors (all statistically-derived, or
calculated as reported by the author or determined by the ECOTOX staff), or
Statistics, No Endpoint (which contains statistically analyzed data but authors did not
identify a specific endpoint or one could not be determined by ECOTOX staff) or
Endpoint Not Reported (NR) where data was not statistically analyzed.
The "View All Applied" box allows users to view and export all search parameters.
More endpoints can be selected after conducting the initial search, but users must
select "Update Search" to apply changes to the output.
Search by Taxonomy
Under the "All Species" search tab, users can conduct a search by using Species
Names or Number(s), or by using Predefined Species Groups. All data records within
ECOTOX include a Scientific name for the test species. All names have been verified
in reliable taxonomic sources. Appendix D contains information regarding the
verification of species data in ECOTOX.
The ECOTOX species file includes historical synonyms for the species. If a search is
conducted using a species name that is noted as a taxonomic synonym in our system,
ECOTOX Knowledgebase will present the results using the currently acceptable genus
and species name.
Taxonomic Entry
Users can search for an unlimited number of species entries, but each entry must be
entered on a separate line or separated by a comma. Users can mix numbers and
name entries, but the name entry must be the same type (e.g., Genus/species and
Common names cannot be searched within one entry screen).
13
-------
ECOTOX 5.4 User Guide
Genus/Species Name: Users can conduct a search on whole or fragments of
scientific names (Genus, Species).
Species Common Name: All data records within ECOTOX include a common name for
each species. Users can conduct an exact search (Exact Match) on the common
name or fragments.
Other Taxonomic Names: Key taxonomic levels (Kingdom, Phylum/Division,
Superclass, Class, Order, Family, Genus, Species, Subspecies, and Variety)
searches are available by typing the appropriate scientific name.
Note: If a species name is entered, users can select either the "Contains" or the
"Exact Match" radio buttons. For example, if users enter trout and select the
"Contains" radio button, it will return everything that contains the sub-string trout.
For name searches, users are required to select the type of name (e.g.
Genus/Species name, etc.). If trout is entered, users would need to select the
Species Common Name radio button to retrieve any results. Selecting the "Exact
Match" is best utilized when the literal string (exact name) of the species is
known (e.g. rainbow trout or Daphnia sp.)
Predefined Species Groups
Species lists have been provided to effectively search a variety of species groups.
For further refinement of a species group, users may click on the "View/Modify Entries
for Selected Group(s)" button located at the bottom of the Species selection box. A new
window will open and display the list of specific species for each of the selected groups.
The View/Modify entries window allows users to view and edit species to include in
search. To remove one or many specific species, click on the highlighted blue box to
remove the species. Users may restore species by clicking on the "Restore AN"
default button. If only a few species are desired, select "Clear AN" and reselect only
those species of interest. When completed, click on the "Save Modifications" button to
close window and return the 'Search' page. Clicking on browser "Back" button will
remove all edits.
Select "Update Search" to apply changes to the output.
Note: Users cannot display both the Animal and Plant species groups due to the large
number of species within these lists.
Taxonomic kingdom (plant or animal) searching is available in 'Search'. The kingdom is
searched using a radio button option located within "AN Species" as "Plants" for the
plant kingdom or "Animals" for the animal kingdom.
The Plant kingdom search also includes species representing Monera and Fungi. Some
studies report both plant and animal species as one effect measurement (e.g., aquatic
community, plankton, soil community). These results will be included when either plant,
animal or both kingdoms are selected.
14
-------
ECOTOX 5.4 User Guide
Search Tips for Taxonomic Searches
By clicking on "All Species" on the frame at the left of the search page, will move
users to the Taxonomic Search area. Some examples are provided to help when
developing your search strategy:
Genus/Species Name: Entering Pimephales promelas in the search text box will result
in only data for fathead minnows. Entering daphnia genus as the genus/species name
will result in all Daphnia and Ceriodaphnia species. If a specific genus and/or species
names is consistently searched, a user may want to use the species number for
searching (ECOTOX Species Number or NCBI TaxlD Number).
Users may also enter a historical Scientific Name and still retrieve data for a species.
For example, if Salmo gairdneri is entered, the output will display the currently
accepted name, Oncorhynchus mykiss.
Other Taxonomic Name: Any taxonomic level (Kingdom, Phylum/Division,
Superclass, Class, Order, Family, Genus, Species, Subspecies, and Variety) can be
searched using this Taxonomic Entry box. For example, entering Salmonidae will
retrieve all species for this family.
Species Common Name: Using some common names may be an effective way to
search if there is a unique common name for that organism. For example, entering
mallard in the common name field will result in only mallard duck results.
Note: Entering the term duck will output results for duck and duckweed. In this case,
searching using the common name (exact) or performing only performing the query
on terrestrial data will eliminate the duckweed from the search.
Note: Entering bird in the common name field will result in bird and ladybird beetle
data. In addition, using the term birdmW not ensure that all bird data in the system will
be extracted because the species name may not use the term bird in the common
name.
Species Number: The species number is the unique indexing number assigned to each
species in ECOTOX and can be used as a shortcut method to search genus and/or
species data.
Search by Test Conditions
For each toxicity test, pertinent information on testing procedures presented by the
authors are documented within the database. Search selections available on this page
are Test Location, Exposure media, Exposures types, Control types and Chemical
analysis.
The options for searching by test conditions are briefly described below.
Test Location
The valid entries for test location are Lab (laboratory), Field (all outdoor field tests,
artificial, natural or undeterminable) and Not Reported (i.e., the author(s) did not present
sufficient information to determine test location). The default within ECOTOX is that all
data, regardless of test location, are included in search result. To selectively search on
a specific test location, click to mark the appropriate checkbox.
15
-------
ECOTOX 5.4 User Guide
Exposure Media
The default within ECOTOX is that all data, regardless of test media, are included in
search result. To selectively search on a specific exposure type, click to mark the
appropriate checkbox.
Aquatic freshwater tests include those conducted in freshwater, reconstituted water,
distilled water, or tap water. Saltwater tests include those conducted in natural or
artificial seawater, brackish water, or estuarine water. Not Reported (NR) is used if a
determination cannot be made regarding the use of either freshwater or saltwater.
Terrestrial exposure media selections are focused on tests using a substrate (e.g., soil
or artificial media). If the terrestrial organism does not utilize a substrate for nutrition
(e.g., birds, mammals), do not select any exposure media types.
Exposure Type
Users can select the exposure type by clicking the items in the search selection box area.
Organisms are typically exposed to toxicants through aqueous, diet, injection, in vitro,
topical or environmental routes. Occasionally, an exposure may be through multiple
routes (e.g., such as topical and oral).
ECOTOX includes chemical exposures on whole living organisms as well as organisms
that are not intact {in vitro). For example, in vitro exposures can contain studies using
excised organs and cell cultures. Inclusion of in vitro studies into ECOTOX have the
same species criteria requirements as those for whole organisms (ecologically relevant
and exclude humans, monkeys, rats and mice).
Control Type
Control Type allows the capability to filter toxicity tests based on author reported
test control types, as well as the ability to select specific control type(s).
Individual control types may be selected by choosing the appropriate checkbox(es)
from the following options:
o Baseline (B) - parameters measured before administration of test chemical
o Concurrent (C) - run simultaneously with the exposure
o Historical (H) - data collected often during a long-term survey of the area
o Multiple (M) - multiple type of controls reported, noted individually
o Other (0) - control is run in a different system than exposures
o Positive (P) - an exposure that causes a desired effect in the experiment
o Solvent (V) - exposed to carrier or solvent only
o Undefined (K) - control is presented but without accompanying
methodology
Historical ECOTOX Control Types
o Insufficient (I) - not enough information presented to determine control type
o Multiple Controls (OK) - multiple type of controls reported
16
-------
ECOTOX 5.4 User Guide
o Satisfactory (S) - run in the same system, low mortality
o Unsatisfactory (U) - chemical entered control, high mortality
Control Not Reported
o No Control Used (Z) - authors state no control used
o Not Coded (NC) - was not coded
o Not Reported (NR) - was not reported
Chemical Analysis
The method of chemical analysis filters toxicity tests based on the author reported
chemical concentrations, as measured or nominal values. Individual chemical analysis
types may be selected by choosing the appropriate checkbox(es) from the following
options
Measured: Exposure and/or observation concentrations or doses are quantitative.
Analysis methods may be reported.
Unmeasured: Exposure and/or observation concentrations or doses are clearly
identified as nominal values, or when the author does not report whether the
concentrations were measured or nominal (i.e., unmeasured is used as a default value
when there is no information provided about the reported chemical concentrations).
Not Reported: Exposure and/or observation concentrations or doses are not reported.
Search by Publication Options
Publication Year(s)
The default within the ECOTOX Knowledgebase is that all data, regardless of
publication year, are included in search result. The default publication year search may
be overridden by selecting a range of publication years
The Aquatic component of ECOTOX contains data from publication years 1915 to
present. The Terrestrial component of ECOTOX contains data from publication
years 1926 to present.
Author(s)
Searches may be conducted on specific authors. To search on an author, enter the
specific author names in the selection box while in the "All Publication Options" of
the 'Search' page, one author per line. Partial author names may be used. Only
authors which have data extracted in the ECOTOX Knowledgebase are returned.
Reference Number
Each publication abstracted for the ECOTOX Knowledgebase is assigned a unique
Reference Number (also called an ECOREF Number). These reference numbers are
available for selection for any ECOTOX outputs. To conduct a search, enter a valid
ECOTOX Reference Number(s) in the selection box in the "Ref Num" box, with one
reference number per line.
17
-------
ECOTOX 5.4 User Guide
Independently Compiled Data
ECOTOX includes several independently compiled data sets. Data sets from the
Organization for Economic Cooperation and Development (OECD), Russia, Office of
Pesticide Programs, the U.S. Geological Survey, and U.S. EPA Duluth Lab are
included as subsets of the ECOTOX Knowledgebase. For further information on these
data files, refer to Appendix F.
Recent Modifications and Additions
The default within ECOTOX is that all data, regardless of the date added to the
database, are included in search results. Data may be restricted to newly updated or
modified data using this filter. The Recent Modifications/Additions search box allows
searches based on the last 10 updates to the Knowledgebase, which typically span two
to three years. This feature is useful for specific queries (e.g., list of species and/or
chemicals) conducted on a regular basis.
Users can select "View All Applied" box to view the selected parameters used in the
'Search' function. This information can be exported to retain a dated record of each
search.
Output and Report Format Options
Within 'Search' function, the output table report has been condensed to include only the
most utilized output fields. All or some of the coded fields can be exported by first
selecting "Customize Output Fields" button, then click on "Select AN" or clicking on any
additional fields to display in search results. All updated fields will be displayed in the
output table.
Navigating within Output table: Users can move through the report in several ways.
To view within a page, use the scroll bar on the right side of the window. To view all
coded output fields, scroll down to bottom and then scroll to right of table. To move
from one page to another page of the report, use the numbered hyperlinks located at
bottom of each report page.
Users can also choose to export data to an Excel spreadsheet or delimited file. The
report will be saved as either Aquatic or Terrestrial depending on selected output.
In the downloaded/saved Excel report, if the author did not report data for a database
field, the output report will display an NR or 'Not reported.' Definitions for any codes
presented in the report can be found in the "ECOTOX Terms Appendix" located under
the "Help" tab.
Note: Users must first export output to Excel or delimited file; currently, users cannot
print directly from the HTML output.
Delimited Output
Users are able to generate a delimited data file (.txt) of search results. The delimited
tabular output format has set default output fields. If the author did not report data for a
parameter, the delimited output will have an NR or 'Not reported' in the data field.
Definitions for all terms presented in the report can be found in the "ECOTOX Terms
18
-------
ECOTOX 5.4 User Guide
Appendix" located in the "Help" section under the Home page.
The exported data file may be imported into spreadsheet or database software for
further refinements. Each data element is separated into a unique field, and each result
number appears as a data record on a single line. For delimited reports, the Reference
Citation field will appear in the separate delimited fields (Reference Number, Author,
Title, Publication Year and Source).
Note: Each field in the delimited file report will be separated by a vertical bar ("|").
Users may have to specify the vertical bar as the delimiter when importing the data. A
forward slash (/) within a field refers to an associated comment. Comment fields can be
selected in output to help interpret unique test conditions but for a complete
understanding of the toxicity study, refer to the full publication.
Display Fields
Select data parameters are presented in the default versions of the Aquatic and
Terrestrial tabular reports. A checkmark appears in data fields that are displayed in the
default output format. Users can change the display fields for Excel and delimited
outputs by selecting the "Customize Output Fields" button to add additional output fields
then select "Save". To remove a selected data field, click on the checked box to
uncheck it. Click on the "View All Applied" to see modified entries.
USING 'EXPLORE' TO LOCATE DATA
About Explore
The 'Explore' feature is a great tool for searching the ECOTOX Knowledgebase if you
do not know the exact parameters you wish to search or would like a visual
representation of general and specific data trends. It is an interactive way to examine
search paths by Chemical, Species and Effects. There are ways to examine the data
visually via plotting functions. The user can investigate available data with these
'Explore' options and then send the query filters to 'Search' for further refinement and
export of the resulting data records.
Explore by Chemical
Predefined Chemical Groups
The option to select from predefined lists is available in 'Explore.' Chemical lists have
been provided to effectively search a variety of Metal/Organometal or Organic
compounds chemical groups. To select a chemical group or group(s) of interest, click
on the checkbox you want to search. To unselect, click on the checkbox again.
Searches for data on a specific user-defined single chemical or "custom group" of
chemicals can also be conducted from the 'Explore' Chemicals page, however users
cannot select both a chemical from the pre-defined group list and enter in a Custom
group chemical. After a specific group is selected, click on "Explore Data" button.
Explore Data >
19
-------
ECOTOX 5.4 User Guide
The default within the ECOTOX Knowledgebase is that all chemicals in the selected
group are selected for searching. The output can be refined by filtering the tabular data
using the text entry fields at the top of each column to limit results to specific chemicals
in that group, or by using the Query filters on the left side of table.
Notice that the initial output has both Aquatic and Terrestrial data reported under the
Group Summary tab. Users can deselect one or the other by clicking the checkbox to
filter data.
Aquatic
Terrestrial
Group Summary
Records
Plot View
Users can filter all available data results by selecting the "Records" tab above the
table to show all Distinct records in the Group.
Aquatic
Terrestrial
Group Summary
Records
Plot View
Note: There are fewer output columns displayed in the 'Explore' feature as
compared to the 'Search' feature. To see all available data for specific results,
users can send the query filters and search parameters to the 'Search' feature of
the Knowledgebase using the green button on the upper right of the Records
Table.
Send Query Filters to Search
Refining/Filtering data using Query filters
Users can refine tabular data using filters on the left side of the table. All chemicals,
species, and effects data resulting from an initial search can be refined via the
dropdown boxes under each filter group. Users may select one or multiple options in
each box. Once filters are selected, click 'Enter' on keyboard or mouse-click outside
the box to apply to data output table. Users can select "View All Applied" box to view
the selected parameters. This information can also be exported to retain a dated
record of each search.
Data Visualization Plots
Data output presented in the 'Explore' table can also be plotted (if applicable) by
selecting the 'Plot View' tab.
Aquatic
Terrestrial
Group Summary Records
Plot View
20
-------
ECOTOX 5.4 User Guide
Currently, only Aquatic data or Terrestrial data that can be converted to ppm
equivalents are viewable in the Plot View. ECOTOX unit conversion logic can be found
here: https://cfpub.epa.gov/ecotox/help.cfm. There are three types of pre-defined plots
available: Effect by Chemical, Duration by Chemical and Duration by Endpoint. There is
also the option for a Custom Plot, in which the Y-axis can be set to Concentration or
Duration, and the X-axis and Legend can be set to categorical fields such as Chemical,
Species, Effect, Endpoint, etc.
The data presented in the table or in the plot can be further refined using either the
query filters on the left side of the webpage, or via the headers in the output table.
Users can also "zoom" into the plot to refine output, or by deselecting/selecting items in
plot legend.
Hovering the cursor over any of the data points in the graph will highlight the study.
Clicking on any data point in the plot will highlight the result in the table below the plot.
Notice in the 'Explore' plot table, only 13 output columns are shown. To see all available
data for specific results, users should select "Send Query filters to Search" to apply the
search parameters to the 'Search' feature of the Knowledgebase.
Explore by Species
Predefined and Custom Species Groups
The option to select from predefined group or a Custom Group is available in the
'Explore' feature. Species groups have been provided to effectively search a variety of
Animal, Plants, or Special interest groups. To select one or many species group(s) of
interest, click on the checkbox(es) you want to search. To unselect, click on the
checkbox again.
After specific group is selected, click on "Explore Data" button.
Explore Data >
The default within the ECOTOX Knowledgebase is that all species in the selected group
are selected for searching. If you want to limit results to specific species in that group,
the output can be refined by filtering tabular data using the text entry fields at the top of
the table columns, or by using the Query filters on the left side of table.
Notice that the initial output has both Aquatic and Terrestrial data reported under the
Group Summary tab (if data are available and applicable). You can deselect one or the
other by clicking the checkbox to filter data.
Q Aquatic Q Terrestrial Records Plot View
21
-------
ECOTOX 5.4 User Guide
You can zero in on available data results by selecting "Records" tab above the
table which will show all Distinct records in the Group:
Q Aquatic Q Terrestrial Group Summary Plot View
To create a custom group of species, select the Create Custom Group button from the
left side panel.
Create Custom Group...
From there, you can either Browse Species by entering a common name, Latin name
or NCBI TaxlD and then selecting one or more species or chose to Enter by NCBI
TaxID. You can also copy and paste a list of NCBI TaxIDs into the appropriate box.
Note: While searching for data using the 'Explore' feature, you will notice fewer output
columns as compared to Search feature (currently 6 under Group summary and 9 under
Records). To see all available data for specific results, users should select "Send Query
filters to Search" to apply the search parameters to the 'Search' feature of the
Knowledgebase.
Refining/Filtering data using Query filters
Users can refine tabular data using filters on the left side of the table. All chemicals,
species, and effects data resulting from an initial search can be refined via the
dropdown boxes under each filter group. Users may select one or multiple options in
each box. Once filters are selected, click 'Enter' on keyboard or mouse-click outside
the box to apply to data output table. Users can select "View All Applied" box to view
the selected parameters. This information can also be exported to retain a dated
record of each search.
Data Visualization Plots
Data output presented in the 'Explore' table can also be plotted (if applicable) by
selecting the 'Plot View' tab.
] Aquatic Q Terrestrial
Group Summary Records
Plot View
Currently, only Aquatic data or Terrestrial data that can be converted to ppm
equivalents are viewable in the Plot View, and there are three types of pre-defined plots
available: Effect by Chemical, Duration by Chemical and Duration by Endpoint. There is
also the option for a Custom Plot, in which the Y-axis can be set to Concentration or
Duration, and the X-axis and Legend can be set to categorical fields such as Chemical,
Species, Effect, Endpoint, etc.
22
-------
ECOTOX 5.4 User Guide
The data presented in the table or in the plot can be further refined using either the
query filters on the left side of the webpage, or via the headers in the output table.
Users can also "zoom' into the plot to refine output, or by deselecting/selecting items in
plot legend.
Hovering the cursor over any of the data points in the graph will highlight the study.
Clicking on any data point in the plot will highlight the result in the table below the plot.
Notice in the 'Explore' plot table, only 13 output columns are shown. To see all available
data for specific results, users should select "Send Query filters to Search" to apply the
search parameters to the 'Search' feature of the Knowledgebase.
Explore by Effects
Predefined Effects Groups
The option to select from predefined lists is available in the 'Explore' feature. Effects
groups have been provided to effectively search a variety of typical apical effects such
as Growth, Reproduction and Mortality, but also include newer effects groups such as
Behavior and Physiology effects. To select one or many species group(s) of interest,
click on the checkbox(es) you want to search. To unselect, click on the checkbox
again.
After specific group is selected, click on the "Explore Data" button.
Explore Data >
The default within the ECOTOX Knowledgebase is that all effects in the selected group
are selected for searching. If you want to limit results to a specific effect measurement
in that group, the output can be refined by filtering Tabular data using text entry fields at
the top of the table columns, or by using the Query filters on the left side of table.
Notice that the initial output has both Aquatic and Terrestrial data reported under the
Group Summary tab (if data are available and applicable). You can deselect one or the
other by clicking on the checkbox to filter data.
Q Aquatic Q Terrestrial Records Plot View
You can zero in on available data results by selecting the "Records" tab above the
table which will show all Distinct records in the Group:
Q Aquatic Q Terrestrial Group Summary Plot View
Any specific Effect on the output table can be selected for viewing by clicking on the
23
-------
ECOTOX 5.4 User Guide
green arrow on right side of output table This will refine the output table to all
records by selected effect.
Note: While searching for data using the 'Explore' feature, you will notice
fewer output columns as compared to 'Search' feature (currently 6 under Group
summary and 9 under Records). To see all available data for specific results, you
must apply the search parameters using the 'Search' feature of the
Knowledgebase.
Refining/Filtering data using Query filters
Users can refine tabular data using filters on the left side of the table. All chemicals,
species, and effects data resulting from an initial search can be refined via the
dropdown boxes under each filter group. Users may select one or multiple options in
each box. Once filters are selected, click 'Enter' on keyboard or mouse-click outside
the box to apply to data output table. Users can select "View All Applied" box to view
the selected parameters. This information can also be exported to retain a dated
record of each search.
Data Visualization Plots
Data output presented in the 'Explore' table can also be plotted (if applicable) by
selecting the 'Plot View' tab.
Q Aquatic Q Terrestrial Group Summary Records
Currently, only Aquatic data or Terrestrial data that can be converted to ppm
equivalents are viewable in the Plot View, and there are three types of pre-defined plots
available: Effect by Chemical, Duration by Chemical and Duration by Endpoint. There is
also the option for a Custom Plot, in which the Y-axis can be set to Concentration or
Duration, and the X-axis and Legend can be set to categorical fields such as Chemical,
Species, Effect, Endpoint, etc.
The data presented in the table or in the plot can be further refined using either the
query filters on the left side of the webpage, or via the headers in the output table.
Users can also "zoom' into the plot to refine output, or by deselecting/selecting items in
plot legend.
Hovering the cursor over any of the data points in the graph will highlight the study.
Clicking on any data point in the plot will highlight the result in the table below the plot.
Notice in the 'Explore' plot table, only 13 output columns are shown. To see all available
data for specific results, users should select "Send Query filters to Search" to apply the
search parameters to the 'Search' feature of the Knowledgebase.
24
-------
ECOTOX 5.4 User Guide
Exporting Data in Explore
~ Export CSV
Tabular data output can be exported to CSV file by clicking on button and
saving file to computer. If the number of records is larger than you would like to view, you may
close the report window and return to the ECOTOX Knowledgebase window to refine your
search strategy.
Once search is completed, and report window closed, users will be returned to the
ECOTOX Knowledgebase window. The search strategy will remain intact, so
refinements can be made, or if you want to conduct another search, you may clear
the search by clicking the "Reset AN" button.
EXITING ECOTOX
Exiting your Web browser or visiting another Web site will leave the program. Exiting the
Web browser will not save your search strategy.
25
-------
ECOTOX 5.4 User Guide
APPENDIX A: ECOTOX SEARCH PLANNING FORM
Use this form to help plan your searches or to document searches for yourself or others
to perform.
Chemicals
Chemical Names
CAS Numbers
Predefined Groups
Metal Compounds Organic Compounds
Aluminum Conazoles
Antimony DDT and metabolites
Arsenic Dibenzofurans
Barium Explosives
Beryllium Glycol Ethers
Cadmium Major Ions
Chromium Neonicotinoids
Cobalt Nitrosamines
Copper Perchlorates
Iron Phthalate Esters
Lead Polyaromatic Hydrocarbons (PAH)
Manganese Polychlorinated Biphenyls (PCB)
Mercury Polybrominated Diphenyl Ethers (PBDE)
Nickel Pharmaceutical Personal Care (PPCP)
Organotin Strobins
Selenium
Silver Per- and Polyfluoroalkyl Substances (PFAS)
Vanadium
Zinc
26
-------
ECOTOX 5.4 User Guide
Species
Scientific Names/
Taxonomic Levels
Common Names
Species
ECOTOX
Numbers or
NCBI TaxIDs
Predefined Taxonomic Groups
All
Animals
Amphibians
Insects/Spiders
Molluscs
Birds
Other Invertebrates
Reptiles
Crustaceans
Mammals
Worms
Fish
All
Plants
Algae
Moss/Hornworts, Fungi,
Flowers, Trees, Shrubs, Ferns
Special
Interest
Standard Test Species
US Threatened/Endangered
Species
US Exotic/Nuisance
Test Results
Endpoints:
Concentration Based
Time Based
Bioaccumulation/bioconcentration Factor
Statistics, No endpoint
Effect Groups:
Accumulation Mortality
Behavior Physiology
Biochemical Population
Cellular Reproduction
Growth Ecosystem
Specific Effect Measurements
Include Post-exposure Measurements (for recovery or delayed effects)
27
-------
ECOTOX 5.4 User Guide
Test Conditions
Test Location(s):
Lab
All Field
Tests
Field Artificial
Field Natural
Field Undeterminable
Exposure Media:
WATER: Freshwater
Saltwater Not Specified
SOIL: Artificial
Humus Litter Manure Mineral Soil Natural Soil
Unspecified Soil
Soil Mixture
ARTIFICIAL: Hydroponic
Other
Exposure Tvpe:
Diet
Flow-through (aquatic)
Injection
Leaching (aquatic)
Topical
Intermittent (aquatic)
Environmental
Renewal (aquatic)
Multiple Entry
Lotic (aquatic)
In-vitro
Static (aquatic)
Not Reported
Lentic (outdoor aquatic)
Tidal (outdoor aquatic)
Control Tvpe:
Historical Control Tvpe:
Concurrent
Insufficient
Multiple
Multiple Controls
Baseline
Satisfactory
Solvent
Unsatisfactory
Positive
Historical
Control Not Reported:
Undefined
No Control
_ Other
Not Reported
Chemical Analysis:
Measured Unmeasured Not Reported
Publications
Publication Years:
Author:
Reference Number(s):
Independently Compiled Data:
EPA: Fathead Minnow Acute Toxicity
EPA: Office of Pesticide Program Database
Dutch Dataset
French Dataset
German Dataset
Russian Dataset
USGS Acute Toxicity Dataset
Recent Update Dates:
28
-------
ECOTOX 5.4 User Guide
Report Output
Aquatic Output Elements
Standard default output elements are listed in bold. Some output
options are available for Field Data only and are indicated by 'field
only'.
Terrestrial Output Elements
Standard default output elements are listed in bold. Some output
options are available for Field Data only and are indicated by 'field
only'.
Alkalinity
Application Date (field only)
Application Date (field only)
Application Date /Season (field only)
Application Date /Season (field only)
Application Frequency
Application Frequency
Application Rate (field only)
Application Rate (field only)
Author
Application Type (field only)
CAS Number/Chemical Name
Author
Chemical DTXSID
BCF Value
Chemical Analysis Method
Calcium
Chemical Carrier (includes all associated fields)
CAS Number
Chemical Comment
CAS Number/Chemical Name
Chemical Formulation
Chemical DTXSID
Chemical Grade
Chemical Analysis
Chemical Half Life (field only)
Chemical Carrier (includes all associated fields)
Chemical Name
Chemical Comments
Chemical Purity
Chemical Formulation
Chemical Radiolabel
Chemical Grade
Control Type
Chemical Half Life (field only)
Dose (Author)
Chemical Name Chemical Purity
Dose Statistical Method (browser view only)
Chemical Radiolabel
Doses
Chlorine
EE Comment
Concentration (Author)
Effect
Concentration (Standardized)
Effect %
Conductivity
Effect Measurement
Control
Endpoint
Dissolved Inorganic Carbon
Endpoint Assignment
Dissolved Oxygen
Endpoint / BCF/BAF
Doses
Experimental Design
EE Comment
Exposure Comment
Effect
Exposure Duration (Author)
Effect %
Exposure Duration (Days)
Effect Measurement
Exposure Sample Number
Effect /Effect Measurement
Exposure Type
Endpoint
Exposure Type/Chemical Analysis method
Endpoint Assignment
Gender
Endpoint / BCF value
General comments
Experimental Design
Geographic Term (Field Data Only)
Exposure Duration (Author)
Geographic Location (Field Data Only)
Exposure Duration (Days)
Habitat
Exposure Sample Number
Intake Rate
Exposure Type
Ionic Fraction
Exposure Type/Chemical Analysis method
Longitude/Latitude (Field Data Only)
Gender
Media Cation Exchange Capacity
General comments
Media Measurement
Geographic Term (Field Data Only)
Media Moisture
Geographic Location (Field Data Only)
Media Organic Matter and Type
Habitat
Media Type
Hardness
Media Type/Test Location
Humic Acid
Number of Doses
Intake Rate
Observed Duration (Author)
Ionic Fraction
Observed Duration (Days)
Longitude/Latitude (Field Data Only)
Observed Response [also BCF/BAF]
Magnesium
Organism Age
Media Type
Organism Comment
Media Type/Test Location
Organism Initial Weight
Number of Doses
Organism Lifestage
Number of Doses/Result Sample Unit
Organism Source
Observed Duration (Author)
Other Effects
Observed Duration (Days)
Publication Year
29
-------
ECOTOX 5.4 User Guide
Organic Carbon Type/Value
Reference Citation
Organism Age
Reference Number
Organism Comment
Response Site
Organism Initial Weight
Response Site/Exposure Duration (Days)
Organism Lifestage
Result Percent Dry/Wet Weight
Organism Source
Result Comment
Other Effects
Result Percent Lipid
pH
Result Sample Number/Unit
Potassium
Result Sample Number
Publication Year
Result Sample Unit
Reference Citation
Result Statistical Method/Observed Response Value
Reference Number
Significance Level
Response Site
Significance Level/Statistical Significance
Response Site/Exposure Duration (Days)
Soil Clay %
Result Percent Dry/Wet Weight
Soil Dose Measured
Result Comment
Soil pH
Result Percent Lipid
Soil Sand %
Result Sample Number/Unit
Soil Silt %
Result Sample Number
Soil Type
Result Sample Unit
Species Common Name
Salinity
Species ECOTOX Number
Season
Species Final Weight
Significance Level
Species Group
Significance Level/Statistical Significance
Species NCBI TaxlD
Sodium
Species Scientific Name
Species Common Name
Species Scientific Name/Species Common Name
Species ECOTOX Number
Species Taxonomic Information
Species Final Weight
Statistical Significance
Species Group
Steady State
Species NCBI TaxlD
Study Duration (Author)
Species Scientific Name
Study Duration (Days)
Species Scientific Name/Species Common Name
Study Type
Species Taxonomic Information
Sub-Habitat Term (Field only)
Statistical Significance
Sub-Habitat Description (Field only)
Steady State
Sub-Habitat Comment (Field only)
Study Duration (Author)
Substrate Code (Field only)
Study Duration (Days)
Substrate Comment (Field only)
Study Type
Temperature
Sub-Habitat Term (Field only)
Test Comments
Sub-Habitat Description (Field only)
Test Location
Sub-Habitat Comment (Field only)
Test Method
Substrate Code (Field only)
Test Number
Substrate Comment (Field only
Test Type
Sulfate
Trend
Sulfur
Trend/Effect %
Temperature
Test Location
Test Method
Test Number
Test Type
Trend
Trend/Effect %
Water Depth
30
-------
ECOTOX 5.4 User Guide
APPENDIX B: PRACTICE SEARCHES
These examples are for you to try in the 'Search' Page. After each example search,
remember to click on "Reset AN" before proceeding to the next search.
Example A
You want to locate All Reproductive effects data for Nickel compounds. You want to
include the specific habitat information for any results.
1. From home page (https://www.epa.gov/ecotox), click on search:
2. Click on "All Chemicals" from the menu. Scroll down to "Any Chemical Group".
3. Select Nickel checkbox from the metal compound list.
4. Click on "All Effects" from the menu. Select Reproduction Group.
Update Search
5. Click on the "Update Search" button.
6. Notice that Aquatic data is displayed, click on "Customize Output Fields"
Customize Output Fields
lin the upper right hand. Scroll down and click on the
Habitat checkbox to add this field to your output. Then click 'Save'.
7. Note: If you wish to view Terrestrial data, click on the Terrestrial button. You will
have to select the same Output field for the Terrestrial button.
Terrestrial
Example B
You want to locate LC50 data on Freshwater organisms exposed to Malathion.
1. From Home page (https://www.epa.gov/ecotox), click on search: B9
2. Click the "All Chemicals" menu on the left frame of the Search page. Type in
'Malathion' or CAS Number either formatted ('121-75-5') or unformatted
('121755') in the Chemical entry selection box.
3. Click "All Endpoints" menu. Within the "Concentration Based Endpoint" menu,
select 'LC50' checkbox.
4. Click "All Test Conditions" menu. Scroll down to the "Exposure Media" selection
box and click on the Fresh Water checkbox.
5. Click on the "Update Search" button.
31
-------
ECOTOX 5.4 User Guide
Example C
You want to locate recently published, lethality endpoint only studies on Daphnia
magna.
1. From home page (https://www.epa.gov/ecotox), click on 'Search':
2. Click "All Species" menu on the left frame of the 'Search' page. Type in
"Daphnia magna' and confirm that the Genus/Species Name radio button is
highlighted.
3. Click on the "All Effects" menu and select the 'Mortality Group' checkbox.
4. Click on the All Publication Options" menu. Within the "Publication Years"
selection box, select 2010 from the first drop down list and select 2018 from the
second drop down list.
Update Search
5. Click on the "Update Search" button
6. Note: Only 'Aquatic' data should be presented in the table.
Example D
You want to locate toxicity data for Amphibian tests performed in an outdoor location.
You would like to move these data records into your own database.
1. From home page (https://www.epa.gov/ecotox), click on 'Search':
2. Click on the "All Species" menu on the left frame of the 'Search' page. Scroll
down to the "Any Species Groups" and check the 'Amphibians' checkbox.
3. Click on the "All Test Conditions" menu. Within the "Any Test Locations" area,
select the checkbox 'All Field Tests' from the list. Also, within the "Exposure
Media - Water" select Fresh', 'Salt' and Not Specified'.
4. Click on the Terrestrial button. (Selecting 'Aquatic' will return too many to view,
but if desired, you could select additional filters to refine output)
5. Click on the "Update Search" button.
Update Search
6. Click "Export As..." button. Choose either 'Excel' or 'Delimited' report option for
the results.
32
-------
ECOTOX 5.4 User Guide
ADDITIONAL SEARCH and EXPLORE EXAMPLES
After each example, remember to click on "Reset AN" before proceeding to the next
example.
I. Search Example
You want to locate all reproductive effects data for Buprofezin. What types of
reproductive effects were measured?
1. From the ECOTOX home page, click 'Search' on the top banner. ESS
2. Select the 'All Chemicals' tab from the left frame.
3. Type "Buprofezin" into the chemical name search box and click the green
button.
4. Select the 'All Effects' tab from the left frame and scroll down to 'Reproduction
Group'
5. Deselect the checkbox next to 'Any Measurements' and/or just select the
checkbox next to 'Reproduction Group' then
6. Select the 'Aquatic' button for aquatic data or 'Terrestrial' button for terrestrial
data. The data fields and display format are different for an aquatic exposure
versus a terrestrial exposure. If you would like to view data for both Aquatic and
Terrestrial, you can toggle between the two by select either 'Aquatic' HiKI or
'Terrestrial' ¦HUMiiH.
7. Click the blue 'View All Applied' button to view/export search parameters applied.
View All Applied
8. Select green "Customize Output Fields" to select additional data fields to be
Customize Output Fields
shown in the output table.
9. Select 'References' tab in upper right to see list of references for the results from
this search.
10. Click the green 'Export as...' drop-down to select type of file to download.
0 Export as...
/Vote: Please confirm that what you select/deselect makes sense in the database. If
you have selected "Reproduction" and "Growth" you should NOT be seeing any other
Effects in your report. Also, if you are viewing Aquatic Tab in the Results table, you
should not be able to see any Bird species under the Results table.
Conversely if you are viewing the Terrestrial table, there should only be terrestrial
organisms listed, but you can also go back to ALL SPECIES and select smaller
group of results, such as WORMS.
If you are seeing anything that you feel may be in error or "bugs", please "View All
Applied" and Copy/Save and send the information to Ecotox.support@epa.gov .
33
-------
ECOTOX 5.4 User Guide
The second example is using the 'EXPLORE' feature. You might use this when you
are not sure of what type of chemical information or species are in contained in the
knowledgebase.
II. Explore Example
You want to Explore data on the Reproductive effects of Cadmium on fish.
1. From the ECOTOX home page, click 'Explore' on the top banner.
2. Click the 'Chemicals' icon.
3. Under the Chemicals Groups, scroll down and select Cadmium checkbox.
~
Beryllium
Q
Cadmium
~
ChromiurT
Explore Data >
4. Click the 'Explore Data' button to begin exploring.
5. The compounds are listed by CAS number. You can browse this list by CAS, or
Chemical name, or number of publications just by typing in the column header. To
Remove this filter, just click on the "X Reset" in upper RED BAR.
6. To view information on specific CAS number listed in output table, click the green
'>' (greater than) sign on the right side of the output table, and all the Aquatic and
Terrestrial Records for that compound will be displayed. You can filter additionally
by Aquatic or Terrestrial by deselecting one or the other. Note: Depending on
number of Records, the output may be limited to the first 3,000.
7. If you want to go back to your original list of compounds, you must go back to
'Query Filters' on left side of the webpage, and 'Reset All' (red 'x' at the bottom of
the Query Filters'. Using the browser Back key or closing out the tab above,
will bring you all the way back to the Home page. You can then Select Group
Summary' ¦IttiliiiiUiilittfl to see original list of compounds.
8. From the list of 'Query filters', click the drop down 'Species Group' selection box
and select Fish. If you wish to select multiple species groups, hold the 'ctrl' key
and click on multiple selections. Click outside of the 'Species Group' drop down
menu or click Enter on your keyboard to apply new parameters.
Notice now that above 'Query Filters', the Terrestrial box is no longer highlighted due to
the selection of 'Fish' (Aquatic organism) as your species of interest.
You can continue to refine the output by Effect:
Q AQUATIC
9. From the drop down 'Effect Groups' selection box. Scroll down to Select
'Reproduction'. Again, click outside of the dropdown menu or click Enter on your
34
-------
ECOTOX 5.4 User Guide
keyboard to apply new parameters. On the top left corner of the page, above
additional 'Query Filters', ensure that only the Aquatic checkbox is selected.
10. The data matching your 'Explore' criteria will automatically display in the Group
Summary view. You can switch to view records individually by clicking the
GroupSummary
'Records' button located under the top banner.
11. You can again filter or refine your Table view by typing in a filter in the header (i.e.,
"LOEC" under Endpoint) which will reduce the number of Records (red bar). Note:
If you export to CSV file from here, you will only get this subset of records, not all
original record output.
12. To use 'Explore' with the visualization feature, select the 'Plot View' button.
GroupSummary Records
13. There are 4 interactive figures to display ECOTOX Records which have exposure
concentrations (standardized to an equivalent of ppm (parts per million)).
a) Dur x Chem: Exposure duration (days) on x-axis, Exposure concentration on
y- axis, Chemical for point shape and color
b) Dur x Endpt: Exposure duration (days) on x-axis, Exposure concentration on
y- axis, Endpoint for point shape and color
c) Effect x Chem: Effect Groups on x-axis, Exposure concentration on y-axis,
Chemical for point shape and color
d) Custom Plot: y-axis can be set to Exposure concentration or Exposure
duration (days), x-axis and legend can be set to categorical fields such as
Chemical, Species, Effect, Endpoint, etc.
Note: Zoom in by drawing rectangle around area of interest. Turn Chemicals or Endpoints off and
on by clicking on name in legend. Hover over points of interest for more information. Click on
point to be directed to record in table below the figure
14. Simplified table below each figure shows subset of data for each record.
15. You can continue to refine the output with the Query filters on left hand side.
16. Click the blue 'View All Applied' button to view/export 'Explore' parameters applied.
View All Applied
17. Click the green "Export" button to download figure or simple table.
Note: Default output table does not include all fields. Return to 'Search' and apply
filter parameters to download complete data tables.
35
-------
ECOTOX 5.4 User Guide
APPENDIX C: ECOTOX KNOWLEDGEBASE OVERVIEW
Data Sources
The primary source of toxicity effect information in ECOTOX is from peer reviewed
literature. Pertinent literature is identified through online computerized searches of the
international literature. The computerized searches were historically initiated with the
1970 publication year and continue through to the present; in the last five years this
has changed to have no date restrictions on the literature searches. Comprehensive
searches are designed to include the effect of nearly all toxic substances on aquatic
and terrestrial organisms within the scope of each ECOTOX Knowledgebase systems'
guidelines.
Commercial literature sources are continually evaluated for relevance to the ECOTOX
literature searches. The search strategy is evaluated regarding the success ratio of
each search. Additional literature sources include abstract journals, review
bibliographies, and the U.S. EPA library collections.
The abstracts obtained through computerized searches of abstracting databases are
screened to identify toxicity references applicable to aquatic and terrestrial habitats.
Those references pertinent to one or more of the databases are acquired through a
variety of literature acquisition procedures such as author reprint requests, inter-library
loans, and commercial sources. As the publications are received, a reference number
is assigned for storage and retrieval purposes, and a final check for applicability and
duplication is made. A bibliographic sub-file stores the citations and a reprint of each
publication is archived.
Publications used in ECOTOX usually contain unique data. For various reasons authors
may report the same data point in different publications. If the authors themselves
cross-reference the data, ECOTOX abstracts the data only once and notes the cross-
reference as part of the bibliographic citation. This type of cross-reference most
frequently occurs in the publication of a thesis and subsequent journal articles. If the
author does NOT acknowledge multiple publications of a single data point, it is likely this
data point will occur in ECOTOX as multiple records, each with a different citation. This
type of publication occurs most frequently when data is published in different sources
such as a textbook and journal article, an agency publication and a journal article, or a
regional journal and an international journal.
Toxicity test data are included unless the data have been cited as published elsewhere.
Data reported in review papers are abstracted from the original publication.
International publications may be reviewed by ECOTOX staff if either an English
abstract or a translated table of data is included. International cooperative efforts with
the Organization for Economic Cooperation and Development (OECD) and Russia
(Borok Institute) have been used to enhance review of the international literature.
Data obtained from independently compiled data files must meet the minimum data
requirements and quality assurance guidelines defined for each ECOTOX
Knowledgebase component. The key data fields that must be included are test
chemical name, test organism, test duration, effect, and effect concentration or
application rate. Documentation describing the test methods must be provided within
36
-------
ECOTOX 5.4 User Guide
the publication. If tests are missing key parameters, the data are rejected for
inclusion into ECOTOX.
No effort is made to locate unreported data (e.g., authors are not contacted, citations
referring to methods used are not obtained). During the incorporation of an electronic
data file, a quality assurance check of the CAS number, species scientific name, and
reference citation is completed. Data files that have been included in the aquatic
dataset are the U.S. EPA Duluth Lab fathead minnow acute toxicity database
(http://archive.epa.gov/med/med archive 03/web/html/prods pubs.html, Center for
Lake Superior Studies, University of Wisconsin-Superior, 1984, 1985, 1986, 1988, and
1990), and datasets from France, Germany, the Netherlands and Russia. ECOTOX
also includes the U.S. EPA OPP's Pesticide Ecotoxicity Database for both aquatic and
terrestrial toxicity tests. Appendix F contains additional information and contacts for
independently compiled data files.
Quality Assurance
Quality assurance procedures begin with literature acquisition and cataloging, and
continue through the chemical and species verification, the literature review process,
data entry, and data retrieval. The ECOTOX literature is abstracted by trained document
data curators. An intensive training period, a well-documented manual (U.S. EPA 2020),
and close interaction with the data coordinator help to ensure a high level of accuracy
and consistency in the reviewing process. Ten percent of the publications are
independently reviewed by two different reviewers, and all documents are QA'd by more
experienced data curators. These reviews are compared and differences (if any) are
documented, discussed, and resolved by the data coordinator.
Test and Result Identification
Each reference included in ECOTOX may include multiple unique tests. A computer-
generated Test Number used to designate each unique test design. A unique test
design may be characterized by a new test chemical, test species, test location, or
exposure type. Additionally, there are experimental design parameters that will
influence a test scenario sufficiently to warrant an independent test number. Such
parameters include tests conducted at different test temperatures or conducted during
different seasons.
Each Test Number within a reference may include multiple effects and endpoints. A
separate line is used for each effect or endpoint from either a unique experimental
design or within one design scenario for statistically defined effects or endpoints. Each
of these lines is designated with a Result Number and is one data record in ECOTOX.
If no statistics are used to distinguish endpoints or effects and experimental designs
are similar, the data may be combined into one data record. Endpoints always require
a discrete line. Effects lacking an author reported endpoint may be combined based on
statistical representation by the author. Food chain effects are abstracted for
organisms at the first level of exposure.
Aquatic Data Elements
Aquatic data includes toxic effect results from exposures of single chemicals to aquatic
organisms. Bioassays not included are water chemistry effects (e.g., pH), complex
-------
ECOTOX 5.4 User Guide
effluents, chemical mixtures, and sediment studies that do not report a water
concentration. If a publication contains data for a single chemical besides one of the
above categories of toxicants, the paper is retained and only the single chemical data
are used in ECOTOX. Test organisms are limited to those that are exclusively aquatic.
Amphibian and insect data for purely aquatic life stages of the organism are included.
Information and data for terrestrial life stages of these organisms is included in the
terrestrial database. Classes of organisms associated with the aquatic environment
(e.g., birds, mammals, reptiles) are abstracted for the terrestrial database. Microbial
communities (bacteria and virus) are omitted from the aquatic database. Terrestrial
plants tested in hydroponic or nutrient solutions are abstracted for the terrestrial
database.
The data elements for each test are grouped by chemical, organism, exposure
conditions, and effect endpoint. The test chemical parameters describe the toxicant, the
associated CAS registry number, and the grade, purity and/or composition of the
toxicant. The test organism parameters define the type of organism and the life-stage
being tested. The test conditions identify the test water, test location, exposure type
and duration, control parameters, and basic water chemistry. The effect endpoint
parameters consist of a code to define the lethal, sublethal, or residue endpoint and the
corresponding test chemical concentration.
Toxicity test results are primarily reported for observations taken during the chemical
exposure. However, when results are reported only for the time period after the
exposure, i.e. recovery or delayed effects (called 'Post-Exposure Measurements' in
ECOTOX), this type of result is noted by using a in conjunction with the
endpoint/effect code, e.g., ~MOR for a post-exposure or delayed mortality effect.
Terrestrial Data Elements
Toxicity data includes toxic effect results from exposures of single chemicals to
terrestrial organisms. The terrestrial toxicity database includes individual dose
response values, if reported. Only quantitative data are abstracted from the publication;
qualitative data are excluded. Graphical data may be recoded as ranges and are
reported by using <, > or ~ operators with the value.
Bioassays that are not included are contaminated soils, sediment studies and chemical
mixtures. If a publication contains data for a single chemical besides one of the above
categories of toxicants, the paper is retained and only the single chemical data are used
in ECOTOX. Test organisms are limited to those that are exclusively terrestrial.
The data elements for each test are grouped by chemical, organism, exposure
conditions, and effect endpoint. The test chemical parameters describe the toxicant, the
associated CAS registry number, and the grade, purity and/or composition of the
toxicant. The test organism parameters define the type of organism, organism source,
and the lifestage being tested. The test conditions identify the test location, exposure
type and duration, control parameters, and basic soil parameters. The effect endpoint
parameters consist of a code to define the lethal, sublethal, or residue endpoint and the
corresponding test chemical concentration.
If the author does not report data for a terrestrial database field, the field will display a
"NR' (not reported).
38
-------
ECOTOX 5.4 User Guide
The terrestrial data identifies sources of alternative data (domestic, laboratory animal or
plant toxicity and bioaccumulation information) when there is a paucity of information on
wildlife species. Animals associated with the aquatic environment that breathe using
lungs (e.g., ducks, whales) are included in the terrestrial database. Exposures to the
aquatic life stages of amphibians and insects are included in the aquatic database.
Decisions regarding the inclusion of animal terrestrial species are based on published
terrestrial wildlife toxicity standard methods and procedures documentation. The priority
for the animal portion of the database is wildlife avian species (e.g. mallard, pheasant or
bobwhite), mammalian species (e.g., meadow vole, deer mouse or mink), and
beneficial invertebrate species (e.g., earthworm, honey bee, leafcutter bee or alkali
bee). If data for other species including laboratory, domestic or non-beneficial
organisms are reported in a publication, data for all test species are abstracted for
ECOTOX inclusion.
Terrestrial plant data includes native, crop, or weed species. Terrestrial plants tested in
hydroponic or nutrient solutions are abstracted for the terrestrial database. Aquatic
plant exposures are recorded in the aquatic database portion of ECOTOX.
References
Center for Lake Superior Environmental Studies, University of Wisconsin-Superior,
1984, 1985, 1986, 1988, and 1990. Acute Toxicities of Organic Chemicals to Fathead
Minnows (Pimephales promelas), Vol. 1-5. University of Wisconsin-Superior, Superior,
Wl.
U.S. Environmental Protection Agency. 2020. GLTED Ecotoxicology Knowledgebase
System: ECOTOX Data Abstraction Guidelines (prepared by General Dynamic
Information Technology, Contract CIO-SP3, HHSN316201200013W, Task EP-G16H-
01256, SMAVCS3), Great Lakes Toxicology and Ecology Division, Duluth, MN.
39
-------
ECOTOX 5.4 User Guide
APPENDIX D: SPECIES AND CHEMICAL VERIFICATION
Species Verification
The test organism is identified by the current scientific name as verified in the taxonomic
literature. For each species entry, the verified name, taxonomic kingdom, nomenclature
history, and verification sources are kept on file for documentation purposes. A species
number can be located using the species scientific name or common name. ECOTOX
retains all species name synonyms that are no longer used for taxonomic classification.
These synonyms are identified within the scientific name file by a trailing 'Historical
name' after the scientific name. Searches in ECOTOX can be done using the species
synonym name, however, output will contain the currently accepted species name.
Taxonomic kingdoms are divided into plant (including fungi and monera) and animal.
Field studies may report results for a target community (e.g. benthic
macroinvertebrates) or for an entire enclosed ecosystem (e.g. system-level primary
productivity or respiration). If a community of organisms was tested, the species
grouping from the publication is reported.
Taxonomic Hierarchy
You can search on various taxonomic levels:
Kingdom
Phylum
Division
Subphylum
Superclass
Class
Order
Family
Genus
Species
Subspecies
Variety
The taxonomic levels are verified by the ITIS (Integrated Taxonomic Information
System, located at https://www.itis.gov. If the taxonomic levels are not available with
ITIS, other taxonomic sources are used.
40
-------
ECOTOX 5.4 User Guide
Predefined Special Interest Sources
The species of special interest groups were compiled using the following
references:
Standard Test Species References (Updated annually)
1. Amiard-Triquet, C., Amiard, J. C., and Mouneyrac, C. (2015). Aquatic Ecotoxicology -
Advancing Tools for Dealing with Emerging Risks. Kidlington, Oxford: Elsevier/Academic
Press. Print.
2. ASTM International - Environmental Assessment Standards and Risk Management Standards -
Biological Effects and Environmental Fate. Years 2012-2019.
3. EPA, Office of Prevention, Pesticides and Toxic Substances, Harmonized Test Guidelines, Series
850, Ecological Effects Test Guidelines. Years 2012/2016.
4. EPA, Office of Solid Waste and Emergency Response. (1994). ECO Update Catalogue of
Standard Toxicity Tests for Ecological Risk Assessment Publication 9345.0-051. Volume 2
Number 2.
5. Nikinmaa, M. (2014). An Intro to Aquatic Toxicology. Waltham, MA: Elsevier/Academic Press.
Print.
6. OECD (Organization for Economic Cooperation and Development) Test Guidelines. (2016).
OECD Guidelines for the Testing of Chemicals, Section 2: Effects on Biotic Systems. Years
1984-2018.
7. Rand, G. M. (2003). Fundamentals of aquatic toxicology: effects, environmental fate and risk
assessment - Second Edition. Ecological Services, Inc. New York, NY: Taylor and Francis
Group. Print.
U.S. Threatened and Endangered Species Reference (Updated Quarterly)
U.S. Fish and Wildlife Service (http://ecos.fws.gov/tess_public/pub/adHocSpeciesForm.jsp)
U.S. Exotic/Nuisance Species References
1. U.S. Department of the Interior. National Invasive Species Council.
http://www.invasivespecies.gov/profiles/main.shtml
2. Additional invasive species information is compiled through a collaboration with the Minnesota
Sea Grant - Exotic Species Information Center Coordinator.
41
-------
ECOTOX 5.4 User Guide
Chemical Verification
A standardized identification number and name for each chemical recorded in the
database is used for consistency. Chemicals reported in the ECOTOX Knowledgebase
are cataloged by using a Chemical Abstracts Service (CAS) registry number. If a CAS
registry number is not available for the test chemical, toxicity data cannot be included in
ECOTOX. Toxicants not included in ECOTOX are water chemistry effects (e.g., tests
based on hardness, pH, etc as the tested toxicant), complex effluents, chemical
mixtures and biological toxicants. If the author states that a soil nutrient is added to
maintain test organism growth, the test is included. If the test includes a series of
nutrient doses and a toxicant to produce interactive effects, this is considered a mixture
and excluded.
Retrieval is made by using the CAS number, chemical name or chemical list. The
Collective Index (CI) name is used as the standardized name for storage and retrieval.
A separate index file is available for screening CAS numbers and chemical names used
in ECOTOX. It is recommended, especially for critical decision-making, that users refer
to the original publication to obtain additional test chemical information which may affect
the context of toxicity information retrieved from ECOTOX.
For more information, please refer to the Chemical Verification section, linked from
the ECOTOX Help page under "ECOTOX Documentation."
42
-------
ECOTOX 5.4 User Guide
APPENDIX E: ECOTOX DATA FIELD DESCRIPTIONS
All associated terms for these fields are located in the "ECOTOX Terms
Appendix", available linked from the ECOTOX Help page.
Data fields are listed for both aquatic and terrestrial. If the field is only available for one
database, this is noted (Aquatic only or Terrestrial only).
Bibliographic Fields
Author
Publication author name(s), if available.
Reference Number
Each publication abstracted for ECOTOX is assigned a unique ECOTOX reference number (also
called an EcoREF number). These reference numbers appear in all default ECOTOX outputs.
Title
Publication title.
Source
Publication source or journal name.
Publication Year
Publication year.
Reference Citation
The reference number, author, publication year, title and source combined in one field.
Chemical Fields
CAS Number
Chemical Abstracts Service (CAS) Number.
Chemical Name
CAS Collective Index Name.
Chemical DTXSID
Substance Identifier from the U.S. EPA's Distributed Structure-Searchable Toxicity (DSSTox)
database (searchable on the U.S. EPA CompTox Chemicals Dashboard).
Chemical Grade
Grade of chemical.
43
-------
ECOTOX 5.4 User Guide
Chemical Purity
Percent purity or active ingredient.
Chemical Formulation
Formulation of chemical.
Chemical Comment
Chemical formulation code, trade names, synonyms, isomer names.
Chemical Radiolabel
The isotope of a test or carrier chemical.
Chemical Carrier
Solvent used to dissolve toxicant in solution or positive control. Contains all carriers (up to three)
and all the associated information (CAS #|Chemical Name|Chemical Grade|Chemical
Formulation|Chemical Radiolabel|Chemical Characteristics|Chemical Purity).
Species Fields
Species Number
Unique number assigned by ECOTOX software.
Species Scientific Name
Currently accepted scientific name (genus, species).
Species Common Name
Species or taxonomic grouping common name(s).
Species NCBI TaxlD
Numerical taxonomy identified from National Center for Biotechnology
Information (NCBI) Taxonomy Database.
Organism Source
The source from which the test organism was obtained.
Organism Lifestage
Initial test organism lifestage.
Organism Age
Initial age of the test organism.
Gender
The sex of the organism.
44
-------
ECOTOX 5.4 User Guide
Organism Initial Weight
Initial weight of organism.
Species Final Weight
Weight of the organism at the time of observation.
Organism Comment
Initial age, weight, length, developmental stage or cell concentration of test
organism.
Species Group
Predefined taxonomic groups name. For more documentation and list of groups, see
Predefined Taxonomic Groups.
Species Taxonomic Information
Organism classification hierarchy (Kingdom, Phylum/Division, Subphylum, Superclass,
Class, Order, Family, Genus, Species, Subspecies, Variety).
Kingdom
Divides all species into two kingdoms (plant or animal). The plant kingdom includes
Monera and Fungi species. A taxonomic group (e.g., aquatic community,
plankton) that has both plant and animal kingdoms into one result are included in both
plant and animal kingdom search. (Search option. Included in output with Species Taxonomic
Information.)
Test Condition Fields
Media Type
Aquatic - Freshwater (FW) tests include those 1) conducted in freshwater, reconstituted
water, distilled water, or tap water or 2) the organism habitat is exclusively freshwater.
Saltwater (SW) tests include those 1) conducted in natural or artificial seawater,
brackish water, or estuarine water or 2) the organism habitat is exclusively saline.
Note: If a salinity value of four parts per thousand is reported, it is considered a
freshwater test.
Terrestrial - Type of exposure media, (e.g., natural or artificial soil, hydroponic, filter
paper). If an aqueous exposure is conducted in pore water from a specific soil, the soil
parameters in the soil characteristics fields are reported (pH, CEC, OM, etc.). See
Appendix L. Exposure Media Terms in the "ECOTOX Terms Appendix" found under the
Help section of the website for more information.
Test Location
Aquatic - A natural (Field N) study is an experiment conducted outdoors in a natural
water body or in an artificial water body that has a natural bottom substrate and
established aquatic communities (e.g. phytoplankton, zooplankton and fish). Outdoor
studies conducted in an artificial water body without a natural bottom substrate are
45
-------
ECOTOX 5.4 User Guide
considered artificial studies (Field A). If the water body cannot be determined to be
natural or artificial it is coded as field unknown (Field U). All other studies are
considered laboratory (LAB) tests.
Terrestrial - The location or setting in which the experiment was conducted. For
example, a natural field study (Field N) is an experiment conducted outdoors in a
natural setting. The test organisms are sampled in the wild, e.g. population counts.
Outdoor studies conducted in a simulated environment are coded as an artificial field
study (Field A). Artificial field studies include organisms isolated from their natural
environment via an enclosure of some type, e.g. cages or fencing. If the publication
does not provide enough information to distinguish between Field A and Field N, then
use the code Field U to indicate that the field test type is unknown. Laboratory tests
(LAB) are conducted indoors under controlled laboratory conditions.
Exposure Duration
Aquatic - Exposure duration is coded using the units reported in the literature. For a
fluctuating or intermittent dosing experiment, the total exposure time is recorded. For
post-exposure measurements, report the duration of the entire study.
Terrestrial - Time period recorded in the data field is the time of actual exposure to the
chemical. It is assumed that the exposure duration is equivalent to the longest
observation time. In some instances, a biological time is used, such as an exposure
time reported as "until hatch", "growing season" or "after the nth egg has been laid".
For injection, diet and topical, and environmental exposures where the actual exposure
is dependent on biological and environmental conditions, the exposure time is recorded
as equivalent to the study time.
Author Reported and Standardized Duration
ECOTOX offers two output options for duration: the duration as the author reports in the
publication or duration that is converted to a standard unit (days).
Study Duration
In cases where the observation time is the only duration reported, it is assumed that the
exposure duration is equivalent to the study time.
In some instance, a biological time is used, such as an exposure time reported as "until
harvest", "growing season" or "after the nth egg has been laid." The term that best
describes the author's text is used.
For injection, diet, topical and environmental exposures where the actual exposure is
dependent on biological and environmental conditions, the exposure time is recorded as
equivalent to the study time.
Author Reported and Standardized Duration
ECOTOX offers two output options for duration, the duration as the author reports in the
publication or duration that is converted to a standard unit (days).
46
-------
ECOTOX 5.4 User Guide
Exposure Type
Aquatic - Exposures must either be aqueous, through diet, by injection, or in vitro.
Terrestrial - The mechanism by which the toxicant was applied. Organisms are typically
exposed to toxicants through diet, injection, topical, in vitro or environmental routes. On
occasion, an exposure may be through multiple routes (e.g., such as topical and oral).
Exposure types are searched by major exposure groups. However, a more specific
exposure type is displayed in your output (e.g., searching on 'Intercutaneous' is found
under the Injection exposure type).
Habitat
Indicates whether the study was completed in an aquatic or terrestrial
environment. For Terrestrial studies, the habitat can either be soil or non-soil.
Aquatic studies are all in water (aqua).
Chemical Analysis
Quantitative analysis of water in test chambers or field sites is considered a measured
concentration. Concentrations that are not analyzed in test chambers or field sites are
considered unmeasured (nominal).
Application Frequency
Author reported frequency of dosing application.
Study Type
Used to identify field simulation studies. Examples of field study types include
exposures conducted in a mesocosm, microcosm or enclosure.
Test Type
Author reported test type for the toxicity study (e.g. ACUTE, CHRONIC, ELS (Early
Life Stage), FLC (Full Life Cycle), or Generational).
Test Method
Denotes the test methodology used for the study, e.g. U.S.EPA or OECD guideline.
Control
Control information for the reported effect may be presented in the text, in a graph, or in
table format. ECOTOX does not make assessments whether the controls were
satisfactory or insufficient (e.g., replicates run, death of control organisms), but rather
documents author reported controls.
Number of Doses
The total number of exposure doses or concentrations, including the control(s), for
each independent test design.
47
-------
ECOTOX 5.4 User Guide
Doses
For all aquatic reports and terrestrial browser viewable, the individual doses used in the
study are summarized here.
For Terrestrial Excel and delimited reports, this data field is not included. Maximum
and minimum dose levels are found in the Terrestrial field 'Dose Max' and 'Dose
Min'.
Experimental Design
Additional study information is included here. For field tests, this could include exposure
system dimensions (e.g. pond or lake depth, cage or enclosure size), type of artificial
substrate, and physical or chemical water chemistry parameters. For laboratory studies,
this could include information about media, test chambers, and number of replicates.
Exposure Sample Number
Sample number reflects the initial sample size for each exposure dose, i.e., the number
of test organisms per treatment.
Gender
Identifies the initial sex (ML - Male, FM - Female, BH - Both) of the organism for each
exposure level.
Ionic Fraction
For ionizing substances such as metals, if authors report the concentration based on
the ionic form of the compound, this field has the ionic fraction (e.g., organotin as Sn).
Test Result Parameters
A separate line is used for each effect or endpoint from either a unique experimental
design or within one design scenario for statistically defined effects or endpoints. If no
statistics are used to distinguish endpoints or effects and experimental designs are
similar the data may be combined into one data record. Endpoints always require a
discrete line. Emphasis is placed on abstracting LC50, LD50, EC50 over other
regression analyzed endpoints (e.g., EC20, LC100, LD10) when an author reports both
endpoints. Effects lacking an author reported endpoint may be combined based on
statistical representation by the author. Food chain effects are abstracted for
organisms at the first level of exposure.
Toxicity test results are primarily reported for observations taken during the chemical
exposure. However, when results are reported only for the period of time after the
exposure, i.e. recovery or delayed effects (called 'Post-Exposure measurements' in
ECOTOX), this type of result is noted by using a in conjunction with the
endpoint/effect code, e.g., ~MOR for a post-exposure or delayed mortality effect.
Test Number
A computer-generated number used to designate each unique test design. A unique
test design may be characterized by a new test chemical, test species, test location,
or exposure type. Additionally, there are experimental design parameters that will
48
-------
ECOTOX 5.4 User Guide
influence a test scenario sufficiently to warrant an independent test number. Such
parameters include tests conducted at different test temperatures or conducted during
different seasons. There can be many Test Numbers for each ECOTOX Reference
Number.
Result (Record) Number
A computer-generated number used to designate each unique result within a Test
Number. A separate line is used for each effect or endpoint from either a unique
experimental design or within one design scenario for statistically defined effects or
endpoints. Each of these lines is designated with a Result Number. If no statistics are
used to distinguish endpoints or effects and experimental designs are similar, the data
may be combined into one data record. Endpoints always require a discrete line.
Effects lacking an author reported endpoint may be combined based on statistical
representation by the author. There can be many Result Numbers for each Test
Number, and many Test Numbers for each ECOTOX Reference Number. Within the
Aquatic and Terrestrial databases, each Result Number is a data record.
Endpoint
Endpoint information is abstracted if it is reported by the author. For the purposes of
ECOTOX, an endpoint is defined as the quantification of an observed effect obtained
through statistics or other means of calculation for the express purpose of comparing
equivalent effects (e.g., LC50). Many terrestrial plant tests do not have associated
endpoints. Prior to 1996, terrestrial plant database structure allowed only results based
on percent change from control.
An asterisk (*) denotes the reported endpoint acronym provided was modified to
conform to the standard database acronym terminology. For example, if the author
reported a TLM, the endpoint was recoded as an LC50* The author reported
acronym should appear in EE Remark field.
Effect
Effect information must be provided by the author in order for the test to be included.
For ECOTOX Knowledgebase purposes, effect is defined as the observation of a
response resulting from the action of a chemical stressor (e.g., mortality). The listing of
effect measurements can be found by using the Browse Effects index, ECOTOX
Terms List or "ECOTOX Terms Appendix" (includes many detailed measurement
definitions).
ECOTOX internally categorizes all observed effects under at least one of eleven
major effect groups:
Accumulation (ACC) - Process by which chemicals are taken into and stored in the
organism. Includes lethal body burden.
Behavior (BEH) - Activity of an organism represented by three subgroups, avoidance
(AVO), general behavior (BEH) and feeding behavior (FDB). All effects related to
reproductive behavior are listed under the Reproduction effect group.
Biochemistry (BCM) - Biotransformation or metabolism of chemical compounds, modes
of toxic action, and biochemical organism responses. Biochemical has three
49
-------
ECOTOX 5.4 User Guide
subgroups, biochemical (BCM), enzyme (ENZ) and hormone (HRM) effects.
Cellular (CEL) - Changes in structure and chemical composition of cells and tissues in
organisms. Three cellular subgroups include cellular (CEL) effects, genetics (GEN)
and histology (HIS).
Growth (GRO) - Encompasses individual organism weight, length, development and
morphology. Development (DVP) covers effects on tissue organization in growing early
life stages. Growth (GRO) represents length and weight changes at any point in the life
cycle. Morphology (MPH) measurements and endpoints address the structure (bones)
and form (organ/tissue development) of an organism at any stage of its life history.
Mortality (MOR) - Death of individuals or measurements that indicate death.
Physiology (PHY) - Basic cell and tissue activities. Subgroups include injury (INJ),
immunity (IMM) and intoxication (ITX).
Population (POP) - Effects on species or taxonomic group occupying the same area at
a given time.
Reproduction (REP) - Reproductive behavior, physiology and care of progeny
measurements. Offspring development effects are found in Growth effect group.
Ecosystem (SYS) - Ecosystem processes (PRS) include community structure and
function. Includes microbial processes.
Multiple Effect (MLT) - Change in more than one effect when data were reported as one result.
No Effect (NER) - The author reported an endpoint, but not a specific effect. This term will only
exist on a data transferred reference (OPP database (Reference number 344)) and is not a
searchable Effect term.
Effect Measurement
The specific parameter being measured for the observed effect. For instance, a Growth (GRO)
effect, would include specific measurements of weight or length (WGHT or LGTH). An Enzyme
(ENZ) effect would include specific measurements of catalase (CTLS) or peroxidase (PODA).
Trend
The observed or measured response trend as compared to the control is abstracted
when textually or graphically reported.
Response Site
A response site or tissue term is used to identify specific body, organ or tissue effect
sites for associated effect measurement.
EEComment
This field contains additional endpoint and/or effect text as described by the author.
50
-------
ECOTOX 5.4 User Guide
Effect %
Effect is reported as a raw percent value or percent change, e.g., percent of the total
population or percent increase or decrease. The term "COM" is used to denote several
effect measurements or response sites reporting data results as percentages.
Statistical Significance
Statistical analysis as compared to the control(s) in the test result.
Statistical Level
The level of significance (e.g. test statistic) is recoded when the author has reported
statistical analysis in the test result. Terminology for significance level may be presented
as: p =, p<, or alpha value. The terminologies are equivalent and are generally in the
range of 0.001 to 0.10.
Bioconcentration
The bioconcentration factor (BCF) or bioaccumulation factor (BAF) is the degree to which a
chemical can be concentrated in the tissues of an organism in the environment as a result of
exposure to chemicals at steady state during the uptake phase. The BCF/BAF is a value which is
equal to the concentration of a chemical in one or more tissues of the exposed organism divided
by the average exposure concentration of a chemical in the test. A bioconcentration endpoint is
recoded as either wet (or unknown) or as dry weight (BCF and BCFD, respectively). It is usually
reported with units of L/kg. If a unit cannot be determined from the information in the paper or it is
unitless, RA (ratio) is used for the unit.
Concentration Type
Concentrations based on the active ingredient or formulation, or as the total, un-ionized
or dissolved concentration, are identified.
Endpoint Assignment
Used to identify the source of the effect or endpoint information as reported specifically
by the author (P), or assigned by an ECOTOX reviewer (R)). The reviewer only assigns
the endpoint if the author has provided the statistical analysis that support the endpoint.
Concentration/Dose
The concentration or dose reflects either the range of concentrations tested or, if there
is an endpoint reported, the concentration associated with the endpoint. The confidence
interval or range is recorded when available. If an asterisk (*) denotes the concentration
has been recalculated from the author's original units to the standard concentration
(ug/L) needed for plot view or from the metal compound to the active ionic form.
In certain cases, the water concentration is routinely reported as active form of the test
chemical. For metal salts, the concentration is generally expressed as ug ion/L (e.g.,
HgCI is expressed as Hg+). Since 1998, the data distinguish between the metal
compound and the metal ion in the Ion field. Data abstracted prior to this date may have
comments regarding ionic fraction in Comment field.
When an exponential number is reported (e.g., 1 x 106), it is coded as E+n or E-n (e.g.,
1 E+6).
51
-------
ECOTOX 5.4 User Guide
Author Reported and Standardized Concentration
ECOTOX offers two output options for concentrations: the concentration as the author
reports in the publication, and (for Aquatic only) the concentration that is converted to
a standard unit ratio equivalent to ppm (mg/l, mg/kg bdwt, or mg/kg food), if possible.
ECOTOX unit conversion logic can be found here:
https://cfpub.epa.gov/ecotox/help.cfm.
Result Sample Number
The sample number reflects the sample size (e.g., 10 embryos) that the observation or
response value is based on at each exposure level. Sample units correspond to the
sample number (i.e., the unit on which the measurement or endpoint is based).
For generational studies and measurements based on the progeny, F1, F2, etc. are
noted in the sample unit field.
Observed Duration
The exposure duration when the result value was observed. This may be plus or minus
any up to the time at which the response to the toxicant was observed. If the
observation time is not reported or unable to be explicitly determined, a less than or
equal to (<=) the exposure duration is displayed.
Observations during the pretreatment time are reported as negative values. Report
as x' any pretreatment response observations for which time is unknown.
Author Reported and Standardized Duration
ECOTOX offers two output options for duration: the duration as the author reports in the
publication and or the duration that is converted to a standard unit (days).
Intake Rate
Denotes the amount of food taken by the organism.
Result % Dry/Wet Weight
If the effect measurement is based on dry (D) or wet (W) weight basis, it is denoted
in this field. If the percent moisture is reported, record the percentage value also (
e.g., W75%).
Result Percent Lipid
Percent lipid in the whole organism or response site.
Other Effects
Comments regarding other toxicity tests or effects reported in the publication that does
not meet ECOTOX minimum data requirements are recoded in this field. Commas
separate each distinct term and the text ends with a double slash {II).
Result Comment
Additional information related to the endpoint or effect response. Appendix G contains
header terms used to link the comment to a specific ECOTOX field.
52
-------
ECOTOX 5.4 User Guide
General Comment
This field contains additional information about any data field that does not fit in the
space provided. A complete list of comment identifiers that link to the associated field is
documented in Appendix Gl: Comment Field Header Names.
Water Chemistry Fields (Aquatic only)
These measured values pertain either to the test water chemistry (preferred) or the
dilution water chemistry values. If it is necessary to report the dilution water chemistry,
this is denoted by an asterisk (*).
Alkalinity - Expressed as reported by author.
Calcium - Expressed as reported by author
Chlorine - Expressed as reported by author
Conductivity - Expressed as reported by author
Dissolved Inorganic Carbon - Expressed as reported by author
Dissolved Oxygen - Expressed as reported by author. A "SAT" code denotes 100% saturation
Hardness - Expressed as reported by author. If the author only reports the terms
"hard" or "soft", these terms are recorded
Humic Acid - Expressed as reported by author
Organic Carbon Type and Value - Expressed as reported by author as Carbon. (T=
total, P= Particulate, D= Dissolved)
pH - pH value
Potassium - Expressed as reported by author
Salinity - Expressed as reported by author
Sodium - Expressed as reported by author
Sulfate - Expressed as reported by author
Sulfur - Expressed as reported by author
Temperature - Expressed as reported by author
53
-------
ECOTOX 5.4 User Guide
Outdoor Test Fields
Sub-Habitat Term/Description
A classification of the test study area (e.g. desert, estuarine, lacustrine, tundra).
The aquatic field tests include the Cowardin* system level classification to describe
major aquatic systems.
*Cowardin, L.M., V.Carter, F.C.Golet and E.T.LaRoe. 1979. Classification of Wetlands and Deepwater
Habitats of the United States. U.S. Fish and Wildlife Service, FWS/OBS-79, 31 p. (
https://www.fws.aov/wetlands/documents/Classification-of-Wetlands-and-Deepwater-Habitats-of-the-
United-States.pdf)
Sub-Habitat Comment
The author's description of the test study area (e.g. brackish marsh, wooded swamp, boreal
forest, citrus orchard).
Latitude/Longitude
The geographic location, latitude and longitude, of the test site.
Substrate Term/Description
The bottom substrate is recorded using standard substrate definitions or as author reports.
Water Depth
Water depth of the experimental system.
Geographic Term
The standardized name based on FIPS (Federal Information Processing Standards)
code, of the country, or United States and Canadian state/province where the test was
performed is displayed. You can view FIPS documentation at:
http://www.itl.nist.gov/fipspubs/fip10-4.htm
Geographic Location
Contains general text about the test site specific geographic identifiers (e.g., lake, river,
bay, field station or city) where the study was performed.
Application Type
The method of application of the chemical for an aquatic species in a field study.
Application Rate
This field contains the application rate value and the units. If an exposure concentration
is not reported, the application rate must be reported. Application rate units may be
recalculated only if the denominator is not equal to one (e.g. 5 g/2.5 ac).
Chemical Half-Life
The test chemical half-life in the system.
54
-------
ECOTOX 5.4 User Guide
Application Date/Season
The application date is recorded the time of initial exposure. This field includes the
actual date, a partial date or a season. The format is MO-DA-YR. Examples: 12-01-93,
01-00-75, 00-00-64. If one pond is exposed multiple times, only the first application date
is recorded. If the calendar year date is not reported, but a season is, the season
(Northern Hemisphere) of initial application of the chemical is reported.
Terrestrial Only Data Elements
(Dose) Statistical Method
The method used to determine the range around the dose, if reported by the
author(s). The terms standard deviation (SD), standard error (SE), range (R),
confidence interval (CI), confidence limits (CL) or confidence value (CV) of the dose
value are noted. Only included in browser view.
Test Comment
Additional information related to methodology or techniques used in the experimental
design. Appendix G contains header terms used to link the comment to a specific
ECOTOX field.
Exposure Comment
Additional information related to dosing methodology or techniques used in the test.
Observed Response Mean/Min/Max (Terrestrial Dose Response only)
The specific numeric observed response at a particular dose level [e.g. average weight
change of earthworms (mg/pot) might be -44 mg/cntr (mg/container)]. Response values
may include greater than (>), less than (<), minus (-) or approximation (~) symbols, if
used by the author(s). Response values must be numeric and from text or graph. If the
response is bioconcentration or bioaccumulation, the BCF or BAF value will be included
in this field. This field is limited to a subset of terrestrial studies with dose response data
and is no longer extracted.
Result Statistical Method/Observed Response Value (Terrestrial Dose Response only)
When the measurement unit of the Observed Response (Mean) includes a standard
deviation (SD), standard error (SE), range (R), confidence interval (CI), confidence
limits (CL) or confidence value (CV) of the observed response ,it is noted in the
Result Statistical Method. Its associated value is noted in the Observed Response
Value. This field is limited to a subset of terrestrial studies with dose response data
and is no longer extracted.
55
-------
ECOTOX 5.4 User Guide
Soil Parameter Fields (Terrestrial only)
Temperature
Expressed as reported by author.
Soil Type
The classification name of the natural soil or commercial name of the artificial soil used
in the study. If the classification name is not included, the type of soil is recorded using
the author's terminology, e.g., forest soil, sandy loam soil, arboreal coniferous soil.
Soil Sand %, Soil Silt %, Soil Clay %
The soil texture is stated using percentages of sand, silt and/or clay. Bentonite,
kaolinite or montmorillonite etc., are reported as clay.
Soil pH
The pH of the test media is recorded. If the pH of the treated media is not presented,
but the pH value is stated for the untreated or acclimation media, an asterisk (*) is
denoted. If the pH of a specific soil type is not given in the publication, a search is
made of the USDA/NRCS National Cooperative Soil Survey (USA) web site
(http://soils.usda.gov/) may be found for the specific soil series.
Media Organic Matter
If organic matter is reported for the untreated or acclimation media, it will be displayed
with an asterisk (*). If the organic matter of a specific soil type is not provided in the
publication, information from the USDA/NRCS National Cooperative Soil Survey (USA)
is used for the specific soil series.
Media Moisture
The percentage of moisture in the test media is recorded. If moisture is reported for the
untreated or acclimation media, this moisture percentage is recoded and denoted it
with an asterisk (*).
Media Cation Exchange Capacity
The media cation exchange capacity is recorded. If the cation exchange capacity is
reported for the untreated or acclimation media, this value is denoted with an asterisk.
Soil Dose Measured
The toxicant concentration that was measured in the soil. However, the exposure
dose value may or may not reflect the measured values. The Chemical Analysis field
will denote if the exposure dose value is based on the measured values.
Media Measurement (wet/dry)
Denotes whether the soil concentration was reported based on dry or wet weight basis.
56
-------
ECOTOX 5.4 User Guide
APPENDIX F: INDEPENDENTLY COMPILED DATA FILES
Some independently compiled data sets have been transferred into ECOTOX from
external sources. The data sets must meet the ECOTOX data parameter and quality
assurance guidelines.
The U.S. EPA Duluth laboratory data set includes the Acute Toxicity of Organic
Chemicals file which contains data for a single test species (30-day fathead minnow).
The U.S. EPA Office of Toxic Substances is acknowledged for long-term support in the
generation of all acute toxicity data for organic chemicals. All test results, including data
not available on-line, have been compiled in five volumes titled: Acute Toxicities of
Organic Chemicals to Fathead Minnows (Pimephales promelas), available from the
Center for Lake Superior Environmental Studies, University of Wisconsin, Superior, Wl.
International cooperative efforts with the Organization for Economic Cooperation and
Development (OECD) and the Commonwealth of Independent States (Borok Institute)
were conducted to enhance the review of the International literature. These efforts
resulted in digital data files from France, Germany, the Netherlands, and Russia
received in the early 1990s and incorporated into ECOTOX.
The Office of Pesticide Programs' Pesticide Ecotoxicity Database (formerly
Environmental Effects Database) is a compilation of the toxic effects data for registered
pesticides. These data have been reviewed and categorized as acceptable for
fulfillment of pesticide registration and re-registration guideline requirements as
explained under FIFRA Subdivision E, Parts 158.145 and 158.150. Data for the
Pesticide Ecotoxicity Database are drawn from several sources. The major portion of
the data is derived from actual Agency reviews of toxicological studies conducted by
commercial laboratories and submitted by pesticide companies in support of their
products. The U.S. EPA conducts audits of these laboratories on a periodic basis
through the U.S. EPA Office of Compliance and Monitoring. A second major source of
data entries is the numerous studies conducted by U.S. EPA, USDA, and U.S. FWS
laboratories over the last 25 years. The Office of Pesticide Programs is actively
updating this database. Updates will be incorporated into ECOTOX on an on-going
basis, starting with the acute Honeybee (Apis mellifera) and Bumblebee (Bombus
terrestris) toxicity data (updated in ECOTOX in December 2020).
The U.S. Geological Survey, Biological Resources Division, Columbia Environmental
Research Center (CERC) located in Columbia, Missouri
(https://www.usas.gov/centers/cerc) database summarizes the results from aquatic
acute toxicity tests conducted by this research facility. The acute toxicity test provides a
relative starting point for hazard assessment of contaminants and is required for federal
chemical registration programs such as the Federal Insecticide Fungicide Rodenticide
Act (PL 80-104) as amended by the Federal Environmental Pesticide Control Act of
1972 (7 U.S.C. 136-136y) and the Toxic Substances Control Act of 1976 (PL 94-469).
The database was initially developed in 1986 by Foster L. Mayer and Mark R. Ellersieck
for 4,901 acute toxicity tests toxicity tests conducted by CERC since 1965 with 410
chemicals and 66 species of aquatic animals. A report by Mayer and Ellersieck (1986)
57
-------
ECOTOX 5.4 User Guide
provides an interpretation of the original 4,901 toxicity tests which utilizes various
statistical approaches to make taxonomic comparisons, and to assess the degree to
which various factors (static versus flow-through, age of test solutions, pH, temperature,
water hardness, and diet) affect toxicity (Manual of Acute Toxicity: Interpretation and
Data Base for 410 Chemicals and 66 Species of Freshwater Animals, F.L. Mayer and
M.R. Ellersieck, United States Department of the Interior, U.S. Fish and Wildlife Service,
Resource Publication 160, 1986). This publication is commonly referred to as the "Gold
Book".
The available data sets, data, institution address and contacts are listed below:
Institution Contact Information
Data Summary and
Reference Numbers
EPA: Fathead Minnow Acute Toxicity Database (GLTED-Duluth MN)
To obtain hard copies of the University of Wisconsin-Superior (UWS)
volumes contact:
University of Wisconsin/ Lake Superior Research Institute
PO Box 2000
Superior, Wl 54880
Contact: MattTenEyck
E-mail: MTenEyck@uwsuper.edu
Phone: 715-394-8160
For technical information on the database contact:
U.S. EPA/ORD/CCTE/GLTED
Contact: Dale Hoff
E-mail: hoff.dale@epa.qov
5 references (#3217,
12447,12448, 12858,
12859)
1133 aquatic records
French (OECD-IRCHA)
Ecotoxicology Department, INERIS
Rue Lavoisier, B.P. 1
F-91710 Vert Le Petit
France
Most recent contact:
http://www.ineris.fr/
Contact: Dr. Roger Cabridenc
Phone: 33-1-45960956; Fax: 33-1-45960957
13 references (#20, 3397,
3516, 3517, 3518, 3519,
3520,3521, 5161, 6771,
9170, 10724, 15300)
256 aquatic records
58
-------
ECOTOX 5.4 User Guide
Institution Contact Information
Data Summary and
Reference Numbers
German (OECD)
Umweltbundesamt, Federal Environmental Agency
Dienstgebaude Berlin-Mitte
Mauerstrabe 45-52
0-1080 Berlin Germany
Worlitzer Platz 1
06844 Dessau-RoGlau
Germany
Most recent contacts:
Telephone: +49-340-2103-0
Fax: +49-340-2103-2285
Email: Gerlinde.knetsch@uba.de
or:
Dieter Schudoma
German Environment Agency
Section IV 2.4: Water-hazardous substances/ Ecotoxicology laboratory
Schichauweg 58,
12307 Berlin
Tel: (+49-30) 8903 4225
Fax: (+49-30) 8903 4233
Email: dieter,schudoma®>uba,de
186 references (citation
refers to OECDG
Database)
10494 aquatic records
1873 terrestrial records
Dutch (OECD)
National Institute of Public Health and Environmental Protection
(RIVM/ACT)
PO Box 1, 3720 BA Bilthoven
The Netherlands
htto://ri vm.nl/en/
Most recent contact:
Contact: Dr. Hans Canton
E-mail: ecocr@sb615.rivm.nl
17 references (#5180,
5331,5333,5336, 5337,
5356,5367,5370, 5374,
5375, 5378, 5390, 5400,
5411,5414, 11039,
11044)
1992 aquatic records
Russia
Borok Institute, Institute for Biology of Inland Waters, Academy of Sciences
152742 Borok, Nekouz, Yaroslavsky Region
Russian Republic
htto://www.ibiw.ru/
Most recent contact:
Contact: Victor Komov
E-mail: vkomov®. ibiw.varoslavl.ru
55 references
255 aquatic records
59
-------
ECOTOX 5.4 User Guide
Institution Contact Information
Data Summary and
Reference Numbers
EPA: Office of Pesticides Program Database (OPP)
(Pesticide Ecotoxicity Database -formerly Ecological Effects Database)
U.S. Environmental Protection Agency
Office of Pesticide Programs
Environmental Fate and Effects Division,
Ecological Effects Branch
401 M St. SW
Washington, DC 20460
httDs://www.eDa.aov/Desticide-contacts/office-Desticide-Droarams-contacts-
Reference #344
16,956 aquatic records
17,848 terrestrial records
Reference #184644
- Acute Bee Studies
1,494 terrestrial records
division-and-tooic
Contact: Nicholas Mastrota
E-mail: Mastrota.Nicholas@eDa.aov
USGS Acute Toxicity Database (Mayer & Ellersieck, 1986 - commonly
referred to as the "Gold Book")
Columbia Environmental Research Center
U.S. Geological Survey
4200 New Haven Road, Columbia, Missouri 65201
Phone: 573-875-5399
(http://www.cerc.usqs.qov/data/acute/acute.html)
Contact: Linda Sappington
E-mail: linda saDDinaton@usas.aov
1 reference (#6797)
8761 aquatic records
60
-------
ECOTOX 5.4 User Guide
APPENDIX G: COMMENT FIELD HEADER NAMES
Aquatic Comment Abbreviations
Comment headers codes are used to link additional data provided to the primary
database field.
Header Abbreviation
Associated Field Name
ALK
Alkalinity
APTY
Application Type
AP SEAS
Application Season
AP DATE
Application Date
AP RATE
Application Rate
AP FREQ
Application Frequency
BCF
Bioconcentration
CARRIER
Carrier or Solvent
CHAR
Chemical Comment
CL
Chlorine Value and Unit
COMPEP
Companion Endpoint
CONC
Concentration
COND
Conductivity
CONTR
Control
DEPTH
Water Depth
DNUM
Number of Doses
DO
Dissolved Oxygen
DOSES
Individual Concentration Value and Unit
ETIME
Exposure Time and Unit
FO
Chemical Formulation
FW, SW
Freshwater/Saltwater Exposure Media
GRADE
Chemical Grade
HAB
Habitat Description
HALF
Half Life
HARD
Hardness
HMA
Humic Acid Value and Unit
61
-------
ECOTOX 5.4 User Guide
Header Abbreviation
Associated Field Name
In EE Comment
Endpt (Endpoint)
In EE Comment
Measurement
In EE Comment
Effect
INTAKE
Food Intake Rate and Unit
LAB, FIELD
Location
LAT
Latitude
LD
Percent Lipid
LEVEL
Statistical Level
LIFESTG
Organism Lifestage
LOC
Location
LONG
Longitude
MSMT
Effect Measurement
NA
Sodium Value and Unit
ORG C
Organic Carbon
PH
PH
POT
Potassium Value and Unit
PURITY
Chemical Purity
RADIO
Chemical Radiolabel
SALIN
Salinity
SAMPN
Sample Number and Unit
SEX
Gender
SIGNIF
Significance
SITE
Response Site
S04
Sulfate Value and Unit
SOLVCHAR
Chemical Carrier Comment
SOLVFO
Chemical Carrier Formulation
SOLVGRADE
Chemical Carrier Grade
SOLVPURITY
Chemical Carrier Purity
SOURCE
Organism Source
STST
Steady State
STYPE
Study Type
SUBSTR
Substrate Comment
62
-------
ECOTOX 5.4 User Guide
Header Abbreviation
Associated Field Name
SULF
Sulfur Value and Unit
TEMP
Temperature
TESTID
Test Number
TIME
Exposure Time
TREND
Effect Trend
TMETH
Test Method
TYPE
Exposure Type
WTAT
Weight at Time of Result
WTINT
Initial Body Weight
Terrestrial Comment Abbreviations
Comment headers codes are used to link additional data provided to the primary
database field.
Header Abbreviations
Associated Field Name
ANALYSIS
Chemical Analysis
AP DATE
Application Date
AP FREQ
Application Frequency
AP RATE
Application Rate
AP SEAS
Application Season
CEC
Media Cation Exchange Capacity
CHAR
Chemical Comments
COMPEP
Companion Endpoint
CONCTYPE
Concentration Type
CONTR
Control
DNUM
Number of Doses
DOSE/ DUNIT
Exposure Dose and Unit,
DOSES
Individual Concentrations Value and Unit
DW
Dry or Wet Weight
EDES
Experimental Design
EFCT
Effect
63
-------
ECOTOX 5.4 User Guide
Header Abbreviations
Associated Field Name
EFCT%
Effect Percent
ENDPT
Endpoint Assigned
ETIME
Exposure Duration
FO
Chemical Formulation
GEO
Geographic Code
HABCODE
Habitat Code
HABITAT
Habitat
INTAKE
Intake Rate and Unit
ION
Ionic Fraction
LAT
Latitude
LD
Percent Lipid
LIFESTG/ AGE
Lifestage/Age
LOC
Test Location
LONG
Longitude
MEDIA
Media Type
MOIST
Media Moisture
MSMT
Effect Measurement
OCHAR
Organism Comment
OEF
Other Effects
OM
Media Organic Matter
OTIME
Observation Time
PC, CARRIER
Chemical Name, Type
PH
Media pH
RADIO
Chemical Radiolabel
RSITE
Response Site
RVALUE / RUNIT
Observed Response Value/ Unit
SAMPN/NUNIT
Sample Number and Unit
SEX
Gender
SIGNIF
Statistical Significance
SOIL
Soil Type
SOURCE
Organism Source
64
-------
ECOTOX 5.4 User Guide
Header Abbreviations
Associated Field Name
STIME
Study Duration
STST
Steady State
STYPE
Study Type
TEMP
Temperature
TEXTURE
Soil Texture
TREND
Effect Trend
TYPE
Exposure Type
TMETH
Test Method
WTAT
Weight at Time of Result
WTINT
Initial Body Weight
65
-------
ECOTOX 5.4 User Guide
APPENDIX H: DELIMITED OUTPUT HEADER NAMES
Aquatic Report Output Fields
A forward slash (/) within a field refers to an associated comment in a separate field.
Users should refer to the full publication for proper interpretation.
/Vote: OP = Operator (>, >=, <. =<. =)
Report Header
Delimited File Header Name
Header Name Definition
Alk. (7 fields)
Alkalinity Mean Op
Alkalinity Mean Operator
Alkalinity Mean
Alkalinity Mean Value
Alkalinity Min Op
Alkalinity Minimum Operator
Alkalinity Min
Alkalinity Minimum Value
Alkalinity Max Op
Alkalinity Maximum Operator
Alkalinity Max
Alkalinity Maximum Value
Alkalinity Units
Alkalinity Units
Appl. Date
Application Date
Application Date
Appl. Freq. (7 fields)
Application Frequency Mean Op
Application Frequency Mean Operator
Application Frequency Mean
Application Frequency Mean Value
Application Frequency Min Op
Application Frequency Minimum Operator
Application Frequency Min
Application Frequency Minimum Value
Application Frequency Max Op
Application Frequency Maximum
Operator
Application Frequency Max
Application Frequency Maximum Value
Application Frequency Units
Application Frequency Units
Appl. Rate (2 fields)
Application Rate
Application Units
Application Rate
Application Units
Appl. Seas. (2 fields)
Application Season
Application Season Description
Application Season
Application Season Description
Appl. Type
Application Type
Application Type
Author
Author
Author
66
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
BCF (21 fields)
BCF1 Value Op
First Bioconcentration Factor Mean
Operator
Note: The Concentration
Type determines the
fraction measured in BCF1
and BCF 2.
BCF1 Value
First Bioconcentration Factor Mean Value
BCF1 Min Op
First Bioconcentration Factor Minimum
Operator
BCF1 Min
First Bioconcentration Factor Minimum
Value
BCF1 Max Op
First Bioconcentration Factor Maximum
Operator
BCF1 Max
First Bioconcentration Factor Maximum
Value
BCF1 Unit
First Bioconcentration Factor Unit
BCF2 Value Op
Second Bioconcentration Factor Mean
Operator
BCF2 Value
Second Bioconcentration Factor Mean
BCF2 Min Op
Second Bioconcentration Factor
Minimum Operator
BCF2 Min
Second Bioconcentration Factor
Minimum Value
BCF2 Max Op
Second Bioconcentration Factor
Maximum Operator
BCF2 Max
Second Bioconcentration Factor
Maximum Value
BCF2 Unit
Second Bioconcentration Factor
Unit
BCF3 Value Op
Third Bioconcentration Factor Mean
Operator
BCF3 Value
Third Bioconcentration Factor Mean
BCF3 Min Op
Third Bioconcentration Factor Minimum
Operator
BCF3 Min
Third Bioconcentration Factor Minimum
Value
BCF3 Max Op
Third Bioconcentration Factor Maximum
Operator
BCF3 Max
Third Bioconcentration Factor Maximum
Value
BCF3 Unit
Third Bioconcentration Factor Unit
Calcium Mean
Calcium Mean Value
67
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Calcium (7 fields)
Calcium Mean Op
Calcium Mean Operator
Calcium Mean
Calcium Mean Value
Calcium Min Op
Calcium Minimum Operator
Calcium Min
Calcium Minimum Value
Calcium Max Op
Calcium Maximum Operator
Calcium Max
Calcium Maximum Value
Calcium Units
Calcium Units
CAS#
CAS Number
Test Chemical Abstract Services Registry
Number
Chem. DTXSID
Chemical DTXSID
Test Chemical DSSTox Substance
Identifier
Chem. Anal.
Chemical Analysis
Chemical Analysis
Chemical Carrier
Chemical Carrier
Contains all carriers (up to three) and all
the associated information (CAS
#|Chemical Name|Chemical
Grade|Chemical Formulation|Chemical
Radiolabel|Chemical
Characteristics|Chemical Purity).
Chem. Comment
Chemical Comment
Test Chemical Comment
Chem. Form.
Chemical Formulation
Chemical Formulation
Chem. Grade
Chemical Grade
Chemical Grade
Chem. Half Life (7 fields)
Chemical Half Life Mean OP
Chemical Half Life Mean Operator
Chemical Half Life Mean
Chemical Half Life Mean
Half Life Min OP
Half Life Minimum Operator
Half Life Min
Half Life Minimum
Half Life MaxOP
Half Life Maximum Operator
Half Life Max
Half Life Maximum
Half Life Unit
Half Life Unit
Chemical
Chemical Name
Chemical Name
Chem. Pur. (6 Fields)
Chemical Purity Mean OP
Chemical Purity Mean Operator
Chemical Purity Mean
Chemical Purity Mean
Chemical Purity Min OP
Chemical Purity Minimum Operator
Chemical Purity Min
Chemical Purity Minimum
Chemical Purity Max OP
Chemical Purity Maximum Operator
Chemical Purity Max
Chemical Purity Maximum
68
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Chem. Radiolabel
Chemical Radiolabel
Chemical Radiolabel
Chlorine
Chlorine Mean OP
Chlorine Mean Operator
Chlorine Mean
Chlorine Mean
Chlorine Min OP
Chlorine Minimum Operator
Chlorine Min
Chlorine Minimum
Chlorine Max OP
Chlorine Maximum Operator
Chlorine Max
Chlorine Max
Chlorine Unit
Chlorine Unit
Cone (48 fields) (Author) or
(ug/L)
Concentration 1 Mean Op
First Concentration Mean Operator
(Author) or (ug/L)
Concentration 1 Mean
First Concentration Mean Value (Author)
or (ug/L)
Concentration 1 Min Op
First Concentration Minimum Operator
(Author) or (ug/L)
Concentration 1 Min
First Concentration Minimum Value
(Author) or (ug/L)
Concentration 1 Max Op
First Concentration Maximum Operator
(Author) or (ug/L)
Concentration 1 Max
First Concentration Maximum Value
(Author) or (ug/L)
Concentration Typel
First Concentration Type (Author) or
(ug/L)
Concentration2 Mean Op
Third Concentration Mean Operator
(Author) or (ug/L)
Concentration2 Mean
Third Concentration Mean Value (Author)
or (ug/L)
Concentration2 Min Op
Third Concentration Minimum (Author) or
(ug/L) Operator
Concentration2 Min
Third Concentration Minimum Value
Concentration2 Max Op
Third Concentration Maximum Operator
(Author) or (ug/L)
Concentration2 Max
Third Concentration Maximum Value
(Author) or (ug/L)
Concentration Type 2
Third Concentration Type (Author) or
(ug/L)
Concentrations Mean Op
Third Concentration Mean Operator
(Author) or (ug/L)
69
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Concentrations Mean
Third Concentration Mean Value (Author)
or (ug/L)
Concentrations Min Op
Third Concentration Minimum (Author) or
(ug/L) Operator
Concentrations Min
Third Concentration Minimum Value
Concentrations Max Op
Third Concentration Maximum Operator
(Author) or (ug/L)
Concentrations Max
Third Concentration Maximum Value
(Author) or (ug/L)
Concentration Type 3
Third Concentration Type (Author) or
(ug/L)
Concentration Units
Author or ug/L
Control
Control
Control
Conductiv. (7 fields)
Conductivity Mean Op
Conductivity Mean Operator
Conductivity Mean
Conductivity Mean Value
Conductivity Min Op
Conductivity Minimum Operator
Conductivity Min
Conductivity Minimum Value
Conductivity Max Op
Conductivity Maximum Operator
Conductivity Max
Conductivity Maximum Value
Conductivity Units
Conductivity Units
D.O. (7 fields)
Dissolved Oxygen Mean Op
Dissolved Oxygen Mean Operator
Dissolved Oxygen Mean
Dissolved Oxygen Mean Value
Dissolved Oxygen Min Op
Dissolved Oxygen Minimum Operator
Dissolved Oxygen Min
Dissolved Oxygen Minimum Value
Dissolved Oxygen Max Op
Dissolved Oxygen Maximum Operator
Dissolved Oxygen Max
Dissolved Oxygen Maximum Value
Dissolved Oxygen Units
Dissolved Oxygen Units
Dissolved Inorganic
Carbon (7 fields)
Dissolved Inorganic Carbon
Mean Op
Dissolved Inorganic Carbon Mean
Operator
Dissolved Inorganic Carbon
Mean
Dissolved Inorganic Carbon Mean Value
Dissolved Inorganic Carbon
Min Op
Dissolved Inorganic Carbon Minimum
Operator
Dissolved Inorganic Carbon
Min
Dissolved Inorganic Carbon Minimum
Value
70
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Dissolved Inorganic Carbon
Max Op
Dissolved Inorganic Carbon Maximum
Operator
Dissolved Inorganic Carbon
Maximum
Dissolved Inorganic Carbon Maximum
Value
Dissolved Inorganic Carbon
Units
Dissolved Inorganic Carbon Units
Effect
Effect
Effect
Effect Meas.
Effect Measurement
Effect Measurement
Eff. Percent (6 fields)
Effect Percent Mean Op
Effect Percent Mean Value Operator
Effect Percent Mean
Effect Percent Mean Value
Effect Percent Min Op
Effect Percent Minimum Value Operator
Effect Percent Min
Effect Percent Minimum Value
Effect Percent Max Op
Effect Percent Maximum Value Operator
Effect Percent Max
Effect Percent Maximum Value
Endpoint
Endpoint
Endpoint
Endpoint Assign.
Endpoint Assignment
Endpoint Assignment
EE Comment
EE Comment
Effect Endpoint (EE) Comment
Exp. Design
Experimental Design
Experimental Design Comment
Exp. Dur. (14 fields)
(Author) or (Days)
Exposure Duration Op
Exposure Duration Operator
Exposure Duration
Exposure Duration Value
Exposure Duration Min Op
Exposure Duration Minimum Operator
Exposure Duration Min
Exposure Duration Minimum Value
Exposure Duration Max Op
Exposure Duration Maximum Operator
Exposure Duration Max
Exposure Duration Maximum Value
Exposure Duration Units
Exposure Duration Units
Exposure Sample Number
Exposure Sample Number
Exposure Sample Number
Exp. Type
Exposure Type
Exposure Type
General Comments
General Comments
General Comments
Geog. Loc
Geographic Location
Geographic Location
Geog. Code
Geographic Code
Geographic Code
Gender
Gender
Gender
Habitat
Habitat
Habitat
71
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Hardness (mg/L) (7 fields)
Hardness Mean Op
Hardness Mean Operator
Hardness Mean
Hardness Mean Value
Hardness Min Op
Hardness Minimum Operator
Hardness Min
Hardness Minimum Value
Hardness Max Op
Hardness Maximum Operator
Hardness Maximum
Hardness Maximum Value
Hardness Units
Hardness Units
Humic Acid (mg/L) (7 fields)
Humic Acid Mean Op
Humic Acid Mean Operator
Humic Acid Mean
Humic Acid Mean Value
Humic Acid Min Op
Humic Acid Minimum Operator
Humic Acid Min
Humic Acid Minimum Value
Humic Acid Max Op
Humic Acid Maximum Operator
Humic Acid Maximum
Humic Acid Maximum Value
Humic Acid Units
Humic Acid Units
Intake Rate (7 Fields)
Intake Rate Mean Op
Intake Rate Mean Operator
Intake Rate Mean
Intake Rate Mean Value
Intake Rate Min Op
Intake Rate Minimum Operator
Intake Rate Min
Intake Rate Minimum Value
Intake Rate Max Op
Intake Rate Maximum Operator
Intake Rate Maximum
Intake Rate Maximum Value
Intake Rate Units
Intake Rate Units
Ion (3 fields)
Ionic Fractionl
Ionic Fractionl
Ionic Fraction2
Ionic Fraction2
Ionic Fraction3
Ionic Fraction3
Lat/Long
Latitude/Longitude
Latitude/Longitude
Magnesium (mg/L) (7 fields)
Magnesium Mean Op
Magnesium Mean Operator
Magnesium Mean
Magnesium Mean Value
Magnesium Min Op
Magnesium Minimum Operator
Magnesium Min
Magnesium Minimum Value
Magnesium Max Op
Magnesium Maximum Operator
Magnesium Maximum
Magnesium Maximum Value
Magnesium Units
Magnesium Units
72
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Media Type
Media Type
Media Type
Number of Doses
Number of Doses
Number of Doses
Obs. Dur. (14 fields)
(Author) or (Days)
Observed Duration Op
Observed Duration Operator
Observed Duration
Observed Duration Value
Observed Duration Min Op
Observed Duration Minimum Operator
Observed Duration Min
Observed Duration Minimum Value
Observed Duration Max Op
Observed Duration Maximum Operator
Observed Duration Max
Observed Duration Maximum Value
Observed Duration Units
Observed Duration Units
Org. Carb. Type
Value (8 fields)
Organic Carbon Mean Op
Organic Carbon Mean Operator
Organic Carbon Mean
Organic Carbon Mean Value
Organic Carbon Min Op
Organic Carbon Minimum Operator
Organic Carbon Min
Organic Carbon Minimum Value
Organic Carbon Max Op
Organic Carbon Maximum Operator
Organic Carbon Maximum
Organic Carbon Maximum
Organic Carbon Units
Organic Carbon Units
Organic Carbon Type
Organic Carbon Type
Org. Age (7 fields)
Organism Age Mean Op
Organism Age Mean Operator
Organism Age Mean
Organism Age Mean
Organism Age Min Op
Organism Age Minimum Operator
Organism Age Min
Organism Age Minimum
Organism Age Max Op
Organism Age Maximum Operator
Organism Age Max
Organism Age Maximum
Organism Age Units
Organism Age Units
Org. Comment
Organism Comment
Organism Comment
Species Final Weight
Species Final Weight Mean
Op
Species Final Weight Mean Operator
Species Final Weight Mean
Species Final Weight Mean
Species Final Weight Min Op
Species Final Weight Minimum Operator
73
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Species Final Weight Min
Species Final Weight Minimum
Species Final Weight Max Op
Species Final Weight Maximum Operator
Species Final Weight Max
Species Final Weight Maximum
Species Final Weight Units
Species Final Weight Units
Organism Initial Weight
Organism Initial Weight Mean
Op
Organism Initial Weight Mean Operator
Organism Initial Weight Mean
Organism Initial Weight Mean
Organism Initial Weight Min
Op
Organism Initial Weight Minimum
Operator
Organism Initial Weight Min
Organism Initial Weight Minimum
Organism Initial Weight Max
Op
Organism Initial Weight Maximum
Operator
Organism Initial Weight Max
Organism Initial Weight Max
Organism Initial Weight Units
Organism Initial Weight Units
Org. Lifestg.
Organism Lifestage
Organism Lifestage
Organism Source
Organism Source
Organism Source
Other Effects
Other Effects
Other Effects
pH (6 fields)
pH Mean Op
pH Mean Operator
pH Mean
pH Mean Value
pH Min Op
pH Minimum Operator
pH Min
pH Minimum Value
pH Max Op
pH Maximum Operator
pH Maximum
pH Maximum Value
Potassium (7 Fields)
Potassium Mean Op
Potassium Mean Operator
Potassium Mean
Potassium Mean Value
Potassium Min Op
Potassium Minimum Operator
Potassium Min
Potassium Minimum Value
Potassium Max Op
Potassium Maximum Operator
Potassium Maximum
Potassium Maximum Value
Potassium Unit
Potassium Unit
Pub. Year
Publication Year
Publication Year
Ref#
Reference Number
ECOTOX Reference Number
74
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Reference Citation (4
fields)
Author
Title
Publication Year
Source
Author
Title
Publication Year
Source
Resp. Site
Response Site
Response Site
Result Comment
Result Comment
Result Percent Lipid (6
Fields)
Result Percent Lipid Mean Op
Result Percent Lipid Mean Operator
Result Percent Lipid Mean
Result Percent Lipid Mean Value
Result Percent Lipid Min Op
Result Percent Lipid Minimum Operator
Result Percent Lipid Min
Result Percent Lipid Minimum Value
Result Percent Lipid Max Op
Result Percent Lipid Maximum Operator
Result Percent Lipid Maximum
Result Percent Lipid Maximum Value
Result Number
Result Number
Result Sample Number and
Unit
Result Sample Number Mean
Op
Result Sample Number Mean Operator
Result Sample Number Mean
Result Sample Number Mean Value
Result Sample Number Min
Op
Result Sample Number Minimum
Operator
Result Sample Number Min
Result Sample Number Minimum Value
Result Sample Number Max
Op
Result Sample Number Maximum
Operator
Result Sample Number
Maximum
Result Sample Number Maximum Value
Result SampleUnit
Result Sample Number Unit
Result Percent Dry/Wet
Weight
Result Percent Dry/Wet
Weight Mean Op
Result Percent Dry/Wet Weight Mean
Operator
Result Percent Dry/Wet
Weight Mean
Result Percent Dry/Wet Weight Mean
Value
Result Percent Dry/Wet
Weight Min Op
Result Percent Dry/Wet Weight Minimum
Operator
Result Percent Dry/Wet
Weight Min
Result Percent Dry/Wet Weight Minimum
Value
Result Percent Dry/Wet
Weight Max Op
Result Percent Dry/Wet Weight Maximum
Operator
Result Percent Dry/Wet
Weight Maximum
Result Percent Dry/Wet Weight Maximum
Value
75
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Result Percent Dry/Wet
Weight Unit
Result Percent Dry/Wet Weight Unit
Salin. (7 fields)
Salinity Mean Op
Salinity Mean Operator
Salinity Mean
Salinity Mean Value
Salinity Min Op
Salinity Minimum Operator
Salinity Min
Salinity Minimum Value
Salinity Max Op
Salinity Maximum Operator
Salinity Max
Salinity Maximum Value
Salinity Units
Salinity Units
Sig. Level
Significance Level Mean Op
Significance Level Mean Operator
Significance Level Mean
Significance Level Mean Value
Significance Level Min Op
Significance Level Minimum Operator
Significance Level Min
Significance Level Minimum Value
Significance Level Max Op
Significance Level Maximum Operator
Significance Level Max
Significance Level Maximum Value
Sodium
Sodium Mean Op
Sodium Mean Operator
Sodium Mean
Sodium Mean Value
Sodium Min Op
Sodium Minimum Operator
Sodium Min
Sodium Minimum Value
Sodium Max Op
Sodium Maximum Operator
Sodium Max
Sodium Maximum Value
Sodium Unit
Sodium Unit
Spec. Common Name
Species Common Name
Species Common Name
Spec. Sci. Name
Species Scientific Name
Species Scientific Name
Species Group
Species Group
Species Group
Species Taxon Info.
(10 fields)
Species Kingdom
Species Kingdom
Species Phylum/Division
Species Phylum/Division
Species Subphylum
Species Subphylum
Species Superclass
Species Superclass
Species Class
Species Class
Species Order
Species Order
76
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Species Family
Species Family
Species Genus
Species Genus
Species
Species
Variety
Variety
Spec. Eco #
Species ECOTOX Number
Species Number
Spec. NCBI ID
Species NCBI TaxlD
Species Taxonomy ID from NCBI
Stat. Signif.
Statistical Significance
Statistical Significance
Steady State
Steady State
Study Duration (14 fields)
(Author) or (Days)
Study Duration Op
Study Duration Operator
Study Duration
Study Duration Value
Study Duration Min Op
Study Duration Minimum Operator
Study Duration Min
Study Duration Minimum Value
Study Duration Max Op
Study Duration Maximum Operator
Study Duration Max
Study Duration Maximum Value
Study Duration Units
Study Duration Units
Study Type
Study Type
Study Type
Sub-Habitat (3 fields)
Sub-Habitat
Sub-Habitat Term
Sub-Habitat Description
Sub-Habitat Description
Sub-Habitat Comment
Sub-Habitat Comment
Substr. Code
Substrate Code
Substrate Code
Substr. Comments
Substrate Comments
Substrate Comments
Sulfate
Sulfate Mean Op
Sulfate Mean Operator
Sulfate Mean
Sulfate Mean Value
Sulfate Min Op
Sulfate Minimum Operator
Sulfate Min
Sulfate Minimum Value
Sulfate Max Op
Sulfate Maximum Operator
Sulfate Max
Sulfate Maximum Value
Sulfate Unit
Sulfate Unit
Sulfur
Sulfur Mean Op
Sulfur Mean Operator
Sulfur Mean
Sulfur Mean Value
Sulfur Min Op
Sulfur Minimum Operator
Sulfur Min
Sulfur Minimum Value
77
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Header Name Definition
Sulfur Max Op
Sulfur Maximum Operator
Sulfur Max
Sulfur Maximum Value
Sulfur Unit
Sulfur Unit
Temperature (7 fields)
Temperature Mean Op
Temperature Mean Operator
Temperature Mean
Temperature Mean Value
Temperature Min Op
Temperature Minimum Operator
Temperature Min
Temperature Minimum Value
Temperature Max Op
Temperature Maximum Operator
Temperature Max
Temperature Maximum Value
Temperature Units
Temperature Units
Test#
Test Number
Test Number
Test Location
Test Location
Test Location
Test Method
Test Method
Test Method
Test Type
Test Type
Test Type
Title
Title
Title of the Publication
Trend
Trend
Trend
Water Depth (7 fields)
Water Depth Mean Op
Water Depth Mean Operator
Water Depth Mean
Water Depth Mean Value
Water Depth Min Op
Water Depth Minimum Operator
Water Depth Min
Water Depth Minimum Value
Water Depth Max Op
Water Depth Maximum Operator
Water Depth Max
Water Depth Maximum Value
Water Depth Units
Water Depth Units
78
-------
ECOTOX 5.4 User Guide
Terrestrial Delimited Report Output Fields
A forward slash (/) within a field refers to an associated comment in a separate field.
Users should review the full publication for proper interpretation.
Note: OP = operator ( >, >=, <. =<. =)
Report Header
Delimited File Header Name
Delimited Header Definition
Appl. Date
Application Date
Appl. Freq. (7 fields)
Application Frequency Mean
Op
Application Frequency Mean Operator
Application Frequency Mean
Application Frequency Mean Value
Application Frequency Min Op
Application Frequency Minimum
Operator
Application Frequency Min
Application Frequency Minimum Value
Application Frequency Max
Op
Application Frequency Maximum
Operator
Application Frequency Max
Application Frequency Maximum Value
Application Frequency Units
Application Frequency Units
Appl. Rate (2 fields)
Application Rate
Application Units
Application Rate
Application Units
Appl. Seas. (2 fields)
Application Season
Application Season
Description
Application Season
Application Season Description
Author
Author
BCF/BAF (7 fields)
** BCF/BAF values are
located in "Observed
Response Mean" field in
the Excel/Delimited
reports**
Observed Response Mean Op
Bioconcentration Factor Mean Operator
Observed Response Mean
Bioconcentration Factor Mean Value
Observed Response Min Op
Bioconcentration Factor Minimum
Operator
Observed Response Min
Bioconcentration Factor Minimum Value
Observed Response Max Op
Bioconcentration Factor Maximum
Operator
Observed Response Max
Bioconcentration Factor Maximum Value
Observed Response Unit
Bioconcentration Factor Unit
79
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
CAS#
CAS Number
Test Chemical Abstracts Service
Registry Number
Chem. DTXSID
Chemical DTXSID
Test Chemical DSSTox Substance
Identifier
Chemical Carrier
Carrier
Contains all carriers (up to three) and all
the associated information (CAS
#|Chemical Name|Chemical
Grade|Chemical Formulation|Chemical
Radiolabel|Chemical
Characteristics|Chemical Purity).
Chem. Anal.
Chemical Analysis Method
Chemical Analysis Method
Chem. Comment
Chemical Comment
Test Chemical Comment
Chem. Grade
Chemical Grade
Test Chemical Grade
Chem. Form.
Chemical Formulation
Test Chemical Formulation
Chemical Name
Chemical Name
Test Chemical Name
Chem. Pur.
Chemical Purity
Test Chemical Purity
Chem. Radiolabel
Chemical Radiolabel
Test Chemical Radiolabel
Chem. Half Life (7 fields)
Chemical Half Life Mean OP
Chemical Half Life Mean Operator
Chemical Half Life Mean
Chemical Half Life Mean
Chemical Half Life Min Op
Chemical Half Life Minimum Operator
Chemical Half Life Min
Chemical Half Life Minimum
Chemical Half Life Max Op
Chemical Half Life Maximum Operator
Chemical Half Life Max
Chemical Half Life Maximum
Chemical Half Life Unit
Chemical Half Life Unit
Cone (7 fields) (Author)
Cone 1 Mean Op (Author)
Concentration 1 Mean Operator
Cone 1 Mean (Author)
Concentration 1 Mean Value
Cone 1 Min Op (Author)
Concentration 1 Minimum Operator
Cone Min 1 (Author)
Concentration 1 Minimum Value
Cone 1 Max Op (Author)
Concentration 1 Maximum Operator
Cone 1 Max (Author)
Concentration 1 Maximum Value
Cone 1 Units (Author)\
Concentration 1 Units
80
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Dose (7 fields)
Dose Mean Op
Dose Mean Operator
Dose Mean
Dose Mean Value
Dose Min Op
Dose Minimum Operator
Dose Min
Dose Minimum Value
Dose Max Op
Dose Maximum Operator
Dose Max
Dose Maximum Value
Dose Units
Dose Units
Control
Control
Control
EE Comment
EE Comment
Effect Endpoint (EE) Comment
Effect
Effect
Effect
Effect Meas.
Effect Measurement
Effect Measurement
Eff. Percent (6 fields)
Effect Percent Mean Op
Effect Percent Mean Value Operator
Effect Percent Mean
Effect Percent Mean Value
Effect Percent Min Op
Effect Percent Minimum Value Operator
Effect Percent Min
Effect Percent Minimum Value
Effect Percent Max Op
Effect Percent Maximum Value Operator
Effect Percent Max
Effect Percent Maximum Value
Endpoint
Endpoint
Endpoint
Endpoint Assign.
Endpoint Assignment
Endpoint Assignment
Experimental Design
Experimental Design
Experimental Design Comment
Exp. Type
Exposure Type
Exposure Type
81
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Exposure Comment
Exposure Comment
Exposure Comment
Exp. Dur (Author or Days)
Exposure Mean Op
Exposure Duration Mean Operator
(Author) or (Days)
Exposure Mean
Exposure Duration Mean Value (Author)
or (Days)
Exposure Min Op
Exposure Duration Minimum Operator
(Author) or (Days)
Exposure Min
Exposure Duration Minimum Value
(Author) or (Days)
Exposure Max Op
Exposure Duration Maximum Operator
(Author) or (Days)
Exposure Max
Exposure Duration Maximum Value
(Author) or (Days)
Exposure Duration Units
(Author) or (Days)
Exp. Sample Number (6
fields)
Exposure Sample Number
Mean Op
Exposure Sample Number Mean
Operator (Author) or (Days)
Exposure Sample Number
Mean
Exposure Sample Number Mean Value
(Author) or (Days)
Exposure Sample Number
Min Op
Exposure Sample Number Minimum
Operator (Author) or (Days)
Exposure Sample Number
Min
Exposure Sample Number Minimum
Value (Author) or (Days)
Exposure Sample Number
Max Op
Exposure Sample Number Maximum
Operator (Author) or (Days)
Exposure Sample Number
Max
Exposure Sample Number Maximum
Value (Author) or (Days)
Gender
Gender
Gender
Gen. Comments
General Comments
General Comments
Geog. Loc
Geographic Location
Geographic Location
Geog. Code
Geographic Code
Geographic Code
Habitat
Habitat
Habitat
Intake Rate (7 Fields)
Intake Rate Mean Op
Intake Rate Mean Operator
Intake Rate Mean
Intake Rate Mean Value
Intake Rate Min Op
Intake Rate Minimum Operator
82
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Intake Rate Min
Intake Rate Minimum Value
Intake Rate Max Op
Intake Rate Maximum Operator
Intake Rate Maximum
Intake Rate Maximum Value
Intake Rate Units
Intake Rate Units
Ion
Ionic Fraction
Ionic Fraction
Lat/Long
Latitude/Longitude
Latitude/Longitude
Media Meas. Wet/Dry
Media Measurement (wet/
dry)
Media Measurement (wet/dry)
Media CEC (7 fields)
Media CEC Mean Op
Media Cation Exchange Capacity Mean
Operator
Media CEC Mean
Media Cation Exchange Capacity Mean
Value
Media CEC Min Op
Media Cation Exchange Capacity
Minimum Operator
Media CEC Min
Media Cation Exchange Capacity
Minimum Value
Media CEC Max Op
Media Cation Exchange Capacity
Maximum Operator
Media CEC Max
Media Cation Exchange Capacity
Maximum Value
Media CEC Units
Media Cation Exchange Capacity Units
Media Moist. (6 fields)
Media Moisture Mean Op
Media Moisture Mean Operator
Media Moisture Mean
Media Moisture Mean Value
Media Moisture Min Op
Media Moisture Minimum Operator
Media Moisture Min
Media Moisture Minimum Value
Media Moisture Max Op
Media Moisture Maximum Operator
Media Moisture Max
Media Moisture Maximum Value
Media Orgnc. Mat. (7
fields)
Media Organic Matter Mean
Op
Media Organic Matter Mean Operator
Media Organic Matter Mean
Media Organic Matter Mean Value
Media Organic Matter Min Op
Media Organic Matter Minimum Operator
Media Organic Matter Min
Media Organic Matter Minimum Value
Media Organic Matter Max Op
Media Organic Matter Maximum
Operator
Media Organic Matter Max
Media Organic Matter Maximum Value
83
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Media Organic Matter Units
Media Organic Matter Units
Media Type
Media Type
Media Type
Obs. Dur. (Author), (Days)
Observation Duration Mean
Op
Observation Duration Mean Operator
(Author) or (Days)
Observation Duration Mean
Observation Duration Mean Value
(Author) or (Days)
Observation Duration Min Op
Observation Duration Minimum Operator
(Author) or (Days)
Observation Duration Min
Observation Duration Minimum Value
(Author) or (Days))
Observation Duration Max Op
Observation Duration Maximum (Author)
or (Days)
Observation Duration Max
Observation Duration Maximum Value
(Author) or (Days)
Observation Duration Unit
(Author) or (Days)
Observed Response
Observed Response Mean Op
Observed Response Mean Operator
*Holds Terrestrial Dose
Response data and
Terrestrial Endpoint values
Observed Response Mean
Observed Response Mean Value
Observed Response Min Op
Observed Response Minimum Operator
(9 Fields)
Observed Response Min
Observed Response Minimum Value
Observed Response Max Op
Observed Response Maximum Operator
Observed Response Max
Observed Response Maximum Value
Result Statistical Method
Result Statistical Method
Observed Response Value
Observed Response Statistical Method
Value
Observed Response Units
Observed Response Units
Number of Doses
Number of Doses
Number of Doses
Org. Comment
Organism Comment
Organism Comment
Org. Age (7 fields)
Organism Age Mean OP
Organism Age Mean Operator
Organism Age Mean
Organism Age Mean
Organism Age Min OP
Organism Age Minimum Operator
Organism Age Min
Organism Age Minimum
Organism Age Max OP
Organism Age Maximum Operator
Organism Age Max
Organism Age Maximum
Organism Age Units
Organism Age Units
Org. Comment
Organism Comment
Organism Comment
84
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Org. In it. Wt.
Organism Initial Weight Mean
OP
Organism Initial Weight Mean Operator
Organism Initial Weight Mean
Organism Initial Weight Mean
Organism Initial Weight Min
OP
Organism Initial Weight Minimum
Operator
Organism Initial Weight Min
Organism Initial Weight Minimum
Organism Initial Weight Max
OP
Organism Initial Weight Maximum
Operator
Organism Initial Weight Max
Organism Initial Weight Maximum
Organism Initial Weight Units
Organism Initial Weight Units
Org. Lifestg.
Organism Lifestage
Organism Lifestage
Org. Source
Organism Source
Organism Source
Other Effects
Other Effects
Other Effects
Ref. #
Reference Number
ECOTOX Reference Number
Reference Citation (4
fields)
Click on "References" to
obtain full citation
Author
Title
Year
Source
Author
Title
Year
Source
Resp. Site
Response Site
Response Site
Result Comment
Result Comment
Result Comment
Result % Dry/Wet Weight
Result Percent Dry/Wet
Weight
Result Percent Dry/Wet Weight
Result % Lipid
Result Percent Lipid
Result Percent Lipid
Result Rec. Num.
Result Record Number
Result (Record) Number
Result Sample Number and
Unit
Result Sample Number Mean
Op
Result Sample Number Mean Operator
Result Sample Number Mean
Result Sample Number Mean Value
Result Sample Number Min
Op
Result Sample Number Minimum
Operator
Result Sample Number Min
Result Sample Number Minimum Value
Result Sample Number Max
Op
Result Sample Number Maximum
Operator
Result Sample Number
Maximum
Result Sample Number Maximum Value
Result Sample Unit
Result Sample Number Unit
85
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Result Statistical Method
Result Statistical Method
Result Statistical Method
Sig. Level
Significance Level
Significance Level
Soil Dose Meas.
Soil Dose
Soil Does Measured
Soil Clay % (6 fields)
Soil Clay Percent Mean Op
Soil Clay Percent Mean Operator
Soil Clay Percent Mean
Soil Clay Percent Mean Value
Soil Clay Percent Min Op
Soil Clay Percent Minimum Operator
Soil Clay Percent Min
Soil Clay Percent Minimum Value
Soil Clay Percent Max Op
Soil Clay Percent Maximum Operator
Soil Clay Percent Maximum
Soil Clay Percent Maximum Value
Soil Sand % (6 fields)
Soil Sand Percent Mean Op
Soil Sand Percent Mean Operator
Soil Sand Percent Mean
Soil Sand Percent Mean Value
Soil Sand Percent Min Op
Soil Sand Percent Minimum Operator
Soil Sand Percent Min
Soil Sand Percent Minimum Value
Soil Sand Percent Max Op
Soil Sand Percent Maximum Operator
Soil Sand Percent Max
Soil Sand Percent Maximum Value
Soil Silt % (6 fields)
Soil Silt Percent Mean Op
Soil Silt Percent Mean Operator
Soil Silt Percent Mean
Soil Silt Percent Mean Value
Soil Silt Percent Min Op
Soil Silt Percent Minimum Operator
Soil Silt Percent Min
Soil Silt Percent Minimum Value
Soil Silt Percent Max Op
Soil Silt Percent Maximum Operator
Soil Silt Percent Max
Soil Silt Percent Maximum Value
Soil pH (6 fields)
Soil pH Mean Op
Soil pH Mean Operator
Soil pH Mean
Soil pH Mean Value
Soil pH Min Op
Soil pH Minimum Operator
Soil pH Min
Soil pH Minimum Value
Soil pH Max Op
Soil pH Maximum Operator
Soil pH Max
Soil pH Maximum Value
Soil Type
Soil Type
Soil Type
Source
Source
Bibliographic Source
Spec. Common Name
Species Common Name
Study Type
Study Type
Study Type
86
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Org. Final Wt
Species Final Weight Mean
Op
Species Final Weight Mean Operator
Species Final Weight Mean
Species Final Weight Mean
Species Final Weight Min Op
Species Final Weight Minimum Operator
Species Final Weight Min
Species Final Weight Minimum
Species Final Weight Max Op
Species Final Weight Maximum Operator
Species Final Weight Max
Species Final Weight Maximum
Species Final Weight Units
Species Final Weight Units
Species Group
Species Group
Species Group
Species Taxon Info.
(10 fields)
Species Kingdom
Species Kingdom
Species Phylum/Division
Species Phylum/Division
Species Subphylum
Species Subphylum
Species Superclass
Species Superclass
Species Class
Species Class
Species Order
Species Order
Species Family
Species Family
Species Genus
Species Genus
Species
Species
Variety
Variety
Spec. Eco #
Species ECOTOX Number
Species ECOTOX Number
Spec. NCBI ID
Species NCBI TaxlD
Species Taxonomy ID from NCBI
Spec. Sci. Name
Species Scientific Name
Species Scientific Name
Sign if.
Statistical Significance
Statistical Significance
Steady State
Steady State
Steady State
87
-------
ECOTOX 5.4 User Guide
Report Header
Delimited File Header Name
Delimited Header Definition
Study Duration (14 fields)
(Author) or (Days)
Study Mean Op
Study Duration Mean Operator
Study Mean
Study Duration Mean Value
Study Min Op
Study Duration Minimum Operator
Study Min
Study Duration Minimum Value
Study Max Op
Study Duration Maximum Operator
Study Max
Study Duration Maximum Value
Study Duration Unit
Study Duration Units
Sub-Habitat (3 fields)
Sub-Habitat
Sub-Habitat Term
Sub-Habitat Description
Sub-Habitat Description
Sub-Habitat Comment
Sub-Habitat Comment
Substr. Code
Substrate Code
Substrate Code
Substr. Comments
Substrate Comments
Substrate Comments
Temperature (7 fields)
Temperature Mean Op
Temperature Mean Operator
Temperature Mean
Temperature Mean Value
Temperature Min Op
Temperature Minimum Operator
Temperature Min
Temperature Minimum Value
Temperature Max Op
Temperature Maximum Operator
Temperature Max
Temperature Maximum Value
Temperature Units
Temperature Units
Test Comments
Test Comment
Test Comment
Test Loc.
Test Location
Test Location
Test#
Test Number
Test Number
Test Method
Test Method
Test Method
Test Type
Test Type
Test Type
Trend
Trend
Trend
Title
Title
Title of Publication
Pub. Year
Year
Publication Year
88
------- |