Newer
Older
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Working with pybis"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## connect to openBIS\n",
"(using stored session token ~/.pybis/localhost.token)"
]
},
{
"cell_type": "code",
"execution_count": 86,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"'vermeul-170213105629815x0CF2F2467FF08E65E79A1E25E0334BC3'"
"execution_count": 86,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)\n",
"o.token"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"check if session is still active:"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"True"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.is_session_active()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"login with a password if the token is no longer valid - and store the token"
]
},
{
"cell_type": "code",
"execution_count": 85,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"········\n"
]
},
{
"data": {
"text/plain": [
"'vermeul-170213105629815x0CF2F2467FF08E65E79A1E25E0334BC3'"
"execution_count": 85,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o = Openbis('https://localhost:8443', verify_certificates=False)\n",
"password = getpass.getpass()\n",
"o.login('vermeul',password, save_token=True)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"you can connect to another openBIS instance if you like to:"
]
},
{
"cell_type": "code",
"execution_count": 82,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"········\n"
]
},
{
"data": {
"text/plain": [
"'vermeul-170213105248365xBB06092567F9EE09864C78CDBDB14CA9'"
]
},
"execution_count": 82,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from pybis import Openbis\n",
"import getpass\n",
"o2 = Openbis('https://sprint-openbis.ethz.ch:8443', verify_certificates=False)\n",
"password = getpass.getpass()\n",
"o2.login('vermeul',password)\n",
"o2.token"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"disconnnect (or rather: make the session key invalid):"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"o2.logout()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## get general information about openBIS"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Data Store Servers (DSS)"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>downloadUrl</th>\n",
" <th>hostUrl</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>DSS1</td>\n",
" <td>https://localhost:8444/datastore_server</td>\n",
" <td>https://localhost:8444</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" code downloadUrl hostUrl\n",
"0 DSS1 https://localhost:8444/datastore_server https://localhost:8444"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_datastores()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"list all available spaces:"
]
},
{
"cell_type": "code",
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>description</th>\n",
" <th>registrationDate</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>ANOTHER_SPACE_NAME</td>\n",
" <td>another space description</td>\n",
" <td>2016-07-15 02:54:45</td>\n",
" <td>2016-07-15 02:54:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>MATERIALS</td>\n",
" <td>None</td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>METHODS</td>\n",
" <td>None</td>\n",
" <td>2016-06-24 11:47:53</td>\n",
" <td>2016-06-24 11:47:53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>MY_NEW_SPACE</td>\n",
" <td>this is yet another space</td>\n",
" <td>2016-07-15 03:02:14</td>\n",
" <td>2016-07-15 03:02:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>VERMEUL</td>\n",
" <td>Space for user vermeul</td>\n",
" <td>2016-06-24 11:50:48</td>\n",
" <td>2016-06-24 11:50:48</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f7ff39e4fd0>"
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_spaces()"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>permId</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>description</td> <td>this is yet another space</td> </tr><tr> <td>registrator</td> <td>vermeul</td> </tr><tr> <td>registrationDate</td> <td>2016-07-15 03:02:14</td> </tr><tr> <td>modificationDate</td> <td>2016-07-15 03:02:14</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Space at 0x7f7ff5194898>"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sp = o.get_space('my_new_space')\n",
"# another way: get space number 3 from the list above.\n",
"# sp = o.get_spaces()[3]\n",
"# sp = o.get_spaces()['MY_NEW_SPACE']\n",
{
"cell_type": "markdown",
"metadata": {},
"source": [
"list all the projects within that space"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>leader</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td>\n",
" <td>20160926234755430-363</td>\n",
" <td>None</td>\n",
" <td>vermeul</td>\n",
" <td>2016-09-26 23:47:55</td>\n",
" <td>admin</td>\n",
" <td>2017-01-20 23:57:45</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f7ff39e8940>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"get details of the first project in this list"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>VERMEUL_PROJECT</td> </tr><tr> <td>description</td> <td>my first project in my space...</td> </tr><tr> <td>permId</td> <td>20160926234755430-363</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>leader</td> <td></td> </tr><tr> <td>registrator</td> <td>vermeul</td> </tr><tr> <td>registrationDate</td> <td>2016-09-26 23:47:55</td> </tr><tr> <td>modifier</td> <td>admin</td> </tr><tr> <td>modificationDate</td> <td>2017-01-20 23:57:45</td> </tr><tr><td>attachments</td><td>pybis.pdf</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Project at 0x7f6a2776dbe0>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pr = sp.get_projects()[0]\n",
"# this works too:\n",
"# pr = sp.get_projects()['/MY_NEW_SPACE/VERMEUL_PROJECT']\n",
"pr"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"**TAB completion**: list all possible attributes and methods by hitting the TAB key"
]
},
{
"cell_type": "code",
},
"outputs": [],
"source": [
"# try it: put the cursor after the dot and press TAB\n",
"pr."
"cell_type": "markdown",
"metadata": {},
"Fetch the experiments that belong to a project"
]
},
{
"cell_type": "code",
"execution_count": 87,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"pr = o.get_project('/MY_NEW_SPACE/VERMEUL_PROJECT')"
]
},
{
"cell_type": "code",
"execution_count": 88,
"collapsed": false,
"scrolled": true
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>project</th>\n",
" <th>type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/EXP_NEW</td>\n",
" <td>20170127005816666-430</td>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>None</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-27 00:58:17</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-27 00:58:17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
" <td>20160924020719018-358</td>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>None</td>\n",
" <td>vermeul</td>\n",
" <td>2016-09-24 02:07:19</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-09 00:05:43</td>\n",
" </tr>\n",
" <tr>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPER...</td>\n",
" <td>20161121013609807-402</td>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>None</td>\n",
" <td>vermeul</td>\n",
" <td>2016-11-21 01:36:10</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-20 23:41:42</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"0\t/MY_NEW_SPACE/VERMEUL_PROJECT/EXP_NEW\n",
"1\t/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4\n",
"2\t/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT"
"execution_count": 88,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"exs = pr.get_experiments()\n",
"exs"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"... using a different approach"
]
},
{
"cell_type": "code",
"execution_count": 90,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>project</th>\n",
" <th>type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/EXP_NEW</td>\n",
" <td>20170127005816666-430</td>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>None</td>\n",
" <td>2017-01-27 00:58:17</td>\n",
" <td>2017-01-27 00:58:17</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
" <td>20160924020719018-358</td>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>None</td>\n",
" <td>2016-09-24 02:07:19</td>\n",
" <td>2017-01-09 00:05:43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPER...</td>\n",
" <td>20161121013609807-402</td>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>None</td>\n",
" <td>2016-11-21 01:36:10</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-20 23:41:42</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
"0\t/MY_NEW_SPACE/VERMEUL_PROJECT/EXP_NEW\n",
"1\t/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4\n",
"2\t/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT"
"execution_count": 90,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_experiments(project='/MY_NEW_SPACE/VERMEUL_PROJECT')"
"cell_type": "markdown",
"metadata": {},
"**get vocabulary terms**"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>vocabulary term</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>vocabulary</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>PBLUESCRIPT_II_KS_PLUS</td> <td>pBluescript II KS +</td> <td>Commercial vector for cloning in bacteria (Stratagene)</td> <td>BACKBONE</td> </tr><tr> <td>PSPPOLY_A</td> <td>pSPpoly(A)</td> <td>Standard cloning vector. It can be used for in vitro trascription from SP6 promoter. It contains a poly(A) to generate poly(A)+ transcripts in vitro (Promega)</td> <td>BACKBONE</td> </tr><tr> <td>PRS30Y</td> <td>pRS30y</td> <td>Integrative yeast shuttle vector from Sikorski et al, 1989</td> <td>BACKBONE</td> </tr><tr> <td>PRS31Y</td> <td>pRS31y</td> <td>Centromeric yeast shuttle vector from Sikorski et al, 1989</td> <td>BACKBONE</td> </tr><tr> <td>PRS40Y</td> <td>pRS40y</td> <td>Integrative yeast shuttle vector from Sikorski et al, 1992</td> <td>BACKBONE</td> </tr><tr> <td>PRS41Y</td> <td>pRS41y</td> <td>Centromeric yeast shuttle vector from Sikorski et al, 1992</td> <td>BACKBONE</td> </tr><tr> <td>PRS42Y</td> <td>pRS42y</td> <td>2-micron-based yeast shuttle vector from Sikorski et al, 1992</td> <td>BACKBONE</td> </tr><tr> <td>UNKNOWN</td> <td>unknown</td> <td>unknown vector</td> <td>BACKBONE</td> </tr><tr> <td>PGEX4T1</td> <td>pGEX4T1</td> <td>Vector for bacterial expression</td> <td>BACKBONE</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.masterdata.Vocabulary at 0x7f3140fafeb8>"
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"x = o.get_terms('Backbone')\n",
"x"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## get information about general types"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"OpenBIS categorizes some of its entities in «types»:\n",
"\n",
"* sample type\n",
"* experiment type\n",
"* material type\n",
"* dataset type\n",
"\n",
"The types define the collection of **properties** that can be later assigned to a sample, experiment or dataset."
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>description</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>DEFAULT_EXPERIMENT</td>\n",
" <td>Default Experiment</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>MATERIALS</td>\n",
" <td>Folder used to organize samples in the Invento...</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>METHODS</td>\n",
" <td>Folder used to organize samples in the Invento...</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>BOARDS</td>\n",
" <td>Folder used to organize boards</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>UNKNOWN</td>\n",
" <td>Unknown</td>\n",
" <td>2016-06-24 10:47:01</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
"<pybis.pybis.Things at 0x7f7ff3996a20>"
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_experiment_types()"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>description</th>\n",
" <th>generatedCodePrefix</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>ANTIBODY</td>\n",
" <td>ANT</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>CHEMICAL</td>\n",
" <td>CHE</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>ENZYME</td>\n",
" <td>ENZ</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>MEDIA</td>\n",
" <td>MED</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>SOLUTION_BUFFER</td>\n",
" <td>SOL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>OLIGO</td>\n",
" <td>OLI</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>RNA</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>PLASMID</td>\n",
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
" <td>PLA</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>BACTERIA</td>\n",
" <td></td>\n",
" <td>BAC</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>YEAST</td>\n",
" <td></td>\n",
" <td>YEA</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>CELL_LINE</td>\n",
" <td></td>\n",
" <td>CEL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>FLY</td>\n",
" <td></td>\n",
" <td>FLY</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>EXPERIMENTAL_STEP</td>\n",
" <td></td>\n",
" <td>EXP</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>GENERAL_PROTOCOL</td>\n",
" <td></td>\n",
" <td>GEN</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>PCR_PROTOCOL</td>\n",
" <td></td>\n",
" <td>PCR</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>WESTERN_BLOTTING_PROTOCOL</td>\n",
" <td></td>\n",
" <td>WES</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>DRAWING_BOARD</td>\n",
" <td></td>\n",
" <td>DRA</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>UNKNOWN</td>\n",
" <td>Unknown</td>\n",
" <td>S</td>\n",
" <td>2016-06-24 10:47:01</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f7ff399dbe0>"
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_sample_types()"
"execution_count": 14,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>description</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>MY_VERY_EXCITING_MATERIAL</td>\n",
" <td>looks like dirt and probably is dirt</td>\n",
" <td>2016-09-24 00:46:19</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
"<pybis.pybis.Things at 0x7f7ff399d518>"
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_material_types()"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>kind</th>\n",
" <th>modificationDate</th>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>ELN_PREVIEW</td>\n",
" <td>ELN Preview image</td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>SEQ_FILE</td>\n",
" <td></td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>RAW_DATA</td>\n",
" <td></td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>ANALYZED_DATA</td>\n",
" <td></td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
" <td>ATTACHMENT</td>\n",
" <td></td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>DRAWING_BOARD</td>\n",
" <td></td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:48:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>Jupyter Analysis Results</td>\n",
" <td>CONTAINER</td>\n",
" <td>2016-06-29 15:29:06</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>Analysis Notebook Files</td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-29 15:29:07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>UNKNOWN</td>\n",
" <td>Unknown</td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-24 10:47:01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>Analysis Results Files</td>\n",
" <td>PHYSICAL</td>\n",
" <td>2016-06-29 15:29:06</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f7ff399d588>"
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_dataset_types()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"to get a more detailed view of an item from the list above, just provide the index number like so:"
]
},
{
"cell_type": "code",
"execution_count": 16,
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"<p>DataSetType: <b>ELN_PREVIEW</b>\n",
"<p>description: ELN Preview image</p>\n",
" \n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>dataType</th>\n",
" <th>mandatory</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <th>name</th> <td>Name</td> <td>Name</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>notes</th> <td>Notes</td> <td>Notes regarding the dataset</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>xmlcomments</th> <td>Comments List</td> <td>Several comments can be added by different users</td> <td>XML</td> <td>False</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.property.PropertyAssignments at 0x7f7ff39e41d0>"
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_dataset_types()[0]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"you can as well use an identifier to get the details:"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"<p>DataSetType: <b>ELN_PREVIEW</b>\n",
"<p>description: ELN Preview image</p>\n",
" \n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>dataType</th>\n",
" <th>mandatory</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <th>name</th> <td>Name</td> <td>Name</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>notes</th> <td>Notes</td> <td>Notes regarding the dataset</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>xmlcomments</th> <td>Comments List</td> <td>Several comments can be added by different users</td> <td>XML</td> <td>False</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
"<pybis.property.PropertyAssignments at 0x7f7ff39e4898>"
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_dataset_type('ELN_PREVIEW')"
"execution_count": 17,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"<p>SampleType: <b>YEAST</b>\n",
"<p>description: </p>\n",
" <p>Code autogenerated: True</p>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>dataType</th>\n",
" <th>mandatory</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <th>name</th> <td>Name</td> <td>Name</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>show_in_project_overview</th> <td>Show in project overview</td> <td>Show in project overview</td> <td>BOOLEAN</td> <td>False</td> </tr><tr> <th>owner</th> <td>Owner</td> <td>Who produced/owned the sample</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>owner_number</th> <td>Owner number</td> <td>Owner number</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>genetic_modification</th> <td>Genetic modifications</td> <td>Genetic modifications composed by the Plasmid ancestors</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>genetic_background</th> <td>Genetic Background</td> <td>Genetic background of the yeast strain</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>mating_type</th> <td>Mating Type</td> <td>Mating type or ploidy of the yeast strain</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>background-specific_markers</th> <td>Background-specific markers</td> <td>Background-specific markers available in the strain for further genetic modifications</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>common_markers</th> <td>Common markers</td> <td>Common markers available in the strain for further genetic modifications</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>endogenous_plasmid</th> <td>Endogenous 2micron plasmid in yeast</td> <td>Presence of an endogenous cir 2micron plasmid</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>origin</th> <td>Origin</td> <td>How the strain/cell line was produced</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>strain_check</th> <td>Strain Check</td> <td>Check done to verify the modifications introduced in the strain</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>source</th> <td>Source</td> <td>Source from where the construct/strain/cell line obtained or purchased, if it was not produced in the lab</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>publication</th> <td>Publication</td> <td>Publication from where the information was first found OR technical sheet given by the manufacturer</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>notes</th> <td>Notes</td> <td>Notes regarding the dataset</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>xmlcomments</th> <td>Comments List</td> <td>Several comments can be added by different users</td> <td>XML</td> <td>False</td> </tr><tr> <th>annotations_state</th> <td>Annotations State</td> <td>Annotations State</td> <td>XML</td> <td>False</td> </tr><tr> <th>storage_names</th> <td>Storage Name</td> <td>Storage Name</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>storage_row</th> <td>Storage Row</td> <td>Storage Row</td> <td>INTEGER</td> <td>False</td> </tr><tr> <th>storage_column</th> <td>Storage Column</td> <td>Storage Column</td> <td>INTEGER</td> <td>False</td> </tr><tr> <th>storage_box_name</th> <td>Storage Box Name</td> <td>Storage Box Name</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>storage_box_size</th> <td>Storage Box Size</td> <td>Storage Box Size</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>storage_user</th> <td>Storage User Id</td> <td>Storage User Id</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>storage_position</th> <td>Storage Position</td> <td>Storage Position</td> <td>VARCHAR</td> <td>False</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.property.PropertyAssignments at 0x7f72f022c9b0>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_sample_type('YEAST')"
"cell_type": "markdown",
"metadata": {},
"**tags**: almost all entities in openBIS can be tagged:"
]
},
{
"cell_type": "code",
"collapsed": false,
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>A_tag</td>\n",
" <td>2016-07-05 23:45:04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>CREATE_JSON_TAG</td>\n",
" <td>2016-06-30 00:36:50</td>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>CREATE_JSON_TAG_2</td>\n",
" <td>2016-07-06 00:07:07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>CREATE_JSON_TAG_3</td>\n",
" <td>2016-07-06 00:07:07</td>\n",
" <th>4</th>\n",
" <td>CREATE_JSON_TAG_blalbal</td>\n",
" <td>2016-11-08 10:24:18</td>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>another_nice_tag</td>\n",
" <td>2016-10-06 14:43:21</td>\n",
" </tr>\n",
" <tr>\n",
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
" <th>6</th>\n",
" <td>another_tag</td>\n",
" <td>2016-10-04 11:29:02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>blblblblblb</td>\n",
" <td>2016-10-06 14:47:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>clue</td>\n",
" <td>2016-09-26 23:48:08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>do</td>\n",
" <td>2016-09-12 23:57:14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>due</td>\n",
" <td>2016-06-30 17:18:11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>fa</td>\n",
" <td>2016-09-12 23:57:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>gimme_a_tag</td>\n",
" <td>2016-11-18 15:20:10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>gimme_one_more</td>\n",
" <td>2016-10-27 02:03:25</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>la</td>\n",
" <td>2016-09-12 23:57:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>mi</td>\n",
" <td>2016-09-12 23:57:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>new_tag</td>\n",
" <td>2016-10-06 10:49:15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>no</td>\n",
" <td>2016-09-26 23:48:08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>one</td>\n",
" <td>2016-11-09 14:27:58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>re</td>\n",
" <td>2016-09-12 23:57:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>so</td>\n",
" <td>2016-09-12 23:57:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>three</td>\n",
" <td>2016-11-09 14:27:58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>ti</td>\n",
" <td>2016-09-12 23:57:29</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>too_late</td>\n",
" <td>2016-10-06 10:56:07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>tre</td>\n",
" <td>2016-06-30 17:18:11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>two</td>\n",
" <td>2016-11-09 14:27:58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>uno</td>\n",
" <td>2016-06-30 17:18:11</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
1426
1427
1428
1429
1430
1431
1432
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
1447
1448
1449
1450
1451
1452
1453
" code registrationDate\n",
"0 A_tag 2016-07-05 23:45:04\n",
"1 CREATE_JSON_TAG 2016-06-30 00:36:50\n",
"2 CREATE_JSON_TAG_2 2016-07-06 00:07:07\n",
"3 CREATE_JSON_TAG_3 2016-07-06 00:07:07\n",
"4 CREATE_JSON_TAG_blalbal 2016-11-08 10:24:18\n",
"5 another_nice_tag 2016-10-06 14:43:21\n",
"6 another_tag 2016-10-04 11:29:02\n",
"7 blblblblblb 2016-10-06 14:47:45\n",
"8 clue 2016-09-26 23:48:08\n",
"9 do 2016-09-12 23:57:14\n",
"10 due 2016-06-30 17:18:11\n",
"11 fa 2016-09-12 23:57:29\n",
"12 gimme_a_tag 2016-11-18 15:20:10\n",
"13 gimme_one_more 2016-10-27 02:03:25\n",
"14 la 2016-09-12 23:57:29\n",
"15 mi 2016-09-12 23:57:29\n",
"16 new_tag 2016-10-06 10:49:15\n",
"17 no 2016-09-26 23:48:08\n",
"18 one 2016-11-09 14:27:58\n",
"19 re 2016-09-12 23:57:29\n",
"20 so 2016-09-12 23:57:29\n",
"21 three 2016-11-09 14:27:58\n",
"22 ti 2016-09-12 23:57:29\n",
"23 too_late 2016-10-06 10:56:07\n",
"24 tre 2016-06-30 17:18:11\n",
"25 two 2016-11-09 14:27:58\n",
"26 uno 2016-06-30 17:18:11"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"**get the terms of a (controlled) vocabulary.**\n",
"\n",
"Some assigned properties have a controlled vocabulary, which means you can not enter anything you want."
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>vocabulary term</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>vocabulary</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>A</td> <td>a</td> <td>None</td> <td>MATING_TYPE</td> </tr><tr> <td>ALPHA</td> <td>alpha</td> <td>None</td> <td>MATING_TYPE</td> </tr><tr> <td>DIPLOID</td> <td>diploid</td> <td>None</td> <td>MATING_TYPE</td> </tr><tr> <td>UNKNOWN</td> <td>unknown</td> <td>None</td> <td>MATING_TYPE</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.masterdata.Vocabulary at 0x7fca603910f0>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_terms('MATING_TYPE')"
"cell_type": "markdown",
"metadata": {},
"**list all the deleted items in openBIS.**\n",
"\n",
"*TODO*: fetch the deletion date"
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
1532
1533
1534
1535
1536
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
1561
1562
1563
1564
1565
1566
1567
1568
1569
1570
1571
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>permId</th>\n",
" <th>reason</th>\n",
" <th>type</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>20160629183649792-77</td>\n",
" <td>no jolly good reason</td>\n",
" <td>as.dto.sample.id.SamplePermId</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>20160629185740101-79</td>\n",
" <td>no jolly good reason</td>\n",
" <td>as.dto.sample.id.SamplePermId</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>20160705234127476-205</td>\n",
" <td>jjj</td>\n",
" <td>as.dto.sample.id.SamplePermId</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>20160630111810821-87</td>\n",
" <td>no specific reason</td>\n",
" <td>as.dto.sample.id.SamplePermId</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>20160926234807546-364</td>\n",
" <td>no longer needed</td>\n",
" <td>as.dto.experiment.id.ExperimentPermId</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>20161004215320704-370</td>\n",
" <td>it was just an experiment</td>\n",
" <td>as.dto.experiment.id.ExperimentPermId</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
" permId reason \\\n",
"0 20160629183649792-77 no jolly good reason \n",
"1 20160629185740101-79 no jolly good reason \n",
"2 20160705234127476-205 jjj \n",
"3 20160630111810821-87 no specific reason \n",
"4 20160926234807546-364 no longer needed \n",
"5 20161004215320704-370 it was just an experiment \n",
"\n",
" type \n",
"0 as.dto.sample.id.SamplePermId \n",
"1 as.dto.sample.id.SamplePermId \n",
"2 as.dto.sample.id.SamplePermId \n",
"3 as.dto.sample.id.SamplePermId \n",
"4 as.dto.experiment.id.ExperimentPermId \n",
"5 as.dto.experiment.id.ExperimentPermId "
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"cell_type": "markdown",
"metadata": {},
"## working with projects"
"outputs": [
{
"data": {
"text/plain": [
"'vermeul-170126143455586x8A10E9354784B7ED77C8901A15079664'"
]
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)\n",
"o.token"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"list all projects in a given space."
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"sp = o.get_space('VERMEUL')"
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/VERMEUL/PROJECT_ONE</td>\n",
" <td>20170115220158336-410</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-15 22:01:58</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-26 23:36:43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>/VERMEUL/READY_TO_DELETE</td>\n",
" <td>20170122214024061-421</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-22 21:40:24</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-22 21:40:24</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f882ed7bcf8>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "code",
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>PROJECT_ONE</td> </tr><tr> <td>description</td> <td></td> </tr><tr> <td>permId</td> <td>20170115220158336-410</td> </tr><tr> <td>identifier</td> <td>/VERMEUL/PROJECT_ONE</td> </tr><tr> <td>space</td> <td>VERMEUL</td> </tr><tr> <td>leader</td> <td></td> </tr><tr> <td>registrator</td> <td>vermeul</td> </tr><tr> <td>registrationDate</td> <td>2017-01-15 22:01:58</td> </tr><tr> <td>modifier</td> <td></td> </tr><tr> <td>modificationDate</td> <td>2017-01-26 23:36:43</td> </tr><tr><td>attachments</td><td>IMG_3587.JPG</td></tr>\n",
" "
],
"text/plain": [
"<pybis.pybis.Project at 0x7f882ed87080>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"p = sp.get_projects()[0]\n",
"p"
]
},
{
"cell_type": "code",
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
1776
1777
1778
1779
1780
1781
1782
1783
"execution_count": 8,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"[{'description': None, 'fileName': 'IMG_3587.JPG', 'title': 'just a big mess'}]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"p.attachments"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>fileName</th>\n",
" <th>title</th>\n",
" <th>description</th>\n",
" <th>version</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>IMG_3587.JPG</td>\n",
" <td>just a big mess</td>\n",
" <td>None</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
],
"text/plain": [
" fileName title description version\n",
"0 IMG_3587.JPG just a big mess None 1"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"['localhost/20170115220158336-410/IMG_3587.JPG']"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"p.download_attachments()"
]
},
{
"cell_type": "code",
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"localhost/20170115220158336-410\r\n",
"localhost/20170115220158336-410/IMG_3587.JPG\r\n"
"!find localhost/20170115220158336-410"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"p.add_attachment(fileName='testfile', description= 'another file', title= 'one more attachment')"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>PROJECT_ONE</td> </tr><tr> <td>description</td> <td></td> </tr><tr> <td>permId</td> <td>20170115220158336-410</td> </tr><tr> <td>identifier</td> <td>/VERMEUL/PROJECT_ONE</td> </tr><tr> <td>space</td> <td>VERMEUL</td> </tr><tr> <td>leader</td> <td></td> </tr><tr> <td>registrator</td> <td>vermeul</td> </tr><tr> <td>registrationDate</td> <td>2017-01-15 22:01:58</td> </tr><tr> <td>modifier</td> <td></td> </tr><tr> <td>modificationDate</td> <td>2017-01-24 15:13:08</td> </tr><tr><td>attachments</td><td>IMG_3587.JPG<br/>testfile</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Project at 0x7fc53d9cd780>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Project successfully updated.\n"
]
}
],
"source": [
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## working with experiments"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)"
]
},
{
"cell_type": "markdown",
"**fetching experiments of a specific type containing tags**"
]
},
{
"cell_type": "code",
"collapsed": false,
"scrolled": true
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
1994
1995
1996
1997
1998
1999
2000
2001
2002
2003
2004
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>project</th>\n",
" <th>type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/MATERIALS/YEASTS/MY_FIRST_EXPERIMENT_WITH_PRO...</td>\n",
" <td>20160924015154859-355</td>\n",
" <td>YEASTS</td>\n",
" <td>None</td>\n",
" <td>vermeul</td>\n",
" <td>2016-09-24 01:51:55</td>\n",
" <td>vermeul</td>\n",
" <td>2017-01-27 00:12:25</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"<pybis.pybis.Things at 0x7f21b2d65898>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"exps = o.get_experiments(\n",
" project='YEASTS',\n",
" space='MATERIALS', \n",
" type='DEFAULT_EXPERIMENT',\n",
" tags='*', \n",
" is_finished=True\n",
")\n",
"exps"
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_FIRST_EXPERIMENT_WITH_PROPERTY</td> </tr><tr> <td>permId</td> <td>20160924015154859-355</td> </tr><tr> <td>identifier</td> <td>/MATERIALS/YEASTS/MY_FIRST_EXPERIMENT_WITH_PROPERTY</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>project</td> <td>/MATERIALS/YEASTS</td> </tr><tr> <td>tags</td> <td>['too_late', 'uno']</td> </tr><tr><td>attachments</td><td>testfile</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7fbe86a64748>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"e0 = exps[0]\n",
"e0"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [],
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Experiment successfully updated.\n"
]
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>permId</th>\n",
" <th>properties</th>\n",
" <th>type</th>\n",
" <th>registrationDate</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>20170106004736870-407</td>\n",
" <td>{'NAME': 'dunno'}</td>\n",
" <td>ANALYZED_DATA</td>\n",
" <td>/MATERIALS/YEASTS/MY_FIRST_EXPERIMENT_WITH_PRO...</td>\n",
" <td>None</td>\n",
" <td>2017-01-06 00:47:37</td>\n",
" <td>2017-01-06 00:47:37</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"<pybis.pybis.Things at 0x7fbb3966a4e0>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "code",
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_FIRST_EXPERIMENT_WITH_PROPERTY</td> </tr><tr> <td>permId</td> <td>20160924015154859-355</td> </tr><tr> <td>identifier</td> <td>/MATERIALS/YEASTS/MY_FIRST_EXPERIMENT_WITH_PROPERTY</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>project</td> <td>/MATERIALS/YEASTS</td> </tr><tr> <td>tags</td> <td>['too_late', 'uno']</td> </tr><tr><td>attachments</td><td>testfile</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7fbb39647eb8>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"{'End Date': 'TIMESTAMP', 'syntax': 'YYYY-MM-DD HH:MIN:SS'}"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"e_new = o.new_experiment('DEFAULT_EXPERIMENT')"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"e_new.project ='VERMEUL_PROJECT'"
]
},
{
"cell_type": "code",
"e_new.tags = 'too_late'"
]
},
{
"cell_type": "code",
},
"outputs": [],
"source": [
"e_new.code = 'exp_new'"
]
},
{
"cell_type": "code",
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Experiment successfully created.\n"
]
}
],
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_EXPERIMENT007</td> </tr><tr> <td>permId</td> <td>20161004220718730-373</td> </tr><tr> <td>identifier</td> <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MATERIALS/YEASTS</td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr><td>attachments</td><td>Bildschirmfoto 2016-12-20 um 10.47.26.png<br/>Ein Saurier.txt</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7f3140f55400>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"e = o.get_experiment('/MATERIALS/YEASTS/MY_EXPERIMENT007')\n",
"e"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_EXPERIMENT007</td> </tr><tr> <td>permId</td> <td>20161004220718730-373</td> </tr><tr> <td>identifier</td> <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MATERIALS/YEASTS</td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr><td>attachments</td><td>Bildschirmfoto 2016-12-20 um 10.47.26.png<br/>Ein Saurier.txt</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7fd2241efc18>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_experiment('20161004220718730-373')"
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
2385
2386
2387
2388
2389
2390
2391
2392
2393
2394
2395
2396
2397
2398
2399
2400
2401
2402
2403
2404
2405
2406
2407
2408
2409
2410
2411
2412
2413
2414
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>experiment</th>\n",
" <th>sample_type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/MATERIALS/FLY43</td>\n",
" <td>20170104000802333-404</td>\n",
" <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td>\n",
" <td>FLY</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:02</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>/MATERIALS/FLY45</td>\n",
" <td>20170104000847172-405</td>\n",
" <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td>\n",
" <td>FLY</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:47</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:36:09</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7fd223f3f208>"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": false
},
2427
2428
2429
2430
2431
2432
2433
2434
2435
2436
2437
2438
2439
2440
2441
2442
2443
2444
2445
2446
2447
2448
2449
2450
2451
2452
2453
2454
2455
2456
2457
2458
2459
2460
2461
2462
2463
2464
2465
2466
2467
2468
2469
2470
2471
2472
2473
2474
2475
2476
2477
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>experiment</th>\n",
" <th>sample_type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/MATERIALS/FLY43</td>\n",
" <td>20170104000802333-404</td>\n",
" <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td>\n",
" <td>FLY</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:02</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>/MATERIALS/FLY45</td>\n",
" <td>20170104000847172-405</td>\n",
" <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td>\n",
" <td>FLY</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:47</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:36:09</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7fd223f3f8d0>"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
"o.get_samples(experiment='20161004220718730-373')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"get all experiment with a given property"
"metadata": {
"collapsed": false
},
2497
2498
2499
2500
2501
2502
2503
2504
2505
2506
2507
2508
2509
2510
2511
2512
2513
2514
2515
2516
2517
2518
2519
2520
2521
2522
2523
2524
2525
2526
2527
2528
2529
2530
2531
2532
2533
2534
2535
2536
2537
2538
2539
2540
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>identifier</th>\n",
" <th>project</th>\n",
" <th>type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>MY_EXPERIMENT013</td>\n",
" <td>/MATERIALS/YEASTS/MY_EXPERIMENT013</td>\n",
" <td>YEASTS</td>\n",
" <td>DEFAULT_EXPERIMENT</td>\n",
" <td></td>\n",
" <td>2016-10-04 22:09:15</td>\n",
" <td></td>\n",
" <td>2016-12-23 16:58:43</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7fd223f4c860>"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"o.get_experiments(is_finished=False, name='blast')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### updating an experiment."
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>name</td> <td>blast</td> </tr><tr> <td>show_in_project_overview</td> <td></td> </tr><tr> <td>finished_flag</td> <td>False</td> </tr><tr> <td>experimental_goals</td> <td></td> </tr><tr> <td>grant</td> <td></td> </tr><tr> <td>start_date</td> <td></td> </tr><tr> <td>end_date</td> <td></td> </tr><tr> <td>experimental_results</td> <td></td> </tr><tr> <td>xmlcomments</td> <td></td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.property.PropertyHolder at 0x7f768c61a748>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ex = o.get_experiments(type='DEFAULT_EXPERIMENT')[0]\n",
"ex.p"
]
},
{
"cell_type": "code",
2592
2593
2594
2595
2596
2597
2598
2599
2600
2601
2602
2603
2604
2605
2606
2607
2608
2609
2610
2611
2612
"execution_count": 26,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"ex.set_properties({'FINISHED_FLAG': False})"
]
},
{
"cell_type": "raw",
"metadata": {
"collapsed": false
},
"source": [
"e = o.new_experiment('/MATERIALS/YEASTS', 'my_experiment0815', 'DEFAULT_EXPERIMENT', properties={\"Name\":\"blast\"})"
]
},
{
"cell_type": "code",
"execution_count": 44,
"collapsed": true
},
"outputs": [],
"source": [
"e3.delete(reason='it was just an experiment')"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## working with samples"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)"
]
},
{
"cell_type": "code",
"execution_count": 26,
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>YEA34</td> </tr><tr> <td>permId</td> <td>20161108230958839-384</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/YEA34</td> </tr><tr> <td>type</td> <td>YEAST</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>project</td> <td></td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT</td> </tr><tr> <td>tags</td> <td>['uno']</td> </tr><tr><td>attachments</td><td>Bildschirmfoto 2016-12-20 um 10.47.26.png<br/>testfile</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f9c08388358>"
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sa = o.get_sample('/MY_NEW_SPACE/YEA34')\n",
"sa"
2678
2679
2680
2681
2682
2683
2684
2685
2686
2687
2688
2689
2690
2691
2692
2693
2694
2695
2696
2697
2698
2699
2700
2701
2702
2703
2704
2705
2706
2707
2708
2709
2710
2711
2712
2713
2714
{
"cell_type": "code",
"execution_count": 27,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>name</td> <td></td> </tr><tr> <td>show_in_project_overview</td> <td>False</td> </tr><tr> <td>owner</td> <td></td> </tr><tr> <td>owner_number</td> <td></td> </tr><tr> <td>genetic_modification</td> <td></td> </tr><tr> <td>genetic_background</td> <td></td> </tr><tr> <td>mating_type</td> <td>DIPLOID</td> </tr><tr> <td>background-specific_markers</td> <td></td> </tr><tr> <td>common_markers</td> <td></td> </tr><tr> <td>endogenous_plasmid</td> <td></td> </tr><tr> <td>origin</td> <td></td> </tr><tr> <td>strain_check</td> <td></td> </tr><tr> <td>source</td> <td></td> </tr><tr> <td>publication</td> <td></td> </tr><tr> <td>notes</td> <td></td> </tr><tr> <td>xmlcomments</td> <td></td> </tr><tr> <td>annotations_state</td> <td></td> </tr><tr> <td>storage_names</td> <td></td> </tr><tr> <td>storage_row</td> <td></td> </tr><tr> <td>storage_column</td> <td></td> </tr><tr> <td>storage_box_name</td> <td></td> </tr><tr> <td>storage_box_size</td> <td></td> </tr><tr> <td>storage_user</td> <td></td> </tr><tr> <td>storage_position</td> <td></td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.property.PropertyHolder at 0x7f9c083883c8>"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sa.props"
]
},
{
"cell_type": "code",
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>fileName</th>\n",
" <th>title</th>\n",
" <th>description</th>\n",
" <th>version</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Bildschirmfoto 2016-12-20 um 10.47.26.png</td>\n",
" <td>nocheinfoto</td>\n",
" <td>None</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>testfile</td>\n",
" <td>None</td>\n",
" <td>None</td>\n",
" <td>1</td>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" fileName title description version\n",
"0 Bildschirmfoto 2016-12-20 um 10.47.26.png nocheinfoto None 1\n",
"1 testfile None None 1"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"sa.add_attachment('testfile')"
2783
2784
2785
2786
2787
2788
2789
2790
2791
2792
2793
2794
2795
2796
2797
2798
2799
2800
2801
2802
2803
2804
2805
2806
2807
2808
2809
2810
2811
2812
2813
2814
2815
2816
2817
2818
2819
2820
2821
2822
"execution_count": 17,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Sample successfully updated\n"
]
}
],
"source": [
"sa.save()"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"localhost/20161108230958839-384/Bildschirmfoto 2016-12-20 um 10.47.26.png\n",
"localhost/20161108230958839-384/testfile\n"
]
}
],
"source": [
"sa.download_attachments()"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>experiment</th>\n",
" <th>sample_type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/VERMEUL/ANOTHER_SAMPLE1</td>\n",
" <td>20160706001644827-208</td>\n",
" <td>None</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-07-06 00:16:45</td>\n",
" <td></td>\n",
" <td>2016-11-09 10:18:18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>/VERMEUL/BLAJLSD</td>\n",
" <td>20160630111949369-89</td>\n",
" <td>None</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-06-30 17:19:49</td>\n",
" <td></td>\n",
" <td>2016-06-30 17:19:49</td>\n",
" </tr>\n",
" <tr>\n",
" <td>/MY_NEW_SPACE/CHILD_OF_SAMPLE1</td>\n",
" <td>20160705234504004-206</td>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-07-05 23:45:04</td>\n",
" <td></td>\n",
" <td>2016-10-07 01:05:46</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>20160630105304285-81</td>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-06-30 16:53:04</td>\n",
" <td></td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
2892
2893
2894
2895
2896
2897
2898
2899
2900
2901
2902
2903
2904
2905
2906
2907
2908
2909
2910
2911
2912
2913
2914
2915
2916
2917
2918
2919
2920
2921
2922
2923
2924
2925
2926
2927
2928
2929
2930
2931
2932
" <td>/VERMEUL/OH_WIE_SCHOEN_IST_PANAMA</td>\n",
" <td>20160630110733527-86</td>\n",
" <td>None</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-06-30 17:07:34</td>\n",
" <td></td>\n",
" <td>2016-07-06 00:11:45</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>/VERMEUL/OH_WIE_SCHOEN_IST_PANAMA3</td>\n",
" <td>20160630112720553-90</td>\n",
" <td>None</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-06-30 17:27:21</td>\n",
" <td></td>\n",
" <td>2016-06-30 17:27:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>/VERMEUL/OH_WIE_SCHOEN_IST_PANAMA5</td>\n",
" <td>20160706231053756-211</td>\n",
" <td>None</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-07-06 23:10:54</td>\n",
" <td></td>\n",
" <td>2016-07-06 23:10:54</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>/VERMEUL/YET_ANOTHER_SAMPLE1</td>\n",
" <td>20160706002555747-209</td>\n",
" <td>None</td>\n",
" <td>UNKNOWN</td>\n",
" <td></td>\n",
" <td>2016-07-06 00:25:56</td>\n",
" <td></td>\n",
" <td>2016-11-09 10:18:18</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f2e99f1a518>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_samples(space='VERMEUL', tags=['*'])"
"cell_type": "markdown",
"metadata": {},
"get the first sample of the above list and just display the basic attributes"
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>YEA21</td> </tr><tr> <td>permId</td> <td>20161025010638912-382</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/YEA21</td> </tr><tr> <td>type</td> <td>YEAST</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>['do', 'fa', 're']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f8ff54adb38>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s = o.get_sample('/MY_NEW_SPACE/YEA21')\n",
"s"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Show all the properties assigned to this sample type:"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"<p>SampleType: <b>YEAST</b>\n",
"<p>description: </p>\n",
" <p>Code autogenerated: True</p>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>dataType</th>\n",
" <th>mandatory</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <th>name</th> <td>Name</td> <td>Name</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>show_in_project_overview</th> <td>Show in project overview</td> <td>Show in project overview</td> <td>BOOLEAN</td> <td>False</td> </tr><tr> <th>owner</th> <td>Owner</td> <td>Who produced/owned the sample</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>owner_number</th> <td>Owner number</td> <td>Owner number</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>genetic_modification</th> <td>Genetic modifications</td> <td>Genetic modifications composed by the Plasmid ancestors</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>genetic_background</th> <td>Genetic Background</td> <td>Genetic background of the yeast strain</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>mating_type</th> <td>Mating Type</td> <td>Mating type or ploidy of the yeast strain</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>background-specific_markers</th> <td>Background-specific markers</td> <td>Background-specific markers available in the strain for further genetic modifications</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>common_markers</th> <td>Common markers</td> <td>Common markers available in the strain for further genetic modifications</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>endogenous_plasmid</th> <td>Endogenous 2micron plasmid in yeast</td> <td>Presence of an endogenous cir 2micron plasmid</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>origin</th> <td>Origin</td> <td>How the strain/cell line was produced</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>strain_check</th> <td>Strain Check</td> <td>Check done to verify the modifications introduced in the strain</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>source</th> <td>Source</td> <td>Source from where the construct/strain/cell line obtained or purchased, if it was not produced in the lab</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>publication</th> <td>Publication</td> <td>Publication from where the information was first found OR technical sheet given by the manufacturer</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>notes</th> <td>Notes</td> <td>Notes regarding the dataset</td> <td>MULTILINE_VARCHAR</td> <td>False</td> </tr><tr> <th>xmlcomments</th> <td>Comments List</td> <td>Several comments can be added by different users</td> <td>XML</td> <td>False</td> </tr><tr> <th>annotations_state</th> <td>Annotations State</td> <td>Annotations State</td> <td>XML</td> <td>False</td> </tr><tr> <th>storage_names</th> <td>Storage Name</td> <td>Storage Name</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>storage_row</th> <td>Storage Row</td> <td>Storage Row</td> <td>INTEGER</td> <td>False</td> </tr><tr> <th>storage_column</th> <td>Storage Column</td> <td>Storage Column</td> <td>INTEGER</td> <td>False</td> </tr><tr> <th>storage_box_name</th> <td>Storage Box Name</td> <td>Storage Box Name</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>storage_box_size</th> <td>Storage Box Size</td> <td>Storage Box Size</td> <td>CONTROLLEDVOCABULARY</td> <td>False</td> </tr><tr> <th>storage_user</th> <td>Storage User Id</td> <td>Storage User Id</td> <td>VARCHAR</td> <td>False</td> </tr><tr> <th>storage_position</th> <td>Storage Position</td> <td>Storage Position</td> <td>VARCHAR</td> <td>False</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.property.PropertyAssignments at 0x7f8ff55c26d8>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.type"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"however, you still can check whether the sample type corresponds to a certain string:"
]
},
{
"cell_type": "code",
3055
3056
3057
3058
3059
3060
3061
3062
3063
3064
3065
3066
3067
3068
3069
3070
3071
3072
3073
3074
3075
3076
3077
3078
3079
3080
3081
3082
3083
3084
3085
3086
3087
3088
3089
3090
3091
3092
3093
3094
3095
3096
3097
3098
3099
3100
3101
3102
3103
3104
3105
3106
3107
3108
3109
3110
3111
3112
3113
3114
3115
3116
3117
3118
3119
3120
3121
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"True"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.type == 'YEAST'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"get experiment related to that sample"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_SPECIAL_EXPERIMENT</td> </tr><tr> <td>permId</td> <td>20161121013609807-402</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT</td> </tr><tr> <td>type</td> <td>UNKNOWN</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7f2e99ceee48>"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.experiment"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"<p>ExperimentType: <b>UNKNOWN</b>\n",
"<p>description: Unknown</p>\n",
" \n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>dataType</th>\n",
" <th>mandatory</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" \n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.property.PropertyAssignments at 0x7f2e99cf6ef0>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
]
},
{
"cell_type": "code",
"outputs": [
{
"data": {
"text/plain": [
"True"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"s.experiment.type == 'UNKNOWN'"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
3193
3194
3195
3196
3197
3198
3199
3200
3201
3202
3203
3204
3205
3206
3207
3208
3209
3210
3211
3212
3213
3214
3215
3216
3217
3218
3219
3220
3221
3222
3223
3224
3225
3226
3227
3228
3229
3230
3231
3232
3233
3234
3235
3236
3237
3238
3239
3240
3241
3242
3243
3244
3245
3246
3247
3248
3249
3250
3251
3252
3253
3254
3255
3256
3257
3258
3259
3260
3261
3262
3263
3264
3265
3266
3267
3268
3269
3270
3271
3272
3273
3274
3275
3276
3277
3278
3279
3280
3281
3282
3283
3284
3285
3286
3287
3288
3289
3290
3291
3292
3293
3294
3295
3296
3297
3298
3299
3300
3301
3302
3303
3304
3305
3306
3307
3308
3309
3310
3311
3312
3313
3314
3315
3316
3317
3318
3319
3320
3321
3322
3323
3324
3325
3326
3327
3328
3329
3330
3331
3332
3333
3334
3335
3336
3337
3338
3339
3340
3341
3342
3343
3344
3345
3346
3347
3348
3349
3350
3351
3352
3353
3354
3355
3356
3357
3358
3359
3360
3361
3362
3363
3364
3365
3366
3367
3368
3369
3370
3371
3372
3373
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>space</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" <th>permid</th>\n",
" <th>identifier</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>BACTERIA</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-33</td>\n",
" <td>/MATERIALS/BACTERIA</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>CELL_LINES</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-34</td>\n",
" <td>/MATERIALS/CELL_LINES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>FLIES</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-35</td>\n",
" <td>/MATERIALS/FLIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>PLASMIDS</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-37</td>\n",
" <td>/MATERIALS/PLASMIDS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>POLYNUCLEOTIDES</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-38</td>\n",
" <td>/MATERIALS/POLYNUCLEOTIDES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>PROJECT_ONE</td>\n",
" <td>VERMEUL</td>\n",
" <td></td>\n",
" <td>2017-01-15 22:01:58</td>\n",
" <td></td>\n",
" <td>2017-01-15 22:02:59</td>\n",
" <td>20170115220158336-410</td>\n",
" <td>/VERMEUL/PROJECT_ONE</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>PROTOCOLS</td>\n",
" <td>METHODS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-39</td>\n",
" <td>/METHODS/PROTOCOLS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>REAGENTS</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td>20160624054751885-32</td>\n",
" <td>/MATERIALS/REAGENTS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>VERMEUL_PROJECT</td>\n",
" <td>MY_NEW_SPACE</td>\n",
" <td></td>\n",
" <td>2016-09-26 23:47:55</td>\n",
" <td></td>\n",
" <td>2017-01-09 01:33:37</td>\n",
" <td>20160926234755430-363</td>\n",
" <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>YEASTS</td>\n",
" <td>MATERIALS</td>\n",
" <td></td>\n",
" <td>2016-06-24 11:47:52</td>\n",
" <td></td>\n",
" <td>2016-10-04 22:04:57</td>\n",
" <td>20160624054751885-36</td>\n",
" <td>/MATERIALS/YEASTS</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f2e99b5d9b0>"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_projects()"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>YEA21</td> </tr><tr> <td>permId</td> <td>20161025010638912-382</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/YEA21</td> </tr><tr> <td>type</td> <td>YEAST</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>['do', 'fa', 're']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f8ff55c2e10>"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"list all the properties (p) of a given sample"
]
},
{
"cell_type": "code",
"execution_count": 8,
3384
3385
3386
3387
3388
3389
3390
3391
3392
3393
3394
3395
3396
3397
3398
3399
3400
3401
3402
3403
3404
3405
3406
3407
3408
3409
3410
3411
3412
3413
3414
3415
3416
3417
3418
3419
3420
3421
3422
3423
3424
3425
3426
3427
3428
3429
3430
3431
3432
3433
3434
3435
3436
3437
3438
3439
3440
3441
3442
3443
3444
3445
3446
3447
3448
3449
3450
3451
3452
3453
3454
3455
3456
3457
3458
3459
3460
3461
3462
3463
3464
3465
3466
3467
3468
3469
3470
3471
3472
3473
3474
3475
3476
3477
3478
3479
3480
3481
3482
3483
3484
3485
3486
3487
3488
3489
3490
3491
3492
3493
3494
3495
3496
3497
3498
3499
3500
3501
3502
3503
3504
3505
3506
3507
3508
3509
3510
3511
3512
3513
3514
3515
3516
3517
3518
3519
3520
3521
3522
3523
3524
3525
3526
3527
3528
3529
3530
3531
3532
3533
3534
3535
3536
3537
3538
3539
3540
3541
3542
3543
3544
3545
3546
3547
3548
3549
3550
3551
3552
3553
3554
3555
3556
3557
3558
3559
3560
3561
3562
3563
3564
3565
3566
3567
3568
3569
3570
3571
3572
3573
3574
3575
3576
3577
3578
3579
3580
3581
3582
3583
3584
3585
3586
3587
3588
3589
3590
3591
3592
3593
3594
3595
3596
3597
3598
3599
3600
3601
3602
3603
3604
3605
3606
3607
3608
3609
3610
3611
3612
3613
3614
3615
3616
3617
3618
3619
3620
3621
3622
3623
3624
3625
3626
3627
3628
3629
3630
3631
3632
3633
3634
3635
3636
3637
3638
3639
3640
3641
3642
3643
3644
3645
3646
3647
3648
3649
3650
3651
3652
3653
3654
3655
3656
3657
3658
3659
3660
3661
3662
3663
3664
3665
3666
3667
3668
3669
3670
3671
3672
3673
3674
3675
3676
3677
3678
3679
3680
3681
3682
3683
3684
3685
3686
3687
3688
3689
3690
3691
3692
3693
3694
3695
3696
3697
3698
3699
3700
3701
3702
3703
3704
3705
3706
3707
3708
3709
3710
3711
3712
3713
3714
3715
3716
3717
3718
3719
3720
3721
3722
3723
3724
3725
3726
3727
3728
3729
3730
3731
3732
3733
3734
3735
3736
3737
3738
3739
3740
3741
3742
3743
3744
3745
3746
3747
3748
3749
3750
3751
3752
3753
3754
3755
3756
3757
3758
3759
3760
3761
3762
3763
3764
3765
3766
3767
3768
3769
3770
3771
3772
3773
3774
3775
3776
3777
3778
3779
3780
3781
3782
3783
3784
3785
3786
3787
3788
3789
3790
3791
3792
3793
3794
3795
3796
3797
3798
3799
3800
3801
3802
3803
3804
3805
3806
3807
3808
3809
3810
3811
3812
3813
3814
3815
3816
3817
3818
3819
3820
3821
3822
3823
3824
3825
3826
3827
3828
3829
3830
3831
3832
3833
3834
3835
3836
3837
3838
3839
3840
3841
3842
3843
3844
3845
3846
3847
3848
3849
3850
3851
3852
3853
3854
3855
3856
3857
3858
3859
3860
3861
3862
3863
3864
3865
3866
3867
3868
3869
3870
3871
3872
3873
3874
3875
3876
3877
3878
3879
3880
3881
3882
3883
3884
3885
3886
3887
3888
3889
3890
3891
3892
3893
3894
3895
3896
3897
3898
3899
3900
3901
3902
3903
3904
3905
3906
3907
3908
3909
3910
3911
3912
3913
3914
3915
3916
3917
3918
3919
3920
3921
3922
3923
3924
3925
3926
3927
3928
3929
3930
3931
3932
3933
3934
3935
3936
3937
3938
3939
3940
3941
3942
3943
3944
3945
3946
3947
3948
3949
3950
3951
3952
3953
3954
3955
3956
3957
3958
3959
3960
3961
3962
3963
3964
3965
3966
3967
3968
3969
3970
3971
3972
3973
3974
3975
3976
3977
3978
3979
3980
3981
3982
3983
3984
3985
3986
3987
3988
3989
3990
3991
3992
3993
3994
3995
3996
3997
3998
3999
4000
4001
4002
4003
4004
4005
4006
4007
4008
4009
4010
4011
4012
4013
4014
4015
4016
4017
4018
4019
4020
4021
4022
4023
4024
4025
4026
4027
4028
4029
4030
4031
4032
4033
4034
4035
4036
4037
4038
4039
4040
4041
4042
4043
4044
4045
4046
4047
4048
4049
4050
4051
4052
4053
4054
4055
4056
4057
4058
4059
4060
4061
4062
4063
4064
4065
4066
4067
4068
4069
4070
4071
4072
4073
4074
4075
4076
4077
4078
4079
4080
4081
4082
4083
4084
4085
4086
4087
4088
4089
4090
4091
4092
4093
4094
4095
4096
4097
4098
4099
4100
4101
4102
4103
4104
4105
4106
4107
4108
4109
4110
4111
4112
4113
4114
4115
4116
4117
4118
4119
4120
4121
4122
4123
4124
4125
4126
4127
4128
4129
4130
4131
4132
4133
4134
4135
4136
4137
4138
4139
4140
4141
4142
4143
4144
4145
4146
4147
4148
4149
4150
4151
4152
4153
4154
4155
4156
4157
4158
4159
4160
4161
4162
4163
4164
4165
4166
4167
4168
4169
4170
4171
4172
4173
4174
4175
4176
4177
4178
4179
4180
4181
4182
4183
4184
4185
4186
4187
4188
4189
4190
4191
4192
4193
4194
4195
4196
4197
4198
4199
4200
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>vocabulary term</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>vocabulary</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>URA3_HIS3_LEU2</td> <td>ura3- his3- leu2-</td> <td>The strain is a uracil, histidine, and leucine auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>URA3_HIS3</td> <td>ura3- his3-</td> <td>The strain is a uracil and histidine auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>URA3_LEU2</td> <td>ura3- leu2-</td> <td>The strain is a uracil and leucine auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>URA3</td> <td>ura3-</td> <td>The strain is a uracil auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>HIS3_LEU2</td> <td>his3- leu2-</td> <td>The strain is a histidine and leucine auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>HIS3</td> <td>his3-</td> <td>The strain is a histidine auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>LEU2</td> <td>leu2-</td> <td>The strain is a leucine auxotroph</td> <td>COMMON_MARKERS</td> </tr><tr> <td>NONE</td> <td>none</td> <td>The strain does not have any background-specific auxotrophies</td> <td>COMMON_MARKERS</td> </tr><tr> <td>UNKNOWN</td> <td>unknown</td> <td>No information about the auxotrophy</td> <td>COMMON_MARKERS</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Vocabulary at 0x7f6b74235358>"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.props.common_markers_"
]
},
{
"cell_type": "markdown",
"metadata": {
"collapsed": false
},
"source": [
"fetch just a single property: sample.p.«property_name»"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"'comments: publication in my office'"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.p.publication"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"if you don't know the controlled vocabulary of a property, just add an underscore and press shift-enter:"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>vocabulary term</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>vocabulary</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>A</td> <td>a</td> <td>None</td> <td>MATING_TYPE</td> </tr><tr> <td>ALPHA</td> <td>alpha</td> <td>None</td> <td>MATING_TYPE</td> </tr><tr> <td>DIPLOID</td> <td>diploid</td> <td>None</td> <td>MATING_TYPE</td> </tr><tr> <td>UNKNOWN</td> <td>unknown</td> <td>None</td> <td>MATING_TYPE</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Vocabulary at 0x7efe6097d828>"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.p.mating_type_"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"pybis will automatically check the controlled vocabulary when you assign a value to it:"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {
"collapsed": false
},
"outputs": [
{
"ename": "ValueError",
"evalue": "Value must be one of these terms: A, ALPHA, DIPLOID, UNKNOWN",
"output_type": "error",
"traceback": [
"\u001b[1;31m\u001b[0m",
"\u001b[1;31mValueError\u001b[0mTraceback (most recent call last)",
"\u001b[1;32m<ipython-input-24-d4d5f6a664c5>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0ms\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mmating_type\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m'invalid content'\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[1;32m/vagrant_python/PyBis/pybis/pybis.py\u001b[0m in \u001b[0;36m__setattr__\u001b[1;34m(self, name, value)\u001b[0m\n\u001b[0;32m 2122\u001b[0m \u001b[0mvoc\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_openbis\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_terms\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 2123\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mvalue\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mvoc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2124\u001b[1;33m \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Value must be one of these terms: \"\u001b[0m \u001b[1;33m+\u001b[0m \u001b[1;34m\", \"\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjoin\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mvoc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 2125\u001b[0m \u001b[1;32melif\u001b[0m \u001b[0mdata_type\u001b[0m \u001b[1;32min\u001b[0m \u001b[1;33m(\u001b[0m\u001b[1;34m'INTEGER'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'BOOLEAN'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'VARCHAR'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 2126\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mcheck_datatype\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_type\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
"\u001b[1;31mValueError\u001b[0m: Value must be one of these terms: A, ALPHA, DIPLOID, UNKNOWN"
]
}
],
"source": [
"s.p.mating_type = 'invalid content'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"some properties are of a general type. Again, you can list it by adding an underscore _ :"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"{'Storage Column': 'INTEGER'}"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.p.storage_column_"
]
},
{
"cell_type": "markdown",
"metadata": {
"collapsed": true
},
"source": [
"### alter a sample and its properties"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>FLY45</td> </tr><tr> <td>permId</td> <td>20170104000847172-405</td> </tr><tr> <td>identifier</td> <td>/MATERIALS/FLY45</td> </tr><tr> <td>type</td> <td>FLY</td> </tr><tr> <td>parents</td> <td>['/MATERIALS/FLY43']</td> </tr><tr> <td>children</td> <td>[]</td> </tr><tr> <td>space</td> <td>MATERIALS</td> </tr><tr> <td>experiment</td> <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr><td>attachments</td><td>openBIS JSON-RPC.md</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7faa0c089828>"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sample = o.get_sample('/MATERIALS/FLY45')\n",
"sample"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>property</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>name</td> <td>a fly45 which is the child of fly43</td> </tr><tr> <td>show_in_project_overview</td> <td>False</td> </tr><tr> <td>owner</td> <td></td> </tr><tr> <td>owner_number</td> <td></td> </tr><tr> <td>genetic_modification</td> <td></td> </tr><tr> <td>fly_genotype</td> <td></td> </tr><tr> <td>associated_gene</td> <td></td> </tr><tr> <td>markers</td> <td></td> </tr><tr> <td>origin</td> <td></td> </tr><tr> <td>strain_check</td> <td></td> </tr><tr> <td>source</td> <td></td> </tr><tr> <td>mating_partners</td> <td></td> </tr><tr> <td>publication</td> <td></td> </tr><tr> <td>notes</td> <td></td> </tr><tr> <td>xmlcomments</td> <td><root>\n",
" <commentEntry date=\"1483484927350\" person=\"vermeul\"/>\n",
"</root>\n",
"</td> </tr><tr> <td>annotations_state</td> <td>�(undefined)</td> </tr><tr> <td>storage_names</td> <td></td> </tr><tr> <td>storage_row</td> <td></td> </tr><tr> <td>storage_column</td> <td></td> </tr><tr> <td>storage_box_name</td> <td></td> </tr><tr> <td>storage_box_size</td> <td></td> </tr><tr> <td>storage_user</td> <td></td> </tr><tr> <td>storage_position</td> <td></td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.PropertyHolder at 0x7faa0c089a20>"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sample.props"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>identifier</th>\n",
" <th>permId</th>\n",
" <th>experiment</th>\n",
" <th>sample_type</th>\n",
" <th>registrator</th>\n",
" <th>registrationDate</th>\n",
" <th>modifier</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>/MATERIALS/FLY43</td>\n",
" <td>20170104000802333-404</td>\n",
" <td>/MATERIALS/YEASTS/MY_EXPERIMENT007</td>\n",
" <td>FLY</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:02</td>\n",
" <td></td>\n",
" <td>2017-01-04 00:08:47</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7faa0c0de940>"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"sample.get_parents()"
]
},
{
"cell_type": "code",
"execution_count": 65,
"metadata": {
"collapsed": false
},
"outputs": [
{
"ename": "NameError",
"evalue": "name 'sample' is not defined",
"output_type": "error",
"traceback": [
"\u001b[1;31m\u001b[0m",
"\u001b[1;31mNameError\u001b[0mTraceback (most recent call last)",
"\u001b[1;32m<ipython-input-65-066328cddbd3>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0msample\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_datasets\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[1;31mNameError\u001b[0m: name 'sample' is not defined"
]
}
],
"source": [
"sample.get_datasets()"
]
},
{
"cell_type": "code",
"execution_count": 14,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Files downloaded to: localhost/20170104003608559-406\n"
]
}
],
"source": [
"sample.get_datasets()[0].download()"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"localhost/20170104003608559-406\r\n",
"localhost/20170104003608559-406/original\r\n",
"localhost/20170104003608559-406/original/jupyter_useage_lab.zip\r\n"
]
}
],
"source": [
"!find localhost/20170104003608559-406"
]
},
{
"cell_type": "code",
"execution_count": 19,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"s_up = o.get_sample('/VERMEUL/MY_WONDERFUL_SAMPLE_NAME')"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"s_up.space = 'ANOTHER_SPACE_NAME'"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"s_up.tags = ['one', 'two', 'three']"
]
},
{
"cell_type": "code",
"execution_count": 22,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>identifier</td> <td>/VERMEUL/MY_WONDERFUL_SAMPLE_NAME</td> </tr><tr> <td>permId</td> <td>20160720225637704-262</td> </tr><tr> <td>code</td> <td>MY_WONDERFUL_SAMPLE_NAME</td> </tr><tr> <td>type</td> <td>UNKNOWN</td> </tr><tr> <td>space</td> <td>ANOTHER_SPACE_NAME</td> </tr><tr> <td>project</td> <td>None</td> </tr><tr> <td>experiment</td> <td></td> </tr><tr> <td>parents</td> <td>[]</td> </tr><tr> <td>children</td> <td>[]</td> </tr><tr> <td>tags</td> <td>['one', 'two', 'three']</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7efe60915668>"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s_up"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Sample successfully updated\n"
]
}
],
"source": [
"s_up.save()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### create a new sample"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Experiment\n"
]
},
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>YEAST_COLLECTION_1</td> </tr><tr> <td>permId</td> <td>20160624054739283-9</td> </tr><tr> <td>identifier</td> <td>/MATERIALS/YEASTS/YEAST_COLLECTION_1</td> </tr><tr> <td>type</td> <td>MATERIALS</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MATERIALS/YEASTS</td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7f56f2f17b38>"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_experiments()[31]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"to create a new sample, the sampletype must be specified"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"s_new = o.new_sample(type='YEAST', space='VERMEUL')"
]
},
{
"cell_type": "code",
"execution_count": 25,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td></td> </tr><tr> <td>permId</td> <td></td> </tr><tr> <td>identifier</td> <td></td> </tr><tr> <td>type</td> <td></td> </tr><tr> <td>parents</td> <td></td> </tr><tr> <td>children</td> <td></td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>experiment</td> <td></td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td></td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f8177455898>"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s_new"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"s_new.delete('obsolete')"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_EXPERIMENT4</td> </tr><tr> <td>permId</td> <td>20160924020719018-358</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td> </tr><tr> <td>tags</td> <td>['A_tag', 'another_tag', 'too_late', 'tre']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7f10ecdadd30>"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"e = o.get_experiment('/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4')\n",
"e"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"controlled vocabulary: find out which terms are allowed by adding an underscore to the property."
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>vocabulary term</th>\n",
" <th>label</th>\n",
" <th>description</th>\n",
" <th>vocabulary</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>CROSS</td> <td>cross</td> <td>The strain was produced by crossing two parent strains</td> <td>ORIGIN</td> </tr><tr> <td>TRANSFORMATION</td> <td>transformation</td> <td>The strain/ cell line was obtained by transformation</td> <td>ORIGIN</td> </tr><tr> <td>SPORULATION</td> <td>transformation sporulation</td> <td>The strain was obtained by sporulating a parent diploid strain</td> <td>ORIGIN</td> </tr><tr> <td>NEGATIVE_SELECTION</td> <td>negative selection</td> <td>The strain/cell line was obtained by negative selection</td> <td>ORIGIN</td> </tr><tr> <td>TRANSFECTION</td> <td>transfection</td> <td>The strain/cell line was obtained by transfection</td> <td>ORIGIN</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Vocabulary at 0x7fbfcacd5a58>"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s_new.p.origin_"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"assigning a wrong value to a property will lead to an error:"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": false
},
"outputs": [
{
"ename": "ValueError",
"evalue": "Value must be one of these terms: CROSS, TRANSFORMATION, SPORULATION, NEGATIVE_SELECTION, TRANSFECTION",
"output_type": "error",
"traceback": [
"\u001b[1;31m\u001b[0m",
"\u001b[1;31mValueError\u001b[0mTraceback (most recent call last)",
"\u001b[1;32m<ipython-input-12-d9539d489991>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0ms_new\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mp\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0morigin\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;34m'crozz'\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[1;32m/vagrant_python/PyBis/pybis/pybis.py\u001b[0m in \u001b[0;36m__setattr__\u001b[1;34m(self, name, value)\u001b[0m\n\u001b[0;32m 2099\u001b[0m \u001b[0mvoc\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_openbis\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_terms\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mname\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 2100\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mvalue\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mvoc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2101\u001b[1;33m \u001b[1;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"Value must be one of these terms: \"\u001b[0m \u001b[1;33m+\u001b[0m \u001b[1;34m\", \"\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjoin\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mvoc\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mterms\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 2102\u001b[0m \u001b[1;32melif\u001b[0m \u001b[0mdata_type\u001b[0m \u001b[1;32min\u001b[0m \u001b[1;33m(\u001b[0m\u001b[1;34m'INTEGER'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'BOOLEAN'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;34m'VARCHAR'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 2103\u001b[0m \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mcheck_datatype\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata_type\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
"\u001b[1;31mValueError\u001b[0m: Value must be one of these terms: CROSS, TRANSFORMATION, SPORULATION, NEGATIVE_SELECTION, TRANSFECTION"
]
}
],
"source": [
"s_new.p.origin = 'crozz'"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"s_new.p. + TAB autocompletes all available properties for that given sample type. To show the current attributes of our new sample just use this:"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"s_new.p.mating_type = 'ALPHA'"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>identifier</td> <td>None</td> </tr><tr> <td>permId</td> <td>None</td> </tr><tr> <td>code</td> <td>None</td> </tr><tr> <td>type</td> <td>None</td> </tr><tr> <td>space</td> <td>VERMEUL</td> </tr><tr> <td>project</td> <td>None</td> </tr><tr> <td>experiment</td> <td>None</td> </tr><tr> <td>parents</td> <td>None</td> </tr><tr> <td>children</td> <td>None</td> </tr><tr> <td>tags</td> <td>None</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f52d7cfb630>"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s_new"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## working with datasets"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"from pybis import Openbis\n",
"o = Openbis(url='https://localhost:8443', verify_certificates=False)"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>CHILD_OF_SAMPLE1</td> </tr><tr> <td>permId</td> <td>20160705234504004-206</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/CHILD_OF_SAMPLE1</td> </tr><tr> <td>type</td> <td>UNKNOWN</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>['A_tag', 'due']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
4201
4202
4203
4204
4205
4206
4207
4208
4209
4210
4211
4212
4213
4214
4215
4216
4217
4218
4219
4220
4221
4222
4223
4224
4225
4226
4227
4228
4229
4230
4231
4232
4233
4234
4235
4236
4237
4238
4239
4240
4241
4242
4243
4244
4245
4246
4247
4248
4249
4250
4251
4252
4253
4254
4255
4256
4257
4258
4259
4260
4261
4262
4263
4264
4265
4266
4267
4268
4269
4270
4271
4272
4273
4274
4275
4276
4277
4278
4279
4280
4281
4282
4283
4284
4285
4286
4287
4288
4289
4290
4291
4292
4293
4294
4295
4296
4297
4298
4299
4300
4301
4302
4303
4304
4305
4306
4307
4308
4309
4310
4311
4312
4313
4314
4315
4316
4317
4318
4319
4320
4321
4322
4323
4324
4325
4326
4327
4328
4329
4330
4331
4332
4333
4334
4335
4336
4337
4338
4339
4340
4341
4342
4343
4344
4345
4346
4347
4348
4349
4350
4351
4352
4353
4354
4355
4356
4357
4358
4359
4360
4361
4362
4363
4364
4365
4366
4367
4368
4369
4370
4371
4372
4373
4374
4375
4376
4377
4378
4379
4380
4381
4382
4383
4384
4385
4386
4387
4388
4389
4390
4391
4392
4393
4394
4395
4396
4397
4398
4399
4400
4401
4402
4403
4404
4405
4406
4407
4408
4409
4410
4411
4412
4413
4414
4415
4416
4417
4418
4419
4420
4421
4422
4423
4424
4425
4426
4427
4428
4429
4430
4431
4432
4433
4434
4435
4436
4437
4438
4439
4440
4441
4442
4443
4444
4445
4446
4447
4448
4449
4450
4451
4452
4453
4454
4455
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f89bae953c8>"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_sample('/MY_NEW_SPACE/CHILD_OF_SAMPLE1')"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>MY_EXPERIMENT4</td> </tr><tr> <td>permId</td> <td>20160924020719018-358</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>type</td> <td>DEFAULT_EXPERIMENT</td> </tr><tr> <td>space</td> <td></td> </tr><tr> <td>project</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT</td> </tr><tr> <td>tags</td> <td>['A_tag', 'another_tag', 'too_late', 'tre']</td> </tr><tr><td>attachments</td><td></td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Experiment at 0x7f2b0cbd14e0>"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.get_experiment()"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>HOW_WONDERFUL</td> </tr><tr> <td>permId</td> <td>20160630105304285-81</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/HOW_WONDERFUL</td> </tr><tr> <td>type</td> <td>UNKNOWN</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>['CREATE_JSON_TAG']</td> </tr><tr><td>attachments</td><td>Bildschirmfoto 2016-10-14 um 23.01.06.png</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.Sample at 0x7f89bae8bd30>"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s = o.get_sample('/MY_NEW_SPACE/HOW_WONDERFUL')\n",
"s"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>properties</th>\n",
" <th>type</th>\n",
" <th>sample</th>\n",
" <th>registrationDate</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>20160721002154012-269</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-07-21 00:22:11</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>20160721002157457-270</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-07-21 00:22:11</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>20160721002157457-271</td>\n",
" <td>{'NAME': 'my_delightful_analysis', 'DESCRIPTIO...</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-07-21 00:22:11</td>\n",
" <td>2016-11-21 00:51:47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>20160721005440169-272</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-07-21 00:54:51</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>20160721005441238-273</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-07-21 00:54:51</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>20160818092513667-332</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-08-18 09:25:15</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>20160818092513706-333</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-08-18 09:25:15</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>20160826103944978-335</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-08-26 10:39:46</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>20160826103945007-336</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-08-26 10:39:46</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>20160929145446441-365</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-09-29 14:54:47</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>20160929145446460-366</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-09-29 14:54:47</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>20160929145446460-367</td>\n",
" <td>{'NAME': 'crc32 check', 'DESCRIPTION': 'should...</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-09-29 14:54:47</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>20161121005146312-396</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-11-21 00:51:47</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>20161121005146338-397</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-11-21 00:51:47</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>20161121005146338-398</td>\n",
" <td>{'NAME': 'my new data analysis', 'DESCRIPTION'...</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-11-21 00:51:47</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>20161121005357966-399</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_NOTEBOOK</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>20161121005357983-400</td>\n",
" <td>{}</td>\n",
" <td>JUPYTER_RESULT</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7f89bae89550>"
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"s.get_datasets()"
"execution_count": 22,
"metadata": {
"collapsed": false
},
"outputs": [],
"source": [
"ds = s.get_datasets()[11]"
]
},
{
"cell_type": "code",
"execution_count": 23,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>20160929145446460-367</td> </tr><tr> <td>permId</td> <td>20160929145446460-367</td> </tr><tr> <td>type</td> <td>JUPYTER_CONTAINER</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>sample</td> <td>/MY_NEW_SPACE/HOW_WONDERFUL</td> </tr><tr> <td>parents</td> <td>[]</td> </tr><tr> <td>children</td> <td>[]</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>[]</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pybis.pybis.DataSet at 0x7f89bae835f8>"
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ds"
]
},
{
"cell_type": "code",
"execution_count": 22,
4538
4539
4540
4541
4542
4543
4544
4545
4546
4547
4548
4549
4550
4551
4552
4553
4554
4555
4556
4557
4558
4559
4560
4561
4562
4563
4564
4565
4566
4567
4568
4569
4570
4571
4572
4573
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>isDirectory</th>\n",
" <th>pathInDataSet</th>\n",
" <th>fileSize</th>\n",
" <th>crc32Checksum</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>True</td>\n",
" <td>original</td>\n",
" <td>-1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>True</td>\n",
" <td>original/JUPYTER_NOTEBOOk</td>\n",
" <td>-1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>False</td>\n",
" <td>original/JUPYTER_NOTEBOOk/pybis demo.ipynb</td>\n",
" <td>77667</td>\n",
" <td>1fae7b5a</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>True</td>\n",
" <td>original/JUPYTER_RESULT</td>\n",
" <td>-1</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>False</td>\n",
" <td>original/JUPYTER_RESULT/PLATE1_A01_06_GFP.jpg</td>\n",
" <td>426229</td>\n",
" <td>aa4da9f7</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" isDirectory pathInDataSet fileSize \\\n",
"0 True original -1 \n",
"1 True original/JUPYTER_NOTEBOOk -1 \n",
"2 False original/JUPYTER_NOTEBOOk/pybis demo.ipynb 77667 \n",
"3 True original/JUPYTER_RESULT -1 \n",
"4 False original/JUPYTER_RESULT/PLATE1_A01_06_GFP.jpg 426229 \n",
"\n",
" crc32Checksum \n",
"0 0 \n",
"1 0 \n",
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ds.get_files()"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
4631
4632
4633
4634
4635
4636
4637
4638
4639
4640
4641
4642
4643
4644
4645
4646
4647
4648
4649
4650
4651
4652
4653
4654
4655
4656
4657
4658
4659
4660
4661
4662
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>pathInDataSet</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>original</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>original/JUPYTER_NOTEBOOk</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>original/JUPYTER_NOTEBOOk/pybis demo.ipynb</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>original/JUPYTER_RESULT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>original/JUPYTER_RESULT/PLATE1_A01_06_GFP.jpg</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" pathInDataSet\n",
"0 original\n",
"1 original/JUPYTER_NOTEBOOk\n",
"2 original/JUPYTER_NOTEBOOk/pybis demo.ipynb\n",
"3 original/JUPYTER_RESULT\n",
"4 original/JUPYTER_RESULT/PLATE1_A01_06_GFP.jpg"
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ds.get_files()[['pathInDataSet']]"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {
"collapsed": false
},
"outputs": [
{
4690
4691
4692
4693
4694
4695
4696
4697
4698
4699
4700
4701
4702
4703
4704
4705
4706
4707
4708
4709
4710
4711
4712
4713
4714
4715
4716
4717
4718
"name": "stdout",
"output_type": "stream",
"text": [
"Files downloaded to: localhost/20160929145446460-367\n"
]
}
],
"source": [
"ds.download('/tmp')"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {
"collapsed": false,
"scrolled": true
},
"outputs": [
{
"ename": "TypeError",
"evalue": "get_datasets() got an unexpected keyword argument 'withSamples'",
"output_type": "error",
"traceback": [
"\u001b[1;31m\u001b[0m",
"\u001b[1;31mTypeError\u001b[0mTraceback (most recent call last)",
"\u001b[1;32m<ipython-input-3-1a1f42c5c6c5>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mo\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_datasets\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mwithSamples\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'20160630105304285-81'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
"\u001b[1;31mTypeError\u001b[0m: get_datasets() got an unexpected keyword argument 'withSamples'"
]
}
],
"source": [
"o.get_datasets(withSamples='20160630105304285-81')"
4723
4724
4725
4726
4727
4728
4729
4730
4731
4732
4733
4734
4735
4736
4737
4738
4739
4740
4741
4742
4743
4744
4745
4746
4747
4748
4749
4750
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>code</th>\n",
" <th>properties</th>\n",
" <th>type</th>\n",
" <th>sample</th>\n",
" <th>registrationDate</th>\n",
" <th>modificationDate</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>20160721002157457-271</td>\n",
" <td>{'NAME': 'my_delightful_analysis', 'DESCRIPTIO...</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-07-21 00:22:11</td>\n",
" <td>2016-11-21 00:51:47</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>20160817175233002-331</td>\n",
" <td>{'NAME': 'demo_analysis', 'DESCRIPTION': 'done!'}</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/VERMEUL/MON_160718_181654</td>\n",
" <td>2016-08-17 17:52:35</td>\n",
" <td>2016-10-05 12:46:43</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>20160929145446460-367</td>\n",
" <td>{'NAME': 'crc32 check', 'DESCRIPTION': 'should...</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-09-29 14:54:47</td>\n",
" <td>2016-11-06 22:59:21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>20161121005146338-398</td>\n",
" <td>{'NAME': 'my new data analysis', 'DESCRIPTION'...</td>\n",
" <td>JUPYTER_CONTAINER</td>\n",
" <td>/MY_NEW_SPACE/HOW_WONDERFUL</td>\n",
" <td>2016-11-21 00:51:47</td>\n",
" <td>2016-11-21 00:53:59</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
"<pybis.pybis.Things at 0x7fa301974c18>"
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.get_datasets(type='JUPYTER_CONTAINER')"
]
},
{
"cell_type": "code",
"execution_count": 66,
"metadata": {
"collapsed": false
},
"outputs": [
{
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>20160721002157457-271</td> </tr><tr> <td>permId</td> <td>20160721002157457-271</td> </tr><tr> <td>type</td> <td>JUPYTER_CONTAINER</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>sample</td> <td>/MY_NEW_SPACE/HOW_WONDERFUL</td> </tr><tr> <td>parents</td> <td>[]</td> </tr><tr> <td>children</td> <td>['20160817175233002-331', '20161121005146338-398']</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>[]</td> </tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"<pybis.pybis.DataSet at 0x7f3140f570f0>"
"execution_count": 66,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ds = o.get_dataset('20160721002157457-271')\n",
"ds"
]
},
{
"cell_type": "code",
"execution_count": 10,
"collapsed": false,
"scrolled": true
"dss = o.get_datasets(type='JUPYTER_CONTAINER')"
]
},
{
"cell_type": "raw",
"metadata": {
"collapsed": false
},
"source": [
"files = ds.get_files()\n",
"files[0]"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Files downloaded to: localhost/20160929145446460-367\n"
]
}
],
"source": [
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"localhost/20160929145446460-367\r\n",
"localhost/20160929145446460-367/original\r\n",
"localhost/20160929145446460-367/original/JUPYTER_RESULT\r\n",
"localhost/20160929145446460-367/original/JUPYTER_RESULT/PLATE1_A01_06_GFP.jpg\r\n",
"localhost/20160929145446460-367/original/JUPYTER_NOTEBOOk\r\n",
"localhost/20160929145446460-367/original/JUPYTER_NOTEBOOk/pybis demo.ipynb\r\n"
]
}
],
"source": [
"!find localhost/20160929145446460-367"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"[{'@id': 1,\n",
" '@type': 'FileInfoDssDTO',\n",
" 'crc32Checksum': 1397688417,\n",
" 'fileSize': '209715200',\n",
" 'isDirectory': False,\n",
" 'pathInDataSet': 'original/JUPYTER_RESULT/large_testfile',\n",
" 'pathInListing': 'large_testfile'}]"
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ds2 = o.get_dataset('20160721002157457-271')\n",
"ds2.get_file_list(start_folder='original/JUPYTER_RESULT/large_testfile')"
"execution_count": 17,
"metadata": {
"collapsed": false
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Files downloaded to: localhost/20160721002157457-271\n"
]
"ds2.download('original/JUPYTER_RESULT/large_testfile')"
]
},
{
"cell_type": "code",
"metadata": {
"collapsed": false
},
4959
4960
4961
4962
4963
4964
4965
4966
4967
4968
4969
4970
4971
4972
4973
4974
4975
4976
4977
4978
4979
4980
4981
4982
4983
4984
4985
4986
4987
4988
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Files downloaded to: localhost/20160721002157457-271\n"
]
}
],
"source": [
"ds2.download()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## upload data to openBIS\n",
"The pybis data ingestion service «jupyter-uploader-api» in the openBIS instance is needed in order to work. Files are first uploaded to session workspace, then the ingestion service is activated which in turn registers 3 datasets:\n",
"- a JUPYTER_CONTAINER containing:\n",
"- JUPYTER_NOTEBOOK (containing the notebook files)\n",
"- JUPYTER_RESULTS (containing any result files)"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>20160721002157457-271</td> </tr><tr> <td>permId</td> <td>20160721002157457-271</td> </tr><tr> <td>type</td> <td>JUPYTER_CONTAINER</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_EXPERIMENT4</td> </tr><tr> <td>sample</td> <td>/MY_NEW_SPACE/HOW_WONDERFUL</td> </tr><tr> <td>parents</td> <td>[]</td> </tr><tr> <td>children</td> <td>['20160817175233002-331', '20161121005146338-398']</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>[]</td> </tr>\n",
" </tbody>\n",
" </table>\n",
"<pybis.pybis.DataSet at 0x7f3140f3dd30>"
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ds = o.get_dataset('20160721002157457-271')\n",
"ds"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {
"collapsed": false
},
"text/html": [
"\n",
" <table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th>attribute</th>\n",
" <th>value</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr> <td>code</td> <td>YEA34</td> </tr><tr> <td>permId</td> <td>20161108230958839-384</td> </tr><tr> <td>identifier</td> <td>/MY_NEW_SPACE/YEA34</td> </tr><tr> <td>type</td> <td>YEAST</td> </tr><tr> <td>space</td> <td>MY_NEW_SPACE</td> </tr><tr> <td>experiment</td> <td>/MY_NEW_SPACE/VERMEUL_PROJECT/MY_SPECIAL_EXPERIMENT</td> </tr><tr> <td>container</td> <td></td> </tr><tr> <td>components</td> <td></td> </tr><tr> <td>tags</td> <td>[]</td> </tr><tr><td>attachments</td><td>Bildschirmfoto 2016-12-20 um 10.47.26.png</td></tr>\n",
" </tbody>\n",
" </table>\n",
" "
],
"<pybis.pybis.Sample at 0x7f89bae33d30>"
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 31,
"o.new_analysis(\n",
" name='minimal', \n",
" sample = s\n",
")"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/plain": [
"'Dataset registration successful'"
]
},
"execution_count": 30,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"o.new_analysis(\n",
" name='my new data analysis', \n",
" description='some meaningful description',\n",
" sample = s,\n",
" notebook_files=['pybis demo.ipynb'],\n",
" result_files=['PLATE1_A01_06_GFP.jpg'],\n",
" parents = [ds]\n",
")"
},
{
"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.5.2"
}
},
"nbformat": 4,
"nbformat_minor": 0
}