Workflows-tutorial/AccessTG-GatesData.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pip._internal import main as pip\n",
    "\n",
    "try:\n",
    "    import pprint\n",
    "except ImportError:\n",
    "    pip(['install', 'pprint'])\n",
    "    import pprint\n",
    "\n",
    "try:\n",
    "    import requests\n",
    "except ImportError:\n",
    "    pip(['install', 'requests'])\n",
    "    import requests\n",
    "\n",
    "try:\n",
    "    import pandas as pd\n",
    "except ImportError:\n",
    "    pip(['install', 'pandas'])\n",
    "    import pandas as pd\n",
    "\n",
    "try:\n",
    "    import simplejson as json\n",
    "except ImportError:\n",
    "    pip(['install', 'simplejson'])\n",
    "    import simplejson as json\n",
    "\n",
    "import re\n",
    "\n",
    "pd.set_option('display.max_colwidth', -1)\n",
    "pd.set_option('display.max_rows', 99999)\n",
    "pd.set_option('display.max_columns', 99999)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Select EdelweissData server and authenticate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "try:\n",
    "    from edelweiss_data import API, QueryExpression as Q\n",
    "except ImportError:\n",
    "    from edelweiss_data import API, QueryExpression as Q\n",
    "\n",
    "edelweiss_api_url = 'https://api.develop.edelweiss.douglasconnect.com'\n",
    "api = API(edelweiss_api_url)\n",
    "api.authenticate()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## List metadata of all TG-Gates sets on the server"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns = [\n",
    "#    (\"Metadata\", \"$\"),\n",
    "    (\"Compound\", \"$.Compound.Name\"),\n",
    "    (\"SMILES\", \"$.Compound.SMILES\"),\n",
    "    (\"Organism\", \"$.Assay.Organism\"),\n",
    "    (\"Study type\", \"$.Assay.\\\"Study type\\\"\"),\n",
    "    (\"Organ\", \"$.Assay.Organ\"),\n",
    "    (\"Dose\", \"$.Assay.Exposure.Dose\"),\n",
    "    (\"Duration\", \"$.Assay.Exposure.Duration\")\n",
    "]\n",
    "condition = Q.search_anywhere(\"TG-GATES\")\n",
    "TGGATES = api.get_published_datasets(limit=200, columns=columns, condition=condition)\n",
    "#TGGATES"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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></th>\n",
       "      <th>dataset</th>\n",
       "      <th>Compound</th>\n",
       "      <th>SMILES</th>\n",
       "      <th>Organism</th>\n",
       "      <th>Study type</th>\n",
       "      <th>Organ</th>\n",
       "      <th>Dose</th>\n",
       "      <th>Duration</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th>version</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>472755fe-211b-40a0-a05b-696a2a384aff</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '472755fe-211b-40a0-a05b-696a2a384aff':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_24_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ece66bab-bee8-47f1-8f16-b154f6e3f359</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'ece66bab-bee8-47f1-8f16-b154f6e3f359':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_24_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>a7908788-399f-4449-820d-f321ca387232</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'a7908788-399f-4449-820d-f321ca387232':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_24_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"fenofibrate\"</td>\n",
       "      <td>\"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66f8d3e3-d470-49a4-af08-2625d3ec42aa</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '66f8d3e3-d470-49a4-af08-2625d3ec42aa':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e40ebbc7-844d-4b79-b5c0-10c36fd6eb77</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'e40ebbc7-844d-4b79-b5c0-10c36fd6eb77':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"fenofibrate\"</td>\n",
       "      <td>\"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>912b41ce-bb1f-47fb-8b8f-e88cb8744315</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '912b41ce-bb1f-47fb-8b8f-e88cb8744315':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_24_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>530f243f-ded1-4fe1-a01e-37995296dde3</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '530f243f-ded1-4fe1-a01e-37995296dde3':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_8_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>acb77d9b-9d0e-425a-a67a-c78bb5c4663d</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'acb77d9b-9d0e-425a-a67a-c78bb5c4663d':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4b6aa018-0cf8-47a5-8ce0-1a5551e9f634</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '4b6aa018-0cf8-47a5-8ce0-1a5551e9f634':1 - TG-GATES-ORN_cs_aoplink_gemfibrozil_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"gemfibrozil\"</td>\n",
       "      <td>\"CC1=CC(=C(C=C1)C)OCCCC(C)(C)C(=O)O\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4a211f9d-2c43-43d6-9561-1c2ad6d17c77</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '4a211f9d-2c43-43d6-9561-1c2ad6d17c77':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_2_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34617dcd-4c45-4f7f-90fd-f390abab60c9</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '34617dcd-4c45-4f7f-90fd-f390abab60c9':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_2_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e2b62348-5421-4dfb-aa73-fb95d3998ce0</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'e2b62348-5421-4dfb-aa73-fb95d3998ce0':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_24_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78c29410-8bb0-4d4b-85d2-27dde8a64739</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '78c29410-8bb0-4d4b-85d2-27dde8a64739':1 - TG-GATES-ORN_cs_aoplink_gemfibrozil_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"gemfibrozil\"</td>\n",
       "      <td>\"CC1=CC(=C(C=C1)C)OCCCC(C)(C)C(=O)O\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198799ee-3228-4de2-b197-3c176ba4d8e6</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '198799ee-3228-4de2-b197-3c176ba4d8e6':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_2_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>969ec4ba-0fd7-4782-8c31-04f0129fbd12</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '969ec4ba-0fd7-4782-8c31-04f0129fbd12':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_24_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"fenofibrate\"</td>\n",
       "      <td>\"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2a3dd77a-5464-4dbe-9984-91c73044aa5b</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '2a3dd77a-5464-4dbe-9984-91c73044aa5b':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"fenofibrate\"</td>\n",
       "      <td>\"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5b93fdca-eab6-4ae7-a071-763d1af367f4</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '5b93fdca-eab6-4ae7-a071-763d1af367f4':1 - TG-GATES-ORN_cs_aoplink_gemfibrozil_Human_Liver_in vitro_8_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"gemfibrozil\"</td>\n",
       "      <td>\"CC1=CC(=C(C=C1)C)OCCCC(C)(C)C(=O)O\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49e8e9bd-bb29-4715-ad35-fef351f8bbe9</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '49e8e9bd-bb29-4715-ad35-fef351f8bbe9':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_8_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dde3e916-ae10-4cab-9511-287bf62bb861</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'dde3e916-ae10-4cab-9511-287bf62bb861':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_24_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>881e6c03-9e14-4265-9dd3-afc94ef05e2d</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '881e6c03-9e14-4265-9dd3-afc94ef05e2d':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_2_hr_low_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"low\"</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56efddc9-6b42-4402-a1ec-1e8a50665825</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '56efddc9-6b42-4402-a1ec-1e8a50665825':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_2_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9901c889-3eb3-469e-bd12-46bfc401d86a</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '9901c889-3eb3-469e-bd12-46bfc401d86a':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_2_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"clofibrate\"</td>\n",
       "      <td>\"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>a4af3ef9-aa3e-4aa4-8493-964860da9a8f</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset 'a4af3ef9-aa3e-4aa4-8493-964860da9a8f':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_24_hr_middle_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"middle\"</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294b845f-8434-496e-99bb-3682dbcf7255</th>\n",
       "      <th>1</th>\n",
       "      <td>&lt;PublishedDataset '294b845f-8434-496e-99bb-3682dbcf7255':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES&gt;</td>\n",
       "      <td>\"WY-14643\"</td>\n",
       "      <td>\"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"</td>\n",
       "      <td>\"Human\"</td>\n",
       "      <td>\"in_vitro\"</td>\n",
       "      <td>\"Liver\"</td>\n",
       "      <td>\"high\"</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                                                                                                       dataset  \\\n",
       "id                                   version                                                                                                                                                     \n",
       "472755fe-211b-40a0-a05b-696a2a384aff 1        <PublishedDataset '472755fe-211b-40a0-a05b-696a2a384aff':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_24_hr_high_FOLD_CHANGES>        \n",
       "ece66bab-bee8-47f1-8f16-b154f6e3f359 1        <PublishedDataset 'ece66bab-bee8-47f1-8f16-b154f6e3f359':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_24_hr_low_FOLD_CHANGES>         \n",
       "a7908788-399f-4449-820d-f321ca387232 1        <PublishedDataset 'a7908788-399f-4449-820d-f321ca387232':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_24_hr_high_FOLD_CHANGES>     \n",
       "66f8d3e3-d470-49a4-af08-2625d3ec42aa 1        <PublishedDataset '66f8d3e3-d470-49a4-af08-2625d3ec42aa':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES>       \n",
       "e40ebbc7-844d-4b79-b5c0-10c36fd6eb77 1        <PublishedDataset 'e40ebbc7-844d-4b79-b5c0-10c36fd6eb77':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES>    \n",
       "912b41ce-bb1f-47fb-8b8f-e88cb8744315 1        <PublishedDataset '912b41ce-bb1f-47fb-8b8f-e88cb8744315':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_24_hr_low_FOLD_CHANGES>        \n",
       "530f243f-ded1-4fe1-a01e-37995296dde3 1        <PublishedDataset '530f243f-ded1-4fe1-a01e-37995296dde3':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_8_hr_low_FOLD_CHANGES>          \n",
       "0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151 1        <PublishedDataset '0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES>      \n",
       "acb77d9b-9d0e-425a-a67a-c78bb5c4663d 1        <PublishedDataset 'acb77d9b-9d0e-425a-a67a-c78bb5c4663d':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES>        \n",
       "4b6aa018-0cf8-47a5-8ce0-1a5551e9f634 1        <PublishedDataset '4b6aa018-0cf8-47a5-8ce0-1a5551e9f634':1 - TG-GATES-ORN_cs_aoplink_gemfibrozil_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES>      \n",
       "4a211f9d-2c43-43d6-9561-1c2ad6d17c77 1        <PublishedDataset '4a211f9d-2c43-43d6-9561-1c2ad6d17c77':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_2_hr_low_FOLD_CHANGES>          \n",
       "34617dcd-4c45-4f7f-90fd-f390abab60c9 1        <PublishedDataset '34617dcd-4c45-4f7f-90fd-f390abab60c9':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_2_hr_high_FOLD_CHANGES>         \n",
       "e2b62348-5421-4dfb-aa73-fb95d3998ce0 1        <PublishedDataset 'e2b62348-5421-4dfb-aa73-fb95d3998ce0':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_24_hr_middle_FOLD_CHANGES>     \n",
       "78c29410-8bb0-4d4b-85d2-27dde8a64739 1        <PublishedDataset '78c29410-8bb0-4d4b-85d2-27dde8a64739':1 - TG-GATES-ORN_cs_aoplink_gemfibrozil_Human_Liver_in vitro_8_hr_middle_FOLD_CHANGES>    \n",
       "198799ee-3228-4de2-b197-3c176ba4d8e6 1        <PublishedDataset '198799ee-3228-4de2-b197-3c176ba4d8e6':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_2_hr_middle_FOLD_CHANGES>       \n",
       "969ec4ba-0fd7-4782-8c31-04f0129fbd12 1        <PublishedDataset '969ec4ba-0fd7-4782-8c31-04f0129fbd12':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_24_hr_middle_FOLD_CHANGES>   \n",
       "2a3dd77a-5464-4dbe-9984-91c73044aa5b 1        <PublishedDataset '2a3dd77a-5464-4dbe-9984-91c73044aa5b':1 - TG-GATES-ORN_cs_aoplink_fenofibrate_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES>      \n",
       "5b93fdca-eab6-4ae7-a071-763d1af367f4 1        <PublishedDataset '5b93fdca-eab6-4ae7-a071-763d1af367f4':1 - TG-GATES-ORN_cs_aoplink_gemfibrozil_Human_Liver_in vitro_8_hr_low_FOLD_CHANGES>       \n",
       "49e8e9bd-bb29-4715-ad35-fef351f8bbe9 1        <PublishedDataset '49e8e9bd-bb29-4715-ad35-fef351f8bbe9':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_8_hr_low_FOLD_CHANGES>         \n",
       "dde3e916-ae10-4cab-9511-287bf62bb861 1        <PublishedDataset 'dde3e916-ae10-4cab-9511-287bf62bb861':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_24_hr_high_FOLD_CHANGES>       \n",
       "881e6c03-9e14-4265-9dd3-afc94ef05e2d 1        <PublishedDataset '881e6c03-9e14-4265-9dd3-afc94ef05e2d':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_2_hr_low_FOLD_CHANGES>         \n",
       "56efddc9-6b42-4402-a1ec-1e8a50665825 1        <PublishedDataset '56efddc9-6b42-4402-a1ec-1e8a50665825':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_2_hr_high_FOLD_CHANGES>        \n",
       "9901c889-3eb3-469e-bd12-46bfc401d86a 1        <PublishedDataset '9901c889-3eb3-469e-bd12-46bfc401d86a':1 - TG-GATES-ORN_cs_aoplink_lofibrate_Human_Liver_in vitro_2_hr_middle_FOLD_CHANGES>      \n",
       "a4af3ef9-aa3e-4aa4-8493-964860da9a8f 1        <PublishedDataset 'a4af3ef9-aa3e-4aa4-8493-964860da9a8f':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_24_hr_middle_FOLD_CHANGES>      \n",
       "294b845f-8434-496e-99bb-3682dbcf7255 1        <PublishedDataset '294b845f-8434-496e-99bb-3682dbcf7255':1 - TG-GATES-ORN_cs_aoplink_WY-14643_Human_Liver_in vitro_8_hr_high_FOLD_CHANGES>         \n",
       "\n",
       "                                                   Compound  \\\n",
       "id                                   version                  \n",
       "472755fe-211b-40a0-a05b-696a2a384aff 1        \"WY-14643\"      \n",
       "ece66bab-bee8-47f1-8f16-b154f6e3f359 1        \"WY-14643\"      \n",
       "a7908788-399f-4449-820d-f321ca387232 1        \"fenofibrate\"   \n",
       "66f8d3e3-d470-49a4-af08-2625d3ec42aa 1        \"WY-14643\"      \n",
       "e40ebbc7-844d-4b79-b5c0-10c36fd6eb77 1        \"fenofibrate\"   \n",
       "912b41ce-bb1f-47fb-8b8f-e88cb8744315 1        \"clofibrate\"    \n",
       "530f243f-ded1-4fe1-a01e-37995296dde3 1        \"WY-14643\"      \n",
       "0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151 1        \"clofibrate\"    \n",
       "acb77d9b-9d0e-425a-a67a-c78bb5c4663d 1        \"clofibrate\"    \n",
       "4b6aa018-0cf8-47a5-8ce0-1a5551e9f634 1        \"gemfibrozil\"   \n",
       "4a211f9d-2c43-43d6-9561-1c2ad6d17c77 1        \"WY-14643\"      \n",
       "34617dcd-4c45-4f7f-90fd-f390abab60c9 1        \"WY-14643\"      \n",
       "e2b62348-5421-4dfb-aa73-fb95d3998ce0 1        \"clofibrate\"    \n",
       "78c29410-8bb0-4d4b-85d2-27dde8a64739 1        \"gemfibrozil\"   \n",
       "198799ee-3228-4de2-b197-3c176ba4d8e6 1        \"WY-14643\"      \n",
       "969ec4ba-0fd7-4782-8c31-04f0129fbd12 1        \"fenofibrate\"   \n",
       "2a3dd77a-5464-4dbe-9984-91c73044aa5b 1        \"fenofibrate\"   \n",
       "5b93fdca-eab6-4ae7-a071-763d1af367f4 1        \"gemfibrozil\"   \n",
       "49e8e9bd-bb29-4715-ad35-fef351f8bbe9 1        \"clofibrate\"    \n",
       "dde3e916-ae10-4cab-9511-287bf62bb861 1        \"clofibrate\"    \n",
       "881e6c03-9e14-4265-9dd3-afc94ef05e2d 1        \"clofibrate\"    \n",
       "56efddc9-6b42-4402-a1ec-1e8a50665825 1        \"clofibrate\"    \n",
       "9901c889-3eb3-469e-bd12-46bfc401d86a 1        \"clofibrate\"    \n",
       "a4af3ef9-aa3e-4aa4-8493-964860da9a8f 1        \"WY-14643\"      \n",
       "294b845f-8434-496e-99bb-3682dbcf7255 1        \"WY-14643\"      \n",
       "\n",
       "                                                                                              SMILES  \\\n",
       "id                                   version                                                           \n",
       "472755fe-211b-40a0-a05b-696a2a384aff 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "ece66bab-bee8-47f1-8f16-b154f6e3f359 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "a7908788-399f-4449-820d-f321ca387232 1        \"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"   \n",
       "66f8d3e3-d470-49a4-af08-2625d3ec42aa 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "e40ebbc7-844d-4b79-b5c0-10c36fd6eb77 1        \"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"   \n",
       "912b41ce-bb1f-47fb-8b8f-e88cb8744315 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "530f243f-ded1-4fe1-a01e-37995296dde3 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "acb77d9b-9d0e-425a-a67a-c78bb5c4663d 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "4b6aa018-0cf8-47a5-8ce0-1a5551e9f634 1        \"CC1=CC(=C(C=C1)C)OCCCC(C)(C)C(=O)O\"                     \n",
       "4a211f9d-2c43-43d6-9561-1c2ad6d17c77 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "34617dcd-4c45-4f7f-90fd-f390abab60c9 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "e2b62348-5421-4dfb-aa73-fb95d3998ce0 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "78c29410-8bb0-4d4b-85d2-27dde8a64739 1        \"CC1=CC(=C(C=C1)C)OCCCC(C)(C)C(=O)O\"                     \n",
       "198799ee-3228-4de2-b197-3c176ba4d8e6 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "969ec4ba-0fd7-4782-8c31-04f0129fbd12 1        \"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"   \n",
       "2a3dd77a-5464-4dbe-9984-91c73044aa5b 1        \"CC(C)OC(=O)C(C)(C)OC1=CC=C(C=C1)C(=O)C2=CC=C(C=C2)Cl\"   \n",
       "5b93fdca-eab6-4ae7-a071-763d1af367f4 1        \"CC1=CC(=C(C=C1)C)OCCCC(C)(C)C(=O)O\"                     \n",
       "49e8e9bd-bb29-4715-ad35-fef351f8bbe9 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "dde3e916-ae10-4cab-9511-287bf62bb861 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "881e6c03-9e14-4265-9dd3-afc94ef05e2d 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "56efddc9-6b42-4402-a1ec-1e8a50665825 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "9901c889-3eb3-469e-bd12-46bfc401d86a 1        \"CCOC(=O)C(C)(C)OC1=CC=C(C=C1)Cl\"                        \n",
       "a4af3ef9-aa3e-4aa4-8493-964860da9a8f 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "294b845f-8434-496e-99bb-3682dbcf7255 1        \"CC1=C(C(=CC=C1)NC2=CC(=NC(=N2)SCC(=O)O)Cl)C\"            \n",
       "\n",
       "                                             Organism  Study type    Organ  \\\n",
       "id                                   version                                 \n",
       "472755fe-211b-40a0-a05b-696a2a384aff 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "ece66bab-bee8-47f1-8f16-b154f6e3f359 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "a7908788-399f-4449-820d-f321ca387232 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "66f8d3e3-d470-49a4-af08-2625d3ec42aa 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "e40ebbc7-844d-4b79-b5c0-10c36fd6eb77 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "912b41ce-bb1f-47fb-8b8f-e88cb8744315 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "530f243f-ded1-4fe1-a01e-37995296dde3 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "acb77d9b-9d0e-425a-a67a-c78bb5c4663d 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "4b6aa018-0cf8-47a5-8ce0-1a5551e9f634 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "4a211f9d-2c43-43d6-9561-1c2ad6d17c77 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "34617dcd-4c45-4f7f-90fd-f390abab60c9 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "e2b62348-5421-4dfb-aa73-fb95d3998ce0 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "78c29410-8bb0-4d4b-85d2-27dde8a64739 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "198799ee-3228-4de2-b197-3c176ba4d8e6 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "969ec4ba-0fd7-4782-8c31-04f0129fbd12 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "2a3dd77a-5464-4dbe-9984-91c73044aa5b 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "5b93fdca-eab6-4ae7-a071-763d1af367f4 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "49e8e9bd-bb29-4715-ad35-fef351f8bbe9 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "dde3e916-ae10-4cab-9511-287bf62bb861 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "881e6c03-9e14-4265-9dd3-afc94ef05e2d 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "56efddc9-6b42-4402-a1ec-1e8a50665825 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "9901c889-3eb3-469e-bd12-46bfc401d86a 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "a4af3ef9-aa3e-4aa4-8493-964860da9a8f 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "294b845f-8434-496e-99bb-3682dbcf7255 1        \"Human\"  \"in_vitro\"  \"Liver\"   \n",
       "\n",
       "                                                  Dose Duration  \n",
       "id                                   version                     \n",
       "472755fe-211b-40a0-a05b-696a2a384aff 1        \"high\"    24       \n",
       "ece66bab-bee8-47f1-8f16-b154f6e3f359 1        \"low\"     24       \n",
       "a7908788-399f-4449-820d-f321ca387232 1        \"high\"    24       \n",
       "66f8d3e3-d470-49a4-af08-2625d3ec42aa 1        \"middle\"  8        \n",
       "e40ebbc7-844d-4b79-b5c0-10c36fd6eb77 1        \"middle\"  8        \n",
       "912b41ce-bb1f-47fb-8b8f-e88cb8744315 1        \"low\"     24       \n",
       "530f243f-ded1-4fe1-a01e-37995296dde3 1        \"low\"     8        \n",
       "0d2ce56e-ee3f-47fa-bbbf-b0853b5d4151 1        \"middle\"  8        \n",
       "acb77d9b-9d0e-425a-a67a-c78bb5c4663d 1        \"high\"    8        \n",
       "4b6aa018-0cf8-47a5-8ce0-1a5551e9f634 1        \"high\"    8        \n",
       "4a211f9d-2c43-43d6-9561-1c2ad6d17c77 1        \"low\"     2        \n",
       "34617dcd-4c45-4f7f-90fd-f390abab60c9 1        \"high\"    2        \n",
       "e2b62348-5421-4dfb-aa73-fb95d3998ce0 1        \"middle\"  24       \n",
       "78c29410-8bb0-4d4b-85d2-27dde8a64739 1        \"middle\"  8        \n",
       "198799ee-3228-4de2-b197-3c176ba4d8e6 1        \"middle\"  2        \n",
       "969ec4ba-0fd7-4782-8c31-04f0129fbd12 1        \"middle\"  24       \n",
       "2a3dd77a-5464-4dbe-9984-91c73044aa5b 1        \"high\"    8        \n",
       "5b93fdca-eab6-4ae7-a071-763d1af367f4 1        \"low\"     8        \n",
       "49e8e9bd-bb29-4715-ad35-fef351f8bbe9 1        \"low\"     8        \n",
       "dde3e916-ae10-4cab-9511-287bf62bb861 1        \"high\"    24       \n",
       "881e6c03-9e14-4265-9dd3-afc94ef05e2d 1        \"low\"     2        \n",
       "56efddc9-6b42-4402-a1ec-1e8a50665825 1        \"high\"    2        \n",
       "9901c889-3eb3-469e-bd12-46bfc401d86a 1        \"middle\"  2        \n",
       "a4af3ef9-aa3e-4aa4-8493-964860da9a8f 1        \"middle\"  24       \n",
       "294b845f-8434-496e-99bb-3682dbcf7255 1        \"high\"    8        "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "TGGATES = TGGATES[(TGGATES['Organism']==\"\\\"Human\\\"\") & (TGGATES['Organ']==\"\\\"Liver\\\"\") & (TGGATES['Study type']==\"\\\"in_vitro\\\"\")]\n",
    "TGGATES"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Access first dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>PROBEID</th>\n",
       "      <th>SYMBOL</th>\n",
       "      <th>ENSEMBL</th>\n",
       "      <th>ENTREZID</th>\n",
       "      <th>logFC</th>\n",
       "      <th>AveExpr</th>\n",
       "      <th>t</th>\n",
       "      <th>P.Value</th>\n",
       "      <th>adj.P.Val</th>\n",
       "      <th>B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>205999_x_at</td>\n",
       "      <td>CYP3A4</td>\n",
       "      <td>ENSG00000160868</td>\n",
       "      <td>1576</td>\n",
       "      <td>1.722137</td>\n",
       "      <td>1.626904</td>\n",
       "      <td>50.461830</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1253.587116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>205939_at</td>\n",
       "      <td>CYP3A7</td>\n",
       "      <td>ENSG00000160870</td>\n",
       "      <td>1551</td>\n",
       "      <td>1.337397</td>\n",
       "      <td>1.301707</td>\n",
       "      <td>39.188226</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>753.293200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>211843_x_at</td>\n",
       "      <td>CYP3A7-CYP3A51P</td>\n",
       "      <td>ENSG00000282301</td>\n",
       "      <td>100861540</td>\n",
       "      <td>1.310793</td>\n",
       "      <td>1.581767</td>\n",
       "      <td>38.408686</td>\n",
       "      <td>1.686483e-318</td>\n",
       "      <td>3.073616e-314</td>\n",
       "      <td>723.350212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>208367_x_at</td>\n",
       "      <td>CYP3A4</td>\n",
       "      <td>ENSG00000160868</td>\n",
       "      <td>1576</td>\n",
       "      <td>1.299005</td>\n",
       "      <td>0.970862</td>\n",
       "      <td>38.063261</td>\n",
       "      <td>6.567899e-313</td>\n",
       "      <td>8.977497e-309</td>\n",
       "      <td>710.274423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>243015_at</td>\n",
       "      <td>CYP3A5</td>\n",
       "      <td>ENSG00000106258</td>\n",
       "      <td>1577</td>\n",
       "      <td>1.141211</td>\n",
       "      <td>1.132945</td>\n",
       "      <td>33.439605</td>\n",
       "      <td>1.036940e-242</td>\n",
       "      <td>1.133894e-238</td>\n",
       "      <td>546.622619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>218245_at</td>\n",
       "      <td>TSKU</td>\n",
       "      <td>ENSG00000182704</td>\n",
       "      <td>25987</td>\n",
       "      <td>1.131982</td>\n",
       "      <td>2.062511</td>\n",
       "      <td>33.169183</td>\n",
       "      <td>7.125216e-239</td>\n",
       "      <td>6.492853e-235</td>\n",
       "      <td>537.706288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>221433_at</td>\n",
       "      <td>FGF21</td>\n",
       "      <td>ENSG00000105550</td>\n",
       "      <td>26291</td>\n",
       "      <td>1.033026</td>\n",
       "      <td>0.880748</td>\n",
       "      <td>30.269606</td>\n",
       "      <td>1.293684e-199</td>\n",
       "      <td>8.841520e-196</td>\n",
       "      <td>446.651787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>217779_s_at</td>\n",
       "      <td>PNRC2</td>\n",
       "      <td>ENSG00000189266</td>\n",
       "      <td>55629</td>\n",
       "      <td>-0.974653</td>\n",
       "      <td>2.068771</td>\n",
       "      <td>-28.559154</td>\n",
       "      <td>4.427444e-178</td>\n",
       "      <td>2.689672e-174</td>\n",
       "      <td>396.842252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>209921_at</td>\n",
       "      <td>SLC7A11</td>\n",
       "      <td>ENSG00000151012</td>\n",
       "      <td>23657</td>\n",
       "      <td>0.910682</td>\n",
       "      <td>0.767476</td>\n",
       "      <td>26.684687</td>\n",
       "      <td>7.104468e-156</td>\n",
       "      <td>3.884368e-152</td>\n",
       "      <td>345.582858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>205998_x_at</td>\n",
       "      <td>CYP3A4</td>\n",
       "      <td>ENSG00000160868</td>\n",
       "      <td>1576</td>\n",
       "      <td>0.907741</td>\n",
       "      <td>0.885971</td>\n",
       "      <td>26.598513</td>\n",
       "      <td>6.873709e-155</td>\n",
       "      <td>3.416546e-151</td>\n",
       "      <td>343.309978</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>217558_at</td>\n",
       "      <td>CYP2C9</td>\n",
       "      <td>ENSG00000138109</td>\n",
       "      <td>1559</td>\n",
       "      <td>0.853227</td>\n",
       "      <td>1.291548</td>\n",
       "      <td>25.001152</td>\n",
       "      <td>3.517291e-137</td>\n",
       "      <td>1.479291e-133</td>\n",
       "      <td>302.509800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>201761_at</td>\n",
       "      <td>MTHFD2</td>\n",
       "      <td>ENSG00000065911</td>\n",
       "      <td>10797</td>\n",
       "      <td>0.838857</td>\n",
       "      <td>0.815887</td>\n",
       "      <td>24.580081</td>\n",
       "      <td>1.087696e-132</td>\n",
       "      <td>4.247842e-129</td>\n",
       "      <td>292.175434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>218145_at</td>\n",
       "      <td>TRIB3</td>\n",
       "      <td>ENSG00000101255</td>\n",
       "      <td>57761</td>\n",
       "      <td>0.835372</td>\n",
       "      <td>2.256575</td>\n",
       "      <td>24.477963</td>\n",
       "      <td>1.301052e-131</td>\n",
       "      <td>4.742335e-128</td>\n",
       "      <td>289.695587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>214234_s_at</td>\n",
       "      <td>CYP3A5</td>\n",
       "      <td>ENSG00000106258</td>\n",
       "      <td>1577</td>\n",
       "      <td>0.821790</td>\n",
       "      <td>2.438859</td>\n",
       "      <td>24.079989</td>\n",
       "      <td>1.874479e-127</td>\n",
       "      <td>6.405447e-124</td>\n",
       "      <td>280.129658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>225207_at</td>\n",
       "      <td>PDK4</td>\n",
       "      <td>ENSG00000004799</td>\n",
       "      <td>5166</td>\n",
       "      <td>0.818096</td>\n",
       "      <td>1.838105</td>\n",
       "      <td>23.971753</td>\n",
       "      <td>2.468215e-126</td>\n",
       "      <td>7.938214e-123</td>\n",
       "      <td>277.555148</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>208928_at</td>\n",
       "      <td>POR</td>\n",
       "      <td>ENSG00000127948</td>\n",
       "      <td>5447</td>\n",
       "      <td>0.817565</td>\n",
       "      <td>1.958300</td>\n",
       "      <td>23.956190</td>\n",
       "      <td>3.572281e-126</td>\n",
       "      <td>1.085080e-122</td>\n",
       "      <td>277.185927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>208147_s_at</td>\n",
       "      <td>CYP2C8</td>\n",
       "      <td>ENSG00000138115</td>\n",
       "      <td>1558</td>\n",
       "      <td>0.815923</td>\n",
       "      <td>2.009372</td>\n",
       "      <td>23.908060</td>\n",
       "      <td>1.119079e-125</td>\n",
       "      <td>3.220297e-122</td>\n",
       "      <td>276.045583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1555788_a_at</td>\n",
       "      <td>TRIB3</td>\n",
       "      <td>ENSG00000101255</td>\n",
       "      <td>57761</td>\n",
       "      <td>0.813396</td>\n",
       "      <td>1.294278</td>\n",
       "      <td>23.834027</td>\n",
       "      <td>6.453300e-125</td>\n",
       "      <td>1.764171e-121</td>\n",
       "      <td>274.295973</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>214235_at</td>\n",
       "      <td>CYP3A5</td>\n",
       "      <td>ENSG00000106258</td>\n",
       "      <td>1577</td>\n",
       "      <td>0.804696</td>\n",
       "      <td>2.241754</td>\n",
       "      <td>23.579110</td>\n",
       "      <td>2.583535e-122</td>\n",
       "      <td>6.726417e-119</td>\n",
       "      <td>268.313109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>207275_s_at</td>\n",
       "      <td>ACSL1</td>\n",
       "      <td>ENSG00000151726</td>\n",
       "      <td>2180</td>\n",
       "      <td>0.803593</td>\n",
       "      <td>2.446144</td>\n",
       "      <td>23.546768</td>\n",
       "      <td>5.500893e-122</td>\n",
       "      <td>1.367097e-118</td>\n",
       "      <td>267.558660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>209383_at</td>\n",
       "      <td>DDIT3</td>\n",
       "      <td>ENSG00000175197</td>\n",
       "      <td>1649</td>\n",
       "      <td>0.788840</td>\n",
       "      <td>1.603415</td>\n",
       "      <td>23.114480</td>\n",
       "      <td>1.217020e-117</td>\n",
       "      <td>2.893068e-114</td>\n",
       "      <td>257.573795</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>205892_s_at</td>\n",
       "      <td>FABP1</td>\n",
       "      <td>ENSG00000163586</td>\n",
       "      <td>2168</td>\n",
       "      <td>0.767510</td>\n",
       "      <td>3.383291</td>\n",
       "      <td>22.489486</td>\n",
       "      <td>1.690065e-111</td>\n",
       "      <td>3.850180e-108</td>\n",
       "      <td>243.464996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>217678_at</td>\n",
       "      <td>SLC7A11</td>\n",
       "      <td>ENSG00000151012</td>\n",
       "      <td>23657</td>\n",
       "      <td>0.765852</td>\n",
       "      <td>0.611487</td>\n",
       "      <td>22.440905</td>\n",
       "      <td>4.994346e-111</td>\n",
       "      <td>1.092264e-107</td>\n",
       "      <td>242.384506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>219270_at</td>\n",
       "      <td>CHAC1</td>\n",
       "      <td>ENSG00000128965</td>\n",
       "      <td>79094</td>\n",
       "      <td>0.721675</td>\n",
       "      <td>0.801750</td>\n",
       "      <td>21.146432</td>\n",
       "      <td>7.419273e-99</td>\n",
       "      <td>1.560187e-95</td>\n",
       "      <td>214.454876</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>201743_at</td>\n",
       "      <td>CD14</td>\n",
       "      <td>ENSG00000170458</td>\n",
       "      <td>929</td>\n",
       "      <td>0.657050</td>\n",
       "      <td>2.418389</td>\n",
       "      <td>19.252782</td>\n",
       "      <td>2.508876e-82</td>\n",
       "      <td>4.899029e-79</td>\n",
       "      <td>176.585814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>205960_at</td>\n",
       "      <td>PDK4</td>\n",
       "      <td>ENSG00000004799</td>\n",
       "      <td>5166</td>\n",
       "      <td>0.642288</td>\n",
       "      <td>0.732171</td>\n",
       "      <td>18.820231</td>\n",
       "      <td>9.157444e-79</td>\n",
       "      <td>1.726494e-75</td>\n",
       "      <td>168.433769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>226064_s_at</td>\n",
       "      <td>DGAT2</td>\n",
       "      <td>ENSG00000062282</td>\n",
       "      <td>84649</td>\n",
       "      <td>-0.633289</td>\n",
       "      <td>1.665128</td>\n",
       "      <td>-18.556558</td>\n",
       "      <td>1.242461e-76</td>\n",
       "      <td>2.264385e-73</td>\n",
       "      <td>163.555349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>217127_at</td>\n",
       "      <td>CTH</td>\n",
       "      <td>ENSG00000116761</td>\n",
       "      <td>1491</td>\n",
       "      <td>0.625781</td>\n",
       "      <td>1.716312</td>\n",
       "      <td>18.336558</td>\n",
       "      <td>7.095341e-75</td>\n",
       "      <td>1.251412e-71</td>\n",
       "      <td>159.537622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>218681_s_at</td>\n",
       "      <td>SDF2L1</td>\n",
       "      <td>ENSG00000128228</td>\n",
       "      <td>23753</td>\n",
       "      <td>0.624196</td>\n",
       "      <td>2.308508</td>\n",
       "      <td>18.290108</td>\n",
       "      <td>1.656683e-74</td>\n",
       "      <td>2.830598e-71</td>\n",
       "      <td>158.695472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>222406_s_at</td>\n",
       "      <td>PNRC2</td>\n",
       "      <td>ENSG00000189266</td>\n",
       "      <td>55629</td>\n",
       "      <td>-0.609894</td>\n",
       "      <td>0.725478</td>\n",
       "      <td>-17.871031</td>\n",
       "      <td>3.164766e-71</td>\n",
       "      <td>5.243442e-68</td>\n",
       "      <td>151.193971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>205633_s_at</td>\n",
       "      <td>ALAS1</td>\n",
       "      <td>ENSG00000023330</td>\n",
       "      <td>211</td>\n",
       "      <td>0.605581</td>\n",
       "      <td>2.319071</td>\n",
       "      <td>17.744662</td>\n",
       "      <td>2.985835e-70</td>\n",
       "      <td>4.801486e-67</td>\n",
       "      <td>148.966089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>201963_at</td>\n",
       "      <td>ACSL1</td>\n",
       "      <td>ENSG00000151726</td>\n",
       "      <td>2180</td>\n",
       "      <td>0.594467</td>\n",
       "      <td>2.931739</td>\n",
       "      <td>17.418995</td>\n",
       "      <td>9.030875e-68</td>\n",
       "      <td>1.410752e-64</td>\n",
       "      <td>143.297428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>206754_s_at</td>\n",
       "      <td>CYP2B6</td>\n",
       "      <td>ENSG00000197408</td>\n",
       "      <td>1555</td>\n",
       "      <td>0.592953</td>\n",
       "      <td>1.313100</td>\n",
       "      <td>17.374621</td>\n",
       "      <td>1.950917e-67</td>\n",
       "      <td>2.962955e-64</td>\n",
       "      <td>142.533171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>227558_at</td>\n",
       "      <td>CBX4</td>\n",
       "      <td>ENSG00000141582</td>\n",
       "      <td>8535</td>\n",
       "      <td>0.587940</td>\n",
       "      <td>1.797114</td>\n",
       "      <td>17.227746</td>\n",
       "      <td>2.463000e-66</td>\n",
       "      <td>3.639582e-63</td>\n",
       "      <td>140.017429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>202146_at</td>\n",
       "      <td>IFRD1</td>\n",
       "      <td>ENSG00000006652</td>\n",
       "      <td>3475</td>\n",
       "      <td>0.572021</td>\n",
       "      <td>1.555192</td>\n",
       "      <td>16.761294</td>\n",
       "      <td>6.727477e-63</td>\n",
       "      <td>9.679601e-60</td>\n",
       "      <td>132.169460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>207097_s_at</td>\n",
       "      <td>SLC17A2</td>\n",
       "      <td>ENSG00000112337</td>\n",
       "      <td>10246</td>\n",
       "      <td>0.559440</td>\n",
       "      <td>0.915895</td>\n",
       "      <td>16.392627</td>\n",
       "      <td>3.007846e-60</td>\n",
       "      <td>4.216769e-57</td>\n",
       "      <td>126.119106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>222853_at</td>\n",
       "      <td>FLRT3</td>\n",
       "      <td>ENSG00000125848</td>\n",
       "      <td>23767</td>\n",
       "      <td>-0.556428</td>\n",
       "      <td>2.276392</td>\n",
       "      <td>-16.304370</td>\n",
       "      <td>1.271025e-59</td>\n",
       "      <td>1.737332e-56</td>\n",
       "      <td>124.690642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>207256_at</td>\n",
       "      <td>MBL2</td>\n",
       "      <td>ENSG00000165471</td>\n",
       "      <td>4153</td>\n",
       "      <td>0.554523</td>\n",
       "      <td>1.010559</td>\n",
       "      <td>16.248557</td>\n",
       "      <td>3.149602e-59</td>\n",
       "      <td>4.200109e-56</td>\n",
       "      <td>123.791266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>212295_s_at</td>\n",
       "      <td>SLC7A1</td>\n",
       "      <td>ENSG00000139514</td>\n",
       "      <td>6541</td>\n",
       "      <td>0.535977</td>\n",
       "      <td>1.397692</td>\n",
       "      <td>15.705130</td>\n",
       "      <td>1.844900e-55</td>\n",
       "      <td>2.401665e-52</td>\n",
       "      <td>115.195706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>206085_s_at</td>\n",
       "      <td>CTH</td>\n",
       "      <td>ENSG00000116761</td>\n",
       "      <td>1491</td>\n",
       "      <td>0.534705</td>\n",
       "      <td>1.039133</td>\n",
       "      <td>15.667853</td>\n",
       "      <td>3.309789e-55</td>\n",
       "      <td>4.208435e-52</td>\n",
       "      <td>114.616812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>206755_at</td>\n",
       "      <td>CYP2B6</td>\n",
       "      <td>ENSG00000197408</td>\n",
       "      <td>1555</td>\n",
       "      <td>0.533582</td>\n",
       "      <td>0.863619</td>\n",
       "      <td>15.634940</td>\n",
       "      <td>5.538912e-55</td>\n",
       "      <td>6.882727e-52</td>\n",
       "      <td>114.106821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>223333_s_at</td>\n",
       "      <td>ANGPTL4</td>\n",
       "      <td>ENSG00000167772</td>\n",
       "      <td>51129</td>\n",
       "      <td>0.531303</td>\n",
       "      <td>2.277541</td>\n",
       "      <td>15.568183</td>\n",
       "      <td>1.568841e-54</td>\n",
       "      <td>1.906142e-51</td>\n",
       "      <td>113.075705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>205765_at</td>\n",
       "      <td>CYP3A5</td>\n",
       "      <td>ENSG00000106258</td>\n",
       "      <td>1577</td>\n",
       "      <td>0.526209</td>\n",
       "      <td>1.773519</td>\n",
       "      <td>15.418908</td>\n",
       "      <td>1.584016e-53</td>\n",
       "      <td>1.882740e-50</td>\n",
       "      <td>110.785991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>201272_at</td>\n",
       "      <td>AKR1B1</td>\n",
       "      <td>ENSG00000085662</td>\n",
       "      <td>231</td>\n",
       "      <td>0.524118</td>\n",
       "      <td>1.363903</td>\n",
       "      <td>15.357622</td>\n",
       "      <td>4.067006e-53</td>\n",
       "      <td>4.731140e-50</td>\n",
       "      <td>109.852329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>206753_at</td>\n",
       "      <td>RDH16</td>\n",
       "      <td>ENSG00000139547</td>\n",
       "      <td>8608</td>\n",
       "      <td>0.523411</td>\n",
       "      <td>0.760240</td>\n",
       "      <td>15.336930</td>\n",
       "      <td>5.587058e-53</td>\n",
       "      <td>6.364008e-50</td>\n",
       "      <td>109.537923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>206336_at</td>\n",
       "      <td>CXCL6</td>\n",
       "      <td>ENSG00000124875</td>\n",
       "      <td>6372</td>\n",
       "      <td>-0.522773</td>\n",
       "      <td>0.903365</td>\n",
       "      <td>-15.318234</td>\n",
       "      <td>7.440883e-53</td>\n",
       "      <td>8.302658e-50</td>\n",
       "      <td>109.254226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>201010_s_at</td>\n",
       "      <td>TXNIP</td>\n",
       "      <td>ENSG00000265972</td>\n",
       "      <td>10628</td>\n",
       "      <td>0.517813</td>\n",
       "      <td>0.861864</td>\n",
       "      <td>15.172881</td>\n",
       "      <td>6.823837e-52</td>\n",
       "      <td>7.461866e-49</td>\n",
       "      <td>107.060367</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>219250_s_at</td>\n",
       "      <td>FLRT3</td>\n",
       "      <td>ENSG00000125848</td>\n",
       "      <td>23767</td>\n",
       "      <td>-0.517522</td>\n",
       "      <td>1.826611</td>\n",
       "      <td>-15.164373</td>\n",
       "      <td>7.763993e-52</td>\n",
       "      <td>8.323458e-49</td>\n",
       "      <td>106.932594</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>209822_s_at</td>\n",
       "      <td>VLDLR</td>\n",
       "      <td>ENSG00000147852</td>\n",
       "      <td>7436</td>\n",
       "      <td>0.515651</td>\n",
       "      <td>1.041508</td>\n",
       "      <td>15.109544</td>\n",
       "      <td>1.780617e-51</td>\n",
       "      <td>1.872216e-48</td>\n",
       "      <td>106.110945</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>211048_s_at</td>\n",
       "      <td>PDIA4</td>\n",
       "      <td>ENSG00000155660</td>\n",
       "      <td>9601</td>\n",
       "      <td>0.513874</td>\n",
       "      <td>2.830582</td>\n",
       "      <td>15.057469</td>\n",
       "      <td>3.906275e-51</td>\n",
       "      <td>4.029728e-48</td>\n",
       "      <td>105.333317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>202557_at</td>\n",
       "      <td>HSPA13</td>\n",
       "      <td>ENSG00000155304</td>\n",
       "      <td>6782</td>\n",
       "      <td>0.509502</td>\n",
       "      <td>2.205265</td>\n",
       "      <td>14.929364</td>\n",
       "      <td>2.667943e-50</td>\n",
       "      <td>2.701292e-47</td>\n",
       "      <td>103.431756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>218358_at</td>\n",
       "      <td>CRELD2</td>\n",
       "      <td>ENSG00000184164</td>\n",
       "      <td>79174</td>\n",
       "      <td>0.496106</td>\n",
       "      <td>2.176387</td>\n",
       "      <td>14.536837</td>\n",
       "      <td>8.694666e-48</td>\n",
       "      <td>8.488944e-45</td>\n",
       "      <td>97.706353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>204551_s_at</td>\n",
       "      <td>AHSG</td>\n",
       "      <td>ENSG00000145192</td>\n",
       "      <td>197</td>\n",
       "      <td>-0.495970</td>\n",
       "      <td>3.011708</td>\n",
       "      <td>-14.532843</td>\n",
       "      <td>9.214706e-48</td>\n",
       "      <td>8.838843e-45</td>\n",
       "      <td>97.648889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>201009_s_at</td>\n",
       "      <td>TXNIP</td>\n",
       "      <td>ENSG00000265972</td>\n",
       "      <td>10628</td>\n",
       "      <td>0.488461</td>\n",
       "      <td>0.734876</td>\n",
       "      <td>14.312818</td>\n",
       "      <td>2.207888e-46</td>\n",
       "      <td>2.081315e-43</td>\n",
       "      <td>94.507195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>241994_at</td>\n",
       "      <td>XDH</td>\n",
       "      <td>ENSG00000158125</td>\n",
       "      <td>7498</td>\n",
       "      <td>0.485743</td>\n",
       "      <td>1.286965</td>\n",
       "      <td>14.233181</td>\n",
       "      <td>6.889385e-46</td>\n",
       "      <td>6.384358e-43</td>\n",
       "      <td>93.381885</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>202672_s_at</td>\n",
       "      <td>ATF3</td>\n",
       "      <td>ENSG00000162772</td>\n",
       "      <td>467</td>\n",
       "      <td>0.483492</td>\n",
       "      <td>1.187955</td>\n",
       "      <td>14.167213</td>\n",
       "      <td>1.759990e-45</td>\n",
       "      <td>1.603791e-42</td>\n",
       "      <td>92.454468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>224327_s_at</td>\n",
       "      <td>DGAT2</td>\n",
       "      <td>ENSG00000062282</td>\n",
       "      <td>84649</td>\n",
       "      <td>-0.482898</td>\n",
       "      <td>1.304863</td>\n",
       "      <td>-14.149805</td>\n",
       "      <td>2.252602e-45</td>\n",
       "      <td>2.019033e-42</td>\n",
       "      <td>92.210464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>206101_at</td>\n",
       "      <td>ECM2</td>\n",
       "      <td>ENSG00000106823</td>\n",
       "      <td>1842</td>\n",
       "      <td>0.475356</td>\n",
       "      <td>1.069007</td>\n",
       "      <td>13.928826</td>\n",
       "      <td>5.034307e-44</td>\n",
       "      <td>4.439528e-41</td>\n",
       "      <td>89.139049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>202375_at</td>\n",
       "      <td>SEC24D</td>\n",
       "      <td>ENSG00000150961</td>\n",
       "      <td>9871</td>\n",
       "      <td>0.475294</td>\n",
       "      <td>1.920587</td>\n",
       "      <td>13.927014</td>\n",
       "      <td>5.163202e-44</td>\n",
       "      <td>4.480922e-41</td>\n",
       "      <td>89.114059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>235737_at</td>\n",
       "      <td>TSLP</td>\n",
       "      <td>ENSG00000145777</td>\n",
       "      <td>85480</td>\n",
       "      <td>0.474369</td>\n",
       "      <td>1.387412</td>\n",
       "      <td>13.899890</td>\n",
       "      <td>7.534781e-44</td>\n",
       "      <td>6.436940e-41</td>\n",
       "      <td>88.740446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>208964_s_at</td>\n",
       "      <td>FADS1</td>\n",
       "      <td>ENSG00000149485</td>\n",
       "      <td>3992</td>\n",
       "      <td>0.472687</td>\n",
       "      <td>1.982545</td>\n",
       "      <td>13.850603</td>\n",
       "      <td>1.494700e-43</td>\n",
       "      <td>1.257272e-40</td>\n",
       "      <td>88.063398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>226650_at</td>\n",
       "      <td>ZFAND2A</td>\n",
       "      <td>ENSG00000178381</td>\n",
       "      <td>90637</td>\n",
       "      <td>0.470794</td>\n",
       "      <td>1.975874</td>\n",
       "      <td>13.795155</td>\n",
       "      <td>3.220883e-43</td>\n",
       "      <td>2.668209e-40</td>\n",
       "      <td>87.304607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>204607_at</td>\n",
       "      <td>HMGCS2</td>\n",
       "      <td>ENSG00000134240</td>\n",
       "      <td>3158</td>\n",
       "      <td>0.470336</td>\n",
       "      <td>1.948626</td>\n",
       "      <td>13.781716</td>\n",
       "      <td>3.877853e-43</td>\n",
       "      <td>3.164502e-40</td>\n",
       "      <td>87.121150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>205047_s_at</td>\n",
       "      <td>ASNS</td>\n",
       "      <td>ENSG00000070669</td>\n",
       "      <td>440</td>\n",
       "      <td>0.459461</td>\n",
       "      <td>1.982820</td>\n",
       "      <td>13.463068</td>\n",
       "      <td>3.001886e-41</td>\n",
       "      <td>2.413649e-38</td>\n",
       "      <td>82.823746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>201417_at</td>\n",
       "      <td>SOX4</td>\n",
       "      <td>ENSG00000124766</td>\n",
       "      <td>6659</td>\n",
       "      <td>-0.458958</td>\n",
       "      <td>2.306881</td>\n",
       "      <td>-13.448324</td>\n",
       "      <td>3.662189e-41</td>\n",
       "      <td>2.901886e-38</td>\n",
       "      <td>82.627332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>216598_s_at</td>\n",
       "      <td>CCL2</td>\n",
       "      <td>ENSG00000108691</td>\n",
       "      <td>6347</td>\n",
       "      <td>-0.455986</td>\n",
       "      <td>0.617400</td>\n",
       "      <td>-13.361230</td>\n",
       "      <td>1.180026e-40</td>\n",
       "      <td>9.216843e-38</td>\n",
       "      <td>81.471510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>230031_at</td>\n",
       "      <td>HSPA5</td>\n",
       "      <td>ENSG00000044574</td>\n",
       "      <td>3309</td>\n",
       "      <td>0.451886</td>\n",
       "      <td>1.497904</td>\n",
       "      <td>13.241114</td>\n",
       "      <td>5.853091e-40</td>\n",
       "      <td>4.507292e-37</td>\n",
       "      <td>79.889777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>202721_s_at</td>\n",
       "      <td>GFPT1</td>\n",
       "      <td>ENSG00000198380</td>\n",
       "      <td>2673</td>\n",
       "      <td>0.449454</td>\n",
       "      <td>2.063086</td>\n",
       "      <td>13.169835</td>\n",
       "      <td>1.503771e-39</td>\n",
       "      <td>1.141926e-36</td>\n",
       "      <td>78.957912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>214421_x_at</td>\n",
       "      <td>CYP2C9</td>\n",
       "      <td>ENSG00000138109</td>\n",
       "      <td>1559</td>\n",
       "      <td>0.448265</td>\n",
       "      <td>2.371183</td>\n",
       "      <td>13.135015</td>\n",
       "      <td>2.380015e-39</td>\n",
       "      <td>1.782566e-36</td>\n",
       "      <td>78.504519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>224997_x_at</td>\n",
       "      <td>H19</td>\n",
       "      <td>ENSG00000130600</td>\n",
       "      <td>283120</td>\n",
       "      <td>-0.442136</td>\n",
       "      <td>0.889828</td>\n",
       "      <td>-12.955406</td>\n",
       "      <td>2.493931e-38</td>\n",
       "      <td>1.842644e-35</td>\n",
       "      <td>76.184873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>206724_at</td>\n",
       "      <td>CBX4</td>\n",
       "      <td>ENSG00000141582</td>\n",
       "      <td>8535</td>\n",
       "      <td>0.438669</td>\n",
       "      <td>0.283572</td>\n",
       "      <td>12.853808</td>\n",
       "      <td>9.288028e-38</td>\n",
       "      <td>6.770972e-35</td>\n",
       "      <td>74.886874</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>221059_s_at</td>\n",
       "      <td>CHST6</td>\n",
       "      <td>ENSG00000183196</td>\n",
       "      <td>4166</td>\n",
       "      <td>0.437635</td>\n",
       "      <td>1.548835</td>\n",
       "      <td>12.823522</td>\n",
       "      <td>1.371803e-37</td>\n",
       "      <td>9.868858e-35</td>\n",
       "      <td>74.501927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>219910_at</td>\n",
       "      <td>FICD</td>\n",
       "      <td>ENSG00000198855</td>\n",
       "      <td>11153</td>\n",
       "      <td>0.437183</td>\n",
       "      <td>1.328963</td>\n",
       "      <td>12.810286</td>\n",
       "      <td>1.626245e-37</td>\n",
       "      <td>1.154740e-34</td>\n",
       "      <td>74.333982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>208963_x_at</td>\n",
       "      <td>FADS1</td>\n",
       "      <td>ENSG00000149485</td>\n",
       "      <td>3992</td>\n",
       "      <td>0.436358</td>\n",
       "      <td>1.710612</td>\n",
       "      <td>12.786091</td>\n",
       "      <td>2.218568e-37</td>\n",
       "      <td>1.555131e-34</td>\n",
       "      <td>74.027423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>208962_s_at</td>\n",
       "      <td>FADS1</td>\n",
       "      <td>ENSG00000149485</td>\n",
       "      <td>3992</td>\n",
       "      <td>0.428829</td>\n",
       "      <td>1.773027</td>\n",
       "      <td>12.565479</td>\n",
       "      <td>3.668040e-36</td>\n",
       "      <td>2.538608e-33</td>\n",
       "      <td>71.258913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>221024_s_at</td>\n",
       "      <td>SLC2A10</td>\n",
       "      <td>ENSG00000197496</td>\n",
       "      <td>81031</td>\n",
       "      <td>0.426321</td>\n",
       "      <td>1.507525</td>\n",
       "      <td>12.492015</td>\n",
       "      <td>9.236985e-36</td>\n",
       "      <td>6.312902e-33</td>\n",
       "      <td>70.347685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>221009_s_at</td>\n",
       "      <td>ANGPTL4</td>\n",
       "      <td>ENSG00000167772</td>\n",
       "      <td>51129</td>\n",
       "      <td>0.423698</td>\n",
       "      <td>2.517871</td>\n",
       "      <td>12.415130</td>\n",
       "      <td>2.414507e-35</td>\n",
       "      <td>1.629792e-32</td>\n",
       "      <td>69.399751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>201195_s_at</td>\n",
       "      <td>SLC7A5</td>\n",
       "      <td>ENSG00000103257</td>\n",
       "      <td>8140</td>\n",
       "      <td>0.421971</td>\n",
       "      <td>0.704108</td>\n",
       "      <td>12.364541</td>\n",
       "      <td>4.529168e-35</td>\n",
       "      <td>3.019906e-32</td>\n",
       "      <td>68.779231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>226769_at</td>\n",
       "      <td>FIBIN</td>\n",
       "      <td>ENSG00000176971</td>\n",
       "      <td>387758</td>\n",
       "      <td>0.421567</td>\n",
       "      <td>0.391645</td>\n",
       "      <td>12.352704</td>\n",
       "      <td>5.245460e-35</td>\n",
       "      <td>3.455368e-32</td>\n",
       "      <td>68.634403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>206155_at</td>\n",
       "      <td>ABCC2</td>\n",
       "      <td>ENSG00000023839</td>\n",
       "      <td>1244</td>\n",
       "      <td>0.421518</td>\n",
       "      <td>2.502201</td>\n",
       "      <td>12.351250</td>\n",
       "      <td>5.340888e-35</td>\n",
       "      <td>3.476346e-32</td>\n",
       "      <td>68.616619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>201631_s_at</td>\n",
       "      <td>IER3</td>\n",
       "      <td>ENSG00000137331</td>\n",
       "      <td>8870</td>\n",
       "      <td>-0.421452</td>\n",
       "      <td>2.989165</td>\n",
       "      <td>-12.349341</td>\n",
       "      <td>5.468791e-35</td>\n",
       "      <td>3.517719e-32</td>\n",
       "      <td>68.593276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>217564_s_at</td>\n",
       "      <td>CPS1</td>\n",
       "      <td>ENSG00000021826</td>\n",
       "      <td>1373</td>\n",
       "      <td>-0.418378</td>\n",
       "      <td>2.456898</td>\n",
       "      <td>-12.259263</td>\n",
       "      <td>1.663564e-34</td>\n",
       "      <td>1.057620e-31</td>\n",
       "      <td>67.495999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>225090_at</td>\n",
       "      <td>SYVN1</td>\n",
       "      <td>ENSG00000162298</td>\n",
       "      <td>84447</td>\n",
       "      <td>0.418124</td>\n",
       "      <td>1.668925</td>\n",
       "      <td>12.251811</td>\n",
       "      <td>1.823288e-34</td>\n",
       "      <td>1.145842e-31</td>\n",
       "      <td>67.405580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>204341_at</td>\n",
       "      <td>TRIM16</td>\n",
       "      <td>ENSG00000221926</td>\n",
       "      <td>10626</td>\n",
       "      <td>0.417468</td>\n",
       "      <td>1.213158</td>\n",
       "      <td>12.232583</td>\n",
       "      <td>2.309288e-34</td>\n",
       "      <td>1.434777e-31</td>\n",
       "      <td>67.172535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>202887_s_at</td>\n",
       "      <td>DDIT4</td>\n",
       "      <td>ENSG00000168209</td>\n",
       "      <td>54541</td>\n",
       "      <td>0.416181</td>\n",
       "      <td>2.160797</td>\n",
       "      <td>12.194886</td>\n",
       "      <td>3.666150e-34</td>\n",
       "      <td>2.252211e-31</td>\n",
       "      <td>66.716715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>214658_at</td>\n",
       "      <td>TICAM2</td>\n",
       "      <td>ENSG00000243414</td>\n",
       "      <td>353376</td>\n",
       "      <td>0.413638</td>\n",
       "      <td>2.295476</td>\n",
       "      <td>12.120362</td>\n",
       "      <td>9.104537e-34</td>\n",
       "      <td>5.531006e-31</td>\n",
       "      <td>65.819721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>209122_at</td>\n",
       "      <td>PLIN2</td>\n",
       "      <td>ENSG00000147872</td>\n",
       "      <td>123</td>\n",
       "      <td>0.408294</td>\n",
       "      <td>3.534115</td>\n",
       "      <td>11.963763</td>\n",
       "      <td>6.048221e-33</td>\n",
       "      <td>3.633917e-30</td>\n",
       "      <td>63.952781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>201008_s_at</td>\n",
       "      <td>TXNIP</td>\n",
       "      <td>ENSG00000265972</td>\n",
       "      <td>10628</td>\n",
       "      <td>0.405485</td>\n",
       "      <td>0.692346</td>\n",
       "      <td>11.881455</td>\n",
       "      <td>1.620525e-32</td>\n",
       "      <td>9.630674e-30</td>\n",
       "      <td>62.981255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>203634_s_at</td>\n",
       "      <td>CPT1A</td>\n",
       "      <td>ENSG00000110090</td>\n",
       "      <td>1374</td>\n",
       "      <td>0.405050</td>\n",
       "      <td>0.490670</td>\n",
       "      <td>11.868720</td>\n",
       "      <td>1.886357e-32</td>\n",
       "      <td>1.108995e-29</td>\n",
       "      <td>62.831534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>224806_at</td>\n",
       "      <td>TRIM25</td>\n",
       "      <td>ENSG00000121060</td>\n",
       "      <td>7706</td>\n",
       "      <td>0.402909</td>\n",
       "      <td>2.219289</td>\n",
       "      <td>11.805993</td>\n",
       "      <td>3.976853e-32</td>\n",
       "      <td>2.313132e-29</td>\n",
       "      <td>62.096419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>202655_at</td>\n",
       "      <td>MANF</td>\n",
       "      <td>ENSG00000145050</td>\n",
       "      <td>7873</td>\n",
       "      <td>0.402683</td>\n",
       "      <td>3.020523</td>\n",
       "      <td>11.799369</td>\n",
       "      <td>4.301739e-32</td>\n",
       "      <td>2.475764e-29</td>\n",
       "      <td>62.019024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>212810_s_at</td>\n",
       "      <td>SLC1A4</td>\n",
       "      <td>ENSG00000115902</td>\n",
       "      <td>6509</td>\n",
       "      <td>0.402497</td>\n",
       "      <td>0.728038</td>\n",
       "      <td>11.793921</td>\n",
       "      <td>4.588649e-32</td>\n",
       "      <td>2.613379e-29</td>\n",
       "      <td>61.955391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>211441_x_at</td>\n",
       "      <td>CYP3A43</td>\n",
       "      <td>ENSG00000021461</td>\n",
       "      <td>64816</td>\n",
       "      <td>0.401898</td>\n",
       "      <td>0.447685</td>\n",
       "      <td>11.776367</td>\n",
       "      <td>5.648558e-32</td>\n",
       "      <td>3.183865e-29</td>\n",
       "      <td>61.750583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>224583_at</td>\n",
       "      <td>COTL1</td>\n",
       "      <td>ENSG00000103187</td>\n",
       "      <td>23406</td>\n",
       "      <td>0.401770</td>\n",
       "      <td>1.330200</td>\n",
       "      <td>11.772602</td>\n",
       "      <td>5.905812e-32</td>\n",
       "      <td>3.294901e-29</td>\n",
       "      <td>61.706691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>220148_at</td>\n",
       "      <td>ALDH8A1</td>\n",
       "      <td>ENSG00000118514</td>\n",
       "      <td>64577</td>\n",
       "      <td>-0.397400</td>\n",
       "      <td>2.312205</td>\n",
       "      <td>-11.644549</td>\n",
       "      <td>2.663590e-31</td>\n",
       "      <td>1.471028e-28</td>\n",
       "      <td>60.222344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>220468_at</td>\n",
       "      <td>ARL14</td>\n",
       "      <td>ENSG00000179674</td>\n",
       "      <td>80117</td>\n",
       "      <td>-0.395968</td>\n",
       "      <td>1.634585</td>\n",
       "      <td>-11.602592</td>\n",
       "      <td>4.347944e-31</td>\n",
       "      <td>2.377239e-28</td>\n",
       "      <td>59.739532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>226181_at</td>\n",
       "      <td>TUBE1</td>\n",
       "      <td>ENSG00000074935</td>\n",
       "      <td>51175</td>\n",
       "      <td>0.394992</td>\n",
       "      <td>1.336044</td>\n",
       "      <td>11.573989</td>\n",
       "      <td>6.066482e-31</td>\n",
       "      <td>3.284009e-28</td>\n",
       "      <td>59.411380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>214837_at</td>\n",
       "      <td>ALB</td>\n",
       "      <td>ENSG00000163631</td>\n",
       "      <td>213</td>\n",
       "      <td>-0.391464</td>\n",
       "      <td>1.109744</td>\n",
       "      <td>-11.470626</td>\n",
       "      <td>2.007937e-30</td>\n",
       "      <td>1.076313e-27</td>\n",
       "      <td>58.232292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>200629_at</td>\n",
       "      <td>WARS</td>\n",
       "      <td>ENSG00000140105</td>\n",
       "      <td>7453</td>\n",
       "      <td>0.391381</td>\n",
       "      <td>1.675372</td>\n",
       "      <td>11.468190</td>\n",
       "      <td>2.065133e-30</td>\n",
       "      <td>1.096225e-27</td>\n",
       "      <td>58.204626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>225424_at</td>\n",
       "      <td>GPAM</td>\n",
       "      <td>ENSG00000119927</td>\n",
       "      <td>57678</td>\n",
       "      <td>0.391321</td>\n",
       "      <td>1.856755</td>\n",
       "      <td>11.466425</td>\n",
       "      <td>2.107572e-30</td>\n",
       "      <td>1.107995e-27</td>\n",
       "      <td>58.184589</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          PROBEID           SYMBOL          ENSEMBL   ENTREZID     logFC  \\\n",
       "1    205999_x_at   CYP3A4           ENSG00000160868  1576       1.722137   \n",
       "2    205939_at     CYP3A7           ENSG00000160870  1551       1.337397   \n",
       "3    211843_x_at   CYP3A7-CYP3A51P  ENSG00000282301  100861540  1.310793   \n",
       "4    208367_x_at   CYP3A4           ENSG00000160868  1576       1.299005   \n",
       "5    243015_at     CYP3A5           ENSG00000106258  1577       1.141211   \n",
       "6    218245_at     TSKU             ENSG00000182704  25987      1.131982   \n",
       "7    221433_at     FGF21            ENSG00000105550  26291      1.033026   \n",
       "8    217779_s_at   PNRC2            ENSG00000189266  55629     -0.974653   \n",
       "9    209921_at     SLC7A11          ENSG00000151012  23657      0.910682   \n",
       "10   205998_x_at   CYP3A4           ENSG00000160868  1576       0.907741   \n",
       "11   217558_at     CYP2C9           ENSG00000138109  1559       0.853227   \n",
       "12   201761_at     MTHFD2           ENSG00000065911  10797      0.838857   \n",
       "13   218145_at     TRIB3            ENSG00000101255  57761      0.835372   \n",
       "14   214234_s_at   CYP3A5           ENSG00000106258  1577       0.821790   \n",
       "15   225207_at     PDK4             ENSG00000004799  5166       0.818096   \n",
       "16   208928_at     POR              ENSG00000127948  5447       0.817565   \n",
       "17   208147_s_at   CYP2C8           ENSG00000138115  1558       0.815923   \n",
       "18   1555788_a_at  TRIB3            ENSG00000101255  57761      0.813396   \n",
       "19   214235_at     CYP3A5           ENSG00000106258  1577       0.804696   \n",
       "20   207275_s_at   ACSL1            ENSG00000151726  2180       0.803593   \n",
       "21   209383_at     DDIT3            ENSG00000175197  1649       0.788840   \n",
       "22   205892_s_at   FABP1            ENSG00000163586  2168       0.767510   \n",
       "23   217678_at     SLC7A11          ENSG00000151012  23657      0.765852   \n",
       "24   219270_at     CHAC1            ENSG00000128965  79094      0.721675   \n",
       "25   201743_at     CD14             ENSG00000170458  929        0.657050   \n",
       "26   205960_at     PDK4             ENSG00000004799  5166       0.642288   \n",
       "27   226064_s_at   DGAT2            ENSG00000062282  84649     -0.633289   \n",
       "28   217127_at     CTH              ENSG00000116761  1491       0.625781   \n",
       "29   218681_s_at   SDF2L1           ENSG00000128228  23753      0.624196   \n",
       "30   222406_s_at   PNRC2            ENSG00000189266  55629     -0.609894   \n",
       "31   205633_s_at   ALAS1            ENSG00000023330  211        0.605581   \n",
       "32   201963_at     ACSL1            ENSG00000151726  2180       0.594467   \n",
       "33   206754_s_at   CYP2B6           ENSG00000197408  1555       0.592953   \n",
       "34   227558_at     CBX4             ENSG00000141582  8535       0.587940   \n",
       "35   202146_at     IFRD1            ENSG00000006652  3475       0.572021   \n",
       "36   207097_s_at   SLC17A2          ENSG00000112337  10246      0.559440   \n",
       "37   222853_at     FLRT3            ENSG00000125848  23767     -0.556428   \n",
       "38   207256_at     MBL2             ENSG00000165471  4153       0.554523   \n",
       "39   212295_s_at   SLC7A1           ENSG00000139514  6541       0.535977   \n",
       "40   206085_s_at   CTH              ENSG00000116761  1491       0.534705   \n",
       "41   206755_at     CYP2B6           ENSG00000197408  1555       0.533582   \n",
       "42   223333_s_at   ANGPTL4          ENSG00000167772  51129      0.531303   \n",
       "43   205765_at     CYP3A5           ENSG00000106258  1577       0.526209   \n",
       "44   201272_at     AKR1B1           ENSG00000085662  231        0.524118   \n",
       "45   206753_at     RDH16            ENSG00000139547  8608       0.523411   \n",
       "46   206336_at     CXCL6            ENSG00000124875  6372      -0.522773   \n",
       "47   201010_s_at   TXNIP            ENSG00000265972  10628      0.517813   \n",
       "48   219250_s_at   FLRT3            ENSG00000125848  23767     -0.517522   \n",
       "49   209822_s_at   VLDLR            ENSG00000147852  7436       0.515651   \n",
       "50   211048_s_at   PDIA4            ENSG00000155660  9601       0.513874   \n",
       "51   202557_at     HSPA13           ENSG00000155304  6782       0.509502   \n",
       "52   218358_at     CRELD2           ENSG00000184164  79174      0.496106   \n",
       "53   204551_s_at   AHSG             ENSG00000145192  197       -0.495970   \n",
       "54   201009_s_at   TXNIP            ENSG00000265972  10628      0.488461   \n",
       "55   241994_at     XDH              ENSG00000158125  7498       0.485743   \n",
       "56   202672_s_at   ATF3             ENSG00000162772  467        0.483492   \n",
       "57   224327_s_at   DGAT2            ENSG00000062282  84649     -0.482898   \n",
       "58   206101_at     ECM2             ENSG00000106823  1842       0.475356   \n",
       "59   202375_at     SEC24D           ENSG00000150961  9871       0.475294   \n",
       "60   235737_at     TSLP             ENSG00000145777  85480      0.474369   \n",
       "61   208964_s_at   FADS1            ENSG00000149485  3992       0.472687   \n",
       "62   226650_at     ZFAND2A          ENSG00000178381  90637      0.470794   \n",
       "63   204607_at     HMGCS2           ENSG00000134240  3158       0.470336   \n",
       "64   205047_s_at   ASNS             ENSG00000070669  440        0.459461   \n",
       "65   201417_at     SOX4             ENSG00000124766  6659      -0.458958   \n",
       "66   216598_s_at   CCL2             ENSG00000108691  6347      -0.455986   \n",
       "67   230031_at     HSPA5            ENSG00000044574  3309       0.451886   \n",
       "68   202721_s_at   GFPT1            ENSG00000198380  2673       0.449454   \n",
       "69   214421_x_at   CYP2C9           ENSG00000138109  1559       0.448265   \n",
       "70   224997_x_at   H19              ENSG00000130600  283120    -0.442136   \n",
       "71   206724_at     CBX4             ENSG00000141582  8535       0.438669   \n",
       "72   221059_s_at   CHST6            ENSG00000183196  4166       0.437635   \n",
       "73   219910_at     FICD             ENSG00000198855  11153      0.437183   \n",
       "74   208963_x_at   FADS1            ENSG00000149485  3992       0.436358   \n",
       "75   208962_s_at   FADS1            ENSG00000149485  3992       0.428829   \n",
       "76   221024_s_at   SLC2A10          ENSG00000197496  81031      0.426321   \n",
       "77   221009_s_at   ANGPTL4          ENSG00000167772  51129      0.423698   \n",
       "78   201195_s_at   SLC7A5           ENSG00000103257  8140       0.421971   \n",
       "79   226769_at     FIBIN            ENSG00000176971  387758     0.421567   \n",
       "80   206155_at     ABCC2            ENSG00000023839  1244       0.421518   \n",
       "81   201631_s_at   IER3             ENSG00000137331  8870      -0.421452   \n",
       "82   217564_s_at   CPS1             ENSG00000021826  1373      -0.418378   \n",
       "83   225090_at     SYVN1            ENSG00000162298  84447      0.418124   \n",
       "84   204341_at     TRIM16           ENSG00000221926  10626      0.417468   \n",
       "85   202887_s_at   DDIT4            ENSG00000168209  54541      0.416181   \n",
       "86   214658_at     TICAM2           ENSG00000243414  353376     0.413638   \n",
       "87   209122_at     PLIN2            ENSG00000147872  123        0.408294   \n",
       "88   201008_s_at   TXNIP            ENSG00000265972  10628      0.405485   \n",
       "89   203634_s_at   CPT1A            ENSG00000110090  1374       0.405050   \n",
       "90   224806_at     TRIM25           ENSG00000121060  7706       0.402909   \n",
       "91   202655_at     MANF             ENSG00000145050  7873       0.402683   \n",
       "92   212810_s_at   SLC1A4           ENSG00000115902  6509       0.402497   \n",
       "93   211441_x_at   CYP3A43          ENSG00000021461  64816      0.401898   \n",
       "94   224583_at     COTL1            ENSG00000103187  23406      0.401770   \n",
       "95   220148_at     ALDH8A1          ENSG00000118514  64577     -0.397400   \n",
       "96   220468_at     ARL14            ENSG00000179674  80117     -0.395968   \n",
       "97   226181_at     TUBE1            ENSG00000074935  51175      0.394992   \n",
       "98   214837_at     ALB              ENSG00000163631  213       -0.391464   \n",
       "99   200629_at     WARS             ENSG00000140105  7453       0.391381   \n",
       "100  225424_at     GPAM             ENSG00000119927  57678      0.391321   \n",
       "\n",
       "      AveExpr          t        P.Value      adj.P.Val            B  \n",
       "1    1.626904  50.461830  0.000000e+00   0.000000e+00   1253.587116  \n",
       "2    1.301707  39.188226  0.000000e+00   0.000000e+00   753.293200   \n",
       "3    1.581767  38.408686  1.686483e-318  3.073616e-314  723.350212   \n",
       "4    0.970862  38.063261  6.567899e-313  8.977497e-309  710.274423   \n",
       "5    1.132945  33.439605  1.036940e-242  1.133894e-238  546.622619   \n",
       "6    2.062511  33.169183  7.125216e-239  6.492853e-235  537.706288   \n",
       "7    0.880748  30.269606  1.293684e-199  8.841520e-196  446.651787   \n",
       "8    2.068771 -28.559154  4.427444e-178  2.689672e-174  396.842252   \n",
       "9    0.767476  26.684687  7.104468e-156  3.884368e-152  345.582858   \n",
       "10   0.885971  26.598513  6.873709e-155  3.416546e-151  343.309978   \n",
       "11   1.291548  25.001152  3.517291e-137  1.479291e-133  302.509800   \n",
       "12   0.815887  24.580081  1.087696e-132  4.247842e-129  292.175434   \n",
       "13   2.256575  24.477963  1.301052e-131  4.742335e-128  289.695587   \n",
       "14   2.438859  24.079989  1.874479e-127  6.405447e-124  280.129658   \n",
       "15   1.838105  23.971753  2.468215e-126  7.938214e-123  277.555148   \n",
       "16   1.958300  23.956190  3.572281e-126  1.085080e-122  277.185927   \n",
       "17   2.009372  23.908060  1.119079e-125  3.220297e-122  276.045583   \n",
       "18   1.294278  23.834027  6.453300e-125  1.764171e-121  274.295973   \n",
       "19   2.241754  23.579110  2.583535e-122  6.726417e-119  268.313109   \n",
       "20   2.446144  23.546768  5.500893e-122  1.367097e-118  267.558660   \n",
       "21   1.603415  23.114480  1.217020e-117  2.893068e-114  257.573795   \n",
       "22   3.383291  22.489486  1.690065e-111  3.850180e-108  243.464996   \n",
       "23   0.611487  22.440905  4.994346e-111  1.092264e-107  242.384506   \n",
       "24   0.801750  21.146432  7.419273e-99   1.560187e-95   214.454876   \n",
       "25   2.418389  19.252782  2.508876e-82   4.899029e-79   176.585814   \n",
       "26   0.732171  18.820231  9.157444e-79   1.726494e-75   168.433769   \n",
       "27   1.665128 -18.556558  1.242461e-76   2.264385e-73   163.555349   \n",
       "28   1.716312  18.336558  7.095341e-75   1.251412e-71   159.537622   \n",
       "29   2.308508  18.290108  1.656683e-74   2.830598e-71   158.695472   \n",
       "30   0.725478 -17.871031  3.164766e-71   5.243442e-68   151.193971   \n",
       "31   2.319071  17.744662  2.985835e-70   4.801486e-67   148.966089   \n",
       "32   2.931739  17.418995  9.030875e-68   1.410752e-64   143.297428   \n",
       "33   1.313100  17.374621  1.950917e-67   2.962955e-64   142.533171   \n",
       "34   1.797114  17.227746  2.463000e-66   3.639582e-63   140.017429   \n",
       "35   1.555192  16.761294  6.727477e-63   9.679601e-60   132.169460   \n",
       "36   0.915895  16.392627  3.007846e-60   4.216769e-57   126.119106   \n",
       "37   2.276392 -16.304370  1.271025e-59   1.737332e-56   124.690642   \n",
       "38   1.010559  16.248557  3.149602e-59   4.200109e-56   123.791266   \n",
       "39   1.397692  15.705130  1.844900e-55   2.401665e-52   115.195706   \n",
       "40   1.039133  15.667853  3.309789e-55   4.208435e-52   114.616812   \n",
       "41   0.863619  15.634940  5.538912e-55   6.882727e-52   114.106821   \n",
       "42   2.277541  15.568183  1.568841e-54   1.906142e-51   113.075705   \n",
       "43   1.773519  15.418908  1.584016e-53   1.882740e-50   110.785991   \n",
       "44   1.363903  15.357622  4.067006e-53   4.731140e-50   109.852329   \n",
       "45   0.760240  15.336930  5.587058e-53   6.364008e-50   109.537923   \n",
       "46   0.903365 -15.318234  7.440883e-53   8.302658e-50   109.254226   \n",
       "47   0.861864  15.172881  6.823837e-52   7.461866e-49   107.060367   \n",
       "48   1.826611 -15.164373  7.763993e-52   8.323458e-49   106.932594   \n",
       "49   1.041508  15.109544  1.780617e-51   1.872216e-48   106.110945   \n",
       "50   2.830582  15.057469  3.906275e-51   4.029728e-48   105.333317   \n",
       "51   2.205265  14.929364  2.667943e-50   2.701292e-47   103.431756   \n",
       "52   2.176387  14.536837  8.694666e-48   8.488944e-45   97.706353    \n",
       "53   3.011708 -14.532843  9.214706e-48   8.838843e-45   97.648889    \n",
       "54   0.734876  14.312818  2.207888e-46   2.081315e-43   94.507195    \n",
       "55   1.286965  14.233181  6.889385e-46   6.384358e-43   93.381885    \n",
       "56   1.187955  14.167213  1.759990e-45   1.603791e-42   92.454468    \n",
       "57   1.304863 -14.149805  2.252602e-45   2.019033e-42   92.210464    \n",
       "58   1.069007  13.928826  5.034307e-44   4.439528e-41   89.139049    \n",
       "59   1.920587  13.927014  5.163202e-44   4.480922e-41   89.114059    \n",
       "60   1.387412  13.899890  7.534781e-44   6.436940e-41   88.740446    \n",
       "61   1.982545  13.850603  1.494700e-43   1.257272e-40   88.063398    \n",
       "62   1.975874  13.795155  3.220883e-43   2.668209e-40   87.304607    \n",
       "63   1.948626  13.781716  3.877853e-43   3.164502e-40   87.121150    \n",
       "64   1.982820  13.463068  3.001886e-41   2.413649e-38   82.823746    \n",
       "65   2.306881 -13.448324  3.662189e-41   2.901886e-38   82.627332    \n",
       "66   0.617400 -13.361230  1.180026e-40   9.216843e-38   81.471510    \n",
       "67   1.497904  13.241114  5.853091e-40   4.507292e-37   79.889777    \n",
       "68   2.063086  13.169835  1.503771e-39   1.141926e-36   78.957912    \n",
       "69   2.371183  13.135015  2.380015e-39   1.782566e-36   78.504519    \n",
       "70   0.889828 -12.955406  2.493931e-38   1.842644e-35   76.184873    \n",
       "71   0.283572  12.853808  9.288028e-38   6.770972e-35   74.886874    \n",
       "72   1.548835  12.823522  1.371803e-37   9.868858e-35   74.501927    \n",
       "73   1.328963  12.810286  1.626245e-37   1.154740e-34   74.333982    \n",
       "74   1.710612  12.786091  2.218568e-37   1.555131e-34   74.027423    \n",
       "75   1.773027  12.565479  3.668040e-36   2.538608e-33   71.258913    \n",
       "76   1.507525  12.492015  9.236985e-36   6.312902e-33   70.347685    \n",
       "77   2.517871  12.415130  2.414507e-35   1.629792e-32   69.399751    \n",
       "78   0.704108  12.364541  4.529168e-35   3.019906e-32   68.779231    \n",
       "79   0.391645  12.352704  5.245460e-35   3.455368e-32   68.634403    \n",
       "80   2.502201  12.351250  5.340888e-35   3.476346e-32   68.616619    \n",
       "81   2.989165 -12.349341  5.468791e-35   3.517719e-32   68.593276    \n",
       "82   2.456898 -12.259263  1.663564e-34   1.057620e-31   67.495999    \n",
       "83   1.668925  12.251811  1.823288e-34   1.145842e-31   67.405580    \n",
       "84   1.213158  12.232583  2.309288e-34   1.434777e-31   67.172535    \n",
       "85   2.160797  12.194886  3.666150e-34   2.252211e-31   66.716715    \n",
       "86   2.295476  12.120362  9.104537e-34   5.531006e-31   65.819721    \n",
       "87   3.534115  11.963763  6.048221e-33   3.633917e-30   63.952781    \n",
       "88   0.692346  11.881455  1.620525e-32   9.630674e-30   62.981255    \n",
       "89   0.490670  11.868720  1.886357e-32   1.108995e-29   62.831534    \n",
       "90   2.219289  11.805993  3.976853e-32   2.313132e-29   62.096419    \n",
       "91   3.020523  11.799369  4.301739e-32   2.475764e-29   62.019024    \n",
       "92   0.728038  11.793921  4.588649e-32   2.613379e-29   61.955391    \n",
       "93   0.447685  11.776367  5.648558e-32   3.183865e-29   61.750583    \n",
       "94   1.330200  11.772602  5.905812e-32   3.294901e-29   61.706691    \n",
       "95   2.312205 -11.644549  2.663590e-31   1.471028e-28   60.222344    \n",
       "96   1.634585 -11.602592  4.347944e-31   2.377239e-28   59.739532    \n",
       "97   1.336044  11.573989  6.066482e-31   3.284009e-28   59.411380    \n",
       "98   1.109744 -11.470626  2.007937e-30   1.076313e-27   58.232292    \n",
       "99   1.675372  11.468190  2.065133e-30   1.096225e-27   58.204626    \n",
       "100  1.856755  11.466425  2.107572e-30   1.107995e-27   58.184589    "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = TGGATES.iloc[0]['dataset'].get_data()\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}