Multiscale confining dynamics from holographic RG flows