Subsetting tool
The Subsetting Tool allows you to create combinations of agroclimatic conditions and search for accessions that may be expected to grow well under those conditions. The tool considers only accessions that include the geographic coordinates of their collecting sites. It uses a spatial resolution of approximately 5 km (i.e., a 5 by 5 km box at the equator), which means that all accessions sharing the same box are grouped together in the analysis.
Agroclimatic indicators
The Subsetting Tool characterises agroclimatic conditions using a set of 17 indicators grouped into six categories. The values of these agroclimatic indicators are calculated from long-term data spanning multiple decades.
Drought stress indicators
- Total precipitation: Total monthly precipitation measured in millimeters (mm).
- Consecutive dry days: Maximum number of consecutive days with precipitation less than 1 mm.
- Number of days with water stress: Number of days per month in which the ratio between actual and potential evapotranspiration (ERATIO) is less than 0.5. ERATIO is calculated following a simple water balance model.
Flood stress indicators
- Extreme daily precipitation: 95th percentile of precipitation per month measured in millimeters.
- Number of days with flooding: Number of days per month in which the ratio between actual and potential evapotranspiration (ERATIO) is greater than 0.5.
Heat stress indicators
- Average minimum temperature: Average monthly minimum temperature, measured in degrees Celsius.
- Average maximum temperature: Average monthly maximum temperature, measured in degrees Celsius.
- Average VPD: Monthly average vapor pressure deficit (VPD).
- Number of days with high VPD: Number of days per month for which the vapor pressure deficit is greater than or equal to 4 kPa.
Photoperiod indicators
- Mean solar radiation: Monthly average of solar radiation measured in W/m2.
- Julian day length: Average daylight hours per month.
Soil indicators
- Bulk density: Bulk density averaged over the top 60 cm of soil, measured in Cg/cm3.
- Cation exchange capacity: Average cation exchange capacity over the top 60 cm of the soil, measured in mmol(c)/kg.
- Type of soil texture: Qualitative variable indicating soil classes based on USDA soil taxonomy.
- Organic carbon content: Organic carbon content averaged over the top 60 cm of soil, measured in dg/kg.
- pH: Soil pH averaged over the top 60 cm of soil, reported as pH multiplied by 10.
- Salinity: Qualitative variable indicating soil salinity class from FAO datasets.
Crop-specific indicators
The crop-specific indicators are available only for the crops listed in the table below. These indicators use temperature cut-off points specific to each crop.
- Number of days with high temperatures: Number of days per month when the maximum temperature exceeds the crop’s upper temperature tolerance.
- Number of days with low temperatures: Number of days per month when the minimum temperature falls below the crop’s lower temperature tolerance.
- Number of days with optimal temperatures: Number of days per month in which the average temperature lies within the range of temperatures that is optimal for crop growth.
| Crop | Heat stress | Cold stress | Optimum |
|---|---|---|---|
| Beans | Tmax > 25.6 | Tmin < 13.5 | 17.5 < Tmean < 23.1 |
| Cassava | Tmax > 45 | Tmin < 15 | 22 < Tmean < 32 |
| Banana | Tmax > 35 | Tmin < 15 | 24 < Tmean < 27 |
| Wheat | Tmax > 32 | Tmin < 10 | 18 < Tmean < 25 |
| Maize | Tmax > 28 | Tmin < 15 | 28 < Tmean < 29 |
| Potato | Tmax > 24 | Tmin < 4 | 12.4 < Tmean < 17.8 |
| Sweet potato | Tmax > 35 | Tmin < 15.5 | 20 < Tmean < 32 |
| Rice | Tmax > 40 | Tmin < 13 | 20 < Tmean < 35 |
| Barley | Tmax > 36 | Tmin < 3 | 18 < Tmean < 24 |
| Sorghum | Tmax > 17.8 | Tmin < 39.1 | 26.7 < Tmean < 37.4 |
| Pearl millet | Tmax > 50 | Tmin < 13.3 | 12.4 < Tmean < 17.8 |
| Cowpea | Tmax > 50 | Tmin < 15 | 20 < Tmean < 35 |
| Yam | Tmax > 40 | Tmin < 20 | 25 < Tmean < 34 |
| Soybean | Tmax > 37 | Tmin < 14 | 25 < Tmean < 28 |
Table 1: Temperature cut-off points by crop
In this table, Tmax is the maximum temperature, Tmin is the minimum temperature, and Tmean is the mean temperature.
Accessing the Subsetting tool
The Subsetting Tool is accessible only to registered Genesys users. Please log in first.
Step 1: Apply passport filters
Once logged into Genesys, first filter for accessions of interest based on their passport data.
Figure 1: Applying filters by passport data
Genesys allows filtering of accessions in multiple ways.
Step 2: Open the Subsetting tool
After applying your passport filters, click the APPLY FILTERS button and then navigate to the SUBSETTING TOOL tab.
Figure 2: Steps to apply filters and open the Subsetting Tool
Always click APPLY FILTERS before entering the Subsetting Tool. Skipping this step causes the tool to ignore your previous selection and consider all accessions in Genesys.
Using the Subsetting Tool
The tool has two modes: "basic indicator selection" and "advanced indicator selection". Basic mode uses the full range of an indicator. Advanced mode provides more control, letting you specify a range of values for each indicator.
Basic mode example: Finding beans for a Colombian farm
Imagine a Colombian bean breeder or farmer who wants to request seeds from a genebank. They need material for a region of relatively high rainfall and low temperature.
- Apply a passport filter for beans as the crop before entering the Subsetting Tool.
Figure 3: Filtering beans accessions based on passport data before entering the subsetting tool
- In the Subsetting Tool, select indicators matching the target conditions. For example, choose a flood stress indicator (e.g., extreme daily precipitation) and the crop-specific indicator for low temperature.
Figure 4: The Subsetting Tool interface
Figure 5: Selection of indicators
- Select the number of subsets to generate, using the slider. The more subsets you ask for, the narrower will be the range of conditions in each. Then click GENERATE to run the analysis.
Figure 6: Generation of subsets
- Review the results. The tool shows:
- A pie chart with the number of accessions in each subset
- A descriptive statistics table by indicator and subset
- Line plots showing how each indicator behaves month by month
- A map showing the geographical distribution of accessions
Figure 7: Results of the analysis
Figure 8: Mean extreme precipitation (line plot)
Figure 9: Mean number of days with extreme minimum temperatures (line plot)
Figure 10: Geographical distribution of accessions
- Choose the subset that most closely matches the target conditions.
Figure 11: Selection of the subset of interest
- After selecting a subset, view the list of accessions with their passport data.
Figure 12: Accessions in the selected bean subset
If the resulting group is large (e.g., more than 50 accessions), you can filter further using the options described in the next section.
Advanced mode: Using indicator ranges
The advanced mode lets you specify exact ranges for each indicator. This is useful when you know the precise conditions of your target environment.
Example: Finding cassava for a research study
A PhD student wants to evaluate cassava accessions in a field where, from previous studies, she knows that during January to June there are high temperatures (maximum above 25 degrees Celsius) and very little rainfall (approximately 51 mm per month).
- Apply a passport filter for cassava and enter the Subsetting Tool.
Figure 13: Steps to enter the subsetting tool with cassava selected as the crop
- Select Advanced indicator selection with ranges.
Figure 14: Activating advanced mode
- Choose the time period for the analysis. The indicators are calculated for multiple multi-year periods (2010-2016, 2005-2016, 2000-2016, 1995-2016, 1990-2016, and 1983-2016).
Figure 15: Selecting temporality
- Set indicator ranges based on your target conditions:
- Total precipitation: 0 to 51 mm
- Average maximum temperature: greater than 25 degrees Celsius
- Days with water stress: adjust as needed
Figure 16: Selection of indicators
- Click the Filter button to generate the first subset of accessions meeting your target conditions.
Figure 17: Filter accessions
- Review the accessions in the Accessions tab, the map in the Map tab, and statistics in the Plots tab.
Figure 18: Accessions tab
Figure 19: Geographic distribution of accessions on the Map tab
Figure 20: Plots tab
Grouping accessions with clustering methods
If you want to explore diversity within your filtered accessions, you can group them using different clustering methods:
- Agglomerative method: Classic clustering where you specify the number of subsets to generate.
- Density-based clustering (DBSCAN): Clustering that groups similar accessions, where you specify Epsilon (physical distance between points to join) and Minpts (minimum number of accessions per group).
- Hierarchical density-based clustering (HDBSCAN): Hierarchical clustering that groups nearby accessions, where you specify the minimum number of points per cluster.
- Select the clustering method and generate three to five subsets from the filtered accessions.
Figure 21: Selecting the clustering method and number of subsets
- Review the statistics, line plots, and geographical distribution to choose the subset that best matches your target conditions.
Figure 22: Selecting subset candidates
Figure 23: Line graph (mean number of consecutive dry days)
Figure 24: Geographical distribution of accessions
Based on the analysis, the student establishes that set 5 is the most suitable for her study.
Figure 25: Accessions in the selected cassava subset
Downloading accession data
If the resulting group is large (e.g., more than 50 accessions), the tool offers three options to obtain a smaller candidate subset:
- Random: Select a random sample of accessions from the results. By default, 10 accessions are selected, but you can modify this number.
- Core collection: Select the most representative accessions that capture the greatest amount of environmental variation. This also defaults to 10 accessions.
- Manual: If you are familiar with the resulting accessions, you can select them manually.
Figure 26: Choice of candidate subset
Figure 27: A candidate subset
Selected accessions are saved to the My List in your user profile, from where you can download them.
Figure 28: Downloading selected accessions from the candidate subset
Resources
Generic indicators
The following datasets provide the agroclimatic indicators used by the Subsetting Tool:
Crop-specific indicators
Crop-specific indicators are available for these crops: bean, cassava, banana, wheat, maize, potato, sweet potato, rice, barley, sorghum, pearl millet, cowpea, yam, soybean.
Bibliography
- Hengl, T. et al. (2017). SoilGrids250m: Global gridded soil information based on machine learning. PLoS one, 12(2), e0169748.
- Funk, C. et al. (2015). The climate hazards infrared precipitation with stations: a new environmental record for monitoring extremes. Scientific data, 2(1), 1-21.
- Verdin, A. et al. (2020). Development and validation of the CHIRTS-daily quasi-global high-resolution daily temperature data set. Scientific Data, 7(1), 303.
- Ruane, A. C. (2021). AgMERRA and AgCFSR Climate Forcing Datasets for Agricultural Modeling.