Package: expDB 0.3.0

Bangyou Zheng

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.3.0.tar.gz
expDB_0.3.0.zip(r-4.7)expDB_0.3.0.zip(r-4.6)expDB_0.3.0.zip(r-4.5)
expDB_0.3.0.tgz(r-4.6-any)expDB_0.3.0.tgz(r-4.5-any)
expDB_0.3.0.tar.gz(r-4.7-any)expDB_0.3.0.tar.gz(r-4.6-any)
expDB_0.3.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
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/docs site:https://expdb.bangyou.me

On CRAN:

Conda:

3.00 score 4 scripts 245 downloads 52 exports 43 dependencies

Last updated from:9e0a9c5686. Checks:9 OK. Indexed: yes.

TargetResultTimeFilesSyslog
linux-devel-x86_64OK127
source / vignettesOK203
linux-release-x86_64OK139
macos-release-arm64OK75
macos-oldrel-arm64OK75
windows-develOK122
windows-releaseOK89
windows-oldrelOK132
wasm-releaseOK118

Exports:approx_zadoksdbAddDesignsdbAddFertilizationdbAddGenedbAddGeneAlleledbAddGenotypedbAddIrrigatonsdbAddLogdbAddMethodsdbAddMetsdbAddNodesdbAddPhenotypedbAddResearcherdbAddSitesdbAddSourcedbAddTraitsdbAddTrialsdbAddTrialSoildbAddWeatherdbExportMetdbGenotypeCheckNamedbGetDryWeightPerStemdbGetFertilizationdbGetFieldMaturitydbGetFieldPopulationdbGetFieldStemNumberdbGetFieldTillerNumberdbGetGenedbGetGenotypedbGetIrrigationdbGetLogdbGetMetInfodbGetOrganFinalLeafNumberdbGetOrganHaunIndexdbGetPhenotypedbGetPlantFloweringdbGetPlantHeadingdbGetPlantStemElongationdbGetPlantStemNumberdbGetPlantTillerNumberdbGetSitesdbGetSourcedbGetTraitsdbGetTrialsdbGetWeatherdbGetZadoksStagedbImportXLSXdbListTrialsexpdbConnectexpdbCreateDBexpdbDisconnectharvestQuadratDetail

Dependencies:bitbit64blobcachemcellrangerclicpp11crayonDBIdplyrfastmapgenericsgluehmslifecyclelubridatemagrittrmemoisepillarpkgconfigplyrpngprettyunitsprogresspurrrR6Rcppreadxlrematchreshape2rlangRSQLitesettingsstringistringrtibbletidyrtidyselecttimechangeutf8vctrsweaanawithr

Readme and manuals

Help Manual

Help pageTopics
Approximate Date for a Target Zadoks Stageapprox_zadoks
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