Display data from paper

Reference: [CM91]

Download as: Table (CSV)
View as list of objects

Detection table from CM91

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	Source name	Other name	Frequency	V_peak	F_peak	List	Detection	Class	Dist. (parallax)	Ref.
	(J2000)	(J2000)	(deg.)	(deg.)				(MHz)	(km/s)	(Jy)		Yes/No		(kpc)
1	06 08 32.8	+20 39 16	189.7707	0.3377	G189.778+0.345	IRAS06055+2039	S252-A3	4750	10.0	1.000	QIA14	+H₂O -CH₃OH I +CH₃OH II +OH	SFR_MIXED		CM91
	06 08 32.8	+20 39 16	189.7707	0.3377	G189.778+0.345	IRAS06055+2039	IRAS06055+2039	4765	10.0	0.250	QIA14	+H₂O -CH₃OH I +CH₃OH II +OH	SFR_MIXED		CM91
3	17 47 19.6	-28 23 07	0.6652	-0.0337	G0.6667-0.0344	IRAS17441-2822	SGRB2	4765	60.0	1.400	QIA14	+H₂O +CH₃OH I +CH₃OH II -OH	SFR		CM91
	17 47 19.6	-28 23 07	0.6652	-0.0337	G0.6667-0.0344	IRAS17441-2822	SGRB2	4750	60.0	0.500	QIA14	+H₂O +CH₃OH I +CH₃OH II -OH	SFR		CM91
	17 47 19.6	-28 23 07	0.6652	-0.0337	G0.6667-0.0344	IRAS17441-2822	SGRB2	4660	60.0	1.400	QIA14	+H₂O +CH₃OH I +CH₃OH II -OH	SFR		CM91
6	18 10 29.7	-19 55 48	10.6258	-0.3870	G10.623-0.383	IRAS18075-1956	W31	4765	-1.0	0.400	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR_MIXED		CM91
7	19 10 12	+09 06 11	43.1633	0.0161	G43.167+0.011	IRAS19078+0901	W49N	4750	7.0	0.400	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR_MIXED		CM91
	19 10 12	+09 06 11	43.1633	0.0161	G43.167+0.011	IRAS19078+0901	W49N	4660	7.0	0.700	QIA14	+H₂O +CH₃OH I +CH₃OH II +OH	SFR_MIXED		CM91

DSS colored	2MASS colored	WISE colored
SDSS color	IRAC color I1,I2,I4	GLIMPSE 360
PACS color (70-160 um)	SPIRE color (250-500 um)	NVSS (1.4GHz)
ATLASGAL 870 um	ATLASGAL 870 um + Planck	Bolocam 1.1 mm
UKIDSS K Download UKIDSS K FITS	2MASS K Download 2MASS K FITS

select MAX(oh_data_all.ra_hms) as ra_hms,MAX(oh_data_all.dec_dms) as dec_dms,MAX(oh_data_all.source_name) as source_name,MAX(oh_data_all.ra) as ra,MAX(oh_data_all.dec) as dec,MAX(oh_data_all.l) as l,MAX(oh_data_all.b) as b,MAX(oh_data_all.grp) as grp,MAX(oh_data_all.other_name) as other_name,MAX(oh_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(oh_data_all.freq) as freq,MAX(oh_data_all.vrange) as vrange,MAX(oh_data_all.vpeak) as vpeak,MAX(oh_data_all.peak) as peak,MAX(oh_data_all.fwhm) as fwhm,MAX(oh_data_all.int) as int,MAX(oh_data_all.rms) as rms,MAX(oh_data_all.units) as units,MAX(oh_data_all.units_rms) as units_rms,MAX(oh_data_all.date_txt) as date_txt,MAX(oh_data_all.telescope_ref) as telescope_ref,MAX(oh_data_all.telescope_conf) as telescope_conf,MAX(oh_data_all.v_step) as v_step,MAX(oh_data_all.beam) as beam,MAX(oh_data_all.beam_maj) as beam_maj,MAX(oh_data_all.beam_min) as beam_min,MAX(oh_data_all.beam_pa) as beam_pa,MAX(oh_data_all.ref) as ref,MAX(oh_data_all.list_ref) as list_ref,MAX(oh_data_all.ascii) as ascii,MAX(oh_data_all.url) as url,MAX(oh_data_all.image) as image,MAX(oh_data_all.image2) as image2,MAX(oh_data_all.image3) as image3,MAX(oh_data_all.descr) as descr,MAX(oh_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(oh_data_all.dist) as dist,1 as dist_parallax,MAX(oh_data_all.date_txt) as date_txt,MAX(line_det) as line_det,MAX(type) as type,MAX(simbad_types_cat) as simbad_types_cat FROM oh_data_all  LEFT JOIN all_objects_withmet ON oh_data_all.grp=all_objects_withmet.group_name LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' LEFT JOIN transitions ON oh_data_all.line=transitions."Line"  WHERE ref ilike 'CM91' AND detected=true AND hide=false GROUP BY ref

select oh_data_all.ra_hms,oh_data_all.dec_dms,oh_data_all.source_name,oh_data_all.ra,oh_data_all.dec,oh_data_all.l,oh_data_all.b,oh_data_all.grp,oh_data_all.other_name,oh_data_all.other_desc,oh_data_all.thermal,oh_data_all.freq,oh_data_all.vrange,oh_data_all.vpeak,oh_data_all.peak,oh_data_all.fwhm,oh_data_all.int,oh_data_all.rms,oh_data_all.units,oh_data_all.units_rms,oh_data_all.date_txt,oh_data_all.telescope_ref,oh_data_all.telescope_conf,oh_data_all.v_step,oh_data_all.beam,oh_data_all.beam_maj,oh_data_all.beam_min,oh_data_all.beam_pa,oh_data_all.ref,oh_data_all.list_ref,oh_data_all.ascii,oh_data_all.url,oh_data_all.image,oh_data_all.image2,oh_data_all.image3,oh_data_all.descr,oh_data_all.id,oh_data_all.mjy_flag,oh_data_all.rms_mjy_flag,oh_data_all.dist,oh_data_all.dist_parallax,oh_data_all.date_txt,line_det,type,simbad_types_cat FROM oh_data_all   LEFT JOIN all_objects_withmet ON oh_data_all.grp=all_objects_withmet.group_name LEFT JOIN object_categories ON all_objects_withmet.group_name = object_categories.group_name_cat AND object_categories.tbl_cat = 'all_objects_withmet' LEFT JOIN transitions ON oh_data_all.line=transitions."Line"  WHERE ref ilike 'CM91' AND detected=true AND hide=false ORDER BY detected DESC,id

Display data from paper

Reference: [CM91]

View as list of objects

Detection table from CM91