ECOTOX Knowledgebase ReferenceGuide United States Igen?ymental Protection www.epa.gov/ecotox EPA/600/F-19/089 General Guidance on Searches / Navigation / Explore / Help: o The "Search" function is designed to query the data if the exact search parameters are known. Data can be refined by selecting additional search parameters. It is recommended that you conduct general searches initially, and filter or refine output if the data set is too large, o The "Explore" function allows you to search ECOTOX if the exact parameters you want to search are not known, or you would like a visual representation of the data. This is a great starting point for filtering the data prior to running a search, o The search logic includes two basic strategies, combination/union and intersection. Within a search selection box, the selections are combined. Between search selection boxes, the search will intersect. o Context sensitive help is available by clicking on the © located within the Chemical, Effects, Species and Publication search parameters, o Using your browser's Back button will result in the loss of all entries made in any of the ECOTOX forms, o The Help function contains complete User guide and a Code Definition document. o 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. About Search The "Search" function is located within a single web page. Click on the plus sign next to each Search parameter to select or enter specific fields. Search parameters (you must select at least one parameter): All Chemicals (Chemical names, CAS Registry numbers or predefined groups) All Effects (Search specific measurements or select major effect groups from a predefined list) All Endpoints (Select all or any endpoints, or statistics but no endpoint or endpoint is not reported) All Species (Select taxonomic kingdom, scientific or common names, or predefined groups) All Test Conditions (Select any or all lab/field studies, exposure or control media and types, and chemical analysis methods) All Publication Options (Search by year, author, datasets or specific ECOTOX data updates) Any selections made using multiple parameter search boxes within the search page will narrow the search result. Perform a search (Update Search): Once all parameters are selected or entered, click the "Update Search" button to apply the selection parameters and perform the search. Aquatic and Terrestrial reports are run separately. The output table defaults to show Aquatic data first; click on Terrestrial tab to show relevant data. Clicking to select the other habitat will automatically run that search provided no other changes were made to search parameters. Customizing output fields must be done to each habitat to update data reported. < Chemicals Q, Name(s) or CAS number(s) O Contains Q Exact Match Enter each chemical name and/or CAS registry number on separate lines. < Effect Measurements Qv Effect(s) (eg. food, vitellogenini, acetylcholine) O Contains Q Exact Match Enter each effect measurement on separate lines. I I Include Delayed Effects Results D Any Effect Group Accumulation Group Behavior Group El Avoidance _| Behavior Feeding Behavior Growth Group _| Developmental _| Growth _| Morphological Mortality Group Update Search Aquatic Terrestrial Reports: All results initially display in HTML format. You can choose to export the report after the results are retrieved by selecting the "Export as..." button. Excel and delimited reports are available for selection. 0 Export as... Reset All: Clears all Search parameters. x Reset All View All Applied: View the selected parameters, which can be exported to retain a record of the search. View All Applied For more information on the ECOTOX Knowledgebase: Telephone: 218 529 5225 Email: ecotox.support@epa.gov ------- United States Environmental Protection Agency ECOTOX Knowledgebase ReferenceGuide www.epa.gov/ecotox EPA/600/F-xxx About Explore Choose a storting point betow. Explore is a great tool for searching the ECOTOX Knowledgebase if you do not know the exact parameters you want to search, or would like a visual representation of general and specific data trends. It provides an interactive way to examine search paths by Chemicals, Species or Effects. The data can be visually examined with interactive plots. Searching in Explore is predominately driven by selecting predefined groups within each of the Chemicals, Species, and Effects pages. Within the Chemicals and Species pages, users are also able to customize queries by entering in CAS Registry Numbers, NCBI TaxIDs or typing list of species keywords to search. Querying and Filtering Data: To query the data, start by selecting the parameter of interest (Chemicals, Species or Effects). Select from the predefined lists, or create custom group, then click "Explore Data". Explore Data > From the tables displayed for the 'Group Summary' or 'Records', you can further refine the data by applying Query filters (refine data to select one or more names or options using control/click to highlight) or selecting to include/exclude Aquatic or Terrestrial habitats. The following Query filter options and associated data are available utilizing the drop-down feature for: Chemicals Species Group Class Order Family Genus Species Special Interest Groups Effect Groups Effect Measurements Endpoints Publication Years Interactive Data Display: Once a query has been run, the data can be plotted and output refined further using the Query filters mentioned above. After the query is run, you can toggle between various features (Group Summary, Records and Plot View. The pre-defined options for these plots have Chemical concentration on the y-axis and either Effect Group or Exposure Duration on the x-axis. Zooming into data is available using concentration range bar below plot. • Data records can be plotted if they can be converted to standardized concentration units (ppm). • In the simplified Results Table below plot, data can be refined using text boxes above each column. • Clicking on 'Group Summary' or 'Records' tab will return data to table format. • Both tabular data and plot can be exported and saved. (23) Species Group (11) (49) (127) Family (206) (318) All Species All (428) Special Interest Groups (3) Effect Groups (22) Effect Measurements (266) Endpoints (28) Publication Years Group Summary Records Plot View 0 Export v Table as CSV Print Chart For more information on the ECOTOX Knowledgebase: Telephone: 218 529 5225 Email: ecotox.support@epa.gov ------- |