Non-Fickian particle diffusion in confined plasmas and the transition from diffusive transport to density waves propagation