Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Python SQL toolkit and Object Relational Mapper\n",
    "import sqlalchemy\n",
    "from sqlalchemy.ext.automap import automap_base\n",
    "from sqlalchemy.orm import Session\n",
    "from sqlalchemy import create_engine\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import random\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(os.path.join(\"sqlite:///\",\"DataSets\",\"belly_button_biodiversity.sqlite\"),echo=False)\n",
    "\n",
    "\n",
    "conn = engine.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['otu', 'samples', 'samples_metadata']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Base = automap_base()\n",
    "# Use the Base class to reflect the database tables\n",
    "Base.prepare(engine, reflect=True)\n",
    "# Print all of the classes mapped to the Base\n",
    "Base.classes.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "otu_db = Base.classes.otu\n",
    "samples_db = Base.classes.samples\n",
    "samples_meta_db = Base.classes.samples_metadata\n",
    "session = Session(engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'BB_1233': 0,\n",
       " 'BB_1234': 0,\n",
       " 'BB_1235': 0,\n",
       " 'BB_1236': 0,\n",
       " 'BB_1237': 0,\n",
       " 'BB_1238': 0,\n",
       " 'BB_1242': 0,\n",
       " 'BB_1243': 0,\n",
       " 'BB_1246': 0,\n",
       " 'BB_1253': 0,\n",
       " 'BB_1254': 0,\n",
       " 'BB_1258': 0,\n",
       " 'BB_1259': 0,\n",
       " 'BB_1260': 0,\n",
       " 'BB_1264': 0,\n",
       " 'BB_1265': 0,\n",
       " 'BB_1273': 0,\n",
       " 'BB_1275': 0,\n",
       " 'BB_1276': 0,\n",
       " 'BB_1277': 0,\n",
       " 'BB_1278': 0,\n",
       " 'BB_1279': 0,\n",
       " 'BB_1280': 0,\n",
       " 'BB_1281': 0,\n",
       " 'BB_1282': 0,\n",
       " 'BB_1283': 0,\n",
       " 'BB_1284': 0,\n",
       " 'BB_1285': 0,\n",
       " 'BB_1286': 0,\n",
       " 'BB_1287': 0,\n",
       " 'BB_1288': 0,\n",
       " 'BB_1289': 0,\n",
       " 'BB_1290': 0,\n",
       " 'BB_1291': 0,\n",
       " 'BB_1292': 0,\n",
       " 'BB_1293': 0,\n",
       " 'BB_1294': 0,\n",
       " 'BB_1295': 0,\n",
       " 'BB_1296': 0,\n",
       " 'BB_1297': 0,\n",
       " 'BB_1298': 0,\n",
       " 'BB_1308': 0,\n",
       " 'BB_1309': 0,\n",
       " 'BB_1310': 0,\n",
       " 'BB_1374': 0,\n",
       " 'BB_1415': 0,\n",
       " 'BB_1439': 0,\n",
       " 'BB_1441': 0,\n",
       " 'BB_1443': 0,\n",
       " 'BB_1486': 0,\n",
       " 'BB_1487': 0,\n",
       " 'BB_1489': 0,\n",
       " 'BB_1490': 0,\n",
       " 'BB_1491': 0,\n",
       " 'BB_1494': 0,\n",
       " 'BB_1495': 0,\n",
       " 'BB_1497': 0,\n",
       " 'BB_1499': 0,\n",
       " 'BB_1500': 0,\n",
       " 'BB_1501': 0,\n",
       " 'BB_1502': 0,\n",
       " 'BB_1503': 0,\n",
       " 'BB_1504': 0,\n",
       " 'BB_1505': 0,\n",
       " 'BB_1506': 0,\n",
       " 'BB_1507': 0,\n",
       " 'BB_1508': 0,\n",
       " 'BB_1510': 0,\n",
       " 'BB_1511': 0,\n",
       " 'BB_1512': 0,\n",
       " 'BB_1513': 0,\n",
       " 'BB_1514': 0,\n",
       " 'BB_1515': 0,\n",
       " 'BB_1516': 0,\n",
       " 'BB_1517': 0,\n",
       " 'BB_1518': 0,\n",
       " 'BB_1519': 0,\n",
       " 'BB_1521': 0,\n",
       " 'BB_1524': 0,\n",
       " 'BB_1526': 0,\n",
       " 'BB_1527': 0,\n",
       " 'BB_1530': 0,\n",
       " 'BB_1531': 0,\n",
       " 'BB_1532': 0,\n",
       " 'BB_1533': 0,\n",
       " 'BB_1534': 0,\n",
       " 'BB_1535': 0,\n",
       " 'BB_1536': 0,\n",
       " 'BB_1537': 0,\n",
       " 'BB_1539': 0,\n",
       " 'BB_1540': 0,\n",
       " 'BB_1541': 0,\n",
       " 'BB_1542': 0,\n",
       " 'BB_1543': 0,\n",
       " 'BB_1544': 0,\n",
       " 'BB_1545': 0,\n",
       " 'BB_1546': 0,\n",
       " 'BB_1547': 0,\n",
       " 'BB_1548': 0,\n",
       " 'BB_1549': 0,\n",
       " 'BB_1550': 0,\n",
       " 'BB_1551': 0,\n",
       " 'BB_1552': 0,\n",
       " 'BB_1553': 0,\n",
       " 'BB_1554': 0,\n",
       " 'BB_1555': 0,\n",
       " 'BB_1556': 0,\n",
       " 'BB_1557': 0,\n",
       " 'BB_1558': 0,\n",
       " 'BB_1561': 0,\n",
       " 'BB_1562': 0,\n",
       " 'BB_1563': 0,\n",
       " 'BB_1564': 0,\n",
       " 'BB_1572': 0,\n",
       " 'BB_1573': 0,\n",
       " 'BB_1574': 0,\n",
       " 'BB_1576': 0,\n",
       " 'BB_1577': 0,\n",
       " 'BB_1581': 0,\n",
       " 'BB_1601': 0,\n",
       " 'BB_940': 0,\n",
       " 'BB_941': 0,\n",
       " 'BB_943': 0,\n",
       " 'BB_944': 0,\n",
       " 'BB_945': 0,\n",
       " 'BB_946': 0,\n",
       " 'BB_947': 0,\n",
       " 'BB_948': 0,\n",
       " 'BB_949': 0,\n",
       " 'BB_950': 0,\n",
       " 'BB_952': 0,\n",
       " 'BB_953': 0,\n",
       " 'BB_954': 0,\n",
       " 'BB_955': 0,\n",
       " 'BB_956': 0,\n",
       " 'BB_958': 0,\n",
       " 'BB_959': 0,\n",
       " 'BB_960': 0,\n",
       " 'BB_961': 0,\n",
       " 'BB_962': 0,\n",
       " 'BB_963': 0,\n",
       " 'BB_964': 0,\n",
       " 'BB_966': 1,\n",
       " 'BB_967': 0,\n",
       " 'BB_968': 0,\n",
       " 'BB_969': 0,\n",
       " 'BB_970': 0,\n",
       " 'BB_971': 0,\n",
       " 'BB_972': 0,\n",
       " 'BB_973': 0,\n",
       " 'BB_974': 0,\n",
       " 'BB_975': 0,\n",
       " 'BB_978': 0,\n",
       " '_sa_instance_state': <sqlalchemy.orm.state.InstanceState at 0x12649026a58>,\n",
       " 'otu_id': 1}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "first_row = session.query(samples_db).first()\n",
    "first_row.__dict__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['BB_940',\n",
       " 'BB_941',\n",
       " 'BB_943',\n",
       " 'BB_944',\n",
       " 'BB_945',\n",
       " 'BB_946',\n",
       " 'BB_947',\n",
       " 'BB_948',\n",
       " 'BB_949',\n",
       " 'BB_950',\n",
       " 'BB_952',\n",
       " 'BB_953',\n",
       " 'BB_954',\n",
       " 'BB_955',\n",
       " 'BB_956',\n",
       " 'BB_958',\n",
       " 'BB_959',\n",
       " 'BB_960',\n",
       " 'BB_961',\n",
       " 'BB_962',\n",
       " 'BB_963',\n",
       " 'BB_964',\n",
       " 'BB_966',\n",
       " 'BB_967',\n",
       " 'BB_968',\n",
       " 'BB_969',\n",
       " 'BB_970',\n",
       " 'BB_971',\n",
       " 'BB_972',\n",
       " 'BB_973',\n",
       " 'BB_974',\n",
       " 'BB_975',\n",
       " 'BB_978',\n",
       " 'BB_1233',\n",
       " 'BB_1234',\n",
       " 'BB_1235',\n",
       " 'BB_1236',\n",
       " 'BB_1237',\n",
       " 'BB_1238',\n",
       " 'BB_1242',\n",
       " 'BB_1243',\n",
       " 'BB_1246',\n",
       " 'BB_1253',\n",
       " 'BB_1254',\n",
       " 'BB_1258',\n",
       " 'BB_1259',\n",
       " 'BB_1260',\n",
       " 'BB_1264',\n",
       " 'BB_1265',\n",
       " 'BB_1273',\n",
       " 'BB_1275',\n",
       " 'BB_1276',\n",
       " 'BB_1277',\n",
       " 'BB_1278',\n",
       " 'BB_1279',\n",
       " 'BB_1280',\n",
       " 'BB_1281',\n",
       " 'BB_1282',\n",
       " 'BB_1283',\n",
       " 'BB_1284',\n",
       " 'BB_1285',\n",
       " 'BB_1286',\n",
       " 'BB_1287',\n",
       " 'BB_1288',\n",
       " 'BB_1289',\n",
       " 'BB_1290',\n",
       " 'BB_1291',\n",
       " 'BB_1292',\n",
       " 'BB_1293',\n",
       " 'BB_1294',\n",
       " 'BB_1295',\n",
       " 'BB_1296',\n",
       " 'BB_1297',\n",
       " 'BB_1298',\n",
       " 'BB_1308',\n",
       " 'BB_1309',\n",
       " 'BB_1310',\n",
       " 'BB_1374',\n",
       " 'BB_1415',\n",
       " 'BB_1439',\n",
       " 'BB_1441',\n",
       " 'BB_1443',\n",
       " 'BB_1486',\n",
       " 'BB_1487',\n",
       " 'BB_1489',\n",
       " 'BB_1490',\n",
       " 'BB_1491',\n",
       " 'BB_1494',\n",
       " 'BB_1495',\n",
       " 'BB_1497',\n",
       " 'BB_1499',\n",
       " 'BB_1500',\n",
       " 'BB_1501',\n",
       " 'BB_1502',\n",
       " 'BB_1503',\n",
       " 'BB_1504',\n",
       " 'BB_1505',\n",
       " 'BB_1506',\n",
       " 'BB_1507',\n",
       " 'BB_1508',\n",
       " 'BB_1510',\n",
       " 'BB_1511',\n",
       " 'BB_1512',\n",
       " 'BB_1513',\n",
       " 'BB_1514',\n",
       " 'BB_1515',\n",
       " 'BB_1516',\n",
       " 'BB_1517',\n",
       " 'BB_1518',\n",
       " 'BB_1519',\n",
       " 'BB_1521',\n",
       " 'BB_1524',\n",
       " 'BB_1526',\n",
       " 'BB_1527',\n",
       " 'BB_1530',\n",
       " 'BB_1531',\n",
       " 'BB_1532',\n",
       " 'BB_1533',\n",
       " 'BB_1534',\n",
       " 'BB_1535',\n",
       " 'BB_1536',\n",
       " 'BB_1537',\n",
       " 'BB_1539',\n",
       " 'BB_1540',\n",
       " 'BB_1541',\n",
       " 'BB_1542',\n",
       " 'BB_1543',\n",
       " 'BB_1544',\n",
       " 'BB_1545',\n",
       " 'BB_1546',\n",
       " 'BB_1547',\n",
       " 'BB_1548',\n",
       " 'BB_1549',\n",
       " 'BB_1550',\n",
       " 'BB_1551',\n",
       " 'BB_1552',\n",
       " 'BB_1553',\n",
       " 'BB_1554',\n",
       " 'BB_1555',\n",
       " 'BB_1556',\n",
       " 'BB_1557',\n",
       " 'BB_1558',\n",
       " 'BB_1561',\n",
       " 'BB_1562',\n",
       " 'BB_1563',\n",
       " 'BB_1564',\n",
       " 'BB_1572',\n",
       " 'BB_1573',\n",
       " 'BB_1574',\n",
       " 'BB_1576',\n",
       " 'BB_1577',\n",
       " 'BB_1581',\n",
       " 'BB_1601']"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "samples_cols_list=Base.classes.samples.__table__.columns.keys()\n",
    "samples_cols_list[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[[('Archaea;Euryarchaeota;Halobacteria;Halobacteriales;Halobacteriaceae;Halococcus'),\n",
       "  ('Archaea;Euryarchaeota;Halobacteria;Halobacteriales;Halobacteriaceae;Halococcus'),\n",
       "  ('Archaea;Euryarchaeota;Halobacteria;Halobacteriales;Halobacteriaceae;Natronorubrum'),\n",
       "  ('Archaea;Euryarchaeota;Methanobacteria;Methanobacteriales;Methanobacteriaceae;Methanobrevibacter'),\n",
       "  ('Archaea;Euryarchaeota;Methanobacteria;Methanobacteriales;Methanobacteriaceae;Methanobrevibacter'),\n",
       "  ('Archaea;Euryarchaeota;Methanobacteria;Methanobacteriales;Methanobacteriaceae;Methanobrevibacter'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp1;Gp1'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp1;Gp1'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp1;Gp1'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp1;Gp1'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp1;Gp1'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp10;Gp10'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp16;Gp16'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp16;Gp16'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp16;Gp16'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp2;Gp2'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp2;Gp2'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp2;Gp2'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp2;Gp2'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp2;Gp2'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp2;Gp2'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp3;Gp3'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp3;Gp3'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp3;Gp3'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp3;Gp3'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp4;Gp4'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp4;Gp4'),\n",
       "  ('Bacteria;Acidobacteria;Acidobacteria_Gp6;Gp6'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Acidimicrobiales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Acidimicrobiales;Iamiaceae;Iamia'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Acidimicrobidae_incertae_sedis;Ilumatobacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinobaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinobaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinobaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Actinomyces'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Arcanobacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Mobiluncus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Actinomycetaceae;Varibaculum'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Bogoriellaceae;Georgenia'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Brevibacteriaceae;Brevibacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Brevibacteriaceae;Brevibacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Brevibacteriaceae;Brevibacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Cellulomonadaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Corynebacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Turicella'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Turicella'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Corynebacteriaceae;Turicella'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Brachybacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Brachybacterium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermabacteraceae;Dermabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermacoccaceae;Dermacoccus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermacoccaceae;Dermacoccus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermacoccaceae;Kytococcus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dermacoccaceae;Kytococcus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Dietziaceae;Dietzia'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Intrasporangiaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Intrasporangiaceae;Arsenicicoccus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Intrasporangiaceae;Janibacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Intrasporangiaceae;Ornithinimicrobium'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Intrasporangiaceae;Phycicoccus'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Intrasporangiaceae;Terrabacter'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Kineosporiaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Kineosporiaceae;Quadrisphaera'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae'),\n",
       "  ('Bacteria;Actinobacteria;Actinobacteria;Actinomycetales;Microbacteriaceae;Zimmermannella'),\n",
       "  ...]]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "taxonomy_list=[]\n",
    "result_taxonomy = session.query(otu_db.lowest_taxonomic_unit_found).all()\n",
    "taxonomy_list.append(result_taxonomy)\n",
    "taxonomy_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(48, 'I', 'Caucasian', 'M', 'Lexington/NC', 960)"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample=\"BB_960\"\n",
    "sample=sample.split(\"_\")[1]\n",
    "result_sample = session.query(samples_meta_db.AGE,samples_meta_db.BBTYPE,samples_meta_db.ETHNICITY,samples_meta_db.GENDER,\\\n",
    "                       samples_meta_db.LOCATION,samples_meta_db.SAMPLEID).filter(samples_meta_db.SAMPLEID==sample).first()\n",
    "result_sample"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "sample_dict={}\n",
    "#di{\"Age\":result[0],\"BBTYPE\":result[1],\"ETHNICITY\":result[2],\"GENDER\":result[3],\"LOCATION\":result[3],\"SAMPLEID\":result[4]}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "names = [\"Age\", \"BBTYPE\", \"ETHNICITY\",\"GENDER\",\"LOCATION\",\"SAMPLEID\"]\n",
    "for i in range(len(names)):\n",
    "    sample_dict[names[i]]=result_sample[i]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Age': 48,\n",
       " 'BBTYPE': 'I',\n",
       " 'ETHNICITY': 'Caucasian',\n",
       " 'GENDER': 'M',\n",
       " 'LOCATION': 'Lexington/NC',\n",
       " 'SAMPLEID': 960}"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample=\"BB_960\"\n",
    "sample=sample.split(\"_\")[1]\n",
    "result_wfreq= session.query(samples_meta_db.WFREQ).filter(samples_meta_db.SAMPLEID==sample).first()\n",
    "result_wfreq[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(1167, 163),\n",
       " (2859, 126),\n",
       " (482, 113),\n",
       " (2264, 78),\n",
       " (41, 71),\n",
       " (1189, 51),\n",
       " (352, 50),\n",
       " (189, 47),\n",
       " (1977, 40),\n",
       " (2318, 40),\n",
       " (3450, 37),\n",
       " (874, 36),\n",
       " (1959, 30),\n",
       " (2191, 28),\n",
       " (1950, 25),\n",
       " (2077, 23),\n",
       " (2275, 22),\n",
       " (944, 19),\n",
       " (2184, 19),\n",
       " (2244, 14),\n",
       " (2024, 13),\n",
       " (2419, 13),\n",
       " (2811, 13),\n",
       " (165, 12),\n",
       " (2782, 12),\n",
       " (2011, 11),\n",
       " (2247, 11),\n",
       " (2396, 11),\n",
       " (830, 10),\n",
       " (1795, 10),\n",
       " (2964, 10),\n",
       " (2722, 8),\n",
       " (307, 7),\n",
       " (2178, 7),\n",
       " (2908, 7),\n",
       " (1193, 6),\n",
       " (1208, 5),\n",
       " (2039, 5),\n",
       " (2167, 5),\n",
       " (1274, 4),\n",
       " (2737, 4),\n",
       " (2739, 4),\n",
       " (833, 3),\n",
       " (907, 3),\n",
       " (1314, 3),\n",
       " (1962, 3),\n",
       " (2186, 3),\n",
       " (2335, 3),\n",
       " (2936, 3),\n",
       " (121, 2),\n",
       " (159, 2),\n",
       " (170, 2),\n",
       " (258, 2),\n",
       " (259, 2),\n",
       " (340, 2),\n",
       " (342, 2),\n",
       " (357, 2),\n",
       " (412, 2),\n",
       " (513, 2),\n",
       " (725, 2),\n",
       " (1169, 2),\n",
       " (1232, 2),\n",
       " (1497, 2),\n",
       " (1498, 2),\n",
       " (1503, 2),\n",
       " (1505, 2),\n",
       " (1960, 2),\n",
       " (1968, 2),\n",
       " (2065, 2),\n",
       " (2110, 2),\n",
       " (2188, 2),\n",
       " (2235, 2),\n",
       " (2291, 2),\n",
       " (2342, 2),\n",
       " (2350, 2),\n",
       " (2475, 2),\n",
       " (2483, 2),\n",
       " (2491, 2),\n",
       " (2546, 2),\n",
       " (2571, 2),\n",
       " (11, 1),\n",
       " (19, 1),\n",
       " (22, 1),\n",
       " (24, 1),\n",
       " (39, 1),\n",
       " (42, 1),\n",
       " (79, 1),\n",
       " (81, 1),\n",
       " (84, 1),\n",
       " (93, 1),\n",
       " (102, 1),\n",
       " (122, 1),\n",
       " (133, 1),\n",
       " (154, 1),\n",
       " (185, 1),\n",
       " (198, 1),\n",
       " (226, 1),\n",
       " (235, 1),\n",
       " (244, 1),\n",
       " (246, 1),\n",
       " (300, 1),\n",
       " (314, 1),\n",
       " (320, 1),\n",
       " (327, 1),\n",
       " (328, 1),\n",
       " (359, 1),\n",
       " (361, 1),\n",
       " (373, 1),\n",
       " (381, 1),\n",
       " (386, 1),\n",
       " (400, 1),\n",
       " (404, 1),\n",
       " (407, 1),\n",
       " (414, 1),\n",
       " (564, 1),\n",
       " (593, 1),\n",
       " (620, 1),\n",
       " (650, 1),\n",
       " (728, 1),\n",
       " (791, 1),\n",
       " (794, 1),\n",
       " (821, 1),\n",
       " (841, 1),\n",
       " (854, 1),\n",
       " (866, 1),\n",
       " (881, 1),\n",
       " (919, 1),\n",
       " (922, 1),\n",
       " (1094, 1),\n",
       " (1115, 1),\n",
       " (1155, 1),\n",
       " (1159, 1),\n",
       " (1174, 1),\n",
       " (1179, 1),\n",
       " (1191, 1),\n",
       " (1199, 1),\n",
       " (1217, 1),\n",
       " (1223, 1),\n",
       " (1227, 1),\n",
       " (1243, 1),\n",
       " (1254, 1),\n",
       " (1484, 1),\n",
       " (1495, 1),\n",
       " (1496, 1),\n",
       " (1501, 1),\n",
       " (1502, 1),\n",
       " (1515, 1),\n",
       " (1524, 1),\n",
       " (1576, 1),\n",
       " (1600, 1),\n",
       " (1935, 1),\n",
       " (1944, 1),\n",
       " (1947, 1),\n",
       " (1954, 1),\n",
       " (1965, 1),\n",
       " (1984, 1),\n",
       " (1991, 1),\n",
       " (1997, 1),\n",
       " (2036, 1),\n",
       " (2040, 1),\n",
       " (2051, 1),\n",
       " (2054, 1),\n",
       " (2062, 1),\n",
       " (2068, 1),\n",
       " (2080, 1),\n",
       " (2084, 1),\n",
       " (2093, 1),\n",
       " (2096, 1),\n",
       " (2114, 1),\n",
       " (2115, 1),\n",
       " (2136, 1),\n",
       " (2165, 1),\n",
       " (2192, 1),\n",
       " (2197, 1),\n",
       " (2202, 1),\n",
       " (2212, 1),\n",
       " (2216, 1),\n",
       " (2217, 1),\n",
       " (2229, 1),\n",
       " (2256, 1),\n",
       " (2263, 1),\n",
       " (2268, 1),\n",
       " (2334, 1),\n",
       " (2413, 1),\n",
       " (2423, 1),\n",
       " (2473, 1),\n",
       " (2508, 1),\n",
       " (2539, 1),\n",
       " (2542, 1),\n",
       " (2549, 1),\n",
       " (2603, 1),\n",
       " (2633, 1),\n",
       " (2750, 1),\n",
       " (2752, 1),\n",
       " (2753, 1),\n",
       " (2758, 1),\n",
       " (2795, 1),\n",
       " (2820, 1),\n",
       " (2829, 1),\n",
       " (2837, 1),\n",
       " (2840, 1),\n",
       " (2852, 1),\n",
       " (2873, 1),\n",
       " (2876, 1),\n",
       " (2915, 1),\n",
       " (2917, 1),\n",
       " (2949, 1),\n",
       " (2968, 1),\n",
       " (2985, 1),\n",
       " (2989, 1),\n",
       " (2994, 1),\n",
       " (3427, 1),\n",
       " (3439, 1),\n",
       " (3453, 1),\n",
       " (1, 0),\n",
       " (2, 0),\n",
       " (3, 0),\n",
       " (4, 0),\n",
       " (5, 0),\n",
       " (6, 0),\n",
       " (7, 0),\n",
       " (8, 0),\n",
       " (9, 0),\n",
       " (10, 0),\n",
       " (12, 0),\n",
       " (13, 0),\n",
       " (14, 0),\n",
       " (15, 0),\n",
       " (16, 0),\n",
       " (17, 0),\n",
       " (18, 0),\n",
       " (20, 0),\n",
       " (21, 0),\n",
       " (23, 0),\n",
       " (25, 0),\n",
       " (26, 0),\n",
       " (27, 0),\n",
       " (28, 0),\n",
       " (29, 0),\n",
       " (30, 0),\n",
       " (31, 0),\n",
       " (32, 0),\n",
       " (33, 0),\n",
       " (34, 0),\n",
       " (35, 0),\n",
       " (36, 0),\n",
       " (37, 0),\n",
       " (38, 0),\n",
       " (40, 0),\n",
       " (43, 0),\n",
       " (44, 0),\n",
       " (45, 0),\n",
       " (46, 0),\n",
       " (47, 0),\n",
       " (48, 0),\n",
       " (49, 0),\n",
       " (50, 0),\n",
       " (51, 0),\n",
       " (52, 0),\n",
       " (53, 0),\n",
       " (54, 0),\n",
       " (55, 0),\n",
       " (56, 0),\n",
       " (57, 0),\n",
       " (58, 0),\n",
       " (59, 0),\n",
       " (60, 0),\n",
       " (61, 0),\n",
       " (62, 0),\n",
       " (63, 0),\n",
       " (64, 0),\n",
       " (65, 0),\n",
       " (66, 0),\n",
       " (67, 0),\n",
       " (68, 0),\n",
       " (69, 0),\n",
       " (70, 0),\n",
       " (71, 0),\n",
       " (72, 0),\n",
       " (73, 0),\n",
       " (74, 0),\n",
       " (75, 0),\n",
       " (76, 0),\n",
       " (77, 0),\n",
       " (78, 0),\n",
       " (80, 0),\n",
       " (82, 0),\n",
       " (83, 0),\n",
       " (85, 0),\n",
       " (86, 0),\n",
       " (87, 0),\n",
       " (88, 0),\n",
       " (89, 0),\n",
       " (90, 0),\n",
       " (91, 0),\n",
       " (92, 0),\n",
       " (94, 0),\n",
       " (95, 0),\n",
       " (96, 0),\n",
       " (97, 0),\n",
       " (98, 0),\n",
       " (99, 0),\n",
       " (100, 0),\n",
       " (101, 0),\n",
       " (103, 0),\n",
       " (104, 0),\n",
       " (105, 0),\n",
       " (106, 0),\n",
       " (107, 0),\n",
       " (108, 0),\n",
       " (109, 0),\n",
       " (110, 0),\n",
       " (111, 0),\n",
       " (112, 0),\n",
       " (113, 0),\n",
       " (114, 0),\n",
       " (115, 0),\n",
       " (116, 0),\n",
       " (117, 0),\n",
       " (118, 0),\n",
       " (119, 0),\n",
       " (120, 0),\n",
       " (123, 0),\n",
       " (124, 0),\n",
       " (125, 0),\n",
       " (126, 0),\n",
       " (127, 0),\n",
       " (128, 0),\n",
       " (129, 0),\n",
       " (130, 0),\n",
       " (131, 0),\n",
       " (132, 0),\n",
       " (134, 0),\n",
       " (135, 0),\n",
       " (136, 0),\n",
       " (137, 0),\n",
       " (138, 0),\n",
       " (139, 0),\n",
       " (140, 0),\n",
       " (141, 0),\n",
       " (142, 0),\n",
       " (143, 0),\n",
       " (144, 0),\n",
       " (145, 0),\n",
       " (146, 0),\n",
       " (147, 0),\n",
       " (148, 0),\n",
       " (149, 0),\n",
       " (150, 0),\n",
       " (151, 0),\n",
       " (152, 0),\n",
       " (153, 0),\n",
       " (155, 0),\n",
       " (156, 0),\n",
       " (157, 0),\n",
       " (158, 0),\n",
       " (160, 0),\n",
       " (161, 0),\n",
       " (162, 0),\n",
       " (163, 0),\n",
       " (164, 0),\n",
       " (166, 0),\n",
       " (167, 0),\n",
       " (168, 0),\n",
       " (169, 0),\n",
       " (171, 0),\n",
       " (172, 0),\n",
       " (173, 0),\n",
       " (174, 0),\n",
       " (175, 0),\n",
       " (176, 0),\n",
       " (177, 0),\n",
       " (178, 0),\n",
       " (179, 0),\n",
       " (180, 0),\n",
       " (181, 0),\n",
       " (182, 0),\n",
       " (183, 0),\n",
       " (184, 0),\n",
       " (186, 0),\n",
       " (187, 0),\n",
       " (188, 0),\n",
       " (190, 0),\n",
       " (191, 0),\n",
       " (192, 0),\n",
       " (193, 0),\n",
       " (194, 0),\n",
       " (195, 0),\n",
       " (196, 0),\n",
       " (197, 0),\n",
       " (199, 0),\n",
       " (200, 0),\n",
       " (201, 0),\n",
       " (202, 0),\n",
       " (203, 0),\n",
       " (204, 0),\n",
       " (205, 0),\n",
       " (206, 0),\n",
       " (207, 0),\n",
       " (208, 0),\n",
       " (209, 0),\n",
       " (210, 0),\n",
       " (211, 0),\n",
       " (212, 0),\n",
       " (213, 0),\n",
       " (214, 0),\n",
       " (215, 0),\n",
       " (216, 0),\n",
       " (217, 0),\n",
       " (218, 0),\n",
       " (219, 0),\n",
       " (220, 0),\n",
       " (221, 0),\n",
       " (222, 0),\n",
       " (223, 0),\n",
       " (224, 0),\n",
       " (225, 0),\n",
       " (227, 0),\n",
       " (228, 0),\n",
       " (229, 0),\n",
       " (230, 0),\n",
       " (231, 0),\n",
       " (232, 0),\n",
       " (233, 0),\n",
       " (234, 0),\n",
       " (236, 0),\n",
       " (237, 0),\n",
       " (238, 0),\n",
       " (239, 0),\n",
       " (240, 0),\n",
       " (241, 0),\n",
       " (242, 0),\n",
       " (243, 0),\n",
       " (245, 0),\n",
       " (247, 0),\n",
       " (248, 0),\n",
       " (249, 0),\n",
       " (250, 0),\n",
       " (251, 0),\n",
       " (252, 0),\n",
       " (253, 0),\n",
       " (254, 0),\n",
       " (255, 0),\n",
       " (256, 0),\n",
       " (257, 0),\n",
       " (260, 0),\n",
       " (261, 0),\n",
       " (262, 0),\n",
       " (263, 0),\n",
       " (264, 0),\n",
       " (265, 0),\n",
       " (266, 0),\n",
       " (267, 0),\n",
       " (268, 0),\n",
       " (269, 0),\n",
       " (270, 0),\n",
       " (271, 0),\n",
       " (272, 0),\n",
       " (273, 0),\n",
       " (274, 0),\n",
       " (275, 0),\n",
       " (276, 0),\n",
       " (277, 0),\n",
       " (278, 0),\n",
       " (279, 0),\n",
       " (280, 0),\n",
       " (281, 0),\n",
       " (282, 0),\n",
       " (283, 0),\n",
       " (284, 0),\n",
       " (285, 0),\n",
       " (286, 0),\n",
       " (287, 0),\n",
       " (288, 0),\n",
       " (289, 0),\n",
       " (290, 0),\n",
       " (291, 0),\n",
       " (292, 0),\n",
       " (293, 0),\n",
       " (294, 0),\n",
       " (295, 0),\n",
       " (296, 0),\n",
       " (297, 0),\n",
       " (298, 0),\n",
       " (299, 0),\n",
       " (301, 0),\n",
       " (302, 0),\n",
       " (303, 0),\n",
       " (304, 0),\n",
       " (305, 0),\n",
       " (306, 0),\n",
       " (308, 0),\n",
       " (309, 0),\n",
       " (310, 0),\n",
       " (311, 0),\n",
       " (312, 0),\n",
       " (313, 0),\n",
       " (315, 0),\n",
       " (316, 0),\n",
       " (317, 0),\n",
       " (318, 0),\n",
       " (319, 0),\n",
       " (321, 0),\n",
       " (322, 0),\n",
       " (323, 0),\n",
       " (324, 0),\n",
       " (325, 0),\n",
       " (326, 0),\n",
       " (329, 0),\n",
       " (330, 0),\n",
       " (331, 0),\n",
       " (332, 0),\n",
       " (333, 0),\n",
       " (334, 0),\n",
       " (335, 0),\n",
       " (336, 0),\n",
       " (337, 0),\n",
       " (338, 0),\n",
       " (339, 0),\n",
       " (341, 0),\n",
       " (343, 0),\n",
       " (344, 0),\n",
       " (345, 0),\n",
       " (346, 0),\n",
       " (347, 0),\n",
       " (348, 0),\n",
       " (349, 0),\n",
       " (350, 0),\n",
       " (351, 0),\n",
       " (353, 0),\n",
       " (354, 0),\n",
       " (355, 0),\n",
       " (356, 0),\n",
       " (358, 0),\n",
       " (360, 0),\n",
       " (362, 0),\n",
       " (363, 0),\n",
       " (364, 0),\n",
       " (365, 0),\n",
       " (366, 0),\n",
       " (367, 0),\n",
       " (368, 0),\n",
       " (369, 0),\n",
       " (370, 0),\n",
       " (371, 0),\n",
       " (372, 0),\n",
       " (374, 0),\n",
       " (375, 0),\n",
       " (376, 0),\n",
       " (377, 0),\n",
       " (378, 0),\n",
       " (379, 0),\n",
       " (380, 0),\n",
       " (382, 0),\n",
       " (383, 0),\n",
       " (384, 0),\n",
       " (385, 0),\n",
       " (387, 0),\n",
       " (388, 0),\n",
       " (389, 0),\n",
       " (390, 0),\n",
       " (391, 0),\n",
       " (392, 0),\n",
       " (393, 0),\n",
       " (394, 0),\n",
       " (395, 0),\n",
       " (396, 0),\n",
       " (397, 0),\n",
       " (398, 0),\n",
       " (399, 0),\n",
       " (401, 0),\n",
       " (402, 0),\n",
       " (403, 0),\n",
       " (405, 0),\n",
       " (406, 0),\n",
       " (408, 0),\n",
       " (409, 0),\n",
       " (410, 0),\n",
       " (411, 0),\n",
       " (413, 0),\n",
       " (415, 0),\n",
       " (416, 0),\n",
       " (417, 0),\n",
       " (418, 0),\n",
       " (419, 0),\n",
       " (420, 0),\n",
       " (421, 0),\n",
       " (422, 0),\n",
       " (423, 0),\n",
       " (424, 0),\n",
       " (425, 0),\n",
       " (426, 0),\n",
       " (427, 0),\n",
       " (428, 0),\n",
       " (429, 0),\n",
       " (430, 0),\n",
       " (431, 0),\n",
       " (432, 0),\n",
       " (433, 0),\n",
       " (434, 0),\n",
       " (435, 0),\n",
       " (436, 0),\n",
       " (437, 0),\n",
       " (438, 0),\n",
       " (439, 0),\n",
       " (440, 0),\n",
       " (441, 0),\n",
       " (442, 0),\n",
       " (443, 0),\n",
       " (444, 0),\n",
       " (445, 0),\n",
       " (446, 0),\n",
       " (447, 0),\n",
       " (448, 0),\n",
       " (449, 0),\n",
       " (450, 0),\n",
       " (451, 0),\n",
       " (452, 0),\n",
       " (453, 0),\n",
       " (454, 0),\n",
       " (455, 0),\n",
       " (456, 0),\n",
       " (457, 0),\n",
       " (458, 0),\n",
       " (459, 0),\n",
       " (460, 0),\n",
       " (461, 0),\n",
       " (462, 0),\n",
       " (463, 0),\n",
       " (464, 0),\n",
       " (465, 0),\n",
       " (466, 0),\n",
       " (467, 0),\n",
       " (468, 0),\n",
       " (469, 0),\n",
       " (470, 0),\n",
       " (471, 0),\n",
       " (472, 0),\n",
       " (473, 0),\n",
       " (474, 0),\n",
       " (475, 0),\n",
       " (476, 0),\n",
       " (477, 0),\n",
       " (478, 0),\n",
       " (479, 0),\n",
       " (480, 0),\n",
       " (481, 0),\n",
       " (483, 0),\n",
       " (484, 0),\n",
       " (485, 0),\n",
       " (486, 0),\n",
       " (487, 0),\n",
       " (488, 0),\n",
       " (489, 0),\n",
       " (490, 0),\n",
       " (491, 0),\n",
       " (492, 0),\n",
       " (493, 0),\n",
       " (494, 0),\n",
       " (495, 0),\n",
       " (496, 0),\n",
       " (497, 0),\n",
       " (498, 0),\n",
       " (499, 0),\n",
       " (500, 0),\n",
       " (501, 0),\n",
       " (502, 0),\n",
       " (503, 0),\n",
       " (504, 0),\n",
       " (505, 0),\n",
       " (506, 0),\n",
       " (507, 0),\n",
       " (508, 0),\n",
       " (509, 0),\n",
       " (510, 0),\n",
       " (511, 0),\n",
       " (512, 0),\n",
       " (514, 0),\n",
       " (515, 0),\n",
       " (516, 0),\n",
       " (517, 0),\n",
       " (518, 0),\n",
       " (519, 0),\n",
       " (520, 0),\n",
       " (521, 0),\n",
       " (522, 0),\n",
       " (523, 0),\n",
       " (524, 0),\n",
       " (525, 0),\n",
       " (526, 0),\n",
       " (527, 0),\n",
       " (528, 0),\n",
       " (529, 0),\n",
       " (530, 0),\n",
       " (531, 0),\n",
       " (532, 0),\n",
       " (533, 0),\n",
       " (534, 0),\n",
       " (535, 0),\n",
       " (536, 0),\n",
       " (537, 0),\n",
       " (538, 0),\n",
       " (539, 0),\n",
       " (540, 0),\n",
       " (541, 0),\n",
       " (542, 0),\n",
       " (543, 0),\n",
       " (544, 0),\n",
       " (545, 0),\n",
       " (546, 0),\n",
       " (547, 0),\n",
       " (548, 0),\n",
       " (549, 0),\n",
       " (550, 0),\n",
       " (551, 0),\n",
       " (552, 0),\n",
       " (553, 0),\n",
       " (554, 0),\n",
       " (555, 0),\n",
       " (556, 0),\n",
       " (557, 0),\n",
       " (558, 0),\n",
       " (559, 0),\n",
       " (560, 0),\n",
       " (561, 0),\n",
       " (562, 0),\n",
       " (563, 0),\n",
       " (565, 0),\n",
       " (566, 0),\n",
       " (567, 0),\n",
       " (568, 0),\n",
       " (569, 0),\n",
       " (570, 0),\n",
       " (571, 0),\n",
       " (572, 0),\n",
       " (573, 0),\n",
       " (574, 0),\n",
       " (575, 0),\n",
       " (576, 0),\n",
       " (577, 0),\n",
       " (578, 0),\n",
       " (579, 0),\n",
       " (580, 0),\n",
       " (581, 0),\n",
       " (582, 0),\n",
       " (583, 0),\n",
       " (584, 0),\n",
       " (585, 0),\n",
       " (586, 0),\n",
       " (587, 0),\n",
       " (588, 0),\n",
       " (589, 0),\n",
       " (590, 0),\n",
       " (591, 0),\n",
       " (592, 0),\n",
       " (594, 0),\n",
       " (595, 0),\n",
       " (596, 0),\n",
       " (597, 0),\n",
       " (598, 0),\n",
       " (599, 0),\n",
       " (600, 0),\n",
       " (601, 0),\n",
       " (602, 0),\n",
       " (603, 0),\n",
       " (604, 0),\n",
       " (605, 0),\n",
       " (606, 0),\n",
       " (607, 0),\n",
       " (608, 0),\n",
       " (609, 0),\n",
       " (610, 0),\n",
       " (611, 0),\n",
       " (612, 0),\n",
       " (613, 0),\n",
       " (614, 0),\n",
       " (615, 0),\n",
       " (616, 0),\n",
       " (617, 0),\n",
       " (618, 0),\n",
       " (619, 0),\n",
       " (621, 0),\n",
       " (622, 0),\n",
       " (623, 0),\n",
       " (624, 0),\n",
       " (625, 0),\n",
       " (626, 0),\n",
       " (627, 0),\n",
       " (628, 0),\n",
       " (629, 0),\n",
       " (630, 0),\n",
       " (631, 0),\n",
       " (632, 0),\n",
       " (633, 0),\n",
       " (634, 0),\n",
       " (635, 0),\n",
       " (636, 0),\n",
       " (637, 0),\n",
       " (638, 0),\n",
       " (639, 0),\n",
       " (640, 0),\n",
       " (641, 0),\n",
       " (642, 0),\n",
       " (643, 0),\n",
       " (644, 0),\n",
       " (645, 0),\n",
       " (646, 0),\n",
       " (647, 0),\n",
       " (648, 0),\n",
       " (649, 0),\n",
       " (651, 0),\n",
       " (652, 0),\n",
       " (653, 0),\n",
       " (654, 0),\n",
       " (655, 0),\n",
       " (656, 0),\n",
       " (657, 0),\n",
       " (658, 0),\n",
       " (659, 0),\n",
       " (660, 0),\n",
       " (661, 0),\n",
       " (662, 0),\n",
       " (663, 0),\n",
       " (664, 0),\n",
       " (665, 0),\n",
       " (666, 0),\n",
       " (667, 0),\n",
       " (668, 0),\n",
       " (669, 0),\n",
       " (670, 0),\n",
       " (671, 0),\n",
       " (672, 0),\n",
       " (673, 0),\n",
       " (674, 0),\n",
       " (675, 0),\n",
       " (676, 0),\n",
       " (677, 0),\n",
       " (678, 0),\n",
       " (679, 0),\n",
       " (680, 0),\n",
       " (681, 0),\n",
       " (682, 0),\n",
       " (683, 0),\n",
       " (684, 0),\n",
       " (685, 0),\n",
       " (686, 0),\n",
       " (687, 0),\n",
       " (688, 0),\n",
       " (689, 0),\n",
       " (690, 0),\n",
       " (691, 0),\n",
       " (692, 0),\n",
       " (693, 0),\n",
       " (694, 0),\n",
       " (695, 0),\n",
       " (696, 0),\n",
       " (697, 0),\n",
       " (698, 0),\n",
       " (699, 0),\n",
       " (700, 0),\n",
       " (701, 0),\n",
       " (702, 0),\n",
       " (703, 0),\n",
       " (704, 0),\n",
       " (705, 0),\n",
       " (706, 0),\n",
       " (707, 0),\n",
       " (708, 0),\n",
       " (709, 0),\n",
       " (710, 0),\n",
       " (711, 0),\n",
       " (712, 0),\n",
       " (713, 0),\n",
       " (714, 0),\n",
       " (715, 0),\n",
       " (716, 0),\n",
       " (717, 0),\n",
       " (718, 0),\n",
       " (719, 0),\n",
       " (720, 0),\n",
       " (721, 0),\n",
       " (722, 0),\n",
       " (723, 0),\n",
       " (724, 0),\n",
       " (726, 0),\n",
       " (727, 0),\n",
       " (729, 0),\n",
       " (730, 0),\n",
       " (731, 0),\n",
       " (732, 0),\n",
       " (733, 0),\n",
       " (734, 0),\n",
       " (735, 0),\n",
       " (736, 0),\n",
       " (737, 0),\n",
       " (738, 0),\n",
       " (739, 0),\n",
       " (740, 0),\n",
       " (741, 0),\n",
       " (742, 0),\n",
       " (743, 0),\n",
       " (744, 0),\n",
       " (745, 0),\n",
       " (746, 0),\n",
       " (747, 0),\n",
       " (748, 0),\n",
       " (749, 0),\n",
       " (750, 0),\n",
       " (751, 0),\n",
       " (752, 0),\n",
       " (753, 0),\n",
       " (754, 0),\n",
       " (755, 0),\n",
       " (756, 0),\n",
       " (757, 0),\n",
       " (758, 0),\n",
       " (759, 0),\n",
       " (760, 0),\n",
       " (761, 0),\n",
       " (762, 0),\n",
       " (763, 0),\n",
       " (764, 0),\n",
       " (765, 0),\n",
       " (766, 0),\n",
       " (767, 0),\n",
       " (768, 0),\n",
       " (769, 0),\n",
       " (770, 0),\n",
       " (771, 0),\n",
       " (772, 0),\n",
       " (773, 0),\n",
       " (774, 0),\n",
       " (775, 0),\n",
       " (776, 0),\n",
       " (777, 0),\n",
       " (778, 0),\n",
       " (779, 0),\n",
       " (780, 0),\n",
       " (781, 0),\n",
       " (782, 0),\n",
       " (783, 0),\n",
       " (784, 0),\n",
       " (785, 0),\n",
       " (786, 0),\n",
       " (787, 0),\n",
       " (788, 0),\n",
       " (789, 0),\n",
       " (790, 0),\n",
       " (792, 0),\n",
       " (793, 0),\n",
       " (795, 0),\n",
       " (796, 0),\n",
       " (797, 0),\n",
       " (798, 0),\n",
       " (799, 0),\n",
       " (800, 0),\n",
       " (801, 0),\n",
       " (802, 0),\n",
       " (803, 0),\n",
       " (804, 0),\n",
       " (805, 0),\n",
       " (806, 0),\n",
       " (807, 0),\n",
       " (808, 0),\n",
       " (809, 0),\n",
       " (810, 0),\n",
       " (811, 0),\n",
       " (812, 0),\n",
       " (813, 0),\n",
       " (814, 0),\n",
       " (815, 0),\n",
       " (816, 0),\n",
       " (817, 0),\n",
       " (818, 0),\n",
       " (819, 0),\n",
       " (820, 0),\n",
       " (822, 0),\n",
       " (823, 0),\n",
       " (824, 0),\n",
       " (825, 0),\n",
       " (826, 0),\n",
       " (827, 0),\n",
       " (828, 0),\n",
       " (829, 0),\n",
       " (831, 0),\n",
       " (832, 0),\n",
       " (834, 0),\n",
       " (835, 0),\n",
       " (836, 0),\n",
       " (837, 0),\n",
       " (838, 0),\n",
       " (839, 0),\n",
       " (840, 0),\n",
       " (842, 0),\n",
       " (843, 0),\n",
       " (844, 0),\n",
       " (845, 0),\n",
       " (846, 0),\n",
       " (847, 0),\n",
       " (848, 0),\n",
       " ...]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "s=\"BB_940\"\n",
    "result_samples_desc = session.query(samples_db.otu_id,getattr(samples_db, s)).order_by(getattr(samples_db, s).desc()).all()\n",
    "result_samples_desc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [],
   "source": [
    "otu_list=[]\n",
    "sample_list=[]\n",
    "for i in result_samples_desc:\n",
    "    otu_list.append(i[0])\n",
    "    sample_list.append(i[1])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [],
   "source": [
    "sample_otu_dict={}\n",
    "sample_otu_dict[\"otu_ids\"]=otu_list\n",
    "sample_otu_dict[\"sample_values\"]=sample_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'otu_ids': [1167,\n",
       "   2859,\n",
       "   482,\n",
       "   2264,\n",
       "   41,\n",
       "   1189,\n",
       "   352,\n",
       "   189,\n",
       "   1977,\n",
       "   2318,\n",
       "   3450,\n",
       "   874,\n",
       "   1959,\n",
       "   2191,\n",
       "   1950,\n",
       "   2077,\n",
       "   2275,\n",
       "   944,\n",
       "   2184,\n",
       "   2244,\n",
       "   2024,\n",
       "   2419,\n",
       "   2811,\n",
       "   165,\n",
       "   2782,\n",
       "   2011,\n",
       "   2247,\n",
       "   2396,\n",
       "   830,\n",
       "   1795,\n",
       "   2964,\n",
       "   2722,\n",
       "   307,\n",
       "   2178,\n",
       "   2908,\n",
       "   1193,\n",
       "   1208,\n",
       "   2039,\n",
       "   2167,\n",
       "   1274,\n",
       "   2737,\n",
       "   2739,\n",
       "   833,\n",
       "   907,\n",
       "   1314,\n",
       "   1962,\n",
       "   2186,\n",
       "   2335,\n",
       "   2936,\n",
       "   121,\n",
       "   159,\n",
       "   170,\n",
       "   258,\n",
       "   259,\n",
       "   340,\n",
       "   342,\n",
       "   357,\n",
       "   412,\n",
       "   513,\n",
       "   725,\n",
       "   1169,\n",
       "   1232,\n",
       "   1497,\n",
       "   1498,\n",
       "   1503,\n",
       "   1505,\n",
       "   1960,\n",
       "   1968,\n",
       "   2065,\n",
       "   2110,\n",
       "   2188,\n",
       "   2235,\n",
       "   2291,\n",
       "   2342,\n",
       "   2350,\n",
       "   2475,\n",
       "   2483,\n",
       "   2491,\n",
       "   2546,\n",
       "   2571,\n",
       "   11,\n",
       "   19,\n",
       "   22,\n",
       "   24,\n",
       "   39,\n",
       "   42,\n",
       "   79,\n",
       "   81,\n",
       "   84,\n",
       "   93,\n",
       "   102,\n",
       "   122,\n",
       "   133,\n",
       "   154,\n",
       "   185,\n",
       "   198,\n",
       "   226,\n",
       "   235,\n",
       "   244,\n",
       "   246,\n",
       "   300,\n",
       "   314,\n",
       "   320,\n",
       "   327,\n",
       "   328,\n",
       "   359,\n",
       "   361,\n",
       "   373,\n",
       "   381,\n",
       "   386,\n",
       "   400,\n",
       "   404,\n",
       "   407,\n",
       "   414,\n",
       "   564,\n",
       "   593,\n",
       "   620,\n",
       "   650,\n",
       "   728,\n",
       "   791,\n",
       "   794,\n",
       "   821,\n",
       "   841,\n",
       "   854,\n",
       "   866,\n",
       "   881,\n",
       "   919,\n",
       "   922,\n",
       "   1094,\n",
       "   1115,\n",
       "   1155,\n",
       "   1159,\n",
       "   1174,\n",
       "   1179,\n",
       "   1191,\n",
       "   1199,\n",
       "   1217,\n",
       "   1223,\n",
       "   1227,\n",
       "   1243,\n",
       "   1254,\n",
       "   1484,\n",
       "   1495,\n",
       "   1496,\n",
       "   1501,\n",
       "   1502,\n",
       "   1515,\n",
       "   1524,\n",
       "   1576,\n",
       "   1600,\n",
       "   1935,\n",
       "   1944,\n",
       "   1947,\n",
       "   1954,\n",
       "   1965,\n",
       "   1984,\n",
       "   1991,\n",
       "   1997,\n",
       "   2036,\n",
       "   2040,\n",
       "   2051,\n",
       "   2054,\n",
       "   2062,\n",
       "   2068,\n",
       "   2080,\n",
       "   2084,\n",
       "   2093,\n",
       "   2096,\n",
       "   2114,\n",
       "   2115,\n",
       "   2136,\n",
       "   2165,\n",
       "   2192,\n",
       "   2197,\n",
       "   2202,\n",
       "   2212,\n",
       "   2216,\n",
       "   2217,\n",
       "   2229,\n",
       "   2256,\n",
       "   2263,\n",
       "   2268,\n",
       "   2334,\n",
       "   2413,\n",
       "   2423,\n",
       "   2473,\n",
       "   2508,\n",
       "   2539,\n",
       "   2542,\n",
       "   2549,\n",
       "   2603,\n",
       "   2633,\n",
       "   2750,\n",
       "   2752,\n",
       "   2753,\n",
       "   2758,\n",
       "   2795,\n",
       "   2820,\n",
       "   2829,\n",
       "   2837,\n",
       "   2840,\n",
       "   2852,\n",
       "   2873,\n",
       "   2876,\n",
       "   2915,\n",
       "   2917,\n",
       "   2949,\n",
       "   2968,\n",
       "   2985,\n",
       "   2989,\n",
       "   2994,\n",
       "   3427,\n",
       "   3439,\n",
       "   3453,\n",
       "   1,\n",
       "   2,\n",
       "   3,\n",
       "   4,\n",
       "   5,\n",
       "   6,\n",
       "   7,\n",
       "   8,\n",
       "   9,\n",
       "   10,\n",
       "   12,\n",
       "   13,\n",
       "   14,\n",
       "   15,\n",
       "   16,\n",
       "   17,\n",
       "   18,\n",
       "   20,\n",
       "   21,\n",
       "   23,\n",
       "   25,\n",
       "   26,\n",
       "   27,\n",
       "   28,\n",
       "   29,\n",
       "   30,\n",
       "   31,\n",
       "   32,\n",
       "   33,\n",
       "   34,\n",
       "   35,\n",
       "   36,\n",
       "   37,\n",
       "   38,\n",
       "   40,\n",
       "   43,\n",
       "   44,\n",
       "   45,\n",
       "   46,\n",
       "   47,\n",
       "   48,\n",
       "   49,\n",
       "   50,\n",
       "   51,\n",
       "   52,\n",
       "   53,\n",
       "   54,\n",
       "   55,\n",
       "   56,\n",
       "   57,\n",
       "   58,\n",
       "   59,\n",
       "   60,\n",
       "   61,\n",
       "   62,\n",
       "   63,\n",
       "   64,\n",
       "   65,\n",
       "   66,\n",
       "   67,\n",
       "   68,\n",
       "   69,\n",
       "   70,\n",
       "   71,\n",
       "   72,\n",
       "   73,\n",
       "   74,\n",
       "   75,\n",
       "   76,\n",
       "   77,\n",
       "   78,\n",
       "   80,\n",
       "   82,\n",
       "   83,\n",
       "   85,\n",
       "   86,\n",
       "   87,\n",
       "   88,\n",
       "   89,\n",
       "   90,\n",
       "   91,\n",
       "   92,\n",
       "   94,\n",
       "   95,\n",
       "   96,\n",
       "   97,\n",
       "   98,\n",
       "   99,\n",
       "   100,\n",
       "   101,\n",
       "   103,\n",
       "   104,\n",
       "   105,\n",
       "   106,\n",
       "   107,\n",
       "   108,\n",
       "   109,\n",
       "   110,\n",
       "   111,\n",
       "   112,\n",
       "   113,\n",
       "   114,\n",
       "   115,\n",
       "   116,\n",
       "   117,\n",
       "   118,\n",
       "   119,\n",
       "   120,\n",
       "   123,\n",
       "   124,\n",
       "   125,\n",
       "   126,\n",
       "   127,\n",
       "   128,\n",
       "   129,\n",
       "   130,\n",
       "   131,\n",
       "   132,\n",
       "   134,\n",
       "   135,\n",
       "   136,\n",
       "   137,\n",
       "   138,\n",
       "   139,\n",
       "   140,\n",
       "   141,\n",
       "   142,\n",
       "   143,\n",
       "   144,\n",
       "   145,\n",
       "   146,\n",
       "   147,\n",
       "   148,\n",
       "   149,\n",
       "   150,\n",
       "   151,\n",
       "   152,\n",
       "   153,\n",
       "   155,\n",
       "   156,\n",
       "   157,\n",
       "   158,\n",
       "   160,\n",
       "   161,\n",
       "   162,\n",
       "   163,\n",
       "   164,\n",
       "   166,\n",
       "   167,\n",
       "   168,\n",
       "   169,\n",
       "   171,\n",
       "   172,\n",
       "   173,\n",
       "   174,\n",
       "   175,\n",
       "   176,\n",
       "   177,\n",
       "   178,\n",
       "   179,\n",
       "   180,\n",
       "   181,\n",
       "   182,\n",
       "   183,\n",
       "   184,\n",
       "   186,\n",
       "   187,\n",
       "   188,\n",
       "   190,\n",
       "   191,\n",
       "   192,\n",
       "   193,\n",
       "   194,\n",
       "   195,\n",
       "   196,\n",
       "   197,\n",
       "   199,\n",
       "   200,\n",
       "   201,\n",
       "   202,\n",
       "   203,\n",
       "   204,\n",
       "   205,\n",
       "   206,\n",
       "   207,\n",
       "   208,\n",
       "   209,\n",
       "   210,\n",
       "   211,\n",
       "   212,\n",
       "   213,\n",
       "   214,\n",
       "   215,\n",
       "   216,\n",
       "   217,\n",
       "   218,\n",
       "   219,\n",
       "   220,\n",
       "   221,\n",
       "   222,\n",
       "   223,\n",
       "   224,\n",
       "   225,\n",
       "   227,\n",
       "   228,\n",
       "   229,\n",
       "   230,\n",
       "   231,\n",
       "   232,\n",
       "   233,\n",
       "   234,\n",
       "   236,\n",
       "   237,\n",
       "   238,\n",
       "   239,\n",
       "   240,\n",
       "   241,\n",
       "   242,\n",
       "   243,\n",
       "   245,\n",
       "   247,\n",
       "   248,\n",
       "   249,\n",
       "   250,\n",
       "   251,\n",
       "   252,\n",
       "   253,\n",
       "   254,\n",
       "   255,\n",
       "   256,\n",
       "   257,\n",
       "   260,\n",
       "   261,\n",
       "   262,\n",
       "   263,\n",
       "   264,\n",
       "   265,\n",
       "   266,\n",
       "   267,\n",
       "   268,\n",
       "   269,\n",
       "   270,\n",
       "   271,\n",
       "   272,\n",
       "   273,\n",
       "   274,\n",
       "   275,\n",
       "   276,\n",
       "   277,\n",
       "   278,\n",
       "   279,\n",
       "   280,\n",
       "   281,\n",
       "   282,\n",
       "   283,\n",
       "   284,\n",
       "   285,\n",
       "   286,\n",
       "   287,\n",
       "   288,\n",
       "   289,\n",
       "   290,\n",
       "   291,\n",
       "   292,\n",
       "   293,\n",
       "   294,\n",
       "   295,\n",
       "   296,\n",
       "   297,\n",
       "   298,\n",
       "   299,\n",
       "   301,\n",
       "   302,\n",
       "   303,\n",
       "   304,\n",
       "   305,\n",
       "   306,\n",
       "   308,\n",
       "   309,\n",
       "   310,\n",
       "   311,\n",
       "   312,\n",
       "   313,\n",
       "   315,\n",
       "   316,\n",
       "   317,\n",
       "   318,\n",
       "   319,\n",
       "   321,\n",
       "   322,\n",
       "   323,\n",
       "   324,\n",
       "   325,\n",
       "   326,\n",
       "   329,\n",
       "   330,\n",
       "   331,\n",
       "   332,\n",
       "   333,\n",
       "   334,\n",
       "   335,\n",
       "   336,\n",
       "   337,\n",
       "   338,\n",
       "   339,\n",
       "   341,\n",
       "   343,\n",
       "   344,\n",
       "   345,\n",
       "   346,\n",
       "   347,\n",
       "   348,\n",
       "   349,\n",
       "   350,\n",
       "   351,\n",
       "   353,\n",
       "   354,\n",
       "   355,\n",
       "   356,\n",
       "   358,\n",
       "   360,\n",
       "   362,\n",
       "   363,\n",
       "   364,\n",
       "   365,\n",
       "   366,\n",
       "   367,\n",
       "   368,\n",
       "   369,\n",
       "   370,\n",
       "   371,\n",
       "   372,\n",
       "   374,\n",
       "   375,\n",
       "   376,\n",
       "   377,\n",
       "   378,\n",
       "   379,\n",
       "   380,\n",
       "   382,\n",
       "   383,\n",
       "   384,\n",
       "   385,\n",
       "   387,\n",
       "   388,\n",
       "   389,\n",
       "   390,\n",
       "   391,\n",
       "   392,\n",
       "   393,\n",
       "   394,\n",
       "   395,\n",
       "   396,\n",
       "   397,\n",
       "   398,\n",
       "   399,\n",
       "   401,\n",
       "   402,\n",
       "   403,\n",
       "   405,\n",
       "   406,\n",
       "   408,\n",
       "   409,\n",
       "   410,\n",
       "   411,\n",
       "   413,\n",
       "   415,\n",
       "   416,\n",
       "   417,\n",
       "   418,\n",
       "   419,\n",
       "   420,\n",
       "   421,\n",
       "   422,\n",
       "   423,\n",
       "   424,\n",
       "   425,\n",
       "   426,\n",
       "   427,\n",
       "   428,\n",
       "   429,\n",
       "   430,\n",
       "   431,\n",
       "   432,\n",
       "   433,\n",
       "   434,\n",
       "   435,\n",
       "   436,\n",
       "   437,\n",
       "   438,\n",
       "   439,\n",
       "   440,\n",
       "   441,\n",
       "   442,\n",
       "   443,\n",
       "   444,\n",
       "   445,\n",
       "   446,\n",
       "   447,\n",
       "   448,\n",
       "   449,\n",
       "   450,\n",
       "   451,\n",
       "   452,\n",
       "   453,\n",
       "   454,\n",
       "   455,\n",
       "   456,\n",
       "   457,\n",
       "   458,\n",
       "   459,\n",
       "   460,\n",
       "   461,\n",
       "   462,\n",
       "   463,\n",
       "   464,\n",
       "   465,\n",
       "   466,\n",
       "   467,\n",
       "   468,\n",
       "   469,\n",
       "   470,\n",
       "   471,\n",
       "   472,\n",
       "   473,\n",
       "   474,\n",
       "   475,\n",
       "   476,\n",
       "   477,\n",
       "   478,\n",
       "   479,\n",
       "   480,\n",
       "   481,\n",
       "   483,\n",
       "   484,\n",
       "   485,\n",
       "   486,\n",
       "   487,\n",
       "   488,\n",
       "   489,\n",
       "   490,\n",
       "   491,\n",
       "   492,\n",
       "   493,\n",
       "   494,\n",
       "   495,\n",
       "   496,\n",
       "   497,\n",
       "   498,\n",
       "   499,\n",
       "   500,\n",
       "   501,\n",
       "   502,\n",
       "   503,\n",
       "   504,\n",
       "   505,\n",
       "   506,\n",
       "   507,\n",
       "   508,\n",
       "   509,\n",
       "   510,\n",
       "   511,\n",
       "   512,\n",
       "   514,\n",
       "   515,\n",
       "   516,\n",
       "   517,\n",
       "   518,\n",
       "   519,\n",
       "   520,\n",
       "   521,\n",
       "   522,\n",
       "   523,\n",
       "   524,\n",
       "   525,\n",
       "   526,\n",
       "   527,\n",
       "   528,\n",
       "   529,\n",
       "   530,\n",
       "   531,\n",
       "   532,\n",
       "   533,\n",
       "   534,\n",
       "   535,\n",
       "   536,\n",
       "   537,\n",
       "   538,\n",
       "   539,\n",
       "   540,\n",
       "   541,\n",
       "   542,\n",
       "   543,\n",
       "   544,\n",
       "   545,\n",
       "   546,\n",
       "   547,\n",
       "   548,\n",
       "   549,\n",
       "   550,\n",
       "   551,\n",
       "   552,\n",
       "   553,\n",
       "   554,\n",
       "   555,\n",
       "   556,\n",
       "   557,\n",
       "   558,\n",
       "   559,\n",
       "   560,\n",
       "   561,\n",
       "   562,\n",
       "   563,\n",
       "   565,\n",
       "   566,\n",
       "   567,\n",
       "   568,\n",
       "   569,\n",
       "   570,\n",
       "   571,\n",
       "   572,\n",
       "   573,\n",
       "   574,\n",
       "   575,\n",
       "   576,\n",
       "   577,\n",
       "   578,\n",
       "   579,\n",
       "   580,\n",
       "   581,\n",
       "   582,\n",
       "   583,\n",
       "   584,\n",
       "   585,\n",
       "   586,\n",
       "   587,\n",
       "   588,\n",
       "   589,\n",
       "   590,\n",
       "   591,\n",
       "   592,\n",
       "   594,\n",
       "   595,\n",
       "   596,\n",
       "   597,\n",
       "   598,\n",
       "   599,\n",
       "   600,\n",
       "   601,\n",
       "   602,\n",
       "   603,\n",
       "   604,\n",
       "   605,\n",
       "   606,\n",
       "   607,\n",
       "   608,\n",
       "   609,\n",
       "   610,\n",
       "   611,\n",
       "   612,\n",
       "   613,\n",
       "   614,\n",
       "   615,\n",
       "   616,\n",
       "   617,\n",
       "   618,\n",
       "   619,\n",
       "   621,\n",
       "   622,\n",
       "   623,\n",
       "   624,\n",
       "   625,\n",
       "   626,\n",
       "   627,\n",
       "   628,\n",
       "   629,\n",
       "   630,\n",
       "   631,\n",
       "   632,\n",
       "   633,\n",
       "   634,\n",
       "   635,\n",
       "   636,\n",
       "   637,\n",
       "   638,\n",
       "   639,\n",
       "   640,\n",
       "   641,\n",
       "   642,\n",
       "   643,\n",
       "   644,\n",
       "   645,\n",
       "   646,\n",
       "   647,\n",
       "   648,\n",
       "   649,\n",
       "   651,\n",
       "   652,\n",
       "   653,\n",
       "   654,\n",
       "   655,\n",
       "   656,\n",
       "   657,\n",
       "   658,\n",
       "   659,\n",
       "   660,\n",
       "   661,\n",
       "   662,\n",
       "   663,\n",
       "   664,\n",
       "   665,\n",
       "   666,\n",
       "   667,\n",
       "   668,\n",
       "   669,\n",
       "   670,\n",
       "   671,\n",
       "   672,\n",
       "   673,\n",
       "   674,\n",
       "   675,\n",
       "   676,\n",
       "   677,\n",
       "   678,\n",
       "   679,\n",
       "   680,\n",
       "   681,\n",
       "   682,\n",
       "   683,\n",
       "   684,\n",
       "   685,\n",
       "   686,\n",
       "   687,\n",
       "   688,\n",
       "   689,\n",
       "   690,\n",
       "   691,\n",
       "   692,\n",
       "   693,\n",
       "   694,\n",
       "   695,\n",
       "   696,\n",
       "   697,\n",
       "   698,\n",
       "   699,\n",
       "   700,\n",
       "   701,\n",
       "   702,\n",
       "   703,\n",
       "   704,\n",
       "   705,\n",
       "   706,\n",
       "   707,\n",
       "   708,\n",
       "   709,\n",
       "   710,\n",
       "   711,\n",
       "   712,\n",
       "   713,\n",
       "   714,\n",
       "   715,\n",
       "   716,\n",
       "   717,\n",
       "   718,\n",
       "   719,\n",
       "   720,\n",
       "   721,\n",
       "   722,\n",
       "   723,\n",
       "   724,\n",
       "   726,\n",
       "   727,\n",
       "   729,\n",
       "   730,\n",
       "   731,\n",
       "   732,\n",
       "   733,\n",
       "   734,\n",
       "   735,\n",
       "   736,\n",
       "   737,\n",
       "   738,\n",
       "   739,\n",
       "   740,\n",
       "   741,\n",
       "   742,\n",
       "   743,\n",
       "   744,\n",
       "   745,\n",
       "   746,\n",
       "   747,\n",
       "   748,\n",
       "   749,\n",
       "   750,\n",
       "   751,\n",
       "   752,\n",
       "   753,\n",
       "   754,\n",
       "   755,\n",
       "   756,\n",
       "   757,\n",
       "   758,\n",
       "   759,\n",
       "   760,\n",
       "   761,\n",
       "   762,\n",
       "   763,\n",
       "   764,\n",
       "   765,\n",
       "   766,\n",
       "   767,\n",
       "   768,\n",
       "   769,\n",
       "   770,\n",
       "   771,\n",
       "   772,\n",
       "   773,\n",
       "   774,\n",
       "   775,\n",
       "   776,\n",
       "   777,\n",
       "   778,\n",
       "   779,\n",
       "   780,\n",
       "   781,\n",
       "   782,\n",
       "   783,\n",
       "   784,\n",
       "   785,\n",
       "   786,\n",
       "   787,\n",
       "   788,\n",
       "   789,\n",
       "   790,\n",
       "   792,\n",
       "   793,\n",
       "   795,\n",
       "   796,\n",
       "   797,\n",
       "   798,\n",
       "   799,\n",
       "   800,\n",
       "   801,\n",
       "   802,\n",
       "   803,\n",
       "   804,\n",
       "   805,\n",
       "   806,\n",
       "   807,\n",
       "   808,\n",
       "   809,\n",
       "   810,\n",
       "   811,\n",
       "   812,\n",
       "   813,\n",
       "   814,\n",
       "   815,\n",
       "   816,\n",
       "   817,\n",
       "   818,\n",
       "   819,\n",
       "   820,\n",
       "   822,\n",
       "   823,\n",
       "   824,\n",
       "   825,\n",
       "   826,\n",
       "   827,\n",
       "   828,\n",
       "   829,\n",
       "   831,\n",
       "   832,\n",
       "   834,\n",
       "   835,\n",
       "   836,\n",
       "   837,\n",
       "   838,\n",
       "   839,\n",
       "   840,\n",
       "   842,\n",
       "   843,\n",
       "   844,\n",
       "   845,\n",
       "   846,\n",
       "   847,\n",
       "   848,\n",
       "   ...],\n",
       "  'sample_values': [163,\n",
       "   126,\n",
       "   113,\n",
       "   78,\n",
       "   71,\n",
       "   51,\n",
       "   50,\n",
       "   47,\n",
       "   40,\n",
       "   40,\n",
       "   37,\n",
       "   36,\n",
       "   30,\n",
       "   28,\n",
       "   25,\n",
       "   23,\n",
       "   22,\n",
       "   19,\n",
       "   19,\n",
       "   14,\n",
       "   13,\n",
       "   13,\n",
       "   13,\n",
       "   12,\n",
       "   12,\n",
       "   11,\n",
       "   11,\n",
       "   11,\n",
       "   10,\n",
       "   10,\n",
       "   10,\n",
       "   8,\n",
       "   7,\n",
       "   7,\n",
       "   7,\n",
       "   6,\n",
       "   5,\n",
       "   5,\n",
       "   5,\n",
       "   4,\n",
       "   4,\n",
       "   4,\n",
       "   3,\n",
       "   3,\n",
       "   3,\n",
       "   3,\n",
       "   3,\n",
       "   3,\n",
       "   3,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   2,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   1,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   0,\n",
       "   ...]}]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sample_otu_list=[]\n",
    "sample_otu_list.append(sample_otu_dict)\n",
    "sample_otu_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}