Skip to contents

ECOTOXr

ECOTOXr can be used to explore and analyse data from the US EPA ECOTOX database. More specifically you can:

  • Build a local SQLite copy of the US EPA ECOTOX database
  • Search and extract data from the local database
  • Use experimental features to search the on-line dashboards: ECOTOX and CompTox

Why use ECOTOXr?

The ECOTOXr package allows you to search and extract data from the ECOTOXicological Knowledgebase and import it directly into R. This will allow you to formalize and document the search- and extract-procedures in R code. This makes it easier to share and reproduce such procedures and its results. As illustrated in the graphical abstract below. Moreover, you can directly apply any statistical analysis offered in R.

From De Vries et al. (2024); Creative commons

Installation

Get CRAN version

install.packages("ECOTOXr")

Get development version from r-universe

install.packages("ECOTOXr", repos = c("https://pepijn-devries.r-universe.dev", "https://cloud.r-project.org"))

Usage

Preparing the database

Although ECOTOXr has experimental features to search the on-line database. The package will reach its full potential when you build a copy of the database on your local machine.

Download and build a local copy of the latest ASCII export of the US EPA ECOTOX database

Searching the local database for species and substances

Once built, you can search the local database for species and substances using different strategies. You can use the build-in search function of this package, or you can write custom queries using either the simple query language (SQL) or dplyr verbs. More details in the following vignettes: vignette("searching-ecotox") and vignette("ecotox-schema").

Disclaimers

It is the end-users own responsibility to check the quality of collected data, using the original referenced source in order to evaluate its fitness for use, see also: https://cfpub.epa.gov/ecotox/help.cfm#info-limitations.

Note that the package maintainer is not affiliated with the US EPA, this package is therefore not official US EPA software.

Resources