Increasing extent of periods of no flow in intermittent waterways promotes heterotrophy