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/A+AS/118/481
  ROSAT all-sky survey catalogue of OB stars (Berghoefer+ 1996)
Post annotation
img(gal)
1.J/A+AS/118/481/table2(c)Detections (237 rows) (released 2017-09-20)
[METAtab] [METAcola]
2.J/A+AS/118/481/table3(c)Upper limits of non-detections (1585 rows) (released 2017-09-20)
[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.
   (ALL)HR   [11/8998] Bright Star catalogue number
   (ALL)HR_data (char) (i) Link to all parameters and notes from the Bright Star Catalogue (pos.eq.dec;meta.main)
  (1)Name (char) Star's name
   (ALL)SpType (char) MK spectral classification
   (ALL)Vmag mag V magnitude
  (1)B-V mag B-V magnitude
  (1)E(B-V) mag Color excess
  (1)log(NH) [cm-2] Hydrogen column density
  (1)Dist pc Distance
  (1)log(Lbol) [10-7W] Bolometric luminosity

ALL cols
    
 (i)indexed column
  (1)Texp s Exposure time
  (1)OX-sep arcsec Offset between optical and X-ray position
  (1)n_OX-sep (char) [*] * for offset larger than 75 arcmin
  (1)rate ct/s Mean PSPC count rate
  (1)e_rate ct/s Error of PSPC count rate
  (1)HRatio  Hardness ratio = (H-S)/(H+S)
  (1)e_HRatio  Error of hratio
  (1)n_HRatio (char) [1±] Note on hardness ratio -: upper limit +: lower limit 1: only S band
  (1)Tx keV Estimated X-ray temperature
  (1)log(FX) [mW/m2] Apparent X-ray flux
  (1)log(e_FX) [mW/m2] Error of FX
   (ALL)log(Lx) [10-7W] X-ray luminosity
   (ALL)log(Lx/Lbol) [--] Luminosity ratio log(Lx/Lbol)

ALL cols
    
 (i)indexed column
   (ALL)Simbad (char) ask the Simbad data-base about this object
   (ALL)_RA deg (i) Right Ascension (J2000) from SIMBAD (not part of the original data) (pos.eq.ra;meta.main)
   (ALL)_DE deg (i) Declination (J2000) from SIMBAD (not part of the original data) (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-25T05:29:01)
-3
-source=J/A+AS/118/481
-ref=VIZ68abf49df7a6a
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)
ZIR'):
[1756099741]   Select catid, morid, text From METAmor where catid=41180481 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=41180481 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, type, fmt, explain, more From METAdic where name='HR' Order by type
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=41180481 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, type, fmt, explain, more From METAdic where name='HR' Order by type
----db1_reset(0 'metaviz@VIZIR')

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

....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file****
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=41180481 and  tabid=1 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=41180481 and tabid=1
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   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'):
[1756099741]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   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'):
[1756099741]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   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=41180481 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   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=41180481 and tabid=1
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select catid, morid, text From METAmor where catid=41180481 order by morid
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=41180481 and  tabid=2 order by colid
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=41180481 and tabid=2
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   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=41180481 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   select login from METAdba where login like 'large_tables%'
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   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=41180481 and tabid=2
#...meta_close(1): retrieved 0/1000 tuples [tested=0]
++++status=3 0
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid=41180481 and (authid=0)
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=41180481 order by tabid
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METApop' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZIR')
----db1_open(metaviz@VIZIR) gives: 1
----Open server: 130.79.128.5, port 5432 (type postgres base vizier)
----db1_query(1 'metaviz@VIZIR'):
[1756099741]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@VIZIR')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=41180481): 7116 => 0.56
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select idori, kwdid, name, explain From METAorigin
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select ucdid, name From METAucd where ucdid>=0
----db1_exec(0 'metaviz@VIZIR'):
[1756099741]    Update METAhit set etime=809414941,  Ncalls = Ncalls+1 where catid=41180481 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756099741]    UPDATE METAstat set nlocal=nlocal+1, tlocal=809414941 Where phase=3 and catid=41180481
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756099741]    Update METAhit set etime=809414941,  N2list = N2list+2 where catid=41180481 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756099741]    Update METAhit set etime=809414941,  N2list = N2list+2 where catid=41180481 and hstid=-1 and btime=807348600
------------(1 records affected)
----db1_exec(0 'metaviz@VIZIR'):
[1756099741]    UPDATE METAstat set nlocal=nlocal+1, tlocal=809414941 Where phase=3 and catid=41180481
------------(1 records affected)
....show_tuple: show_status = (22, 11, 0, 0, 4)
====Tuple 'J/A+AS/118/481' from 2/0 tables:
    #41180481.1 'J/A+AS/118/481/table2' 27/40 columns
    #41180481.2 'J/A+AS/118/481/table3' 10/24 columns
