StitchTUPAC16.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Stitching TUPAC16 concatenated images from the published patches"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "IdToGrid = pickle.load(open('TUPACStitchInformation.p','rb'))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Generating 01_stitched1.tif\n",
      "Generating 02_stitched1.tif\n",
      "Generating 03_stitched1.tif\n",
      "Generating 04_stitched1.tif\n",
      "Generating 05_stitched1.tif\n",
      "Generating 06_stitched1.tif\n",
      "Generating 07_stitched1.tif\n",
      "Generating 08_stitched1.tif\n",
      "Generating 09_stitched1.tif\n",
      "Generating 10_stitched1.tif\n",
      "Generating 11_stitched1.tif\n",
      "Generating 12_stitched1.tif\n",
      "Generating 13_stitched1.tif\n",
      "Generating 14_stitched1.tif\n",
      "Generating 15_stitched1.tif\n",
      "Generating 16_stitched1.tif\n",
      "Generating 17_stitched1.tif\n",
      "Generating 18_stitched1.tif\n",
      "Generating 19_stitched1.tif\n",
      "Generating 20_stitched1.tif\n",
      "Generating 21_stitched1.tif\n",
      "Generating 22_stitched1.tif\n",
      "Generating 23_stitched1.tif\n"
     ]
    }
   ],
   "source": [
    "import numpy as np\n",
    "import cv2\n",
    "import pyvips\n",
    "import os\n",
    "imsize = 2000\n",
    "for k in range(23):\n",
    "    filename = '%02d_stitched1.tif' % (k+1)\n",
    "    print('Generating',filename)\n",
    "    allpositions = np.array(list(IdToGrid[k+1].values()))\n",
    "\n",
    "    maxidxs = np.max(allpositions,0)\n",
    "    \n",
    "    bigimg = np.zeros((maxidxs[1]+imsize, (maxidxs[0]+imsize),3),np.uint8)\n",
    "    \n",
    "    sourcedir = 'TUPAC/%02d/' % (k+1)\n",
    "    \n",
    "    for im in IdToGrid[k+1].keys():\n",
    "        image = cv2.imread(sourcedir+im)\n",
    "        bigimg[IdToGrid[k+1][im][1]:(IdToGrid[k+1][im][1]+imsize), \n",
    "               IdToGrid[k+1][im][0]:(IdToGrid[k+1][im][0]+imsize),:] = image\n",
    "    \n",
    "    cv2.imwrite('stitched/nopyr_'+filename, bigimg)\n",
    "\n",
    "    # convert to pyramidal TIFF using VIPS\n",
    "    os.system(f'/usr/bin/vips tiffsave stitched/nopyr_{filename} stitched/{filename} --compression=jpeg --Q=90 --tile --tile-width=256 --tile-height=256 --pyramid')\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Successfully migrated DB to version 3\n"
     ]
    }
   ],
   "source": [
    "from SlideRunner.dataAccess.database import Database\n",
    "DBtupac = Database().open('TUPAC.sqlite')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mitosis @ 1397,980\n",
      "Mitosis @ 1803,911\n",
      "Mitosis @ 1243,1149\n",
      "Mitosis @ 270,1090\n",
      "Mitosis @ 1863,1916\n",
      "Mitosis @ 1350,1169\n",
      "Mitosis @ 714,446\n",
      "Mitosis @ 1629,1757\n",
      "Mitosis @ 1029,1873\n",
      "Mitosis @ 747,1278\n",
      "Mitosis @ 729,776\n",
      "Mitosis @ 1542,242\n",
      "Mitosis @ 1874,1996\n",
      "Mitosis @ 569,260\n",
      "Mitosis @ 225,102\n",
      "Mitosis @ 305,571\n",
      "Mitosis @ 1602,1814\n",
      "Mitosis @ 1573,1294\n",
      "Mitosis @ 1778,1059\n",
      "Mitosis @ 1590,777\n",
      "Mitosis @ 1764,737\n",
      "Mitosis @ 1386,1104\n",
      "Mitosis @ 1177,907\n",
      "Mitosis @ 1615,901\n",
      "Mitosis @ 1451,747\n",
      "Mitosis @ 1952,227\n",
      "Mitosis @ 1228,515\n",
      "Mitosis @ 1795,1057\n",
      "Mitosis @ 981,550\n",
      "Mitosis @ 1051,1360\n",
      "Mitosis @ 284,1235\n",
      "Mitosis @ 1193,565\n",
      "Mitosis @ 670,479\n",
      "Mitosis @ 985,252\n",
      "Mitosis @ 1783,318\n",
      "Mitosis @ 994,1745\n",
      "Mitosis @ 1325,275\n",
      "Mitosis @ 1636,532\n",
      "Mitosis @ 1725,1262\n",
      "Mitosis @ 1582,842\n",
      "Mitosis @ 1884,847\n",
      "Mitosis @ 321,1176\n",
      "Mitosis @ 478,1620\n",
      "Mitosis @ 289,155\n",
      "Mitosis @ 1662,1918\n",
      "Mitosis @ 1580,273\n",
      "Mitosis @ 1044,324\n",
      "Mitosis @ 535,297\n",
      "Mitosis @ 512,207\n",
      "Mitosis @ 555,1117\n",
      "Mitosis @ 1733,469\n",
      "Mitosis @ 1301,108\n",
      "Mitosis @ 94,1757\n",
      "Mitosis @ 212,1979\n",
      "Mitosis @ 794,493\n",
      "Mitosis @ 516,920\n",
      "Mitosis @ 1118,1518\n",
      "Mitosis @ 1290,1245\n",
      "Mitosis @ 646,98\n",
      "Mitosis @ 495,239\n",
      "Mitosis @ 174,1193\n",
      "Mitosis @ 1259,285\n",
      "Mitosis @ 1458,1554\n",
      "Mitosis @ 853,1278\n",
      "Mitosis @ 1709,1542\n",
      "Mitosis @ 1128,1064\n",
      "Mitosis @ 714,1790\n",
      "Mitosis @ 288,1709\n",
      "Mitosis @ 223,505\n",
      "Mitosis @ 1420,505\n",
      "Mitosis @ 1735,680\n",
      "Mitosis @ 1920,1877\n",
      "Mitosis @ 921,473\n",
      "Mitosis @ 956,1733\n",
      "Mitosis @ 647,213\n",
      "Mitosis @ 1169,1536\n",
      "Mitosis @ 1419,821\n",
      "Mitosis @ 296,806\n",
      "Mitosis @ 1706,710\n",
      "Mitosis @ 112,1382\n",
      "Mitosis @ 1362,1231\n",
      "Mitosis @ 1299,387\n",
      "Mitosis @ 1982,760\n",
      "Mitosis @ 629,921\n",
      "Mitosis @ 1394,1853\n",
      "Mitosis @ 1169,96\n",
      "Mitosis @ 567,648\n",
      "Mitosis @ 1764,1244\n",
      "Mitosis @ 450,1753\n",
      "Mitosis @ 1237,1191\n",
      "Mitosis @ 914,824\n",
      "Mitosis @ 104,351\n",
      "Mitosis @ 1079,1569\n",
      "Mitosis @ 799,1456\n",
      "Mitosis @ 131,1791\n",
      "Mitosis @ 1148,1813\n",
      "Mitosis @ 1468,1300\n",
      "Mitosis @ 905,869\n",
      "Mitosis @ 1407,381\n",
      "Mitosis @ 1171,88\n",
      "Mitosis @ 1421,1236\n",
      "Mitosis @ 965,713\n",
      "Mitosis @ 421,134\n",
      "Mitosis @ 234,1464\n",
      "Mitosis @ 992,1735\n",
      "Mitosis @ 1133,960\n",
      "Mitosis @ 1214,454\n",
      "Mitosis @ 1404,1393\n",
      "Mitosis @ 1029,1475\n",
      "Mitosis @ 1357,1150\n",
      "Mitosis @ 1252,121\n",
      "Mitosis @ 1515,242\n",
      "Mitosis @ 595,233\n",
      "Mitosis @ 787,797\n",
      "Mitosis @ 1803,879\n",
      "Mitosis @ 526,1544\n",
      "Mitosis @ 1120,588\n",
      "Mitosis @ 1918,450\n",
      "Mitosis @ 379,1010\n",
      "Mitosis @ 1399,779\n",
      "Mitosis @ 161,1615\n",
      "Mitosis @ 98,616\n",
      "Mitosis @ 1673,610\n",
      "Mitosis @ 96,54\n",
      "Mitosis @ 666,1615\n",
      "Mitosis @ 1920,191\n",
      "Mitosis @ 1634,109\n",
      "Mitosis @ 1113,288\n",
      "Mitosis @ 36,1848\n",
      "Mitosis @ 946,607\n",
      "Mitosis @ 368,315\n",
      "Mitosis @ 1071,908\n",
      "Mitosis @ 988,1586\n",
      "Mitosis @ 1909,460\n",
      "Mitosis @ 197,365\n",
      "Mitosis @ 27,934\n",
      "Mitosis @ 1297,315\n",
      "Mitosis @ 1513,61\n",
      "Mitosis @ 1135,1415\n",
      "Mitosis @ 401,1286\n",
      "Mitosis @ 721,393\n",
      "Mitosis @ 1044,41\n",
      "Mitosis @ 376,435\n",
      "Mitosis @ 1751,1788\n",
      "Mitosis @ 1484,1349\n",
      "Mitosis @ 606,776\n",
      "Mitosis @ 1704,1236\n",
      "Mitosis @ 1227,248\n",
      "Mitosis @ 511,563\n",
      "Mitosis @ 429,1797\n",
      "Mitosis @ 1535,1574\n",
      "Mitosis @ 1904,769\n",
      "Mitosis @ 1494,1408\n",
      "Mitosis @ 418,582\n",
      "Mitosis @ 905,727\n",
      "Mitosis @ 459,232\n",
      "Mitosis @ 39,1401\n",
      "Mitosis @ 43,333\n",
      "Mitosis @ 276,475\n",
      "Mitosis @ 1147,195\n",
      "Mitosis @ 791,1192\n",
      "Mitosis @ 794,20\n",
      "Mitosis @ 1559,1036\n",
      "Mitosis @ 19,754\n",
      "Mitosis @ 1004,688\n",
      "Mitosis @ 1752,1994\n",
      "Mitosis @ 1379,1101\n",
      "Mitosis @ 1421,1363\n",
      "Mitosis @ 1037,1577\n",
      "Mitosis @ 344,1974\n",
      "Mitosis @ 396,1662\n",
      "Mitosis @ 485,1438\n",
      "Mitosis @ 1388,1671\n",
      "Mitosis @ 1757,1372\n",
      "Mitosis @ 1330,395\n",
      "Mitosis @ 230,125\n",
      "Mitosis @ 1247,1625\n",
      "Mitosis @ 1305,1640\n",
      "Mitosis @ 998,1713\n",
      "Mitosis @ 143,827\n",
      "Mitosis @ 1568,127\n",
      "Mitosis @ 1539,1627\n",
      "Mitosis @ 935,1803\n",
      "Mitosis @ 1089,1520\n",
      "Mitosis @ 123,233\n",
      "Mitosis @ 223,1820\n",
      "Mitosis @ 226,1056\n",
      "Mitosis @ 538,840\n",
      "Mitosis @ 1440,1731\n",
      "Mitosis @ 96,227\n",
      "Mitosis @ 1628,1984\n",
      "Mitosis @ 722,28\n",
      "Mitosis @ 503,107\n",
      "Mitosis @ 1324,637\n",
      "Mitosis @ 921,1990\n",
      "Mitosis @ 1729,740\n",
      "Mitosis @ 207,698\n",
      "Mitosis @ 1571,1103\n",
      "Mitosis @ 1826,1006\n",
      "Mitosis @ 1427,1663\n",
      "Mitosis @ 1270,1627\n",
      "Mitosis @ 1241,1675\n",
      "Mitosis @ 1572,34\n",
      "Mitosis @ 19,1570\n",
      "Mitosis @ 264,1286\n",
      "Mitosis @ 302,1482\n",
      "Mitosis @ 1094,1297\n",
      "Mitosis @ 1149,1132\n",
      "Mitosis @ 819,282\n",
      "Mitosis @ 1433,1566\n",
      "Mitosis @ 301,115\n",
      "Mitosis @ 216,1349\n",
      "Mitosis @ 1062,1315\n",
      "Mitosis @ 1238,816\n",
      "Mitosis @ 304,17\n",
      "Mitosis @ 1327,252\n",
      "Mitosis @ 1803,723\n",
      "Mitosis @ 1950,843\n",
      "Mitosis @ 1619,753\n",
      "Mitosis @ 1060,16\n",
      "Mitosis @ 1069,350\n",
      "Mitosis @ 455,1837\n",
      "Mitosis @ 99,635\n",
      "Mitosis @ 831,537\n",
      "Mitosis @ 442,408\n",
      "Mitosis @ 1194,456\n",
      "Mitosis @ 1991,1348\n",
      "Mitosis @ 1497,1400\n",
      "Mitosis @ 369,1753\n",
      "Mitosis @ 978,1935\n",
      "Mitosis @ 1807,634\n",
      "Mitosis @ 1489,1444\n",
      "Mitosis @ 72,1252\n",
      "Mitosis @ 152,673\n",
      "Mitosis @ 222,4\n",
      "Mitosis @ 1341,1713\n",
      "Mitosis @ 1126,1935\n",
      "Mitosis @ 1854,160\n",
      "Mitosis @ 1051,675\n",
      "Mitosis @ 1674,1231\n",
      "Mitosis @ 973,1145\n",
      "Mitosis @ 11,1266\n",
      "Mitosis @ 1313,160\n",
      "Mitosis @ 1577,562\n",
      "Mitosis @ 577,133\n",
      "Mitosis @ 830,670\n",
      "Mitosis @ 27,938\n",
      "Mitosis @ 1283,1352\n",
      "Mitosis @ 1380,1125\n",
      "Mitosis @ 1326,1941\n",
      "Mitosis @ 1084,164\n",
      "Mitosis @ 1082,934\n",
      "Mitosis @ 96,1821\n",
      "Mitosis @ 917,535\n",
      "Mitosis @ 1279,435\n",
      "Mitosis @ 923,1405\n",
      "Mitosis @ 959,865\n",
      "Mitosis @ 856,1296\n",
      "Mitosis @ 1463,1113\n",
      "Mitosis @ 1633,1981\n",
      "Mitosis @ 1818,1724\n",
      "Mitosis @ 1091,764\n",
      "Mitosis @ 379,354\n",
      "Mitosis @ 1019,93\n",
      "Mitosis @ 869,1931\n",
      "Mitosis @ 1538,1822\n",
      "Mitosis @ 259,171\n",
      "Mitosis @ 1742,1383\n",
      "Mitosis @ 324,1311\n",
      "Mitosis @ 1455,235\n",
      "Mitosis @ 1169,1375\n",
      "Mitosis @ 748,1036\n",
      "Mitosis @ 65,1836\n",
      "Mitosis @ 1423,1256\n",
      "Mitosis @ 1453,1749\n",
      "Mitosis @ 1321,1597\n",
      "Mitosis @ 1811,991\n",
      "Mitosis @ 1784,348\n",
      "Mitosis @ 88,107\n",
      "Mitosis @ 301,1474\n",
      "Mitosis @ 889,651\n",
      "Mitosis @ 1055,231\n",
      "Mitosis @ 1561,576\n",
      "Mitosis @ 1327,1064\n",
      "Mitosis @ 1252,1952\n",
      "Mitosis @ 1697,1813\n",
      "Mitosis @ 1775,1550\n",
      "Mitosis @ 1424,475\n",
      "Mitosis @ 1221,1768\n",
      "Mitosis @ 511,1053\n",
      "Mitosis @ 1966,330\n",
      "Mitosis @ 1089,227\n",
      "Mitosis @ 801,1881\n",
      "Mitosis @ 501,1858\n",
      "Mitosis @ 610,60\n",
      "Mitosis @ 36,749\n",
      "Mitosis @ 854,1703\n",
      "Mitosis @ 302,1967\n",
      "Mitosis @ 1585,413\n",
      "Mitosis @ 1539,108\n",
      "Mitosis @ 2,1099\n",
      "Mitosis @ 1874,261\n",
      "Mitosis @ 163,1076\n",
      "Mitosis @ 1737,1284\n",
      "Mitosis @ 1319,506\n",
      "Mitosis @ 798,1571\n",
      "Mitosis @ 367,809\n",
      "Mitosis @ 1216,819\n",
      "Mitosis @ 1433,1085\n",
      "Mitosis @ 1145,1899\n",
      "Mitosis @ 1574,1982\n",
      "Mitosis @ 1453,1448\n",
      "Mitosis @ 1098,1409\n",
      "Mitosis @ 390,1275\n",
      "Mitosis @ 1577,211\n",
      "Mitosis @ 728,1871\n",
      "Mitosis @ 314,1987\n",
      "Mitosis @ 1316,1797\n",
      "Mitosis @ 1074,1848\n",
      "Mitosis @ 1730,1594\n",
      "Mitosis @ 1033,230\n",
      "Mitosis @ 1522,529\n",
      "Mitosis @ 1626,207\n",
      "Mitosis @ 1155,460\n",
      "Mitosis @ 1062,1734\n",
      "Mitosis @ 1417,253\n",
      "Mitosis @ 1858,1988\n",
      "Mitosis @ 664,476\n",
      "Mitosis @ 827,1405\n",
      "Mitosis @ 473,1131\n",
      "Mitosis @ 1152,1441\n",
      "Mitosis @ 998,1834\n",
      "Mitosis @ 640,1963\n",
      "Mitosis @ 1362,1874\n",
      "Mitosis @ 1638,1801\n",
      "Mitosis @ 1510,546\n",
      "Mitosis @ 567,1197\n",
      "Mitosis @ 347,1889\n",
      "Mitosis @ 1032,1709\n",
      "Mitosis @ 617,1047\n",
      "Mitosis @ 1807,1564\n",
      "Mitosis @ 49,1037\n",
      "Mitosis @ 246,709\n",
      "Mitosis @ 407,423\n",
      "Mitosis @ 1675,410\n",
      "Mitosis @ 320,1248\n",
      "Mitosis @ 1931,929\n",
      "Mitosis @ 1758,356\n",
      "Mitosis @ 99,1394\n",
      "Mitosis @ 49,1557\n",
      "Mitosis @ 1049,366\n",
      "Mitosis @ 969,339\n",
      "Mitosis @ 1331,1794\n",
      "Mitosis @ 1823,1812\n",
      "Mitosis @ 1709,1480\n",
      "Mitosis @ 819,988\n",
      "Mitosis @ 1019,1331\n",
      "Mitosis @ 1914,773\n",
      "Mitosis @ 572,159\n",
      "Mitosis @ 742,66\n",
      "Mitosis @ 58,1896\n",
      "Mitosis @ 1311,474\n",
      "Mitosis @ 731,724\n",
      "Mitosis @ 1528,31\n",
      "Mitosis @ 244,826\n",
      "Mitosis @ 883,1146\n",
      "Mitosis @ 1811,767\n",
      "Mitosis @ 237,1780\n",
      "Mitosis @ 1430,531\n",
      "Mitosis @ 151,1879\n",
      "Mitosis @ 1332,512\n",
      "Mitosis @ 1255,846\n",
      "Mitosis @ 905,858\n",
      "Mitosis @ 216,716\n",
      "Mitosis @ 540,484\n",
      "Mitosis @ 794,987\n",
      "Mitosis @ 780,1597\n",
      "Mitosis @ 891,1606\n",
      "Mitosis @ 1020,1876\n",
      "Mitosis @ 80,528\n",
      "Mitosis @ 116,607\n",
      "Mitosis @ 210,580\n",
      "Mitosis @ 600,563\n",
      "Mitosis @ 911,1713\n",
      "Mitosis @ 1312,405\n",
      "Mitosis @ 859,1004\n",
      "Mitosis @ 1041,696\n",
      "Mitosis @ 963,26\n",
      "Mitosis @ 1149,298\n",
      "Mitosis @ 54,682\n",
      "Mitosis @ 1442,420\n",
      "Mitosis @ 338,1569\n",
      "Mitosis @ 1378,125\n",
      "Mitosis @ 821,414\n",
      "Mitosis @ 343,1707\n",
      "Mitosis @ 1232,1422\n",
      "Mitosis @ 698,1082\n",
      "Mitosis @ 1041,564\n",
      "Mitosis @ 1886,916\n",
      "Mitosis @ 1855,1183\n",
      "Mitosis @ 1135,1464\n",
      "Mitosis @ 350,1370\n",
      "Mitosis @ 510,1471\n",
      "Mitosis @ 1264,224\n",
      "Mitosis @ 1983,999\n",
      "Mitosis @ 1175,1460\n",
      "Mitosis @ 1061,1800\n",
      "Mitosis @ 343,876\n",
      "Mitosis @ 1677,1515\n",
      "Mitosis @ 1170,435\n",
      "Mitosis @ 1846,76\n",
      "Mitosis @ 1837,1081\n",
      "Mitosis @ 1158,885\n",
      "Mitosis @ 1660,584\n",
      "Mitosis @ 1431,640\n",
      "Mitosis @ 1815,733\n",
      "Mitosis @ 859,216\n",
      "Mitosis @ 1803,395\n",
      "Mitosis @ 454,1337\n",
      "Mitosis @ 1017,288\n",
      "Mitosis @ 29,1410\n",
      "Mitosis @ 507,1457\n",
      "Mitosis @ 1517,1528\n",
      "Mitosis @ 936,1845\n",
      "Mitosis @ 153,483\n",
      "Mitosis @ 1487,1175\n",
      "Mitosis @ 1082,903\n",
      "Mitosis @ 358,1787\n",
      "Mitosis @ 838,960\n",
      "Mitosis @ 1806,790\n",
      "Mitosis @ 511,498\n",
      "Mitosis @ 1886,135\n",
      "Mitosis @ 870,1638\n",
      "Mitosis @ 1098,1970\n",
      "Mitosis @ 1981,1299\n",
      "Mitosis @ 1567,1068\n",
      "Mitosis @ 1452,369\n",
      "Mitosis @ 842,1302\n",
      "Mitosis @ 359,175\n",
      "Mitosis @ 1092,713\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mitosis @ 544,1525\n",
      "Mitosis @ 171,1566\n",
      "Mitosis @ 150,1750\n",
      "Mitosis @ 19,1811\n",
      "Mitosis @ 1594,781\n",
      "Mitosis @ 1635,1059\n",
      "Mitosis @ 1880,1480\n",
      "Mitosis @ 334,790\n",
      "Mitosis @ 794,1664\n",
      "Mitosis @ 1543,681\n",
      "Mitosis @ 537,1750\n",
      "Mitosis @ 1788,951\n",
      "Mitosis @ 51,297\n",
      "Mitosis @ 1609,825\n",
      "Mitosis @ 278,1688\n",
      "Mitosis @ 60,962\n",
      "Mitosis @ 190,1525\n",
      "Mitosis @ 1766,146\n",
      "Mitosis @ 264,1006\n",
      "Mitosis @ 1181,23\n",
      "Mitosis @ 1600,1469\n",
      "Mitosis @ 152,1437\n",
      "Mitosis @ 942,1208\n",
      "Mitosis @ 1176,1957\n",
      "Mitosis @ 1236,35\n",
      "Mitosis @ 597,538\n",
      "Mitosis @ 255,118\n",
      "Mitosis @ 737,66\n",
      "Mitosis @ 1027,275\n",
      "Mitosis @ 223,1626\n",
      "Mitosis @ 975,920\n",
      "Mitosis @ 1519,937\n",
      "Mitosis @ 1499,1329\n",
      "Mitosis @ 1758,99\n",
      "Mitosis @ 1831,522\n",
      "Mitosis @ 1708,1162\n",
      "Mitosis @ 898,1592\n",
      "Mitosis @ 1289,1571\n",
      "Mitosis @ 1786,1527\n",
      "Mitosis @ 1082,104\n",
      "Mitosis @ 693,928\n",
      "Mitosis @ 1500,1136\n",
      "Mitosis @ 1684,593\n",
      "Mitosis @ 187,1822\n",
      "Mitosis @ 1166,477\n",
      "Mitosis @ 919,687\n",
      "Mitosis @ 32,1349\n",
      "Mitosis @ 1745,1448\n",
      "Mitosis @ 1533,1759\n",
      "Mitosis @ 1406,448\n",
      "Mitosis @ 1655,658\n",
      "Mitosis @ 480,1990\n",
      "Mitosis @ 1288,1338\n",
      "Mitosis @ 1765,1405\n",
      "Mitosis @ 401,1622\n",
      "Mitosis @ 190,1863\n",
      "Mitosis @ 1435,22\n",
      "Mitosis @ 739,1012\n",
      "Mitosis @ 439,1796\n",
      "Mitosis @ 1529,1955\n",
      "Mitosis @ 162,1834\n",
      "Mitosis @ 576,1333\n",
      "Mitosis @ 1657,1347\n",
      "Mitosis @ 277,66\n",
      "Mitosis @ 839,407\n",
      "Mitosis @ 274,135\n",
      "Mitosis @ 1276,473\n",
      "Mitosis @ 1657,815\n",
      "Mitosis @ 873,375\n",
      "Mitosis @ 95,902\n",
      "Mitosis @ 314,118\n",
      "Mitosis @ 1539,464\n",
      "Mitosis @ 1891,1754\n",
      "Mitosis @ 290,487\n",
      "Mitosis @ 787,914\n",
      "Mitosis @ 595,558\n",
      "Mitosis @ 904,1086\n",
      "Mitosis @ 1818,289\n",
      "Mitosis @ 36,1310\n",
      "Mitosis @ 748,1785\n",
      "Mitosis @ 372,355\n",
      "Mitosis @ 1039,629\n",
      "Mitosis @ 1641,1051\n",
      "Mitosis @ 503,1702\n",
      "Mitosis @ 1396,165\n",
      "Mitosis @ 291,1400\n",
      "Mitosis @ 1054,563\n",
      "Mitosis @ 61,1894\n",
      "Mitosis @ 1044,205\n",
      "Mitosis @ 1735,167\n",
      "Mitosis @ 413,1292\n",
      "Mitosis @ 62,1494\n",
      "Mitosis @ 771,505\n",
      "Mitosis @ 246,1147\n",
      "Mitosis @ 1841,223\n",
      "Mitosis @ 1579,445\n",
      "Mitosis @ 1641,946\n",
      "Mitosis @ 872,1900\n",
      "Mitosis @ 199,249\n",
      "Mitosis @ 1931,946\n",
      "Mitosis @ 1838,544\n",
      "Mitosis @ 1904,1351\n",
      "Mitosis @ 1543,1325\n",
      "Mitosis @ 531,1326\n",
      "Mitosis @ 1950,1261\n",
      "Mitosis @ 1782,70\n",
      "Mitosis @ 764,1817\n",
      "Mitosis @ 1362,1293\n",
      "Mitosis @ 332,903\n",
      "Mitosis @ 366,1020\n",
      "Mitosis @ 1230,1168\n",
      "Mitosis @ 312,286\n",
      "Mitosis @ 1429,433\n",
      "Mitosis @ 1290,752\n",
      "Mitosis @ 819,1092\n",
      "Mitosis @ 1548,1674\n",
      "Mitosis @ 1186,481\n",
      "Mitosis @ 442,1057\n",
      "Mitosis @ 1693,365\n",
      "Mitosis @ 138,877\n",
      "Mitosis @ 1920,1761\n",
      "Mitosis @ 1202,612\n",
      "Mitosis @ 734,1418\n",
      "Mitosis @ 279,1228\n",
      "Mitosis @ 1656,125\n",
      "Mitosis @ 118,972\n",
      "Mitosis @ 1354,777\n",
      "Mitosis @ 1075,1822\n",
      "Mitosis @ 888,465\n",
      "Mitosis @ 267,766\n",
      "Mitosis @ 1380,58\n",
      "Mitosis @ 1068,568\n",
      "Mitosis @ 808,1657\n",
      "Mitosis @ 614,498\n",
      "Mitosis @ 1561,1551\n",
      "Mitosis @ 514,1322\n",
      "Mitosis @ 113,293\n",
      "Mitosis @ 941,1421\n",
      "Mitosis @ 1572,1410\n",
      "Mitosis @ 593,357\n",
      "Mitosis @ 1209,1757\n",
      "Mitosis @ 573,825\n",
      "Mitosis @ 1502,1326\n",
      "Mitosis @ 1437,1987\n",
      "Mitosis @ 120,646\n",
      "Mitosis @ 227,632\n",
      "Mitosis @ 600,1306\n",
      "Mitosis @ 1115,1359\n",
      "Mitosis @ 1256,1128\n",
      "Mitosis @ 979,40\n",
      "Mitosis @ 231,1635\n",
      "Mitosis @ 152,1826\n",
      "Mitosis @ 779,1063\n",
      "Mitosis @ 1809,967\n",
      "Mitosis @ 1126,1640\n",
      "Mitosis @ 1962,1606\n",
      "Mitosis @ 1365,1632\n",
      "Mitosis @ 916,1565\n",
      "Mitosis @ 1976,239\n",
      "Mitosis @ 939,1886\n",
      "Mitosis @ 1638,1270\n",
      "Mitosis @ 761,1328\n",
      "Mitosis @ 562,565\n",
      "Mitosis @ 1816,1510\n",
      "Mitosis @ 1035,368\n",
      "Mitosis @ 1237,1499\n",
      "Mitosis @ 412,440\n",
      "Mitosis @ 559,1082\n",
      "Mitosis @ 1926,849\n",
      "Mitosis @ 1117,295\n",
      "Mitosis @ 1844,809\n",
      "Mitosis @ 1819,437\n",
      "Mitosis @ 1689,912\n",
      "Mitosis @ 955,1612\n",
      "Mitosis @ 53,946\n",
      "Mitosis @ 1007,1515\n",
      "Mitosis @ 1046,1320\n",
      "Mitosis @ 1202,895\n",
      "Mitosis @ 828,56\n",
      "Mitosis @ 501,568\n",
      "Mitosis @ 1607,1978\n",
      "Mitosis @ 396,655\n",
      "Mitosis @ 413,40\n",
      "Mitosis @ 656,350\n",
      "Mitosis @ 1182,614\n",
      "Mitosis @ 1606,1789\n",
      "Mitosis @ 1881,238\n",
      "Mitosis @ 597,1022\n",
      "Mitosis @ 653,176\n",
      "Mitosis @ 1644,1245\n",
      "Mitosis @ 1425,1499\n",
      "Mitosis @ 1360,1693\n",
      "Mitosis @ 1869,633\n",
      "Mitosis @ 1503,524\n",
      "Mitosis @ 435,860\n",
      "Mitosis @ 746,1067\n",
      "Mitosis @ 526,1764\n",
      "Mitosis @ 346,1635\n",
      "Mitosis @ 581,429\n",
      "Mitosis @ 1429,833\n",
      "Mitosis @ 1314,1019\n",
      "Mitosis @ 990,1342\n",
      "Mitosis @ 1685,1674\n",
      "Mitosis @ 262,276\n",
      "Mitosis @ 315,1097\n",
      "Mitosis @ 340,1741\n",
      "Mitosis @ 955,512\n",
      "Mitosis @ 1007,1605\n",
      "Mitosis @ 320,770\n",
      "Mitosis @ 1079,441\n",
      "Mitosis @ 2000,1685\n",
      "Mitosis @ 1107,720\n",
      "Mitosis @ 925,614\n",
      "Mitosis @ 134,1776\n",
      "Mitosis @ 598,1164\n",
      "Mitosis @ 1052,514\n",
      "Mitosis @ 1166,1692\n",
      "Mitosis @ 213,1632\n",
      "Mitosis @ 159,1498\n",
      "Mitosis @ 1764,1394\n",
      "Mitosis @ 363,619\n",
      "Mitosis @ 171,673\n",
      "Mitosis @ 1122,1433\n",
      "Mitosis @ 1775,1948\n",
      "Mitosis @ 869,1250\n",
      "Mitosis @ 1350,682\n",
      "Mitosis @ 1110,1980\n",
      "Mitosis @ 1732,1199\n",
      "Mitosis @ 1412,361\n",
      "Mitosis @ 1719,1765\n",
      "Mitosis @ 719,113\n",
      "Mitosis @ 1672,1543\n",
      "Mitosis @ 1639,94\n",
      "Mitosis @ 1829,1077\n",
      "Mitosis @ 1644,1483\n",
      "Mitosis @ 407,421\n",
      "Mitosis @ 1795,1982\n",
      "Mitosis @ 198,922\n",
      "Mitosis @ 171,218\n",
      "Mitosis @ 201,546\n",
      "Mitosis @ 1242,1594\n",
      "Mitosis @ 1731,1391\n",
      "Mitosis @ 45,507\n",
      "Mitosis @ 230,530\n",
      "Mitosis @ 96,521\n",
      "Mitosis @ 172,1734\n",
      "Mitosis @ 1384,1344\n",
      "Mitosis @ 525,57\n",
      "Mitosis @ 1067,738\n",
      "Mitosis @ 496,667\n",
      "Mitosis @ 464,736\n",
      "Mitosis @ 799,1002\n",
      "Mitosis @ 1635,630\n",
      "Mitosis @ 1017,615\n",
      "Mitosis @ 1256,1570\n",
      "Mitosis @ 297,856\n",
      "Mitosis @ 185,1675\n",
      "Mitosis @ 1691,1148\n",
      "Mitosis @ 1962,737\n",
      "Mitosis @ 494,1583\n",
      "Mitosis @ 696,1510\n",
      "Mitosis @ 897,1817\n",
      "Mitosis @ 662,91\n",
      "Mitosis @ 1893,1226\n",
      "Mitosis @ 506,1984\n",
      "Mitosis @ 704,1730\n",
      "Mitosis @ 1666,986\n",
      "Mitosis @ 276,803\n",
      "Mitosis @ 745,1077\n",
      "Mitosis @ 613,690\n",
      "Mitosis @ 107,609\n",
      "Mitosis @ 245,1097\n",
      "Mitosis @ 908,976\n",
      "Mitosis @ 509,241\n",
      "Mitosis @ 1586,1715\n",
      "Mitosis @ 1266,990\n",
      "Mitosis @ 1597,1099\n",
      "Mitosis @ 844,1128\n",
      "Mitosis @ 257,1119\n",
      "Mitosis @ 559,888\n",
      "Mitosis @ 1017,1336\n",
      "Mitosis @ 1441,1783\n",
      "Mitosis @ 1301,1779\n",
      "Mitosis @ 1620,276\n",
      "Mitosis @ 117,468\n",
      "Mitosis @ 440,327\n",
      "Mitosis @ 1192,1379\n",
      "Mitosis @ 961,698\n",
      "Mitosis @ 1149,1031\n",
      "Mitosis @ 215,1562\n",
      "Mitosis @ 55,959\n",
      "Mitosis @ 1752,1178\n",
      "Mitosis @ 1650,1411\n",
      "Mitosis @ 1043,1667\n",
      "Mitosis @ 173,354\n",
      "Mitosis @ 290,1761\n",
      "Mitosis @ 7,1780\n",
      "Mitosis @ 830,274\n",
      "Mitosis @ 1163,173\n",
      "Mitosis @ 201,443\n",
      "Mitosis @ 1745,504\n",
      "Mitosis @ 1281,634\n",
      "Mitosis @ 429,1693\n",
      "Mitosis @ 144,749\n",
      "Mitosis @ 447,311\n",
      "Mitosis @ 1593,1251\n",
      "Mitosis @ 740,1588\n",
      "Mitosis @ 1598,1650\n",
      "Mitosis @ 16,1457\n",
      "Mitosis @ 963,169\n",
      "Mitosis @ 792,1061\n",
      "Mitosis @ 430,1575\n",
      "Mitosis @ 1470,766\n",
      "Mitosis @ 131,1917\n",
      "Mitosis @ 1596,330\n",
      "Mitosis @ 1599,1841\n",
      "Mitosis @ 31,1279\n",
      "Mitosis @ 404,1334\n",
      "Mitosis @ 1405,1274\n",
      "Mitosis @ 459,1944\n",
      "Mitosis @ 445,1368\n",
      "Mitosis @ 1726,1679\n",
      "Mitosis @ 120,1792\n",
      "Mitosis @ 309,223\n",
      "Mitosis @ 931,66\n",
      "Mitosis @ 1296,470\n",
      "Mitosis @ 1020,358\n",
      "Mitosis @ 1714,376\n",
      "Mitosis @ 1432,1460\n",
      "Mitosis @ 1422,939\n",
      "Mitosis @ 525,1398\n",
      "Mitosis @ 453,1968\n",
      "Mitosis @ 345,1294\n",
      "Mitosis @ 1333,1868\n",
      "Mitosis @ 1279,1410\n",
      "Mitosis @ 1519,600\n",
      "Mitosis @ 1030,498\n",
      "Mitosis @ 1067,276\n",
      "Mitosis @ 1118,288\n",
      "Mitosis @ 1952,1411\n",
      "Mitosis @ 826,973\n",
      "Mitosis @ 1355,619\n",
      "Mitosis @ 1169,987\n",
      "Mitosis @ 1868,1510\n",
      "Mitosis @ 1878,1977\n",
      "Mitosis @ 1489,599\n",
      "Mitosis @ 48,411\n",
      "Mitosis @ 683,475\n",
      "Mitosis @ 464,1932\n",
      "Mitosis @ 1824,191\n",
      "Mitosis @ 611,1222\n",
      "Mitosis @ 237,1919\n",
      "Mitosis @ 1032,1856\n",
      "Mitosis @ 1245,1595\n",
      "Mitosis @ 1948,354\n",
      "Mitosis @ 1595,990\n",
      "Mitosis @ 802,79\n",
      "Mitosis @ 683,750\n",
      "Mitosis @ 908,623\n",
      "Mitosis @ 842,282\n",
      "Mitosis @ 1541,214\n",
      "Mitosis @ 1939,992\n",
      "Mitosis @ 286,1672\n",
      "Mitosis @ 982,1964\n",
      "Mitosis @ 1454,314\n",
      "Mitosis @ 373,259\n",
      "Mitosis @ 1143,1598\n",
      "Mitosis @ 335,636\n",
      "Mitosis @ 45,652\n",
      "Mitosis @ 1504,1746\n",
      "Mitosis @ 830,743\n",
      "Mitosis @ 493,1718\n",
      "Mitosis @ 1550,304\n",
      "Mitosis @ 810,544\n",
      "Mitosis @ 1079,1934\n",
      "Mitosis @ 554,951\n",
      "Mitosis @ 258,1387\n",
      "Mitosis @ 1825,1425\n",
      "Mitosis @ 1619,393\n",
      "Mitosis @ 836,18\n",
      "Mitosis @ 1307,42\n",
      "Mitosis @ 1277,1768\n",
      "Mitosis @ 1092,1263\n",
      "Mitosis @ 1601,1936\n",
      "Mitosis @ 1152,1507\n",
      "Mitosis @ 1180,1483\n",
      "Mitosis @ 1661,1159\n",
      "Mitosis @ 554,1025\n",
      "Mitosis @ 598,1013\n",
      "Mitosis @ 657,692\n",
      "Mitosis @ 521,1082\n",
      "Mitosis @ 514,1451\n",
      "Mitosis @ 1257,1382\n",
      "Mitosis @ 1965,1824\n",
      "Mitosis @ 1745,444\n",
      "Mitosis @ 660,1841\n",
      "Mitosis @ 725,72\n",
      "Mitosis @ 1798,1877\n",
      "Mitosis @ 77,893\n",
      "Mitosis @ 340,414\n",
      "Mitosis @ 403,854\n",
      "Mitosis @ 272,1140\n",
      "Mitosis @ 8,771\n",
      "Mitosis @ 316,756\n",
      "Mitosis @ 404,922\n",
      "Mitosis @ 170,110\n",
      "Mitosis @ 1719,462\n",
      "Mitosis @ 1573,701\n",
      "Mitosis @ 1431,1148\n",
      "Mitosis @ 1018,1808\n",
      "Mitosis @ 375,1405\n",
      "Mitosis @ 1591,449\n",
      "Mitosis @ 1384,1711\n",
      "Mitosis @ 1819,207\n",
      "Mitosis @ 28,639\n",
      "Mitosis @ 646,594\n",
      "Mitosis @ 1001,1531\n",
      "Mitosis @ 1217,1676\n",
      "Mitosis @ 1951,1967\n",
      "Mitosis @ 1266,1699\n",
      "Mitosis @ 1162,1551\n",
      "Mitosis @ 1910,1591\n",
      "Mitosis @ 1740,772\n",
      "Mitosis @ 506,294\n",
      "Mitosis @ 1632,602\n",
      "Mitosis @ 116,26\n",
      "Mitosis @ 1517,53\n",
      "Mitosis @ 1193,76\n",
      "Mitosis @ 1117,1503\n",
      "Mitosis @ 1611,863\n",
      "Mitosis @ 959,1401\n",
      "Mitosis @ 117,549\n",
      "Mitosis @ 733,337\n",
      "Mitosis @ 281,76\n",
      "Mitosis @ 1094,1380\n",
      "Mitosis @ 1373,194\n",
      "Mitosis @ 964,300\n",
      "Mitosis @ 750,163\n",
      "Mitosis @ 512,402\n",
      "Mitosis @ 1186,1522\n",
      "Mitosis @ 765,496\n",
      "Mitosis @ 594,524\n",
      "Mitosis @ 653,351\n",
      "Mitosis @ 1266,1826\n",
      "Mitosis @ 1643,1517\n",
      "Mitosis @ 1358,1130\n",
      "Mitosis @ 895,884\n",
      "Mitosis @ 1701,1777\n",
      "Mitosis @ 380,741\n",
      "Mitosis @ 1383,1522\n",
      "Mitosis @ 954,1914\n",
      "Mitosis @ 1419,1611\n",
      "Mitosis @ 1374,611\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mitosis @ 1638,968\n",
      "Mitosis @ 137,57\n",
      "Mitosis @ 1885,288\n",
      "Mitosis @ 1244,1312\n",
      "Mitosis @ 1079,691\n",
      "Mitosis @ 965,1427\n",
      "Mitosis @ 921,1176\n",
      "Mitosis @ 569,840\n",
      "Mitosis @ 781,108\n",
      "Mitosis @ 803,1411\n",
      "Mitosis @ 1462,949\n",
      "Mitosis @ 1159,1564\n",
      "Mitosis @ 797,1692\n",
      "Mitosis @ 1427,1059\n",
      "Mitosis @ 1788,1299\n",
      "Mitosis @ 1738,1734\n",
      "Mitosis @ 25,1222\n",
      "Mitosis @ 717,1181\n",
      "Mitosis @ 1786,180\n",
      "Mitosis @ 1944,1115\n",
      "Mitosis @ 1116,940\n",
      "Mitosis @ 1664,688\n",
      "Mitosis @ 1785,681\n",
      "Mitosis @ 1280,318\n",
      "Mitosis @ 721,1000\n",
      "Mitosis @ 1857,1310\n",
      "Mitosis @ 426,1041\n",
      "Mitosis @ 464,1515\n",
      "Mitosis @ 1959,598\n",
      "Mitosis @ 1418,1781\n",
      "Mitosis @ 1877,394\n",
      "Mitosis @ 1383,1885\n",
      "Mitosis @ 1761,1883\n",
      "Mitosis @ 74,1986\n",
      "Mitosis @ 1734,645\n",
      "Mitosis @ 981,1889\n",
      "Mitosis @ 1006,1377\n",
      "Mitosis @ 1652,1428\n",
      "Mitosis @ 1659,931\n",
      "Mitosis @ 1128,1004\n",
      "Mitosis @ 1396,1118\n",
      "Mitosis @ 905,795\n",
      "Mitosis @ 1445,120\n",
      "Mitosis @ 1077,1447\n",
      "Mitosis @ 141,536\n",
      "Mitosis @ 1003,1645\n",
      "Mitosis @ 1171,1917\n",
      "Mitosis @ 1360,1809\n",
      "Mitosis @ 1932,1758\n",
      "Mitosis @ 993,856\n",
      "Mitosis @ 1571,766\n",
      "Mitosis @ 1626,1362\n",
      "Mitosis @ 52,1233\n",
      "Mitosis @ 221,416\n",
      "Mitosis @ 1699,1713\n",
      "Mitosis @ 121,1953\n",
      "Mitosis @ 161,1705\n",
      "Mitosis @ 830,1232\n",
      "Mitosis @ 395,1246\n",
      "Mitosis @ 1361,95\n",
      "Mitosis @ 1598,289\n",
      "Mitosis @ 1760,1493\n",
      "Mitosis @ 1651,1243\n",
      "Mitosis @ 1167,717\n",
      "Mitosis @ 605,1064\n",
      "Mitosis @ 110,1749\n",
      "Mitosis @ 563,1832\n",
      "Mitosis @ 462,1478\n",
      "Mitosis @ 680,1679\n",
      "Mitosis @ 1892,1559\n",
      "Mitosis @ 1033,1788\n",
      "Mitosis @ 1653,1506\n",
      "Mitosis @ 1633,1558\n",
      "Mitosis @ 1173,1804\n",
      "Mitosis @ 847,1136\n",
      "Mitosis @ 450,386\n",
      "Mitosis @ 49,1121\n",
      "Mitosis @ 1428,694\n",
      "Mitosis @ 1358,722\n",
      "Mitosis @ 1054,1257\n",
      "Mitosis @ 19,1463\n",
      "Mitosis @ 1320,1138\n",
      "Mitosis @ 183,1121\n",
      "Mitosis @ 746,436\n",
      "Mitosis @ 802,525\n",
      "Mitosis @ 1747,673\n",
      "Mitosis @ 122,1817\n",
      "Mitosis @ 732,498\n",
      "Mitosis @ 33,1435\n",
      "Mitosis @ 789,837\n",
      "Mitosis @ 247,1456\n",
      "Mitosis @ 263,215\n",
      "Mitosis @ 864,472\n",
      "Mitosis @ 767,1176\n",
      "Mitosis @ 1121,893\n",
      "Mitosis @ 1688,600\n",
      "Mitosis @ 1342,682\n",
      "Mitosis @ 669,1488\n",
      "Mitosis @ 58,1403\n",
      "Mitosis @ 1740,404\n",
      "Mitosis @ 765,1129\n",
      "Mitosis @ 1128,245\n",
      "Mitosis @ 183,279\n",
      "Mitosis @ 1761,703\n",
      "Mitosis @ 1264,1220\n",
      "Mitosis @ 1774,1881\n",
      "Mitosis @ 928,147\n",
      "Mitosis @ 557,64\n",
      "Mitosis @ 1560,687\n",
      "Mitosis @ 1122,886\n",
      "Mitosis @ 1281,1517\n",
      "Mitosis @ 547,1924\n",
      "Mitosis @ 992,1388\n",
      "Mitosis @ 1429,234\n",
      "Mitosis @ 101,1862\n",
      "Mitosis @ 1702,300\n",
      "Mitosis @ 657,1450\n",
      "Mitosis @ 1417,1282\n",
      "Mitosis @ 1477,1829\n",
      "Mitosis @ 233,1080\n",
      "Mitosis @ 1886,266\n",
      "Mitosis @ 14,1690\n",
      "Mitosis @ 330,413\n",
      "Mitosis @ 992,1376\n",
      "Mitosis @ 182,1402\n",
      "Mitosis @ 719,1830\n",
      "Mitosis @ 1648,495\n",
      "Mitosis @ 1873,1095\n",
      "Mitosis @ 281,451\n",
      "Mitosis @ 1387,232\n",
      "Mitosis @ 162,174\n",
      "Mitosis @ 1070,1350\n",
      "Mitosis @ 970,1064\n",
      "Mitosis @ 1277,681\n",
      "Mitosis @ 669,625\n",
      "Mitosis @ 603,1498\n",
      "Mitosis @ 52,8\n",
      "Mitosis @ 1529,534\n",
      "Mitosis @ 1699,478\n",
      "Mitosis @ 1272,374\n",
      "Mitosis @ 1331,456\n",
      "Mitosis @ 140,1986\n",
      "Mitosis @ 656,1470\n",
      "Mitosis @ 381,739\n",
      "Mitosis @ 1615,1934\n",
      "Mitosis @ 687,687\n",
      "Mitosis @ 471,732\n",
      "Mitosis @ 616,1404\n",
      "Mitosis @ 824,1737\n",
      "Mitosis @ 1592,1501\n",
      "Mitosis @ 923,1597\n",
      "Mitosis @ 1706,46\n",
      "Mitosis @ 513,635\n",
      "Mitosis @ 328,657\n",
      "Mitosis @ 974,1478\n",
      "Mitosis @ 251,1790\n",
      "Mitosis @ 198,1184\n",
      "Mitosis @ 1545,1704\n",
      "Mitosis @ 631,1966\n",
      "Mitosis @ 529,1708\n",
      "Mitosis @ 1410,1261\n",
      "Mitosis @ 1747,1656\n",
      "Mitosis @ 758,336\n",
      "Mitosis @ 1373,954\n",
      "Mitosis @ 1274,1798\n",
      "Mitosis @ 140,1460\n",
      "Mitosis @ 113,186\n",
      "Mitosis @ 1195,1640\n",
      "Mitosis @ 461,1084\n",
      "Mitosis @ 1802,1349\n",
      "Mitosis @ 461,1482\n",
      "Mitosis @ 58,850\n",
      "Mitosis @ 503,363\n",
      "Mitosis @ 1374,192\n",
      "Mitosis @ 230,1746\n",
      "Mitosis @ 1347,109\n",
      "Mitosis @ 572,723\n",
      "Mitosis @ 1659,1874\n",
      "Mitosis @ 1799,1840\n",
      "Mitosis @ 1878,377\n",
      "Mitosis @ 829,856\n",
      "Mitosis @ 1300,308\n",
      "Mitosis @ 45,337\n",
      "Mitosis @ 1203,406\n",
      "Mitosis @ 345,144\n",
      "Mitosis @ 1491,405\n",
      "Mitosis @ 1847,1682\n",
      "Mitosis @ 1372,374\n",
      "Mitosis @ 332,224\n",
      "Mitosis @ 1235,1958\n"
     ]
    }
   ],
   "source": [
    "# Rederive TUPAC database\n",
    "import csv\n",
    "DB=Database().create('TUPAC_stitched.sqlite')\n",
    "DB.insertClass('Mitosis')\n",
    "d = int()\n",
    "DB.insertAnnotator('TUPAC16 stitched')\n",
    "for k in range(23):\n",
    "    d='%02d' % (k+1)\n",
    "    DB.insertNewSlide(d+'_stitched1.tif','stitched/')\n",
    "    suid = DB.findSlideWithFilename(d+'_stitched1.tif', 'stitched/')\n",
    "    \n",
    "    for im in IdToGrid[k+1].keys():\n",
    "        gtannofile = f'TUPAC/mitoses_ground_truth/{d}/{im.replace(\"tif\",\"csv\")}'\n",
    "        if os.path.exists(gtannofile):\n",
    "            with open(gtannofile,'r') as csvfile:\n",
    "                csvf = csv.reader(csvfile, delimiter=',', quotechar='|')\n",
    "                for y,x in csvf:\n",
    "                    print(f'Mitosis @ {x},{y}')\n",
    "                    x = int(x) + IdToGrid[k+1][im][0]\n",
    "                    y = int(y) + IdToGrid[k+1][im][1]\n",
    "                    DB.insertNewSpotAnnotation(xpos_orig=x, ypos_orig=y, classID=1, annotator=1, slideUID=suid)\n",
    "\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mitosis @ 375,5405\n",
      "Mitosis @ 343,4860\n",
      "Mitosis @ 354,4088\n",
      "Mitosis @ 750,2962\n",
      "Mitosis @ 1667,4567\n",
      "Mitosis @ 2188,2951\n",
      "Mitosis @ 2664,806\n",
      "Mitosis @ 4325,472\n",
      "Mitosis @ 1481,1169\n",
      "Mitosis @ 1557,592\n",
      "Mitosis @ 5347,400\n",
      "Mitosis @ 5060,5601\n",
      "Mitosis @ 5447,3437\n",
      "Mitosis @ 3705,1125\n",
      "Mitosis @ 374,2249\n",
      "Mitosis @ 79,2800\n",
      "Mitosis @ 251,1493\n",
      "Mitosis @ 188,2209\n",
      "Mitosis @ 147,3948\n",
      "Mitosis @ 835,3950\n",
      "Mitosis @ 969,3565\n",
      "Mitosis @ 614,3725\n",
      "Mitosis @ 1226,2962\n",
      "Mitosis @ 536,2390\n",
      "Mitosis @ 3545,5524\n",
      "Mitosis @ 3607,5519\n",
      "Mitosis @ 5609,3427\n",
      "Mitosis @ 3098,962\n",
      "Mitosis @ 67,5594\n",
      "Mitosis @ 225,5174\n",
      "Mitosis @ 1757,2003\n",
      "Mitosis @ 2958,1450\n",
      "Mitosis @ 2775,1823\n",
      "Mitosis @ 5449,5549\n",
      "Mitosis @ 866,4590\n",
      "Mitosis @ 2655,4891\n",
      "Mitosis @ 2868,3415\n",
      "Mitosis @ 2944,3265\n",
      "Mitosis @ 3251,2940\n",
      "Mitosis @ 2203,3404\n",
      "Mitosis @ 3212,39\n",
      "Mitosis @ 493,507\n",
      "Mitosis @ 109,603\n",
      "Mitosis @ 1692,5545\n",
      "Mitosis @ 48,2890\n",
      "Mitosis @ 1185,4410\n",
      "Mitosis @ 3060,2287\n",
      "Mitosis @ 4980,3240\n",
      "Mitosis @ 4624,3417\n",
      "Mitosis @ 230,3023\n",
      "Mitosis @ 3740,987\n",
      "Mitosis @ 5441,1851\n",
      "Mitosis @ 207,11\n",
      "Mitosis @ 73,4964\n",
      "Mitosis @ 518,4671\n",
      "Mitosis @ 1055,4063\n",
      "Mitosis @ 4906,47\n",
      "Mitosis @ 1724,3311\n",
      "Mitosis @ 2349,5182\n",
      "Mitosis @ 2333,3830\n",
      "Mitosis @ 3100,3786\n",
      "Mitosis @ 4344,3906\n",
      "Mitosis @ 400,2567\n",
      "Mitosis @ 743,3005\n",
      "Mitosis @ 1221,2391\n",
      "Mitosis @ 1149,4084\n",
      "Mitosis @ 4597,2545\n",
      "Mitosis @ 4507,2593\n",
      "Mitosis @ 3335,1246\n",
      "Mitosis @ 5595,1203\n",
      "Mitosis @ 2903,5610\n",
      "Mitosis @ 3187,1513\n",
      "Mitosis @ 3840,2012\n",
      "Mitosis @ 2049,1069\n",
      "Mitosis @ 125,4565\n",
      "Mitosis @ 301,3666\n",
      "Mitosis @ 1981,1071\n",
      "Mitosis @ 1827,215\n",
      "Mitosis @ 1502,5554\n",
      "Mitosis @ 1674,4743\n",
      "Mitosis @ 2878,4627\n",
      "Mitosis @ 5479,5303\n",
      "Mitosis @ 5479,5259\n",
      "Mitosis @ 5290,1148\n",
      "Mitosis @ 3919,862\n",
      "Mitosis @ 3584,634\n",
      "Mitosis @ 2810,801\n",
      "Mitosis @ 2732,664\n",
      "Mitosis @ 2552,188\n",
      "Mitosis @ 2215,1829\n",
      "Mitosis @ 1341,1679\n",
      "Mitosis @ 1510,1482\n",
      "Mitosis @ 347,180\n",
      "Mitosis @ 2196,199\n",
      "Mitosis @ 1078,5149\n",
      "Mitosis @ 1541,3072\n",
      "Mitosis @ 2930,4640\n",
      "Mitosis @ 5404,2181\n",
      "Mitosis @ 226,4795\n",
      "Mitosis @ 375,4512\n",
      "Mitosis @ 494,4189\n",
      "Mitosis @ 150,3450\n",
      "Mitosis @ 1836,5176\n",
      "Mitosis @ 1466,4758\n",
      "Mitosis @ 1623,4484\n",
      "Mitosis @ 1643,3615\n",
      "Mitosis @ 1626,3348\n",
      "Mitosis @ 1857,3306\n",
      "Mitosis @ 796,2692\n",
      "Mitosis @ 234,2474\n",
      "Mitosis @ 563,1971\n",
      "Mitosis @ 1145,2164\n",
      "Mitosis @ 1759,196\n",
      "Mitosis @ 1320,67\n",
      "Mitosis @ 2192,4685\n",
      "Mitosis @ 2284,3783\n",
      "Mitosis @ 2556,2175\n",
      "Mitosis @ 2338,1919\n",
      "Mitosis @ 3044,871\n",
      "Mitosis @ 3326,1818\n",
      "Mitosis @ 3437,3549\n",
      "Mitosis @ 3603,3208\n",
      "Mitosis @ 3835,2666\n",
      "Mitosis @ 4231,5251\n",
      "Mitosis @ 4517,4640\n",
      "Mitosis @ 4843,5384\n",
      "Mitosis @ 5488,2557\n",
      "Mitosis @ 4155,114\n",
      "Mitosis @ 475,1397\n",
      "Mitosis @ 1372,3901\n",
      "Mitosis @ 3454,5596\n",
      "Mitosis @ 3212,4770\n",
      "Mitosis @ 3640,4293\n",
      "Mitosis @ 3397,118\n",
      "Mitosis @ 4070,846\n",
      "Mitosis @ 4798,4807\n",
      "Mitosis @ 197,1864\n",
      "Mitosis @ 2199,4772\n",
      "Mitosis @ 2018,285\n",
      "Mitosis @ 2251,808\n",
      "Mitosis @ 3637,4720\n",
      "Mitosis @ 5188,5194\n",
      "Mitosis @ 3071,1720\n",
      "Mitosis @ 1936,934\n",
      "Mitosis @ 2384,4831\n",
      "Mitosis @ 5255,5469\n",
      "Mitosis @ 5525,1572\n",
      "Mitosis @ 4660,516\n",
      "Mitosis @ 936,4682\n",
      "Mitosis @ 3140,2539\n",
      "Mitosis @ 2924,2062\n",
      "Mitosis @ 3013,1499\n",
      "Mitosis @ 5403,1833\n",
      "Mitosis @ 2093,2430\n",
      "Mitosis @ 2266,948\n",
      "Mitosis @ 2303,108\n",
      "Mitosis @ 2204,5210\n",
      "Mitosis @ 2842,3900\n",
      "Mitosis @ 3203,3683\n",
      "Mitosis @ 3281,2788\n",
      "Mitosis @ 2977,1205\n",
      "Mitosis @ 3266,5522\n",
      "Mitosis @ 3387,4702\n",
      "Mitosis @ 3673,3981\n",
      "Mitosis @ 3998,4160\n",
      "Mitosis @ 3941,5376\n",
      "Mitosis @ 4437,1162\n",
      "Mitosis @ 3581,617\n",
      "Mitosis @ 4702,5171\n",
      "Mitosis @ 5004,5177\n",
      "Mitosis @ 5046,5148\n",
      "Mitosis @ 4979,5093\n",
      "Mitosis @ 5339,4929\n",
      "Mitosis @ 5412,4312\n",
      "Mitosis @ 4748,4362\n",
      "Mitosis @ 4833,4057\n",
      "Mitosis @ 5274,3689\n",
      "Mitosis @ 5288,3553\n",
      "Mitosis @ 5419,3349\n",
      "Mitosis @ 3697,3021\n",
      "Mitosis @ 2580,5439\n",
      "Mitosis @ 5610,1158\n",
      "Mitosis @ 3182,5423\n",
      "Mitosis @ 4007,2566\n",
      "Mitosis @ 1825,2419\n",
      "Mitosis @ 2223,1948\n",
      "Mitosis @ 3543,99\n",
      "Mitosis @ 3954,5595\n",
      "Mitosis @ 5590,4442\n",
      "Mitosis @ 3416,5122\n",
      "Mitosis @ 3744,4758\n",
      "Mitosis @ 3442,3977\n",
      "Mitosis @ 3847,3541\n",
      "Mitosis @ 4153,4019\n",
      "Mitosis @ 4210,4679\n",
      "Mitosis @ 4492,5061\n",
      "Mitosis @ 3584,2518\n",
      "Mitosis @ 4660,1469\n",
      "Mitosis @ 3729,327\n",
      "Mitosis @ 2594,4447\n",
      "Mitosis @ 231,4515\n",
      "Mitosis @ 944,3571\n",
      "Mitosis @ 1847,1501\n",
      "Mitosis @ 2430,2070\n",
      "Mitosis @ 3487,2017\n",
      "Mitosis @ 3868,1611\n",
      "Mitosis @ 4231,765\n",
      "Mitosis @ 654,1836\n",
      "Mitosis @ 844,3234\n",
      "Mitosis @ 1184,3485\n",
      "Mitosis @ 1299,842\n",
      "Mitosis @ 2131,3891\n",
      "Mitosis @ 2247,4236\n",
      "Mitosis @ 2141,3191\n",
      "Mitosis @ 1797,395\n",
      "Mitosis @ 1737,7\n",
      "Mitosis @ 4069,4603\n",
      "Mitosis @ 4842,4952\n",
      "Mitosis @ 4613,1968\n",
      "Mitosis @ 246,5075\n",
      "Mitosis @ 1451,4888\n",
      "Mitosis @ 147,1552\n",
      "Mitosis @ 430,1457\n",
      "Mitosis @ 2985,4147\n",
      "Mitosis @ 3882,3521\n",
      "Mitosis @ 3466,1047\n",
      "Mitosis @ 5169,4866\n",
      "Mitosis @ 4985,4140\n",
      "Mitosis @ 5626,4476\n",
      "Mitosis @ 2262,2439\n",
      "Mitosis @ 4295,3937\n",
      "Mitosis @ 4205,3217\n",
      "Mitosis @ 740,5015\n",
      "Mitosis @ 754,4933\n",
      "Mitosis @ 297,3749\n",
      "Mitosis @ 951,686\n",
      "Mitosis @ 2605,3216\n",
      "Mitosis @ 2679,3152\n",
      "Mitosis @ 2206,1789\n",
      "Mitosis @ 2264,1441\n",
      "Mitosis @ 1845,1200\n",
      "Mitosis @ 1914,1320\n",
      "Mitosis @ 3322,4432\n",
      "Mitosis @ 3368,3820\n",
      "Mitosis @ 3235,1918\n",
      "Mitosis @ 2691,1403\n",
      "Mitosis @ 2576,886\n",
      "Mitosis @ 4729,1808\n",
      "Mitosis @ 5195,1730\n",
      "Mitosis @ 3978,2377\n",
      "Mitosis @ 4524,1260\n",
      "Mitosis @ 753,5484\n",
      "Mitosis @ 1251,5351\n",
      "Mitosis @ 2235,4896\n",
      "Mitosis @ 3619,4411\n",
      "Mitosis @ 3621,3901\n",
      "Mitosis @ 4276,4466\n",
      "Mitosis @ 4597,4879\n",
      "Mitosis @ 5124,4615\n",
      "Mitosis @ 5391,3801\n",
      "Mitosis @ 556,5026\n",
      "Mitosis @ 849,3743\n",
      "Mitosis @ 944,3196\n",
      "Mitosis @ 1177,3752\n",
      "Mitosis @ 1941,4225\n",
      "Mitosis @ 1956,2386\n",
      "Mitosis @ 2842,1986\n",
      "Mitosis @ 3123,3254\n",
      "Mitosis @ 3607,3972\n",
      "Mitosis @ 3844,4022\n",
      "Mitosis @ 3822,3782\n",
      "Mitosis @ 2259,874\n",
      "Mitosis @ 3837,72\n",
      "Mitosis @ 4092,1201\n",
      "Mitosis @ 4480,1280\n",
      "Mitosis @ 4276,2123\n",
      "Mitosis @ 5161,3500\n",
      "Mitosis @ 4942,3361\n",
      "Mitosis @ 3137,417\n",
      "Mitosis @ 2111,2051\n",
      "Mitosis @ 3580,4715\n",
      "Mitosis @ 5418,1914\n",
      "Mitosis @ 331,3700\n",
      "Mitosis @ 521,3577\n",
      "Mitosis @ 410,2856\n",
      "Mitosis @ 624,2817\n",
      "Mitosis @ 516,2628\n",
      "Mitosis @ 281,2455\n",
      "Mitosis @ 245,1455\n",
      "Mitosis @ 136,660\n",
      "Mitosis @ 270,562\n",
      "Mitosis @ 922,2691\n",
      "Mitosis @ 1336,2280\n",
      "Mitosis @ 1467,2572\n",
      "Mitosis @ 1449,3629\n",
      "Mitosis @ 1675,3529\n",
      "Mitosis @ 2119,3360\n",
      "Mitosis @ 1943,2693\n",
      "Mitosis @ 2282,2765\n",
      "Mitosis @ 2314,2388\n",
      "Mitosis @ 2651,2548\n",
      "Mitosis @ 2968,3352\n",
      "Mitosis @ 2992,3307\n",
      "Mitosis @ 3128,2914\n",
      "Mitosis @ 3308,2125\n",
      "Mitosis @ 3292,1696\n",
      "Mitosis @ 3096,1658\n",
      "Mitosis @ 3158,1475\n",
      "Mitosis @ 3182,1395\n",
      "Mitosis @ 3207,1347\n",
      "Mitosis @ 3617,1860\n",
      "Mitosis @ 3686,1981\n",
      "Mitosis @ 3677,3122\n",
      "Mitosis @ 4307,1522\n",
      "Mitosis @ 4502,3197\n",
      "Mitosis @ 4683,3351\n",
      "Mitosis @ 1303,4319\n",
      "Mitosis @ 1676,4564\n",
      "Mitosis @ 3405,4665\n",
      "Mitosis @ 4255,5523\n",
      "Mitosis @ 4596,5357\n",
      "Mitosis @ 4805,5497\n",
      "Mitosis @ 5119,4991\n",
      "Mitosis @ 5033,2844\n",
      "Mitosis @ 5303,2440\n",
      "Mitosis @ 5197,2042\n",
      "Mitosis @ 5021,1580\n",
      "Mitosis @ 4586,1952\n",
      "Mitosis @ 5316,794\n",
      "Mitosis @ 4555,279\n",
      "Mitosis @ 4456,139\n",
      "Mitosis @ 4320,340\n",
      "Mitosis @ 4271,259\n",
      "Mitosis @ 4001,62\n",
      "Mitosis @ 3906,129\n",
      "Mitosis @ 2096,1021\n",
      "Mitosis @ 1968,801\n",
      "Mitosis @ 1919,733\n",
      "Mitosis @ 3438,2374\n",
      "Mitosis @ 1626,1393\n",
      "Mitosis @ 1072,719\n",
      "Mitosis @ 3279,688\n",
      "Mitosis @ 4010,121\n",
      "Mitosis @ 5074,3460\n",
      "Mitosis @ 5079,3278\n",
      "Mitosis @ 315,5471\n",
      "Mitosis @ 1318,4221\n",
      "Mitosis @ 1501,4347\n",
      "Mitosis @ 355,3722\n",
      "Mitosis @ 421,1533\n",
      "Mitosis @ 337,1577\n",
      "Mitosis @ 476,1294\n",
      "Mitosis @ 1648,1966\n",
      "Mitosis @ 2222,4749\n",
      "Mitosis @ 2456,3750\n",
      "Mitosis @ 2219,3116\n",
      "Mitosis @ 3267,4936\n",
      "Mitosis @ 3096,4225\n",
      "Mitosis @ 3185,3906\n",
      "Mitosis @ 3671,3516\n",
      "Mitosis @ 3500,3290\n",
      "Mitosis @ 3343,3042\n",
      "Mitosis @ 3396,2906\n",
      "Mitosis @ 3321,2718\n",
      "Mitosis @ 3410,2656\n",
      "Mitosis @ 2352,1750\n",
      "Mitosis @ 2371,1346\n",
      "Mitosis @ 2419,996\n",
      "Mitosis @ 1888,674\n",
      "Mitosis @ 2050,375\n",
      "Mitosis @ 4093,5043\n",
      "Mitosis @ 4258,4442\n",
      "Mitosis @ 4794,4962\n",
      "Mitosis @ 5494,3374\n",
      "Mitosis @ 5326,3001\n",
      "Mitosis @ 4794,2167\n",
      "Mitosis @ 5559,2292\n",
      "Mitosis @ 5609,2042\n",
      "Mitosis @ 3647,1631\n",
      "Mitosis @ 309,1699\n",
      "Mitosis @ 1377,2231\n",
      "Mitosis @ 1640,969\n",
      "Mitosis @ 2287,2369\n",
      "Mitosis @ 2417,2429\n",
      "Mitosis @ 2829,5542\n",
      "Mitosis @ 3464,3520\n",
      "Mitosis @ 2530,3024\n",
      "Mitosis @ 5467,4998\n",
      "Mitosis @ 773,4532\n",
      "Mitosis @ 1735,4378\n",
      "Mitosis @ 3300,4058\n",
      "Mitosis @ 3119,2697\n",
      "Mitosis @ 4067,4406\n",
      "Mitosis @ 5467,3764\n",
      "Mitosis @ 5602,4502\n",
      "Mitosis @ 3972,1089\n",
      "Mitosis @ 5499,2866\n",
      "Mitosis @ 297,5502\n",
      "Mitosis @ 397,5566\n",
      "Mitosis @ 61,4926\n",
      "Mitosis @ 61,4834\n",
      "Mitosis @ 72,3983\n",
      "Mitosis @ 94,3882\n",
      "Mitosis @ 82,3798\n",
      "Mitosis @ 1620,4971\n",
      "Mitosis @ 1143,3731\n",
      "Mitosis @ 961,2901\n",
      "Mitosis @ 801,2397\n",
      "Mitosis @ 469,1762\n",
      "Mitosis @ 1251,2155\n",
      "Mitosis @ 91,565\n",
      "Mitosis @ 118,409\n",
      "Mitosis @ 301,268\n",
      "Mitosis @ 449,1080\n",
      "Mitosis @ 1092,736\n",
      "Mitosis @ 793,1279\n",
      "Mitosis @ 1132,1508\n",
      "Mitosis @ 2253,5609\n",
      "Mitosis @ 2110,4832\n",
      "Mitosis @ 2322,3894\n",
      "Mitosis @ 2284,3567\n",
      "Mitosis @ 1741,2752\n",
      "Mitosis @ 1592,2545\n",
      "Mitosis @ 2050,2716\n",
      "Mitosis @ 2028,2658\n",
      "Mitosis @ 2325,2545\n",
      "Mitosis @ 2107,2100\n",
      "Mitosis @ 1741,1756\n",
      "Mitosis @ 1920,1736\n",
      "Mitosis @ 1796,1599\n",
      "Mitosis @ 1954,1588\n",
      "Mitosis @ 2077,1219\n",
      "Mitosis @ 1944,1185\n",
      "Mitosis @ 2989,5528\n",
      "Mitosis @ 3048,5441\n",
      "Mitosis @ 3117,5471\n",
      "Mitosis @ 3097,5428\n",
      "Mitosis @ 3162,5409\n",
      "Mitosis @ 3504,5519\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Mitosis @ 3551,5486\n",
      "Mitosis @ 2947,5154\n",
      "Mitosis @ 2964,5107\n",
      "Mitosis @ 3370,4906\n",
      "Mitosis @ 3004,3291\n",
      "Mitosis @ 3462,3519\n",
      "Mitosis @ 2768,2726\n",
      "Mitosis @ 2850,2712\n",
      "Mitosis @ 3247,2688\n",
      "Mitosis @ 2617,2558\n",
      "Mitosis @ 3523,2178\n",
      "Mitosis @ 3219,2259\n",
      "Mitosis @ 3315,1398\n",
      "Mitosis @ 4419,3776\n",
      "Mitosis @ 4636,3373\n",
      "Mitosis @ 4675,3332\n",
      "Mitosis @ 4965,3298\n",
      "Mitosis @ 5016,3267\n",
      "Mitosis @ 4990,3229\n",
      "Mitosis @ 5148,3297\n",
      "Mitosis @ 4407,1542\n",
      "Mitosis @ 5086,245\n",
      "Mitosis @ 1907,2630\n",
      "Mitosis @ 1963,152\n",
      "Mitosis @ 5489,3166\n",
      "Mitosis @ 189,4308\n",
      "Mitosis @ 568,3243\n",
      "Mitosis @ 1443,2927\n",
      "Mitosis @ 5013,1013\n",
      "Mitosis @ 5048,169\n"
     ]
    }
   ],
   "source": [
    "for k in np.arange(23,73):\n",
    "    d='%02d' % (k+1)\n",
    "    \n",
    "    # convert original TUPAC images to pyramidal TIFF using VIPS\n",
    "    os.system(f'/usr/bin/vips tiffsave TUPAC/{d}/01.tif stitched/{d}.tif --compression=jpeg --Q=90 --tile --tile-width=256 --tile-height=256 --pyramid')\n",
    "\n",
    "    DB.insertNewSlide(d+'.tif','stitched/')\n",
    "    suid = DB.findSlideWithFilename(d+'.tif', 'stitched/')\n",
    "\n",
    "    gtannofile = f'TUPAC/mitoses_ground_truth/{d}/01.csv'\n",
    "    if os.path.exists(gtannofile):\n",
    "        with open(gtannofile,'r') as csvfile:\n",
    "            csvf = csv.reader(csvfile, delimiter=',', quotechar='|')\n",
    "            for y,x in csvf:\n",
    "                print(f'Mitosis @ {x},{y}')\n",
    "                DB.insertNewSpotAnnotation(xpos_orig=int(x), ypos_orig=int(y), classID=1, annotator=1, slideUID=suid)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1553,)]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DB.execute('SELECT COUNT(*) FROM Annotations').fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}