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 = "%")
The name of the substance identifying it within the database. Matching is not case-sensitive.
The database to be used. Currently, the databases "cytotox" and "enzymes" of the UFT Department of Bioorganic Chemistry are supported (default is "cytotox").
The name of the experimentator whose data is to be used. Default is "%", which means that data from all experimentators are shown.
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.
Currently, only data for AChE, GR and GST are supported. The default value is "%", i.e. data for any enzyme type will be displayed.
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.
The endpoint that should be used for selecting the data. Only important if the database "ecotox" is used. Defaults to "%".
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).
With the default value "%", all data in the database is retrieved for the specified substance.
The function lists a report and shows one graph.
# NOT RUN {
# Check substance IM14 BF4 in the cytotox database
# }
# NOT RUN {
checksubstance("IM14 BF4")
# }
Run the code above in your browser using DataLab