Self-consistent migration puts tight constraints on the spatio-temporal organization of species-rich metacommunities