Mining the sequential patterns of water quality preceding the biological status of waterbodies