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/161/194
  LCs and RVs of 5 exoplanets discovered by TESS (Rodriguez+, 2021)
timeSerie
Post annotation
img(gal)
1.J/AJ/161/194/table1(c)Literature and measured properties for the five systems[timeSerie] (5 rows) (released 2022-03-10)
[METAtab] [METAcola]
2.J/AJ/161/194/table3Radial velocities for all five systems (164 rows) (released 2022-03-10)
[METAtab] [METAcola]
3.J/AJ/161/194/fig2TESS Follow-up Observing Program (TFOP) SG1 follow-up transits of TOI-628b, TOI-640b, TOI-1333b, TOI-1478b, and TOI-1601b (6515 rows) (released 2022-03-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)
   (ALL)TOI (char) (i) TOI number (meta.id;meta.main)
  (1)Np  (n)Number of flux measurements (link to Fig 2) (meta.number)
  (1)Nrv  (n)Number of radial velocities measurements (link to Table 3) (meta.number)
  (1)TIC  TIC number (meta.id)
  (1)OName (char) Other name (meta.id)
  (1)TYC (char) Tycho-2 identifier (meta.id)
  (1)2MASS (char) 2MASS name (JHHMMSSss+DDMMSSs) (meta.id)
  (1)TESSs (char) Tess sector (s) (obs.field)
  (1)RAJ2000 "h:m:s" (i) Gaia DR2 Hour of right ascension (J2000) (pos.eq.ra;meta.main)
  (1)DEJ2000 "d:m:s" (i) Gaia DR2 Degree of declination (J2000) (pos.eq.dec;meta.main)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)BTmag mag [9.93/11.62] Tycho BT magnitude (phot.mag;em.opt.B)
  (1)e_BTmag mag [0.02/0.09] Uncertainty on the Bmag (stat.error;phot.mag)
  (1)VTmag mag [9.48/10.81] Tycho VT band magnitude (phot.mag;em.opt.V)
  (1)e_VTmag mag [0.02/0.07] Uncertainty on the Vmag (stat.error;phot.mag)
  (1)Gmag mag [9.35/10.66] Gaia DR2 G-band magnitude (phot.mag;em.opt)
  (1)e_Gmag mag [0.02] Uncertainty on the Gmag (stat.error;phot.mag)
  (1)BPmag mag [9.59/11.03] Gaia DR2 BP-band magnitude (phot.mag;em.opt.B)
  (1)e_BPmag mag [0.02] Uncertainty on the BPmag (stat.error;phot.mag)
  (1)RPmag mag [8.99/10.16] Gaia DR2 RP-band magnitude (phot.mag;em.opt.R)
  (1)e_RPmag mag [0.02] Uncertainty on the RPmag (stat.error;phot.mag)
  (1)Tmag mag [9.03/10.21] TESS band magnitude (phot.mag;em.opt)
  (1)e_Tmag mag [0.006/0.007] Uncertainty on the Tmag (stat.error;phot.mag)
  (1)Jmag mag [8.48/9.6] 2MASS J-band magnitude (phot.mag;em.IR.J)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)e_Jmag mag [0.02/0.05] Uncertainty on the Jmag (stat.error;phot.mag)
  (1)Hmag mag [8.39/9.33] 2MASS H-band magnitude (phot.mag;em.IR.H)
  (1)e_Hmag mag [0.02/0.06] Uncertainty on the Hmag (stat.error;phot.mag)
  (1)Ksmag mag [8.27/9.25] 2MASS Ks-band magnitude (phot.mag;em.IR.K)
  (1)e_Ksmag mag [0.02/0.024] Uncertainty on the Ksmag (stat.error;phot.mag)
  (1)W1mag mag [7.7/9.3] WISE W1 (3.4um) band magnitude (phot.mag;em.IR.3-4um)
  (1)e_W1mag mag [0.013/0.03] Uncertainty on the W1mag (stat.error;phot.mag)
  (1)W2mag mag [7.5/9.3] WISE W2 (4.6um) band magnitude (phot.mag;em.IR.4-8um)
  (1)e_W2mag mag [0.012/0.03] Uncertainty on the W2mag (stat.error;phot.mag)
  (1)W3mag mag [8/9.3] WISE W3 (12um) band magnitude (phot.flux.density;em.IR.8-15um)
  (1)e_W3mag mag [0.019/0.04] Uncertainty on the W3mag (stat.error;phot.mag)
  (1)W4mag mag (n) [8.04/8.8] WISE W4 (22um) band magnitude (phot.flux.density;em.IR.15-30um)
  (1)e_W4mag mag (n) [0.16/0.33] Uncertainty on the W4mag (stat.error;phot.mag)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)pmRA mas/yr [-9.81/21.8] Gaia DR2 proper motion in right ascension direction (pmRA*cosDE) (pos.pm;pos.eq.ra)
  (1)e_pmRA mas/yr [0.04/0.12] pmRA uncertainty (stat.error;pos.pm;pos.eq.ra)
  (1)pmDE mas/yr [-10.51/67.95] Gaia DR2 proper motion in declination direction (pos.pm;pos.eq.dec)
  (1)e_pmDE mas/yr [0.045/0.09] PmDE uncertainty (stat.error;pos.pm;pos.eq.dec)
  (1)Vrot km/s [4.3/14.2] Rotational velocity from this work (section 2.5) (phys.veloc.rotat)
  (1)e_Vrot km/s [0.5] Vrot uncertainty (stat.error)
  (1)Vmac km/s [4.9/7.4] Macroturbulent broadening (section 2.5) (spect.line.broad)
  (1)e_Vmac km/s [0.5/1.8] Vmac uncertainty (stat.error)
  (1)plx mas [2.9/6.6] Gaia DR2 parallax (pos.parallax.trig)
  (1)e_plx mas [0.03/0.11] Parallax uncertainty (stat.error;pos.parallax)
  (1)Per d (n) [5.3] Rotation period (sections 2.1, 2.2, 2.3) (time.period)
  (1)e_Per d (n) [0.159] Per uncertainty (stat.error)
  (1)RV (char) Interactive Plot (meta.ref.url)

