docs/derivapy-datapath-example-3.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Datapath Example 3\n",
    "\n",
    "This notebook gives an example of how to build relatively simple data paths.\n",
    "It assumes that you understand the concepts presented in the example 2\n",
    "notebook.\n",
    "\n",
    "## Exampe Data Model\n",
    "The examples require that you understand a little bit about the example\n",
    "catalog data model, which is based on the FaceBase project.\n",
    "\n",
    "### Key tables\n",
    "- `'dataset'` : represents a unit of data usually a 'study' or 'collection'\n",
    "- `'experiment'` : a bioassay (typically RNA-seq or ChIP-seq assays)\n",
    "- `'replicate'` : a record of a replicate (bio or technical) related to an experiment\n",
    "\n",
    "### Relationships\n",
    "- `dataset <- experiment`: A dataset may have one to many experiments. I.e., there \n",
    "  is a foreign key reference from experiment to dataset.\n",
    "- `experiment <- replicate`: An experiment may have one to many replicates. I.e., there is a\n",
    "  foreign key reference from replicate to experiment."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import deriva modules\n",
    "from deriva.core import ErmrestCatalog, get_credential"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Connect with the deriva catalog\n",
    "protocol = 'https'\n",
    "hostname = 'www.facebase.org'\n",
    "catalog_number = 1\n",
    "# If you need to authenticate, use Deriva Auth agent and get the credential\n",
    "credential = get_credential(hostname)\n",
    "catalog = ErmrestCatalog(protocol, hostname, catalog_number, credential)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get the path builder interface for this catalog\n",
    "pb = catalog.getPathBuilder()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Building a DataPath\n",
    "Build a data path by linking together tables that are related. To make things a little easier we will use python variables to reference the tables. This is not necessary, but simplifies the examples."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset = pb.isa.dataset\n",
    "experiment = pb.isa.experiment\n",
    "replicate = pb.isa.replicate"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Initiate a path from a table object\n",
    "Like the example 2 notebook, begin by initiating a `path` instance from a `Table` object. This path will be \"rooted\" at the table it was initiated from, in this case, the `dataset` table. `DataPath`'s have URIs that identify the resource in the catalog."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.facebase.org/ermrest/catalog/1/entity/dataset:=isa:dataset\n"
     ]
    }
   ],
   "source": [
    "path = dataset.path\n",
    "print(path.uri)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Link other related tables to the path\n",
    "In the catalog's model, tables are _related_ by foreign key references. Related tables may be linked together in a `DataPath`. Here we link the following tables based on their foreign key references (i.e., `dataset <- experiment <- replicate`)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.facebase.org/ermrest/catalog/1/entity/dataset:=isa:dataset/experiment:=isa:experiment/replicate:=isa:replicate\n"
     ]
    }
   ],
   "source": [
    "path.link(experiment).link(replicate)\n",
    "print(path.uri)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "### Path context\n",
    "By default, `DataPath` objects return entities for the _last_ linked entity set in the path. The `path` from the prior step ended in `replicate` which is therefore the `context` for this path."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'replicate'"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path.context.name"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get entities for the current context\n",
    "The following DataPath will fetch `replicate` entities not `dataset`s."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3132"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "entities = path.entities()\n",
    "len(entities)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get entities for a different path context\n",
    "Let's say we wanted to fetch the entities for the `dataset` table rather than the current context which is the `replicate` table. We can do that by referencing the table as a property of the path object. **Note** that these are known as \"table instances\" rather than tables when used within a path expression. We will discuss table instances later in this notebook."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "Table name: 'dataset'\n",
       "List of columns:\n",
       "  id\n",
       "  accession\n",
       "  title\n",
       "  project\n",
       "  funding\n",
       "  summary\n",
       "  description\n",
       "  mouse_genetic\n",
       "  human_anatomic\n",
       "  study_design\n",
       "  release_date\n",
       "  show_in_jbrowse\n",
       "  _keywords\n",
       "  RID\n",
       "  RCB\n",
       "  RMB\n",
       "  RCT\n",
       "  RMT\n",
       "  released"
      ],
      "text/plain": [
       "<deriva.core.datapath.TableAlias at 0x10a35d8d0>"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path.table_instances['dataset']\n",
    "# or\n",
    "path.dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "From that table instance we can fetch entities, add a filter specific to that table instance, or even link another table. Here we will get the `dataset` entities from the path."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "120"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "entities = path.dataset.entities()\n",
    "len(entities)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Notice that we fetched fewer entities this time which is the number of `dataset` entities rather than the `replicate` entities that we previously fetched."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filtering a DataPath\n",
    "\n",
    "Building off of the path, a filter can be added. Like fetching entities, linking and filtering are performed _relative to the current context_. In this filter, the assay's attriburtes are referenced in the expression.\n",
    "\n",
    "Currently, _binary comparisons_ and _logical operators_ are supported. _Unary opertors_ have not yet been implemented. In binary comparisons, the left operand must be an attribute (column name) while the right operand must be a literal\n",
    "value."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.facebase.org/ermrest/catalog/1/entity/dataset:=isa:dataset/experiment:=isa:experiment/replicate:=isa:replicate/bioreplicate_number=1\n"
     ]
    }
   ],
   "source": [
    "path.filter(replicate.bioreplicate_number == 1)\n",
    "print(path.uri)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "765"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "entities = path.entities()\n",
    "len(entities)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's see it rendered as a Pandas DataFrame."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>RCB</th>\n",
       "      <th>RCT</th>\n",
       "      <th>RID</th>\n",
       "      <th>RMB</th>\n",
       "      <th>RMT</th>\n",
       "      <th>bioreplicate_number</th>\n",
       "      <th>biosample</th>\n",
       "      <th>dataset</th>\n",
       "      <th>experiment</th>\n",
       "      <th>technical_replicate_number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T12:45:26.363625-07:00</td>\n",
       "      <td>1-3SE6</td>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T12:45:26.363625-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3SE2</td>\n",
       "      <td>1-3SB2</td>\n",
       "      <td>1-3SD2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T14:31:19.620159-07:00</td>\n",
       "      <td>1-3SJ2</td>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T14:31:19.620159-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3SHY</td>\n",
       "      <td>1-3SGA</td>\n",
       "      <td>1-3SHT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T14:48:55.912218-07:00</td>\n",
       "      <td>1-3SP6</td>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T14:48:55.912218-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3SP2</td>\n",
       "      <td>1-3SM2</td>\n",
       "      <td>1-3SNY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T15:02:14.625232-07:00</td>\n",
       "      <td>1-3SSA</td>\n",
       "      <td>https://auth.globus.org/a1d30d14-b3b0-49de-854...</td>\n",
       "      <td>2018-06-08T15:02:14.625232-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3SS6</td>\n",
       "      <td>1-3SQJ</td>\n",
       "      <td>1-3SS2</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1-3T5A</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T0A</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZA</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1-3T5E</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T0E</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZA</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1-3T5J</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T0J</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZA</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1-3T5P</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T0P</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZA</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1-3T5T</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:41:16.162698-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T0T</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZA</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1-3T6T</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T0Y</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1-3T6Y</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T12</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1-3T72</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T16</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1-3T76</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T1A</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1-3T7A</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:47:38.483851-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T1E</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZE</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1-3T86</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T1J</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZJ</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1-3T8A</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T1P</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZJ</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1-3T8E</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T1T</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZJ</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1-3T8J</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T1Y</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZJ</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1-3T8P</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:51:59.083357-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T22</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZJ</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1-3T9J</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T26</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1-3T9P</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T2A</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1-3T9T</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T2E</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1-3T9Y</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T2J</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1-3TA2</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:54:25.409906-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T2P</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZP</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1-3TB2</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T2T</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1-3TB6</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T2Y</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1-3TBA</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T32</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1-3TBE</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T36</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1-3TBJ</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:55:48.137336-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T3A</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:57:27.431803-07:00</td>\n",
       "      <td>1-3TCJ</td>\n",
       "      <td>https://auth.globus.org/f8ae714f-6015-48da-971...</td>\n",
       "      <td>2018-06-13T16:57:27.431803-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>1-3T3E</td>\n",
       "      <td>1-3SWE</td>\n",
       "      <td>1-3SZY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>735</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-03-26T16:36:10.863089-07:00</td>\n",
       "      <td>3S6E</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3RZY</td>\n",
       "      <td>VQ4</td>\n",
       "      <td>3S1Y</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>736</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-03-27T16:59:54.24287-07:00</td>\n",
       "      <td>3SZ2</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3SXP</td>\n",
       "      <td>VDE</td>\n",
       "      <td>3SV6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>737</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-03-27T17:01:02.304091-07:00</td>\n",
       "      <td>3SZE</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3SY2</td>\n",
       "      <td>VDE</td>\n",
       "      <td>3SYT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>738</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-03-27T17:02:06.673969-07:00</td>\n",
       "      <td>3SZT</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3SYE</td>\n",
       "      <td>VDE</td>\n",
       "      <td>3SYY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>739</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:23:06.756915-07:00</td>\n",
       "      <td>3T62</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T3P</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T5Y</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:39:41.239168-07:00</td>\n",
       "      <td>3T8J</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T3T</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T6T</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>741</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:40:11.426804-07:00</td>\n",
       "      <td>3T8P</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T3Y</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T6Y</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>742</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:40:35.072511-07:00</td>\n",
       "      <td>3T8T</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T42</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T72</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>743</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:41:02.330199-07:00</td>\n",
       "      <td>3T8Y</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T46</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T76</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>744</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:53:49.707626-07:00</td>\n",
       "      <td>3T92</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T4A</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T7A</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>745</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:57:47.778732-07:00</td>\n",
       "      <td>3T96</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T4E</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T7E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>746</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T14:59:19.874396-07:00</td>\n",
       "      <td>3T9A</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T4T</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T7P</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:00:00.866205-07:00</td>\n",
       "      <td>3T9E</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T4P</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T7T</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>748</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:00:51.75637-07:00</td>\n",
       "      <td>3T9J</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T4Y</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T7Y</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:01:27.102249-07:00</td>\n",
       "      <td>3T9P</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T52</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T82</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:02:02.193199-07:00</td>\n",
       "      <td>3T9T</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T56</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T86</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:02:32.834426-07:00</td>\n",
       "      <td>3T9Y</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T5A</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T8A</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:03:05.577721-07:00</td>\n",
       "      <td>3TA2</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T5E</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T8E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-02T15:05:14.27574-07:00</td>\n",
       "      <td>3TA6</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3T4J</td>\n",
       "      <td>VAC</td>\n",
       "      <td>3T7J</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>754</th>\n",
       "      <td>https://auth.globus.org/bb256144-d274-11e5-adb...</td>\n",
       "      <td>2018-04-06T11:33:05.8501-07:00</td>\n",
       "      <td>3TH2</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3TGT</td>\n",
       "      <td>3TGJ</td>\n",
       "      <td>3TGY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>755</th>\n",
       "      <td>https://auth.globus.org/bb256144-d274-11e5-adb...</td>\n",
       "      <td>2018-04-06T11:46:57.679319-07:00</td>\n",
       "      <td>3TK2</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3TJT</td>\n",
       "      <td>3TJA</td>\n",
       "      <td>3TJY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>756</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-06T11:54:06.84542-07:00</td>\n",
       "      <td>3TKP</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3TJE</td>\n",
       "      <td>3THE</td>\n",
       "      <td>3THT</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>757</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-06T12:12:32.335272-07:00</td>\n",
       "      <td>3TNJ</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3TNA</td>\n",
       "      <td>3TM6</td>\n",
       "      <td>3TMY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>758</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-11T12:26:16.576316-07:00</td>\n",
       "      <td>3TSE</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>30AA</td>\n",
       "      <td>2ARP</td>\n",
       "      <td>341Y</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>https://auth.globus.org/b506963e-d274-11e5-99f...</td>\n",
       "      <td>2018-04-11T12:28:24.259798-07:00</td>\n",
       "      <td>3TSJ</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>30GP</td>\n",
       "      <td>2ARP</td>\n",
       "      <td>3422</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>https://auth.globus.org/8ae274db-d033-47eb-bd3...</td>\n",
       "      <td>2018-05-04T13:57:05.981299-07:00</td>\n",
       "      <td>3V3A</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3V06</td>\n",
       "      <td>3TYP</td>\n",
       "      <td>3TZY</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>https://auth.globus.org/8ae274db-d033-47eb-bd3...</td>\n",
       "      <td>2018-05-04T13:58:26.138503-07:00</td>\n",
       "      <td>3V3E</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3V0A</td>\n",
       "      <td>3TYP</td>\n",
       "      <td>3V02</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>https://auth.globus.org/8ae274db-d033-47eb-bd3...</td>\n",
       "      <td>2018-05-04T14:00:18.896079-07:00</td>\n",
       "      <td>3V3J</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3V1P</td>\n",
       "      <td>3V0E</td>\n",
       "      <td>3V1J</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>https://auth.globus.org/8ae274db-d033-47eb-bd3...</td>\n",
       "      <td>2018-05-04T14:03:00.875741-07:00</td>\n",
       "      <td>3V3P</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3V1Y</td>\n",
       "      <td>3V0E</td>\n",
       "      <td>3V1T</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>https://auth.globus.org/aea1663e-d274-11e5-b9e...</td>\n",
       "      <td>2018-05-07T11:31:52.577241-07:00</td>\n",
       "      <td>3V4Y</td>\n",
       "      <td>None</td>\n",
       "      <td>2018-06-05T18:44:38.502116-07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>3V4T</td>\n",
       "      <td>3V4A</td>\n",
       "      <td>3V4P</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>765 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   RCB  \\\n",
       "0    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "1    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "2    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "3    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "4    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "5    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "6    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "7    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "8    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "9    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "10   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "11   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "12   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "13   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "14   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "15   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "16   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "17   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "18   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "19   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "20   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "21   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "22   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "23   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "24   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "25   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "26   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "27   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "28   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "29   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "..                                                 ...   \n",
       "735  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "736  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "737  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "738  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "739  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "740  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "741  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "742  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "743  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "744  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "745  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "746  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "747  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "748  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "749  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "750  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "751  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "752  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "753  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "754  https://auth.globus.org/bb256144-d274-11e5-adb...   \n",
       "755  https://auth.globus.org/bb256144-d274-11e5-adb...   \n",
       "756  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "757  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "758  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "759  https://auth.globus.org/b506963e-d274-11e5-99f...   \n",
       "760  https://auth.globus.org/8ae274db-d033-47eb-bd3...   \n",
       "761  https://auth.globus.org/8ae274db-d033-47eb-bd3...   \n",
       "762  https://auth.globus.org/8ae274db-d033-47eb-bd3...   \n",
       "763  https://auth.globus.org/8ae274db-d033-47eb-bd3...   \n",
       "764  https://auth.globus.org/aea1663e-d274-11e5-b9e...   \n",
       "\n",
       "                                  RCT     RID  \\\n",
       "0    2018-06-08T12:45:26.363625-07:00  1-3SE6   \n",
       "1    2018-06-08T14:31:19.620159-07:00  1-3SJ2   \n",
       "2    2018-06-08T14:48:55.912218-07:00  1-3SP6   \n",
       "3    2018-06-08T15:02:14.625232-07:00  1-3SSA   \n",
       "4    2018-06-13T16:41:16.162698-07:00  1-3T5A   \n",
       "5    2018-06-13T16:41:16.162698-07:00  1-3T5E   \n",
       "6    2018-06-13T16:41:16.162698-07:00  1-3T5J   \n",
       "7    2018-06-13T16:41:16.162698-07:00  1-3T5P   \n",
       "8    2018-06-13T16:41:16.162698-07:00  1-3T5T   \n",
       "9    2018-06-13T16:47:38.483851-07:00  1-3T6T   \n",
       "10   2018-06-13T16:47:38.483851-07:00  1-3T6Y   \n",
       "11   2018-06-13T16:47:38.483851-07:00  1-3T72   \n",
       "12   2018-06-13T16:47:38.483851-07:00  1-3T76   \n",
       "13   2018-06-13T16:47:38.483851-07:00  1-3T7A   \n",
       "14   2018-06-13T16:51:59.083357-07:00  1-3T86   \n",
       "15   2018-06-13T16:51:59.083357-07:00  1-3T8A   \n",
       "16   2018-06-13T16:51:59.083357-07:00  1-3T8E   \n",
       "17   2018-06-13T16:51:59.083357-07:00  1-3T8J   \n",
       "18   2018-06-13T16:51:59.083357-07:00  1-3T8P   \n",
       "19   2018-06-13T16:54:25.409906-07:00  1-3T9J   \n",
       "20   2018-06-13T16:54:25.409906-07:00  1-3T9P   \n",
       "21   2018-06-13T16:54:25.409906-07:00  1-3T9T   \n",
       "22   2018-06-13T16:54:25.409906-07:00  1-3T9Y   \n",
       "23   2018-06-13T16:54:25.409906-07:00  1-3TA2   \n",
       "24   2018-06-13T16:55:48.137336-07:00  1-3TB2   \n",
       "25   2018-06-13T16:55:48.137336-07:00  1-3TB6   \n",
       "26   2018-06-13T16:55:48.137336-07:00  1-3TBA   \n",
       "27   2018-06-13T16:55:48.137336-07:00  1-3TBE   \n",
       "28   2018-06-13T16:55:48.137336-07:00  1-3TBJ   \n",
       "29   2018-06-13T16:57:27.431803-07:00  1-3TCJ   \n",
       "..                                ...     ...   \n",
       "735  2018-03-26T16:36:10.863089-07:00    3S6E   \n",
       "736   2018-03-27T16:59:54.24287-07:00    3SZ2   \n",
       "737  2018-03-27T17:01:02.304091-07:00    3SZE   \n",
       "738  2018-03-27T17:02:06.673969-07:00    3SZT   \n",
       "739  2018-04-02T14:23:06.756915-07:00    3T62   \n",
       "740  2018-04-02T14:39:41.239168-07:00    3T8J   \n",
       "741  2018-04-02T14:40:11.426804-07:00    3T8P   \n",
       "742  2018-04-02T14:40:35.072511-07:00    3T8T   \n",
       "743  2018-04-02T14:41:02.330199-07:00    3T8Y   \n",
       "744  2018-04-02T14:53:49.707626-07:00    3T92   \n",
       "745  2018-04-02T14:57:47.778732-07:00    3T96   \n",
       "746  2018-04-02T14:59:19.874396-07:00    3T9A   \n",
       "747  2018-04-02T15:00:00.866205-07:00    3T9E   \n",
       "748   2018-04-02T15:00:51.75637-07:00    3T9J   \n",
       "749  2018-04-02T15:01:27.102249-07:00    3T9P   \n",
       "750  2018-04-02T15:02:02.193199-07:00    3T9T   \n",
       "751  2018-04-02T15:02:32.834426-07:00    3T9Y   \n",
       "752  2018-04-02T15:03:05.577721-07:00    3TA2   \n",
       "753   2018-04-02T15:05:14.27574-07:00    3TA6   \n",
       "754    2018-04-06T11:33:05.8501-07:00    3TH2   \n",
       "755  2018-04-06T11:46:57.679319-07:00    3TK2   \n",
       "756   2018-04-06T11:54:06.84542-07:00    3TKP   \n",
       "757  2018-04-06T12:12:32.335272-07:00    3TNJ   \n",
       "758  2018-04-11T12:26:16.576316-07:00    3TSE   \n",
       "759  2018-04-11T12:28:24.259798-07:00    3TSJ   \n",
       "760  2018-05-04T13:57:05.981299-07:00    3V3A   \n",
       "761  2018-05-04T13:58:26.138503-07:00    3V3E   \n",
       "762  2018-05-04T14:00:18.896079-07:00    3V3J   \n",
       "763  2018-05-04T14:03:00.875741-07:00    3V3P   \n",
       "764  2018-05-07T11:31:52.577241-07:00    3V4Y   \n",
       "\n",
       "                                                   RMB  \\\n",
       "0    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "1    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "2    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "3    https://auth.globus.org/a1d30d14-b3b0-49de-854...   \n",
       "4    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "5    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "6    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "7    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "8    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "9    https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "10   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "11   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "12   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "13   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "14   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "15   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "16   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "17   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "18   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "19   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "20   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "21   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "22   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "23   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "24   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "25   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "26   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "27   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "28   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "29   https://auth.globus.org/f8ae714f-6015-48da-971...   \n",
       "..                                                 ...   \n",
       "735                                               None   \n",
       "736                                               None   \n",
       "737                                               None   \n",
       "738                                               None   \n",
       "739                                               None   \n",
       "740                                               None   \n",
       "741                                               None   \n",
       "742                                               None   \n",
       "743                                               None   \n",
       "744                                               None   \n",
       "745                                               None   \n",
       "746                                               None   \n",
       "747                                               None   \n",
       "748                                               None   \n",
       "749                                               None   \n",
       "750                                               None   \n",
       "751                                               None   \n",
       "752                                               None   \n",
       "753                                               None   \n",
       "754                                               None   \n",
       "755                                               None   \n",
       "756                                               None   \n",
       "757                                               None   \n",
       "758                                               None   \n",
       "759                                               None   \n",
       "760                                               None   \n",
       "761                                               None   \n",
       "762                                               None   \n",
       "763                                               None   \n",
       "764                                               None   \n",
       "\n",
       "                                  RMT  bioreplicate_number biosample dataset  \\\n",
       "0    2018-06-08T12:45:26.363625-07:00                    1    1-3SE2  1-3SB2   \n",
       "1    2018-06-08T14:31:19.620159-07:00                    1    1-3SHY  1-3SGA   \n",
       "2    2018-06-08T14:48:55.912218-07:00                    1    1-3SP2  1-3SM2   \n",
       "3    2018-06-08T15:02:14.625232-07:00                    1    1-3SS6  1-3SQJ   \n",
       "4    2018-06-13T16:41:16.162698-07:00                    1    1-3T0A  1-3SWE   \n",
       "5    2018-06-13T16:41:16.162698-07:00                    1    1-3T0E  1-3SWE   \n",
       "6    2018-06-13T16:41:16.162698-07:00                    1    1-3T0J  1-3SWE   \n",
       "7    2018-06-13T16:41:16.162698-07:00                    1    1-3T0P  1-3SWE   \n",
       "8    2018-06-13T16:41:16.162698-07:00                    1    1-3T0T  1-3SWE   \n",
       "9    2018-06-13T16:47:38.483851-07:00                    1    1-3T0Y  1-3SWE   \n",
       "10   2018-06-13T16:47:38.483851-07:00                    1    1-3T12  1-3SWE   \n",
       "11   2018-06-13T16:47:38.483851-07:00                    1    1-3T16  1-3SWE   \n",
       "12   2018-06-13T16:47:38.483851-07:00                    1    1-3T1A  1-3SWE   \n",
       "13   2018-06-13T16:47:38.483851-07:00                    1    1-3T1E  1-3SWE   \n",
       "14   2018-06-13T16:51:59.083357-07:00                    1    1-3T1J  1-3SWE   \n",
       "15   2018-06-13T16:51:59.083357-07:00                    1    1-3T1P  1-3SWE   \n",
       "16   2018-06-13T16:51:59.083357-07:00                    1    1-3T1T  1-3SWE   \n",
       "17   2018-06-13T16:51:59.083357-07:00                    1    1-3T1Y  1-3SWE   \n",
       "18   2018-06-13T16:51:59.083357-07:00                    1    1-3T22  1-3SWE   \n",
       "19   2018-06-13T16:54:25.409906-07:00                    1    1-3T26  1-3SWE   \n",
       "20   2018-06-13T16:54:25.409906-07:00                    1    1-3T2A  1-3SWE   \n",
       "21   2018-06-13T16:54:25.409906-07:00                    1    1-3T2E  1-3SWE   \n",
       "22   2018-06-13T16:54:25.409906-07:00                    1    1-3T2J  1-3SWE   \n",
       "23   2018-06-13T16:54:25.409906-07:00                    1    1-3T2P  1-3SWE   \n",
       "24   2018-06-13T16:55:48.137336-07:00                    1    1-3T2T  1-3SWE   \n",
       "25   2018-06-13T16:55:48.137336-07:00                    1    1-3T2Y  1-3SWE   \n",
       "26   2018-06-13T16:55:48.137336-07:00                    1    1-3T32  1-3SWE   \n",
       "27   2018-06-13T16:55:48.137336-07:00                    1    1-3T36  1-3SWE   \n",
       "28   2018-06-13T16:55:48.137336-07:00                    1    1-3T3A  1-3SWE   \n",
       "29   2018-06-13T16:57:27.431803-07:00                    1    1-3T3E  1-3SWE   \n",
       "..                                ...                  ...       ...     ...   \n",
       "735  2018-06-05T18:44:38.502116-07:00                    1      3RZY     VQ4   \n",
       "736  2018-06-05T18:44:38.502116-07:00                    1      3SXP     VDE   \n",
       "737  2018-06-05T18:44:38.502116-07:00                    1      3SY2     VDE   \n",
       "738  2018-06-05T18:44:38.502116-07:00                    1      3SYE     VDE   \n",
       "739  2018-06-05T18:44:38.502116-07:00                    1      3T3P     VAC   \n",
       "740  2018-06-05T18:44:38.502116-07:00                    1      3T3T     VAC   \n",
       "741  2018-06-05T18:44:38.502116-07:00                    1      3T3Y     VAC   \n",
       "742  2018-06-05T18:44:38.502116-07:00                    1      3T42     VAC   \n",
       "743  2018-06-05T18:44:38.502116-07:00                    1      3T46     VAC   \n",
       "744  2018-06-05T18:44:38.502116-07:00                    1      3T4A     VAC   \n",
       "745  2018-06-05T18:44:38.502116-07:00                    1      3T4E     VAC   \n",
       "746  2018-06-05T18:44:38.502116-07:00                    1      3T4T     VAC   \n",
       "747  2018-06-05T18:44:38.502116-07:00                    1      3T4P     VAC   \n",
       "748  2018-06-05T18:44:38.502116-07:00                    1      3T4Y     VAC   \n",
       "749  2018-06-05T18:44:38.502116-07:00                    1      3T52     VAC   \n",
       "750  2018-06-05T18:44:38.502116-07:00                    1      3T56     VAC   \n",
       "751  2018-06-05T18:44:38.502116-07:00                    1      3T5A     VAC   \n",
       "752  2018-06-05T18:44:38.502116-07:00                    1      3T5E     VAC   \n",
       "753  2018-06-05T18:44:38.502116-07:00                    1      3T4J     VAC   \n",
       "754  2018-06-05T18:44:38.502116-07:00                    1      3TGT    3TGJ   \n",
       "755  2018-06-05T18:44:38.502116-07:00                    1      3TJT    3TJA   \n",
       "756  2018-06-05T18:44:38.502116-07:00                    1      3TJE    3THE   \n",
       "757  2018-06-05T18:44:38.502116-07:00                    1      3TNA    3TM6   \n",
       "758  2018-06-05T18:44:38.502116-07:00                    1      30AA    2ARP   \n",
       "759  2018-06-05T18:44:38.502116-07:00                    1      30GP    2ARP   \n",
       "760  2018-06-05T18:44:38.502116-07:00                    1      3V06    3TYP   \n",
       "761  2018-06-05T18:44:38.502116-07:00                    1      3V0A    3TYP   \n",
       "762  2018-06-05T18:44:38.502116-07:00                    1      3V1P    3V0E   \n",
       "763  2018-06-05T18:44:38.502116-07:00                    1      3V1Y    3V0E   \n",
       "764  2018-06-05T18:44:38.502116-07:00                    1      3V4T    3V4A   \n",
       "\n",
       "    experiment  technical_replicate_number  \n",
       "0       1-3SD2                           1  \n",
       "1       1-3SHT                           1  \n",
       "2       1-3SNY                           1  \n",
       "3       1-3SS2                           1  \n",
       "4       1-3SZA                           1  \n",
       "5       1-3SZA                           1  \n",
       "6       1-3SZA                           1  \n",
       "7       1-3SZA                           1  \n",
       "8       1-3SZA                           1  \n",
       "9       1-3SZE                           1  \n",
       "10      1-3SZE                           1  \n",
       "11      1-3SZE                           1  \n",
       "12      1-3SZE                           1  \n",
       "13      1-3SZE                           1  \n",
       "14      1-3SZJ                           1  \n",
       "15      1-3SZJ                           1  \n",
       "16      1-3SZJ                           1  \n",
       "17      1-3SZJ                           1  \n",
       "18      1-3SZJ                           1  \n",
       "19      1-3SZP                           1  \n",
       "20      1-3SZP                           1  \n",
       "21      1-3SZP                           1  \n",
       "22      1-3SZP                           1  \n",
       "23      1-3SZP                           1  \n",
       "24      1-3SZT                           1  \n",
       "25      1-3SZT                           1  \n",
       "26      1-3SZT                           1  \n",
       "27      1-3SZT                           1  \n",
       "28      1-3SZT                           1  \n",
       "29      1-3SZY                           1  \n",
       "..         ...                         ...  \n",
       "735       3S1Y                           1  \n",
       "736       3SV6                           1  \n",
       "737       3SYT                           1  \n",
       "738       3SYY                           1  \n",
       "739       3T5Y                           1  \n",
       "740       3T6T                           1  \n",
       "741       3T6Y                           1  \n",
       "742       3T72                           1  \n",
       "743       3T76                           1  \n",
       "744       3T7A                           1  \n",
       "745       3T7E                           1  \n",
       "746       3T7P                           1  \n",
       "747       3T7T                           1  \n",
       "748       3T7Y                           1  \n",
       "749       3T82                           1  \n",
       "750       3T86                           1  \n",
       "751       3T8A                           1  \n",
       "752       3T8E                           1  \n",
       "753       3T7J                           1  \n",
       "754       3TGY                           1  \n",
       "755       3TJY                           1  \n",
       "756       3THT                           1  \n",
       "757       3TMY                           1  \n",
       "758       341Y                           1  \n",
       "759       3422                           1  \n",
       "760       3TZY                           1  \n",
       "761       3V02                           1  \n",
       "762       3V1J                           1  \n",
       "763       3V1T                           1  \n",
       "764       3V4P                           1  \n",
       "\n",
       "[765 rows x 10 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "entities.dataframe"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Table Instances\n",
    "So far we have discussed _base_ tables. A _base_ table is a representation of the table as it is stored in the ERMrest catalog. A table _instance_ is a usage or reference of a table _within the context_ of a data path. As demonstrated above, we may link together multiple tables and thus create multiple table instances within a data path.\n",
    "\n",
    "For example, in `path.link(dataset).link(experiment).link(replicate)` the table instance `experiment` is no longer the same as the original base table `experiment` because _within the context_ of this data path the `experiment` entities must satisfy the constraints of the data path. The `experiment` entities must reference a `dataset` entity, and they must be referenced by a `replicate` entity. Thus within this path, the entity set for `experiment` may be quite different than the entity set for the base table on its own."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Table instances are bound to the path\n",
    "Whenever you initiate a data path (e.g., `table.path`) or link a table to a path (e.g., `path.link(table)`) a table instance is created and bound to the DataPath object (e.g., `path`). These table instances can be referenced via the `DataPath`'s `table_instances` container or directly as a property of the `DataPath` object itself."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset_instance = path.table_instances['dataset']\n",
    "# or\n",
    "dataset_instance = path.dataset"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Aliases for table instances\n",
    "Whenever a table instance is created and bound to a path, it is given a name. If no name is specified for it, it will be named after the name of its base table. For example, a table named \"My Table\" will result in a table instance also named \"My Table\". Tables may appear _more than once_ in a path (as table instances), and if the table name is taken, the instance will be given the \"'base name' + `number`\" (e.g., \"My Table2\").\n",
    "\n",
    "You may wish to specify the name of your table instance. In conventional database terms, an alternate name is called an \"alias\". Here we give the `dataset` table instance an alias of 'D' though longer strings are also valid as long as they do not contain special characters in them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<deriva.core.datapath.DataPath at 0x10a35d898>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path.link(dataset.alias('D'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://www.facebase.org/ermrest/catalog/1/entity/dataset:=isa:dataset/experiment:=isa:experiment/replicate:=isa:replicate/bioreplicate_number=1/D:=isa:dataset'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path.D.uri"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You'll notice that in this path we added an additional _instance_ of the `dataset` table from our catalog model. In addition, we linked it to the `isa.replicate` table. This was possible because in this model, there is a foriegn key reference from the base table `replicate` to the base table `dataset`. The entities for the table instance named `dataset` and the instance name `D` will likely consist of different entities because the constraints for each are different."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "## Selecting Attributes From Linked Entities\n",
    "\n",
    "Returning to the initial example, if we want to include additional attributes\n",
    "from other table instances in the path, we need to be able to reference the\n",
    "table instances at any point in the path. First, we will build our original path."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.facebase.org/ermrest/catalog/1/entity/dataset:=isa:dataset/experiment:=isa:experiment/replicate:=isa:replicate/bioreplicate_number=1\n"
     ]
    }
   ],
   "source": [
    "path = dataset.path.link(experiment).link(replicate).filter(replicate.bioreplicate_number == 1)\n",
    "print(path.uri) "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Now let's fetch an entity set with attributes pulled from each of the table instances in the path."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.facebase.org/ermrest/catalog/1/attribute/dataset:=isa:dataset/experiment:=isa:experiment/replicate:=isa:replicate/bioreplicate_number=1/dataset:accession,type_of_experiment:=experiment:experiment_type,technical_replicate_num:=replicate:technical_replicate_number\n"
     ]
    }
   ],
   "source": [
    "results = path.attributes(path.dataset.accession, \n",
    "                          type_of_experiment=path.experiment.experiment_type, \n",
    "                          technical_replicate_num=path.replicate.technical_replicate_number)\n",
    "print(results.uri)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**Notice** that the `ResultSet` also has a `uri` property. This URI may differ from the origin path URI because the attribute projection does not get appended to the path URI."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "path.uri != results.uri"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As usual, `fetch(...)` the entities from the catalog."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'accession': 'FB00000975', 'type_of_experiment': 'OBI:0002083', 'technical_replicate_num': 1}\n",
      "{'accession': 'FB00000976', 'type_of_experiment': 'OBI:0002083', 'technical_replicate_num': 1}\n",
      "{'accession': 'FB00000977', 'type_of_experiment': 'OBI:0002083', 'technical_replicate_num': 1}\n",
      "{'accession': 'FB00000978', 'type_of_experiment': 'OBI:0002083', 'technical_replicate_num': 1}\n",
      "{'accession': 'FB00000985', 'type_of_experiment': 'OBI:0001271', 'technical_replicate_num': 1}\n"
     ]
    }
   ],
   "source": [
    "results.fetch(limit=5)\n",
    "for result in results:\n",
    "    print(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}