tcpl 2.0
Data Retrieval

National Center for Computational Toxicology, US EPA

Data Retrieval

This vignette describes how the user can retrieve data from the csv files using tcplLite or from the ToxCast databases using tcpl. Listed below are case examples that extract summary information about the chemical, Bisphenol A, and the assay, NVS_NR_hTRa. The multiple concentration table for level 5 can be downloaded from the publicly available ToxCast data

##A. Using TcplLite

In this example, we will identify the positive responses for the chemical Bisphenol A.

Now that we isolated all the sample IDs (spids) for the chemical of interest, we can start mapping data from the multiple-concentration tables: level 4(mc4), level 5(mc5), and level 6(mc6) from the local csv directory. Level 4 includes the spids, and level 5 specifies whether the chemical is active or inactive. Level 6 indicates flags reflecting the quality of the data or the analysis.

Next, we match the the m5ids that correspond to the spids of interest. From those, we select the positive responses, with hit call = 1.

To identify the flags for the Bisphenol A samples, we match the flag columns in the mc6 table by the corresponding m5ids.

##B. Using Tcpl We illustrate here the necessary steps for extracting information about Bisphenol A using tcpl rather than tcplLite.

First, we change the driver in tcpl settings to MySQL, and the database to invitrodb :

Next, we define the chemical of interest and load the related spids:

Then, we load the data from different levels to summarize positive responses for this chemical.

Then, we can generate all level 6 plots for positive responses for this chemical:

In the following example, we will obtain summary information about the example assay NVS_NR_hTRa_Antagonist using tcpl:

Moreover, we can extract the mc3 data used for plots:

Then, we can visualize the normalized mc3 data without tcpl curve-fitting:

The tcplLoadData function can be used to load data from level 7. The added level allows for estimating the uncertainty in the fitted parameters, such as AC50.