The rare close projection of two quasars on the sky provides the opportunity to study the host galaxy environment of a foreground quasar in absorption against the continuum emission of a background quasar. For over a decade the "Quasars probing quasars" series has utilized this technique to further the understanding of galaxy formation and evolution in the presence of a quasar at z>2, resolving scales as small as a galactic disc and from bound gas in the circumgalactic medium to the diffuse environs of intergalactic space. Presented here, is the public release of the quasar pair spectral database utilized in these studies. In addition to projected pairs at z>2, the database also includes quasar pair members at z<2, gravitational lens candidates and quasars closely separated in redshift that are useful for small-scale clustering studies. In total the database catalogs 5627 distinct objects, with 4083 lying within 5' of at least one other source. A spectral library contains 3582 optical and near-infrared spectra for 3028 of the cataloged sources. As well as reporting on 54 newly discovered quasar pairs, we outline the key contributions made by this series over the last ten years, summarize the imaging and spectroscopic data used for target selection, discuss the target selection methodologies, describe the database content and explore some avenues for future work. Full documentation for the spectral database, including download instructions, are supplied at the following URL http://specdb.readthedocs.io/en/latest/

We present new results on the auto- and cross-correlation functions of galaxies and OVI absorbers in a $\sim 18~\textrm{Gpc}^3$ comoving volume at $z < 1$. We use a sample of 51,296 galaxies and 140 OVI absorbers in the column density range $13 \lesssim \log N \lesssim 15$ to measure two-point correlation functions in the two dimensions transverse and orthogonal to the line-of-sight $\xi(r_{\perp}, r_{\parallel})$. We furthermore infer the corresponding 'real-space' correlation functions, $\xi(r)$, by projecting $\xi(r_{\perp}, r_{\parallel})$ along $r_{\parallel}$, and assuming a power-law form, $\xi(r) = (r / r_0)^{-\gamma}$. Comparing the results from the absorber-galaxy cross-correlation function, $\xi_{\textrm{ag}}$, the galaxy auto-correlation function, $\xi_{\textrm{gg}}$, and the absorber auto-correlation function, $\xi_{\textrm{aa}}$, we constrain the statistical connection between galaxies and the metal-enriched intergalactic medium as a function of star-formation activity. We also compare these results to predictions from the EAGLE cosmological hydrodynamical simulation and find a reasonable agreement. We find that: (i) OVI absorbers show very little velocity dispersion with respect to galaxies on $\sim$ Mpc scales, likely $\lesssim$ 100 \kms; (ii) OVI absorbers and galaxies may not linearly trace the same underlying distribution of matter in general. In particular, our results demonstrate that OVI absorbers are less clustered, and potentially more extended around galaxies than galaxies are around themselves; (iii) On $\gtrsim 100$ kpc scales, the likelihood of finding OVI absorbers around star-forming galaxies is similar to the likelihood of finding OVI absorbers around non star-forming galaxies (abridged)