Package: MsBackendSql 1.11.3

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.11.3.tar.gz
MsBackendSql_1.11.3.zip(r-4.7)MsBackendSql_1.11.3.zip(r-4.6)MsBackendSql_1.11.3.zip(r-4.5)
MsBackendSql_1.11.3.tgz(r-4.6-any)MsBackendSql_1.11.3.tgz(r-4.5-any)
MsBackendSql_1.11.3.tar.gz(r-4.7-any)MsBackendSql_1.11.3.tar.gz(r-4.6-any)
MsBackendSql_1.11.3.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
MsBackendSql/json (API)

# Install 'MsBackendSql' in R:
install.packages('MsBackendSql', repos = c('https://rformassspectrometry.r-universe.dev', 'https://cloud.r-project.org'))

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

On BioConductor:MsBackendSql-1.13.0(bioc 3.24)MsBackendSql-1.12.0(bioc 3.23)

infrastructuremassspectrometrymetabolomicsdataimportproteomics

5.78 score 4 stars 43 scripts 30 exports 37 dependencies

Last updated from:9b5f2feb56. Checks:9 OK. Indexed: no.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK588
source / vignettesOK287
linux-release-x86_64OK606
macos-release-arm64OK671
macos-oldrel-arm64OK511
windows-develOK658
windows-releaseOK624
windows-oldrelOK758
wasm-releaseOK135

Exports:backendInitializebackendMergecentroidedcreateMsBackendSqlDatabasedataStorageextractByIndexfilterDataOriginfilterMsLevelfilterPrecursorMzRangefilterPrecursorMzValuesfilterRtintensityintensity<-longFormMsBackendOfflineSqlMsBackendSqlmzmz<-peaksDatapeaksVariablesprecScanNumresetshowsmoothedspectraDataspectraNamesspectraNames<-supportsSetBackendticuniqueMsLevels

Dependencies:BHBiocGenericsBiocParallelcliclueclustercodetoolscpp11crayondata.tableDBIfastmatchformatRfsfutile.loggerfutile.optionsgenericsgluehmsIRangeslambda.rlifecycleMASSMetaboCoreUtilsMsCoreUtilspkgconfigprettyunitsprogressProtGenericsR6RcpprlangS4VectorssnowSpectrastringivctrs

Storing Mass Spectrometry Data in SQL Databases

Rendered fromMsBackendSql.Rmdusingknitr::rmarkdownon Jun 03 2026.

Last update: 2026-02-05
Started: 2022-11-16

Readme and manuals

Help Manual

Help pageTopics
SQL-based MS backend without active database connectionbackendInitialize,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 extractByIndex,MsBackendSql,ANY-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,MsBackendOfflineSql-method intensity,MsBackendSql-method intensity<-,MsBackendSql-method longForm,MsBackendOfflineSql-method longForm,MsBackendSql-method MsBackendSql MsBackendSql-class mz,MsBackendOfflineSql-method mz,MsBackendSql-method 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