Regional GAM

Overview
Creative Commons License: CC-BY Questions:
  • What are abundance and trends of a butterfly species?

Objectives:
  • Obtain and filter/manipulate occurrence data

  • Compute and visualize phenology of a species through the years

  • Compute temporal abundance trends

Requirements:
Time estimation: 2 hours 30 minutes
Supporting Materials:
Published: Jul 4, 2019
Last modification: Apr 10, 2024
License: Tutorial Content is licensed under Creative Commons Attribution 4.0 International License. The GTN Framework is licensed under MIT
purl PURL: https://gxy.io/GTN:T00134
version Revision: 212

This tutorial will show you how to study species abundance through the computation of a flight curve, abundance index, and trends. It will explain you how to use different regionalGAM tools on Galaxy allowing you to deal with datasets containing abundance information for various species per site and per date through a couple of years.

After a certain number of steps, you will be able to extract single species data and study related abundance through the years. The goal of this exercise is to be able to create abundance trend over time and biodiversity indicators. Following these indicators allow to follow trends in terms of population dynamics. You could for example try to predict the occurrences of one specific species in a certain type of environment using the prediction model of climate evolution. Based on charts that you will generate, you could try to explain the evolution of a species with environmental data (temperatures variations, modifications of the environmental conditions).

You will basically learn how to create a file on the basis of which you can create a visual material that can be quite easily understood and therefore be efficient for a large audience.

Agenda

In this tutorial, we will deal with:

  1. Step 1: Pre-processing
    1. Data upload
    2. Prepare the data
    3. Check that the dataset contains only one species
  2. Step 2: Analyze phenology of a species through the years
    1. Compute and visualize the phenology
    2. Compute Abundance Index across sites and years
    3. Compute a collated index for each year and estimates the temporal trend
    4. Model temporal trend
    5. Take into account the autocorrelation
  3. Conclusions

Step 1: Pre-processing

The goal of the first step is to upload and prepare the file so that it will be usable for the regional GAM analysis.

Data upload

Hands-on: Data upload
  1. Create a new history for this tutorial and give it a proper name like regionalGAM tutorial

    Click the new-history icon at the top of the history panel:

    UI for creating new history

    1. Click on galaxy-pencil (Edit) next to the history name (which by default is “Unnamed history”)
    2. Type the new name
    3. Click on Save

    If you do not have the galaxy-pencil (Edit) next to the history name:

    1. Click on Unnamed history (or the current name of the history) (Click to rename history) at the top of your history panel
    2. Type the new name
    3. Press Enter

  2. Import the CSV dataset file with only one species from Zenodo or from the data library (ask your instructor)

    https://zenodo.org/record/1324204/files/regional%20GAM%20data.csv
    
    • Copy the link location
    • Click galaxy-upload Upload Data at the top of the tool panel

    • Select galaxy-wf-edit Paste/Fetch Data
    • Paste the link(s) into the text field

    • Press Start

    • Close the window

    As an alternative to uploading the data from a URL or your computer, the files may also have been made available from a shared data library:

    1. Go into Shared data (top panel) then Data libraries
    2. Navigate to the correct folder as indicated by your instructor.
      • On most Galaxies tutorial data will be provided in a folder named GTN - Material –> Topic Name -> Tutorial Name.
    3. Select the desired files
    4. Click on Add to History galaxy-dropdown near the top and select as Datasets from the dropdown menu
    5. In the pop-up window, choose

      • “Select history”: the history you want to import the data to (or create a new one)
    6. Click on Import

  3. Check that the file contains a header corresponding to: "SPECIES","SITE","YEAR","MONTH","DAY","COUNT", and that all the non numeric content are between double quotes as “x” and that separators are “,”

This dataset gathers years of records of the presence of butterfly species per site and per day. Columns indicates species names (“SPECIES”), observation site (“SITE”), date of the observation (“YEAR”,”MONTH”,”DAY”) and number of individuals (“COUNT”). It compiles counts for the Gatekeeper (Pironia tithonus) collected between 2003 and 2012 and extracted from five European BMSs (United Kingdom, Netherlands, France, Germany, and Catalonia-Spain). The Gatekeeper has one generation per year and feeds mainly on Poaceae. It is found in the Central and Southern Europe, North Africa Anatolia, and Caucasus.

Gatekeeper (Pironia tithonus). Open image in new tab

Figure 1: Gatekeeper (Pironia tithonus) Charles J Sharp

Prepare the data

