You asked
Is the 7artisans 6mm f 2 good in low light?
Here is what the site says about that.
From 7Artisans 6mm f/2: 7Artisans 6mm f/2: A prime lens by 7Artisans for APS-C cameras, 6mm f/2. Specs - Maker: 7Artisans - Focal length: 6mm (prime) - Maximum aperture: f/2 - Made for: APS-C sensors - Mounts: Sony E, Fujifilm X, Nikon Z, Canon RF, Micro Four Thirds - Stabilised: no - Autofocus: no, manual focus What it frames like - On APS-C (Sony E, Fujifilm X, Nikon Z): like 9mm on full frame; f/2 gives about ...
From Sony a6400: Sony a6400: A mirrorless camera by Sony with a 24.2-megapixel APS-C sensor, announced in 2019. Small and very quick to focus. There's no stabilisation in the body, so pick stabilised lenses for low light.
Quoted from this site's pages.