Bioinformatics Resources SoSe 2018



Lecture (3 SWS) + Exercises (2 SWS)




Lothar Richter 


Friday, 9:30 - 11:45 (lecture)
Monday: 14.15 -15.45 (exercise)
Friday: 13.00 -14.30 (exercise)


Lecture: Friday: MI 00.13.009A
Exercise: Friday MI 01.09.014
Exercise: Monday MI 00.08.38


20.7.2018, 13:00 - 15:00, please be on time, 90 minutes working time




October 30th: Review & Inspection of Make-up exam at 1pm-2pm in room 01.09.034

Sep 16th: Review & Inspection on Sep 20th 2-3pm room 01.09.034

Review and inspection of the main exam will most likely take place in the week after Sep. 17th. Please stay tuned for futher details.

No lecture and exercises on May 11th and 14th (Ascension day)

No exercises on May 18th and 21st (Whit Monday)

No lecture and exercises on June 1st and 4th (Corpus Christi)




  1. Apr. 13th Introduction Videos: Part1, Part2
  2. Apr. 20th Genbank XML/Web (for the notebooks please see Material for Exercise 0) Videos: Part1, Part2
  3. Apr. 27th Swissprot Videos: Part1, Part2
  4. May 4th PDB Videos: Part1, Part2
  5. May 18th Stuctural Databases & SQL Video
  6. May 25th SQL2 Videos: Part1, Part2
  7. June 8th NoSQL Video
  8. June 15th NoSql, code example, PredictProtein (by Prof. Rost) Video
  9. June 22nd JavaScript Videos: Part1 Part2
  10. June 29th Visualization w/ JS Video
  11. July 6th  Interactive Data Visualization for the Web 2nd Edition Chap1-9, Video 
    for students this book available as ebook:
  12. July 13th Q&A Session Video



  1. Exercise sheet 0 Materials JupyterNotebook
  2. Exercise sheet 1 JupyterNotebook
  3. Exercise sheet 2
  4. Exercise sheet 3 (GradedJupyterNotebook
  5. Exercise sheet 4 SQL Statements
  6. Exercise sheet 5 JupyterNotebook SQL Statements
  7. Exercise sheet 6
  8. Exercise sheet 7 (Graded)
  9. Exercise sheet 8 Template
  10. Exercise sheet 9 Code

All jupyter notebooks are based on Python 3. Not everything in the notebook may be required for correctly solving the task. There are often different ways of approaching the problem which are equally valid. Notebooks are offered as additonal material to students that attended the exercises and were interested in the code. The notebooks are not a substitute for attending the exercise.