ALL cols
    
(n) indicates a possible blank or NULL column(i)indexed column
  (1)LC (char) Interactive Plot (meta.ref.url)
  (1)Simbad (char) ask the Simbad data-base about this object (meta.ref.url)
  (2+3)BJD d [2458604/2459211] Barcentric Julian Date; TBD (time.epoch)
  (2)RVel m/s [-1309/39183] Radial velocity (phys.veloc;pos.heliocentric)
  (2)e_RVel m/s [6.4/69] Internal uncertainty in RVel (stat.error;spect.dopplerVeloc)
  (2)Inst (char) Instrument used (instr.setup)
  (3)Obs "Y:M:D" [2019/2020] Year of the observation (time.epoch)
  (3)Filt (char) Filter used (BVRI or Sloani, Sloanr, Sloanz) (instr.setup;instr.filter)
  (3)ObsID (char) Observatory or instrument identifier (Note 1)   (meta.id;instr.obsty)
  (3)Flux   [0.93/1.1] Normalized flux (phot.flux;arith.ratio)
  (3)e_Flux   [0.0002/0.3] Uncertainty in NFlux (stat.error;phot.flux)
  (3)DT1  (n) [1/946775] First detrending parameter (Note 2)   (arith.factor;phot.flux)
  (3)DT2  (n) [24/5587966] Second detrending parameter (Note 2)   (arith.factor;phot.flux)
  (3)DT3  (n) [1142/1419] Third detrending parameter (Note 2)   (arith.factor;phot.flux)

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 (2024-09-20T06:51:01)
-3
-source=J/AJ/161/194
-ref=VIZ66ed1b5552832
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=8ae129b2b46e
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
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_X_FORWARDED_FOR=130.79.129.254
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
QUERY_STRING=-source=J%2FAJ%2F161%2F194
REMOTE_ADDR=130.79.128.30
REMOTE_PORT=37988
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=J%2FAJ%2F161%2F194
SCRIPT_FILENAME=/srv/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SERVER_ADDR=172.17.0.2
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 963216 Sep 12 07:38 /srv/httpd/bin/vizier
Vroot=/srv/httpd

################################################################
....(in): -source=J/AJ/161/194
################################################################

