Package: MsBackendSql 1.7.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.7.3.tar.gz
MsBackendSql_1.7.3.zip(r-4.5)MsBackendSql_1.7.3.zip(r-4.4)MsBackendSql_1.7.3.zip(r-4.3)
MsBackendSql_1.7.3.tgz(r-4.4-any)MsBackendSql_1.7.3.tgz(r-4.3-any)
MsBackendSql_1.7.3.tar.gz(r-4.5-noble)MsBackendSql_1.7.3.tar.gz(r-4.4-noble)
MsBackendSql_1.7.3.tgz(r-4.4-emscripten)MsBackendSql_1.7.3.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.7.2(bioc 3.21)MsBackendSql-1.6.0(bioc 3.20)

infrastructuremassspectrometrymetabolomicsdataimportproteomics

5.46 score 4 stars 16 scripts 192 downloads 29 exports 37 dependencies

Last updated 29 days agofrom:b1a65a0d14. Checks:7 OK. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKJan 25 2025
R-4.5-winOKJan 25 2025
R-4.5-linuxOKJan 25 2025
R-4.4-winOKJan 25 2025
R-4.4-macOKJan 25 2025
R-4.3-winOKJan 25 2025
R-4.3-macOKJan 25 2025

Exports:backendInitializebackendMergecentroidedcreateMsBackendSqlDatabasedataStorageextractByIndexfilterDataOriginfilterMsLevelfilterPrecursorMzRangefilterPrecursorMzValuesfilterRtintensityintensity<-MsBackendOfflineSqlMsBackendSqlmzmz<-peaksDatapeaksVariablesprecScanNumresetshowsmoothedspectraDataspectraNamesspectraNames<-supportsSetBackendticuniqueMsLevels

Dependencies:BHBiocGenericsBiocParallelcliclueclustercodetoolscpp11crayondata.tableDBIfastmatchformatRfsfutile.loggerfutile.optionsgenericsgluehmsIRangeslambda.rlifecycleMASSMetaboCoreUtilsMsCoreUtilspkgconfigprettyunitsprogressProtGenericsR6RcpprlangS4VectorssnowSpectrastringivctrs

Storing Mass Spectrometry Data in SQL Databases

Rendered fromMsBackendSql.Rmdusingknitr::rmarkdownon Jan 25 2025.

Last update: 2025-01-24
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 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