Package: MsBackendSql 1.5.0

Johannes Rainer

MsBackendSql: SQL-based Mass Spectrometry Data Backend

SQL-based mass spectrometry (MS) data backend supporting also storange and handling of very large data sets. Objects from this package are supposed to be used with the Spectra Bioconductor package. Through the MsBackendSql with its minimal memory footprint, this package thus provides an alternative MS data representation for very large or remote MS data sets.

Authors:Johannes Rainer [aut, cre], Chong Tang [ctb], Laurent Gatto [ctb]

MsBackendSql_1.5.0.tar.gz
MsBackendSql_1.5.0.zip(r-4.5)MsBackendSql_1.5.0.zip(r-4.4)MsBackendSql_1.5.0.zip(r-4.3)
MsBackendSql_1.5.0.tgz(r-4.4-any)MsBackendSql_1.5.0.tgz(r-4.3-any)
MsBackendSql_1.5.0.tar.gz(r-4.5-noble)MsBackendSql_1.5.0.tar.gz(r-4.4-noble)
MsBackendSql_1.5.0.tgz(r-4.4-emscripten)MsBackendSql_1.5.0.tgz(r-4.3-emscripten)
MsBackendSql.pdf |MsBackendSql.html✨
MsBackendSql/json (API)

# Install 'MsBackendSql' in R:

install.packages('MsBackendSql', repos = c('https://bioc.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/rformassspectrometry/msbackendsql/issues

On BioConductor:MsBackendSql-1.5.0(bioc 3.20)MsBackendSql-1.4.0(bioc 3.19)

bioconductor-package

26 exports 1.08 score 34 dependencies

Last updated 2 months agofrom:dd49c9e346

Exports:backendInitialize backendMerge centroided createMsBackendSqlDatabase dataStorage filterDataOrigin filterMsLevel filterPrecursorMzRange filterPrecursorMzValues filterRt intensity<-MsBackendOfflineSql MsBackendSql mz<-peaksData peaksVariables precScanNum reset show smoothed spectraData spectraNames spectraNames<-supportsSetBackend tic uniqueMsLevels

Dependencies:BH BiocGenerics BiocParallel cli clue cluster codetools cpp11 crayon data.table DBI formatR fs futile.logger futile.options glue hms IRanges lambda.r lifecycle MASS MetaboCoreUtils MsCoreUtils pkgconfig prettyunits progress ProtGenerics R6 Rcpp rlang S4Vectors snow Spectra vctrs

Storing Mass Spectrometry Data in SQL Databases

Rendered fromMsBackendSql.Rmdusingknitr::rmarkdownon Jul 06 2024.

Last update: 2024-03-28
Started: 2022-11-16

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
SQL-based MS backend without active database connection	backendInitialize,MsBackendOfflineSql-method MsBackendOfflineSql MsBackendOfflineSql-class
'Spectra' MS backend storing data in a SQL database	$<-,MsBackendSql-method backendBpparam,MsBackendSql-method backendInitialize,MsBackendSql-method backendMerge,MsBackendOfflineSql-method backendMerge,MsBackendSql-method centroided,MsBackendSql-method createMsBackendSqlDatabase dataStorage,MsBackendOfflineSql-method dataStorage,MsBackendSql-method dbconn,MsBackendOfflineSql-method dbconn,MsBackendSql-method filterDataOrigin,MsBackendOfflineSql-method filterDataOrigin,MsBackendSql-method filterMsLevel,MsBackendOfflineSql-method filterMsLevel,MsBackendSql-method filterPrecursorMzRange,MsBackendOfflineSql-method filterPrecursorMzRange,MsBackendSql-method filterPrecursorMzValues,MsBackendOfflineSql-method filterPrecursorMzValues,MsBackendSql-method filterRt,MsBackendOfflineSql-method filterRt,MsBackendSql-method intensity<-,MsBackendSql-method MsBackendSql MsBackendSql-class mz<-,MsBackendSql-method peaksData,MsBackendOfflineSql-method peaksData,MsBackendSql-method peaksVariables,MsBackendOfflineSql-method peaksVariables,MsBackendSql-method precScanNum,MsBackendSql-method reset,MsBackendOfflineSql-method reset,MsBackendSql-method show,MsBackendOfflineSql-method show,MsBackendSql-method smoothed,MsBackendSql-method spectraData,MsBackendOfflineSql-method spectraData,MsBackendSql-method spectraNames,MsBackendSql-method spectraNames<-,MsBackendSql-method supportsSetBackend,MsBackendOfflineSql-method supportsSetBackend,MsBackendSql-method tic,MsBackendOfflineSql-method tic,MsBackendSql-method uniqueMsLevels,MsBackendOfflineSql-method uniqueMsLevels,MsBackendSql-method [,MsBackendSql-method

Help page

Topics

SQL-based MS backend without active database connection

backendInitialize,MsBackendOfflineSql-method MsBackendOfflineSql MsBackendOfflineSql-class

'Spectra' MS backend storing data in a SQL database

$<-,MsBackendSql-method backendBpparam,MsBackendSql-method backendInitialize,MsBackendSql-method backendMerge,MsBackendOfflineSql-method backendMerge,MsBackendSql-method centroided,MsBackendSql-method createMsBackendSqlDatabase dataStorage,MsBackendOfflineSql-method dataStorage,MsBackendSql-method dbconn,MsBackendOfflineSql-method dbconn,MsBackendSql-method filterDataOrigin,MsBackendOfflineSql-method filterDataOrigin,MsBackendSql-method filterMsLevel,MsBackendOfflineSql-method filterMsLevel,MsBackendSql-method filterPrecursorMzRange,MsBackendOfflineSql-method filterPrecursorMzRange,MsBackendSql-method filterPrecursorMzValues,MsBackendOfflineSql-method filterPrecursorMzValues,MsBackendSql-method filterRt,MsBackendOfflineSql-method filterRt,MsBackendSql-method intensity<-,MsBackendSql-method MsBackendSql MsBackendSql-class mz<-,MsBackendSql-method peaksData,MsBackendOfflineSql-method peaksData,MsBackendSql-method peaksVariables,MsBackendOfflineSql-method peaksVariables,MsBackendSql-method precScanNum,MsBackendSql-method reset,MsBackendOfflineSql-method reset,MsBackendSql-method show,MsBackendOfflineSql-method show,MsBackendSql-method smoothed,MsBackendSql-method spectraData,MsBackendOfflineSql-method spectraData,MsBackendSql-method spectraNames,MsBackendSql-method spectraNames<-,MsBackendSql-method supportsSetBackend,MsBackendOfflineSql-method supportsSetBackend,MsBackendSql-method tic,MsBackendOfflineSql-method tic,MsBackendSql-method uniqueMsLevels,MsBackendOfflineSql-method uniqueMsLevels,MsBackendSql-method [,MsBackendSql-method