Motivation: Here, we make available a second version of the BioTIME database, which compiles records of abundance estimates for species in sample events of ecological assemblages through time. The updated version expands version 1.0 of the database by doubling the number of studies and includes substantial additional curation to the taxonomic accuracy of the records, as well as the metadata. Moreover, we now provide an R package (BioTIMEr) to facilitate use of the database.Main Types of Variables Included: The database is composed of one main data table containing the abundance records and 11 metadata tables. The data are organised in a hierarchy of scales where 11,989,233 records are nested in 1,603,067 sample events, from 553,253 sampling locations, which are nested in 708 studies. A study is defined as a sampling methodology applied to an assemblage for a minimum of 2 years.Spatial Location and Grain: Sampling locations in BioTIME are distributed across the planet, including marine, terrestrial and freshwater realms. Spatial grain size and extent vary across studies depending on sampling methodology. We recommend gridding of sampling locations into areas of consistent size.Time Period and Grain: The earliest time series in BioTIME start in 1874, and the most recent records are from 2023. Temporal grain and duration vary across studies. We recommend doing sample‐level rarefaction to ensure consistent sampling effort through time before calculating any diversity metric.Major Taxa and Level of Measurement: The database includes any eukaryotic taxa, with a combined total of 56,400 taxa.Software Format: csv and. SQL.

The structure of fish assemblages in Neotropical rivers is influenced by a series of environmental, spatial and/or temporal factors, given that different species will occupy the habitats that present the most favourable conditions to their survival. The present study aims to identify the principal factors responsible for the structuring of the fish assemblages found in the middle Xingu River, examining the influence of environmental, spatial, and temporal factors, in addition to the presence of natural barriers (waterfalls). For this, data were collected every three months between July 2012 and April 2013, using gillnets of different sizes and meshes. In addition to biotic data, 17 environmental variables were measured. A total of 8,485 fish specimens were collected during the study, representing 188 species. Total dissolved solids, conductivity, total suspended matter, and dissolved oxygen concentrations were the variables that had the greatest influence on the characteristics of the fish fauna of the middle Xingu. Only the barriers and hydrological periods played a significant deterministic role, resulting in both longitudinal and lateral gradients. This emphasizes the role of the connectivity of the different habitats found within the study area in the structuring of its fish assemblages.