[00000003] col#000 v000 OA002 J/A+AS/118/481/table2*recno           
[00000003] col#001 v000 O2043 J/A+AS/118/481/table2*HR              
[00000003] col#001 v004 O0011 J/A+AS/118/481/table2*HR_data         
[00000001] col#002 v004 O4040 J/A+AS/118/481/table2*Name            
[00000003] col#003 v004 O4043 J/A+AS/118/481/table2*SpType          
[00000003] col#004 v001 O0043 J/A+AS/118/481/table2*Vmag            
[00000001] col#005 v001 O0043 J/A+AS/118/481/table2*B-V             
[00000001] col#006 v001 O0043 J/A+AS/118/481/table2*E(B-V)          
[00000001] col#007 v001 O0043 J/A+AS/118/481/table2*log(NH)         
[00000001] col#008 v000 O0043 J/A+AS/118/481/table2*Dist            
[00000001] col#009 v001 O0043 J/A+AS/118/481/table2*log(Lbol)       
[00000001] col#010 v000 O0040 J/A+AS/118/481/table2*Texp            
[00000001] col#011 v001 O0003 J/A+AS/118/481/table2*OX-sep          
[00000001] col#012 v004 O4000 J/A+AS/118/481/table2*n_OX-sep        
[00000001] col#013 v001 O0003 J/A+AS/118/481/table2*rate            
[00000001] col#014 v001 O0000 J/A+AS/118/481/table2*e_rate          
[00000001] col#015 v001 O0003 J/A+AS/118/481/table2*HRatio          
[00000001] col#016 v001 O0000 J/A+AS/118/481/table2*e_HRatio        
[00000001] col#017 v004 O4000 J/A+AS/118/481/table2*n_HRatio        
[00000001] col#018 v001 O0040 J/A+AS/118/481/table2*Tx              
[00000001] col#019 v001 O0003 J/A+AS/118/481/table2*log(FX)         
[00000001] col#020 v001 O0000 J/A+AS/118/481/table2*log(e_FX)       
[00000003] col#021 v001 O0040 J/A+AS/118/481/table2*log(Lx)         
[00000003] col#022 v001 O0003 J/A+AS/118/481/table2*log(Lx/Lbol)    
[00000003] col#023 v004 OA050 J/A+AS/118/481/table2*Simbad          
[00000003] col#024 v311 O8023 J/A+AS/118/481/table2*_RA             
[00000003] col#025 v011 O8023 J/A+AS/118/481/table2*_DE             
[00000003] col#000 v000 OA002 J/A+AS/118/481/table3*recno           
[00000003] col#001 v000 O2043 J/A+AS/118/481/table3*HR              
[00000003] col#001 v004 O0011 J/A+AS/118/481/table3*HR_data         
[00000003] col#002 v004 O4043 J/A+AS/118/481/table3*SpType          
[00000003] col#003 v001 O0043 J/A+AS/118/481/table3*Vmag            
[00000003] col#004 v001 O0003 J/A+AS/118/481/table3*log(Lx)         
[00000003] col#005 v001 O0003 J/A+AS/118/481/table3*log(Lx/Lbol)    
[00000003] col#006 v004 OA051 J/A+AS/118/481/table3*Simbad          
[00000003] col#007 v311 O8023 J/A+AS/118/481/table3*_RA             
[00000003] col#008 v011 O8023 J/A+AS/118/481/table3*_DE             

----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1243
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=179
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select ucdid, name, class, explain From METAucd where ucdid=248
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=530
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=156
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1332
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=716
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=688
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=434
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=930
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1192
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=399
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1370
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1110
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=313
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=437
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1283
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1078
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=584
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1017
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1012
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select ucdid, name, class, explain From METAucd where ucdid=249
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1165
----db1_reset(0 'metaviz@VIZIR')
----db1_query(0 'metaviz@VIZIR'):
[1756099741]   Select famid, name, explain From METAfam where famid=1135
----db1_reset(0 'metaviz@VIZIR')
----opt1= 8
----inherit(u=used, h=hidden):
     [u] +source=J/A+AS/118/481
     [u] -ref=VIZ68abf49df7a6a
====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