Decoding the regulatory roles of non-coding RNAs in cellular metabolism and disease