The ESO UVES advanced data products quasar sample – VI. Sub-damped Lyman α metallicity measurements and the circumgalactic medium