23_live_python_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data science in Python\n",
    "\n",
    "- Course GitHub repo: https://github.com/pycam/python-data-science\n",
    "- Python website: https://www.python.org/ \n",
    "\n",
    "## Session 2.3 live: Biological data with BioPython\n",
    "\n",
    "**REMIND** participants to use red/pink post-it if they are lost during the live coding session to get help for the other trainer. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas \n",
    "mouse = pandas.read_csv('data/GRCm38.gff3', sep = '\\t')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['seqid', 'source', 'type', 'start', 'end', 'score', 'strand', 'phase',\n",
      "       'attributes', 'gbid'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(mouse.columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>seqid</th>\n",
       "      <th>source</th>\n",
       "      <th>type</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>score</th>\n",
       "      <th>strand</th>\n",
       "      <th>phase</th>\n",
       "      <th>attributes</th>\n",
       "      <th>gbid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>24544129</td>\n",
       "      <td>24544373</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...</td>\n",
       "      <td>NM_177676.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>71655663</td>\n",
       "      <td>71655741</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...</td>\n",
       "      <td>XM_017312883.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>118329486</td>\n",
       "      <td>118329612</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id520282;Parent=rna46416;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_378454.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>5175722</td>\n",
       "      <td>5175928</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id673061;Parent=rna60010;Dbxref=GeneID:6400...</td>\n",
       "      <td>XM_017314047.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NC_000083.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>24585923</td>\n",
       "      <td>24586066</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1054336;Parent=rna94586;Dbxref=GeneID:187...</td>\n",
       "      <td>XM_017317334.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>61740946</td>\n",
       "      <td>61741001</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id756287;Parent=rna67525;Dbxref=GeneID:2126...</td>\n",
       "      <td>XM_006532761.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>149130153</td>\n",
       "      <td>149130219</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id309255;Parent=rna27107;Dbxref=GeneID:6992...</td>\n",
       "      <td>NM_027263.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>125218141</td>\n",
       "      <td>125218252</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id157624;Parent=rna12621;Dbxref=GeneID:2049...</td>\n",
       "      <td>NM_001079690.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NC_000086.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>134446962</td>\n",
       "      <td>134447027</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1188223;Parent=rna107372;Dbxref=GeneID:13...</td>\n",
       "      <td>NM_010078.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>57708192</td>\n",
       "      <td>57708290</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id686725;Parent=rna61293;Dbxref=GeneID:1876...</td>\n",
       "      <td>XM_006512605.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>60499325</td>\n",
       "      <td>60499560</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id754010;Parent=rna67374;Dbxref=GeneID:1791...</td>\n",
       "      <td>NM_182698.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>154426526</td>\n",
       "      <td>154426617</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id67658;Parent=rna4879;Dbxref=GeneID:12290,...</td>\n",
       "      <td>XM_017312594.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NC_000081.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>77153530</td>\n",
       "      <td>77153812</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id979416;Parent=rna87784;Dbxref=GeneID:9368...</td>\n",
       "      <td>NM_001286419.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NC_000069.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>80702458</td>\n",
       "      <td>80702656</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id206493;Parent=rna17568;Dbxref=GeneID:1480...</td>\n",
       "      <td>XR_001783656.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>52622299</td>\n",
       "      <td>52622981</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id341017;Parent=rna29660;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_376954.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NC_000075.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>49502134</td>\n",
       "      <td>49505563</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id621844;Parent=rna55895;Dbxref=GeneID:1796...</td>\n",
       "      <td>XM_006510062.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NC_000085.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>56842212</td>\n",
       "      <td>56842319</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1158048;Parent=rna104294;Dbxref=GeneID:83...</td>\n",
       "      <td>XM_006527477.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NC_000081.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>76380468</td>\n",
       "      <td>76380576</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id977457;Parent=rna87622;Dbxref=GeneID:2236...</td>\n",
       "      <td>XM_011245572.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>45309098</td>\n",
       "      <td>45309230</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id487259;Parent=rna43262;Dbxref=GeneID:6866...</td>\n",
       "      <td>XM_006541148.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>109903062</td>\n",
       "      <td>109903114</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id719264;Parent=rna63948;Dbxref=GeneID:2603...</td>\n",
       "      <td>XM_006513679.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>NC_000085.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>6372301</td>\n",
       "      <td>6372416</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1132895;Parent=rna101937;Dbxref=GeneID:22...</td>\n",
       "      <td>NM_011750.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>152440765</td>\n",
       "      <td>152440922</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id169605;Parent=rna13822;Dbxref=GeneID:2287...</td>\n",
       "      <td>NR_110367.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>84923731</td>\n",
       "      <td>84923939</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id576343;Parent=rna51558;Dbxref=GeneID:5652...</td>\n",
       "      <td>XM_006531216.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>67702980</td>\n",
       "      <td>67703044</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id344114;Parent=rna29991;Dbxref=GeneID:1198...</td>\n",
       "      <td>NM_001038999.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>123646083</td>\n",
       "      <td>123646305</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id375767;Parent=rna32649;Dbxref=GeneID:5643...</td>\n",
       "      <td>XM_017321017.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>NC_000083.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>12895512</td>\n",
       "      <td>12895597</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1047168;Parent=rna93919;Dbxref=GeneID:240...</td>\n",
       "      <td>XM_006523326.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>NC_000086.7</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>100612052</td>\n",
       "      <td>100612111</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1181798;Parent=rna106789;Dbxref=GeneID:17...</td>\n",
       "      <td>XM_006527871.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>94746902</td>\n",
       "      <td>94747025</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id581998;Parent=rna52023;Dbxref=GeneID:2029...</td>\n",
       "      <td>NM_009137.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>NC_000079.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>53485797</td>\n",
       "      <td>53485922</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id880287;Parent=rna78850;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_873411.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>111011285</td>\n",
       "      <td>111011462</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id590946;Parent=rna52837;Dbxref=GeneID:2347...</td>\n",
       "      <td>NM_001190800.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29952</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>127371496</td>\n",
       "      <td>127371878</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id598743;Parent=rna53748;Dbxref=GeneID:9374...</td>\n",
       "      <td>XM_006531527.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29953</th>\n",
       "      <td>NC_000075.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>21835510</td>\n",
       "      <td>21835814</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id608162;Parent=rna54531;Dbxref=GeneID:6242...</td>\n",
       "      <td>NM_001080940.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29956</th>\n",
       "      <td>NC_000075.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>42597854</td>\n",
       "      <td>42597961</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id615581;Parent=rna55355;Dbxref=GeneID:1106...</td>\n",
       "      <td>XM_017313103.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29958</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>34138269</td>\n",
       "      <td>34139431</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id743197;Parent=rna66190;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_872372.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29959</th>\n",
       "      <td>NC_000085.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>28928548</td>\n",
       "      <td>28928632</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1143176;Parent=rna102968;Dbxref=GeneID:38...</td>\n",
       "      <td>XM_011247272.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29960</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>34282423</td>\n",
       "      <td>34282592</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id9409;Parent=rna608;Dbxref=GeneID:13518,Ge...</td>\n",
       "      <td>XM_006495685.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29961</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>90600186</td>\n",
       "      <td>90600280</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id785667;Parent=rna69875;Dbxref=GeneID:2091...</td>\n",
       "      <td>XM_006532737.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29962</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>101863777</td>\n",
       "      <td>101863896</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id356684;Parent=rna31035;Dbxref=GeneID:7214...</td>\n",
       "      <td>XM_006535225.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29963</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>118545393</td>\n",
       "      <td>118545456</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id51774;Parent=rna3652;Dbxref=GeneID:76707,...</td>\n",
       "      <td>XM_017312817.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29964</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>46545612</td>\n",
       "      <td>46545728</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id256601;Parent=rna22403;Dbxref=GeneID:1076...</td>\n",
       "      <td>NM_178893.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29966</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>82970635</td>\n",
       "      <td>82970820</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id267868;Parent=rna23351;Dbxref=GeneID:3298...</td>\n",
       "      <td>XR_001784157.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29967</th>\n",
       "      <td>NC_000082.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>43072424</td>\n",
       "      <td>43072469</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1026109;Parent=rna92025;Dbxref=GeneID:564...</td>\n",
       "      <td>XM_017317089.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29970</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>16205397</td>\n",
       "      <td>16205498</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id464855;Parent=rna40782;Dbxref=GeneID:7172...</td>\n",
       "      <td>NM_027883.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29972</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>52075813</td>\n",
       "      <td>52075975</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id685647;Parent=rna61190;Dbxref=GeneID:1988...</td>\n",
       "      <td>XM_017313855.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29973</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>116154633</td>\n",
       "      <td>116154686</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id519731;Parent=rna46360;Dbxref=GeneID:2337...</td>\n",
       "      <td>NM_001305190.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29974</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>87737551</td>\n",
       "      <td>87737668</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id784412;Parent=rna69740;Dbxref=GeneID:2092...</td>\n",
       "      <td>XM_006532741.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29976</th>\n",
       "      <td>NC_000082.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>16316334</td>\n",
       "      <td>16316443</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1008620;Parent=rna90552;Dbxref=GeneID:740...</td>\n",
       "      <td>NM_001276341.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29978</th>\n",
       "      <td>NC_000080.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>65174055</td>\n",
       "      <td>65174175</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id936720;Parent=rna84314;Dbxref=GeneID:1052...</td>\n",
       "      <td>XR_874714.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29979</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>80305529</td>\n",
       "      <td>80305627</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id703447;Parent=rna62607;Dbxref=GeneID:2380...</td>\n",
       "      <td>NM_011789.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29980</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>125569555</td>\n",
       "      <td>125569651</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id158051;Parent=rna12635;Dbxref=GeneID:9910...</td>\n",
       "      <td>XM_011239870.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29982</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>90940564</td>\n",
       "      <td>90940575</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id712588;Parent=rna63423;Dbxref=GeneID:7753...</td>\n",
       "      <td>XM_006514301.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29983</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>76876332</td>\n",
       "      <td>76876422</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id348601;Parent=rna30290;Dbxref=GeneID:2313...</td>\n",
       "      <td>XR_389267.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29984</th>\n",
       "      <td>NC_000069.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>108911164</td>\n",
       "      <td>108911260</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id227419;Parent=rna19628;Dbxref=GeneID:6692...</td>\n",
       "      <td>XM_006501915.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29985</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>4787444</td>\n",
       "      <td>4787549</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id732892;Parent=rna65250;Dbxref=GeneID:1801...</td>\n",
       "      <td>XM_011243669.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29986</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>42934633</td>\n",
       "      <td>42934818</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id252873;Parent=rna22077;Dbxref=GeneID:2300...</td>\n",
       "      <td>XM_017320120.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29988</th>\n",
       "      <td>NC_000069.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>101439375</td>\n",
       "      <td>101439779</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id222996;Parent=rna19162;Dbxref=GeneID:7890...</td>\n",
       "      <td>XM_006502342.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29991</th>\n",
       "      <td>NC_000084.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>31841440</td>\n",
       "      <td>31841642</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1107440;Parent=rna99310;Dbxref=GeneID:743...</td>\n",
       "      <td>NM_001170967.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29995</th>\n",
       "      <td>NC_000082.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>52139491</td>\n",
       "      <td>52139628</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1029870;Parent=rna92382;Dbxref=GeneID:208...</td>\n",
       "      <td>XM_006521949.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29996</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>108690884</td>\n",
       "      <td>108691063</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id719123;Parent=rna63941;Dbxref=GeneID:2097...</td>\n",
       "      <td>XM_006513448.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29997</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>130945428</td>\n",
       "      <td>130945457</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id55237;Parent=rna3973;Dbxref=GeneID:329244...</td>\n",
       "      <td>XM_006529705.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15604 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             seqid      source  type      start        end score strand phase  \\\n",
       "2      NC_000071.6  BestRefSeq  exon   24544129   24544373     .      -     .   \n",
       "3      NC_000074.6      Gnomon  exon   71655663   71655741     .      -     .   \n",
       "7      NC_000073.6      Gnomon  exon  118329486  118329612     .      +     .   \n",
       "8      NC_000076.6      Gnomon  exon    5175722    5175928     .      -     .   \n",
       "9      NC_000083.6      Gnomon  exon   24585923   24586066     .      +     .   \n",
       "13     NC_000077.6      Gnomon  exon   61740946   61741001     .      -     .   \n",
       "14     NC_000070.6  BestRefSeq  exon  149130153  149130219     .      -     .   \n",
       "15     NC_000068.7  BestRefSeq  exon  125218141  125218252     .      +     .   \n",
       "16     NC_000086.7  BestRefSeq  exon  134446962  134447027     .      +     .   \n",
       "18     NC_000076.6      Gnomon  exon   57708192   57708290     .      +     .   \n",
       "19     NC_000077.6  BestRefSeq  exon   60499325   60499560     .      +     .   \n",
       "21     NC_000067.6      Gnomon  exon  154426526  154426617     .      -     .   \n",
       "23     NC_000081.6  BestRefSeq  exon   77153530   77153812     .      -     .   \n",
       "24     NC_000069.6      Gnomon  exon   80702458   80702656     .      -     .   \n",
       "25     NC_000071.6      Gnomon  exon   52622299   52622981     .      -     .   \n",
       "26     NC_000075.6      Gnomon  exon   49502134   49505563     .      -     .   \n",
       "28     NC_000085.6      Gnomon  exon   56842212   56842319     .      +     .   \n",
       "32     NC_000081.6      Gnomon  exon   76380468   76380576     .      +     .   \n",
       "34     NC_000073.6      Gnomon  exon   45309098   45309230     .      -     .   \n",
       "35     NC_000076.6      Gnomon  exon  109903062  109903114     .      -     .   \n",
       "38     NC_000085.6  BestRefSeq  exon    6372301    6372416     .      +     .   \n",
       "39     NC_000068.7  BestRefSeq  exon  152440765  152440922     .      +     .   \n",
       "41     NC_000074.6      Gnomon  exon   84923731   84923939     .      -     .   \n",
       "43     NC_000071.6  BestRefSeq  exon   67702980   67703044     .      -     .   \n",
       "45     NC_000071.6      Gnomon  exon  123646083  123646305     .      -     .   \n",
       "46     NC_000083.6      Gnomon  exon   12895512   12895597     .      -     .   \n",
       "48     NC_000086.7      Gnomon  exon  100612052  100612111     .      +     .   \n",
       "49     NC_000074.6  BestRefSeq  exon   94746902   94747025     .      +     .   \n",
       "52     NC_000079.6      Gnomon  exon   53485797   53485922     .      +     .   \n",
       "54     NC_000074.6  BestRefSeq  exon  111011285  111011462     .      -     .   \n",
       "...            ...         ...   ...        ...        ...   ...    ...   ...   \n",
       "29952  NC_000074.6      Gnomon  exon  127371496  127371878     .      +     .   \n",
       "29953  NC_000075.6  BestRefSeq  exon   21835510   21835814     .      +     .   \n",
       "29956  NC_000075.6      Gnomon  exon   42597854   42597961     .      -     .   \n",
       "29958  NC_000077.6      Gnomon  exon   34138269   34139431     .      +     .   \n",
       "29959  NC_000085.6      Gnomon  exon   28928548   28928632     .      -     .   \n",
       "29960  NC_000067.6      Gnomon  exon   34282423   34282592     .      +     .   \n",
       "29961  NC_000077.6      Gnomon  exon   90600186   90600280     .      -     .   \n",
       "29962  NC_000071.6      Gnomon  exon  101863777  101863896     .      -     .   \n",
       "29963  NC_000067.6      Gnomon  exon  118545393  118545456     .      +     .   \n",
       "29964  NC_000070.6  BestRefSeq  exon   46545612   46545728     .      -     .   \n",
       "29966  NC_000070.6      Gnomon  exon   82970635   82970820     .      -     .   \n",
       "29967  NC_000082.6      Gnomon  exon   43072424   43072469     .      +     .   \n",
       "29970  NC_000073.6  BestRefSeq  exon   16205397   16205498     .      -     .   \n",
       "29972  NC_000076.6      Gnomon  exon   52075813   52075975     .      -     .   \n",
       "29973  NC_000073.6  BestRefSeq  exon  116154633  116154686     .      -     .   \n",
       "29974  NC_000077.6      Gnomon  exon   87737551   87737668     .      +     .   \n",
       "29976  NC_000082.6  BestRefSeq  exon   16316334   16316443     .      -     .   \n",
       "29978  NC_000080.6      Gnomon  exon   65174055   65174175     .      +     .   \n",
       "29979  NC_000076.6  BestRefSeq  exon   80305529   80305627     .      +     .   \n",
       "29980  NC_000068.7      Gnomon  exon  125569555  125569651     .      -     .   \n",
       "29982  NC_000076.6      Gnomon  exon   90940564   90940575     .      +     .   \n",
       "29983  NC_000071.6      Gnomon  exon   76876332   76876422     .      -     .   \n",
       "29984  NC_000069.6      Gnomon  exon  108911164  108911260     .      -     .   \n",
       "29985  NC_000077.6      Gnomon  exon    4787444    4787549     .      -     .   \n",
       "29986  NC_000070.6      Gnomon  exon   42934633   42934818     .      +     .   \n",
       "29988  NC_000069.6      Gnomon  exon  101439375  101439779     .      +     .   \n",
       "29991  NC_000084.6  BestRefSeq  exon   31841440   31841642     .      +     .   \n",
       "29995  NC_000082.6      Gnomon  exon   52139491   52139628     .      +     .   \n",
       "29996  NC_000076.6      Gnomon  exon  108690884  108691063     .      -     .   \n",
       "29997  NC_000067.6      Gnomon  exon  130945428  130945457     .      -     .   \n",
       "\n",
       "                                              attributes            gbid  \n",
       "2      ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...     NM_177676.6  \n",
       "3      ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...  XM_017312883.1  \n",
       "7      ID=id520282;Parent=rna46416;Dbxref=GeneID:1026...     XR_378454.2  \n",
       "8      ID=id673061;Parent=rna60010;Dbxref=GeneID:6400...  XM_017314047.1  \n",
       "9      ID=id1054336;Parent=rna94586;Dbxref=GeneID:187...  XM_017317334.1  \n",
       "13     ID=id756287;Parent=rna67525;Dbxref=GeneID:2126...  XM_006532761.3  \n",
       "14     ID=id309255;Parent=rna27107;Dbxref=GeneID:6992...     NM_027263.2  \n",
       "15     ID=id157624;Parent=rna12621;Dbxref=GeneID:2049...  NM_001079690.1  \n",
       "16     ID=id1188223;Parent=rna107372;Dbxref=GeneID:13...     NM_010078.3  \n",
       "18     ID=id686725;Parent=rna61293;Dbxref=GeneID:1876...  XM_006512605.3  \n",
       "19     ID=id754010;Parent=rna67374;Dbxref=GeneID:1791...     NM_182698.2  \n",
       "21     ID=id67658;Parent=rna4879;Dbxref=GeneID:12290,...  XM_017312594.1  \n",
       "23     ID=id979416;Parent=rna87784;Dbxref=GeneID:9368...  NM_001286419.1  \n",
       "24     ID=id206493;Parent=rna17568;Dbxref=GeneID:1480...  XR_001783656.1  \n",
       "25     ID=id341017;Parent=rna29660;Dbxref=GeneID:1026...     XR_376954.1  \n",
       "26     ID=id621844;Parent=rna55895;Dbxref=GeneID:1796...  XM_006510062.1  \n",
       "28     ID=id1158048;Parent=rna104294;Dbxref=GeneID:83...  XM_006527477.3  \n",
       "32     ID=id977457;Parent=rna87622;Dbxref=GeneID:2236...  XM_011245572.1  \n",
       "34     ID=id487259;Parent=rna43262;Dbxref=GeneID:6866...  XM_006541148.3  \n",
       "35     ID=id719264;Parent=rna63948;Dbxref=GeneID:2603...  XM_006513679.2  \n",
       "38     ID=id1132895;Parent=rna101937;Dbxref=GeneID:22...     NM_011750.2  \n",
       "39     ID=id169605;Parent=rna13822;Dbxref=GeneID:2287...     NR_110367.1  \n",
       "41     ID=id576343;Parent=rna51558;Dbxref=GeneID:5652...  XM_006531216.3  \n",
       "43     ID=id344114;Parent=rna29991;Dbxref=GeneID:1198...  NM_001038999.2  \n",
       "45     ID=id375767;Parent=rna32649;Dbxref=GeneID:5643...  XM_017321017.1  \n",
       "46     ID=id1047168;Parent=rna93919;Dbxref=GeneID:240...  XM_006523326.2  \n",
       "48     ID=id1181798;Parent=rna106789;Dbxref=GeneID:17...  XM_006527871.2  \n",
       "49     ID=id581998;Parent=rna52023;Dbxref=GeneID:2029...     NM_009137.2  \n",
       "52     ID=id880287;Parent=rna78850;Dbxref=GeneID:1026...     XR_873411.1  \n",
       "54     ID=id590946;Parent=rna52837;Dbxref=GeneID:2347...  NM_001190800.1  \n",
       "...                                                  ...             ...  \n",
       "29952  ID=id598743;Parent=rna53748;Dbxref=GeneID:9374...  XM_006531527.2  \n",
       "29953  ID=id608162;Parent=rna54531;Dbxref=GeneID:6242...  NM_001080940.1  \n",
       "29956  ID=id615581;Parent=rna55355;Dbxref=GeneID:1106...  XM_017313103.1  \n",
       "29958  ID=id743197;Parent=rna66190;Dbxref=GeneID:1026...     XR_872372.1  \n",
       "29959  ID=id1143176;Parent=rna102968;Dbxref=GeneID:38...  XM_011247272.2  \n",
       "29960  ID=id9409;Parent=rna608;Dbxref=GeneID:13518,Ge...  XM_006495685.2  \n",
       "29961  ID=id785667;Parent=rna69875;Dbxref=GeneID:2091...  XM_006532737.3  \n",
       "29962  ID=id356684;Parent=rna31035;Dbxref=GeneID:7214...  XM_006535225.3  \n",
       "29963  ID=id51774;Parent=rna3652;Dbxref=GeneID:76707,...  XM_017312817.1  \n",
       "29964  ID=id256601;Parent=rna22403;Dbxref=GeneID:1076...     NM_178893.4  \n",
       "29966  ID=id267868;Parent=rna23351;Dbxref=GeneID:3298...  XR_001784157.1  \n",
       "29967  ID=id1026109;Parent=rna92025;Dbxref=GeneID:564...  XM_017317089.1  \n",
       "29970  ID=id464855;Parent=rna40782;Dbxref=GeneID:7172...     NM_027883.3  \n",
       "29972  ID=id685647;Parent=rna61190;Dbxref=GeneID:1988...  XM_017313855.1  \n",
       "29973  ID=id519731;Parent=rna46360;Dbxref=GeneID:2337...  NM_001305190.1  \n",
       "29974  ID=id784412;Parent=rna69740;Dbxref=GeneID:2092...  XM_006532741.2  \n",
       "29976  ID=id1008620;Parent=rna90552;Dbxref=GeneID:740...  NM_001276341.1  \n",
       "29978  ID=id936720;Parent=rna84314;Dbxref=GeneID:1052...     XR_874714.1  \n",
       "29979  ID=id703447;Parent=rna62607;Dbxref=GeneID:2380...     NM_011789.2  \n",
       "29980  ID=id158051;Parent=rna12635;Dbxref=GeneID:9910...  XM_011239870.1  \n",
       "29982  ID=id712588;Parent=rna63423;Dbxref=GeneID:7753...  XM_006514301.2  \n",
       "29983  ID=id348601;Parent=rna30290;Dbxref=GeneID:2313...     XR_389267.2  \n",
       "29984  ID=id227419;Parent=rna19628;Dbxref=GeneID:6692...  XM_006501915.1  \n",
       "29985  ID=id732892;Parent=rna65250;Dbxref=GeneID:1801...  XM_011243669.2  \n",
       "29986  ID=id252873;Parent=rna22077;Dbxref=GeneID:2300...  XM_017320120.1  \n",
       "29988  ID=id222996;Parent=rna19162;Dbxref=GeneID:7890...  XM_006502342.3  \n",
       "29991  ID=id1107440;Parent=rna99310;Dbxref=GeneID:743...  NM_001170967.1  \n",
       "29995  ID=id1029870;Parent=rna92382;Dbxref=GeneID:208...  XM_006521949.1  \n",
       "29996  ID=id719123;Parent=rna63941;Dbxref=GeneID:2097...  XM_006513448.1  \n",
       "29997  ID=id55237;Parent=rna3973;Dbxref=GeneID:329244...  XM_006529705.1  \n",
       "\n",
       "[15604 rows x 10 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mouse[mouse['type']=='exon']"
   ]
  },
  {
   "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>seqid</th>\n",
       "      <th>source</th>\n",
       "      <th>type</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>score</th>\n",
       "      <th>strand</th>\n",
       "      <th>phase</th>\n",
       "      <th>attributes</th>\n",
       "      <th>gbid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>CDS</td>\n",
       "      <td>49420174</td>\n",
       "      <td>49420340</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>1</td>\n",
       "      <td>ID=cds30916;Parent=rna43633;Dbxref=GeneID:7828...</td>\n",
       "      <td>XP_006541352.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>CDS</td>\n",
       "      <td>64607740</td>\n",
       "      <td>64608137</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>2</td>\n",
       "      <td>ID=cds1286;Parent=rna1815;Dbxref=GeneID:67099,...</td>\n",
       "      <td>XP_006496267.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>24544129</td>\n",
       "      <td>24544373</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...</td>\n",
       "      <td>NM_177676.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>71655663</td>\n",
       "      <td>71655741</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...</td>\n",
       "      <td>XM_017312883.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>CDS</td>\n",
       "      <td>135932249</td>\n",
       "      <td>135932302</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>1</td>\n",
       "      <td>ID=cds9263;Parent=rna13273;Dbxref=GeneID:18798...</td>\n",
       "      <td>XP_006499009.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         seqid      source  type      start        end score strand phase  \\\n",
       "0  NC_000073.6      Gnomon   CDS   49420174   49420340     .      +     1   \n",
       "1  NC_000067.6      Gnomon   CDS   64607740   64608137     .      -     2   \n",
       "2  NC_000071.6  BestRefSeq  exon   24544129   24544373     .      -     .   \n",
       "3  NC_000074.6      Gnomon  exon   71655663   71655741     .      -     .   \n",
       "4  NC_000068.7      Gnomon   CDS  135932249  135932302     .      +     1   \n",
       "\n",
       "                                          attributes            gbid  \n",
       "0  ID=cds30916;Parent=rna43633;Dbxref=GeneID:7828...  XP_006541352.1  \n",
       "1  ID=cds1286;Parent=rna1815;Dbxref=GeneID:67099,...  XP_006496267.1  \n",
       "2  ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...     NM_177676.6  \n",
       "3  ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...  XM_017312883.1  \n",
       "4  ID=cds9263;Parent=rna13273;Dbxref=GeneID:18798...  XP_006499009.1  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mouse.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 29998 entries, 0 to 29997\n",
      "Data columns (total 10 columns):\n",
      "seqid         29998 non-null object\n",
      "source        29998 non-null object\n",
      "type          29998 non-null object\n",
      "start         29998 non-null int64\n",
      "end           29998 non-null int64\n",
      "score         29998 non-null object\n",
      "strand        29998 non-null object\n",
      "phase         29998 non-null object\n",
      "attributes    29998 non-null object\n",
      "gbid          28741 non-null object\n",
      "dtypes: int64(2), object(8)\n",
      "memory usage: 2.3+ MB\n"
     ]
    }
   ],
   "source": [
    "mouse.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "seqid            0\n",
       "source           0\n",
       "type             0\n",
       "start            0\n",
       "end              0\n",
       "score            0\n",
       "strand           0\n",
       "phase            0\n",
       "attributes       0\n",
       "gbid          1257\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mouse.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "mouse.dropna(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "seqid         0\n",
       "source        0\n",
       "type          0\n",
       "start         0\n",
       "end           0\n",
       "score         0\n",
       "strand        0\n",
       "phase         0\n",
       "attributes    0\n",
       "gbid          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mouse.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 28741 entries, 0 to 29997\n",
      "Data columns (total 10 columns):\n",
      "seqid         28741 non-null object\n",
      "source        28741 non-null object\n",
      "type          28741 non-null object\n",
      "start         28741 non-null int64\n",
      "end           28741 non-null int64\n",
      "score         28741 non-null object\n",
      "strand        28741 non-null object\n",
      "phase         28741 non-null object\n",
      "attributes    28741 non-null object\n",
      "gbid          28741 non-null object\n",
      "dtypes: int64(2), object(8)\n",
      "memory usage: 2.4+ MB\n"
     ]
    }
   ],
   "source": [
    "mouse.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "exon_mouse = mouse[mouse['type']=='exon']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>seqid</th>\n",
       "      <th>source</th>\n",
       "      <th>type</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>score</th>\n",
       "      <th>strand</th>\n",
       "      <th>phase</th>\n",
       "      <th>attributes</th>\n",
       "      <th>gbid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>24544129</td>\n",
       "      <td>24544373</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...</td>\n",
       "      <td>NM_177676.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>71655663</td>\n",
       "      <td>71655741</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...</td>\n",
       "      <td>XM_017312883.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>118329486</td>\n",
       "      <td>118329612</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id520282;Parent=rna46416;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_378454.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>5175722</td>\n",
       "      <td>5175928</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id673061;Parent=rna60010;Dbxref=GeneID:6400...</td>\n",
       "      <td>XM_017314047.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NC_000083.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>24585923</td>\n",
       "      <td>24586066</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1054336;Parent=rna94586;Dbxref=GeneID:187...</td>\n",
       "      <td>XM_017317334.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>61740946</td>\n",
       "      <td>61741001</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id756287;Parent=rna67525;Dbxref=GeneID:2126...</td>\n",
       "      <td>XM_006532761.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>149130153</td>\n",
       "      <td>149130219</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id309255;Parent=rna27107;Dbxref=GeneID:6992...</td>\n",
       "      <td>NM_027263.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>125218141</td>\n",
       "      <td>125218252</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id157624;Parent=rna12621;Dbxref=GeneID:2049...</td>\n",
       "      <td>NM_001079690.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>NC_000086.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>134446962</td>\n",
       "      <td>134447027</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1188223;Parent=rna107372;Dbxref=GeneID:13...</td>\n",
       "      <td>NM_010078.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>57708192</td>\n",
       "      <td>57708290</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id686725;Parent=rna61293;Dbxref=GeneID:1876...</td>\n",
       "      <td>XM_006512605.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>60499325</td>\n",
       "      <td>60499560</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id754010;Parent=rna67374;Dbxref=GeneID:1791...</td>\n",
       "      <td>NM_182698.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>154426526</td>\n",
       "      <td>154426617</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id67658;Parent=rna4879;Dbxref=GeneID:12290,...</td>\n",
       "      <td>XM_017312594.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>NC_000081.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>77153530</td>\n",
       "      <td>77153812</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id979416;Parent=rna87784;Dbxref=GeneID:9368...</td>\n",
       "      <td>NM_001286419.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>NC_000069.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>80702458</td>\n",
       "      <td>80702656</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id206493;Parent=rna17568;Dbxref=GeneID:1480...</td>\n",
       "      <td>XR_001783656.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>52622299</td>\n",
       "      <td>52622981</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id341017;Parent=rna29660;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_376954.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NC_000075.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>49502134</td>\n",
       "      <td>49505563</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id621844;Parent=rna55895;Dbxref=GeneID:1796...</td>\n",
       "      <td>XM_006510062.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NC_000085.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>56842212</td>\n",
       "      <td>56842319</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1158048;Parent=rna104294;Dbxref=GeneID:83...</td>\n",
       "      <td>XM_006527477.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>NC_000081.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>76380468</td>\n",
       "      <td>76380576</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id977457;Parent=rna87622;Dbxref=GeneID:2236...</td>\n",
       "      <td>XM_011245572.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>45309098</td>\n",
       "      <td>45309230</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id487259;Parent=rna43262;Dbxref=GeneID:6866...</td>\n",
       "      <td>XM_006541148.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>109903062</td>\n",
       "      <td>109903114</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id719264;Parent=rna63948;Dbxref=GeneID:2603...</td>\n",
       "      <td>XM_006513679.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>NC_000085.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>6372301</td>\n",
       "      <td>6372416</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1132895;Parent=rna101937;Dbxref=GeneID:22...</td>\n",
       "      <td>NM_011750.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>152440765</td>\n",
       "      <td>152440922</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id169605;Parent=rna13822;Dbxref=GeneID:2287...</td>\n",
       "      <td>NR_110367.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>84923731</td>\n",
       "      <td>84923939</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id576343;Parent=rna51558;Dbxref=GeneID:5652...</td>\n",
       "      <td>XM_006531216.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>67702980</td>\n",
       "      <td>67703044</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id344114;Parent=rna29991;Dbxref=GeneID:1198...</td>\n",
       "      <td>NM_001038999.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>123646083</td>\n",
       "      <td>123646305</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id375767;Parent=rna32649;Dbxref=GeneID:5643...</td>\n",
       "      <td>XM_017321017.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>NC_000083.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>12895512</td>\n",
       "      <td>12895597</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1047168;Parent=rna93919;Dbxref=GeneID:240...</td>\n",
       "      <td>XM_006523326.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>NC_000086.7</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>100612052</td>\n",
       "      <td>100612111</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1181798;Parent=rna106789;Dbxref=GeneID:17...</td>\n",
       "      <td>XM_006527871.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>94746902</td>\n",
       "      <td>94747025</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id581998;Parent=rna52023;Dbxref=GeneID:2029...</td>\n",
       "      <td>NM_009137.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>NC_000079.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>53485797</td>\n",
       "      <td>53485922</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id880287;Parent=rna78850;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_873411.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>111011285</td>\n",
       "      <td>111011462</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id590946;Parent=rna52837;Dbxref=GeneID:2347...</td>\n",
       "      <td>NM_001190800.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29952</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>127371496</td>\n",
       "      <td>127371878</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id598743;Parent=rna53748;Dbxref=GeneID:9374...</td>\n",
       "      <td>XM_006531527.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29953</th>\n",
       "      <td>NC_000075.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>21835510</td>\n",
       "      <td>21835814</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id608162;Parent=rna54531;Dbxref=GeneID:6242...</td>\n",
       "      <td>NM_001080940.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29956</th>\n",
       "      <td>NC_000075.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>42597854</td>\n",
       "      <td>42597961</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id615581;Parent=rna55355;Dbxref=GeneID:1106...</td>\n",
       "      <td>XM_017313103.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29958</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>34138269</td>\n",
       "      <td>34139431</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id743197;Parent=rna66190;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_872372.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29959</th>\n",
       "      <td>NC_000085.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>28928548</td>\n",
       "      <td>28928632</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1143176;Parent=rna102968;Dbxref=GeneID:38...</td>\n",
       "      <td>XM_011247272.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29960</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>34282423</td>\n",
       "      <td>34282592</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id9409;Parent=rna608;Dbxref=GeneID:13518,Ge...</td>\n",
       "      <td>XM_006495685.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29961</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>90600186</td>\n",
       "      <td>90600280</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id785667;Parent=rna69875;Dbxref=GeneID:2091...</td>\n",
       "      <td>XM_006532737.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29962</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>101863777</td>\n",
       "      <td>101863896</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id356684;Parent=rna31035;Dbxref=GeneID:7214...</td>\n",
       "      <td>XM_006535225.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29963</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>118545393</td>\n",
       "      <td>118545456</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id51774;Parent=rna3652;Dbxref=GeneID:76707,...</td>\n",
       "      <td>XM_017312817.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29964</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>46545612</td>\n",
       "      <td>46545728</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id256601;Parent=rna22403;Dbxref=GeneID:1076...</td>\n",
       "      <td>NM_178893.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29966</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>82970635</td>\n",
       "      <td>82970820</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id267868;Parent=rna23351;Dbxref=GeneID:3298...</td>\n",
       "      <td>XR_001784157.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29967</th>\n",
       "      <td>NC_000082.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>43072424</td>\n",
       "      <td>43072469</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1026109;Parent=rna92025;Dbxref=GeneID:564...</td>\n",
       "      <td>XM_017317089.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29970</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>16205397</td>\n",
       "      <td>16205498</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id464855;Parent=rna40782;Dbxref=GeneID:7172...</td>\n",
       "      <td>NM_027883.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29972</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>52075813</td>\n",
       "      <td>52075975</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id685647;Parent=rna61190;Dbxref=GeneID:1988...</td>\n",
       "      <td>XM_017313855.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29973</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>116154633</td>\n",
       "      <td>116154686</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id519731;Parent=rna46360;Dbxref=GeneID:2337...</td>\n",
       "      <td>NM_001305190.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29974</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>87737551</td>\n",
       "      <td>87737668</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id784412;Parent=rna69740;Dbxref=GeneID:2092...</td>\n",
       "      <td>XM_006532741.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29976</th>\n",
       "      <td>NC_000082.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>16316334</td>\n",
       "      <td>16316443</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1008620;Parent=rna90552;Dbxref=GeneID:740...</td>\n",
       "      <td>NM_001276341.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29978</th>\n",
       "      <td>NC_000080.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>65174055</td>\n",
       "      <td>65174175</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id936720;Parent=rna84314;Dbxref=GeneID:1052...</td>\n",
       "      <td>XR_874714.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29979</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>80305529</td>\n",
       "      <td>80305627</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id703447;Parent=rna62607;Dbxref=GeneID:2380...</td>\n",
       "      <td>NM_011789.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29980</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>125569555</td>\n",
       "      <td>125569651</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id158051;Parent=rna12635;Dbxref=GeneID:9910...</td>\n",
       "      <td>XM_011239870.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29982</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>90940564</td>\n",
       "      <td>90940575</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id712588;Parent=rna63423;Dbxref=GeneID:7753...</td>\n",
       "      <td>XM_006514301.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29983</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>76876332</td>\n",
       "      <td>76876422</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id348601;Parent=rna30290;Dbxref=GeneID:2313...</td>\n",
       "      <td>XR_389267.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29984</th>\n",
       "      <td>NC_000069.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>108911164</td>\n",
       "      <td>108911260</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id227419;Parent=rna19628;Dbxref=GeneID:6692...</td>\n",
       "      <td>XM_006501915.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29985</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>4787444</td>\n",
       "      <td>4787549</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id732892;Parent=rna65250;Dbxref=GeneID:1801...</td>\n",
       "      <td>XM_011243669.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29986</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>42934633</td>\n",
       "      <td>42934818</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id252873;Parent=rna22077;Dbxref=GeneID:2300...</td>\n",
       "      <td>XM_017320120.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29988</th>\n",
       "      <td>NC_000069.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>101439375</td>\n",
       "      <td>101439779</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id222996;Parent=rna19162;Dbxref=GeneID:7890...</td>\n",
       "      <td>XM_006502342.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29991</th>\n",
       "      <td>NC_000084.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>31841440</td>\n",
       "      <td>31841642</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1107440;Parent=rna99310;Dbxref=GeneID:743...</td>\n",
       "      <td>NM_001170967.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29995</th>\n",
       "      <td>NC_000082.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>52139491</td>\n",
       "      <td>52139628</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1029870;Parent=rna92382;Dbxref=GeneID:208...</td>\n",
       "      <td>XM_006521949.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29996</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>108690884</td>\n",
       "      <td>108691063</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id719123;Parent=rna63941;Dbxref=GeneID:2097...</td>\n",
       "      <td>XM_006513448.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29997</th>\n",
       "      <td>NC_000067.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>130945428</td>\n",
       "      <td>130945457</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id55237;Parent=rna3973;Dbxref=GeneID:329244...</td>\n",
       "      <td>XM_006529705.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>15309 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             seqid      source  type      start        end score strand phase  \\\n",
       "2      NC_000071.6  BestRefSeq  exon   24544129   24544373     .      -     .   \n",
       "3      NC_000074.6      Gnomon  exon   71655663   71655741     .      -     .   \n",
       "7      NC_000073.6      Gnomon  exon  118329486  118329612     .      +     .   \n",
       "8      NC_000076.6      Gnomon  exon    5175722    5175928     .      -     .   \n",
       "9      NC_000083.6      Gnomon  exon   24585923   24586066     .      +     .   \n",
       "13     NC_000077.6      Gnomon  exon   61740946   61741001     .      -     .   \n",
       "14     NC_000070.6  BestRefSeq  exon  149130153  149130219     .      -     .   \n",
       "15     NC_000068.7  BestRefSeq  exon  125218141  125218252     .      +     .   \n",
       "16     NC_000086.7  BestRefSeq  exon  134446962  134447027     .      +     .   \n",
       "18     NC_000076.6      Gnomon  exon   57708192   57708290     .      +     .   \n",
       "19     NC_000077.6  BestRefSeq  exon   60499325   60499560     .      +     .   \n",
       "21     NC_000067.6      Gnomon  exon  154426526  154426617     .      -     .   \n",
       "23     NC_000081.6  BestRefSeq  exon   77153530   77153812     .      -     .   \n",
       "24     NC_000069.6      Gnomon  exon   80702458   80702656     .      -     .   \n",
       "25     NC_000071.6      Gnomon  exon   52622299   52622981     .      -     .   \n",
       "26     NC_000075.6      Gnomon  exon   49502134   49505563     .      -     .   \n",
       "28     NC_000085.6      Gnomon  exon   56842212   56842319     .      +     .   \n",
       "32     NC_000081.6      Gnomon  exon   76380468   76380576     .      +     .   \n",
       "34     NC_000073.6      Gnomon  exon   45309098   45309230     .      -     .   \n",
       "35     NC_000076.6      Gnomon  exon  109903062  109903114     .      -     .   \n",
       "38     NC_000085.6  BestRefSeq  exon    6372301    6372416     .      +     .   \n",
       "39     NC_000068.7  BestRefSeq  exon  152440765  152440922     .      +     .   \n",
       "41     NC_000074.6      Gnomon  exon   84923731   84923939     .      -     .   \n",
       "43     NC_000071.6  BestRefSeq  exon   67702980   67703044     .      -     .   \n",
       "45     NC_000071.6      Gnomon  exon  123646083  123646305     .      -     .   \n",
       "46     NC_000083.6      Gnomon  exon   12895512   12895597     .      -     .   \n",
       "48     NC_000086.7      Gnomon  exon  100612052  100612111     .      +     .   \n",
       "49     NC_000074.6  BestRefSeq  exon   94746902   94747025     .      +     .   \n",
       "52     NC_000079.6      Gnomon  exon   53485797   53485922     .      +     .   \n",
       "54     NC_000074.6  BestRefSeq  exon  111011285  111011462     .      -     .   \n",
       "...            ...         ...   ...        ...        ...   ...    ...   ...   \n",
       "29952  NC_000074.6      Gnomon  exon  127371496  127371878     .      +     .   \n",
       "29953  NC_000075.6  BestRefSeq  exon   21835510   21835814     .      +     .   \n",
       "29956  NC_000075.6      Gnomon  exon   42597854   42597961     .      -     .   \n",
       "29958  NC_000077.6      Gnomon  exon   34138269   34139431     .      +     .   \n",
       "29959  NC_000085.6      Gnomon  exon   28928548   28928632     .      -     .   \n",
       "29960  NC_000067.6      Gnomon  exon   34282423   34282592     .      +     .   \n",
       "29961  NC_000077.6      Gnomon  exon   90600186   90600280     .      -     .   \n",
       "29962  NC_000071.6      Gnomon  exon  101863777  101863896     .      -     .   \n",
       "29963  NC_000067.6      Gnomon  exon  118545393  118545456     .      +     .   \n",
       "29964  NC_000070.6  BestRefSeq  exon   46545612   46545728     .      -     .   \n",
       "29966  NC_000070.6      Gnomon  exon   82970635   82970820     .      -     .   \n",
       "29967  NC_000082.6      Gnomon  exon   43072424   43072469     .      +     .   \n",
       "29970  NC_000073.6  BestRefSeq  exon   16205397   16205498     .      -     .   \n",
       "29972  NC_000076.6      Gnomon  exon   52075813   52075975     .      -     .   \n",
       "29973  NC_000073.6  BestRefSeq  exon  116154633  116154686     .      -     .   \n",
       "29974  NC_000077.6      Gnomon  exon   87737551   87737668     .      +     .   \n",
       "29976  NC_000082.6  BestRefSeq  exon   16316334   16316443     .      -     .   \n",
       "29978  NC_000080.6      Gnomon  exon   65174055   65174175     .      +     .   \n",
       "29979  NC_000076.6  BestRefSeq  exon   80305529   80305627     .      +     .   \n",
       "29980  NC_000068.7      Gnomon  exon  125569555  125569651     .      -     .   \n",
       "29982  NC_000076.6      Gnomon  exon   90940564   90940575     .      +     .   \n",
       "29983  NC_000071.6      Gnomon  exon   76876332   76876422     .      -     .   \n",
       "29984  NC_000069.6      Gnomon  exon  108911164  108911260     .      -     .   \n",
       "29985  NC_000077.6      Gnomon  exon    4787444    4787549     .      -     .   \n",
       "29986  NC_000070.6      Gnomon  exon   42934633   42934818     .      +     .   \n",
       "29988  NC_000069.6      Gnomon  exon  101439375  101439779     .      +     .   \n",
       "29991  NC_000084.6  BestRefSeq  exon   31841440   31841642     .      +     .   \n",
       "29995  NC_000082.6      Gnomon  exon   52139491   52139628     .      +     .   \n",
       "29996  NC_000076.6      Gnomon  exon  108690884  108691063     .      -     .   \n",
       "29997  NC_000067.6      Gnomon  exon  130945428  130945457     .      -     .   \n",
       "\n",
       "                                              attributes            gbid  \n",
       "2      ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...     NM_177676.6  \n",
       "3      ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...  XM_017312883.1  \n",
       "7      ID=id520282;Parent=rna46416;Dbxref=GeneID:1026...     XR_378454.2  \n",
       "8      ID=id673061;Parent=rna60010;Dbxref=GeneID:6400...  XM_017314047.1  \n",
       "9      ID=id1054336;Parent=rna94586;Dbxref=GeneID:187...  XM_017317334.1  \n",
       "13     ID=id756287;Parent=rna67525;Dbxref=GeneID:2126...  XM_006532761.3  \n",
       "14     ID=id309255;Parent=rna27107;Dbxref=GeneID:6992...     NM_027263.2  \n",
       "15     ID=id157624;Parent=rna12621;Dbxref=GeneID:2049...  NM_001079690.1  \n",
       "16     ID=id1188223;Parent=rna107372;Dbxref=GeneID:13...     NM_010078.3  \n",
       "18     ID=id686725;Parent=rna61293;Dbxref=GeneID:1876...  XM_006512605.3  \n",
       "19     ID=id754010;Parent=rna67374;Dbxref=GeneID:1791...     NM_182698.2  \n",
       "21     ID=id67658;Parent=rna4879;Dbxref=GeneID:12290,...  XM_017312594.1  \n",
       "23     ID=id979416;Parent=rna87784;Dbxref=GeneID:9368...  NM_001286419.1  \n",
       "24     ID=id206493;Parent=rna17568;Dbxref=GeneID:1480...  XR_001783656.1  \n",
       "25     ID=id341017;Parent=rna29660;Dbxref=GeneID:1026...     XR_376954.1  \n",
       "26     ID=id621844;Parent=rna55895;Dbxref=GeneID:1796...  XM_006510062.1  \n",
       "28     ID=id1158048;Parent=rna104294;Dbxref=GeneID:83...  XM_006527477.3  \n",
       "32     ID=id977457;Parent=rna87622;Dbxref=GeneID:2236...  XM_011245572.1  \n",
       "34     ID=id487259;Parent=rna43262;Dbxref=GeneID:6866...  XM_006541148.3  \n",
       "35     ID=id719264;Parent=rna63948;Dbxref=GeneID:2603...  XM_006513679.2  \n",
       "38     ID=id1132895;Parent=rna101937;Dbxref=GeneID:22...     NM_011750.2  \n",
       "39     ID=id169605;Parent=rna13822;Dbxref=GeneID:2287...     NR_110367.1  \n",
       "41     ID=id576343;Parent=rna51558;Dbxref=GeneID:5652...  XM_006531216.3  \n",
       "43     ID=id344114;Parent=rna29991;Dbxref=GeneID:1198...  NM_001038999.2  \n",
       "45     ID=id375767;Parent=rna32649;Dbxref=GeneID:5643...  XM_017321017.1  \n",
       "46     ID=id1047168;Parent=rna93919;Dbxref=GeneID:240...  XM_006523326.2  \n",
       "48     ID=id1181798;Parent=rna106789;Dbxref=GeneID:17...  XM_006527871.2  \n",
       "49     ID=id581998;Parent=rna52023;Dbxref=GeneID:2029...     NM_009137.2  \n",
       "52     ID=id880287;Parent=rna78850;Dbxref=GeneID:1026...     XR_873411.1  \n",
       "54     ID=id590946;Parent=rna52837;Dbxref=GeneID:2347...  NM_001190800.1  \n",
       "...                                                  ...             ...  \n",
       "29952  ID=id598743;Parent=rna53748;Dbxref=GeneID:9374...  XM_006531527.2  \n",
       "29953  ID=id608162;Parent=rna54531;Dbxref=GeneID:6242...  NM_001080940.1  \n",
       "29956  ID=id615581;Parent=rna55355;Dbxref=GeneID:1106...  XM_017313103.1  \n",
       "29958  ID=id743197;Parent=rna66190;Dbxref=GeneID:1026...     XR_872372.1  \n",
       "29959  ID=id1143176;Parent=rna102968;Dbxref=GeneID:38...  XM_011247272.2  \n",
       "29960  ID=id9409;Parent=rna608;Dbxref=GeneID:13518,Ge...  XM_006495685.2  \n",
       "29961  ID=id785667;Parent=rna69875;Dbxref=GeneID:2091...  XM_006532737.3  \n",
       "29962  ID=id356684;Parent=rna31035;Dbxref=GeneID:7214...  XM_006535225.3  \n",
       "29963  ID=id51774;Parent=rna3652;Dbxref=GeneID:76707,...  XM_017312817.1  \n",
       "29964  ID=id256601;Parent=rna22403;Dbxref=GeneID:1076...     NM_178893.4  \n",
       "29966  ID=id267868;Parent=rna23351;Dbxref=GeneID:3298...  XR_001784157.1  \n",
       "29967  ID=id1026109;Parent=rna92025;Dbxref=GeneID:564...  XM_017317089.1  \n",
       "29970  ID=id464855;Parent=rna40782;Dbxref=GeneID:7172...     NM_027883.3  \n",
       "29972  ID=id685647;Parent=rna61190;Dbxref=GeneID:1988...  XM_017313855.1  \n",
       "29973  ID=id519731;Parent=rna46360;Dbxref=GeneID:2337...  NM_001305190.1  \n",
       "29974  ID=id784412;Parent=rna69740;Dbxref=GeneID:2092...  XM_006532741.2  \n",
       "29976  ID=id1008620;Parent=rna90552;Dbxref=GeneID:740...  NM_001276341.1  \n",
       "29978  ID=id936720;Parent=rna84314;Dbxref=GeneID:1052...     XR_874714.1  \n",
       "29979  ID=id703447;Parent=rna62607;Dbxref=GeneID:2380...     NM_011789.2  \n",
       "29980  ID=id158051;Parent=rna12635;Dbxref=GeneID:9910...  XM_011239870.1  \n",
       "29982  ID=id712588;Parent=rna63423;Dbxref=GeneID:7753...  XM_006514301.2  \n",
       "29983  ID=id348601;Parent=rna30290;Dbxref=GeneID:2313...     XR_389267.2  \n",
       "29984  ID=id227419;Parent=rna19628;Dbxref=GeneID:6692...  XM_006501915.1  \n",
       "29985  ID=id732892;Parent=rna65250;Dbxref=GeneID:1801...  XM_011243669.2  \n",
       "29986  ID=id252873;Parent=rna22077;Dbxref=GeneID:2300...  XM_017320120.1  \n",
       "29988  ID=id222996;Parent=rna19162;Dbxref=GeneID:7890...  XM_006502342.3  \n",
       "29991  ID=id1107440;Parent=rna99310;Dbxref=GeneID:743...  NM_001170967.1  \n",
       "29995  ID=id1029870;Parent=rna92382;Dbxref=GeneID:208...  XM_006521949.1  \n",
       "29996  ID=id719123;Parent=rna63941;Dbxref=GeneID:2097...  XM_006513448.1  \n",
       "29997  ID=id55237;Parent=rna3973;Dbxref=GeneID:329244...  XM_006529705.1  \n",
       "\n",
       "[15309 rows x 10 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exon_mouse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'NM_177676.6'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exon_mouse['gbid'].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "829310.7034000154\n"
     ]
    }
   ],
   "source": [
    "from Bio import Entrez\n",
    "from Bio import SeqIO\n",
    "from Bio.SeqUtils import GC, molecular_weight\n",
    "\n",
    "Entrez.email = 'Hello@example.com'\n",
    "handle = Entrez.efetch(db = 'nucleotide', id = exon_mouse[\"gbid\"].iloc[0], rettype = 'gb')\n",
    "seq_record = SeqIO.read(handle, 'gb')\n",
    "print(molecular_weight(seq_record.seq))\n",
    "handle.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "exon_mouse10 = exon_mouse.iloc[0:10,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "exon_mouse10.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "mws = []\n",
    "for gbid in exon_mouse10[\"gbid\"]:\n",
    "    handle = Entrez.efetch(db = 'nucleotide', id = gbid, rettype = 'gb')\n",
    "    seq_record = SeqIO.read(handle, 'gb')\n",
    "    mws.append(molecular_weight(seq_record.seq))\n",
    "    handle.close()\n",
    "\n",
    "exon_mouse10.insert(len(exon_mouse10.columns), 'mw', mws)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>seqid</th>\n",
       "      <th>source</th>\n",
       "      <th>type</th>\n",
       "      <th>start</th>\n",
       "      <th>end</th>\n",
       "      <th>score</th>\n",
       "      <th>strand</th>\n",
       "      <th>phase</th>\n",
       "      <th>attributes</th>\n",
       "      <th>gbid</th>\n",
       "      <th>mw</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NC_000071.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>24544129</td>\n",
       "      <td>24544373</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...</td>\n",
       "      <td>NM_177676.6</td>\n",
       "      <td>8.293107e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NC_000074.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>71655663</td>\n",
       "      <td>71655741</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...</td>\n",
       "      <td>XM_017312883.1</td>\n",
       "      <td>2.164587e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>NC_000073.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>118329486</td>\n",
       "      <td>118329612</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id520282;Parent=rna46416;Dbxref=GeneID:1026...</td>\n",
       "      <td>XR_378454.2</td>\n",
       "      <td>3.169640e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>5175722</td>\n",
       "      <td>5175928</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id673061;Parent=rna60010;Dbxref=GeneID:6400...</td>\n",
       "      <td>XM_017314047.1</td>\n",
       "      <td>8.345749e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>NC_000083.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>24585923</td>\n",
       "      <td>24586066</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1054336;Parent=rna94586;Dbxref=GeneID:187...</td>\n",
       "      <td>XM_017317334.1</td>\n",
       "      <td>4.384230e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NC_000077.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>61740946</td>\n",
       "      <td>61741001</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id756287;Parent=rna67525;Dbxref=GeneID:2126...</td>\n",
       "      <td>XM_006532761.3</td>\n",
       "      <td>5.642921e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NC_000070.6</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>149130153</td>\n",
       "      <td>149130219</td>\n",
       "      <td>.</td>\n",
       "      <td>-</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id309255;Parent=rna27107;Dbxref=GeneID:6992...</td>\n",
       "      <td>NM_027263.2</td>\n",
       "      <td>2.891971e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NC_000068.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>125218141</td>\n",
       "      <td>125218252</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id157624;Parent=rna12621;Dbxref=GeneID:2049...</td>\n",
       "      <td>NM_001079690.1</td>\n",
       "      <td>1.441759e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NC_000086.7</td>\n",
       "      <td>BestRefSeq</td>\n",
       "      <td>exon</td>\n",
       "      <td>134446962</td>\n",
       "      <td>134447027</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id1188223;Parent=rna107372;Dbxref=GeneID:13...</td>\n",
       "      <td>NM_010078.3</td>\n",
       "      <td>2.157642e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NC_000076.6</td>\n",
       "      <td>Gnomon</td>\n",
       "      <td>exon</td>\n",
       "      <td>57708192</td>\n",
       "      <td>57708290</td>\n",
       "      <td>.</td>\n",
       "      <td>+</td>\n",
       "      <td>.</td>\n",
       "      <td>ID=id686725;Parent=rna61293;Dbxref=GeneID:1876...</td>\n",
       "      <td>XM_006512605.3</td>\n",
       "      <td>3.328927e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         seqid      source  type      start        end score strand phase  \\\n",
       "0  NC_000071.6  BestRefSeq  exon   24544129   24544373     .      -     .   \n",
       "1  NC_000074.6      Gnomon  exon   71655663   71655741     .      -     .   \n",
       "2  NC_000073.6      Gnomon  exon  118329486  118329612     .      +     .   \n",
       "3  NC_000076.6      Gnomon  exon    5175722    5175928     .      -     .   \n",
       "4  NC_000083.6      Gnomon  exon   24585923   24586066     .      +     .   \n",
       "5  NC_000077.6      Gnomon  exon   61740946   61741001     .      -     .   \n",
       "6  NC_000070.6  BestRefSeq  exon  149130153  149130219     .      -     .   \n",
       "7  NC_000068.7  BestRefSeq  exon  125218141  125218252     .      +     .   \n",
       "8  NC_000086.7  BestRefSeq  exon  134446962  134447027     .      +     .   \n",
       "9  NC_000076.6      Gnomon  exon   57708192   57708290     .      +     .   \n",
       "\n",
       "                                          attributes            gbid  \\\n",
       "0  ID=id325971;Parent=rna28488;Dbxref=GeneID:2310...     NM_177676.6   \n",
       "1  ID=id568467;Parent=rna50916;Dbxref=GeneID:3820...  XM_017312883.1   \n",
       "2  ID=id520282;Parent=rna46416;Dbxref=GeneID:1026...     XR_378454.2   \n",
       "3  ID=id673061;Parent=rna60010;Dbxref=GeneID:6400...  XM_017314047.1   \n",
       "4  ID=id1054336;Parent=rna94586;Dbxref=GeneID:187...  XM_017317334.1   \n",
       "5  ID=id756287;Parent=rna67525;Dbxref=GeneID:2126...  XM_006532761.3   \n",
       "6  ID=id309255;Parent=rna27107;Dbxref=GeneID:6992...     NM_027263.2   \n",
       "7  ID=id157624;Parent=rna12621;Dbxref=GeneID:2049...  NM_001079690.1   \n",
       "8  ID=id1188223;Parent=rna107372;Dbxref=GeneID:13...     NM_010078.3   \n",
       "9  ID=id686725;Parent=rna61293;Dbxref=GeneID:1876...  XM_006512605.3   \n",
       "\n",
       "             mw  \n",
       "0  8.293107e+05  \n",
       "1  2.164587e+06  \n",
       "2  3.169640e+05  \n",
       "3  8.345749e+06  \n",
       "4  4.384230e+06  \n",
       "5  5.642921e+05  \n",
       "6  2.891971e+05  \n",
       "7  1.441759e+06  \n",
       "8  2.157642e+06  \n",
       "9  3.328927e+05  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "exon_mouse10"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**NOTE** We have to filter on exons to be able to query the Entrez nucleotide database otherwise there will be gbid for other types and you will need to specify another db value e.g. protein."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Next session\n",
    "\n",
    "Go to our next notebook: [Session 2.4: Data project report in Jupyter](24_python_data.ipynb)"
   ]
  }
 ],
 "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}