Display data from paper

Select data type: ,

GOM14 - A sensitive search for methanol line emission toward evolved stars

Short title: Gomez et al. (2014)
Authors: Gómez, J. F. Uscanga, L. Suárez, O. Rizzo, J. R. de Gregorio-Monsalvo, I.
Journal: Revista Mexicana de Astronomía y Astrofísica Vol. 50, pp. 137-143 (2014)
Bibcode:
PDF:

Target type: pAGB_PN
Transitions: CH3OH_23.4(I),CH3OH_25-30_GHz(I),CH3OH_36(I),CH3OH_44(I),CH3OH_95(I),CH3OH_19(II)

Abstract

We present a sensitive search for methanol line emission in evolved stars at 1 cm, aiming to detect, for the first time, methanol masers in this type of objects. Our sample comprised post-AGB stars and young planetary nebulae (PNe), whose mass-loss processes and circumstellar structures resemble those of young stellar objects (YSOs), where methanol masers are detected. Class I masers were searched for in 73 objects, whereas Class II ones were searched in 16. No detection was obtained. The non-detection of Class I methanol masers indicated that methanol production in dust grains and/or the enhancement of its gas-phase abundance in the shocked regions of evolved objects are not as efficient as in YSOs. We suggest that relatively more evolved PNe might have a better probability of harboring Class II masers.

Target sources:
IRAS

Input tables: Table 1 and 2
Download as: Table (CSV)
View as list of objects

Detection table from Gomez et al. (2014)

Export table to csv

Hide / Show individual components

Non-detection table from Gomez et al. (2014)

Export table to csv

Hide / Show individual components

ID	Obs. RA	Obs. Dec	l	b	Group id	grpv	Source name	Line	Date	Telescope	RMS	Beam	Detection	Class	Date
	(J2000)	(J2000)	(deg.)	(deg.)				CH₃OH (class I)			(Jy)	(arcsec)	Yes/No
1	17 05 23.4	-31 13 18.4	353.2285	5.9337	G353.228+5.934	G353.2283+5.9341	17021-3109	24.933 GHz (I);	2010-03-21	GBT	0.040	30	+H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
2	17 05 24.2	-30 58 14.4	353.4324	6.0818	G353.432+6.082	G353.4320+6.0822	17021-3054	24.933 GHz (I);	2010-03-21	GBT	0.040	30	-H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
3	17 18 11.9	-30 56 40.8	355.0674	3.8747	G355.066+3.876	G355.0664+3.8764	17149-3053	24.933 GHz (I);	2010-03-03	GBT	0.040	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
4	17 20 42.6	-28 22 36.8	357.4953	4.8899	G357.495+4.890	G357.4951+4.8904	17175-2819	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
5	17 26 28.8	-26 04 57.8	0.1243	5.1117	G0.124+5.112	G0.1241+5.1119	17233-2602	24.933 GHz (I);	2010-03-21	GBT	0.030	30	-H₂O -CH₃OH I -CH₃OH II	EVOLVED	21.03.2010
6	17 32 10.2	-21 49 58.9	4.4155	6.3439	G4.415+6.344	G4.4153+6.3443	17291-2147	24.933 GHz (I);	2010-03-21	GBT	0.014	30	+H₂O -CH₃OH I -OH	EVOLVED	21.03.2010
7	17 33 14.2	-25 40 23.5	1.3028	4.0639	G1.302+4.064	G1.3024+4.0642	17301-2538	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I	EVOLVED	03.03.2010
8	17 38 4.3	-29 08 22.7	358.9562	1.2938	G358.957+1.296	G358.9567+1.2958	17348-2906	24.933 GHz (I);	2010-03-03	GBT	0.030	30	+H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
9	17 39 8.1	-29 04 6.1	359.1405	1.1354	G359.140+1.137	G359.1405+1.1372	17359-2902	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I	EVOLVED	03.03.2010
10	17 39 06	-21 43 51.8	5.3644	5.0376	G5.364+5.038	G5.3644+5.0377	17360-2142	24.933 GHz (I);	2010-03-01	GBT	0.021	30	-H₂O -CH₃OH I	EVOLVED	01.03.2010
11	17 41 20.2	-25 32 53.3	2.3861	2.5875	G2.386+2.588	G2.3860+2.5878	17382-2531	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
12	17 41 38.5	-24 14 40.9	3.5319	3.2155	G3.532+3.216	G3.5315+3.2160	17385-2413	24.933 GHz (I);	2010-03-01	GBT	0.020	30	-H₂O -CH₃OH I -CH₃OH II -OH	EVOLVED	01.03.2010
13	17 42 32.3	-27 28 28.2	0.8897	1.3439	G0.890+1.344	G0.8920+1.3418	17393-2727	24.933 GHz (I);	2010-03-03	GBT	0.030	30	+H₂O -CH₃OH I -CH₃OH II	EVOLVED	03.03.2010
14	17 43 37.3	-27 14 46.4	1.2103	1.2592	G1.212+1.257	G1.2103+1.2592	17404-2713	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
	17 43 37.3	-27 14 46.4	1.2103	1.2592	G1.212+1.257	G1.2103+1.2592	17404-2713	24.933 GHz (I);	2010-03-21	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