The current dataset contains a lot of data (exact site names for 5 butterfly monitoring scheme). Processing the file in this condition would require time and for the purpose of this tutorial, we will reduce the number of sites. The column with header SITE of the dataset you are using is really long and the SITES are classified into sub-sites (like ESBMS.12, ESBMS.28, ESBMS.55, etc).

Here, we will only keep the sites that are in the Netherlands (NLBMS.XX). We want to create a down-sampled file, by selecting the lines where NLBMS is found.

Hands-on: Downsample and hide some information
  1. Text reformatting with awk tool with the following parameters:
    • param-file “Select cells from”: Uploaded CSV dataset file tool
    • “AWK Program”:

       NR == 1 { print }
       /NLBMS/ { print }
      

The first line will skip and print the header and the second will print all the lines where NLBMS is found Warning: depending on the Galaxy instance your are using, this tool can not appear on the tool panel. Another solution can be to use Select lines that match an expression tool to select lines matching ‘NLBMS’ pattern in addition to Select first lines from a dataset tool specifying keeping the first line, so the header, then Concatenate datasets tail-to-head tool to recreate a CSV file from concatenating the header and NLBMS lines of the original csv file.

Question

How many sites do you have before and after removing the sites from outside the Netherlands?

You may need to use a tool like Count occurrences of each record tool. If you want to run the same tool with same parameters to several input files, you can directly specify the param-files Multiple datasets option on the tool form for the “from dataset” parameter).

  1. Click on param-files Multiple datasets
  2. Select several files by keeping the Ctrl (or COMMAND) key pressed and clicking on the files of interest

The dataset contains 280 sites now against 1143 before down-sampling.

Hands-on: Data upload.
  1. Import the RData

    For example, you can upload:

    https://zenodo.org/record/1324204/files/gatekeeper_CM%20.RData
    
  2. RData binary file reader tool with the following parameters:
    • param-file “Rdata binary file to explore”: imported RData
  3. RData parser tool with the following parameters
    • param-file “Rdata file to explore”: imported RData
    • param-file “File with .Rdata content details”: output of RData binary file reader tool
    • “Select which attribute(s) you want to extract”: select everything but “trend”
    • “Bind variables in a single tabular when its possible”: Yes

If the tool RData parser tool don’t succeed to create a single tabular file, it generates separate files, each of them containing one column. The file with the TREND header can be let aside as we don’t need it for what will follow.

Question

If Rdata parser fails to generate a single unified tabular file, can you propose a way to regenerate such a dataset ?

You can do that using:

  1. Paste two files side by side tool tool with the following parameters:
    • param-file “paste”: output from RData parser tool headed with “SPECIES”
    • param-file“and”: output from RData parser tool with headed with “SITE”
  2. Repeat Paste two files side by side tool executions as many times as there are separated files in order to create a final dataset with all the columns:
    1. Repeat Paste two files side by side tool tool to paste the file containing 2 columns with the one headed by YEAR
    2. Repeat Paste two files side by side tool tool to paste the file containing 3 columns with the one headed by MONTH
    3. Repeat Paste two files side by side tool tool to paste the file containing 4 columns with the one headed by DAY
    4. Repeat Paste two files side by side tool tool to paste the file containing 5 columns with the one headed by COUNT

Check that the dataset contains only one species

The second step of any Regional GAM data analysis is making sure to have a dataset of only one specific species that you will then be able to use. If you want to create a graph showing abundance evolution by years of several species, you will have to superimpose the graphs on one another.

As the dataset is quite big and may contain heterogeneous information, we need to know whether the data are about one species or more.

Hands-on: How many species are taken into account in this dataset?
  1. Count occurrences of each record tool with the following parameters:
    • param-file “from dataset”: output of Text reformatting with awk
    • “Count occurrences of values in column(s)”: Column: 1, the SPECIES column
    • “Delimited by”: Tab
    • “How should the results be sorted?”: With the most common values first
  2. Inspect the generated file by clicking on the galaxy-eye (eye) icon (View data)
  3. Check that the dataset is for one species only

If your dataset contains information about more than one species, you can apply the previous steps and then run an extra-step to select one specific species and show all the data corresponding to it.

As the dataset is quite big and contains heterogeneous information, you want to know whether the data are about one species or more. So the first step consists to count how many species are taken into account in this dataset.

To test these steps, you can use the following dataset:

https://zenodo.org/record/1324204/files/Dataset%20multispecies%20Regional%20GAM.csv
Question
  1. How many species does your initial dataset take into account ?
  2. What are their names ?
  1. The dataset contains information on 2 different species
  2. Their names are “Pyronia tithonus” and “Aglais io”.

