solgenomics / sgn

The code behind the Sol Genomics Network, Cassavabase and other Breedbase websites
https://solgenomics.net
MIT License
66 stars 35 forks source link

Large format option as wizard output format? #3363

Open bauchetg opened 3 years ago

bauchetg commented 3 years ago

Expected Behavior

Often breeding decisions are made on aggregation of several trial results (ie yield performance obtained from field trials and disease tolerance from inoculation test in greenhouse and a SNP marker assay for a specific trait form the lab). Having the various information for a stock on a single line ("large" file format, many columns and fewer lines)

Current Wizard outputs are long format (many lines, fewer columns) type which is handy for raw data processing in R for example.

Large formats can be more user friendly/human friendly if you wish to aggregate processed data (ie BLUEs or BLUPs single stock entry) together with other experiments (ie: greenhouse, lab).

Have you considered such kind of output?

For Bugs:

Environment

Steps to Reproduce

lukasmueller commented 3 years ago

Step 1: Raw data. Upload to Breedbase. (this is done). Step 2: Run data modeling, usually mixed model (this is also partially done) Step 3: Get data by trial, list 1 accession per line and the adjusted means as columns (potentially done, maybe could be done through the analysis download? ).