ADQL Query

Parameters

ADQL query: SELECT TOP 10 * from help_a_list.main WHERE f_spire_250/ferr_spire_250 >2

Result

Matched: 10

Field	HELP_Id	RA [deg]	Dec [deg]	HP_Idx	EBV	Redshift	zSpec	zSpec_qual	zSpec_Association_Flag	stellarity	stellarity_origin	f_best_u [uJy]	ferr_best_u [uJy]	m_best_u [mag]	merr_best_u [mag]	flag_best_u	f_best_g [uJy]	ferr_best_g [uJy]	m_best_g [mag]	merr_best_g [mag]	flag_best_g	f_best_r [uJy]	ferr_best_r [uJy]	m_best_r [mag]	merr_best_r [mag]	flag_best_r	f_best_i [uJy]	ferr_best_i [uJy]	m_best_i [mag]	merr_best_i [mag]	flag_best_i	f_best_z [uJy]	ferr_best_z [uJy]	m_best_z [mag]	merr_best_z [mag]	flag_best_z	f_best_y [uJy]	ferr_best_y [uJy]	m_best_y [mag]	merr_best_y [mag]	flag_best_y	f_best_j [uJy]	ferr_best_j [uJy]	m_best_j [mag]	merr_best_j [mag]	flag_best_j	f_best_h [uJy]	ferr_best_h [uJy]	m_best_h [mag]	merr_best_h [mag]	flag_best_h	f_best_k [uJy]	ferr_best_k [uJy]	m_best_k [mag]	merr_best_k [mag]	flag_best_k	f_best_ks [uJy]	ferr_best_ks [uJy]	m_best_ks [mag]	merr_best_ks [mag]	flag_best_ks	f_irac_i1 [uJy]	ferr_irac_i1 [uJy]	m_irac_i1 [mag]	merr_irac_i1 [mag]	flag_irac_i1	f_irac_i2 [uJy]	ferr_irac_i2 [uJy]	m_irac_i2 [mag]	merr_irac_i2 [mag]	flag_irac_i2	f_irac_i3 [uJy]	ferr_irac_i3 [uJy]	m_irac_i3 [mag]	merr_irac_i3 [mag]	flag_irac_i3	f_irac_i4 [uJy]	ferr_irac_i4 [uJy]	m_irac_i4 [mag]	merr_irac_i4 [mag]	flag_irac_i4	f_mips_24 [uJy]	ferr_mips_24 [uJy]	flag_mips_24	f_pacs_green [uJy]	ferr_pacs_green [uJy]	flag_pacs_green	f_pacs_red [uJy]	ferr_pacs_red [uJy]	flag_pacs_red	f_spire_250 [uJy]	ferr_spire_250 [uJy]	flag_spire_250	f_spire_350 [uJy]	ferr_spire_350 [uJy]	flag_spire_350	f_spire_500 [uJy]	ferr_spire_500 [uJy]	flag_spire_500	CIGALE_SFR [Msun/yr]	CIGALE_SFR_err [Msun/yr]	CIGALE_Mstar [Msun]	CIGALE_Mstar_err [Msun]	CIGALE_DustLumin [W]	CIGALE_DustLumin_err [W]	CIGALE_DustLumin_IRonly [W]	CIGALE_DustLumin_IRonly_err [W]	cigale_chi2_opt	cigale_chi2_ir	cigale_chi2_red	cigale_chi2_ironly	Flag_Cleaned	Flag_Merged	Flag_OptNIR_Obs²	Flag_OptNIR_Det²
SSDF	HELP_J231600.780-564339.116	349.003251439	-56.7275321473	755879846	0.0112970050757	0.7601	N/A	-99	False	0.35783	des_stellarity	N/A	N/A	N/A	N/A	False	0.143476879109	0.0804722169694	26.0080451965	0.608959436417	False	0.847508818996	0.235341372919	24.0796394348	0.301493793726	False	1.92770777378	0.341452265283	23.1873970032	0.192314982414	False	3.09682994948	0.588450247645	22.672706604	0.206308305264	False	4.00771687929	1.15529818673	22.3927574158	0.312983453274	False	N/A	N/A	N/A	N/A	False	11.9668159485	4.82046937943	21.2050533295	0.437355935574	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	18.13	3.14	20.754005	0.18804258	False	1.25	6.34	23.657722	5.506854	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	13375.577	4574.6914	False	11285.584	4649.311	False	13723.565	7739.8037	False	36.8418811085	19.8531446237	24066911835.7	8200519065.47	1.24706610636e+38	4.59656872922e+37	1.55502059462e+38	3.91790723863e+37	0.88254216985	0.856794536166	0.789138455774	0.81308393203	False	False	7	5
SSDF	HELP_J231330.412-563908.128	348.3767152	-56.6522576581	755886395	0.0143914984132	0.2995	N/A	-99	False	0.03	ssdf_stellarity	N/A	N/A	N/A	N/A	False	21.0444984782	0.209214740749	20.5921535492	0.0107938908041	False	60.8663755643	0.300530139303	19.4390563965	0.00536086549982	False	96.5097583124	0.493596798954	18.9385719299	0.00555297126994	False	129.519559192	1.16386285326	18.6191616058	0.00975642632693	False	135.966336651	2.70808351047	18.5664215088	0.0216249432415	False	191.40335083	9.79907226562	18.1951255798	0.0555852726102	False	261.582519531	16.6772270203	17.8559780121	0.0692212507129	False	N/A	N/A	N/A	N/A	False	378.29888916	22.0527381897	17.455411911	0.0632924288511	False	197.42	5.92	18.161522	0.032557786	False	193.13	5.79	18.185371	0.03255016	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	40629.28	6687.1406	False	11102.682	7542.074	False	6885.6416	7534.7324	True	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	False	False	7	7
SSDF	HELP_J231328.167-563850.887	348.367362772	-56.6474686256	755886484	0.0145796765202	0.7205	N/A	-99	False	0.05	vhs_stellarity	N/A	N/A	N/A	N/A	False	1.3251429361	0.164181178886	23.5943431854	0.134519413114	False	1.99980734515	0.235871413175	23.1475296021	0.128059402108	False	4.13831676551	0.389735742833	22.3579406738	0.102251768112	False	4.94074129633	0.932394225638	22.1655197144	0.204895198345	False	5.28626902882	2.1506892722	22.0921268463	0.441725760698	False	11.2043704987	3.00394177437	21.2765312195	0.291090726852	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	12.16	2.9	21.187668	0.2589338	False	18.27	2.72	20.745659	0.16164216	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	12781.724	4754.488	False	4058.5676	4515.13	True	9920.135	8802.875	True	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	False	False	7	5
SSDF	HELP_J231329.499-563809.292	348.37291182	-56.6359143733	755886528	0.0149664604463	0.9345	N/A	-99	False	0.657565	des_stellarity	N/A	N/A	N/A	N/A	False	1.51307899665	0.108478327455	23.450345993	0.0778405144811	False	1.8028463282	0.170127820352	23.2601032257	0.102456837893	False	1.81266570658	0.280887105145	23.2542057037	0.168243542314	False	2.96199603383	0.671373357372	22.7210388184	0.246095657349	False	2.54053796759	1.5496601261	22.8876857758	0.662270009518	False	11.3489208221	3.00410437584	21.2626132965	0.287398695946	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	15.47	3.14	20.926277	0.22037566	False	17.52	2.96	20.791168	0.18343487	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	30852.342	6365.49	False	13024.065	9015.577	False	5347.723	6850.8823	True	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	False	False	7	5
SSDF	HELP_J231338.518-563919.228	348.410492653	-56.6553412131	755886391	0.0141185085791	0.8877	N/A	-99	False	0.357192	des_stellarity	N/A	N/A	N/A	N/A	False	0.381208358497	0.0872632622753	24.9470939636	0.248538315296	False	0.517758815976	0.145882668281	24.6146812439	0.305914819241	False	1.19120743722	0.207236790877	23.7100315094	0.188887745142	False	0.703240759706	0.495663869138	24.2822399139	0.765257418156	False	0.794274094171	1.14476829685	24.1500740051	1.56484568119	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	6.83	2.88	21.81395	0.4578214	False	14.39	2.62	21.004845	0.19768092	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	13201.283	4898.8135	False	28470.975	5157.9004	False	42323.465	6944.801	False	111.663973512	36.6507175302	5474389128.65	3193605635.94	2.3632801381e+38	5.64670714597e+37	2.63030627502e+38	3.5605275647e+37	0.500265740798	14.1069038913	3.46837796496	13.0671623215	False	False	7	5
SSDF	HELP_J231343.408-563829.084	348.430868653	-56.6414122131	755886436	0.0144909809025	0.7524	N/A	-99	False	0.03	ssdf_stellarity	N/A	N/A	N/A	N/A	False	3.31892172005	0.17672827179	22.5975074768	0.0578140430152	False	4.99831589221	0.294857325777	22.1529407501	0.0640490278602	False	10.3987807578	0.419030555432	21.3575439453	0.0437509603798	False	12.6759850984	0.999962107414	21.1425457001	0.0856497585773	False	13.8881337514	2.30922998565	21.043390274	0.180529266596	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	33.93	4.2	20.07354	0.13439704	False	21.9	3.96	20.54889	0.1963249	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	13581.716	5571.726	False	20045.805	6919.6416	False	33495.28	8592.508	False	49.5881548684	18.1481911324	20195637585.3	6783703174.72	1.50794262287e+38	4.56045770133e+37	1.82061142439e+38	4.02695890917e+37	0.211294203286	5.78262801149	1.42589113559	5.62908973826	False	False	7	5
SSDF	HELP_J231346.150-563835.855	348.442291641	-56.6432931362	755886415	0.0143146301616	0.779	N/A	-99	False	0.05	vhs_stellarity	N/A	N/A	N/A	N/A	False	0.616421065636	0.134342423558	24.4253063202	0.236624673009	False	1.74926038806	0.213944542255	23.2928638458	0.132791742682	False	4.2683708567	0.304754083303	22.324344635	0.0775196328759	False	6.19851416006	0.727369255217	21.9192810059	0.127406522632	False	6.70491505363	1.67902080222	21.8340167999	0.27188616991	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	25.8583049774	8.92157745361	20.3684997559	0.374598413706	False	27.04	2.76	20.319984	0.11082218	False	22.24	2.6	20.532166	0.12692958	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	13722.698	5609.972	False	13870.415	6529.553	False	29166.818	9597.361	False	42.8839516747	23.5981583351	33067120070.5	8823864530.7	1.47608770902e+38	5.63156892717e+37	1.77191695709e+38	4.15438831809e+37	0.0994263031945	3.11699026968	0.692996413244	3.10773374829	False	False	7	5
SSDF	HELP_J231330.442-563750.056	348.376840653	-56.6305712131	755886529	0.0151605396196	0.9524	N/A	-99	False	0.431987	des_stellarity	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	0.350158258595	0.155620060026	25.0393390656	0.48253133893	False	1.57829219357	0.257439199881	23.4045314789	0.177097156644	False	4.40225691712	0.614998946306	22.2908115387	0.15167824924	False	2.82460942911	1.42070065275	22.7726039886	0.546095371246	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	22.78	3.48	20.506119	0.16586311	False	20.09	3.26	20.642548	0.17618218	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	13088.561	5461.326	False	5437.1743	6713.272	True	7591.742	8742.631	True	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	False	False	7	5
SSDF	HELP_J231332.141-563754.510	348.383921653	-56.6318082131	755886443	0.0150723086545	1.1879	N/A	-99	False	0.643325	des_stellarity	N/A	N/A	N/A	N/A	False	1.92925262182	0.162505996682	23.1865272522	0.0914544016123	False	2.59089618907	0.255204144192	22.8663749695	0.106945380569	False	4.05075247071	0.421567046606	22.3811607361	0.112993970513	False	6.060422462	1.00839442102	21.9437427521	0.180655777454	False	7.68073589576	2.3289164425	21.6864929199	0.329211801291	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	64.57	3.82	19.374924	0.06423281	False	55.92	3.6	19.53109	0.069897175	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	15542.735	6128.715	False	25945.602	8376.205	False	17346.896	10770.564	False	143.48453805	53.0309144458	1.07699592748e+11	30611746698.0	4.84136900538e+38	1.52665711129e+38	4.22693665216e+38	7.18198800036e+37	1.44807523197	1.31047811274	1.25660079195	0.994083795911	False	False	7	5
SSDF	HELP_J231331.710-563731.984	348.382125653	-56.6255512131	755886446	0.0153311716756	0.8008	N/A	-99	False	0.519353	des_stellarity	N/A	N/A	N/A	N/A	False	0.198705686881	0.18024901871	25.6544742584	0.984888195992	False	0.946520590333	0.290345645443	23.9596748352	0.333050101995	False	3.51554314011	0.489302799601	22.5350189209	0.151115700603	False	5.43911140358	1.15282482661	22.0611801147	0.230122819543	False	7.91196398606	2.4670395466	21.6542892456	0.338544785976	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	24.8	3.78	20.413872	0.1654872	False	15.36	3.58	20.934021	0.2530557	False	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	14492.523	4097.1523	False	8988.044	5016.282	True	8753.446	7869.167	True	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	False	False	7	5

