Simple TargetList Of TargetsFast Xmatch with large catalogs or Simbad
Target Name (resolved by Sesame) or Position:
Target dimension:
NB: The epoch used for the query is the original epoch of the table(s)Radius Box size

  
J/A+A/645/A42
  Flares in 5 open clusters (Ilin+, 2021)
Post annotation
img(gal)
1.J/A+A/645/A42/stars(c)Stellar parameters (2111 rows) (released 2021-09-10)
[METAtab] [METAcola]
2.J/A+A/645/A42/flaresStellar flares law fit parameters (table 2) (3844 rows) (released 2021-09-10)
[METAtab] [METAcola]
3.J/A+A/645/A42/ffdsFlare frequency distributions and power law fit parameters (table 3) (22 rows) (released 2021-09-10)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - )
ShowSortJoin tables
more join
Column  Constraint Explain   (UCD)
  (ALL)recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  (1)Flares (char) indicates flares data in table flares.dat (meta.ref.url)
   (1+2)ID  (i) EPIC ID (meta.id;meta.main)
  (1+2)Campaign  K2 observing campaign (meta.id;obs)
  (1)RAJ2000 deg (i) Right Ascension (J2000) (pos.eq.ra;meta.main)
  (1)DEJ2000 deg (i) Declination (J2000) (pos.eq.dec;meta.main)
  (1)Pmemb   [0.8/1.0] Mean membership probability (Note 1)   (stat.probability;stat.mean)
  (1)Teff K [2780/5997] Stellar effective temperature (phys.temperature.effective)
  (1)e_Teff K Uncertainty on effective temperature (stat.error;phys.temperature.effective)
  (1)R Rsun [0.13/1.15] stellar radius (phys.size.radius)
  (1)e_R Rsun Uncertainty on stellar radius (stat.error)

ALL cols
    
 (i)indexed column
  (1+2)Lbol 10-7W Projected stellar bolometric luminosity (phys.luminosity)
  (1+2)e_Lbol 10-7W Uncertainty on projected stellar bolometric luminosity (stat.error)
  (1+2)LKepler 10-7W Projected stellar luminosity in the Kepler band (phys.luminosity)
  (1+2)e_LKepler 10-7W Uncertainty on projected stellar luminosity in the Kepler band (stat.error)
  (1)Simbad (char) ask the Simbad data-base about this object (meta.ref.url)
  (2)cstart  Flare start cadence number (meta.id)
  (2)cstop  Flare end cadence number (meta.id)
  (2)tstart d Flare start time, Barycentric Kepler Julian Date (time.start)
  (2)tstop d Flare stop time, Barycentric Kepler Julian Date (time.end)
  (2)ED s [1.82/82185] Measured equivalent duration (time.duration)
  (2)e_ED s Uncertainty on ED (stat.error)
  (2)Ampl-rec   [0.0003/9.6748] Measured relative flare amplitude (src.var.amplitude)
  (2)Note (char) Note saturation of the detector (meta.note)

ALL cols
    
 (i)indexed column
  (2)dtp  Number of accepted data points in light curve (meta.number)
  (2)Teff-med K [2780/5996] Effective temperature (phys.temperature.effective)
  (2)e_Teff-med K Uncertainty on Teff-med (stat.error)
  (2+3)Cluster (char) Open cluster name (meta.id.parent)
  (3)Teffmin K [2500/5000] Minimum effective temperature in bin (phys.temperature.effective;stat.min)
  (3)Teffmax K [3000/6000] Maximum effective temperature in bin (phys.temperature.effective;stat.max)
  (3)alpha   [1.84/2.31] FFD power law index in ED space (Note 1)   (spect.index)
  (3)E_alpha  Upper uncertainty on alpha (Note 1)   (stat.error;stat.max)
  (3)e_alpha  Lower uncertainty on alpha (Note 1)   (stat.error;pos.eq.ra)
  (3)beta 1/s [0.85/4707.79] FFD intercept in ED space (Note 1)   (spect.index)
  (3)E_beta 1/s Upper uncertainty on beta (Note 1)   (stat.error;stat.max)
  (3)e_beta 1/s Lower uncertainty on beta (Note 1)   (stat.error)
  (3)Nflares   [1/970] Number of flares in bin (meta.number)

ALL cols
    
 (i)indexed column
  (3)Nfit   [1/612] Number of flares used in FFD fit (meta.number)
  (3)Age Myr [135/3639] Open cluster age (Note 2)   (time.age)
  (3)E_Age Myr Upper uncertainty on open cluster age (stat.error;stat.max)
  (3)e_Age Myr Upper uncertainty on open cluster age (stat.error;time.age)
  (3)EDmin s [9.9/1236] Minimum equivalent duration used in fit (time.interval)
  (3)EDmax s [59/82185] Maximum equivalent duration used in fit (time.interval)
  (3)alpha-en   [1.86/2.39] FFD power law index in energy space (Note 1)   (spect.index)
  (3)E_alpha-en  Upper uncertainty on alpha-en (Note 1)   (stat.error;stat.max)
  (3)e_alpha-en  Lower uncertainty on alpha-en (Note 1)   (stat.error)
  (3)beta-en 1/s [1.28E+28/4.44E+45] FFD intercept in energy space (Note 1)   (spect.index)
  (3)E_beta-en 1/s Upper uncertainty on beta_en (Note 1)   (stat.error;stat.max)
  (3)e_beta-en 1/s Lower uncertainty on beta_en (Note 1)   (stat.error)
  (3)Nflares-en   [1/970] Number of flares in bin (energy space) (meta.number)

