Structure–property relationships of water adsorption in metal–organic frameworks