This table provides the mapping between AHF halos from a simulation including gas and star formation with its corresponding dark matter only simulation. The match is performed based on the particleIds in each halo, using the AHF merger tree code. Since the mapping was done from halos in the gas simulation to halos in the dm simulation, it can happen that dm-haloIds occur multiple times.
|ahfId_Gas||bigint||meta.id; meta.main||unique id for AHF halo in AHF table of corresponding simulation with gas and star formation|
|ahfId_DM||bigint||meta.id; meta.main||unique id for AHF halo in AHF table of corresponding simulation with dark matter only|
Match the most massive halos at redshift 0 from the Clues3_LGGas simulation with its counterparts in the Clues3_LGDM simulation:
SELECT * FROM Clues3_LGGas.AHFMatch as m, Clues3_LGGas.AHF as gas, Clues3_LGDM.AHF as dm WHERE m.ahfId_Gas = gas.ahfId AND m.ahfId_DM = dm.ahfId ORDER BY gas.Mvir DESC LIMIT 10
This query joins the corresponding AHF tables with the AHFMatch table to extract the properties of corresponding halos.