ShareTraitDatabase

Dataset / Software

Description

ShareTraitDatabase v1.0.0

The ShareTrait DataBase (STDB) SQL – version 1.0.0 includes the database schema, database tables, queries, and scripts needed to set up the ShareTrait database locally. This Zenodo publication represents the first public release of the ShareTrait Database (STDB), version 1.0.0, published on July 28, 2025.

General publication information

GitHub repository name: ShareTraitDatabase Zenodo release version 1.0.0 DOIPublished on: 2025-07-28

General repository version overview

The ShareTrait Database (STDB) is a structured SQL-based database designed to store structured information and retrieve trait-based biological data obtained from ShareTrait: a data portal for making trait data interoperable and reusable (DOI). This release includes the relational schema, organised data tables, and supporting documentation to allow local setup and use of the database. In addition to the full documentation of the design and implementation, version 1.0.0 includes tools and content that facilitate direct data access, integration, and query sharetrait data. Please refer to the README.md files within each sub-folder for detailed guidance on file content and usage.

General repository structure

The sharetrait-database-v1 folder as referred in this release version, includes the following components:

- db-documentation/: Contains documentation, schema design, database component definitions, dictionaries, and mappings to the ShareTrait dataset. - db-export/:Provides the ShareTrait database in SQL format for version 1.0.0. - db-queries/:Includes example SQL queries based on biological research questions. - db-tables/:Contains CSV files with data values and mappings for importing into the ShareTrait tables. - db-publish/:Lists documentation and files used in publications linked to this database version. - db-tools/:Includes Python scripts for creating and interacting with the database. 

Access and usage of the DB and SQL files

Please follow the instructions provided in the repository’s documentation and the specific folders' README.md files.Start with the documentation found in the folders db-export/ and db-tools/ for database setup.

SupportFor any questions about ShareTraitDataBase v1.0.0, you can contact Irene ([email protected])For additional updates, visit the GitHub repository: https://github.com/ShareTraitProject/ShareTraitDatabase 

Extra information

The SharetraitDatabase repository is part of ShareTraitProject (https://github.com/ShareTraitProject)

If you use this software, please cite it using the information provided in this metadata.
Date made available28 Jul 2025
PublisherZenodo

Keywords

  • database
  • data integration
  • trait
  • standards
  • measurement
  • experiment
  • organism
  • species
  • population
  • observation

Cite this