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/783/84
  ALMA observations in 107 galaxies at z=0.2-2.5 (Scoville+, 2014)
Post annotation
img(gal)
1.J/ApJ/783/84/galaxiesGalaxy sample in band 7 (350GHz): low-z (table5), mid-z (table6), and high-z (table7) (107 rows) (released 2018-01-08)
[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)
  Sample (char) Galaxy sample (Note 1)   (src)
  Galaxy   [1/37] Galaxy running sequence number (Note 2)   (meta.id;meta.main)
  RAJ2000 deg (i) Right Ascension in decimal degrees (J2000) (pos.eq.ra;meta.main)
  DEJ2000 deg (i) Declination in decimal degrees (J2000) (pos.eq.dec;meta.main)
  zph   [0.22/2.72] Photometric redshift (Note 3)   (src.redshift)
  Stot mJy [-5/5] Atacama Large Millimeter/submillimeter Array (ALMA) total integrated flux density measurement at 850µm (Stot) (Note 4)   (phot.flux.density;em.mm.200-400GHz)
  stot mJy [0.35/2.5] Measured noise for the integrated flux (σtot) (Note 5)   (stat.snr;phot.flux.density)
  Speak mJy [0.2/4.6] ALMA peak pixel flux density measurement at 850µm (Speak) (Note 4)   (phot.flux.density;em.mm.200-400GHz)
  spix mJy [0.16/0.5] Measured noise for the peak pixel flux (σpix) (Note 5)   (stat.snr;phot.flux.density)
  S/N   [-4.7/18.3] Signal-to-Noise ratio (Note 6)   (stat.snr)
  Mass* 10+11Msun [0.36/3.42] Stellar mass (Note 3)   (phys.mass)
  logSFR [Msun/yr] [-3/2.8] Log of the Star Formation Rate (Note 3)   (meta.id)
  l_Mism (char) [<] Upper limit flag on Mism (meta.code.error)
  Mism 10+10Msun [0.8/15.1] Inferred mass of the interstellar medium (MISM) (Note 7)   (phys.mass)
  e_Mism 10+10Msun(n) [0.26/3] Error in Mism (stat.error)
  COSMOS  (n)Number of sources in the Cosmic Evolution Survey (COSMOS; Capak et al. 2007, Cat. II/284) within 1.5'' (meta.ref.url)
  I13  Display the photometry from Ilbert et al. 2013 (Cat. J/A+A/556/A55) within 1.5'' (meta.ref.url)
  UltraVISTA  Display the data from the UltraVISTA Catalogue Release DR1 (McCracken et al. 2012, Cat. J/A+A/544/A156) (meta.ref.url)
  SimbadName (char) 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-04-07T07:21:06)
-3
-source=J/ApJ/783/84
-ref=VIZ67f37ce29748d
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 963656 Mar 12 13:03 /srv/httpd/bin/vizier
vizier -- Version 7.4.6
cgiprint -- version 9.68 (2016-01-16)
1): retrieved 1/1000 tuples [tested=1]
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   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'):
[1744010466]   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'):
[1744010466]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select catid, tabid, colid, time_rel_id From METAtimeRel where catid=51660196 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 1
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=51660196 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51660196 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select COUNT(*) as n From METAobj Where catid=51660196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select idori, kwdid, name, explain From METAorigin
----db1_exec(0 'metaviz@VIZIR'):
[1744010466]    Update METAhit set etime=797325666,  Ncalls = Ncalls+1 where catid=51660196 and hstid=-1 and btime=796829400
------------(0 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1744010466]    Insert into METAhit (catid, hstid, btime, etime, Ncalls, N2list) VALUES (51660196,-1,796829400,797325666, 1,0)
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1744010466]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797325666 Where phase=3 and catid=51660196
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR')------------(1 records affected)
----db1_exec(1 'metaviz@VIZIR'):
[1744010466]    UPDATE METAstat set nlocal=nlocal+1, tlocal=797325666 Where phase=3 and catid=17830084
------------(1 records affected)
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name From METAucd where ucdid>=0
....show_table(J/ApJ/783/84/galaxies): show_status = (17, 1, 0, 0, 2)
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=82
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=298
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=188
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=321
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=577
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=109
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=914
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=526
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=362
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=235
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=196
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=1025
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=1061
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=64
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=103
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=84
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----inherit(u=used, h=hidden):
     [u] +source=J/ApJ/783/84
     [u] -ref=VIZ67f37ce29748d
====inherit(): added 0 hidden fields
4010466]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=358
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=17
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/AJ/166/196
     [u] -ref=VIZ67f37ce2974b8
====inherit(): added 0 hidden fields
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=106
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select ucdid, name, class, explain From METAucd where ucdid=9
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1744010466]   Select famid, name, explain From METAfam where famid=581
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/ApJ/892/23
     [u] -ref=VIZ67f37ce29749e
====inherit(): added 0 hidden fields
----free temporary files
----db1_close(0 'metaviz@VIZIR')
----free temporary files
----db1_close(0 'metaviz@VIZIR')
----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