Page History

This tutorial will show you how to use the Advanced Search capability of the MAST Portal. Specifically, we will be using Advanced Search to pre-select targets in the TESS Candidate Target List (CTL) that have temperatures between 2000-3500 K, declination below 0 degrees, and proper motions greater than 100 mas/year in both RA and Dec. After pre-selecting using these filters, you can either download the results, or conduct a search within that subset of the CTL.

Step 1 - Sign Into CasJobs: The first thing you'll need to do is sign into CasJobs. The Login button is located towards the top of the page 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 - Enter Account Info: On the login page, enter your user name and password (Item #1). Note that the MAST CasJobs account is not the same as your general STScI (MyST) account. If you don't have a MAST CasJobs account, you can register for one using the link towards the bottom of the page (Item #2).

Step 4 3 - Enter Your Query: Once we have selected TESS_v? as our Context, we can write our query in the space below. This tutorial is not designed to give you a full introduction on how to write SQL queries, but we will explain our basic query. The first line selects all columns from the TIC, which is stored as a table called catalogRecord inside CasJobs (Item #1). The next three lines apply some conditions to our query, namely, we want all stars that have temperatures between 3900. and 4200. K, are in the southern hemisphere, and are classified as a dwarf based on their reduced proper motion (Item #2). The last line tells CasJobs to store the results of our query as a table called tic_kdwarfs into MyDB (Item #3). MyDB is the Context that holds any output tables you make using CasJobs, and is your own personal workspace where you can write (create) and drop (remove) tables. On the upper right (Item #4), you can check that your syntax is valid SQL before running a job with the Syntax button. The Quick button allows you to run a SQL query directly on this page, provided the job takes less than 60 seconds to run and doesn't use too much memory. Finally, the Submit button will send a query to the job manager, allowing you to submit any query to the processing queue. Even if the job takes a long time to run, once submitted to the queue, you can exit CasJobs and return at any time to check on the status or get your output table once finished. This query must use the Submit button, since it won't finish in less than 60 secondsThe Advanced Search UI: After selecting the CTL in the Context menu, enter the Advanced Search using the link below the search box.  Note: you only need to visit the link, at this point, do not enter anything into the Search Box.

Step 5 - Monitoring Job Status: After you Submit a job to the queue, you will be brought to this page, which will continuously refresh every 30 seconds, allowing your to monitor the status of your job 4 - Choose Columns To Filter On: In the Advanced Search screen, you can add or remove sub-panels that can be used to apply a pre-search filter on any of the available columns (Item #1). You can also manually refresh this page if you want to get a status update faster, or visit the History tab at any time if you want to leave the CasJobs page and come back later. When a job is finished, it will show up in blue as Finished. If a job fails for some reason, it will show up in red as Failed. You can see your entire job submission history by visiting the History tab at the top When you add a sub-panel, it will show up on the right side of the menu, where you can apply limits on the ranges for numerical columns, or constraints in text fields by entering a value, including wildcards (Item #2).

Step 6 - Accessing Your Output Tables: The MyDB tab (Item #1) is an important section of CasJobs, because it allows you to get to your output tables and see the available tables provided by MAST. Similarly to the Query tab, a drop-down Context menu allows you to swap between available Contexts (Item #2). In this 5 - Apply Filters:In our example, we'll select MyDB from the drop-down menu, where we will see our output from the query we just ran (Item #3). If a table is "in progress", it will appear in blue, otherwise a table that is finished will appear in yellow. Our query has resulted in some 20 million K dwarfs in the catalog, way too large for other MAST interfaces.

Step 9 - Job Information: If we click on the Job link, we will be able to see information about the query used to create the table. In particular, the exact query used is located at the bottom (Item #1), along with the ability to re-submit this query back to the Query tab, making it easy to regenerate or update a query at any time in the future!

Step 11 - Viewing Other Tables In CasJobs: As mentioned previously, you can also see the content of MAST-provided tables by changing the Context drop-down menu 7 - Continue Interacting With Query Results: Having loaded our Advanced Search results into the main Portal, we see they are stored in their own tab (Item #1). If we change it to the TESS_v? Context, we'll see the available TESS mission tables, including the TIC (listed as the catalogRecord table), and versions of the exoplanet CTL. If we click on any of these links, we can further explore these tables on the right side of the page. If we click on the Notes link, we can see a description of the table and a summary of the table schema (Item #2). You can even download the catalogs in .csv or .fits format if you want, using the same export function used to save our query results table.