Database for Experiment Dataset

[Up] [Top]

Documentation for package ‘expDB’ version 0.1.0

Help Pages

dbAddDesigns Add design for a trial
dbAddFertilization Insert or Update fertilization into expDB
dbAddGene Add gene information into database
dbAddGeneAllele Add gene allele information into database
dbAddGenotype Add genotypes into expDB
dbAddIrrigatons Insert or Update irrigation into expDB
dbAddLog Add log from expDB
dbAddMethods Insert or Update methods into expDB
dbAddMets Insert and update met into expDB
dbAddNodes Add nodes into expDB
dbAddPhenotype Add design for a trial
dbAddResearcher Insert and update researcher into expDB
dbAddSites Insert or update site into expDB
dbAddSource Insert and update source into expDB
dbAddTraits Insert or update trait into expDB
dbAddTrials Insert or Update trial into expDB
dbAddTrialSoil Add soil for a trial
dbAddWeather Add weather records into expDB
dbAppendTable Append a table into db and check the column name
dbExportMet Export trials weather records to met file
dbGenotypeCheckName Check genotype names
dbGetDryWeightPerStem Get the dry weight per stem
dbGetFertilization Get fertilization from database
dbGetFieldMaturity Estimation of maturity
dbGetFieldPopulation Estimation of plant populations
dbGetFieldStemNumber Estimation of stem number per unit area
dbGetFieldTillerNumber Estimation of tiller number per unit area
dbGetGene Get the gene information
dbGetGenotype Get the genotype information
dbGetIrrigation Get irrigation from database
dbGetLog Get log from expDB
dbGetMetInfo Get met information
dbGetOrganFinalLeafNumber Get the final leaf number
dbGetOrganHaunIndex Get Haun Index
dbGetPhenotype Get phenotype values through a group of conditions
dbGetPlantFlowering Estimation of flowering time
dbGetPlantHeading Estimation of heading time
dbGetPlantStemElongation Estimation of stem elongation
dbGetPlantStemNumber Estimation of stem number per plant
dbGetPlantTillerNumber Estimation of tiller number per plant
dbGetSites Get site into expDB
dbGetSource Get source from expDB
dbGetTraits Get trait list
dbGetTrials Get trials by a groups of conditions.
dbGetWeather Get weather records from expDB
dbGetZadoksStage Obtain the key phenology stage
dbImportXLSX Import data from excel file
dbInsertUpdateByRow Insert new rows or update existing rows to a specific table according to a specific column (unique) by each row
dbListTrials List all trials
expdbConnect Connect to expDB
expdbCreateDB create to expDB
expdbDisconnect Didconnect to expDB
getIdByUniqueIndex Get index id by unique_columns.
harvestQuadratDetail Process quadrat (detail) harvestQuadratDetail