Examples

[OIII] wing velocity dispersion selection >300km/s

Retrieves the HES name, AGN [OIII] wing velocity dispersion, observed IFU data cube and high-level products maps for all targets with a velocity dispersion of the [OIII] 5007 wing in the AGN spectrum greater than 300 km/s

select agn.hes_name, agn.wing_sigma, ifu.observed, ifu.maps_full from cars_dr1.agn_parameters as agn, cars_dr1.ifu_observations as ifu where agn.target_id = ifu.target_id and agn.wing_sigma > 300

BPT line construction for CARS target ID 12

Reporting of BPT line ratios with proper cleaning of good data

select log(oiii5007_flux/hbeta_flux) as "log(oiii_hb)", log(nii6583_flux/halpha_flux) as "log(nii_ha)", distance from cars_dr1.ifu_datatable_unbinned where target_id=12 and (oiii5007_flux/oiii5007_flux_err)>3 and (nii6583_flux/nii6583_flux_err)>3 and (hbeta_flux/hbeta_flux_err)>3 and (halpha_flux/halpha_flux_err)>3 and (gas_vel_err<20) and (gas_fwhm_err<30)

BH mass in comparison to ENLR maximum size

Retrieves the target id, HES name, log BH mass, maximum size of the ENLR in kpc and the logarithm of it for all objects where the ENLR is measured and greater than 0.0

select agn.target_id, agn.hes_name, agn.log_bh_mass, host.enlr_max_kpc, log(host.enlr_max_kpc) as "log_enlr_max_kpc" from cars_dr1.agn_parameters as agn, cars_dr1.host_properties as host where agn.target_id = host.target_id and host.enlr_max_kpc > 0.0

Specific SFRs from the AGN decontaminated Halpha and IR-based measurements

Reports the stellar masses, Halpha-based SFRs after AGN-decontamination, and IR-based SFR from SED fitting to compute specific SFR from the sample

select hes_name, log_mass_star, log_mass_star_16, log_mass_star_84, sfr_ha_bpt, sfr_ha_bpt_16, sfr_ha_bpt_84, flag_ha_bpt_limit,  sfr_ir, sfr_ir_16, sfr_ir_84, flag_ir_limit, log(sfr_ha_bpt)-log_mass_star as "ssfr_ha", log(sfr_ir)-log_mass_star as "ssfr_ir" from cars_dr1.host_properties

Spectral Energy Distribution (SED) for target HE0040-1105

Collect integrated panchromatic photometry from the UV to FIR for a single target from the CARS database

select phot_band, phot_centwave, phot_flux, phot_flux_error, phot_flux_limit, log(phot_centwave) as "log_centwave", log(phot_flux) as "log_phot_flux" from cars_dr1.photometry where hes_name = 'HE0040-1105'

Retrieve AGN lumionsities from BLR and X-ray measurements

List the bolometric luminosity based on the Hbeta BLR component and the soft X-ray lumionsity

select tar.hes_name, tar.soft_x_flux, tar.lum_dist, agn.log_agn_lum, log(4*pi())+log(tar.soft_x_flux)-12+2*log(tar.lum_dist*3.086e24) as "log_soft_x_lum" from cars_dr1.targets as tar, cars_dr1.agn_parameters as agn where tar.target_id = agn.target_id