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²
CDFS-SWIRE	HELP_J033133.806-271709.297	52.8908569016	-27.2859158413	589126227	0.00773627918657	N/A	N/A	-99	False	0.96	swire_stellarity_ira	N/A	N/A	N/A	N/A	False	0.893077148496	0.119868326086	24.0227775574	0.145726919174	False	2.65982402981	0.149310454103	22.8378677368	0.060948304832	False	5.38493821979	0.276831446494	22.0720481873	0.055816039443	False	6.97341918945	0.312590330839	21.7913856506	0.0486691817641	False	8.97542285919	0.295189887285	21.5173625946	0.0357084386051	False	12.064242363	0.403087079525	21.1962490082	0.0362763144076	False	16.8125705719	0.678852200508	20.8359146118	0.0438394844532	False	N/A	N/A	N/A	N/A	False	23.6150035858	0.882076501846	20.4670295715	0.0405548252165	False	25.345884633	0.619536956458	20.3902313656	0.0265389712592	N/A	18.070643843	0.848845727581	20.757565934	0.051001090315	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	110.7444	9.564728	False	13986.409	17259.297	True	37539.37	21848.75	False	5924.228	1661.9951	False	6516.523	2309.769	False	10936.929	5493.6406	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	False	False	7	7
CDFS-SWIRE	HELP_J033138.781-271727.153	52.91158721	-27.290875706	589125885	0.00742102717973	0.6166	N/A	-99	False	0.98	servs_stellarity_ira	N/A	N/A	N/A	N/A	False	2.31770569858	0.142890848608	22.9873542786	0.0669376477599	False	7.46684359523	0.178349325958	21.7171573639	0.0259333569556	False	15.385966637	0.327872310192	20.9321880341	0.0231368523091	False	19.3140106201	0.314233869314	20.6853179932	0.0176646411419	False	26.9565925598	0.296277493238	20.3233375549	0.0119332298636	False	37.1541519165	0.405312240124	19.974981308	0.0118442270905	False	57.2656288147	0.681481420994	19.5052642822	0.0129206487909	False	N/A	N/A	N/A	N/A	False	84.6684265137	0.886684834957	19.080696106	0.0113703049719	False	89.8059651899	0.544308314045	19.016737038	0.00658057893882	N/A	56.6760090411	0.706229836915	19.5165018477	0.0135291689692	N/A	58.62	3.86	19.4798854647	0.0714933768401	N/A	34.51	3.1	20.0551376018	0.0975306356056	N/A	178.80104	10.467377	False	21412.719	19969.719	True	18148.576	18269.568	True	9992.251	2762.4644	False	6955.579	3461.4465	False	5390.0576	5778.3467	True	15.3996272434	0.769981362172	54116321472.2	2705816073.61	6.51363791214e+37	3.31821347595e+36	7.82733002357e+37	2.15799633509e+37	5.62446741937	1.45907290418	4.62766337329	0.0853342348746	False	False	7	7
CDFS-SWIRE	HELP_J033136.360-271659.022	52.90149799	-27.283061756	589126228	0.00751015061785	0.5471	N/A	-99	False	0.95	servs_stellarity_ira	N/A	N/A	N/A	N/A	False	1.59225280973	0.154504897168	23.3949699402	0.105354852974	False	8.72195232593	0.193418380858	21.5484657288	0.0240773316473	False	17.2850663529	0.36082696429	20.8058223724	0.0226648189127	False	23.3236465454	0.314906477928	20.4805088043	0.0146591737866	False	30.8391456604	0.29675129056	20.1772441864	0.010447553359	False	40.818813324	0.406261593103	19.8728485107	0.0108061181381	False	58.5709877014	0.682650089264	19.4807929993	0.0126543520018	False	N/A	N/A	N/A	N/A	False	77.4895477295	0.88861978054	19.1768913269	0.0124507974833	False	61.8424277895	0.608946181663	19.4217836734	0.0106909599091	N/A	45.2826196068	0.873545756903	19.7601711427	0.0209449069647	N/A	21.1	2.46	20.5892938618	0.126583462735	N/A	19.48	2.21	20.6760276186	0.123176438014	N/A	42.65455	9.249252	False	22237.205	21464.537	True	15000.865	15211.689	True	4328.3643	1435.5923	False	5771.7603	1725.5708	False	12855.196	4472.082	False	5.77954113673	0.288977056836	34826940990.9	1741347049.54	2.25768706526e+37	1.12884353263e+36	3.27217583571e+37	8.88036563079e+36	12.0133073765	16.7424602927	12.1582506791	4.45847256265	False	False	7	7
CDFS-SWIRE	HELP_J033141.235-272051.277	52.9218118913	-27.3475770384	589125828	0.00817609497625	N/A	N/A	-99	False	0.89	servs_stellarity_ira	N/A	N/A	N/A	N/A	False	2.77281950487	0.163431974827	22.7926959991	0.0639940723777	False	5.81200349385	0.205547734402	21.9891853333	0.0383982248604	False	10.1117542811	0.380348216021	21.3879337311	0.0408393852413	False	12.411816597	0.314590007067	21.1654109955	0.0275190789253	False	14.9520339966	0.296550273895	20.9632492065	0.0215338841081	False	18.7598819733	0.405729353428	20.7169246674	0.0234817620367	False	25.134677887	0.682195901871	20.3993167877	0.0294686425477	False	N/A	N/A	N/A	N/A	False	35.796585083	0.88719522953	20.0153961182	0.0269092731178	False	41.16790796	0.668740144589	19.8636030052	0.0176369269787	N/A	28.8533594748	0.709373695558	20.2495090337	0.02669334587	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	250.6659	11.997787	False	53115.19	25883.002	False	30371.842	23712.479	False	11017.037	2598.0527	False	4628.688	2810.5923	False	2720.3142	3356.5798	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
CDFS-SWIRE	HELP_J033142.660-272048.956	52.92775069	-27.346932156	589125743	0.00809122175757	0.3433	N/A	-99	False	0.03	servs_stellarity_ira	N/A	N/A	N/A	N/A	False	5.0612716039	0.191171973274	22.1393508911	0.0410099178553	False	12.3150000439	0.240835456844	21.1739139557	0.0212329495698	False	16.1812188029	0.444564034535	20.8774719238	0.0298295989633	False	19.2325191498	0.319254994392	20.6899089813	0.018022948876	False	21.5189418793	0.299612700939	20.5679473877	0.0151169318706	False	23.7852897644	0.411853581667	20.4592285156	0.0188000388443	False	27.8302841187	0.689742982388	20.2887058258	0.0269087776542	False	N/A	N/A	N/A	N/A	False	30.9940738678	0.89997190237	20.1718025208	0.0315264165401	False	18.9647321504	0.589470658121	20.7051332168	0.0337473595772	N/A	16.973399931	0.777817546729	20.8255778893	0.0497545968759	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	101.351845	10.290886	False	22509.463	18623.033	True	20040.158	17832.748	True	6488.576	2155.664	False	2225.9941	1830.551	True	2344.0002	2794.4553	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
CDFS-SWIRE	HELP_J033144.394-272106.652	52.93497416	-27.351847846	589125741	0.0080777080916	0.595	N/A	-99	False	0.97	servs_stellarity_ira	N/A	N/A	N/A	N/A	False	2.56624487881	0.140988189418	22.8767547607	0.0596497952938	False	9.09832904875	0.178354367109	21.5025959015	0.0212836656719	False	18.9206692061	0.329614960945	20.7076587677	0.0189144946635	False	25.3364696503	0.314729571342	20.3906345367	0.0134870121256	False	33.7810173035	0.297401070595	20.0783176422	0.0095585975796	False	43.8684043884	0.407394170761	19.7946205139	0.0100829424337	False	62.6543617249	0.683811426163	19.4076213837	0.01184975449	False	N/A	N/A	N/A	N/A	False	86.9732894897	0.89059138298	19.0515346527	0.0111177498475	False	85.4796106648	0.551990904302	19.0703436615	0.00701122179707	N/A	55.1613785324	0.817251387245	19.5459122224	0.016085881882	N/A	42.27	4.8	19.8349193804	0.123291549156	N/A	18.89	2.61	20.7094201052	0.150014372388	N/A	265.6338	11.047699	False	22094.176	20691.168	True	41271.293	22661.508	False	6762.8936	1789.1191	False	5244.3047	2099.895	False	2958.72	3164.9119	True	13.0508556414	0.652542782068	76843191860.0	3842159593.0	5.91333915406e+37	2.95666957703e+36	5.51968307139e+37	1.55775301782e+37	4.5390233044	1.40403624827	3.60942432139	1.09257434886	False	False	7	7
CDFS-SWIRE	HELP_J033144.530-272033.620	52.93554033	-27.342672276	589125754	0.00792757538594	0.6225	N/A	-99	False	0.85	swire_stellarity_ira	N/A	N/A	N/A	N/A	False	2.75350012998	0.155483286173	22.8002872467	0.0613088160753	False	10.3070264926	0.194196606222	21.3671665192	0.0204565580934	False	24.9272574721	0.359440546078	20.4083137512	0.0156558584422	False	34.0797157288	0.316447645426	20.0687599182	0.0100816171616	False	46.924030304	0.297341734171	19.7215118408	0.00687994388863	False	61.7208633423	0.407327383757	19.4239196777	0.00716532533988	False	87.0943603516	0.684564173222	19.0500240326	0.00853391736746	False	N/A	N/A	N/A	N/A	False	127.320396423	0.891211748123	18.6377544403	0.0075998888351	False	160.57659596	0.798575172813	18.3857943822	0.00539955385255	N/A	106.83905018	0.985016792677	18.828174954	0.0100100889357	N/A	93.88	5.08	18.9685672977	0.0587509578203	N/A	140.8	6.96	18.528493363	0.053669914667	N/A	998.0874	11.579895	False	32140.3	21539.484	False	55046.504	22082.879	False	22186.193	1402.4395	False	14956.417	1718.3838	False	9970.892	3400.2563	False	55.2645494562	3.18203585213	1.89886475142e+11	9494323757.09	2.75722683993e+38	1.37861341996e+37	1.69330607874e+38	4.52409326453e+37	1.10782939165	1.3976597424	1.12790716413	0.894797777206	False	False	7	7
CDFS-SWIRE	HELP_J033145.699-272037.480	52.94041082	-27.343744386	589125754	0.00788470965849	0.6253	N/A	-99	False	0.61	swire_stellarity_ira	N/A	N/A	N/A	N/A	False	1.97323302421	0.161082289202	23.1620540619	0.0886326506734	False	5.81446465816	0.203699095665	21.9887256622	0.0380367748439	False	11.0409072289	0.377234285772	21.2924880981	0.0370963104069	False	13.4996929169	0.313454151154	21.0741901398	0.0252100937068	False	17.5107307434	0.295146733522	20.7917385101	0.0183002930135	False	22.7271995544	0.402896672487	20.5086345673	0.0192473996431	False	31.9176368713	0.679542601109	20.1399230957	0.0231158714741	False	N/A	N/A	N/A	N/A	False	43.094165802	0.881610155106	19.8139533997	0.0222117323428	False	43.8003726961	0.635735429661	19.7963054852	0.0157587922235	N/A	29.2048723289	0.806290714316	20.2363617199	0.029975101765	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	81.757744	10.116768	False	29866.254	21384.105	True	12843.188	15273.425	True	8894.825	1523.6821	False	7793.9326	1938.1909	False	6440.255	3500.3862	False	10.354060196	0.5177030098	36302513749.4	1815125687.47	4.3661298101e+37	2.18306490505e+36	7.0491488082e+37	1.86012784909e+37	0.478011584669	6.92332402608	1.92862125748	1.20696167609	False	False	7	7
CDFS-SWIRE	HELP_J033145.872-272001.636	52.94113301	-27.333787786	589125841	0.00771802362152	0.4436	N/A	-99	False	0.95	servs_stellarity_ira	N/A	N/A	N/A	N/A	False	2.90256824868	0.113328896106	22.7430438995	0.0423918664455	False	4.07778378254	0.14217417719	22.3739395142	0.0378547906876	False	6.08265052412	0.262851395354	21.9397678375	0.0469182431698	False	6.76852321625	0.310221165419	21.823764801	0.0497624576092	False	6.76256608963	0.293510913849	21.8247203827	0.0471234470606	False	9.59972572327	0.399632185698	21.4443531036	0.0451987050474	False	9.33078670502	0.67507827282	21.4752044678	0.0785525366664	False	N/A	N/A	N/A	N/A	False	11.6840295792	0.87505209446	21.2310180664	0.0813140496612	False	15.9072811925	0.672604287505	20.8960101046	0.045907959857	N/A	9.91227987395	0.534707037905	21.4095661103	0.0585688456516	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	153.02164	9.653305	False	12272.794	14364.892	True	11096.547	14178.779	True	4469.1265	2079.3008	False	2402.3005	2055.5515	True	4643.2886	3950.6187	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
CDFS-SWIRE	HELP_J033146.739-272022.647	52.94474726	-27.339624166	589125755	0.00776716306104	0.3044	N/A	-99	False	0.41	swire_stellarity_ira	N/A	N/A	N/A	N/A	False	21.157706944	0.228284652122	20.5863285065	0.0117147341371	False	39.5182161894	0.287169883599	19.9080066681	0.00788979791105	False	44.6447615598	0.524266047556	19.7755737305	0.0127498637885	False	55.971786499	0.319855481386	19.5300769806	0.00620453059673	False	55.467376709	0.297897785902	19.5399055481	0.00583114707842	False	60.1411819458	0.40853574872	19.4520702362	0.0073753464967	False	63.3566360474	0.688879072666	19.3955192566	0.0118052503094	False	N/A	N/A	N/A	N/A	False	73.4079589844	0.893775641918	19.2356414795	0.0132193379104	False	37.8275961807	0.787580608984	19.9554781395	0.022605316427	N/A	34.9078268292	0.803528622029	20.0426929679	0.0249921062335	N/A	N/A	N/A	N/A	N/A	N/A	37.7	4.37	19.9591466245	0.125853241772	N/A	66.39282	8.39513	False	18215.955	19502.076	True	8037.4043	12160.27	True	4796.8804	1722.5967	False	3265.321	1844.4504	True	1153.5579	1571.5583	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

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