We now need to create a new file containing the data for only one species

Hands-on: Creating a new file containing only the data from one species
  1. Copy the name of the species you are interested in (for example: “Aglais io”).
  2. Filter data on any column using simple expressions tool
    • param-file “Filter”: output of Text reformatting with awk tool
    • “With following condition”: c1=='"Aglais io"' or (another species name)
    • “Number of header lines to skip”: 1

    You can repeat this set of actions as much as necessary, changing only the name of the species taken into account. By doing this, you will obtain separated dataset, each of them containing a different species.

  3. Repeat the last step on all the different outputs from Filter data on any column using simple expressions tool that you have, one by species
  4. Tag your new dataset with an explicit tags as “Count” and “Aglais io” and/or rename this dataset like “Aglais io count file”.

If you want to create a graph showing abundance evolution by years of several species, you will have to superimpose the graphs on one another.

Step 2: Analyze phenology of a species through the years

Compute and visualize the phenology

Phenology, as described in Wikipedia, is the study of periodic plant and animal life cycle events and how these are influenced by seasonal and inter-annual variations in climate, as well as habitat factors (such as elevation).

Now you have a file containing all the data on the species of interest. The main goal of this step is to model one phenology per year using a general additive model (GAM) with time and sites as explanatory variables. This model will be used to predict values for missing counts at local sites in order to improve the quality of the abundance indices.

Hands-on: Phenology
  1. Flight curve tool with the following parameters
    • param-file “Count file”: output file you just generated with the Text reformatting with awk or Filter data on any column using simple expressions if your file was containing more than one species tool
  2. Generate the chart using the visualization
    1. Inspect and expand the output data from Flight curve tool
    2. Click on the galaxy-barchart (Visualize) icon
    3. Select Line chart (NVD3) as visualization type
    4. Give it a proper name, e.g. Pyronia tithonus phenology raw simple vizu
    5. On Select data area, specify:
      • “Provide a label”: Pyronia tithonus phenology from 2003 to 2012 for example
      • “Pick a series color”: Choose a color for the line
      • “Data point labels”: Column 1
      • “Values for x-axis”: Column 2
      • “Values for y-axis”: Column 6
    6. On Change settings, specify:
      • “X-Axis label”: Year
      • “Y-Axis label”: nm values
    7. Click on Save

Phenology chart.

This graph displays the modeled flight curve of Pyronia tithonus over the years. But the first year is “null”, probably a left-over of the 1st line with the header, and the week number is not shown.

Hands-on: Create a new column of the dataset containing the week and the year
  1. Count occurrences of each record tool with the following parameters
    • param-file “from dataset”: output from Flight curve
    • “Select”: Column: 2 (the column with the year)
    • “Delimited by”: Tab
    • “How should the results be sorted?”: By the values being counted
  2. Inspect and expand the output data from Count occurrences of each record tool

    Question

    What can you see in this file?

    A list of the years and the number of occurrence for each year which should match the number of days for each year.

  3. Column Regex Find And Replace tool with the following parameters:
    • param-file “File to process”: output file from flight curve.
    • “in column”: Column 2 (the column with the year)
    • Click on “Insert Check”
    • “Find pattern”: (20[0-9][0-9])
    • “Replace with”: -\1
  4. Inspect the file and check if all the years are now written with a - before the digits.
  5. Merge Columns together tool with the following parameters:
    • param-file “Select data”: output from the last Column Regex Find And Replace.
    • “Merge column”: Column: 3 (the column with the week)
    • “with column”: Column: 2 (the column with the year)
  6. Column Regex Find And Replace tool to recreate the original content for the year column:
    • param-file “File to process”: output file from Merge Columns together.
    • “in column”: Column 2 (the column with the year)
    • “Find pattern”: -(20[0-9][0-9])
    • “Replace with”: \1
  7. Remove beginning of a file tool to remove first line (to avoid header in the visualization)

    Comment: Dataset with information about more than one species

    If your dataset contains information about more than one species, you can apply the previous steps and then run an extra-step to select one specific species and show all the data corresponding to it.

  8. Generate the chart using the visualization with the x-axis corresponding to your column "week""year".
    1. Inspect and expand the output data from Remove beginning of a file tool
    2. Click on the galaxy-barchart (Visualize) icon
    3. Select Line chart (NVD3) as visualization type
    4. Give it a proper name, e.g. Pyronia tithonus phenology simple vizu
    5. On Select data area, specify:
      • “Provide a label”: Pyronia tithonus phenology from 2003 to 2012 for example
      • “Pick a series color”: Choose a color for the line
      • “Data point labels”: Column 6 (the nm column) or another one
      • “Values for x-axis”: Column 7 (the “week-year” column)
      • “Values for y-axis”: Column 6 (the nm column)
    6. On Customize, specify:
      • “X-Axis label”: Week-Year
      • “Y-Axis label”: nm values
    7. Click on Save