....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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select hstid, flag from METAhst where name='8ae129b2b46e.astro.unistra.fr'
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'J/AJ/161/194' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51610194 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51610194 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select login from METAdba where dbaid=43
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select k.catid,k.kwdid from METAkwd k where catid=51610194 and ((-1*kwdid)<(select min(kwdno_min*1) from METAkwcat where name in ('Astronomy')) or  (-1*kwdid)>(select max(kwdno_max*1) from METAkwcat where name in ('Astronomy'))) order by catid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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'):
[1726815061]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   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'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 146/0 tuples [tested=146]
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51610194 order by catid,tabid,colid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select catid, morid, text From METAmor where catid=51610194 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51610194 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=4
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=713 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=206 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=2
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=803 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=801 and fltrid=3
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select system, filter, famid, photid, fltrid, freq0, dfreq, Fmag0 From METAfilter where photid=801 and fltrid=1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51610194 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51610194 and tabid=3

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51610194 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51610194 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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'):
[1726815061]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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=51610194 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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=51610194 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select catid, morid, text From METAmor where catid=51610194 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=51610194 and  tabid=2 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=51610194 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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=51610194 and tabid=2
#...meta_close(1): retrieved 1/1000 tuples [tested=1]
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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'):
[1726815061]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   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'):
[1726815061]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=51610194 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51610194 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51610194 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select idori, kwdid, name, explain From METAorigin
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name From METAucd where ucdid>=0
----db1_exec(0 'metaviz@VIZIR'):
[1726815061]    Update METAhit set etime=780130261,  Ncalls = Ncalls+1 where catid=51610194 and hstid=-1 and btime=778420800
------------(0 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726815061]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (51610194,-1,778420800,780130261, 1,0)
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726815061]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780130261 Where phase=3 and catid=51610194
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726815061]    Update METAhit set etime=780130261,  N2list = N2list+2 where catid=51610194 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726815061]    Update METAhit set etime=780130261,  N2list = N2list+2 where catid=51610194 and hstid=-1 and btime=778420800
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1726815061]    UPDATE METAstat set nlocal=nlocal+1, tlocal=780130261 Where phase=3 and catid=51610194
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name From METAfam where famid>=0
....show_tuple: show_status = (37, 29, 0, 0, 3)
====Tuple 'J/AJ/161/194' from 3/0 tables:
    #51610194.1 'J/AJ/161/194/table1' 52/64 columns
    #51610194.2 'J/AJ/161/194/table3' 6/16 columns
    #51610194.3 'J/AJ/161/194/fig2' 11/24 columns
