Published February 7, 2025 | Version version 1.2.0
Dataset Open

ShareTrait: a data portal for making trait data interoperable and reusable

Creators

  • 1. ROR icon Alfred-Wegener-Institut Helmholtz-Zentrum für Polar- und Meeresforschung
  • 2. ROR icon Vrije Universiteit Amsterdam
  • 3. ROR icon Martin Luther University Halle-Wittenberg
  • 4. ROR icon Australian Institute of Marine Science
  • 5. ROR icon University College London
  • 6. ROR icon Zoological Society of London
  • 7. ROR icon Universidad de Santiago de Chile
  • 8. ROR icon Monash University
  • 9. ROR icon University of Hong Kong
  • 10. ROR icon Universidad de Los Lagos
  • 11. ROR icon University of Helsinki
  • 12. ROR icon University of Nottingham
  • 13. ROR icon University of Białystok
  • 14. ROR icon Royal Netherlands Institute for Sea Research
  • 15. ROR icon KU Leuven
  • 16. ROR icon University of Haifa
  • 17. ROR icon Université de Rennes
  • 18. ROR icon Leiden University
  • 19. ROR icon Austral University of Chile
  • 20. ROR icon Fondation Pour la Recherche Sur la Biodiversité
  • 21. ROR icon Universidad de Oviedo
  • 22. ROR icon University of St Andrews
  • 23. ROR icon University of Aberdeen
  • 24. ROR icon University of Calicut
  • 25. ROR icon University of Salento
  • 26. ROR icon University of Mons
  • 27. ROR icon Ludwig-Maximilians-Universität München
  • 28. ROR icon University of Turin
  • 29. ROR icon Radboud University Nijmegen
  • 30. ROR icon University of Liège
  • 31. ROR icon Western Sydney University

Description

Scope

This dataset provides the SQL version of the ShareTrait database, corresponding to ShareTrait version 1.2.0. It represents the structured database equivalent of the previously published dataset, ShareTrait: a data portal for making trait data interoperable and reusable, version 1.0.0 (Zenodo, July 12, 2023, DOI: 10.5281/zenodo.8138904). This version includes the database file, an SQL query, and the resulting output file generated from the SQL query. 

Dataset content

The repository provides:

  • ShareTrait-database-v1.2.0.db : the database file.
  • master-query-all.sql : SQL query used for reconstructing the dataset.
  • master-query-output.csv : SQL query output file .
  • ShareTrait-dataset-database-mapping.csv : mapping of attribute fields from the SQL query output to the corresponding attributes in ShareTrait_MetaData_v1.0.0.csv, with relevant column name = "Column_name", version 1.0.0 (DOI: 10.5281/zenodo.8138904)

Access and usage

Files and documentation are available on GitHub: ShareTrait Project. Users can execute the SQL query by using either SQLiteStudio or SQLite3. Detailed instructions are provided in this repository README.

Citation

When using this dataset, please provide the following citation:

Leiva, F., Ellers, J., Berg, M. P., Cuxart-Erruz, R., Barneche, D., Blackburn, T., Castañeda, L. E., Chown, S., Gaitán-Espitia, J. D., Gebauer Mery, P. H., Gomez Isaza, D., Hardy, I., Hermaniuk, A., Hirst, A., Jorissen, S., Keasar, T., Koene, J. M., Le Lann, C., Martorelli, I., Molinet C., Niklitschek E.J., Oliveira B., Olivier B., Orizaola G., Pilakouta N., Shameer K.S., Shokri M., Stoks R., Tougeron K., Tuni C., van de Pol I.L.E., van Dis N.E., Visser B., Vogels J., White C.R., Wu N., and Verberk W. (2025). ShareTrait: a data portal for making trait data interoperable and reusable (version 1.2.0) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14826294

For further information, please contact: i.martorelli@vu.nl

Files

README.md

Files (34.2 MB)

Name Size Download all
md5:3243543fe0f7c928218932730f362d5e
10.4 kB Download
md5:8f733e1b120fa38c27d459b0befb5b5d
16.8 MB Preview Download
md5:dee3bb7dd83af5a7b6c7542ba7465aa3
13.7 kB Preview Download
md5:d9e7c361dc65d831a91f3cd11ff7e6d2
17.3 MB Download
md5:2ac917177d76873b67ef6d70fdbcb712
5.2 kB Preview Download

Additional details

Related works

Is supplement to
Dataset: https://github.com/ShareTraitProject (URL)

Software

Development Status
Active