Phenology chart.

This shows the abundance of Pyronia tithonus, over the weeks. We can see there is a peak every year as expected and we can notice some differences in the values between the weeks and years, but not how the weeks overlap between the years. We will plot a stalked version of this visualization to check if there are no unexpected changes and have an idea of the quality of the reconstructed phenology.

Hands-on: Visualize the years on a stacked graph
  1. Scatterplot w ggplot2 tool with the following parameters
    • param-file “from dataset”: output from Flight curve
    • “Column to plot on x-axis”: 4 (the column with the year)
    • “Column to plot on y-axis”: 6
    • “Plot title”: add a meaningful title (e.g. Pyronia tithonus phenology stacked visualization)
    • “Label for x axis”: add a meaningful label (e.g. Day number)
    • “Label for y axis”: add a meaningful label (e.g. nm value)
    • “Type of plot”: Line only
    • “Plotting multiple groups”: Plot multiple groups of data on one plot to superimpose years
    • “column differentiating the different groups”: 2 to affect one coulor by year
    • “Color schemes to differentiate your groups”: set 3 or any set of color with more than 10 colors as there are 10 years in our dataset.

Stacked Phenology chart.

With this graph, we can see that Pyronia tithonus records are always around the same weeks every year. We can also see small differences between years but overall the phenology is quite stable and the results of this step seem good and allow us to continue with the calculation of the abundance index.

If you are working with more than one species, you should follow the next steps

Hands-on
  1. Paste two files side by side tool with the following parameters:
    • “Paste”: the output from Merge Columns together (with the dataset for species 1)
    • “and”: the output from Merge Columns together (with the dataset for species 2)
    • “Delimited by”: tabulation
Comment: You can add other species.

In order to do so you will have to do as explained below:

  1. Paste two files side by side tool with the following parameters:
    • “Paste”: the output from Paste two files side by side (with the dataset containing species 1 and 2)
    • “and”: the output from Merge Columns together (with the dataset containing species 3)
    • “Delimited by”: tabulation
  2. Repeat Paste two files side by side tool with the output from Paste two files side by side (with the data containing species 1, 2 and 3) and with the output from Merge Columns together (with the dataset containing species 4) and so on.

If your input dataset contains information about more than one species, you can now generate a chart for the multi-species dataset:

Hands-on
  1. Inspect and expand the output data from flight curve tool
  2. Click on the galaxy-barchart (Visualize) icon
  3. Select a visualization: line chart (NVD3)
  4. Give it a proper name like Aglais io & Pyronia tithonus phenology
  5. Select data
    • “Provide a label”: The name of the first species, for example Aglais io
    • “Pick a series color”: Choose a color
    • “Data point labels”: Column corresponding to the name of the species 1
    • “Values for x-axis”: Column corresponding to the "week and year" of the species 1
    • “Values for y-axis”: Column corresponding to nm of the species 1
  6. Insert data series:
    • *“Provide a label”: he name of the second species, for example Pyronia tithonus
    • “Pick a series color”: Choose a different color
    • “Data point labels”: Column corresponding to the name of the species 2
    • “Values for x-axis”: Column corresponding to the "week and year" of the species 2
    • “Values for y-axis”: Column corresponding to nm of the species 2
  7. You may repeat “Insert data series” as many times as needed depending on the number of different species you want to represent on your chart.
  8. Click on Customize
    • “X-Axis label”: Week and Year
    • “Y-Axis label”: nm values
    • “Use multi-panels”: click on No(or you will have separated charts, one for each species)
  9. Click on Save if you are willing to keep it

Compute Abundance Index across sites and years

We now would like to create a file showing the abundance index per year of a chosen species in a certain site.

Hands-on: Generate an abundance index
  1. Abundance index tool with the following parameters:
    • “Count file”: output from Text reformatting with awk, that should be named Counting file and/or tagged Count
    • “Flight curve output”: output from flight curve

