The functional impact of rare variation across the regulatory cascade