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/ApJ/889/74
  Spitzer follow-up of Y brown dwarfs (Meisner+, 2020)
Post annotation
img(gal)
1.J/ApJ/889/74/bdcandWISE and Spitzer photometry (Table 1) and linear motion fitting results (Table 7) (169 rows) (released 2023-01-09)
[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)
  Npos  (n)Number of W2 positions used (link to Table 3) (meta.number)
  Name (char) (i) Source identifier (meta.id;meta.main)
  m_Name (char) [SN] Components on Name (meta.code.multip)
  NIR  (n)Display NIR data for this source (link to Table 9) (meta.ref.url)
  img  (n)Display data for this motion-confirmed target with Spitzer imaging available (link to Table 11) (meta.ref.url)
  f_Name (char) [b] Flag on Name (Note 1)   (meta.code)
  rpos  (n)Display the recalibrated Spitzer ch2 positions (link to Table 4) (meta.ref.url)
  Motion? (char) Motion confirmed? (yes=114 occurrences) (meta.code)
  l_W1mag (char) Limit flag on W1mag (meta.code.error)
  W1mag mag [15.71/19.42] WISE 3.4 micron band magnitude (phot.mag;em.IR.3-4um)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_W1mag mag (n) [0.02/0.6] Uncertainty in W1mag (stat.error;phot.mag)
  f_W1mag (char) [a] Flag on W1mag (Note 1)   (meta.code)
  W2mag mag [14.46/16.84] WISE 4.6 micron band magnitude (phot.mag;em.IR.4-8um)
  e_W2mag mag [0.015/0.3] Uncertainty in W2mag (stat.error;phot.mag)
  l_W1-W2 (char) Limit flag on W1-W2 (meta.code.error)
  W1-W2 mag [1.15/3.3] WISE (W1-W2) color (phot.color;em.IR;em.IR)
  e_W1-W2 mag (n) [0.025/0.6] Uncertainty in W1-W2 (stat.error)
  AOR (char) Spitzer AOR identifier (meta.id;obs)
  3.6mag mag (n) [15.21/19.52] Spitzer/IRAC 3.6um band magnitude (phot.mag;em.IR.3-4um)
  e_3.6mag mag (n) [0.016/0.5] Uncertainty in 3.6mag (stat.error)
  4.5mag mag (n) [14.43/18.01] Spitzer/IRAC 4.5um band magnitude (phot.mag;em.IR.4-8um)
  e_4.5mag mag (n) [0.017/0.08] Uncertainty in 4.5mag (stat.error)
  3.6-4.5 mag (n) [0.33/3.71] Spitzer/IRAC 3.6-4.5 band color (phot.color;em.IR;em.IR)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  e_3.6-4.5 mag (n) [0.024/0.5] Uncertainty in 3.6-4.5 (stat.error)
  Method (char) Search method (Note 2)   (meta.code)
  RA_ICRS deg (i) Right Ascension in decimal degrees (ICRS) at Ep=MJD (pos.eq.ra;meta.main)
  DE_ICRS deg (i) [-84/79.6] Declination in decimal degrees (ICRS) at Ep=MJD (pos.eq.dec;meta.main)
  e_RA_ICRS mas [21/223] Uncertainty in RAdeg (stat.error;pos.eq.ra)
  e_DE_ICRS mas [20/238] Uncertainty in DEdeg (stat.error;pos.eq.dec)
  MJD d [53261.59/58656.23] MJD (time.epoch)
  pmRA mas/yr [-1254/1138] Proper motion along RA (pos.pm;pos.eq.ra)
  e_pmRA mas/yr [16/186] Uncertainty in pmRA (stat.error;pos.pm;pos.eq.ra)
  pmDE mas/yr [-2387/518] Proper motion along DE (pos.pm;pos.eq.dec)
  e_pmDE mas/yr [17/190] Uncertainty in pmDE (stat.error;pos.pm;pos.eq.dec)
  pmTot mas/yr [9/2697] Total proper motion (pos.pm)
  e_pmTot mas/yr [17/189] Uncertainty in pmTot (stat.error)
  Chi2MM   [0.1/2684.6] Significance of motion metric (stat.fit.goodness)
  Chi2  (n) [0.0/54.35] Model χ2 (stat.param;meta.modelled)
  dof   [0/20] Number of degrees of freedom (meta.number)
  rChi2  (n) [0.0/14.92] Reduced χ2 (Note 4)   (meta.note)
  CatWISE  (n)Display data from the CatWISE2020 catalog (II/365) within 5" (meta.ref.url)
  Simbad  ask the Simbad data-base about this object (meta.ref.url)

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-04-10T08:40:21)
-3
-source=J/ApJ/889/74/bdcand
-ref=VIZ67f783f59b83
elapse time 0

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 963696 Apr  9 17:03 /srv/httpd/bin/vizier
vizier -- Version 7.5
cgiprint -- version 9.68 (2016-01-16)
[1744274421]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=703 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18890074 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18890074 and tabid=3
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18890074 and tabid=4
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=9 and fltrid=8
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=222 and fltrid=8
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=222 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=222 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18890074 and tabid=5
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=18890074 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=18890074 and tabid=1

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   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'):
[1744274421]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   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'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   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=18890074 and tabid=1
#...meta_close(1): retrieved 1/1000 tuples [tested=1]
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtimeRel' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   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=49 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=18890074 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=18890074 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18890074 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   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'):
[1744274421]    Update METAhit set etime=797589621,  Ncalls = Ncalls+1 where catid=18890074 and hstid=-1 and btime=796829400
------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1744274421]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797589621 Where phase=3 and catid=18890074
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/ApJ/889/74/bdcand): show_status = (37, 5, 0, 0, 1)
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=67
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=108
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=105
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=103
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=101
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=920
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=667
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=90
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=330
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1142
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=353
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1354
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=361
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=79
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=151
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select famid, name, explain From METAfam where famid=1349
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744274421]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/ApJ/889/74/bdcand
     [u] -ref=VIZ67f783f59b83
====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