DOI: 10.16904/envidat.532
title: Data on the diet of urban and rural bumblebees

description: Data on the diet of urban and rural bumblebees individuals, Bombus lapidarius and Bombus pascuorum, collected in Switzerland (cantons Bern, Basel and Zürich) obtained using metabarconding and chemical analyses from two pollen transportation structures, that is, the body and the leg-baskets (i.e., corbicula). The bumblebees were collected by Egenberger et al., 2019 (https://doi.org/10.5061/dryad.qt8mr4v)
The data contains:
- The composition and relartive abundance of plant species in the body and the leg-baskets, separately.
- The content and ratios of two groups of macronutrients, that is, amino acids and fatty acids.
The dataset contains the data used in the paper "Urban bumblebees diversify their foraging strategy to maintain nutrient intake" as well as unpublished data.
description: Resource Title: Dataset1_Composotion_pollen.csv
 Size: 709634 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/0fd97e8a-015e-4f9b-8c28-14ce1ae4dc6a/download/dataset1_metabarcoding_pollen.csv
 Description: The dataset contains the filtered plant composition1 (removing species with too low relative abundances) and the relative abundance obtained from DNA metabarcoding on pollen samples for both the leg-baskets and the body. The dataset contains the following columns:

- SampleID: Combining bumblebee ID, location, landscape and replica
- Abundance: numeric, relative abundance
- BumblebeeID: numerical ID for each bumblebee individual within a location, landscape and replicate sampling place.
- Location: canton, levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: landscape type, levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) within location and landscape. Levels: A-E.
- LocationLandscape: 
- Bumblebee_species: the two studied species, levels: B.pasquorum; B. lapidarius
- Transportation_structure: bumblebee pollen transportation structure, levels: B = Body; L = leg-baskets (i.e. corbicula)
- Kingddom: taxonomic
- Phylum: taxonomic
- Order: taxonomic
- Family: taxonomic
- Genus: taxonomic
- Species: plant sicentific name
-Binomial_abundance: Logic, indicating if the plant species is included (1).

The raw metabarcoding data is archived in NCBI project PRJNA1137320
description: Resource Title: Dataset3_Aminoacids.csv
 Size: 23314 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/ce8bb95f-caaf-4959-a7c9-07bf93806939/download/dataset3_aminoacids.csv
 Description: The dataset contains the amino acid content and ratios for the two bumblebees. Measures are taken only from pollen from the leg-baskets. SampleID is not the same as in the metabarcoding, several samples from different bumblebees were merged within a Location ,Landscape and Replica. Not for all the samples there is information on both amino acids and fatty acids. The columns are:

- SampleID_chemical: The ID for chemical analyses
- Location: the three Swiss cantons studied. Levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: the two typea of human-dominated ecosystems, nested to the Swiss canton. Levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) nested with the location and the landscape. Levels: A-E.
- Bumblebee_species: the two studied species, levels: B.pasquorum; B. lapidarius
- LocationLandscape: Combining location and landscape
- Asp, Thr, ..., Arg: Content of individual amino acids. Amino acids are written as abbreviated names. FUll names be checked here: https://en.wikipedia.org/wiki/Amino_acid
- sum: total sum of amino acid content (mg)
- sumessential: total sum essential amino acids (mg)
-sumnon-essential: total sum non-essential amino acids (mg)
- proportionnonessentialessential: proportion between essential and non-essential amino acids.
description: Resource Title: Dataset4_Fattyacids.csv
 Size: 58574 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/0b2c5c45-629f-4b01-8c58-535c06c74fb2/download/dataset4_fattyacids.csv
 Description: The dataset contains the fatty acid content and ratios for the two bumblebees. Measures are taken only from pollen from the leg-baskets. SampleID is not the same as in the metabarcoding, several samples from different bumblebees were merged within a Location ,Landscape and Replica. Not for all the samples there is information on both amino acids and fatty acids. The columns are:

- SampleID_chemical: The ID for chemical analyses
- Location: the three Swiss cantons studied. Levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: the two typea of human-dominated ecosystems, nested to the Swiss canton. Levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) nested with the location and the landscape. Levels: A-E.
- Bumblebee_species: the two studied species, levels: B.pasquorum; B. lapidarius
- LocationLandscape: combination between location and landscape
- Caprylic, Pelargonic, ..., Lacceroic: Content of individual fatty acids acids. 
- sum: total sum of fatty acid content (mg)
- unsaturatedsum: total sum unsaturated fatty acids (mg)
- saturatedsum: total sum saturated fatty acids (mg)
- omega3sum: total sum Omega 3 fatty acids (mg)
- omega6sum: total sum Omega 6 fatty acids (mg)
- omega9sum: total sum Omega 9 fatty acids (mg)
- omega6to3ratio: ratio Omega 6 to Omega3 fatty acids
-saturatedtounsaturatedration: ratio between saturated and unsaturated fatty acids
description: Resource Title: Dataset2_sites.csv
 Size: 1248 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/75bace68-f772-4103-9fdf-8395ce1c3d51/download/dataset2_sites.csv
 Description: The dataset contains the information on the 16 study sites:

- Location: the three Swiss cantons studied. Levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: the two typea of human-dominated ecosystems, nested to the Swiss canton. Levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) nested with the location and the landscape. Levels: A-E.
- Site_ID: combination of location, landscape and replicate
- X: X coordinate, WGS84
- Y: Y coordinate WGS84
- Plant S in landscape: Plant species richness within the 800 m calculated using both information from the Global Biodiversity Information. Facility (GBIF) and InfoFlora (www.infoflora.ch).
- % Buildings: the proportion of buildings and other impervious surfaces within 800 m radius.
- % Agricultural: the proportion of agricultural land and other impervious surfaces within 800 m radius.
- % Water: the proportion of water and other impervious surfaces within 800 m radius.
- % Meadows & grasslands: the proportion of meadows and grasslands and other impervious surfaces within 800 m radius.

The raw metabarcoding data is archived in NCBI project PRJNA1137320.
description: Resource Title: Dataset5_Species_richness.csv
 Size: 14377 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/79d981d0-0c62-4e78-810f-750644a08176/download/dataset5_species_richness.csv
 Description: Processed data. The dataset contains the plant species richness in the leg-baskets per bumblebee individual. It contains:

- SampleID: Combining bumblebee ID, location, landscape and replica
- Location: canton, levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: landscape type, levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) within location and landscape. Levels: A-E.
- LocationLandscape: combining location and landscape
- Bumblebee_species: the two studied species, levels: B.pasquorum; B. lapidarius
- Plant species richness: the number of plant species found in the pollen of the leg-baskets.
description: Resource Title: Dataset6_Functional_Diversity.csv
 Size: 86806 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/06afcb49-cc9f-45da-b64f-5860c277d498/download/dataset6_functional_diversity.csv
 Description: Processed data. The dataset contains the functional diversity metrics based on the plant composition from the leg-baskets per bumblebee individual. It contains:

- SampleID: Combining bumblebee ID, location, landscape and replica
- Location: canton, levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: landscape type, levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) within location and landscape. Levels: A-E.
- LocationLandscape: combining location and landscape
- Bumblebee_species: the two studied species, levels: B.pasquorum; B. lapidarius
- Fric.w: Weighted functional richness
-Fric: functional richness
-FEve.w: Weighted functional evenness
- FEve: functional evenness
- FDiv.w: weighted functional divergence 
- FDiv: functional divergence
description: Resource Title: Dataset7_Phylogenetic_Diversity.csv
 Size: 74413 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/f34a3f6e-91f3-4619-a258-8e4408050032/download/dataset7_phylogenetic_diversity.csv
 Description: Processed data. The dataset contains the phylogeneitc diversity metrics based on the plant composition from the leg-baskets per bumblebee individual. It contains:

- SampleID: Combining bumblebee ID, location, landscape and replica
- Location: canton, levels: Bern =BE; Basel = BS; Zurich =ZH
- Landscape: landscape type, levels: Urban = U; Rural = R
- Replicate: sampling place (800-m buffer) within location and landscape. Levels: A-E.
- LocationLandscape: combining location and landscape
- Bumblebee_species: the two studied species, levels: B.pasquorum; B. lapidarius
- PVar: phylogenetic variance
- PRic: Phylogenetic richness
- PEve: Phylogenetic evenness
- PClu: Phylogenetic clustering
description: Resource Title: Dataset8_PlantTraits.csv
 Size: 33177 bytes
 Format: text/csv
 URL: https://www.envidat.ch/dataset/ae82037f-c201-4f1d-9a57-162a25264ddb/resource/79128caa-e0a4-43d6-8b60-ff111075a984/download/dataset8_planttraits.csv
 Description: The dataset contains the plant trait values obtined from published sources. It contains:
- Kingddom: taxonomic
- Phylum: taxonomic
- Order: taxonomic
- Family: taxonomic
- Genus: taxonomic
- Species: species name
- plant.species: full scientific name
- native_exotic: origin status. As presented in https://www.doi.org/10.16904/envidat.210
- pollination mode: vector of pollination. As presented in https://www.doi.org/10.16904/envidat.210
- Flowering_months_duration: Number of flowering months. As presented in https://www.doi.org/10.16904/envidat.210
- start_flowering: month of the starting of the flowering. As presented in https://www.doi.org/10.16904/envidat.210
- growth_form_category: plant growth form. As presented in https://www.doi.org/10.16904/envidat.210
- plant-height: plant heght in meters. As presented in https://www.doi.org/10.16904/envidat.210
- inflorescence: Logic, plant with single flowers (0) or inflorescences (1). As presented in https://www.doi.org/10.16904/envidat.210
- structural_blossom_class: depicting the accessibility of the flowers. As presented in https://www.doi.org/10.16904/envidat.210
- symmetry: floral symmetry. As presented in https://www.doi.org/10.16904/envidat.210
- nectar: logic, nectar present. As presented in https://www.doi.org/10.16904/envidat.210
- pollen: logic, pollen rewards present. As presented in https://www.doi.org/10.16904/envidat.210
- oil: logic. oil present. As presented in https://www.doi.org/10.16904/envidat.210
- sugar.concentration: the amount of sugar present in the nectar, in mg.

Additional information can be found in https://doi.org/10.1016/j.dib.2021.107243