Package: expDB 0.1.0

expDB: Database for Experiment Dataset

A 'SQLite' database is designed to store all information of experiment-based data including metadata, experiment design, managements, phenotypic values and climate records. The dataset can be imported from an 'Excel' file.

Authors:Bangyou Zheng [aut, cre]

expDB_0.1.0.tar.gz
expDB_0.1.0.zip(r-4.5)expDB_0.1.0.zip(r-4.4)expDB_0.1.0.zip(r-4.3)
expDB_0.1.0.tgz(r-4.5-any)expDB_0.1.0.tgz(r-4.4-any)expDB_0.1.0.tgz(r-4.3-any)
expDB_0.1.0.tar.gz(r-4.5-noble)expDB_0.1.0.tar.gz(r-4.4-noble)
expDB_0.1.0.tgz(r-4.4-emscripten)expDB_0.1.0.tgz(r-4.3-emscripten)
expDB.pdf |expDB.html✨
expDB/json (API)

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

Bug tracker:https://github.com/byzheng/expdb/issues

Pkgdown site:https://expdb.bangyou.me

On CRAN:

Conda:

2.70 score 4 scripts 227 downloads 51 exports 114 dependencies

Last updated 1 years agofrom:331dd2e7f0. Checks:1 OK, 8 NOTE. Indexed: yes.

TargetResultLatest binary
Doc / VignettesOKMar 08 2025
R-4.5-winNOTEMar 08 2025
R-4.5-macNOTEMar 08 2025
R-4.5-linuxNOTEMar 08 2025
R-4.4-winNOTEMar 08 2025
R-4.4-macNOTEMar 08 2025
R-4.4-linuxNOTEMar 08 2025
R-4.3-winNOTEMar 08 2025
R-4.3-macNOTEMar 08 2025

Exports:dbAddDesignsdbAddFertilizationdbAddGenedbAddGeneAlleledbAddGenotypedbAddIrrigatonsdbAddLogdbAddMethodsdbAddMetsdbAddNodesdbAddPhenotypedbAddResearcherdbAddSitesdbAddSourcedbAddTraitsdbAddTrialsdbAddTrialSoildbAddWeatherdbExportMetdbGenotypeCheckNamedbGetDryWeightPerStemdbGetFertilizationdbGetFieldMaturitydbGetFieldPopulationdbGetFieldStemNumberdbGetFieldTillerNumberdbGetGenedbGetGenotypedbGetIrrigationdbGetLogdbGetMetInfodbGetOrganFinalLeafNumberdbGetOrganHaunIndexdbGetPhenotypedbGetPlantFloweringdbGetPlantHeadingdbGetPlantStemElongationdbGetPlantStemNumberdbGetPlantTillerNumberdbGetSitesdbGetSourcedbGetTraitsdbGetTrialsdbGetWeatherdbGetZadoksStagedbImportXLSXdbListTrialsexpdbConnectexpdbCreateDBexpdbDisconnectharvestQuadratDetail

Dependencies:askpassbackportsbase64encbitbit64blobbroombslibcachemcallrcellrangerclicliprcolorspaceconflictedcpp11crayoncurldata.tableDBIdbplyrdigestdplyrdtplyrevaluatefansifarverfastmapfontawesomeforcatsfsgarglegenericsggplot2gluegoogledrivegooglesheets4gtablehavenhighrhmshtmltoolshttridsisobandjquerylibjsonliteknitrlabelinglatticelifecyclelubridatemagrittrMASSMatrixmemoisemgcvmimemodelrmunsellnlmeopensslpillarpkgconfigplogrplyrpngprettyunitsprocessxprogresspspurrrR6raggrappdirsRColorBrewerRcppreadrreadxlrematchrematch2reprexreshape2rlangrmarkdownRSQLiterstudioapirvestsassscalesselectrsettingsstringistringrsyssystemfontstextshapingtibbletidyrtidyselecttidyversetimechangetinytextzdbutf8uuidvctrsviridisLitevroomweaanawithrxfunxml2yaml

Readme and manuals

Help Manual

Help pageTopics
Add design for a trialdbAddDesigns
Insert or Update fertilization into expDBdbAddFertilization
Add gene information into databasedbAddGene
Add gene allele information into databasedbAddGeneAllele
Add genotypes into expDBdbAddGenotype
Insert or Update irrigation into expDBdbAddIrrigatons
Add log from expDBdbAddLog
Insert or Update methods into expDBdbAddMethods
Insert and update met into expDBdbAddMets
Add nodes into expDBdbAddNodes
Add design for a trialdbAddPhenotype
Insert and update researcher into expDBdbAddResearcher
Insert or update site into expDBdbAddSites
Insert and update source into expDBdbAddSource
Insert or update trait into expDBdbAddTraits
Insert or Update trial into expDBdbAddTrials
Add soil for a trialdbAddTrialSoil
Add weather records into expDBdbAddWeather
Append a table into db and check the column namedbAppendTable
Export trials weather records to met filedbExportMet
Check genotype namesdbGenotypeCheckName
Get the dry weight per stemdbGetDryWeightPerStem
Get fertilization from databasedbGetFertilization
Estimation of maturitydbGetFieldMaturity
Estimation of plant populationsdbGetFieldPopulation
Estimation of stem number per unit areadbGetFieldStemNumber
Estimation of tiller number per unit areadbGetFieldTillerNumber
Get the gene informationdbGetGene
Get the genotype informationdbGetGenotype
Get irrigation from databasedbGetIrrigation
Get log from expDBdbGetLog
Get met informationdbGetMetInfo
Get the final leaf numberdbGetOrganFinalLeafNumber
Get Haun IndexdbGetOrganHaunIndex
Get phenotype values through a group of conditionsdbGetPhenotype
Estimation of flowering timedbGetPlantFlowering
Estimation of heading timedbGetPlantHeading
Estimation of stem elongationdbGetPlantStemElongation
Estimation of stem number per plantdbGetPlantStemNumber
Estimation of tiller number per plantdbGetPlantTillerNumber
Get site into expDBdbGetSites
Get source from expDBdbGetSource
Get trait listdbGetTraits
Get trials by a groups of conditions.dbGetTrials
Get weather records from expDBdbGetWeather
Obtain the key phenology stagedbGetZadoksStage
Import data from excel filedbImportXLSX
Insert new rows or update existing rows to a specific table according to a specific column (unique) by each rowdbInsertUpdateByRow
List all trialsdbListTrials
Connect to expDBexpdbConnect
create to expDBexpdbCreateDB
Didconnect to expDBexpdbDisconnect
Get index id by unique_columns.getIdByUniqueIndex
Process quadrat (detail) harvestQuadratDetailharvestQuadratDetail