Multiphase circumgalactic medium probed with MUSE and ALMA