16	17 51 12.6	-30 33 44.5	359.2326	-1.8782	G359.233-1.878	G359.2327-1.8762	17479-3032	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I	EVOLVED	03.03.2010
17	17 51 22.6	-25 01 51.4	4.0070	0.9163	G4.007+0.915	G4.0071+0.9152	17482-2501	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
18	17 51 44.8	-19 23 41.5	8.9054	3.7132	G8.905+3.713	G8.9051+3.7134	17487-1922	24.933 GHz (I);	2010-03-21	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
19	17 53 49.4	-29 55 35	0.0677	-2.0412	G0.068-2.041	G0.0675-2.0408	17506-2955	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I	EVOLVED	03.03.2010
20	17 54 43.5	-25 26 29.8	4.0380	0.0555	G4.038+0.056	G4.0379+0.0560	17516-2525	24.933 GHz (I);	2010-03-01	GBT	0.021	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
21	17 57 14.1	-27 54 16	2.1916	-1.6683	G2.186-1.660	G2.1916-1.6684	17540-2753	24.933 GHz (I);	2010-03-01	GBT	0.022	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
22	17 57 57.9	-27 53 20.8	2.2857	-1.8006	G2.287-1.801	G2.2865-1.8014	17548-2753	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
23	17 58 4.3	-21 21 09	7.9595	1.4467	G7.961+1.445	G7.9612+1.4449	17550-2120	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
24	17 58 10.7	-28 00 25.9	2.2068	-1.9003	G2.207-1.900	G2.2066-1.8999	17550-2800	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I -OH	EVOLVED	03.03.2010
25	17 58 16.4	-20 30 22.1	8.7166	1.8286	G8.716+1.829	G8.7164+1.8290	17552-2030	24.933 GHz (I);	2010-03-01	GBT	0.020	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
26	17 59 4.6	-20 27 23.5	8.8535	1.6901	G8.854+1.689	G8.8541+1.6887	17560-2027	24.933 GHz (I);	2010-03-01	GBT	0.021	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
27	18 04 2.8	-18 47 9.7	10.8849	1.4984	G10.885+1.499	G10.8846+1.4987	18011-1847	24.933 GHz (I);	2010-03-21	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
28	18 04 22.3	-13 51 49.1	15.2211	3.8386	G15.221+3.839	G15.2210+3.8389	18015-1352	24.933 GHz (I);	2010-03-21	GBT	0.030	30	-H₂O -CH₃OH I -CH₃OH II +OH	EVOLVED	21.03.2010
29	18 04 45.9	-27 43 11	3.1762	-3.0244	G3.176-3.024	G3.1759-3.0238	18016-2743	24.933 GHz (I);	2010-03-01	GBT	0.022	30	-H₂O -CH₃OH I +OH -SiO	EVOLVED	01.03.2010
30	18 06 53.4	-19 03 9.3	10.9811	0.7816	G10.981+0.782	G10.9810+0.7819	18039-1903	24.933 GHz (I);	2010-03-01	GBT	0.025	30	+H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
31	18 07 54.9	-21 18 8.9	9.1326	-0.5235	G9.132-0.523	G9.1325-0.5233	18049-2118	24.933 GHz (I);	2010-03-01	GBT	0.020	30	-H₂O -CH₃OH I +OH		01.03.2010
32	18 08 12.9	-24 14 35.8	6.5941	-2.0110	G6.594-2.011	G6.5939-2.0109	18051-2415	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
33	18 10 06	-17 26 35.2	12.7584	0.8958	G12.758+0.896	G12.7583+0.8959	18071-1727	24.933 GHz (I);	2010-03-01	GBT	0.030	30	-H₂O -CH₃OH I +OH -SiO	EVOLVED	01.03.2010
34	18 11 18.8	-21 55 5.1	8.9757	-1.5126	G8.976-1.512	G8.9758-1.5121	18083-2155	24.933 GHz (I);	2010-03-01	GBT	0.030	30	-H₂O -CH₃OH I -OH	EVOLVED	01.03.2010
35	18 11 34.7	-14 39 55.6	15.3645	1.9226	G15.364+1.925	G15.3637+1.9243	18087-1440	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	03.03.2010
36	18 13 32.3	-19 35 3.3	11.2732	-0.8488	G11.273-0.848	G11.2729-0.8480	18105-1935	24.933 GHz (I);	2010-03-01	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
37	18 14 26.4	-25 02 55.6	6.5657	-3.6385	G6.566-3.638	G6.5655-3.6383	18113-2503	24.933 GHz (I);	2010-03-03	GBT	0.030	30	+H₂O -CH₃OH I -OH	EVOLVED	03.03.2010
	18 14 26.4	-25 02 55.6	6.5657	-3.6385	G6.566-3.638	G6.5655-3.6383	18113-2503	24.933 GHz (I);	2010-03-21	GBT	0.030	30	+H₂O -CH₃OH I -OH	EVOLVED	21.03.2010
39	18 16 26.2	-14 55 13.4	15.7019	0.7692	G15.701+0.770	G15.7012+0.7704	18135-1456	24.933 GHz (I);	2010-03-01	GBT	0.030	30	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED	01.03.2010
40	18 21 24.8	-25 36 35.2	6.8102	-5.2934	G6.810-5.293	G6.8099-5.2926	18183-2538	24.933 GHz (I);	2010-03-01	GBT	0.021	30	-H₂O -CH₃OH I -OH	EVOLVED	01.03.2010
41	18 22 50.9	-14 40 49.4	16.6455	-0.4836	G16.645-0.483	G16.6454-0.4835	18199-1442	24.933 GHz (I);	2010-03-01	GBT	0.024	30	-H₂O -CH₃OH I +OH +SiO	EVOLVED	01.03.2010
42	18 25 45.1	-11 25 55.7	19.8471	0.4115	G19.847+0.412	G19.8468+0.4120	18229-1127	24.933 GHz (I);	2010-03-21	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
43	18 26 20.4	-04 45 41.8	25.8230	3.3870	G25.822+3.388	G25.8225+3.3879	18236-0447	24.933 GHz (I);	2010-03-01	GBT	0.025	30	-H₂O -CH₃OH I -CH₃OH II +OH	EVOLVED	01.03.2010
44	18 38 15.5	-07 09 52.3	25.0574	-0.3505	G25.057-0.350	G25.0568-0.3504	18355-0712	24.933 GHz (I);	2010-03-01	GBT	0.023	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
45	18 38 58.9	-12 00 44.3	20.8277	-2.7291	G20.827-2.729	G20.8275-2.7286	18361-1203	24.933 GHz (I);	2010-03-01	GBT	0.024	30	+H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
	18 38 58.9	-12 00 44.3	20.8277	-2.7291	G20.827-2.729	G20.8275-2.7286	18361-1203	24.933 GHz (I);	2010-03-21	GBT	0.030	30	+H₂O -CH₃OH I +OH	EVOLVED	21.03.2010
