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/AJ/159/273
  Taurus members & nonmembers with K2 data (Rebull+, 2020)
Post annotation
img(gal)
1.J/AJ/159/273/table2Periods and supporting data for Taurus members with K2 light curves (217 rows) (released 2022-05-03)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
ShowSortColumn  Constraint Explain   (UCD)
  recno  Record number assigned by the VizieR team. Should Not be used for identification. (meta.record)
  EPIC   [210509151/248180268] EPIC identifier (meta.id;meta.main)
  RAJ2000 "h:m:s" (i) [04/05] Hour of right ascension (J2000) (pos.eq.ra;meta.main)
  DEJ2000 "d:m:s" (i) [14/27] Degree of declination (J2000) (pos.eq.dec;meta.main)
  OName (char) Other target identifier (meta.id)
  Gaia (char) Gaia DR2 identifier (meta.id)
  Vmag mag (n) [6.92/24.92] Apparent V band Vega magnitude (phot.mag;em.opt.V)
  Ksmag mag [5.32/15.44] Apparent Ks band Vega magnitude (phot.mag;em.IR.K)
  (V-Ks)o mag (n) [0.08/11.58] Observed (V-Ks) color (phot.color;em.opt.V;em.IR.K)
  (V-Ks)u mag [0.08/15.74] Used (V-Ks) color (Note 1)   (phot.color;em.opt.V;em.IR.K)
  E(V-Ks) mag [0/14.3] Adopted (V-Ks) color excess (2) (If flag on E(V-Ks) is 4, E(V-Ks) is a fixed value) (Note)   (phot.color;em.opt.V;em.IR.K)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  f_E(V-Ks)  Origin of E(V-Ks) leading to (V-Ks)0 (Note G2)   (phot.color;em.opt.V;em.IR.K)
  Ksmag0 mag [4.15/15.37] Inferred dereddended Ks Vega magnitude (Note 2)   (phot.mag;em.IR.K)
  (V-Ks)0 mag [-0.48/9.8] Inferred dereddended (V-Ks) color (Note 3)   (phot.color;em.opt.V;em.IR.K)
  r_mag  References for magnitudes (Note G1)   (meta.ref)
  P1 d (n) [0.18/28] Primary period (Note 4)   (time.period)
  P2 d (n) [0.05/16] Secondary period (time.period)
  P3 d (n) [0.31/12] Tertiary period (time.period)
  P4 d (n) [0.18/0.27] Quaternary period (time.period)
  Member (char) Membership classification (Note 5)   (src.class)
  IRexcess (char) Presence of an IR excess (meta.code)
  IRexStr (char) um Minimum wavelength where IR excess is detected (Note 6)   (em.wl;stat.min;em.IR)
  Slope  (n) [-2.89/1.94] SED slope (Note 7)   (spect.index)
  Class (char) SED class; I, flat, II, or III (meta.code.class)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  dip (char) LC matches dipper characteristics (Note 8)   (meta.code)
  burst (char) LC matches burster characteristics (Note 8)   (meta.code)
  mult (char) Single or multi-period star flag (meta.code.multip)
  dd (char) LC and power spectrum matches double-dip characteristics (Note 8)   (meta.code)
  ddmove (char) LC and power spectrum matche moving double-dip characteristics (Note 8)   (meta.code)
  shape (char) LC matches shape changer characteristics (Note 8)   (meta.code)
  beat (char) LC has beating visible (Note 8)   (meta.code)
  complex (char) Power spectrum has a complex, structured peak and/or wide peak (Note 8)   (meta.code)
  closep (char) Power spectrum has resolved close peaks (Note 8)   (meta.code)
  distp (char) Power spectrum has resolved distant peaks (Note 8)   (meta.code)
  pulse (char) Power spectrum and LC match pulsator characteristics (Note 8)   (meta.code)
  SimbadName (char) (n)Designation understandable by the Simbad data-base (meta.id)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/V-3.err (2025-08-23T22:34:24)
-3
-source=J/AJ/159/273/table2
-ref=VIZ68aa41f1322d18
elapse time 1

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


Contents of error file (/tmp/V-3.err):
-rwxr-xr-x 1 root root 963736 Jun 11 08:12 /srv/httpd/bin/vizier
vizier -- Version 7.5.1
cgiprint -- version 9.68 (2016-01-16)
aviz@VIZIR'):
[1755988464]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAkwdef' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=11 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   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 = 'METAfilter'
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   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 = 'METAsed'
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51590273 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51590273 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51590273 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select catid, morid, text From METAmor where catid=51590273 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590273 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=9 and fltrid=8
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590273 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51590273 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1755988464]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51590273 and tabid=1

====Contents of more_defs:
(nil)
====argColors='(nil)'

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtime' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and  tabid=52 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select catid, tabid, colid, time_syst_id, scale_name, frame_name, time_systematic_err, name, description, time_offset, time_uncertainty, time_representation, id, id From METAtime where catid=51590273 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51590273 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51590273 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZIR'):
[1755988465]    Update METAhit set etime=809303665,  Ncalls = Ncalls+1 where catid=51590273 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1755988465]    UPDATE METAstat set nlocal=nlocal+1, tlocal=809303665 Where phase=3 and catid=51590273
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/AJ/159/273/table2): show_status = (28, 8, 0, 0, 0)
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=747
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=720
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=1255
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=377
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=1374
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=104
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=14
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=2
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=920
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=325
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=288
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=1326
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=63
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=93
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1755988465]   Select famid, name, explain From METAfam where famid=106
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/159/273/table2
     [u] -ref=VIZ68aa41f1322d18
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')
----db1_close(1 'metaviz@VIZIR')

Cite/acknowledge VizieR catalogue
Rules of usage of VizieR data

© Université de Strasbourg/CNRS

    • Contact