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/ApJS/239/14
  Revised exoplanet radii from Gaia DR2 (Johns+, 2018)
Post annotation
img(gal)
1.J/ApJS/239/14/table2(c)Host star properties; all parameters are taken from Gaia DR2 (750 rows) (released 2023-10-24)
[METAtab] [METAcola]
2.J/ApJS/239/14/table3(c)Revised properties of exoplanets (807 rows) (released 2023-10-24)
[METAtab] [METAcola]
Help Xmatch is

 
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)Host (char) Host name (meta.id;meta.main)
  (1)Lum Lsun (n) [0.04/1244.2] Host luminosity, solar units (phys.luminosity)
  (1)E_Lum Lsun (n) [0/97.2] Upper uncertainty in Lum (stat.error;stat.max)
  (1)e_Lum Lsun (n) [-97.2/0] Lower uncertainty in Lum (stat.error)
  (1)Rad Rsun (n) [0.5/78.2] Host radius, solar units (phys.size.radius)
  (1)E_Rad Rsun (n) [0.003/8.5] Upper uncertainty in Rad (stat.error;stat.max)
  (1)e_Rad Rsun (n) [-13.2/-0.003] Lower uncertainty in Rad (stat.error)
  (1)Teff K [3382/9435] Host effective temperature (phys.temperature.effective)
   (ALL)SimbadName (char) (n)Designation understandable by the Simbad data-base (meta.id)
   (ALL)_RA deg (n)(i) Right Ascension (J2000) from SIMBAD (not part of the original data) (pos.eq.ra;meta.main)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
   (ALL)_DE deg (n)(i) Declination (J2000) from SIMBAD (not part of the original data) (pos.eq.dec;meta.main)
  (2)Planet (char) Planet Name (meta.id;meta.main)
  (2)Rad Rjup (n) [0.1/2.9] Planet Radius (phys.size.radius)
  (2)E_Rad Rjup (n) [0.01/1.8] Upper uncertainty in Rad (stat.error;stat.max)
  (2)e_Rad Rjup (n) [-1.8/-0.01] Lower uncertainty in Rad (stat.error)
  (2)Mass Mjup (n) [0.01/55.6] Planet Mass (Note 1)   (phys.mass)
  (2)E_Mass Mjup (n) [0/78.6] Upper uncertainty in Mass (stat.error;stat.max)
  (2)e_Mass Mjup (n) [-78.6/0] Lower uncertainty in Mass (stat.error;phys.mass)
  (2)rho g/cm3 (n) [0.04/26] Planet Density (phys.density)
  (2)E_rho g/cm3 (n) [0.01/27.1] Upper uncertainty in rho (stat.error;stat.max)
  (2)e_rho g/cm3 (n) [-27/-0.01] Lower uncertainty in rho (stat.error)
  (2)a au (n) [0.01/773] Semi-major axis (Note 1)   (phys.size.smajAxis;src.orbital)
  (2)E_a au (n) [0/30] Upper uncertainty in a (stat.error;stat.max)
  (2)e_a au (n) [-30/0] Lower uncertainty in a (stat.error)
  (2)Sinc Earth (n) [0/19317] Planet Incident Flux (phot.flux;arith.ratio)
  (2)E_Sinc Earth (n) [0/3395] Upper uncertainty in Sinc (stat.error;stat.max)
  (2)e_Sinc Earth (n) [-3388/0] Lower uncertainty in Sinc (stat.error)

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-24T14:50:03)
-3
-source=J/ApJS/239/14
-ref=VIZ68ab269b6684d
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 963736 Jun 11 08:12 /srv/httpd/bin/vizier
vizier -- Version 7.5.1
cgiprint -- version 9.68 (2016-01-16)
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21470061 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=21470061 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=221
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=1052
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=225
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=1070
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=175
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=940
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=222
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=1056
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select ucdid, name, class, explain From METAucd where ucdid=9
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756047003]   Select famid, name, explain From METAfam where famid=582
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/ApJS/239/14
     [u] -ref=VIZ68ab269b6684d
====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