47	18 40 52.3	+13 52 53.9	44.1946	8.5818	G44.194+8.582	G44.1943+8.5823	18385+1350	24.933 GHz (I);	2010-03-07	GBT	0.027	30	-H₂O -CH₃OH I	EVOLVED	07.03.2010
48	18 46 4.5	-00 38 55.4	31.7430	0.8974	G31.743+0.898	G31.7430+0.8977	18434-0042	24.933 GHz (I);	2010-03-01	GBT	0.023	30	-H₂O -CH₃OH I -OH	EVOLVED	01.03.2010
49	18 48 1.6	+00 04 48	32.6143	0.7954	G32.614+0.797	G32.6136+0.7971	18454+0001	24.933 GHz (I);	2010-03-01	GBT	0.030	30	-H₂O -CH₃OH I	EVOLVED	01.03.2010
50	18 49 39.2	+00 18 52	33.0083	0.5406	G33.008+0.542	G33.0084+0.5417	18470+0015	24.933 GHz (I);	2010-03-01	GBT	0.030	30	-H₂O -CH₃OH I +OH	EVOLVED	01.03.2010
51	18 53 58.1	+00 23 25.4	33.5678	-0.3849	G33.567-0.384	G33.5674-0.3842	18514+0019	24.933 GHz (I);	2010-03-01	GBT	0.030	30	-H₂O -CH₃OH I -CH₃OH II +OH	EVOLVED	01.03.2010
52	18 55 26.4	+02 14 48.8	35.3877	0.1347	G35.388+0.135	G35.3876+0.1350	18529+0210	24.933 GHz (I);	2010-03-03	GBT	0.030	30	-H₂O -CH₃OH I +OH -SiO	EVOLVED	03.03.2010
	18 55 26.4	+02 14 48.8	35.3877	0.1347	G35.388+0.135	G35.3876+0.1350	18529+0210	24.933 GHz (I);	2010-03-07	GBT	0.030	30	-H₂O -CH₃OH I +OH -SiO	EVOLVED	07.03.2010
54	19 00 25.3	+08 22 47.1	41.4114	1.8307	G41.411+1.831	G41.4110+1.8311	18580+0818	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -OH	EVOLVED	07.03.2010
55	19 02 6.5	+03 20 15.1	37.1186	-0.8481	G37.118-0.847	G37.1184-0.8474	18596+0315	24.933 GHz (I);	2010-03-07	GBT	0.025	30	+H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED	07.03.2010
56	19 03 00	+10 26 35.1	43.5386	2.2074	G43.539+2.208	G43.5385+2.2076	19006+1022	24.933 GHz (I);	2010-03-21	GBT	0.024	30	-H₂O -CH₃OH I	EVOLVED	21.03.2010
57	19 03 30.8	+10 53 53.3	44.0015	2.3029	G44.001+2.304	G44.0010+2.3033	19011+1049	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -CH₃OH II -OH -SiO	EVOLVED	07.03.2010
58	19 03 52.7	+13 01 20.9	45.9347	3.1931	G45.934+3.194	G45.9344+3.1936	19015+1256	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -OH		07.03.2010
59	19 09 29.8	+09 02 23.3	43.0270	0.1410	G43.027+0.141	G43.0270+0.1410	19071+0857	24.933 GHz (I);	2010-03-01	GBT	0.017	30	+H₂O -CH₃OH I	SFR_MIXED	01.03.2010
	19 09 29.8	+09 02 23.3	43.0270	0.1410	G43.027+0.141	G43.0270+0.1410	19071+0857	24.933 GHz (I);	2010-03-03	GBT	0.018	30	+H₂O -CH₃OH I	SFR_MIXED	03.03.2010
	19 09 29.8	+09 02 23.3	43.0270	0.1410	G43.027+0.141	G43.0270+0.1410	19071+0857	24.933 GHz (I);	2010-03-07	GBT	0.023	30	+H₂O -CH₃OH I	SFR_MIXED	07.03.2010