Note 1

The Flag_Gaia is computed by cross-matching the catalogue with the Gaia catalogue:

Value	Meaning
1	The object if possibly a Gaia object: the nearest Gaia source is between 1.5 arcsec and 2 arcsec.
2	The object if probably a Gaia object: the nearest Gaia source is between 0.6 arcsec and 1.5 arcsec.
3	The object is definitely a Gaia object: the nearest Gaia source is nearer than 0.6 arcsec.
0	Otherwise (the nearest Gaia source is farer than 2 arcsec).

Note 2

The Flag_OptNIR_Obs and Flag_OptNIR_Det are computed while cross-matching the optical and near/mid infrared catalogues and indicate if a source was observed (i.e. is on the coverage of surveys at the given regime) or detected (i.e. is present in the catalogue) in various wavelength regime. The detection is based on the detection wavelengths of the catalogues, and to be counted as detected, a source must be present in at least two catalogues.

The flag is a composed binary flag with these values:

Value	Meaning
1	Observation/detection in optical wavelengths.
2	Observation/detection in near-infrared wavelengths.
4	Observation/detection in mid-infrared wavelengths.

Query Form

On this page, you can use ADQL to query some of our tables. This is mainly for dabbling; use TAP for larger jobs (e.g., using TAPHandle within your browser).

To learn what ADQL is or for further information on this implementation, see the service info.

To protect your nerves, the server inserts a TOP 2000 phrase unless you give a limit yourself. Thus, if you hit the 2000 record limit and want to override it, you can specify your limit yourself (like SELECT TOP 20000...).

There is a fixed limit to 100000 rows on this service. If this bugs you, use TAP.

Related

Metadata

Identifier

Cite this

Description

Keywords

Creator

Created

Data updated

Reference URL

ADQL Query

Parameters

Result

Query Form