‘Omics workflow to link terrestrial and aquatic communities and their function