Patterns of fish biodiversity in border and non-border rivers of the Tumen River Basin, China
Data files
Jun 11, 2026 version files 109.23 KB
-
Abundance_and_Biomass.xlsx
17.81 KB
-
Diversity_index.xlsx
44.23 KB
-
Environmental_factor.xlsx
40.12 KB
-
README.md
7.07 KB
Abstract
Fish biodiversity in transboundary river systems is critical for regional ecosystem health, yet remains under pressure from varying degrees of human impact. This study examines fish diversity patterns in the Tumen River Basin, distinguishing ecological differences between its main stem and tributaries. Using species and functional diversity indices, we analyzed community structure and assessed environmental influences on biodiversity. Results indicate that the main stem, minimally disturbed by human activities, supports richer species composition and greater functional diversity, serving as an ecological refuge. In contrast, tributaries experience significant ecological pressure from agricultural runoff and urban activities, leading to reduced diversity and biotic homogenization. These findings underscore the importance of focused water quality management and habitat restoration to safeguard fish biodiversity. Our research provides a scientific foundation for conservation strategies tailored to the unique needs of border rivers, offering insights for transboundary ecological management.
Patterns of Fish Biodiversity in Border and Non–Border Rivers of the Tumen River Basin, China
Access this dataset on Dryad
This dataset supports the manuscript titled "Patterns of Fish Biodiversity in Border and Non–Border Rivers of the Tumen River Basin, China". It includes water environmental parameters, species-level fish abundance and biomass, and biodiversity indices collected from multiple sampling sites within the Tumen River Basin. The dataset can be used to explore relationships between environmental factors and fish community structure, as well as to calculate and interpret fish biodiversity metrics.
Description of the Data and File Structure
The dataset consists of three Excel files:
Environmental_factor.xlsx
Abundance_and_Biomass.xlsx
Diversity_index.xlsx
Environmental_factor.xlsx and Diversity_index.xlsx Excel file contains seven worksheets (tabs), corresponding to seven rivers within the Tumen River Basin:
| Worksheet (Tab) Name | River | Sampling Site Codes |
| Tumen River | Tumen River | T1, T2, T3, ... |
| Mijiang River | Mijiang River | M1, M2, M3, ... |
| Hunchun River | Hunchun River | H1, H2, H3, ... |
| Gaya River | Gaya River | G1, G2, G3, ... |
| Bulhathon River | Bulhathon River | B1, B2, B3, ... |
| Hailan River | Hailan River | L1, L2, L3, ... |
| Hongqi River | Hongqi River | Q1, Q2, Q3, ... |
Within each worksheet, rows represent individual sampling sites located along the corresponding river. Sampling site identifiers are provided in the variable Sample.
The same worksheet structure is used in all three Excel files.
1. Environmental_factor.xlsx
Description
Contains water environmental parameters measured at each sampling site. These parameters describe the physical and chemical characteristics of river water at the time of sampling.
Variables
| Variable | Description | Unit |
| Sample | Sampling site identifier (e.g., T1, M1, H1) | N/A |
| T | Water temperature | °C |
| EC | Electrical conductivity | μS/cm |
| DO | Dissolved oxygen | mg/L |
| pH | Water pH value | unitless |
| TSS | Total suspended solids | mg/L |
| NH3-N | Ammonia nitrogen | mg/L |
| NO3-N | Nitrate nitrogen | mg/L |
| PO43− | Phosphate | mg/L |
| CODMn | Permanganate index | mg/L |
| TN | Total nitrogen | mg/L |
| TP | Total phosphorus | mg/L |
| Chl | Chlorophyll-a | μg/L |
Notes
Missing values are represented as NA.
2. Abundance_and_Biomass.xlsx
Description
Contains fish abundance and biomass data for each sampling site.
Variables
| Variable | Description | Unit |
| Sample | Sampling site identifier (e.g., T1, M1, H1) | N/A |
| Abundance | Total number of fish individuals recorded at the site | count |
| Biomass | Total fish biomass recorded at the site | g |
Notes
Missing values are represented as NA.
3. Diversity_index.xlsx
Description
Contains biodiversity indices calculated for each sampling site using the fish community data. These metrics include taxonomic diversity, and functional diversity indices, allowing comparisons of community composition and functional structure among rivers and sampling sites.
Variables
| Variable | Description |
| Sample | Sampling site identifier (e.g., T1, M1, H1) |
| shannon | Shannon–Wiener diversity index |
| Pielou | Pielou’s evenness index |
| Margalef | Margalef richness index |
| Simpson | Simpson diversity index |
| Taxsim | Taxonomic turnover component of beta diversity (βSIM) |
| Taxnes | Taxonomic nestedness component of beta diversity (βNES) |
| Taxsor | Overall taxonomic beta diversity based on Sørensen dissimilarity (βSOR) |
| FRic | Functional richness |
| FEve | Functional evenness |
| FDiv | Functional divergence |
| FRed | Functional redundancy |
| Funsim | Functional replacement component of beta diversity (βrepl) |
| Funnes | Functional richness difference component of beta diversity (βrich) |
| Funsor | Total functional beta diversity (βtotal) |
Notes
Missing values are represented as NA.
Relationships Between Files
Environmental_factor.xlsx provides environmental and water-quality information for each sampling site.
Abundance_and_Biomass.xlsx contains fish community abundance and biomass data collected from the same sampling sites.
Diversity_index.xlsx contains biodiversity metrics calculated from the fish community data, enabling comparisons of taxonomic and functional diversity among sites and rivers.
The three files are linked through the variable Sample, which uniquely identifies each sampling site.
Sharing / Access Information
The datasets are publicly available at Dryad: https://doi.org/10.5061/dryad.02v6wwqfk
Data was derived from sampling in the Tumen River Basin, China, and calculated following standard ecological and functional diversity methods.
Contact
For questions regarding the dataset, data processing procedures, or biodiversity metrics, please contact:
Wang Mi
Dalian Ocean University
Email: Wangmi1984dlou@163.com