This table contains galaxies in a lightcone mock catalogue based on the galaxy formation model of
Gonzalez-Perez et al.2014.
The lightcone was constructed using the technique described by
Merson et al. 2013.
This lightcone covers the whole sky. Only galaxies with redshift < 4.0 and with
emission line flux greater than 10-16erg/s/cm2 observed within the
wavelength range of the Euclid red-grism (1.25<λ/μ<1.8) are
included. The emission lines considered are Hα, Hβ, Hγ, OII
(3727A), OIII (4959A and 5007A), NII (6583A) and Ly-α. This in effect
limits the redshift range of the lightcone to 0.9
Note: This lightcone is very large (222,936,461 entries). Most basic queries
will fail in the browser mode, unless the query is carefully designed. As
the lightcone has been constructed from the Millennium-WMAP7 simulation
galaxies are frequently repeated (up to several hundred times).
The galaxy catalogue used to construct this lightcone is in the table EUCLID_v1..GAL_Gonzalez2014a.
This table is referred to as EUCLID_v1..LC_ALLSKY_SPEC_Gonzalez2014a in SQL queries. For example, to retrieve all properties
for the first 10 galaxies in the table:
select top 10 * from EUCLID_v1..LC_ALLSKY_SPEC_Gonzalez2014a
| column | type | UCD | unit | description |
|---|
| UniqueGalaxyID |
string |
|
- |
Unique identifier for this periodic replication of this galaxy
|
| GalaxyID |
long |
|
- |
ID of this galaxy. Each galaxy may appear more than once due to periodic replication
|
| redshift_cos |
float |
|
- |
cosmological redshift of galaxy
|
| redshift_obs |
float |
|
- |
observed redshift of galaxy (peculiar velocities included)
|
| bulgemass |
float |
|
Msol/h |
stellar mass in bulge of galaxy
|
| diskstellarmass |
float |
|
Msol/h |
stellar mass in disk of galaxy
|
| coldgas |
float |
|
Msol/h |
mass of cold gas in disk of galaxy
|
| vdisk |
float |
|
km/s |
circular velocity of the disk at the half mass radius
|
| rdisk |
float |
|
Mpc/h |
half-mass radius of disk
|
| sfr |
float |
|
Msol/h/Gyr |
(instantaneous) quiescent SFR in disk
|
| sfr_burst |
float |
|
Msol/h/Gyr |
SFR in bursts
|
| BoT |
float |
|
- |
bulge-to-total stellar mass ratio (ratio of bulge stellar mass and total stellar mass )
|
| blackholemass |
float |
|
Msol/h |
mass of the central black hole
|
| bh_last_accretion |
float |
|
Msol/h |
mass accreted onto the black hole in the most recent accretion event
|
| angmom_disk |
float |
|
Mpc/h km/s |
specific angular momentum of disk of galaxy
|
| angmom_dm |
float |
|
Mpc/h km/s |
specific angular momentum of the dark matter
|
| is_central |
int |
|
- |
is the galaxy a central or a satellite galaxy in its DM halo (1 = central, 0 = satellite)
|
| coldgas_atomic |
float |
|
Msol/h |
mass of atomic hydrogen gas in the disk of the galaxy
|
| coldgas_atomic_bulge |
float |
|
Msol/h |
mass of atomic hydrogen gas in the bulge of the galaxy
|
| coldgas_burst |
float |
|
Msol/h |
mass of cold gas remaining in ongoing bursts
|
| coldgas_mol |
float |
|
Msol/h |
mass of molecular H2 in the disk
|
| coldgas_mol_bulge |
float |
|
Msol/h |
mass of H2 in the bulge
|
| stellarmass |
float |
|
Msol/h |
total stellar mass of galaxy
|
| rbulge |
float |
|
Mpc/h |
half-mass radius of bulge
|
| specfeatures |
int |
|
- |
bitmap identifier of which spectral features considered in the lightcone construction are within the spectral range of the spectrograph given the redshift of the galaxy. The spectral features considered are listed in the parameter "features_name".
|
| spin |
float |
|
- |
halo spin parameter
|
| tburst |
float |
|
Gyr |
lookback time to last burst of star formation (set to 100000 if no burst has yet occured)
|
| vbulge |
float |
|
km/s |
velocity dispersion of the bulge at the half mass radius
|
| vchalo |
float |
|
km/s |
circular velocity of the parent halo at the output time for a central galaxy and circular velocity of the satellite's parent halo just before infall
|
| metalsBulgeMass |
float |
|
- |
metallicity of stars in the bulge (ratio of mass of metals in bulge stars and bulge stellar mass)
|
| metalsDiskMass |
float |
|
- |
metallicity of stars in the disk (ratio of mass of metals in disk stars and disk stellar mass)
|
| metalsStellarMass |
float |
|
- |
metallicity of stars (ratio of mass of metals in stars and total stellar mass)
|
| mdhalo |
float |
|
Msol/h |
mass of the host halo (DHalo Mass)
|
| UniqueDHaloID |
string |
|
- |
Unique identifier for this periodic replication of this halo
|
| DHaloID |
long |
|
- |
ID of this dark matter halo. Each halo may appear more than once due to periodic replication
|
| ra |
double |
|
degrees |
right ascension of galaxy
|
| dec |
double |
|
degrees |
declination of galaxy
|
| x |
float |
|
Mpc/h |
Cartesian comoving x coordinate of this galaxy relative to the observer
|
| y |
float |
|
Mpc/h |
Cartesian comoving y coordinate of this galaxy relative to the observer
|
| z |
float |
|
Mpc/h |
Cartesian comoving z coordinate of this galaxy relative to the observer
|
| r |
float |
|
Mpc/h |
comoving distance between observer and galaxy
|
| velx |
float |
|
km/s |
Cartesian x component of peculiar velocity of this galaxy in physical units
|
| vely |
float |
|
km/s |
Cartesian y component of peculiar velocity of this galaxy in physical units
|
| velz |
float |
|
km/s |
Cartesian z component of peculiar velocity of this galaxy in physical units
|
| BCDM |
float |
|
- |
Band Corrected Distance Modulus = 5 log10(dL/h-1Mpc) + 25 - 2.5 log10(1+zcos)
|
| ipixel |
int |
|
- |
Pixel index
|
| mag_B_obs_app |
float |
|
- |
RGO B-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_B_rest_abs |
float |
|
- |
RGO B-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_V_obs_app |
float |
|
- |
RGO V-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_V_rest_abs |
float |
|
- |
RGO V-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_R_obs_app |
float |
|
- |
RGO R-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_R_rest_abs |
float |
|
- |
RGO R-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_J_obs_app |
float |
|
- |
UKIRT J-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_J_rest_abs |
float |
|
- |
UKIRT J-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_H_obs_app |
float |
|
- |
UKIRT H-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_H_rest_abs |
float |
|
- |
UKIRT H-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_Ks_obs_app |
float |
|
- |
UKIRT Ks-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_Ks_rest_abs |
float |
|
- |
UKIRT Ks-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_K_obs_app |
float |
|
- |
UKIRT K-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_K_rest_abs |
float |
|
- |
UKIRT K-filter rest frame absolute magnitude (AB) including dust extinction
|
| mag_L_obs_app |
float |
|
- |
UKIRT L-filter observed frame apparent magnitude (AB) including dust extinction
|
| mag_L_rest_abs |
float |
|
- |
UKIRT L-filter rest frame absolute magnitude (AB) including dust extinction
|
| SDSS_u_obs_app |
float |
|
- |
SDSS u-filter observed frame apparent magnitude (AB) including dust extinction
|
| SDSS_u_rest_abs |
float |
|
- |
SDSS u-filter rest frame absolute magnitude (AB) including dust extinction
|
| SDSS_g_obs_app |
float |
|
- |
SDSS g-filter observed frame apparent magnitude (AB) including dust extinction
|
| SDSS_g_rest_abs |
float |
|
- |
SDSS g-filter rest frame absolute magnitude (AB) including dust extinction
|
| SDSS_r_obs_app |
float |
|
- |
SDSS r-filter observed frame apparent magnitude (AB) including dust extinction
|
| SDSS_r_rest_abs |
float |
|
- |
SDSS r-filter rest frame absolute magnitude (AB) including dust extinction
|
| SDSS_i_obs_app |
float |
|
- |
SDSS i-filter observed frame apparent magnitude (AB) including dust extinction
|
| SDSS_i_rest_abs |
float |
|
- |
SDSS i-filter rest frame absolute magnitude (AB) including dust extinction
|
| SDSS_z_obs_app |
float |
|
- |
SDSS z-filter observed frame apparent magnitude (AB) including dust extinction
|
| SDSS_z_rest_abs |
float |
|
- |
SDSS z-filter rest frame absolute magnitude (AB) including dust extinction
|
| DES_g_obs_app |
float |
|
- |
DECam g-filter observed frame apparent magnitude (AB) including dust extinction
|
| DES_g_rest_abs |
float |
|
- |
DECam g-filter rest frame absolute magnitude (AB) including dust extinction
|
| DES_r_obs_app |
float |
|
- |
DECam r-filter observed frame apparent magnitude (AB) including dust extinction
|
| DES_r_rest_abs |
float |
|
- |
DECam r-filter rest frame absolute magnitude (AB) including dust extinction
|
| DES_i_obs_app |
float |
|
- |
DECam i-filter observed frame apparent magnitude (AB) including dust extinction
|
| DES_i_rest_abs |
float |
|
- |
DECam i-filter rest frame absolute magnitude (AB) including dust extinction
|
| DES_z_obs_app |
float |
|
- |
DECam z-filter observed frame apparent magnitude (AB) including dust extinction
|
| DES_z_rest_abs |
float |
|
- |
DECam z-filter rest frame absolute magnitude (AB) including dust extinction
|
| DES_Y_obs_app |
float |
|
- |
DECam Y-filter observed frame apparent magnitude (AB) including dust extinction
|
| DES_Y_rest_abs |
float |
|
- |
DECam Y-filter rest frame absolute magnitude (AB) including dust extinction
|
| EUCLID_Y_obs_app |
float |
|
- |
EUCLID Y-filter observed frame apparent magnitude (AB) including dust extinction
|
| EUCLID_Y_rest_abs |
float |
|
- |
EUCLID Y-filter rest frame absolute magnitude (AB) including dust extinction
|
| EUCLID_J_obs_app |
float |
|
- |
EUCLID J-filter observed frame apparent magnitude (AB) including dust extinction
|
| EUCLID_J_rest_abs |
float |
|
- |
EUCLID J-filter rest frame absolute magnitude (AB) including dust extinction
|
| EUCLID_Hp_obs_app |
float |
|
- |
EUCLID Hp-filter observed frame apparent magnitude (AB) including dust extinction
|
| EUCLID_Hp_rest_abs |
float |
|
- |
EUCLID Hp-filter rest frame absolute magnitude (AB) including dust extinction
|
| EUCLID_K_obs_app |
float |
|
- |
EUCLID K-filter observed frame apparent magnitude (AB) including dust extinction
|
| EUCLID_K_rest_abs |
float |
|
- |
EUCLID K-filter rest frame absolute magnitude (AB) including dust extinction
|
| PanSTARRS_w_obs_app |
float |
|
- |
PanSTARRS w-filter observed frame apparent magnitude (AB) including dust extinction
|
| PanSTARRS_w_rest_abs |
float |
|
- |
PanSTARRS w-filter rest frame absolute magnitude (AB) including dust extinction
|
| PanSTARRS_y_obs_app |
float |
|
- |
PanSTARRS y-filter observed frame apparent magnitude (AB) including dust extinction
|
| PanSTARRS_y_rest_abs |
float |
|
- |
PanSTARRS y-filter rest frame absolute magnitude (AB) including dust extinction
|
| GALEX_FUV_rest_abs |
float |
|
- |
GALEX FUV rest frame absolute magnitude (AB) including dust extinction
|
| GALEX_NUV_rest_abs |
float |
|
- |
GALEX NUV rest frame absolute magnitude (AB) including dust extinction
|
| IRAC_36_obs_app |
float |
|
- |
Spitzer-IRAC 3.6 micron observed frame apparent magnitude (AB) including dust extinction
|
| IRAC_36_rest_abs |
float |
|
- |
Spitzer-IRAC 3.6 micron rest frame absolute magnitude (AB) including dust extinction
|
| IRAC_45_obs_app |
float |
|
- |
Spitzer-IRAC 4.5 micron observed frame apparent magnitude (AB) including dust extinction
|
| IRAC_45_rest_abs |
float |
|
- |
Spitzer-IRAC 4.5 micron rest frame absolute magnitude (AB) including dust extinction
|
| IRAC_58_obs_app |
float |
|
- |
Spitzer-IRAC 5.8 micron observed frame apparent magnitude (AB) including dust extinction
|
| IRAC_58_rest_abs |
float |
|
- |
Spitzer-IRAC 5.8 micron rest frame absolute magnitude (AB) including dust extinction
|
| IRAC_80_obs_app |
float |
|
- |
Spitzer-IRAC 8.0 micron observed frame apparent magnitude (AB) including dust extinction
|
| IRAC_80_rest_abs |
float |
|
- |
Spitzer-IRAC 8.0 micron rest frame absolute magnitude (AB) including dust extinction
|
| MUSYC_I_obs_app |
float |
|
- |
MUSYC I-filter observed frame apparent magnitude (AB) including dust extinction
|
| MUSYC_I_rest_abs |
float |
|
- |
MUSYC I-filter rest frame absolute magnitude (AB) including dust extinction
|
| L_Lyalpha |
float |
|
erg/s/cm2 |
Line flux for the Lyalpha line without dust extinction
|
| L_Lyalpha_ext |
float |
|
erg/s/cm2 |
Line flux for the Lyalpha line with dust extinction
|
| L_OII3727 |
float |
|
erg/s/cm2 |
Line flux for the OII3727 line without dust extinction
|
| L_OII3727_ext |
float |
|
erg/s/cm2 |
Line flux for the OII3727 line with dust extinction
|
| L_Hgamma |
float |
|
erg/s/cm2 |
Line flux for the Hgamma line without dust extinction
|
| L_Hgamma_ext |
float |
|
erg/s/cm2 |
Line flux for the Hgamma line with dust extinction
|
| L_Hbeta |
float |
|
erg/s/cm2 |
Line flux for the Hbeta line without dust extinction
|
| L_Hbeta_ext |
float |
|
erg/s/cm2 |
Line flux for the Hbeta line with dust extinction
|
| L_OIII4959 |
float |
|
erg/s/cm2 |
Line flux for the OIII4959 line without dust extinction
|
| L_OIII4959_ext |
float |
|
erg/s/cm2 |
Line flux for the OIII4959 line with dust extinction
|
| L_OIII5007 |
float |
|
erg/s/cm2 |
Line flux for the OIII5007 line without dust extinction
|
| L_OIII5007_ext |
float |
|
erg/s/cm2 |
Line flux for the OIII5007 line with dust extinction
|
| L_Halpha |
float |
|
erg/s/cm2 |
Line flux for the Halpha line without dust extinction
|
| L_Halpha_ext |
float |
|
erg/s/cm2 |
Line flux for the Halpha line with dust extinction
|
| L_NII6583 |
float |
|
erg/s/cm2 |
Line flux for the NII6583 line without dust extinction
|
| L_NII6583_ext |
float |
|
erg/s/cm2 |
Line flux for the NII6583 line with dust extinction
|
| EWBulge_Lyalpha |
float |
|
Angstrom |
Equivalent width of the Lyalpha line (bulge only) without dust extinction
|
| EWBulge_Lyalpha_ext |
float |
|
Angstrom |
Equivalent width of the Lyalpha line (bulge only) with dust extinction
|
| EWDisk_Lyalpha |
float |
|
Angstrom |
Equivalent width of the Lyalpha line (disk only) without dust extinction
|
| EWDisk_Lyalpha_ext |
float |
|
Angstrom |
Equivalent width of the Lyalpha line (disk only) with dust extinction
|
| EW_Lyalpha |
float |
|
Angstrom |
Equivalent width of the Lyalpha line without dust extinction
|
| EW_Lyalpha_ext |
float |
|
Angstrom |
Equivalent width of the Lyalpha line with dust extinction
|
| EWBulge_OII3727 |
float |
|
Angstrom |
Equivalent width of the OII3727 line (bulge only) without dust extinction
|
| EWBulge_OII3727_ext |
float |
|
Angstrom |
Equivalent width of the OII3727 line (bulge only) with dust extinction
|
| EWDisk_OII3727 |
float |
|
Angstrom |
Equivalent width of the OII3727 line (disk only) without dust extinction
|
| EWDisk_OII3727_ext |
float |
|
Angstrom |
Equivalent width of the OII3727 line (disk only) with dust extinction
|
| EW_OII3727 |
float |
|
Angstrom |
Equivalent width of the OII3727 line without dust extinction
|
| EW_OII3727_ext |
float |
|
Angstrom |
Equivalent width of the OII3727 line with dust extinction
|
| EWBulge_Hgamma |
float |
|
Angstrom |
Equivalent width of the Hgamma line (bulge only) without dust extinction
|
| EWBulge_Hgamma_ext |
float |
|
Angstrom |
Equivalent width of the Hgamma line (bulge only) with dust extinction
|
| EWDisk_Hgamma |
float |
|
Angstrom |
Equivalent width of the Hgamma line (disk only) without dust extinction
|
| EWDisk_Hgamma_ext |
float |
|
Angstrom |
Equivalent width of the Hgamma line (disk only) with dust extinction
|
| EW_Hgamma |
float |
|
Angstrom |
Equivalent width of the Hgamma line without dust extinction
|
| EW_Hgamma_ext |
float |
|
Angstrom |
Equivalent width of the Hgamma line with dust extinction
|
| EWBulge_Hbeta |
float |
|
Angstrom |
Equivalent width of the Hbeta line (bulge only) without dust extinction
|
| EWBulge_Hbeta_ext |
float |
|
Angstrom |
Equivalent width of the Hbeta line (bulge only) with dust extinction
|
| EWDisk_Hbeta |
float |
|
Angstrom |
Equivalent width of the Hbeta line (disk only) without dust extinction
|
| EWDisk_Hbeta_ext |
float |
|
Angstrom |
Equivalent width of the Hbeta line (disk only) with dust extinction
|
| EW_Hbeta |
float |
|
Angstrom |
Equivalent width of the Hbeta line without dust extinction
|
| EW_Hbeta_ext |
float |
|
Angstrom |
Equivalent width of the Hbeta line with dust extinction
|
| EWBulge_OIII4959 |
float |
|
Angstrom |
Equivalent width of the OIII4959 line (bulge only) without dust extinction
|
| EWBulge_OIII4959_ext |
float |
|
Angstrom |
Equivalent width of the OIII4959 line (bulge only) with dust extinction
|
| EWDisk_OIII4959 |
float |
|
Angstrom |
Equivalent width of the OIII4959 line (disk only) without dust extinction
|
| EWDisk_OIII4959_ext |
float |
|
Angstrom |
Equivalent width of the OIII4959 line (disk only) with dust extinction
|
| EW_OIII4959 |
float |
|
Angstrom |
Equivalent width of the OIII4959 line without dust extinction
|
| EW_OIII4959_ext |
float |
|
Angstrom |
Equivalent width of the OIII4959 line with dust extinction
|
| EWBulge_OIII5007 |
float |
|
Angstrom |
Equivalent width of the OIII5007 line (bulge only) without dust extinction
|
| EWBulge_OIII5007_ext |
float |
|
Angstrom |
Equivalent width of the OIII5007 line (bulge only) with dust extinction
|
| EWDisk_OIII5007 |
float |
|
Angstrom |
Equivalent width of the OIII5007 line (disk only) without dust extinction
|
| EWDisk_OIII5007_ext |
float |
|
Angstrom |
Equivalent width of the OIII5007 line (disk only) with dust extinction
|
| EW_OIII5007 |
float |
|
Angstrom |
Equivalent width of the OIII5007 line without dust extinction
|
| EW_OIII5007_ext |
float |
|
Angstrom |
Equivalent width of the OIII5007 line with dust extinction
|
| EWBulge_Halpha |
float |
|
Angstrom |
Equivalent width of the Halpha line (bulge only) without dust extinction
|
| EWBulge_Halpha_ext |
float |
|
Angstrom |
Equivalent width of the Halpha line (bulge only) with dust extinction
|
| EWDisk_Halpha |
float |
|
Angstrom |
Equivalent width of the Halpha line (disk only) without dust extinction
|
| EWDisk_Halpha_ext |
float |
|
Angstrom |
Equivalent width of the Halpha line (disk only) with dust extinction
|
| EW_Halpha |
float |
|
Angstrom |
Equivalent width of the Halpha line without dust extinction
|
| EW_Halpha_ext |
float |
|
Angstrom |
Equivalent width of the Halpha line with dust extinction
|
| EWBulge_NII6583 |
float |
|
Angstrom |
Equivalent width of the NII6583 line (bulge only) without dust extinction
|
| EWBulge_NII6583_ext |
float |
|
Angstrom |
Equivalent width of the NII6583 line (bulge only) with dust extinction
|
| EWDisk_NII6583 |
float |
|
Angstrom |
Equivalent width of the NII6583 line (disk only) without dust extinction
|
| EWDisk_NII6583_ext |
float |
|
Angstrom |
Equivalent width of the NII6583 line (disk only) with dust extinction
|
| EW_NII6583 |
float |
|
Angstrom |
Equivalent width of the NII6583 line without dust extinction
|
| EW_NII6583_ext |
float |
|
Angstrom |
Equivalent width of the NII6583 line with dust extinction
|
