Microlensing Planets Data Column Definitions
Data Columns in the Microlensing Planets Table
The following table lists all of the data columns in the Microlensing Planets Table (ML). These parameters can also be retrieved by query through the archive's Table Access Protocol (TAP) service.
More details on microlensing resources in the archive are listed on the Microlensing Resources page.
Query-based Access to the Microlensing Table
The Microlensing Table is connected to the archive's TAP and API services, which enable automated data retrieval using queries. To build a query, review the TAP User Guide or API User Guide and use the database column names on this page.
Please note: The Microlensing Table's database table name (ML) and column names were changed in April 2021, so queries developed before the redesign will not return the most current data. No columns were added or removed as part of the redesign, and all default columns remain the same. This page lists all of the current database column names and their definitions. This document maps the old and new column names to help you update any queries pre-dating April 2021. The mapping document is also available as a comma-separated values (CSV) file.
Digital Object Identifier
If you use archive data or services for your research, please include the following Digital Object Identifier (DOI) as part of your acknowledgment:
DOI 10.26133/NEA7
See Acknowledging the Archive for data set-specific language. See the full list of NASA Exoplanet Archive DOIs for other data sets and services.
_______________________________________________
Skip to a subsection:Default Columns
Coordinate Columns
Microlensing Parameters
Magnitude Columns
Color Columns
Model Columns
_______________________________________________
Default Columns
Default columns are those that display in the Microlensing interactive table when the table is first loaded and when the Reset Filters button is clicked. To add or remove other columns to the interactive table, click the Select Columns button in the upper-left corner of the interface to access Column Controls.
For more information on using the archive's interactive tables, see the User Guide.
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column |
|---|---|---|---|---|
| pl_name | Planet Name | Planet name | ||
| rastr | RA [sexagesimal] | Right ascension of the microlensing event, in sexagesimal format | ||
| decstr | Dec [sexagesimal] | Declination of the microlensing event, in sexagesimal format | ||
| pl_massj | Planet Mass [Jupiter mass] | Mass of planet, in Jupiter masses | (+) pl_orbmassjerr1 (-) pl_massjerr2 |
pl_massjlim |
| pl_masse | Planet Mass [Earth mass] | Mass of planet, in Earth masses | (+) pl_orbmasseerr1 (-) pl_masseerr2 |
pl_masselim |
| pl_orbsmax | Planet-star Projected Semi-major Axis [au] | Projected physical separation of the planet and the host star in the plane of the sky at the time of the event | (+) pl_orbsmaxerr1 (-) pl_orbsmaxerr2 |
pl_orbsmaxlim |
| st_mass | Lens Mass [Solar mass] | Host star mass | (+) st_masserr1 (-) st_masserr2 |
sy_dist |
| sy_dist | Lens Distance [pc] | Distance from the observer to the lens system | (+) sy_disterr1 (-) sy_disterr2 |
sy_distlim |
| ml_dists | Source Distance [pc] | Distance from the observer to the source system | (+) ml_distserr1 (-) ml_distserr2 |
ml_distslim |
| ml_tsepmin | Time of Lens-source Minimum Separation [days] | Time of lense-source minimum separation in the plane of the sky | (+) ml_tsepminerr1 (-) ml_tsepminerr2 |
ml_tsepmin |
| ml_sepminnorm | Normalized Lens-source Minimum Separation | Angular lens-source minimum separation in the plane of the sky, normalized to the angular Einstein radius (microlens impact parameter) | (+) ml_sepminnormerr1 (-) ml_sepminnormerr2 |
ml_sepminnormlim |
| ml_xtimeein | Einstein Crossing Time [days] | Time for the lens-source separation to change by one angular Einstein radius | (+) ml_xtimeeinerr1 (-) ml_xtimeeinerr2 |
ml_xtimeeinlim |
| ml_radsnorm | Normalized Source Angular Radius (10-3) | Ratio of angular source star radius to the angular Einstein radius (x 10-3) | (+) ml_radsnormerr1 (-) ml_radsnormerr2 |
ml_radsnormlim |
| ml_sepinsnorp | Instantaneous Planet-star Projected and Normalized Separation | Projected, angular separation of the planet and the host star in the plane of the sky at the time of the event, normalized to the angular Einstein radius | (+) ml_sepinsnorperr1 (-) ml_sepinsnorperr2 |
mlmassratio |
| ml_massratio | Planet-star Mass Ratio (10-4) | Ratio of the planet mass to the host star mass (lens system; x 10-4) | (+) ml_massratioerr1 (-) ml_massratioerr2 |
ml_massratiolim |
| ml_angstlax | Source Trajectory-lens Axis Angle [rad] | Angle of the source system trajectory relative to the lens system axis | (+) ml_angstlaxerr1 (-) ml_angstlaxerr2 |
ml_angstlaxlim |
| ml_magis | Source I-band [mag] | Brightness of the unmagnified source star, in I-band | (+) ml_magiserr1 (-) ml_magiserr2 |
ml_magislim |
| ml_magibl | Blend I-band [mag] | Brightness of all objects, excluding the source star, superposed at the time of the event, in I-band | (+) ml_magiblerr1 (-) ml_magiblerr2 |
ml_magibllim |
| ml_radeinang | Angular Einstein Radius [mas] | Angular radius of the Einstein ring | (+) ml_radeinangerr1 (-) ml_radeinangerr2 |
ml_radeinanglim |
| ml_pmrells | Lens-source Relative Proper Motion [mas/yr] | Lens-source relative proper motion | (+) ml_pmrellserr1 (-) ml_pmrellserr2 |
ml_pmrellslim |
| ml_modeldef | Default Model | Binary flag indicating whether given microlens model is the default; best-fit model (1=yes; 0=no) | ||
| htmllink | Reference | Reference |
Coordinate Columns
| Database Column Name |
Table Label | Description |
|---|---|---|
| ra | RA [deg] | Right ascension of the microlensing event, in decimal degrees |
| dec | Dec [deg] | Declination of the microlensing event, in decimal degrees |
| glon | Galactic Longitude [deg] | Galactic longitude of the microlensing event, in decimal degrees |
| glat | Galactic Latitude [deg] | Galactic latitude of the microlensing event, in decimal degrees |
Microlensing Parameter Columns
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column |
|---|---|---|---|---|
| ml_plxrel | Lens-source Relative Parallax | Lens-source relative parallax | (+) ml_plxrelerr1 (-) ml_plxrelerr2 |
ml_plxrellim |
| ml_plxmicro | Microlens Parallax | Lens-source relative parallax normalized to the angular Einstein radius | (+) ml_plxmicroerr1 (-) ml_plxmicroerr2 |
ml_plxicrolim |
| ml_plxmicron | Microlens Parallax (North Component) | North component of the microlens parallax | (+) ml_plxmicronerr1 (-) ml_plxmicronerr2 |
ml_plxmicronlim |
| ml_plxmicroe | Microlens Parallax (East Component) | East component of the microlens parallax | (+) ml_plxmicroeerr1 (-) ml_plxmicroeerr2 |
ml_plxmicroelim |
| ml_dsdt | Planet-star Separation Rate of Change [yr-1] | Time rate of change of the projected, angular, normalized separation of the planet and host star in the plane of the sky due to orbital motion of the lens components | (+) ml_dsdterr1 (-) ml_dsdterr2 |
ml_dsdtlim |
| ml_dalphadt | Source Trajectory Angle Rate of Change [rad/yr] | Time rate of change of the angle of the source system trajectory to the lens system axis due to the orbital motion of the lens components | (+) ml_dalphadterr1 (-) ml_dalphadterr2 |
ml_dalphadtlim |
| ml_radsang | Source Angular Radius [microas] | Angular source star radius | (+) ml_radsangerr1 (-) ml_radsangerr2 |
ml_radsanglim |
| ml_radsphy | Source Physical Radius [Solar radii] | Physical source star radius | (+) ml_radsphyerr1 (-) ml_radsphyerr2 |
ml_radsphylim |
| ml_xtimesrc | Source Crossing Time [days] | Time for the lens-source separation to change by one angular source radius | (+) ml_xtimesrcerr1 (-) ml_xtimesrcerr2 |
ml_xtimesrclim |
| ml_efftime | Effective Timescale [days] | Effective timescale, equal to the product of the microlens impact parameter and the Einstein crossing time | (+) ml_efftimeerr1 (-) ml_efftimeerr2 |
ml_efftimelim |
| ml_pms | Source Proper Motion [mas/yr] | Source system proper motion | (+) ml_pmserr1 (-) ml_pmserr2 |
ml_pmslim |
Magnitude Columns
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column |
|---|---|---|---|---|
| ml_magvs | Source V-band [mag] | Brightness of the unmagnified source star, in V-band | (+) ml_magvserr1 (-) ml_magvserr2 |
ml_magvslim |
| ml_magvso | Source De-reddened V-band [mag] | De-reddened brightness of the unmagnified source star, in V-band | (+) ml_magvsoerr1 (-) ml_magvsoerr2 |
ml_magvsolim |
| ml_magiso | Source De-reddened I-band [mag] | De-reddened brightness of the unmagnified source star, in I-band | (+) ml_magisoerr1 (-) ml_magisoerr2 |
ml_magisolim |
| ml_magjs | Source J-band [mag] | Brightness of the unmagnified source star, in J-band | (+) ml_magjserr1 (-) ml_magjserr2 |
ml_magjslim |
| ml_magjso | Source De-reddened J-band [mag] | De-reddened brightness of the unmagnified source star, in J-band | (+) ml_magjsoerr1 (-) ml_magjsoerr2 |
ml_magjsolim |
| ml_maghs | Source H-band [mag] | Brightness of the unmagnified source star, in H-band | (+) ml_maghserr1 (-) ml_maghserr2 |
ml_maghslim |
| ml_maghso | Source De-reddened H-band [mag] | De-reddened brightness of the unmagnified source star, in H-band | (+) ml_maghsoerr1 (-) ml_maghsoerr2 |
ml_maghsolim |
| ml_magks | Source K-band [mag] | Brightness of the unmagnified source star, in K-band | (+) ml_magkserr1 (-) ml_magkserr2 |
ml_magkslim |
| ml_magkso | Source De-reddened K-band [mag] | De-reddened brightness of the unmagnified source star, in K-band | (+) ml_magksoerr1 (-) ml_magksoerr2 |
ml_magksolim |
| ml_magibase | Event Baseline I-band [mag] | Brightness of all objects, including the unmagnified source star, superposed at the time of the event, in I-band | (+) ml_magibaseerr1 (-) ml_magibaseerr2 |
ml_magibaselim |
| sy_vmag | Lens V-band [mag] | Brightness of the lens star, in V-band | (+) sy_vmagerr1 (-) sy_vmagerr2 |
sy_vmaglim |
| sy_icmag | Lens I-band [mag] | Brightness of the lens star, in I-band | (+) sy_icmagerr1 (-) sy_icmagerr2 |
sy_icmaglim |
| sy_jmag | Lens J-band [mag] | Brightness of the lens star, in J-band | (+) sy_jmagerr1 (-) sy_jmagerr2 |
sy_jmaglim |
| sy_hmag | Lens H-band [mag] | Brightness of the lens star, in H-band | (+) sy_hmagerr1 (-) sy_hmagerr2 |
sy_hmaglim |
| sy_kmag | Lens K-band [mag] | Brightness of the lens star, in K-band | (+) sy_kmagerr1 (-) sy_kmagerr2 |
sy_kmaglim |
| ml_extvfld | Line-of-sight V-Band Extinction [mag] | Line-of-sight extinction toward the source system, in V-band | (+) ml_extvflderr1 (-) ml_extvflderr2 |
ml_extvfldlim |
| ml_extifld | Line-of-sight I-Band Extinction [mag] | Line-of-sight extinction toward the source system, in I-band | (+) ml_extiflderr1 (-) ml_extiflderr2 |
ml_extifldlim |
| ml_extjfld | Line-of-sight J-Band Extinction [mag] | Line-of-sight extinction toward the source system, in J-band | (+) ml_extjflderr1 (-) ml_extjflderr2 |
ml_extjfldlim |
| ml_exthfld | Line-of-sight H-Band Extinction [mag] | Line-of-sight extinction toward the source system, in H-band | (+) ml_exthflderr1 (-) ml_exthflderr2 |
ml_exthfldlim |
| ml_extkfld | Line-of-sight K-Band Extinction [mag] | Line-of-sight extinction toward the source system, in K-band | (+) ml_extkflderr1 (-) ml_extkflderr2 |
ml_extkfldlim |
Color Columns
| Database Column Name |
Table Label | Description | Uncertainties Column (positive +) (negative -) |
Limit Column |
|---|---|---|---|---|
| ml_colvis | Source (V-I) [mag] | Color of the unmagnified source star, V minus I | (+) ml_colviserr1 (-) ml_colviserr2 |
ml_colvislim |
| ml_mcolviso | Source De-reddened (V-I) [mag] | De-reddened color of the unmagnified source star, V minus I | (+) ml_mcolvisoerr1 (-) ml_mcolvisoerr2 |
ml_mcolvisolim |
| ml_colvks | Source (V-K) [mag] | Color of the unmagnified source star, V minus K | (+) ml_colvkserr1 (-) ml_colvkserr2 |
ml_colvkslim |
| ml_colvkso | Source De-reddened (V-K) [mag] | De-reddened color of the unmagnified source star, V minus K | (+) ml_colvksoerr1 (-) ml_colvksoerr2 |
ml_colvksolim |
| ml_colihs | Source (I-H) [mag] | Color of the unmagnified source star, I minus H | (+) ml_colihserr1 (-) ml_colihserr2 |
ml_colihslim |
| ml_colihso | Source De-reddened (I-H) [mag] | De-reddened color of the unmagnified source star, I minus H | (+) ml_colihsoerr1 (-) ml_colihoserr2 |
ml_colihsolim |
| ml_colhks | Source (H-K) [mag] | Color of the unmagnified source star, H minus K | (+) ml_colhkserr1 (-) ml_colhkserr2 |
ml_colhkslim |
| ml_colhkso | Source De-reddened (H-K) [mag] | De-reddened color of the unmagnified source star, H minus K | (+) ml_colhksoerr1 (-) ml_colhkoserr2 |
ml_colhksolim |
| ml_colvibl | Blend (V-I) [mag] | Combined color of all objects, excluding the source star, superposed at the time of the event, V minus I | (+) ml_colviblerr1 (-) ml_colviblerr2 |
ml_colvibllim |
| ml_redvi | Line-of-sght Reddening E(V-I) [mag] | Line-of-sight reddening toward the source system, E(V-I) | (+) ml_redvierr1 (-) ml_redvierr2 |
ml_redvilim |
| ml_redvk | Line-of-sight Reddening E(V-K) [mag] | Line-of-sight reddening toward the source system, E(V-K) | (+) ml_redvkerr1 (-) ml_redvkerr2 |
ml_redvklim |
| ml_redhk | Line-of-sight Reddening E(H-K) [mag] | Line-of-sight reddening toward the source system, E(H-K) | (+) ml_redhkerr1 (-) ml_redhkerr2 |
ml_redhklim |
Model Columns
| Database Column Name |
Table Label | Description |
|---|---|---|
| ml_modelchisq | Model Chi-squared | Chi-squared of the microlens model selected as the best fit |
| cb_flag | Circumbinary Flag | Binary flag indicating whether lens system is a stellar binary (1=yes; 0=no) |
| ml_description | Model Description | Microlensing model description and notes |
Last updated: 13 July 2021
