writeDB

<p>Database connection (from DBI::dbConnect or similar)</p>

conn

table

tblname

<p>Simple wrapper - take data table or data frame and append it to the given table in the given database.</p>

Provides parsing functionality for over 30 metabolomics databases, with most available without having to create an account on given websites.
Once parsed, calculates given adducts and isotope patterns and inserts into one big database which can be used to annotate unknown m/z values.
Furthermore, formulas can be predicted for a given m/z, and these can be matched to ChemSpider, PubChem, SUPERNATURAL II, KNApSAcK and ChemIDplus for further annotation.
Current databases available: HMDB, ChEBI, LMDB, BMDB, MCDB, ECMDB, Wikidata, mVOC, VMH, T3DB, Exposome Explorer, FooDB, MetaCyc (requires account), DrugBank (requires account), ReSPECT, MaConDa, Blood Exposome DB, KEGG, SMPDB, LIPID MAPS, MetaboLights, DimeDB, Phenol Explorer, MassBank, YMDB, PAMDB, ANPDB, Metabolomics Workbench, PharmGKB, Reactome, mVOC and STOFF.
Featured in the 'MetaboShiny' package (Wolthuis, J. (2019) <doi:10.1007/s11306-020-01717-8>).

writeDB: Write table to SQLite database

Description

Usage

Arguments

Value

See Also