Abundance index tool generates a table with 5 columns:

  • Site
  • Species
  • Year
  • Regional GAM
  • prop_pheno_sampled

Compute a collated index for each year and estimates the temporal trend

The expected temporal trend allows you to have an overview of the evolution of a species in a certain type of environment in the future.

Hands-on: Expected temporal trend
  1. Expected temporal trend tool with the following parameters:
    • “Tabular file generated by the ab_index tool”: output of abundance index

Expected temporal trend tool generates 2 files”

  1. The graph like:

    Expected temporal trend.

  2. A table with values of “x”, the collated index value by year

Sometimes the expected temporal trend can’t be done on dataset. If you want this action to work, the occurrences on your dataset must lie between the month of April and the end of the month of September.

Model temporal trend

We would like to know if the year has an influence on the abundance of a species. We will use a linear regression to do that.

The model fitted to the data is: \(Y_i = \alpha + \beta x_i + \epsilon_i\) with \(Y_i\) = value of the dependent variable for the unit \(i\) \(\alpha\) = intercept \(\beta\) = slope \(x_i\) = value of the explanatory variable for the unit \(i\) \(e_i\) = residual for the unit \(i\)

Hands-on: Model temporal trend with linear regression
  1. Model temporal trend with a simple linear regression tool
    • param-file “File generated by the glmmpql/Expected temporal trend tool”: tabular output of temporal trend
    • param-file “File generated by the ab_index tool”: output from abundance index

Have a look at the text file result. This is the output of the linear model.

Output from the "model temporal trend with simple linear regression" tool .

Details about the output from the tool

  1. The formula of the model following this format: “Model : dependent variable ~ explanatory variable”
  2. The estimated values of the coefficients
  3. The standard error of the coefficients
  4. The value of the “hypothesis test statistic”
  5. The probability value.
Question
  1. What are the estimates of the regression coefficients?
  2. Can we use this model to make good predictions?
  3. Is the test p-value significant?
  1. Intercept is 183.33852 and the slope (Year) is -0.08952.
  2. No, the residual standard error is high.
  3. Yes (0.0282 < 0.05).

We can also test for autocorrelation in the data.

Hands-on: Check if there is autocorrelation of residuals
  1. Autocorrelation test check for temporal autocorrelation in the residuals tool with the following parameters.
    • param-file “gls model”: tabular output of Model temporal trend

Autocorrelation test graph.

Have a look at this plot. We can see that one of the value is above the threshold (blue dashed line), therefore we observe autocorrelation in the data. We will now take into account the autocorrelation in the next model.

Take into account the autocorrelation

Hands-on: Model temporal trend taking into account autocorrelation of residuals
  1. Linear regression ajusted for autocorrelation in the residuals tool with the following parameters.
    • param-file “File generated by the glmmpql/Expected temporal trend tool”: tabular output of temporal trend
    • param-file “File generated by the ab_index tool”: output from abundance index

For this step you can use the scratchbook function in order to see the results of both models at the same time.

You can follow this tutorial if you want to learn how to use the scratchbook. https://usegalaxy.org/tours/core.scratchbook

Plot of temporal trend with trend line.

Here you can compare the models using the AIC for Akaike information criterion. We can see that the AIC is lower in the model taking the autocorrelation into account. A lower AIC value is associated with less information loss. We will therefore, based on the AIC, select the model taking into account the autocorrelation. We can now represent the data with the trend line from the model.

Hands-on: Plot the data and the trend line from the model
  1. Plot abundance with trend line tool with the following parameters.
    • param-file “File generated by the ab_index tool”: output from abundance index
    • param-files “gls model”: outputs of Model temporal trend with a simple linear regression.

Plot of temporal trend with trend line.

You can see the trends is an apparent decrease. Here results are statistically significant so we can say that there is a significant decrease of the abundance.

Conclusions

In this tutorial, you have analyzed regional GAM data to extract useful information in order to be able to show different tendencies of a chosen species. Therefore, you are now able to treat the dataset so that it shows only the data for one specific species of your choice. From there, you can show the phenology of this species through the years first on a dataset and then on a visual chart. You have also learned how to represent on a single chart the phenology of various species. Afterwards, we have shown you how to create a dataset containing the information on the abundance of a species per year and per site. Based on which you can henceforth visually represent the annual abundance trend on a chart. Thereafter, you have the possibility of showing the expected temporal trend, based on which you will be able to assess the abundance of species. The last part of this tutorial has shown you how to calculate the linear regression allowing you to determinate whether the year has an influence on the abundance of a species or not.