dend_plus_tsv_hack.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from src.scripts.dendrogram_tools import dend_json_2_nodes_n_edges\n",
    "import json\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "ni = dend_json_2_nodes_n_edges('src/dendrograms/CCN202002013.json')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "dend_nodes = {n['cell_set_label'] for n in ni['nodes']}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "tab = pd.read_excel('src/dendrograms/cell_set_nomenclature.xlsx', sheet_name='cell set nomenclature')"
   ]
  },
  {
   "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>cell_set_preferred_alias</th>\n",
       "      <th>cell_set_label</th>\n",
       "      <th>cell_set_ accession</th>\n",
       "      <th>cell_set_ aligned_alias</th>\n",
       "      <th>cell_set_  additional_alias</th>\n",
       "      <th>cell_set_ alias_assignee</th>\n",
       "      <th>cell_set_ alias_citation</th>\n",
       "      <th>cell_set_ structure</th>\n",
       "      <th>cell_set_ ontology_tag</th>\n",
       "      <th>taxonomy_id</th>\n",
       "      <th>species</th>\n",
       "      <th>modality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Inh L1 LAMP5 PVRL2</td>\n",
       "      <td>RNAseq 001</td>\n",
       "      <td>CS201912131_1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Lamp5_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN201912131</td>\n",
       "      <td>Human</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Inh L1 LAMP5 RAB11FIP1</td>\n",
       "      <td>RNAseq 002</td>\n",
       "      <td>CS201912131_2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN201912131</td>\n",
       "      <td>Human</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Inh L1-6 LAMP5 AARD</td>\n",
       "      <td>RNAseq 003</td>\n",
       "      <td>CS201912131_3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN201912131</td>\n",
       "      <td>Human</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Inh L1-6 LAMP5 NES</td>\n",
       "      <td>RNAseq 004</td>\n",
       "      <td>CS201912131_4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN201912131</td>\n",
       "      <td>Human</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Inh L1-6 LAMP5 CA1</td>\n",
       "      <td>RNAseq 005</td>\n",
       "      <td>CS201912131_5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN201912131</td>\n",
       "      <td>Human</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1526</th>\n",
       "      <td>L4</td>\n",
       "      <td>ME 28-29</td>\n",
       "      <td>CS201906170_44</td>\n",
       "      <td>L4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nathan Gouwens</td>\n",
       "      <td>10.1038/s41593-019-0417-0</td>\n",
       "      <td>primary visual cortex</td>\n",
       "      <td>UBERON_0002436</td>\n",
       "      <td>CCN201906170</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>Morphology|Electrophysiology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1527</th>\n",
       "      <td>L6 IT</td>\n",
       "      <td>ME 33-34</td>\n",
       "      <td>CS201906170_45</td>\n",
       "      <td>L6 IT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nathan Gouwens</td>\n",
       "      <td>10.1038/s41593-019-0417-0</td>\n",
       "      <td>primary visual cortex</td>\n",
       "      <td>UBERON_0002436</td>\n",
       "      <td>CCN201906170</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>Morphology|Electrophysiology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1528</th>\n",
       "      <td>L6 CT</td>\n",
       "      <td>ME 35-36</td>\n",
       "      <td>CS201906170_46</td>\n",
       "      <td>L6 CT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Nathan Gouwens</td>\n",
       "      <td>10.1038/s41593-019-0417-0</td>\n",
       "      <td>primary visual cortex</td>\n",
       "      <td>UBERON_0002436</td>\n",
       "      <td>CCN201906170</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>Morphology|Electrophysiology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1529</th>\n",
       "      <td>Sst (Martinotti)</td>\n",
       "      <td>ME 15, 24-25</td>\n",
       "      <td>CS201906170_47</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Martinotti</td>\n",
       "      <td>Nathan Gouwens</td>\n",
       "      <td>10.1038/s41593-019-0417-0</td>\n",
       "      <td>primary visual cortex</td>\n",
       "      <td>UBERON_0002436</td>\n",
       "      <td>CCN201906170</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>Morphology|Electrophysiology</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1530</th>\n",
       "      <td>Sst (Non-Martinotti)</td>\n",
       "      <td>ME 22-23</td>\n",
       "      <td>CS201906170_48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Deep non-Martinotti</td>\n",
       "      <td>Nathan Gouwens</td>\n",
       "      <td>10.1038/s41593-019-0417-0</td>\n",
       "      <td>primary visual cortex</td>\n",
       "      <td>UBERON_0002436</td>\n",
       "      <td>CCN201906170</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>Morphology|Electrophysiology</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1531 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     cell_set_preferred_alias cell_set_label cell_set_ accession  \\\n",
       "0          Inh L1 LAMP5 PVRL2     RNAseq 001       CS201912131_1   \n",
       "1      Inh L1 LAMP5 RAB11FIP1     RNAseq 002       CS201912131_2   \n",
       "2         Inh L1-6 LAMP5 AARD     RNAseq 003       CS201912131_3   \n",
       "3          Inh L1-6 LAMP5 NES     RNAseq 004       CS201912131_4   \n",
       "4          Inh L1-6 LAMP5 CA1     RNAseq 005       CS201912131_5   \n",
       "...                       ...            ...                 ...   \n",
       "1526                       L4       ME 28-29      CS201906170_44   \n",
       "1527                    L6 IT       ME 33-34      CS201906170_45   \n",
       "1528                    L6 CT       ME 35-36      CS201906170_46   \n",
       "1529         Sst (Martinotti)   ME 15, 24-25      CS201906170_47   \n",
       "1530     Sst (Non-Martinotti)       ME 22-23      CS201906170_48   \n",
       "\n",
       "     cell_set_ aligned_alias cell_set_  additional_alias  \\\n",
       "0                        NaN                     Lamp5_1   \n",
       "1                        NaN                         NaN   \n",
       "2                        NaN                         NaN   \n",
       "3                        NaN                         NaN   \n",
       "4                        NaN                         NaN   \n",
       "...                      ...                         ...   \n",
       "1526                      L4                         NaN   \n",
       "1527                   L6 IT                         NaN   \n",
       "1528                   L6 CT                         NaN   \n",
       "1529                     NaN                 Martinotti    \n",
       "1530                     NaN        Deep non-Martinotti    \n",
       "\n",
       "     cell_set_ alias_assignee   cell_set_ alias_citation  \\\n",
       "0             Nikolas Jorstad  10.1101/2020.03.31.016972   \n",
       "1             Nikolas Jorstad  10.1101/2020.03.31.016972   \n",
       "2             Nikolas Jorstad  10.1101/2020.03.31.016972   \n",
       "3             Nikolas Jorstad  10.1101/2020.03.31.016972   \n",
       "4             Nikolas Jorstad  10.1101/2020.03.31.016972   \n",
       "...                       ...                        ...   \n",
       "1526           Nathan Gouwens  10.1038/s41593-019-0417-0   \n",
       "1527           Nathan Gouwens  10.1038/s41593-019-0417-0   \n",
       "1528           Nathan Gouwens  10.1038/s41593-019-0417-0   \n",
       "1529           Nathan Gouwens  10.1038/s41593-019-0417-0   \n",
       "1530           Nathan Gouwens  10.1038/s41593-019-0417-0   \n",
       "\n",
       "        cell_set_ structure cell_set_ ontology_tag   taxonomy_id species  \\\n",
       "0      primary motor cortex         UBERON:0001384  CCN201912131   Human   \n",
       "1      primary motor cortex         UBERON:0001384  CCN201912131   Human   \n",
       "2      primary motor cortex         UBERON:0001384  CCN201912131   Human   \n",
       "3      primary motor cortex         UBERON:0001384  CCN201912131   Human   \n",
       "4      primary motor cortex         UBERON:0001384  CCN201912131   Human   \n",
       "...                     ...                    ...           ...     ...   \n",
       "1526  primary visual cortex         UBERON_0002436  CCN201906170   Mouse   \n",
       "1527  primary visual cortex         UBERON_0002436  CCN201906170   Mouse   \n",
       "1528  primary visual cortex         UBERON_0002436  CCN201906170   Mouse   \n",
       "1529  primary visual cortex         UBERON_0002436  CCN201906170   Mouse   \n",
       "1530  primary visual cortex         UBERON_0002436  CCN201906170   Mouse   \n",
       "\n",
       "                          modality  \n",
       "0                           RNAseq  \n",
       "1                           RNAseq  \n",
       "2                           RNAseq  \n",
       "3                           RNAseq  \n",
       "4                           RNAseq  \n",
       "...                            ...  \n",
       "1526  Morphology|Electrophysiology  \n",
       "1527  Morphology|Electrophysiology  \n",
       "1528  Morphology|Electrophysiology  \n",
       "1529  Morphology|Electrophysiology  \n",
       "1530  Morphology|Electrophysiology  \n",
       "\n",
       "[1531 rows x 12 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tab"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandasql\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"('RNAseq 036-037','RNAseq 058-088','RNAseq 097','RNAseq 051','RNAseq 045','RNAseq 054','RNAseq 063-066','RNAseq 091','RNAseq 111-112','RNAseq 076','RNAseq 049-057','RNAseq 070-073','RNAseq 005-006','RNAseq 050-055','RNAseq 061-062','RNAseq 001-004','RNAseq 023','RNAseq 058-085','RNAseq 063-064','RNAseq 067-068','RNAseq 073','RNAseq 108','RNAseq 110','RNAseq 031-032','RNAseq 101-102','RNAseq 068','RNAseq 099-100','RNAseq 114-115','RNAseq 059','RNAseq 046-047','RNAseq 104','RNAseq 112','RNAseq 022','RNAseq 004','RNAseq 061-068','RNAseq 049','RNAseq 009','RNAseq 020','RNAseq 048','RNAseq 078','RNAseq 096','RNAseq 075','RNAseq 077-078','RNAseq 095','RNAseq 061-069','RNAseq 058-060','RNAseq 049-055','RNAseq 106','RNAseq 082-083','RNAseq 001','RNAseq 012','RNAseq 056-057','RNAseq 092','RNAseq 063','RNAseq 104-107','RNAseq 022-025','RNAseq 047','RNAseq 009-014','RNAseq 061-066','RNAseq 079','RNAseq 082-084','RNAseq 056','RNAseq 034-035','RNAseq 113','RNAseq 015-016','RNAseq 001-027, 089-090','RNAseq 011-014','RNAseq 058','RNAseq 074-080','RNAseq 101','RNAseq 114','RNAseq 009-010','RNAseq 082','RNAseq 115','RNAseq 011','RNAseq 051-055','RNAseq 070','RNAseq 103-116','RNAseq 071-072','RNAseq 104-110','RNAseq 046','RNAseq 018-020','RNAseq 058-073','RNAseq 099-102','RNAseq 001-057, 089-090','RNAseq 081','RNAseq 071-073','RNAseq 055','RNAseq 108-110','RNAseq 003','RNAseq 001-094','RNAseq 061','RNAseq 064','RNAseq 029','RNAseq 069','RNAseq 052-053','RNAseq 029-033','RNAseq 028','RNAseq 065-066','RNAseq 001-091','RNAseq 088','RNAseq 054-055','RNAseq 057','RNAseq 108-109','RNAseq 038-040','RNAseq 098','RNAseq 071','RNAseq 007','RNAseq 015-027','RNAseq 081-084','RNAseq 025','RNAseq 075-080','RNAseq 006','RNAseq 103','RNAseq 034','RNAseq 011-012','RNAseq 046-048','RNAseq 034-041','RNAseq 081-085','RNAseq 090','RNAseq 109','RNAseq 021','RNAseq 074','RNAseq 066','RNAseq 086','RNAseq 083','RNAseq 005','RNAseq 008','RNAseq 044-045','RNAseq 044','RNAseq 030','RNAseq 015','RNAseq 022-023','All cells','RNAseq 077','RNAseq 018','RNAseq 002','RNAseq 015-017','RNAseq 017','RNAseq 036','RNAseq 033','RNAseq 104-105','RNAseq 080','RNAseq 009-027','RNAseq 046-057','RNAseq 100','RNAseq 039-040','RNAseq 010','RNAseq 058-059','RNAseq 029-041','RNAseq 052','RNAseq 092-094','RNAseq 111','RNAseq 058-069','RNAseq 042-043','RNAseq 027','RNAseq 036-041','RNAseq 076-078','RNAseq 095-102','RNAseq 013','RNAseq 005-008','RNAseq 084','RNAseq 094','RNAseq 024','RNAseq 106-107','RNAseq 031-033','RNAseq 001-008','RNAseq 042','RNAseq 026','RNAseq 018-025','RNAseq 018-027','RNAseq 086-087','RNAseq 089','RNAseq 040','RNAseq 037','RNAseq 093','RNAseq 043','RNAseq 107','RNAseq 005-007','RNAseq 038','RNAseq 102','RNAseq 029-057','RNAseq 079-080','RNAseq 099','RNAseq 089-090','RNAseq 075-078','RNAseq 029-030','RNAseq 087','RNAseq 060','RNAseq 097-098','RNAseq 029-045','RNAseq 051-053','RNAseq 001-102','RNAseq 095-096','RNAseq 074-085','RNAseq 032','RNAseq 093-094','RNAseq 041','RNAseq 019','RNAseq 026-027','RNAseq 113-115','RNAseq 105','RNAseq 065','RNAseq 013-014','RNAseq 003-004','RNAseq 035','RNAseq 039','RNAseq 067','RNAseq 072','RNAseq 085','RNAseq 053','RNAseq 001-088','RNAseq 116','RNAseq 113-116','RNAseq 002-004','RNAseq 086-088','RNAseq 042-045','RNAseq 021-025','RNAseq 024-025','RNAseq 016','RNAseq 019-020','RNAseq 001-090','RNAseq 050','RNAseq 103-112','RNAseq 062','RNAseq 014','RNAseq 095-098','RNAseq 031','RNAseq 028-057','RNAseq 104-112','RNAseq 038-041')\""
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "inclause_string = \"('\" + \"','\".join(dend_nodes) + \"')\"\n",
    "inclause_string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>cell_set_preferred_alias</th>\n",
       "      <th>cell_set_label</th>\n",
       "      <th>cell_set_ accession</th>\n",
       "      <th>cell_set_ aligned_alias</th>\n",
       "      <th>cell_set_  additional_alias</th>\n",
       "      <th>cell_set_ alias_assignee</th>\n",
       "      <th>cell_set_ alias_citation</th>\n",
       "      <th>cell_set_ structure</th>\n",
       "      <th>cell_set_ ontology_tag</th>\n",
       "      <th>taxonomy_id</th>\n",
       "      <th>species</th>\n",
       "      <th>modality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Sst</td>\n",
       "      <td>RNAseq 028-047</td>\n",
       "      <td>CS202002013_232</td>\n",
       "      <td>Sst</td>\n",
       "      <td>None</td>\n",
       "      <td>Zizhen Yao</td>\n",
       "      <td>10.1101/2020.02.29.970558</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pvalb</td>\n",
       "      <td>RNAseq 048-057</td>\n",
       "      <td>CS202002013_233</td>\n",
       "      <td>Pvalb</td>\n",
       "      <td>None</td>\n",
       "      <td>Zizhen Yao</td>\n",
       "      <td>10.1101/2020.02.29.970558</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Non-IT projecting</td>\n",
       "      <td>RNAseq 070-088</td>\n",
       "      <td>CS202002013_234</td>\n",
       "      <td>Non-IT projecting</td>\n",
       "      <td>None</td>\n",
       "      <td>Zizhen Yao</td>\n",
       "      <td>10.1101/2020.02.29.970558</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Non-Neuronal</td>\n",
       "      <td>RNAseq 091-116</td>\n",
       "      <td>CS202002013_235</td>\n",
       "      <td>Non-Neuronal</td>\n",
       "      <td>None</td>\n",
       "      <td>Zizhen Yao</td>\n",
       "      <td>10.1101/2020.02.29.970558</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Oligo-OPC</td>\n",
       "      <td>RNAseq 091,095-102</td>\n",
       "      <td>CS202002013_236</td>\n",
       "      <td>Oligodendrocyte-OPC</td>\n",
       "      <td>None</td>\n",
       "      <td>Zizhen Yao</td>\n",
       "      <td>10.1101/2020.02.29.970558</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>None</td>\n",
       "      <td>RNAseq 114-116</td>\n",
       "      <td>CS202002013_237</td>\n",
       "      <td>PVM</td>\n",
       "      <td>None</td>\n",
       "      <td>Zizhen Yao</td>\n",
       "      <td>10.1101/2020.02.29.970558</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Lamp5_2</td>\n",
       "      <td>RNAseq 006-007</td>\n",
       "      <td>CS202002013_239</td>\n",
       "      <td>None</td>\n",
       "      <td>Lamp5_2</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Sncg_3</td>\n",
       "      <td>RNAseq 011-013</td>\n",
       "      <td>CS202002013_240</td>\n",
       "      <td>None</td>\n",
       "      <td>Sncg_3</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Sncg_1</td>\n",
       "      <td>RNAseq 014, 016</td>\n",
       "      <td>CS202002013_241</td>\n",
       "      <td>None</td>\n",
       "      <td>Sncg_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Vip_3</td>\n",
       "      <td>RNAseq 015, 019, 022</td>\n",
       "      <td>CS202002013_242</td>\n",
       "      <td>None</td>\n",
       "      <td>Vip_3</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Vip_2</td>\n",
       "      <td>RNAseq 017-018, 020-021</td>\n",
       "      <td>CS202002013_243</td>\n",
       "      <td>None</td>\n",
       "      <td>Vip_2</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Vip_1</td>\n",
       "      <td>RNAseq 023-025</td>\n",
       "      <td>CS202002013_244</td>\n",
       "      <td>None</td>\n",
       "      <td>Vip_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sst_2</td>\n",
       "      <td>RNAseq 029-030, 034</td>\n",
       "      <td>CS202002013_245</td>\n",
       "      <td>None</td>\n",
       "      <td>Sst_2</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Sst_3</td>\n",
       "      <td>RNAseq 035-036, 038-041</td>\n",
       "      <td>CS202002013_246</td>\n",
       "      <td>None</td>\n",
       "      <td>Sst_3</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sst_6</td>\n",
       "      <td>RNAseq 043-045</td>\n",
       "      <td>CS202002013_247</td>\n",
       "      <td>None</td>\n",
       "      <td>Sst_6</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Pvalb_1</td>\n",
       "      <td>RNAseq 046, 050-055</td>\n",
       "      <td>CS202002013_248</td>\n",
       "      <td>None</td>\n",
       "      <td>Pvalb_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Pvalb_2</td>\n",
       "      <td>RNAseq 048-049</td>\n",
       "      <td>CS202002013_249</td>\n",
       "      <td>None</td>\n",
       "      <td>Pvalb_2</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>L5 IT_1</td>\n",
       "      <td>RNAseq 061-062, 065</td>\n",
       "      <td>CS202002013_250</td>\n",
       "      <td>None</td>\n",
       "      <td>L5 IT_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>L6 IT_2</td>\n",
       "      <td>RNAseq 066, 068</td>\n",
       "      <td>CS202002013_251</td>\n",
       "      <td>None</td>\n",
       "      <td>L6 IT_2</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>L5 ET_1</td>\n",
       "      <td>RNAseq 070, 072-073</td>\n",
       "      <td>CS202002013_252</td>\n",
       "      <td>None</td>\n",
       "      <td>L5 ET_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>L6 CT_1</td>\n",
       "      <td>RNAseq 075, 077-081</td>\n",
       "      <td>CS202002013_253</td>\n",
       "      <td>None</td>\n",
       "      <td>L6 CT_1</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Oligo_2</td>\n",
       "      <td>RNAseq 098, 110-112</td>\n",
       "      <td>CS202002013_254</td>\n",
       "      <td>None</td>\n",
       "      <td>Oligo_2</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>VLMC(i)</td>\n",
       "      <td>RNAseq 104-107, 110</td>\n",
       "      <td>CS202002013_255</td>\n",
       "      <td>None</td>\n",
       "      <td>VLMC(i)</td>\n",
       "      <td>Nikolas Jorstad</td>\n",
       "      <td>10.1101/2020.03.31.016972</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Large CCK basket cell</td>\n",
       "      <td>RNAseq 009-012</td>\n",
       "      <td>CS202002013_256</td>\n",
       "      <td>None</td>\n",
       "      <td>Large CCK basket cell</td>\n",
       "      <td>Federico Scala</td>\n",
       "      <td>10.1101/2020.02.03.929158</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>L5 T Martinotti cell</td>\n",
       "      <td>RNAseq 030-032</td>\n",
       "      <td>CS202002013_258</td>\n",
       "      <td>None</td>\n",
       "      <td>L5 T Martinotti cell</td>\n",
       "      <td>Federico Scala</td>\n",
       "      <td>10.1101/2020.02.03.929158</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Lower FS Basket cell</td>\n",
       "      <td>NAseq 049-053</td>\n",
       "      <td>CS202002013_259</td>\n",
       "      <td>None</td>\n",
       "      <td>Lower FS Basket cell</td>\n",
       "      <td>Federico Scala</td>\n",
       "      <td>10.1101/2020.02.03.929158</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>MY-projecting L5 ET</td>\n",
       "      <td>RNAseq 070-071</td>\n",
       "      <td>CS202002013_260</td>\n",
       "      <td>None</td>\n",
       "      <td>MY-projecting L5 ET</td>\n",
       "      <td>Federico Scala</td>\n",
       "      <td>10.1101/2020.02.03.929158</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Non-MY-projecting L5 ET</td>\n",
       "      <td>RNAseq 072-073</td>\n",
       "      <td>CS202002013_261</td>\n",
       "      <td>None</td>\n",
       "      <td>Non-MY-projecting L5 ET</td>\n",
       "      <td>Federico Scala</td>\n",
       "      <td>10.1101/2020.02.03.929158</td>\n",
       "      <td>primary motor cortex</td>\n",
       "      <td>UBERON:0001384</td>\n",
       "      <td>CCN202002013</td>\n",
       "      <td>Mouse</td>\n",
       "      <td>RNAseq</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   cell_set_preferred_alias           cell_set_label cell_set_ accession  \\\n",
       "0                       Sst           RNAseq 028-047     CS202002013_232   \n",
       "1                     Pvalb           RNAseq 048-057     CS202002013_233   \n",
       "2         Non-IT projecting           RNAseq 070-088     CS202002013_234   \n",
       "3              Non-Neuronal           RNAseq 091-116     CS202002013_235   \n",
       "4                 Oligo-OPC       RNAseq 091,095-102     CS202002013_236   \n",
       "5                      None           RNAseq 114-116     CS202002013_237   \n",
       "6                   Lamp5_2           RNAseq 006-007     CS202002013_239   \n",
       "7                    Sncg_3           RNAseq 011-013     CS202002013_240   \n",
       "8                    Sncg_1          RNAseq 014, 016     CS202002013_241   \n",
       "9                     Vip_3     RNAseq 015, 019, 022     CS202002013_242   \n",
       "10                    Vip_2  RNAseq 017-018, 020-021     CS202002013_243   \n",
       "11                    Vip_1           RNAseq 023-025     CS202002013_244   \n",
       "12                    Sst_2      RNAseq 029-030, 034     CS202002013_245   \n",
       "13                    Sst_3  RNAseq 035-036, 038-041     CS202002013_246   \n",
       "14                    Sst_6           RNAseq 043-045     CS202002013_247   \n",
       "15                  Pvalb_1      RNAseq 046, 050-055     CS202002013_248   \n",
       "16                  Pvalb_2           RNAseq 048-049     CS202002013_249   \n",
       "17                  L5 IT_1      RNAseq 061-062, 065     CS202002013_250   \n",
       "18                  L6 IT_2          RNAseq 066, 068     CS202002013_251   \n",
       "19                  L5 ET_1      RNAseq 070, 072-073     CS202002013_252   \n",
       "20                  L6 CT_1      RNAseq 075, 077-081     CS202002013_253   \n",
       "21                  Oligo_2      RNAseq 098, 110-112     CS202002013_254   \n",
       "22                  VLMC(i)      RNAseq 104-107, 110     CS202002013_255   \n",
       "23    Large CCK basket cell           RNAseq 009-012     CS202002013_256   \n",
       "24     L5 T Martinotti cell           RNAseq 030-032     CS202002013_258   \n",
       "25     Lower FS Basket cell            NAseq 049-053     CS202002013_259   \n",
       "26      MY-projecting L5 ET           RNAseq 070-071     CS202002013_260   \n",
       "27  Non-MY-projecting L5 ET           RNAseq 072-073     CS202002013_261   \n",
       "\n",
       "   cell_set_ aligned_alias cell_set_  additional_alias  \\\n",
       "0                      Sst                        None   \n",
       "1                    Pvalb                        None   \n",
       "2        Non-IT projecting                        None   \n",
       "3             Non-Neuronal                        None   \n",
       "4      Oligodendrocyte-OPC                        None   \n",
       "5                      PVM                        None   \n",
       "6                     None                     Lamp5_2   \n",
       "7                     None                      Sncg_3   \n",
       "8                     None                      Sncg_1   \n",
       "9                     None                       Vip_3   \n",
       "10                    None                       Vip_2   \n",
       "11                    None                       Vip_1   \n",
       "12                    None                       Sst_2   \n",
       "13                    None                       Sst_3   \n",
       "14                    None                       Sst_6   \n",
       "15                    None                     Pvalb_1   \n",
       "16                    None                     Pvalb_2   \n",
       "17                    None                     L5 IT_1   \n",
       "18                    None                     L6 IT_2   \n",
       "19                    None                     L5 ET_1   \n",
       "20                    None                     L6 CT_1   \n",
       "21                    None                     Oligo_2   \n",
       "22                    None                     VLMC(i)   \n",
       "23                    None       Large CCK basket cell   \n",
       "24                    None        L5 T Martinotti cell   \n",
       "25                    None        Lower FS Basket cell   \n",
       "26                    None         MY-projecting L5 ET   \n",
       "27                    None     Non-MY-projecting L5 ET   \n",
       "\n",
       "   cell_set_ alias_assignee   cell_set_ alias_citation   cell_set_ structure  \\\n",
       "0                Zizhen Yao  10.1101/2020.02.29.970558  primary motor cortex   \n",
       "1                Zizhen Yao  10.1101/2020.02.29.970558  primary motor cortex   \n",
       "2                Zizhen Yao  10.1101/2020.02.29.970558  primary motor cortex   \n",
       "3                Zizhen Yao  10.1101/2020.02.29.970558  primary motor cortex   \n",
       "4                Zizhen Yao  10.1101/2020.02.29.970558  primary motor cortex   \n",
       "5                Zizhen Yao  10.1101/2020.02.29.970558  primary motor cortex   \n",
       "6           Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "7           Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "8           Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "9           Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "10          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "11          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "12          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "13          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "14          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "15          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "16          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "17          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "18          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "19          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "20          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "21          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "22          Nikolas Jorstad  10.1101/2020.03.31.016972  primary motor cortex   \n",
       "23           Federico Scala  10.1101/2020.02.03.929158  primary motor cortex   \n",
       "24           Federico Scala  10.1101/2020.02.03.929158  primary motor cortex   \n",
       "25           Federico Scala  10.1101/2020.02.03.929158  primary motor cortex   \n",
       "26           Federico Scala  10.1101/2020.02.03.929158  primary motor cortex   \n",
       "27           Federico Scala  10.1101/2020.02.03.929158  primary motor cortex   \n",
       "\n",
       "   cell_set_ ontology_tag   taxonomy_id species modality  \n",
       "0          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "1          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "2          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "3          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "4          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "5          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "6          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "7          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "8          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "9          UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "10         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "11         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "12         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "13         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "14         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "15         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "16         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "17         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "18         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "19         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "20         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "21         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "22         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "23         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "24         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "25         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "26         UBERON:0001384  CCN202002013   Mouse   RNAseq  \n",
       "27         UBERON:0001384  CCN202002013   Mouse   RNAseq  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sub_data = pandasql.sqldf(\"SELECT * FROM tab \" \\\n",
    "                          \"WHERE tab.taxonomy_id = 'CCN202002013'\" \\\n",
    "                          \" and tab.cell_set_label not in %s;\" % inclause_string, globals())\n",
    "sub_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'NAseq 049-053',\n",
       " 'RNAseq 006-007',\n",
       " 'RNAseq 009-012',\n",
       " 'RNAseq 011-013',\n",
       " 'RNAseq 014, 016',\n",
       " 'RNAseq 015, 019, 022',\n",
       " 'RNAseq 017-018, 020-021',\n",
       " 'RNAseq 023-025',\n",
       " 'RNAseq 028-047',\n",
       " 'RNAseq 029-030, 034',\n",
       " 'RNAseq 030-032',\n",
       " 'RNAseq 035-036, 038-041',\n",
       " 'RNAseq 043-045',\n",
       " 'RNAseq 046, 050-055',\n",
       " 'RNAseq 048-049',\n",
       " 'RNAseq 048-057',\n",
       " 'RNAseq 061-062, 065',\n",
       " 'RNAseq 066, 068',\n",
       " 'RNAseq 070, 072-073',\n",
       " 'RNAseq 070-071',\n",
       " 'RNAseq 070-088',\n",
       " 'RNAseq 072-073',\n",
       " 'RNAseq 075, 077-081',\n",
       " 'RNAseq 091,095-102',\n",
       " 'RNAseq 091-116',\n",
       " 'RNAseq 098, 110-112',\n",
       " 'RNAseq 104-107, 110',\n",
       " 'RNAseq 114-116'}"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(sub_data['cell_set_label'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'NAseq 049-053',\n",
       " 'RNAseq 006-007',\n",
       " 'RNAseq 009-012',\n",
       " 'RNAseq 011-013',\n",
       " 'RNAseq 014, 016',\n",
       " 'RNAseq 015, 019, 022',\n",
       " 'RNAseq 017-018, 020-021',\n",
       " 'RNAseq 023-025',\n",
       " 'RNAseq 028-047',\n",
       " 'RNAseq 029-030, 034',\n",
       " 'RNAseq 030-032',\n",
       " 'RNAseq 035-036, 038-041',\n",
       " 'RNAseq 043-045',\n",
       " 'RNAseq 046, 050-055',\n",
       " 'RNAseq 048-049',\n",
       " 'RNAseq 048-057',\n",
       " 'RNAseq 061-062, 065',\n",
       " 'RNAseq 066, 068',\n",
       " 'RNAseq 070, 072-073',\n",
       " 'RNAseq 070-071',\n",
       " 'RNAseq 070-088',\n",
       " 'RNAseq 072-073',\n",
       " 'RNAseq 075, 077-081',\n",
       " 'RNAseq 091,095-102',\n",
       " 'RNAseq 091-116',\n",
       " 'RNAseq 098, 110-112',\n",
       " 'RNAseq 104-107, 110',\n",
       " 'RNAseq 114-116'}"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(sub_data['cell_set_label']) - dend_nodes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'CS202002013_9|CS202002013_10|CS202002013_11|CS202002013_12'"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'|'.join([n['cell_set_accession'] for n in  ni['nodes'] \n",
    " if n['cell_set_label'] in ['RNAseq 009','RNAseq 010','RNAseq 011', 'RNAseq 012']])"
   ]
  },
  {
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}