QBMS

<!-- badges: end -->

Overview

This R package assists breeders in linking data systems with their analytic pipelines, a crucial step in digitizing breeding processes. It supports querying and retrieving phenotypic and genotypic data from systems like EBS, BMS, BreedBase, GIGWA, and Germinate (using BrAPI calls). Extra helper functions support environmental data sources, including TerraClimate and FAO HWSDv2 soil database.

__Author and Maintainer:_ Khaled Al-Shamaa _

__Contributor:_ Mariano Omar CRIMI _

__Contributor:_ Zakaria Kehel _

__Contributor:_ Johan Aparicio _

__Copyright Holder:_ International Center for Agricultural Research in the Dry Areas (ICARDA)_

BrAPI

The Breeding API (BrAPI) project is an effort to enable interoperability among plant breeding databases. BrAPI is a standardized RESTful web service API specification for communicating plant breeding data. This community driven standard is free to be used by anyone interested in plant breeding data management.

Supported Data Sources

• BMS: vignette("bms_example").
• EBS: vignette("ebs_example").
• Breedbase: vignette("breedbase_example").
• GIGWA: vignette("gigwa_example").
• Germinate: vignette("germinate_example").

Extra sub-systems supported:

• TerraClimate: vignette("terraclimate_example").
• HWSD v2.0: vignette("hwsd2_example").

Installation

r install.packages("QBMS")

Development version

To get a bug fix or to use a feature from the development version, you can install the development version of QBMS from GitHub.

r if (!require("remotes")) install.packages("remotes") remotes::install_github("icarda/QBMS")

Getting Started

Once you successfully install the QBMS R package, you can load it as a library and set up your remote server configuration (e.g., EBS, BMS, BreedBase, or GIGWA) by simply copying and pasting the login page URL from your web browser.

```r

load the QBMS library

library(QBMS)

config your BMS connection (by providing your BMS login page URL)

setqbmsconfig("https://bms.icarda.org/ibpworkbench/controller/auth/login") ```

To start querying and retrieving data from your remote server, you have to login using the same credentials for that server’s GUI/web interface. Please note that you can call the login function(s) with no parameters (interactive mode), where you will get a popup window to insert your username and password (highly advised as one of the best security practices). Although, for automatic analysis pipeline(s) or server services, you can still provide the required username and password as login function parameters (i.e., batch mode).

```r

login using your account (interactive mode)

login_bms()

or pass your username and password as parameters (batch mode)

login_bms("username", "password") ```

You should be careful when sharing your batch mode code to avoid leaking your credential in public or not authorized spaces.

Supporting Multiple Provider Connectors

You can switch between an ongoing QBMS connection and another server/database connection by using get_qbms_connection() and set_qbms_connection() functions, as shown in the following example (i.e., if there is a need to switch forth and back during the same session):

```r

configure QBMS to connect the phenotypics server

setqbmsconfig("https://bms.icarda.org/ibpworkbench/controller/auth/login")

login and retrieve data from the phenotypic server

save current connection (phenotypic server)

con1 <- getqbmsconnection()

configure QBMS to connect the genotypic server

setqbmsconfig("https://gigwa.southgreen.fr/gigwa/", engine = "gigwa", no_auth = TRUE)

retrieve data from the genotypic server

save current connection (before switch)

con2 <- getqbmsconnection()

load the saved phenotypic server connection

setqbmsconnection(con1)

continue retrieving data from the phenotypic server

```

A detailed example is available in the documentation of the get_qbms_connection() and set_qbms_connection() functions.

Also, you can find a more elegant solution developed by Francisco Agosto-Perez from the Breeding Informatics team within the Innovation Lab For Crop Improvement at Cornell University available here: https://github.com/agostof/BrAPI-Provider/

Error and Debugging

If you get unexpected results or weird behavior and want to dig deep and investigate what went wrong, you can get a copy of the internal QBMS variables by calling the debug_qbms() function.

```r dump <- debug_qbms()

dump$config

$crop

[1] "maize"

$server

[1] "https://bms.icarda.org"

$path

[1] "bmsapi"

$page_size

[1] 1000

$time_out

[1] 120

$base_url

[1] "https://bms.icarda.org/bmsapi"

$engine

[1] "bms"

names(dump$state)

[1] "token" "programdbid" "trialdbid" "studydbid" "user"

[6] "expires_in" "errors" ...

dump$state$token

[1] "username:1666907125029:a312bb036cc8d9cc302bee1f0981e5ab"

```

Troubleshooting the Installation

1. If the installation of QBMS generates errors saying that some of the existing packages cannot be removed, you can try to quit any R session, and try to start R in administrator (Windows) or SUDO mode (Linux/Ubuntu) then try installing again.

2. If you get an error related to packages built under a current version of R, and updating your packages doesn’t help, you can consider overriding the error with the following code. Note: This might help you install QBMS but may result in other problems. If possible, it’s best to resolve the errors rather than ignoring them.

```r Sys.setenv("RREMOTESNOERRORSFROM_WARNINGS" = TRUE)

remotes::install_github("icarda/QBMS", upgrade = "always") ```

1. If you get an error related to list or set runs in GIGWA (i.e., gigwa_list_runs() and gigwa_set_run() functions), you can try to ensure that your R session system locale is using UTF-8 character set encoding. You may consider overwriting your system locale with the following command to resolve this issue:

r Sys.setlocale("LC_ALL", "English_United States.utf8")

1. If the get_terraclimate() function takes a long time to run and the progress bar stays at 0%, it might be due to using an outdated version of the R language. Make sure you're using the latest version. For more details, please refer to this GitHub issue.

References

• Peter Selby et al., BrAPI-an application programming interface for plant breeding applications, Bioinformatics, Volume 35, Issue 20, 15 October 2019, Pages 4147–4155, https://doi.org/10.1093/bioinformatics/btz190

• The Breeding API (2022, December 15). BrAPI Compatible Software list. Retrieved from https://brapi.org/compatibleSoftware

• Excellence in Breeding Toolbox (2023, February 1). Query Breeding Management Systems (QBMS) R package. Retrieved from https://excellenceinbreeding.org/toolbox/tools/query-breeding-management-systems-qbms-r-package

• CGSpace (2023, February 23). Query Breeding Management Systems (QBMS) R package. Retrieved from https://cgspace.cgiar.org/handle/10568/128828

• MELSpace (2023, February 23). Query Breeding Management Systems (QBMS) R package. Retrieved from https://repo.mel.cgiar.org/handle/20.500.11766/68139