62	19 10 0.1	+04 37 6.2	39.1608	-2.0091	G39.161-2.009	G39.1606-2.0089	19075+0432	24.933 GHz (I);	2010-03-03	GBT	0.300	30	-H₂O -CH₃OH I -CH₃OH II -OH	EVOLVED	03.03.2010
	19 10 0.1	+04 37 6.2	39.1608	-2.0091	G39.161-2.009	G39.1606-2.0089	19075+0432	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -CH₃OH II -OH	EVOLVED	07.03.2010
64	19 10 32.6	-03 10 15.8	32.2799	-5.6939	G32.280-5.694	G32.2798-5.6937	19079-0315	24.933 GHz (I);	2010-03-21	GBT	0.025	30	-H₂O -CH₃OH I -OH	EVOLVED	21.03.2010
65	19 11 44.7	+16 32 54	49.9457	3.1173	G49.946+3.118	G49.9457+3.1176	19094+1627	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I	EVOLVED	07.03.2010
66	19 15 35.5	+21 36 33.2	54.8684	4.6395	G54.868+4.640	G54.8681+4.6401	19134+2131	24.933 GHz (I);	2010-03-07	GBT	0.024	30	+H₂O -CH₃OH I -CH₃OH II -OH -SiO	EVOLVED	07.03.2010
67	19 20 14.2	+12 12 22	47.0574	-0.7227	G47.057-0.722	G47.0570-0.7221	19178+1206	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED	07.03.2010
68	19 20 25.3	+18 11 41	52.3674	2.0482	G52.367+2.050	G52.3667+2.0497	19181+1806	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I	EVOLVED	07.03.2010
69	19 21 25.4	+11 08 39.8	46.2562	-1.4776	G46.256-1.477	G46.2560-1.4773	19190+1102	24.933 GHz (I);	2010-03-07	GBT	0.024	30	+H₂O -CH₃OH I +OH	EVOLVED	07.03.2010
70	19 21 31.7	+18 10 9.5	52.4683	1.8043	G52.468+1.805	G52.4681+1.8046	19193+1804	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -CH₃OH II +OH	EVOLVED	07.03.2010
71	19 33 41.7	+22 42 8.1	57.8135	1.4585	G57.813+1.459	G57.8132+1.4590	19315+2235	24.933 GHz (I);	2010-03-07	GBT	0.024	30	-H₂O -CH₃OH I -CH₃OH II	EVOLVED	07.03.2010
72	19 34 3.5	+22 21 13.6	57.5490	1.2166	G57.549+1.217	G57.5489+1.2169	19319+2214	24.933 GHz (I);	2010-03-07	GBT	0.023	30	+H₂O -CH₃OH I -CH₃OH II +OH -SiO	EVOLVED	07.03.2010
73	19 39 35.5	+24 06 24.8	59.6999	0.9632	G59.700+0.964	G59.6996+0.9638	19374+2359	24.933 GHz (I);	2010-03-07	GBT	0.023	30	+H₂O -CH₃OH I -OH	UNK	07.03.2010
74	20 05 29.7	+32 51 35.1	70.1285	0.5739	G70.128+0.574	G70.1282+0.5743	20035+3242	24.933 GHz (I);	2010-03-07	GBT	0.022	30	-H₂O -CH₃OH I -CH₃OH II -OH	EVOLVED	07.03.2010
75	20 06 10.7	+33 07 50.7	70.4341	0.5986	G70.434+0.599	G70.4338+0.5992	20042+3259	24.933 GHz (I);	2010-03-07	GBT	0.023	30	-H₂O -CH₃OH I -OH	EVOLVED	07.03.2010
76	20 23 19.3	+37 58 52.4	76.4026	0.3921	G76.402+0.392	G76.4022+0.3925	20214+3749	24.933 GHz (I);	2010-03-07	GBT	0.021	30	-H₂O -CH₃OH I -OH	EVOLVED	07.03.2010
77	20 26 25.5	+35 19 14.2	74.5871	-1.6501	G74.587-1.650	G74.5867-1.6499	20244+3509	24.933 GHz (I);	2010-03-21	GBT	0.023	30	-H₂O -CH₃OH I -OH	EVOLVED	21.03.2010
78	20 48 4.7	+39 05 0.7	80.1921	-2.8162	G80.192-2.816	G80.1918-2.8157	20461+3853	24.933 GHz (I);	2010-03-21	GBT	0.024	30	-H₂O -CH₃OH I -OH	EVOLVED	21.03.2010
79	21 54 15.1	+56 57 23	100.5340	1.9995	G100.534+2.000	G100.5337+1.9999	21525+5643	24.933 GHz (I);	2010-03-21	GBT	0.025	30	-H₂O -CH₃OH I -OH	EVOLVED	21.03.2010
80	21 56 58.4	+62 18 43.4	104.1303	5.9914	G104.130+5.991	G104.1302+5.9915	21554+6204	24.933 GHz (I);	2010-03-21	GBT	0.025	30	-H₂O -CH₃OH I -CH₃OH II +OH +SiO	EVOLVED	21.03.2010

