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/742/L19
  Physics of Kepler hot rocky planetary candidates (Miguel+, 2011)
Post annotation
img(gal)
1.J/ApJ/742/L19/table2Planetary and stellar parameters for Kepler candidates with radius less than 2.5 Earth radius and temperatures higher than 1000K (191 rows) (released 2017-10-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)
  KOI   [69.01/1608.01] Kepler-Object-of-Interest number (meta.id;meta.main)
  a AU Semi-major axis of planetary candidate (phys.size.smajAxis)
  Rp Rgeo [0.6/2.5] Radius of planetary candidate (phys.size.radius)
  Tp K [1001/3074] Equilibrium temperature of planet (phys.temperature)
  Teff K [3684/6869] Effective temperature of star (phys.temperature.effective)
  R* Rsun [0.53/1.88] Radius of parent star (meta.id.parent;phys.size.radius)
  Simbad  ask the Simbad data-base about this object (meta.ref)
  _RA deg (i) Position of host star from SIMBAD database (right ascension part) (pos.eq.ra;meta.main)
  _DE deg (i) Position of host star from SIMBAD database (declination part) (pos.eq.dec;meta.main)

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-24T04:02:28)
-3
-source=J/ApJ/742/L19/table2
-ref=VIZ68aa8ed4397347
elapse time 0

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


Contents of error file (/tmp/V-3.err):
[1756008148]   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'):
[1756008148]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 147/0 tuples [tested=147]
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=22440014 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select ucdid, name, class, explain From METAucd where ucdid=77
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select ucdid, name, class, explain From METAucd where ucdid=83
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756008148]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/ApJ/742/L19/table2
     [u] -ref=VIZ68aa8ed4397347
====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