We present a comprehensive experimental investigation on flow mode transition and heat transport in confined liquid metal convection at a Prandtl number of
$ \textit{Pr} = 0.029$, using cylindrical convection cells with aspect ratios
$\varGamma = 1$,
$1/2$ and
$1/3$. Whenever comparable data are available, the present low-
$ \textit{Pr}$ results are compared with previous measurements in moderate-
$ \textit{Pr}$ water convection (Xi & Xia, Phys. Fluids vol. 20, 2008, p. 055104; Weiss & Ahlers, J. Fluid Mech. vol. 676, 2011, pp. 5–40). It is found that the single-roll mode (SRM) dominates in the
$\varGamma = 1$ and
$1/2$ cells, whereas the double-roll mode (DRM) prevails in the
$\varGamma = 1/3$ cell. The relative weight of the SRM increases with
$\varGamma$, while those of the DRM and the transition mode decrease. Focusing on the
$\varGamma = 1/3$ cell, three representative DRM–SRM–DRM transition routes are observed: one induced by cessations and two associated with azimuthal rotational reorganisation of the flow. Beyond the previously studied reversals of the SRM, the DRM can also reverse through either cessation or continuous azimuthal reorientation. In this strongly confined cell, the dominant DRM is asymmetric, consisting of a larger and stronger upper roll, and a smaller and weaker lower roll. These changes in flow organisation are also reflected in heat transport: the SRM transports heat slightly more efficiently than the DRM and the difference decreases with increasing Rayleigh number
$ \textit{Ra}$. For
$\varGamma = 1/2$, comparison with moderate-
$ \textit{Pr}$ water convection further suggests that this heat-transport difference depends weakly on
$ \textit{Pr}$, compared with its stronger dependence on
$ \textit{Ra}$. These results deepen the understanding of large-scale flow structures in turbulent thermal convection and provide useful data for modelling large-scale flows in turbulent convection.