This tutorial will show you how to customize which columns are included when you export a table in the MAST Portal. Specifically, we will show how to select only those columns expected by the Goddard Mission Office when submiting target lists for the Guest Investigator Program.
Step 1 - Select Collection: Upon visiting the MAST Portal, the first step is to change the collection of data we are searching in from the Context menu (Item #1) at the top left.
Step 2 - Select CTL Catalog: From the Context drop-down menu, select MAST Catalogs, then, in the Mission drop-down menu that appears (Item #1), select either TESS CTL v7.02 for the exoCTL. Note that the version number will change as newer editions replace older ones in the Portal.
Step 3 - Enter The Advanced Search UI: After selecting the CTL in the Context menu, enter the Advanced Search using the link below the search box (Item #1). Note: you only need to visit the link at this point, do not enter anything into the Search Box.
Step 4 - Choose Columns To Filter On: In the Advanced Search window, you can add (green plus symbols) or remove (red minus symbols) panels that can be used to apply a pre-search filter on any of the available columns (Item #1). When you add a panel, it will show up on the right side of the window, where you can apply limits on the ranges for numerical columns, or constraints in text fields by entering some text, including wildcards (Item #2).
Step 5 - Apply Filters: In our example, we'll remove all the sub-panels except for Dec, pmRA, pmDEC, and T_eff. It's not necessary to remove panels if you don't want to filter on them, but we do here for clarity. We filter 2000. < T_eff < 3500. K, declination less than 0 degrees, and require both RA and Dec. proper motions are larger than 100 mas (Item #1). As you apply each filter, the Portal will apply it and keep a running total of the number of return rows in the top-left (Item #2).