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_Gaia¹	Flag_Cleaned	Flag_Merged	Flag_OptNIR_Obs²	Flag_OptNIR_Det²
ELAIS-N1	HELP_J161331.003+543947.901	243.379180099	54.6633057368	166354878	0.00793933221972	1.0413	N/A	-99	False	0.98	SERVS_IRAC2	0.057719618082	0.00858371518552	26.9966907501	0.161464169621	False	0.061646297574	0.00431813439354	26.9252319336	0.0760524943471	False	0.270908236504	0.0104717677459	25.317943573	0.0419683717191	False	2.55080485344	0.114604979753	22.8833065033	0.0487809851766	False	1.28930699825	0.0266056861728	23.6241092682	0.022404871881	False	4.32326459885	0.566680729389	22.3104705811	0.142315089703	False	2.9367108345	0.351030707359	22.7303466797	0.129780143499	False	N/A	N/A	N/A	N/A	False	14.077706337	0.568118870258	21.0286693573	0.0438158884645	False	N/A	N/A	N/A	N/A	False	34.4108669489	0.617312668397	20.058260964	0.0194775305932	False	29.3590645127	0.791714860652	20.2306444669	0.0292786402538	False	30.22	3.57	20.19926385	0.128262020218	False	N/A	N/A	N/A	N/A	False	304.09808	15.72738	False	9555.478	8539.616	True	24204.137	13634.637	False	12295.867	2318.019	False	3509.7919	3302.9198	True	2875.0155	3809.4809	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	0	False	False	7	7
ELAIS-N1	HELP_J161331.643+543742.347	243.381845156	54.6284297428	166354841	0.0076443172197	1.2353	N/A	-99	False	0.65	SWIRE_IRAC2	N/A	N/A	N/A	N/A	False	0.456657111645	0.0572199337184	24.7510242462	0.136044636369	False	0.653218865395	0.105083890259	24.3623523712	0.174663335085	False	0.412223547697	0.136656567454	24.8621673584	0.359933316708	False	2.76594781876	0.268513172865	22.7953891754	0.105401292443	False	4.95515155792	0.704057693481	22.1623573303	0.154267922044	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	6.34656667709	0.567938745022	21.8936519623	0.0971598848701	False	N/A	N/A	N/A	N/A	False	25.76	1.04	20.3726353533	0.0438340703784	False	13.84	1.16	21.0471597747	0.0910010113815	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	50.848545	14.106163	False	7629.216	8076.6006	True	7262.787	8919.824	True	7180.246	3160.7	False	6522.7532	3614.0327	False	3669.1604	4044.0206	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	0	False	False	7	5
ELAIS-N1	HELP_J161332.125+543820.480	243.383856088	54.6390222462	166354865	0.00771454044599	N/A	N/A	-99	False	0.75	SWIRE_IRAC2	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	3.43232393265	0.501265048981	22.5610294342	0.15856359899	False	N/A	N/A	N/A	N/A	False	18.9921016693	0.851352155209	20.7035675049	0.048669911921	False	N/A	N/A	N/A	N/A	False	40.9509515229	0.876229676833	19.8693400067	0.0232315550297	False	42.1342188292	0.7829372672	19.8384126338	0.0201751298748	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	48.648823	14.212341	False	10156.554	8287.003	True	11263.472	10853.53	True	6414.0844	2562.8936	False	3231.7023	2864.831	True	3378.478	3728.134	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	0	False	False	7	6
ELAIS-N1	HELP_J161328.770+543810.001	243.369876972	54.63611134	166354864	0.00770920312952	2.1006	N/A	-99	False	0.78	SWIRE_IRAC1	N/A	N/A	N/A	N/A	False	0.107019007206	0.0545262992382	26.3263473511	0.553183794022	False	0.284128665924	0.0912469774485	25.2662124634	0.34868055582	False	0.266565024853	0.12570078671	25.3354911804	0.511987268925	False	0.0756337270141	0.259532749653	26.7032108307	3.72564077377	False	1.91522121429	0.618607521057	23.1944522858	0.350687742233	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	6.06826925278	0.973085224628	21.9423370361	0.174104645848	False	N/A	N/A	N/A	N/A	False	10.76	0.58	21.3204693217	0.0585248140111	False	13.3632889937	0.652338925468	21.0852165987	0.053001023138	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	261.05048	17.85503	False	10063.267	8264.835	True	9708.144	10330.366	True	10495.985	2781.1513	False	8899.492	3732.9414	False	6250.9184	6088.1106	False	157.737962151	40.9060114079	96139117340.7	20406849194.7	5.87675635995e+38	1.13828975754e+38	6.01783663766e+38	9.95056810963e+37	0.982094239641	0.0873942712188	0.751136365885	0.000722543346695	0	False	True	7	5
ELAIS-N1	HELP_J161327.726+543729.318	243.365525744	54.6248104335	166354831	0.00763823939011	0.2399	N/A	-99	False	0.82	SWIRE_IRAC1	0.719684183598	0.0305363237858	24.257144928	0.0460679754615	False	2.45095658302	0.0155732743442	22.9266605377	0.00689872121438	False	7.03340435028	0.0250831320882	21.7820854187	0.00387204601429	False	13.031332016	0.0517541281879	21.1125278473	0.00431201746687	False	15.778345108	0.107463106513	20.9048461914	0.00739472918212	False	19.4182853699	0.291674375534	20.6794719696	0.0163084156811	False	20.7522525787	0.763136386871	20.6073360443	0.0399265028536	False	N/A	N/A	N/A	N/A	False	30.0129547119	0.752793967724	20.2067279816	0.0272327642888	False	N/A	N/A	N/A	N/A	False	17.2935993876	0.582838374168	20.8052865146	0.0365920772288	False	14.849498446	0.837084228727	20.9707205369	0.0612042660475	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	28.45137	14.990444	False	11263.272	8069.7314	True	16735.652	10787.426	True	3397.003	1507.32	True	4459.679	1685.376	False	4882.604	3724.301	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	0	False	False	7	7
ELAIS-N1	HELP_J161326.036+543740.047	243.358481879	54.6277909495	166354853	0.00766632465391	0.8175	N/A	-99	False	0.81	SERVS_IRAC1	N/A	N/A	N/A	N/A	False	0.569069266319	0.020851995796	24.5120868683	0.0397838540375	False	1.63380622864	0.04174374789	23.3669986725	0.0277405567467	False	5.16428041458	0.0476078651845	22.1174755096	0.0100090578198	False	9.10304260254	0.108048915863	21.5020332336	0.0128871873021	False	11.4032783508	0.269559413195	21.2574253082	0.0256654638797	False	28.7870101929	0.967676579952	20.2520084381	0.0364970713854	False	N/A	N/A	N/A	N/A	False	53.7591705322	1.08219659328	19.5738677979	0.0218563638628	False	N/A	N/A	N/A	N/A	False	55.8964823959	0.631498747714	19.5315388043	0.0122662647856	False	43.637237236	0.767258895806	19.8003568832	0.019090135269	False	28.52	3.32	20.2621261971	0.126390049081	False	N/A	N/A	N/A	N/A	False	65.551414	17.541451	False	9044.016	8694.275	True	7273.6035	9126.09	True	5859.034	1646.666	False	968.96195	1256.52765	True	5373.939	4902.503	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	0	False	False	7	7
ELAIS-N1	HELP_J161326.056+543811.006	243.358566072	54.6363905051	166354855	0.00772152559057	1.0909	N/A	-99	False	0.98	SERVS_IRAC1	0.0267810951918	0.010565938428	27.8304290771	0.42835521698	False	0.131225764751	0.00529110059142	26.1049518585	0.0437775291502	False	0.210950523615	0.00908580701798	25.589548111	0.0467635206878	False	N/A	N/A	N/A	N/A	False	1.4258480072	0.0327616855502	23.5148162842	0.0249469429255	False	1.16643667221	0.796933352947	23.7328472137	0.741797149181	False	3.05676078796	0.769066870213	22.6868457794	0.273166209459	False	N/A	N/A	N/A	N/A	False	10.4086303711	0.570518910885	21.3565158844	0.0595114864409	False	N/A	N/A	N/A	N/A	False	18.8226117321	0.53647612989	20.7133002905	0.0309453101142	False	18.133517067	0.482834024593	20.7537948865	0.0289094707581	False	N/A	N/A	N/A	N/A	False	N/A	N/A	N/A	N/A	False	85.59559	14.49003	False	9319.89	7191.0596	True	15396.844	11053.168	True	8607.608	1596.4343	False	6592.6113	2041.1537	False	4098.6776	3962.1834	False	28.1542393383	5.76789083104	57085432622.4	8156804022.67	1.31147599509e+38	2.36954093289e+37	1.62036860392e+38	3.43263974983e+37	3.06973233069	0.331395325025	2.12933708124	0.00979960698459	0	False	False	7	7
ELAIS-N1	HELP_J161328.462+543852.560	243.368592349	54.6479333215	166354873	0.0077980054265	0.4189	N/A	-99	False	0.999664	SPARCS	483.954376221	0.22695286572	17.1879882812	0.000509161502123	False	151.983200073	0.0799218416214	18.4455108643	0.000570944917854	False	462.216278076	0.156160190701	17.2378864288	0.000366816995665	False	1406.43695675	0.854948389031	16.0296993256	0.000660000019707	False	574.601196289	0.299949079752	17.0015830994	0.000566767994314	False	1370.50266005	4.08726130756	16.057800293	0.00323799997568	False	1342.42016602	3.68208813667	16.0802783966	0.0029780366458	False	N/A	N/A	N/A	N/A	False	746.177734375	2.52134656906	16.7178936005	0.00366872013547	False	N/A	N/A	N/A	N/A	False	381.974901065	1.05970554193	17.4449129323	0.00301213684473	False	268.841651267	1.3792866293	17.8262586144	0.00557034753771	False	162.07	5.82	18.3757434197	0.0389892312685	False	70.52	4.58	19.2792192409	0.0705143479551	False	135.21492	16.03722	False	13845.003	8400.985	False	9150.057	10082.709	True	7037.55	2074.191	False	4542.153	2575.43	False	5231.4205	5475.6725	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	3	False	False	7	7
ELAIS-N1	HELP_J161328.566+543838.886	243.369026692	54.6441351015	166354866	0.00776842296234	0.4921	N/A	-99	False	0.6	SWIRE_IRAC1	3.40320801735	0.0304246861488	22.5702781677	0.00970648322254	False	5.59290266037	0.0180831365287	22.0309066772	0.0035104341805	False	11.6624708176	0.0301888715476	21.2330226898	0.00281048077159	False	17.9535522461	0.0736579969525	20.764623642	0.00445444742218	False	24.1727752686	0.118374988437	20.4416828156	0.00531689077616	False	31.0241699219	0.353205889463	20.1707496643	0.0123609555885	False	25.0249176025	0.752743184566	20.4040679932	0.0326586700976	False	N/A	N/A	N/A	N/A	False	41.4104804993	0.835162818432	19.8572235107	0.0218970309943	False	N/A	N/A	N/A	N/A	False	36.12	0.99	20.0056306459	0.0297585504626	False	37.45	1.3	19.9663704449	0.0376891072413	False	N/A	N/A	N/A	N/A	False	47.45	3.15	19.7094094581	0.0720773244465	False	189.23294	16.44434	False	7856.6787	7482.7373	True	15847.218	11929.565	True	14125.031	1950.757	False	9142.96	2676.8054	False	6386.4994	4721.3146	False	7.71127544839	0.957192132435	17195764393.3	2557312328.15	2.55868547145e+37	1.56780577985e+36	7.76038759408e+37	2.3152676725e+37	1.7136931801	4.63913048985	2.12914131946	0.308751428213	0	False	False	7	7
ELAIS-N1	HELP_J161325.332+543904.215	243.355550394	54.6511707125	166354874	0.00782644503472	0.511	N/A	-99	False	0.999999	WFC	1.49153864384	0.0227727629244	23.4659137726	0.0165769848973	False	10.2971773148	0.0220125894994	21.3682041168	0.00232101138681	False	30.4029273987	0.027438338846	20.1927108765	0.000979866134003	False	114.393119812	3.05543875694	18.7539997101	0.0289999991655	False	280.162872314	0.114320777357	17.7814731598	0.000443035882199	False	N/A	N/A	N/A	N/A	False	375.464599609	1.99435949326	17.4635772705	0.00576711725444	False	N/A	N/A	N/A	N/A	False	315.567871094	1.70502531528	17.6522674561	0.00586627423763	False	N/A	N/A	N/A	N/A	False	218.94	1.71	18.0491872156	0.00847998954114	False	149.91	1.61	18.4604234896	0.0116605649367	False	118.61	5.22	18.7146967352	0.0477830114563	False	59.73	4.32	19.4595187131	0.078526375432	False	27.29603	14.87981	False	4635.5464	6185.321	True	4700.3013	6602.0757	True	6232.7867	3102.4886	False	1420.9659	1698.7553	True	1282.0437	2072.5448	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	3	False	True	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