X

DSS colored	2MASS colored	WISE colored
PACS color (70-160 um)	SPIRE color (250-500 um)	GLIMPSE 360
SDSS color	IRAC color I1,I2,I4	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(met1_data_all.ra_hms) as ra_hms,MAX(met1_data_all.dec_dms) as dec_dms,MAX(met1_data_all.source_name) as source_name,MAX(met1_data_all.ra) as ra,MAX(met1_data_all.dec) as dec,MAX(met1_data_all.l) as l,MAX(met1_data_all.b) as b,MAX(met1_data_all.grp) as grp,MAX(met1_data_all.grpv) as grpv,MAX(met1_data_all.other_name) as other_name,MAX(met1_data_all.other_desc) as other_desc,BOOL_OR(thermal) as thermal,MAX(met1_data_all.line) as line,MAX(met1_data_all.vrange) as vrange,MAX(met1_data_all.vpeak) as vpeak,MAX(met1_data_all.peak) as peak,MAX(met1_data_all.fwhm) as fwhm,MAX(met1_data_all.int) as int,MAX(met1_data_all.rms) as rms,MAX(met1_data_all.units) as units,MAX(met1_data_all.units_rms) as units_rms,MAX(met1_data_all.date_txt) as date_txt,MAX(met1_data_all.telescope_ref) as telescope_ref,MAX(met1_data_all.telescope_conf) as telescope_conf,MAX(met1_data_all.v_step) as v_step,MAX(met1_data_all.beam) as beam,MAX(met1_data_all.beam_maj) as beam_maj,MAX(met1_data_all.beam_min) as beam_min,MAX(met1_data_all.beam_pa) as beam_pa,MAX(met1_data_all.ref) as ref,MAX(met1_data_all.list_ref) as list_ref,MAX(met1_data_all.ascii) as ascii,MAX(met1_data_all.url) as url,MAX(met1_data_all.image) as image,MAX(met1_data_all.image2) as image2,MAX(met1_data_all.image3) as image3,MAX(met1_data_all.descr) as descr,MAX(met1_data_all.id) as id,BOOL_OR(mjy_flag) as mjy_flag,BOOL_OR(rms_mjy_flag) as rms_mjy_flag,MAX(met1_data_all.dist) as dist,1 as dist_parallax,MAX(met1_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 met1_data_all  LEFT JOIN all_objects_withmet ON met1_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 met1_data_all.line=transitions."Line"  WHERE ref ilike 'GOM14' AND detected=true AND hide=false GROUP BY ref

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