Local_Universe.Galaxy_Bayes table

The Galaxy_Bayes table contains data on galaxies that were used to generate the group catalogue. Groups were found with Bayesian group finder based on marked/object point processes. Data on the corresponding groups/clusters are in the GalGroup_Bayes table. The group/cluster identification numbers, groupid, are independent from id numbers in the GalGroup_2MRS and GalGroup_Comb tables.

Table structure

ColumnTypeUCDUnitDescription
pgcidintmeta.id
meta.main
identification number in PGC (principal galaxy catalogue)
groupidintmeta.id.parentprimary group/cluster id in the GalGroup_Bayes table; may be different from icl1 due to the group membership refinement procedure
ngalintmeta.numberrichness (number of members) of the primary group/cluster the galaxy belongs to
groupdistdoublepos.distanceMpccomoving distance to the centre of the primary group/cluster the galaxy belongs to, calculated as an average over all galaxies within the group/cluster
zobsdoublesrc.redshiftobserved redshift (without the CMB correction)
zcmbdoublesrc.redshiftredshift, corrected to the CMB rest frame
zerrdoublestat.error
src.redshift
error of the observed redshift
distdoublepos.distanceMpccomoving distance (calculated directly from the CMB-corrected redshift)
raj2000doublepos.eq.radegright ascension
dej2000doublepos.eq.decdegdeclination
glondoublepos.galactic.londeggalactic longitude
glatdoublepos.galactic.latdeggalactic latitude
sglondoublepos.supergalactic.londegsupergalactic longitude
sglatdoublepos.supergalactic.latdegsupergalactic latitude
x_sgdoublepos.cartesian.xMpcsupergalactic Cartesian coordinate along the x-axis, based on dist_cor (fingers of god are suppressed)
y_sgdoublepos.cartesian.yMpcsupergalactic Cartesian coordinate along the y-axis, based on dist_cor (fingers of god are suppressed)
z_sgdoublepos.cartesian.zMpcsupergalactic Cartesian coordinate along the z-axis, based on dist_cor (fingers of god are suppressed)
mag_ksfloatphot.mag
em.IR.K
magGalactic-extinction-corrected Ks magnitude as given in source catalogue
groupid_fofintmeta.id.parentgroup/cluster id in the FoF group catalogue (table GalGroup_2MRS)
ngal_fofintmeta.numberrichness (number of members) of the group/cluster the galaxy belongs to, based on the FoF group catalogue (table GalGroup_2MRS)
n_clintmeta.numbernumber of groups/clusters the galaxy is associated with
icl1intmeta.id.parentidentification number of the first group/cluster the galaxy is associated with (table GalGroup_Bayes)
icl2intmeta.id.parentidentification number of the second group/cluster the galaxy is associated with (table GalGroup_Bayes)
icl3intmeta.id.parentidentification number of the third group/cluster the galaxy is associated with (table GalGroup_Bayes)
icl4intmeta.id.parentidentification number of the fourth group/cluster the galaxy is associated with (table GalGroup_Bayes)
icl5intmeta.id.parentidentification number of the fifth group/cluster the galaxy is associated with (table GalGroup_Bayes)
p_fieldfloatstat.probabilityprobability that the galaxy is a field galaxy
p1floatstat.probabilityprobability that the galaxy belongs to the first group/cluster
p2floatstat.probabilityprobability that the galaxy belongs to the second group/cluster
p3floatstat.probabilityprobability that the galaxy belongs to the third group/cluster
p4floatstat.probabilityprobability that the galaxy belongs to the fourth group/cluster
p5floatstat.probabilityprobability that the galaxy belongs to the fifth group/cluster

Sample queries

  1. Select all columns for a specific galaxy, based on the ID number pgcid:
    SELECT * FROM Local_Universe.Galaxy_Bayes WHERE pgcid=176
  2. Select all galaxies that primarily belong to the galaxy group with the ID groupid of 5:
    SELECT * FROM Local_Universe.Galaxy_Bayes WHERE groupid=5
  3. Select all field galaxies (probability = 1):
    SELECT * FROM Local_Universe.Galaxy_Bayes WHERE p_field=1