Display data from paper

Reference: [BOB04]

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

Detection table from BOB04

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	Source name	V_range	V_peak	F_peak	List	Detection	Class	Dist. (parallax)	Ref.
	(J2000)	(J2000)	(deg.)	(deg.)			(km/s)	(km/s)	(Jy)		Yes/No		(kpc)
1	01 06 26	+12 35 53	128.6417	-50.1074	G128.642-50.107	*IRC +10011	0.00	10.7	298	ENG_SIO	+H₂O +OH +SiO	EVOLVED		BOB04
2	02 19 20.8	-02 58 39.5	167.7550	-57.9827	G167.754-57.983	*o Ceti	0.00	44.3	617.6	ENG_SIO	+H₂O -OH +SiO	EVOLVED		BOB04
3	13 49 02	-28 22 3.5	318.0223	32.8108	G318.022+32.811	W Hya	0.00	40.7	551.1	ENG_SIO	+H₂O +OH +SiO	EVOLVED		BOB04
4	14 24 11.6	+25 42 13.4	34.2773	69.2127	G34.278+69.213	*RX Boo	0.00	0.3	20.1	ENG_SIO	+H₂O -CH₃OH I +OH +SiO	EVOLVED		BOB04
5	19 50 33.9	+32 54 50.6	68.5387	3.2762	G68.539+3.276	*chi Cyg	0.00	9.7	19.25	ENG_SIO	-H₂O -OH +SiO	EVOLVED		BOB04
6	20 46 25.5	+40 06 59.4	80.7984	-1.9210	G80.798-1.921	*NML Cyg	0.00	-15.2	12.25	ENG_SIO	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED		BOB04
7	23 58 24.9	+51 23 19.7	114.5608	-10.6191	G114.561-10.619	*R Cas	0.00	25.4	475.9	ENG_SIO	+H₂O +OH +SiO	EVOLVED		BOB04

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(sio_data_all.ra_hms) as ra_hms,MAX(sio_data_all.dec_dms) as dec_dms,MAX(sio_data_all.source_name) as source_name,MAX(sio_data_all.ra) as ra,MAX(sio_data_all.dec) as dec,MAX(sio_data_all.l) as l,MAX(sio_data_all.b) as b,MAX(sio_data_all.grp) as grp,MAX(sio_data_all.other_name) as other_name,MAX(sio_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(sio_data_all.line) as line,MAX(sio_data_all.vrange) as vrange,MAX(sio_data_all.vpeak) as vpeak,MAX(sio_data_all.peak) as peak,MAX(sio_data_all.fwhm) as fwhm,MAX(sio_data_all.int) as int,MAX(sio_data_all.rms) as rms,MAX(sio_data_all.units) as units,MAX(sio_data_all.units_rms) as units_rms,MAX(sio_data_all.date_txt) as date_txt,MAX(sio_data_all.telescope_ref) as telescope_ref,MAX(sio_data_all.telescope_conf) as telescope_conf,MAX(sio_data_all.v_step) as v_step,MAX(sio_data_all.beam) as beam,MAX(sio_data_all.beam_maj) as beam_maj,MAX(sio_data_all.beam_min) as beam_min,MAX(sio_data_all.beam_pa) as beam_pa,MAX(sio_data_all.ref) as ref,MAX(sio_data_all.list_ref) as list_ref,MAX(sio_data_all.ascii) as ascii,MAX(sio_data_all.url) as url,MAX(sio_data_all.image) as image,MAX(sio_data_all.image2) as image2,MAX(sio_data_all.image3) as image3,MAX(sio_data_all.descr) as descr,MAX(sio_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(sio_data_all.dist) as dist,1 as dist_parallax,MAX(sio_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 sio_data_all  LEFT JOIN all_objects_withmet ON sio_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' WHERE ref ilike 'BOB04' AND detected=true AND hide=false GROUP BY ref

select sio_data_all.ra_hms,sio_data_all.dec_dms,sio_data_all.source_name,sio_data_all.ra,sio_data_all.dec,sio_data_all.l,sio_data_all.b,sio_data_all.grp,sio_data_all.other_name,sio_data_all.other_desc,sio_data_all.thermal,sio_data_all.line,sio_data_all.vrange,sio_data_all.vpeak,sio_data_all.peak,sio_data_all.fwhm,sio_data_all.int,sio_data_all.rms,sio_data_all.units,sio_data_all.units_rms,sio_data_all.date_txt,sio_data_all.telescope_ref,sio_data_all.telescope_conf,sio_data_all.v_step,sio_data_all.beam,sio_data_all.beam_maj,sio_data_all.beam_min,sio_data_all.beam_pa,sio_data_all.ref,sio_data_all.list_ref,sio_data_all.ascii,sio_data_all.url,sio_data_all.image,sio_data_all.image2,sio_data_all.image3,sio_data_all.descr,sio_data_all.id,sio_data_all.mjy_flag,sio_data_all.rms_mjy_flag,sio_data_all.dist,sio_data_all.dist_parallax,sio_data_all.date_txt,line_det,type,simbad_types_cat FROM sio_data_all   LEFT JOIN all_objects_withmet ON sio_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' WHERE ref ilike 'BOB04' AND detected=true AND hide=false ORDER BY detected DESC,id

Display data from paper

Reference: [BOB04]

View as list of objects

Detection table from BOB04