Choose a database in the left panel then select the table you want!
Table: desi_dr1.agnqso
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| agn_maskbits | AGN selection bitmask, see below for more details. | BIGINT |
| bgs_target | BGS (bright time program) target selection bitmask | BIGINT |
| civ_1549_flux | Gaussian-integrated emission-line flux | REAL |
| civ_1549_flux_ivar | Inverse variance of integrated flux | REAL |
| civ_1549_sigma | Gaussian emission-line width | REAL |
| cmx_target | Target selection bitmask for commissioning | BIGINT |
| coadd_exptime | Summed exposure time for coadd | REAL |
| coadd_fiberstatus | Bitwise-AND of input FIBERSTATUS | INTEGER |
| coadd_numexp | Number of exposures in coadd | SMALLINT |
| desi_target | DESI (dark time program) target selection bitmask | BIGINT |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| flux_ivar_w1 | Inverse variance of FLUX_W1 (AB) | REAL |
| flux_ivar_w2 | Inverse variance of FLUX_W2 (AB) | REAL |
| flux_ivar_w3 | Inverse variance of FLUX_W3 (AB) | REAL |
| flux_w1 | WISE flux in W1 (AB) | REAL |
| flux_w2 | WISE flux in W2 (AB) | REAL |
| flux_w3 | WISE flux in W3 (AB) | REAL |
| glat | Galactic latitude | DOUBLE |
| glon | Galactic longitude | DOUBLE |
| halpha_broad_flux | Gaussian-integrated emission-line flux | REAL |
| halpha_broad_flux_ivar | Inverse variance of integrated flux | REAL |
| halpha_broad_sigma | Gaussian emission-line width | REAL |
| halpha_broad_vshift | Velocity shift relative to Z | REAL |
| halpha_ew | Rest-frame emission-line equivalent width | REAL |
| halpha_ew_ivar | Inverse variance of equivalent width | REAL |
| halpha_flux | Gaussian-integrated emission-line flux | REAL |
| halpha_flux_ivar | Inverse variance of integrated flux | REAL |
| hbeta_broad_chi2 | Chi-squared of the line-fit | REAL |
| hbeta_broad_flux | Gaussian-integrated emission-line flux | REAL |
| hbeta_broad_flux_ivar | Inverse variance of integrated flux | REAL |
| hbeta_broad_sigma | Gaussian emission-line width | REAL |
| hbeta_ew | Rest-frame emission-line equivalent width | REAL |
| hbeta_ew_ivar | Inverse variance of equivalent width | REAL |
| hbeta_flux | Gaussian-integrated emission-line flux | REAL |
| hbeta_flux_ivar | Inverse variance of integrated flux | REAL |
| healpix | Healpix number | INTEGER |
| heii_4686_flux | Gaussian-integrated emission-line flux | REAL |
| heii_4686_flux_ivar | Inverse variance of integrated flux | REAL |
| htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
| ir_type | AGN detailed infrared type information, see below for more details. | BIGINT |
| logmstar | Logarithmic stellar mass (h=1.0, Chabrier+2003 initial mass function) | REAL |
| ls_id | Legacy Surveys DR9 identifier from RELEASE, OBJID, BRICKID | BIGINT |
| main_primary | Boolean flag (True/False) for the primary coadded spectrum in main survey | CHAR |
| max_mjd | MJD of the last exposure in coadded spectrum | DOUBLE |
| mean_mjd | Mean of MJD of exposures in a coadded spectrum | DOUBLE |
| mgii_2796_flux | Gaussian-integrated emission-line flux | REAL |
| mgii_2796_flux_ivar | Inverse variance of integrated flux | REAL |
| mgii_2796_sigma | Gaussian emission-line width | REAL |
| mgii_2803_flux | Gaussian-integrated emission-line flux | REAL |
| mgii_2803_flux_ivar | Inverse variance of integrated flux | REAL |
| mgii_2803_sigma | Gaussian emission-line width | REAL |
| min_mjd | MJD of the first exposure in coadded spectrum | DOUBLE |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
| nev_3426_flux | Gaussian-integrated emission-line flux | REAL |
| nev_3426_flux_ivar | Inverse variance of integrated flux | REAL |
| nii_6584_flux | Gaussian-integrated emission-line flux | REAL |
| nii_6584_flux_ivar | Inverse variance of integrated flux | REAL |
| oi_6300_flux | Gaussian-integrated emission-line flux | REAL |
| oi_6300_flux_ivar | Inverse variance of integrated flux | REAL |
| oii_3726_ew | Rest-frame emission-line equivalent width | REAL |
| oii_3726_ew_ivar | Inverse variance of equivalent width | REAL |
| oii_3726_flux | Gaussian-integrated emission-line flux | REAL |
| oii_3726_flux_ivar | Inverse variance of integrated flux | REAL |
| oii_3729_ew | Rest-frame emission-line equivalent width | REAL |
| oii_3729_ew_ivar | Inverse variance of equivalent width | REAL |
| oii_3729_flux | Gaussian-integrated emission-line flux | REAL |
| oii_3729_flux_ivar | Inverse variance of integrated flux | REAL |
| oiii_5007_flux | Gaussian-integrated emission-line flux | REAL |
| oiii_5007_flux_ivar | Inverse variance of integrated flux | REAL |
| oiii_5007_sigma | Gaussian emission-line width | REAL |
| opt_uv_type | AGN detailed optical/ultraviolet type information, see below for more details. | BIGINT |
| program | DESI program type - BRIGHT, DARK, BACKUP, OTHER | VARCHAR |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| ring256 | HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size) | INTEGER |
| scnd_target | SCND (secondary program) target selection bitmask | BIGINT |
| sii_6716_flux | Gaussian-integrated emission-line flux | REAL |
| sii_6716_flux_ivar | Inverse variance of integrated flux | REAL |
| sii_6731_flux | Gaussian-integrated emission-line flux | REAL |
| sii_6731_flux_ivar | Inverse variance of integrated flux | REAL |
| spectype | Spectral type of Redrock best fit template (e.g. GALAXY, QSO, STAR) | VARCHAR |
| survey | Survey name | VARCHAR |
| sv1_bgs_target | BGS (bright time program) target selection bitmask for SV1 | BIGINT |
| sv1_desi_target | DESI (dark time program) target selection bitmask for SV1 | BIGINT |
| sv1_scnd_target | Secondary target selection bitmask for SV1 | BIGINT |
| sv2_bgs_target | BGS (bright time program) target selection bitmask for SV2 | BIGINT |
| sv2_desi_target | DESI (dark time program) target selection bitmask for SV2 | BIGINT |
| sv2_scnd_target | Secondary target selection bitmask for SV2 | BIGINT |
| sv3_bgs_target | BGS (bright time program) target selection bitmask for SV3 | BIGINT |
| sv3_desi_target | DESI (dark time program) target selection bitmask for SV3 | BIGINT |
| sv3_scnd_target | Secondary target selection bitmask for SV3 | BIGINT |
| sv_primary | Boolean flag (True/False) for the primary coadded spectrum in SV (SV1+2+3) | CHAR |
| target_dec | Declination in decimal degrees (J2000) | DOUBLE |
| target_ra | Right Ascension in decimal degrees (J2000) | DOUBLE |
| targetid | Unique identifier for each object observed by DESI | BIGINT |
| z | Redshift from the FastSpecFit catalog | DOUBLE |
| zcat_primary | Boolean flag (True/False) for the primary coadded spectrum in the zcatalog | CHAR |
| zerr | Redshift error | DOUBLE |
| zwarn | Warning flags (0 is good) | BIGINT |
