Understanding the relationships between biodiversity and ecosystem functioning stands as a cornerstone in ecological research. Extensive evidence now underscores the profound impact of species loss on the stability and dynamics of ecosystem functions. However, it remains unclear whether the loss of genetic diversity within key species yield similar consequences. Here, we delve into the intricate relationship between species diversity, genetic diversity, and ecosystem functions across three trophic levels (primary producers, primary consumers, and secondary consumers) in natural aquatic ecosystems. Our investigation involves estimating species diversity and genome-wide diversity (gauged within three pivotal species) within each trophic level, evaluating seven key ecosystem functions, and analyzing the strength of the relationships between biodiversity and ecosystem functions (BEFs). We found that, overall, the absolute effect size of genetic diversity on ecosystem functions mirrors that of species diversity in natural ecosystems. We nonetheless unveil a striking dichotomy: while genetic diversity was positively correlated with various ecosystem functions, species diversity displays a negative correlation with these functions. These intriguing antagonist effects of species and genetic diversity persists across the three trophic levels (underscoring its systemic nature), but were apparent only when BEFs were assessed within trophic levels rather than across them. This study reveals the complexity of predicting the consequences of genetic and species diversity loss under natural conditions, and emphasizes the need for further mechanistic models integrating these two facets of biodiversity.