Mito_novel_Phosphosites.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "suburban-diving",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import sys\n",
    "import os\n",
    "from collections import Counter\n",
    "import matplotlib.pyplot as plt\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "seasonal-nevada",
   "metadata": {},
   "outputs": [],
   "source": [
    "path_databases = os.path.dirname(os.path.abspath('__file__'))\n",
    "df_known_sites = pd.read_csv((path_databases+'\\\\known_PSP_Phosphosites_mouse.csv'),low_memory=False)\n",
    "\n",
    "path = os.path.dirname(os.path.abspath('__file__'))+'\\\\Prepared_tables\\\\'\n",
    "df_sites = pd.read_csv((path+'Prep_STYsites_mito.csv'),low_memory=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "leading-aluminum",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "99 novel phosphosites\n"
     ]
    }
   ],
   "source": [
    "df_sites['Proteins'] = [df_sites['Proteins'][i].split(';') for i in range(len(df_sites))]\n",
    "df_sites['Positions within proteins'] = [df_sites['Positions within proteins'][i].split(';') for i in range(len(df_sites))]\n",
    "res = [[i + '_'+ j for i, j in zip(df_sites['Proteins'][x], df_sites['Positions within proteins'][x])] for  x in range(len(df_sites))]\n",
    "\n",
    "\n",
    "not_in_PSP = []\n",
    "for x in range(len(res)): \n",
    "    a = [res[x][i] in list(df_known_sites['sites']) for i in range(len(res[x]))]\n",
    "    if True not in a:\n",
    "        not_in_PSP.append(x) \n",
    "\n",
    "sites_not_in_PSP =  len(not_in_PSP)        \n",
    "print(str(sites_not_in_PSP)+ ' novel phosphosites')     "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "ultimate-performer",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['275320'\n",
      "['283531'\n",
      "['993970'\n",
      "['88424'\n",
      "['593876'\n",
      "['1092920'\n",
      "['767856'\n",
      "['191406'\n",
      "['956127'\n",
      "['956143'\n",
      "['902500'\n",
      "['172694'\n",
      "['1148187'\n",
      "['92870'\n",
      "['512695'\n",
      "['1167135'\n",
      "['1167135'\n",
      "['220567'\n",
      "['1157980'\n",
      "['1094441'\n",
      "['399964'\n",
      "['678140'\n",
      "['832082'\n",
      "['820502'\n",
      "['939998'\n",
      "['936410'\n",
      "['887654'\n",
      "['408958'\n",
      "['408958'\n",
      "['408958'\n",
      "['1046309'\n",
      "['827874'\n",
      "['912868'\n",
      "['985813'\n",
      "['930499'\n",
      "['413042'\n",
      "['714935'\n",
      "['942274'\n",
      "['326047'\n",
      "['794340'\n",
      "['158951'\n",
      "['1081102'\n",
      "['650500'\n",
      "['1134959'\n",
      "['999607'\n",
      "['280611'\n",
      "['872974'\n",
      "['166493'\n",
      "['964356'\n",
      "['273548'\n",
      "['1020154'\n",
      "['911400'\n",
      "['903894'\n",
      "['91173'\n",
      "['558417'\n",
      "['449828'\n",
      "['509129'\n",
      "['210549'\n",
      "['422184'\n",
      "['422184'\n",
      "['74323'\n",
      "['1206423'\n",
      "['41925'\n",
      "['32294'\n",
      "['118851'\n",
      "['826424'\n",
      "['265063'\n",
      "['1184433'\n",
      "['1184433'\n",
      "['89714'\n",
      "['941501'\n",
      "['1128188'\n",
      "['868491'\n",
      "['1066211'\n",
      "['1157087'\n",
      "['4379'\n",
      "['1029655'\n",
      "['825538'\n",
      "['579100'\n",
      "['593876'\n",
      "['1044880'\n",
      "['137109'\n",
      "['864534'\n",
      "['1044953'\n",
      "['23848'\n",
      "['172862'\n",
      "['310412'\n",
      "['1019895'\n",
      "['769376'\n",
      "['461224'\n",
      "['389010'\n",
      "['280611'\n",
      "['20085'\n",
      "['207852'\n",
      "['1121106'\n",
      "['1031029'\n",
      "['542012'\n",
      "['1216219'\n",
      "['1206423'\n"
     ]
    }
   ],
   "source": [
    "for i in df_sites.iloc[not_in_PSP][['Proteins','Phospho (STY) site IDs']].reset_index()['Phospho (STY) site IDs']:\n",
    "    print(i.split(',')[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "inappropriate-prerequisite",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"['275320', '275321', '275322', '275323', '275325', '275326', '275327', '275328', '275329', '275330', '275331', '275324']\""
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sites.iloc[not_in_PSP][['Proteins','Phospho (STY) site IDs']].reset_index()['Phospho (STY) site IDs'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "provincial-tribute",
   "metadata": {},
   "outputs": [],
   "source": [
    "cc = [res[i] for i in not_in_PSP]#not_in_PSP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "elegant-window",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['F7D3W5_230',\n",
       " 'Q922S4-2_185',\n",
       " 'Q5PR72_204',\n",
       " 'Q922S4_204',\n",
       " 'A0A1B0GRJ9_214',\n",
       " 'Q922S4-3_197']"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "res[not_in_PSP[10]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "attractive-bowling",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "False"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"P40630_123\" in df_known_sites"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "prospective-competition",
   "metadata": {},
   "outputs": [],
   "source": [
    "bb = pd.DataFrame()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "radio-crawford",
   "metadata": {},
   "outputs": [],
   "source": [
    "bb['id'] = cc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "biblical-mayor",
   "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>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[A0A0R4J1N9_79, P40630-2_95, P40630_123, D3Z0F...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[A0A1L1STE6_105, Q9D6R2_87, Q9D6R2-2_9]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[Q08460-5_1113, Q08460_1178, J3QN27_1049, A0A2...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[A0A5H1ZRL1_6]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[D3YUM1_22, Q91YT0_31, A0A494BAS8_31, D6RG60_31]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>[D3Z0L4_79, Q9D9P1_79, S4R238_79, Q9CRB9_79]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[D3Z6F5_15]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>[D3Z7P3_123, D3Z7P3-2_123]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[E9PVS5_178]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[E9Q800_154, E9QAY6_154, Q8CAQ8_232, Q8CAQ8-5_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>[F7D3W5_230, Q922S4-2_185, Q5PR72_204, Q922S4_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>[O35129_105, F6QPR1_15, F6Q8V7_42]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>[O35129_119, F6QPR1_29, F6Q8V7_56]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>[P05202_123]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>[P05202_317]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>[P12242_50]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>[P12242_51]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>[Q9D881_84, P19536_83]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>[P46656_185]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>[P47738_278, A0A0G2JEU1_278]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>[P48962_213]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>[P54071_443]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>[P56394_8]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>[P58281-2_517, P58281_480, H7BX01_498, E0CXD1_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>[P97807-2_322, P97807_362]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>[Q2TPA8_237, B1AX78_117]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>[V9GX56_42, V9GXP9_42, Q3U4S0_42]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>[Q4KMM3_460, Q4KMM3-4_460, Q4KMM3-2_372, E9Q0A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>[Q4KMM3_462, Q4KMM3-4_462, Q4KMM3-2_374, E9Q0A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>[Q4KMM3_463, Q4KMM3-4_463, Q4KMM3-2_375, E9Q0A...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>[Q60932-2_44, Q60932_57, F2Z471_44]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>[Q64521_384, A2AQR0_384]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>[Q64521_410, A2AQR0_410]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id\n",
       "0   [A0A0R4J1N9_79, P40630-2_95, P40630_123, D3Z0F...\n",
       "1             [A0A1L1STE6_105, Q9D6R2_87, Q9D6R2-2_9]\n",
       "2   [Q08460-5_1113, Q08460_1178, J3QN27_1049, A0A2...\n",
       "3                                      [A0A5H1ZRL1_6]\n",
       "4    [D3YUM1_22, Q91YT0_31, A0A494BAS8_31, D6RG60_31]\n",
       "5        [D3Z0L4_79, Q9D9P1_79, S4R238_79, Q9CRB9_79]\n",
       "6                                         [D3Z6F5_15]\n",
       "7                          [D3Z7P3_123, D3Z7P3-2_123]\n",
       "8                                        [E9PVS5_178]\n",
       "9   [E9Q800_154, E9QAY6_154, Q8CAQ8_232, Q8CAQ8-5_...\n",
       "10  [F7D3W5_230, Q922S4-2_185, Q5PR72_204, Q922S4_...\n",
       "11                 [O35129_105, F6QPR1_15, F6Q8V7_42]\n",
       "12                 [O35129_119, F6QPR1_29, F6Q8V7_56]\n",
       "13                                       [P05202_123]\n",
       "14                                       [P05202_317]\n",
       "15                                        [P12242_50]\n",
       "16                                        [P12242_51]\n",
       "17                             [Q9D881_84, P19536_83]\n",
       "18                                       [P46656_185]\n",
       "19                       [P47738_278, A0A0G2JEU1_278]\n",
       "20                                       [P48962_213]\n",
       "21                                       [P54071_443]\n",
       "22                                         [P56394_8]\n",
       "23  [P58281-2_517, P58281_480, H7BX01_498, E0CXD1_...\n",
       "24                         [P97807-2_322, P97807_362]\n",
       "25                           [Q2TPA8_237, B1AX78_117]\n",
       "26                  [V9GX56_42, V9GXP9_42, Q3U4S0_42]\n",
       "27  [Q4KMM3_460, Q4KMM3-4_460, Q4KMM3-2_372, E9Q0A...\n",
       "28  [Q4KMM3_462, Q4KMM3-4_462, Q4KMM3-2_374, E9Q0A...\n",
       "29  [Q4KMM3_463, Q4KMM3-4_463, Q4KMM3-2_375, E9Q0A...\n",
       "30                [Q60932-2_44, Q60932_57, F2Z471_44]\n",
       "31                           [Q64521_384, A2AQR0_384]\n",
       "32                           [Q64521_410, A2AQR0_410]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bb.iloc[0:33]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "cordless-relevance",
   "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>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>[Q78IK4_191]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>[Q80U23_49, Q80U23-2_82, Z4YN82_49]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>[Q8BGH2_131]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>[Q8BHS8-3_127, Q8BHS8-2_198, Q8BHS8_199, Q8BHS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>[Q8BIJ6_509, E9PWN2_509, E9PWN3_509]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>[Q8BKZ9_196, A2AWH7_131, A2AWH8_196]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>[Q8BMF4_390]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>[Q8BP40_315]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>[Q8BX70-2_3609, A0A1L1SS63_743, A0A1L1SSJ3_62]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>[Q8C196_1203]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>[Q8CAQ8_182, Q8CAQ8-5_182, Q8CAQ8-2_171]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>[Q8K0L3_225, Q8K0L3-2_250, Q8K0L3-3_225]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>[Q8K1Z0_59, F6SFF5_59]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>[Q8K2B3_339]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>[Q8K370_576]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>[Q8K3J1_52]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>[Q8R164_83]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>[Q8R1R3_238, F7BBA2_274]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>[Q8VDD5_1713]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>[Q91VD9_143]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>[Q91VN4_172, E9Q4M4_172]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>[Q921G7_490, Q6PF96_430]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>[Q924X2_372]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>[Q99L13_86]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>[Q99LC5_179]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>[Q99LC5_182]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>[Q9CQ75_96]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>[Q9CQ91_43, D3Z670_43]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>[Q9CQB4_5, Q9D855_5]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>[Q9CQN1_196]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>[Q9CR62_203, Q5SX46_171]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>[Q9CR68_150]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id\n",
       "34                                       [Q78IK4_191]\n",
       "35                [Q80U23_49, Q80U23-2_82, Z4YN82_49]\n",
       "36                                       [Q8BGH2_131]\n",
       "37  [Q8BHS8-3_127, Q8BHS8-2_198, Q8BHS8_199, Q8BHS...\n",
       "38               [Q8BIJ6_509, E9PWN2_509, E9PWN3_509]\n",
       "39               [Q8BKZ9_196, A2AWH7_131, A2AWH8_196]\n",
       "40                                       [Q8BMF4_390]\n",
       "41                                       [Q8BP40_315]\n",
       "42     [Q8BX70-2_3609, A0A1L1SS63_743, A0A1L1SSJ3_62]\n",
       "43                                      [Q8C196_1203]\n",
       "44           [Q8CAQ8_182, Q8CAQ8-5_182, Q8CAQ8-2_171]\n",
       "45           [Q8K0L3_225, Q8K0L3-2_250, Q8K0L3-3_225]\n",
       "46                             [Q8K1Z0_59, F6SFF5_59]\n",
       "47                                       [Q8K2B3_339]\n",
       "48                                       [Q8K370_576]\n",
       "49                                        [Q8K3J1_52]\n",
       "50                                        [Q8R164_83]\n",
       "51                           [Q8R1R3_238, F7BBA2_274]\n",
       "52                                      [Q8VDD5_1713]\n",
       "53                                       [Q91VD9_143]\n",
       "54                           [Q91VN4_172, E9Q4M4_172]\n",
       "55                           [Q921G7_490, Q6PF96_430]\n",
       "56                                       [Q924X2_372]\n",
       "57                                        [Q99L13_86]\n",
       "58                                       [Q99LC5_179]\n",
       "59                                       [Q99LC5_182]\n",
       "60                                        [Q9CQ75_96]\n",
       "61                             [Q9CQ91_43, D3Z670_43]\n",
       "62                               [Q9CQB4_5, Q9D855_5]\n",
       "63                                       [Q9CQN1_196]\n",
       "64                           [Q9CR62_203, Q5SX46_171]\n",
       "65                                       [Q9CR68_150]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bb.iloc[34:66]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "roman-literature",
   "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>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>[Q9CZ13_155, A0A0A6YW82_138]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>[Q9CZ13_159, A0A0A6YW82_142]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>[Q9D3D9_139]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>[Q9DBM2_349]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>[Q9DC70_37]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>[Q9DCZ4_194, Q9DCZ4-3_208, Q9DCZ4-2_160]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>[Q9DCZ4_65, Q9DCZ4-3_79, Q9DCZ4-2_31]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>[Q9JHI5_271]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>[Q9Z1P6_85]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>[A0A1B0GX27_62, O35855_62, O88374_22, A0A1B0GS...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>[A0A1L1STE6_87, Q9D6R2_69]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>[D3YTP3_298]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>[D3YUM1_21, Q91YT0_30, A0A494BAS8_30, D6RG60_30]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>[E9PV44_31, O35143_63]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>[E9Q800_402, E9QAY6_402, Q8CAQ8_480, Q8CAQ8-5_...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>[E9QJW0_91, D3YVR3_57]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>[Q9D924_69, I3ITR1_69]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>[P56391_7]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>[P67778_91, Q5SQG5_91]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>[P67778_141, Q5SQG5_141]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>[Q60932-2_188, Q60932_201, F2Z471_188]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>[Q64521_362, A2AQR0_362]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>[Q6P8J7_151]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>[Q8BWT1_216]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>[Q8K0L3_224, Q8K0L3-2_249, Q8K0L3-3_224]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>[Q91VS7_17, D3YU60_17, A0A0N4SV17_17]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>[Q9CQF4_110]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>[Q9ERS2_114]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>[G3UX26_195, Q60930_207, A0A286YCR8_207]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>[Q6P8J7_159]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>[Q8BH59_278]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>[Q9CQ91_41, D3Z670_41]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id\n",
       "67                       [Q9CZ13_155, A0A0A6YW82_138]\n",
       "68                       [Q9CZ13_159, A0A0A6YW82_142]\n",
       "69                                       [Q9D3D9_139]\n",
       "70                                       [Q9DBM2_349]\n",
       "71                                        [Q9DC70_37]\n",
       "72           [Q9DCZ4_194, Q9DCZ4-3_208, Q9DCZ4-2_160]\n",
       "73              [Q9DCZ4_65, Q9DCZ4-3_79, Q9DCZ4-2_31]\n",
       "74                                       [Q9JHI5_271]\n",
       "75                                        [Q9Z1P6_85]\n",
       "76  [A0A1B0GX27_62, O35855_62, O88374_22, A0A1B0GS...\n",
       "77                         [A0A1L1STE6_87, Q9D6R2_69]\n",
       "78                                       [D3YTP3_298]\n",
       "79   [D3YUM1_21, Q91YT0_30, A0A494BAS8_30, D6RG60_30]\n",
       "80                             [E9PV44_31, O35143_63]\n",
       "81  [E9Q800_402, E9QAY6_402, Q8CAQ8_480, Q8CAQ8-5_...\n",
       "82                             [E9QJW0_91, D3YVR3_57]\n",
       "83                             [Q9D924_69, I3ITR1_69]\n",
       "84                                         [P56391_7]\n",
       "85                             [P67778_91, Q5SQG5_91]\n",
       "86                           [P67778_141, Q5SQG5_141]\n",
       "87             [Q60932-2_188, Q60932_201, F2Z471_188]\n",
       "88                           [Q64521_362, A2AQR0_362]\n",
       "89                                       [Q6P8J7_151]\n",
       "90                                       [Q8BWT1_216]\n",
       "91           [Q8K0L3_224, Q8K0L3-2_249, Q8K0L3-3_224]\n",
       "92              [Q91VS7_17, D3YU60_17, A0A0N4SV17_17]\n",
       "93                                       [Q9CQF4_110]\n",
       "94                                       [Q9ERS2_114]\n",
       "95           [G3UX26_195, Q60930_207, A0A286YCR8_207]\n",
       "96                                       [Q6P8J7_159]\n",
       "97                                       [Q8BH59_278]\n",
       "98                             [Q9CQ91_41, D3Z670_41]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bb.iloc[67:99]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "professional-civilian",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[16,\n",
       " 26,\n",
       " 29,\n",
       " 41,\n",
       " 61,\n",
       " 69,\n",
       " 75,\n",
       " 78,\n",
       " 84,\n",
       " 90,\n",
       " 95,\n",
       " 113,\n",
       " 117,\n",
       " 127,\n",
       " 129,\n",
       " 136,\n",
       " 137,\n",
       " 151,\n",
       " 198,\n",
       " 199,\n",
       " 203,\n",
       " 216,\n",
       " 222,\n",
       " 224,\n",
       " 242,\n",
       " 258,\n",
       " 263,\n",
       " 279,\n",
       " 280,\n",
       " 281,\n",
       " 300,\n",
       " 306,\n",
       " 308,\n",
       " 310,\n",
       " 322,\n",
       " 331,\n",
       " 337,\n",
       " 344,\n",
       " 346,\n",
       " 355,\n",
       " 357,\n",
       " 364,\n",
       " 370,\n",
       " 380,\n",
       " 382,\n",
       " 387,\n",
       " 390,\n",
       " 392,\n",
       " 393,\n",
       " 394,\n",
       " 396,\n",
       " 397,\n",
       " 408,\n",
       " 410,\n",
       " 412,\n",
       " 426,\n",
       " 431,\n",
       " 436,\n",
       " 438,\n",
       " 439,\n",
       " 448,\n",
       " 450,\n",
       " 452,\n",
       " 456,\n",
       " 466,\n",
       " 469,\n",
       " 479,\n",
       " 481,\n",
       " 482,\n",
       " 491,\n",
       " 506,\n",
       " 507,\n",
       " 515,\n",
       " 516,\n",
       " 517,\n",
       " 535,\n",
       " 541,\n",
       " 542,\n",
       " 546,\n",
       " 547,\n",
       " 548,\n",
       " 549,\n",
       " 551,\n",
       " 553,\n",
       " 566,\n",
       " 571,\n",
       " 572,\n",
       " 576,\n",
       " 578,\n",
       " 580,\n",
       " 588,\n",
       " 592,\n",
       " 593,\n",
       " 594,\n",
       " 599,\n",
       " 606,\n",
       " 614,\n",
       " 615,\n",
       " 617]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "not_in_PSP"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "historic-lucas",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python_3.8 (Mito_eLife)",
   "language": "python",
   "name": "mito_elife"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}