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_J231429.164-563912.007	348.621517653	-56.6533352131	755885627	0.0131584144895	0.9806	N/A	-99	False	0.422749	des_stellarity	N/A	N/A	N/A	N/A	False	0.293071283696	0.0805213742996	25.2325668335	0.298306167126	False	0.36986212111	0.148394914743	24.9799003601	0.43561565876	False	0.986245734582	0.219994485128	23.9150371552	0.242187082767	False	1.90989982795	0.440759575378	23.197473526	0.250562161207	False	1.87847486958	1.05311893922	23.2154865265	0.608690261841	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	15.88	2.84	20.897873	0.19417448	False	17.42	2.68	20.797379	0.16703634	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	17300.973	5053.041	False	12486.16	5341.544	False	4907.1875	6894.492	True	81.5209618053	35.4157097328	25847685236.6	11400508526.7	2.58963605186e+38	8.3326338012e+37	2.76153025294e+38	6.34541273806e+37	0.238750264391	0.0465347407524	0.184879539733	5.04526900228e-06	False	False	7	5
SSDF	HELP_J231435.189-563924.250	348.646621631	-56.6567360304	755885628	0.0131322224859	0.7169	N/A	-99	False	0.05	vhs_stellarity	N/A	N/A	N/A	N/A	False	1.24218796399	0.122229475006	23.6645317078	0.106834851205	False	2.15106711624	0.196040702992	23.068365097	0.0989501848817	False	4.66213231228	0.28966758576	22.2285385132	0.0674589574337	False	5.87643686699	0.608259714252	21.9772148132	0.112382657826	False	6.03585757155	1.4773398787	21.9481525421	0.265745401382	False	10.5037221909	3.3549926281	21.3466415405	0.346794873476	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.51	3.88	20.383224	0.16513744	False	11.77	3.72	21.22306	0.34315535	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	13837.924	4414.3457	False	9560.966	4849.007	True	20986.73	7557.1963	False	35.3865905269	16.1811373744	14537975326.3	5082584610.85	1.11556436666e+38	4.23667361937e+37	1.38689779383e+38	3.3091925437e+37	0.377854247944	4.84472503264	0.832189460475	4.56801204482	False	False	7	5
SSDF	HELP_J231432.192-563849.589	348.634134317	-56.6471079713	755885631	0.0130594130538	1.0439	N/A	-99	False	0.9	vhs_stellarity	N/A	N/A	N/A	N/A	False	0.958644449911	0.114504614053	23.9458560944	0.129684999585	False	1.31598178453	0.205799383196	23.6018753052	0.169792503119	False	1.40019003081	0.328535929347	23.534532547	0.254753530025	False	2.26609926883	0.651525825223	23.0118026733	0.312159836292	False	5.79991706454	1.44150617001	21.9914455414	0.269847899675	False	6.8987121582	2.99910306931	21.8030796051	0.472006201744	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	21.93	3.02	20.54741	0.1495177	False	20.7	2.84	20.61007	0.14896089	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	14439.107	5966.0527	False	11367.685	7283.6475	False	4985.1826	6087.539	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_J231432.765-563833.968	348.636520792	-56.6427690007	755885631	0.0130049836329	0.839	N/A	-99	False	0.365218	des_stellarity	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	0.330913517516	0.224260054289	25.1007137299	0.735803306103	False	0.857030979783	0.338601237118	24.0675086975	0.428959548473	False	1.12411014786	0.697086209488	23.772977829	0.673289656639	False	3.43529751687	1.69786740806	22.5600891113	0.536616146564	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	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	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	27973.303	5072.244	False	24265.248	6043.5957	False	8976.669	8658.067	True	116.231008146	49.0288822198	32673880516.1	34505913972.7	3.26185309653e+38	7.91195926939e+37	3.52230767281e+38	8.37933668903e+37	0.377029081393	0.592945555054	0.344806560143	0.558534148652	False	False	7	1
SSDF	HELP_J231437.824-563855.370	348.657598792	-56.6487140007	755885666	0.0130172057317	0.8208	N/A	-99	False	0.492236	des_stellarity	N/A	N/A	N/A	N/A	False	0.368254895571	0.112758432824	24.9846286774	0.332448840141	False	1.1838661752	0.193210131336	23.7167434692	0.177195057273	False	1.7682213135	0.293296161765	23.2811584473	0.18009185791	False	3.61597486369	0.600338185503	22.5044364929	0.180258139968	False	2.22132805351	1.38917045458	23.0334682465	0.678995907307	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	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	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	11552.62	4861.2417	False	23712.074	5201.996	False	18991.688	8274.748	False	60.4819161243	26.6675299672	18758727923.0	13467517310.7	1.82960360038e+38	5.85215177615e+37	1.94305241876e+38	3.94148523886e+37	0.987968123358	4.20886862987	1.76708715604	4.19580735336	False	False	7	1
SSDF	HELP_J231435.334-563838.321	348.647224497	-56.6439780907	755885672	0.012986720846	0.582	N/A	-99	False	0.284382	des_stellarity	N/A	N/A	N/A	N/A	False	0.57595673627	0.0949137980915	24.4990253448	0.178922027349	False	2.4407657055	0.166116141031	22.9311847687	0.0738941505551	False	6.02911758128	0.24167595801	21.9493656158	0.0435215160251	False	7.47437669451	0.505906685648	21.7160625458	0.0734885632992	False	6.57700863223	1.16958822473	21.8549289703	0.193076267838	False	10.4450473785	3.97851371765	21.3527240753	0.413556426764	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	N/A	N/A	N/A	N/A	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	34894.445	5235.4375	False	26737.107	6034.8438	False	18473.625	9555.15	False	71.2586348657	32.8698734106	38904161370.5	16086179158.7	2.35016319764e+38	7.05187606061e+37	2.46201735532e+38	6.79144525207e+37	1.11876914221	0.878851334941	0.918943550733	0.846569322563	False	False	7	1
SSDF	HELP_J231441.667-563907.878	348.673611653	-56.6521882131	755885664	0.0130273704217	0.8318	N/A	-99	False	0.0961675	des_stellarity	N/A	N/A	N/A	N/A	False	1.78983546961	0.165298821704	23.2679672241	0.100272297859	False	2.67957330986	0.282902354922	22.8298358917	0.11462919414	False	6.20994739352	0.418718731528	21.9172801971	0.0732080414891	False	10.2520027928	0.87776293707	21.3729782104	0.0929592996836	False	5.86628748442	2.03130729491	21.9790916443	0.37595564127	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	20.99	2.94	20.59497	0.1520755	False	12.52	2.78	21.15599	0.24108198	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	10039.151	4672.3994	False	5360.07	5264.352	True	6609.9316	7442.0303	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_J231447.518-563950.033	348.697991187	-56.6638981938	755885640	0.0130866618295	0.7805	N/A	-99	False	0.357058	des_stellarity	N/A	N/A	N/A	N/A	False	0.121361209218	0.189235607724	26.1898002625	1.69296228886	False	0.750826428048	0.273664591344	24.211151123	0.395734012127	False	3.86239774293	0.348366245599	22.4328575134	0.0979272127151	False	6.31284635983	0.805413323085	21.8994369507	0.1385217309	False	5.16407152145	1.69380655412	22.1175193787	0.356119602919	False	6.07370185852	2.99817848206	21.9413661957	0.53595495224	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	27.8398475647	9.63510227203	20.2883319855	0.375762790442	False	44.57	3.48	19.777397	0.08477366	False	28.05	3.24	20.280167	0.12541124	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	16311.129	7586.6094	False	5895.073	5581.3457	True	5440.6875	7241.662	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_J231443.890-563913.669	348.682873256	-56.6537970491	755885643	0.0130239032183	0.6181	N/A	-99	False	0.03	ssdf_stellarity	N/A	N/A	N/A	N/A	False	2.63670692084	0.139798689993	22.8473453522	0.0575659349561	False	6.66784419248	0.239615636319	21.8400363922	0.0390170142055	False	9.95611151155	0.353968943747	21.4047756195	0.0386011041701	False	14.2555830763	0.744845784633	21.0150375366	0.0567290745676	False	14.6972376881	1.71312137799	20.9819107056	0.126554250717	False	21.4873504639	6.86459112167	20.5695419312	0.346861541271	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	37.3258781433	10.3032188416	19.9699745178	0.299700319767	False	60.15	4.46	19.451912	0.08050513	False	42.76	4.18	19.822403	0.10613605	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	24184.955	6277.5254	False	18965.537	7731.962	False	7944.377	8562.105	True	65.6137286253	21.403508876	29100898134.6	9484985102.84	2.18578769282e+38	5.86081747351e+37	1.93572313659e+38	5.31818550704e+37	0.309279284821	0.825721596062	0.329995592594	0.305600347472	False	False	7	7
SSDF	HELP_J231445.649-563912.828	348.690204653	-56.6535632131	755885643	0.0130012141244	0.7594	N/A	-99	False	0.488293	des_stellarity	N/A	N/A	N/A	N/A	False	0.361952754484	0.105380509435	25.003370285	0.316105991602	False	0.807402609915	0.181235961709	24.1322746277	0.24371291697	False	2.41879175878	0.26942659244	22.9410037994	0.120938979089	False	3.73149429508	0.569927655981	22.470293045	0.16582930088	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	N/A	N/A	N/A	N/A	False	28.27	3.42	20.271683	0.13134834	False	23.89	3.22	20.45446	0.14634034	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	11693.768	5469.8457	False	19442.695	8669.818	False	7953.094	8530.055	True	38.2845977346	20.4811258074	42368471205.7	13438353090.1	1.48945153044e+38	5.79849673586e+37	1.43389378022e+38	3.41648502294e+37	0.108016530041	1.59657094619	0.30523620875	1.59110090552	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