ALL cols
    
 (i)indexed column
  (3)Nfit-en   [1/663] Number of flares used in FFD fit (energy space) (meta.number)
  (3)alphaD   [1.47/2.18] FFD power law index from Davenport et al., 2019ApJ...871..241D (spect.index)
  (3)betaD 1/s [7.29E+16/9.24E+39] FFD intercept from Davenport et al., 2019ApJ...871..241D (spect.index)
  (3)EKpmin 10-7J [9.01E+31/6.25E+33] Minimum energy used in fit (phys.energy)
  (3)EKpmax 10-7J [3.80E+32/3.01E+35] Maximum energy used in fit (phys.energy)

ALL cols
    
 (i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/V-3.err (2025-08-23T12:30:06)
-3
-source=J/A+A/645/A42
-ref=VIZ68a9b44e26201c
elapse time 0

Options: wopt=0, optS=0, onote=0, opt1=8, opos=0


Contents of error file (/tmp/V-3.err):
CDSportal=http://cdsportal.u-strasbg.fr/StoreVizierData.html
COCAT=130.79.128.31
COCATPORT=1801
CONTEXT_DOCUMENT_ROOT=/srv/httpd/local/cgi/
CONTEXT_PREFIX=/local/viz-bin/
Content=text/html
DOCKER=yes
DOCUMENT_ROOT=/srv/httpd/Pages/
GATEWAY_INTERFACE=CGI/1.1
GLUDIR=/srv/glu
GLUHOME=/srv/glu
GROUP=root
HOME=/srv/httpd
HOST=b448cffa3102
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_CACHE_CONTROL=max-age=0
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=cds:8082
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_VIA=1.1 squid-proxy-5b5d847c96-l5qcg (squid/6.10)
HTTP_X_FORWARDED_FOR=10.3.175.99, 216.73.216.136
HTTP_X_FORWARDED_HOST=viz-beta.u-strasbg.fr
HTTP_X_FORWARDED_SERVER=viz-beta.u-strasbg.fr
LC_ALL=C
LD_LIBRARY_PATH=/srv/httpd/../lib:/srv/lib:/usr/local/lib:/usr/lib
LOGNAME=root
MACHTYPE=x86_64
METADB=metaviz@VIZIR asu asu4VizieR
MOCCMD=mocset query /srv/httpd/mocs/mocset10.bin cone -p 5 
NEWS=/VizieR/+news.htx
OSTYPE=linux
PATH=/srv/httpd/bin:/usr/local/bin:/usr/bin:/bin
PATH_INFO=/
PWD=/srv/httpd/cgi
QMOCCMD=.ext-tsv/qat2s_asu --out.form tsv --noheader --out.max=999999999 --source=%s --moc=%s --out='!/_((RA)|(DE))J2000|recno/'
QUERY_STRING=-source=J%2FApJ%2F914%2F130
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=53896
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FApJ%2F914%2F130
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.17.0.3
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=cds
SERVER_PORT=8082
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=
SERVER_SOFTWARE=Apache/2.4.57 (Unix)
SESAME_SERVER=glu
SHLVL=1
USER=root
VENDOR=unknown
VSEARCH_HOST=cdsarc.cds.unistra.fr
VSEARCH_REDIRECT=http://cdsarc.cds.unistra.fr
Vaccess=*
Vprog=/srv/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 root root 963736 Jun 11 08:12 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/ApJ/914/130
################################################################

....Trying '/srv/httpd/interfaces' => OK
....Trying '/srv/httpd/interfaces' => 3
....db1_interfaces(/srv/httpd/interfaces)
----db1_open(metaviz@VIZIR) gives: 0
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdba'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAtab'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcol'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcat'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAmor'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdic'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdig'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfam'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAucd'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAauth'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select hstid, flag from METAhst where name='b448cffa3102.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/ApJ/914/130' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=19140130 and (authid=0)
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=104
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1052
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=191
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=399
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=995
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=184
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=417
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=418
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=416
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1371
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=325
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1385
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=185
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=2
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=288
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1288
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=188
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=291
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=368
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=1360
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=375
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select ucdid, name, class, explain From METAucd where ucdid=183
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755952206]   Select famid, name, explain From METAfam where famid=957
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/A+A/645/A42
     [u] -ref=VIZ68a9b44e26201c
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact