Novel quantum phases and mesoscopic physics in quantum gases