Report metadata for a specified substance from a specified database, and plot the data.

checksubstance(substance, 
    db = c("cytotox", "enzymes", "ecotox"), 
    experimentator = "%",
    celltype = "%", enzymetype = "%", organism = "%",
    endpoint = "%",
    whereClause = "1", ok = "%")

Arguments

substance

The name of the substance identifying it within the database. Matching is not case-sensitive.

db

The database to be used. Currently, the databases "cytotox" and "enzymes" of the UFT Department of Bioorganic Chemistry are supported (default is "cytotox").

experimentator

The name of the experimentator whose data is to be used. Default is "%", which means that data from all experimentators are shown.

celltype

Currently, only data for IPC-81, C6, NB4, HeLa, Jurkat and U937 are supported. Default is "%", i.e. data for any cell type will be displayed.

enzymetype

Currently, only data for AChE, GR and GST are supported. The default value is "%", i.e. data for any enzyme type will be displayed.

organism

The latin name of the tested organism, if the ecotox db was selected. The default value is "%", i.e. data for any organism will be displayed.

endpoint

The endpoint that should be used for selecting the data. Only important if the database "ecotox" is used. Defaults to "%".

whereClause

With this argument, additional conditions for the SQL query can be set, e.g. "plate != 710". The default is 1 (in SQL syntax this means TRUE).

ok

With the default value "%", all data in the database is retrieved for the specified substance.

Value

The function lists a report and shows one graph.

Author

Johannes Ranke jranke@uni-bremen.de

Examples

# Check substance IM14 BF4 in the cytotox database
if (FALSE) checksubstance("IM14 BF4")