[00000007] col#000 v000 OA002 J/AJ/161/194/table1*recno           
[80000007] col#001 v004 O6403 J/AJ/161/194/table1*TOI             
[00000001] col#002 v000 O80C3 J/AJ/161/194/table1*Np              
[00000001] col#003 v000 O80C3 J/AJ/161/194/table1*Nrv             
[00000001] col#004 v000 O2003 J/AJ/161/194/table1*TIC             
[00000001] col#005 v004 O4000 J/AJ/161/194/table1*OName           
[00000001] col#006 v004 O6003 J/AJ/161/194/table1*TYC             
[00000001] col#007 v004 O6003 J/AJ/161/194/table1*2MASS           
[00000001] col#008 v004 O4043 J/AJ/161/194/table1*TESSs           
[00000001] col#009 v311 O0023 J/AJ/161/194/table1*RAJ2000         
[00000001] col#010 v011 O0023 J/AJ/161/194/table1*DEJ2000         
[00000001] col#011 v001 O0040 J/AJ/161/194/table1*BTmag           
[00000001] col#012 v001 O0040 J/AJ/161/194/table1*e_BTmag         
[00000001] col#013 v001 O0040 J/AJ/161/194/table1*VTmag           
[00000001] col#014 v001 O0040 J/AJ/161/194/table1*e_VTmag         
[00000001] col#015 v001 O0003 J/AJ/161/194/table1*Gmag            
[00000001] col#016 v001 O0040 J/AJ/161/194/table1*e_Gmag          
[00000001] col#017 v001 O0043 J/AJ/161/194/table1*BPmag           
[00000001] col#018 v001 O0040 J/AJ/161/194/table1*e_BPmag         
[00000001] col#019 v001 O0043 J/AJ/161/194/table1*RPmag           
[00000001] col#020 v001 O0040 J/AJ/161/194/table1*e_RPmag         
[00000001] col#021 v001 O0000 J/AJ/161/194/table1*Tmag            
[00000001] col#022 v001 O0040 J/AJ/161/194/table1*e_Tmag          
[00000001] col#023 v001 O0040 J/AJ/161/194/table1*Jmag            
[00000001] col#024 v001 O0040 J/AJ/161/194/table1*e_Jmag          
[00000001] col#025 v001 O0040 J/AJ/161/194/table1*Hmag            
[00000001] col#026 v001 O0040 J/AJ/161/194/table1*e_Hmag          
[00000001] col#027 v001 O0040 J/AJ/161/194/table1*Ksmag           
[00000001] col#028 v001 O0040 J/AJ/161/194/table1*e_Ksmag         
[00000001] col#029 v001 O0043 J/AJ/161/194/table1*W1mag           
[00000001] col#030 v001 O0040 J/AJ/161/194/table1*e_W1mag         
[00000001] col#031 v001 O0043 J/AJ/161/194/table1*W2mag           
[00000001] col#032 v001 O0040 J/AJ/161/194/table1*e_W2mag         
[00000001] col#033 v001 O0043 J/AJ/161/194/table1*W3mag           
[00000001] col#034 v001 O0040 J/AJ/161/194/table1*e_W3mag         
[00000001] col#035 v001 O00C3 J/AJ/161/194/table1*W4mag           
[00000001] col#036 v001 O00C0 J/AJ/161/194/table1*e_W4mag         
[00000001] col#037 v001 O0063 J/AJ/161/194/table1*pmRA            
[00000001] col#038 v001 O0040 J/AJ/161/194/table1*e_pmRA          
[00000001] col#039 v001 O0023 J/AJ/161/194/table1*pmDE            
[00000001] col#040 v001 O0040 J/AJ/161/194/table1*e_pmDE          
[00000001] col#041 v001 O0043 J/AJ/161/194/table1*Vrot            
[00000001] col#042 v001 O0040 J/AJ/161/194/table1*e_Vrot          
[00000001] col#043 v001 O0043 J/AJ/161/194/table1*Vmac            
[00000001] col#044 v001 O0040 J/AJ/161/194/table1*e_Vmac          
[00000001] col#045 v001 O0043 J/AJ/161/194/table1*plx             
[00000001] col#046 v001 O0040 J/AJ/161/194/table1*e_plx           
[00000001] col#047 v001 O00C3 J/AJ/161/194/table1*Per             
[00000001] col#048 v001 O00C0 J/AJ/161/194/table1*e_Per           
[00000001] col#049 v004 OA011 J/AJ/161/194/table1*RV              
[00000001] col#050 v004 OA011 J/AJ/161/194/table1*LC              
[00000001] col#051 v004 OA051 J/AJ/161/194/table1*Simbad          
[00000007] col#000 v000 OA002 J/AJ/161/194/table3*recno           
[00000006] col#001 v001 O0003 J/AJ/161/194/table3*BJD             
[00000002] col#002 v001 O0003 J/AJ/161/194/table3*RVel            
[00000002] col#003 v001 O0043 J/AJ/161/194/table3*e_RVel          
[80000007] col#004 v004 O4803 J/AJ/161/194/table3*TOI             
[00000002] col#005 v004 O4003 J/AJ/161/194/table3*Inst            
[00000007] col#000 v000 OA002 J/AJ/161/194/fig2*recno           
[00000004] col#001 v020 O0003 J/AJ/161/194/fig2*Obs             
[00000004] col#002 v004 O4043 J/AJ/161/194/fig2*Filt            
[00000004] col#003 v004 O4043 J/AJ/161/194/fig2*ObsID           
[80000007] col#004 v004 O4803 J/AJ/161/194/fig2*TOI             
[00000006] col#005 v001 O0003 J/AJ/161/194/fig2*BJD             
[00000004] col#006 v001 O0003 J/AJ/161/194/fig2*Flux            
[00000004] col#007 v001 O0003 J/AJ/161/194/fig2*e_Flux          
[00000004] col#008 v001 O0083 J/AJ/161/194/fig2*DT1             
[00000004] col#009 v001 O0083 J/AJ/161/194/fig2*DT2             
[00000004] col#010 v001 O0083 J/AJ/161/194/fig2*DT3             

----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=314
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=94
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=171
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=112
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=934
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=847
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=933
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=848
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=930
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=741
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=731
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=932
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=742
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=929
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=693
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=928
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=689
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=927
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=696
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=926
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=665
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=925
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=666
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=924
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=480
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=923
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=481
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=265
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1143
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1144
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=342
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1445
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=291
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1299
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=264
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1211
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=260
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=377
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1374
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1363
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=328
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=257
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=1428
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=410
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=45
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=233
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=30
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=230
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=33
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=350
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=9
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=582
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select ucdid, name, class, explain From METAucd where ucdid=6
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1726815061]   Select famid, name, explain From METAfam where famid=825
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/161/194
     [u] -ref=VIZ66ed1b5552832
====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