notebooks/tutorial/s3a_get_participants_complexes.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Tutorial 3a) Breaking down complexes to get thier participants\n",
    "\n",
    "[**Reactome Tutorial**: Breaking down complexes and sets to get thier participants](https://reactome.org/dev/graph-database/extract-participating-molecules#complexes-sets-participants)\n",
    "\n",
    "## Step 1) [Connect to Neo4j loaded with the Reactome Knowledgebase](https://github.com/dvklopfenstein/reactome_neo4j_py/blob/master/doc/md/README_gdbdr.md)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from neo4j import GraphDatabase\n",
    "\n",
    "neo4j_url = 'bolt://localhost:7687'\n",
    "neo4j_usr = 'neo4j'\n",
    "neo4j_password = 'myneo4j_password'\n",
    "\n",
    "gdbdr = GraphDatabase.driver(neo4j_url, auth=(neo4j_usr, neo4j_password))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    " ## Step 2) First Query\n",
    " ###  Get the complexes directly below the complex, R-HSA-983126 _Ag-substrate:E3:E2:Ub [cytosol]_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    R-HSA-976075 CandidateSet E3 ligases in proteasomal degradation [cytosol]\n",
      "    R-ALL-983035 OtherEntity antigenic substrate [cytosol]\n",
      "    R-HSA-976165 Complex Ubiquitin:E2 conjugating enzymes [cytosol]\n"
     ]
    }
   ],
   "source": [
    "query = ('MATCH (Complex{stId:\"R-HSA-983126\"})-[:hasComponent]->(pe:PhysicalEntity)'\n",
    "         'RETURN '\n",
    "         'pe.stId AS ID, pe.displayName AS Name, pe.schemaClass as schemaClass')\n",
    "\n",
    "with gdbdr.session() as session:\n",
    "    for dct in session.run(query).data():\n",
    "        print(\"    {ID} {schemaClass} {Name}\".format(**dct))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Step 3) Second Query\n",
    "\n",
    "### Get all items at all levels of hierarchy inside the complex, R-HSA-983126,_Ag-substrate:E3:E2:Ub [cytosol]_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n",
      "    R-HSA-976165  Complex                       Ubiquitin:E2 conjugating enzymes [cytosol]\n"
     ]
    }
   ],
   "source": [
    "query = ('MATCH (Complex{stId:\"R-HSA-983126\"})-[:hasComponent|hasMember|hasCandidate*]->(pe:PhysicalEntity)'\n",
    "         'RETURN pe.stId AS ID, pe.displayName AS Name, pe.schemaClass as schemaClass')\n",
    "\n",
    "with gdbdr.session() as session:\n",
    "    for dct in session.run(query).data():\n",
    "        print(\"    {ID:13} {schemaClass:29} {Name}\".format(**dct))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Copyright (C) 2018-present, DV Klopfenstein. All rights reserved."
   ]
  }
 ],
 "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}