Skip to main content

SQLAlchemy-based interface to the oPOSSUM3 transcription factor binding database.

Project description

The package provides an object-oriented access interface to the oPOSSUM3 raw database tables.

Installation

The simplest way to install the package is via easy_install or pip:

$ easy_install pyopossum3

Dependencies

  • SQLAlchemy

  • MySQL-Python

Usage

A usage example is the following:

>>> from pyopossum3 import Opossum
>>> o = Opossum("mysql://opossum_r:@opossum.cmmt.ubc.ca/oPOSSUM3_human")
>>> o.ConservedTfbs.query.first().gene
>>> o.ExternalGeneId.query.filter(o.ExternalGeneId.external_id.in_(['TSPAN6'])).filter(o.ExternalGeneId.gene.has(chr='X')).first().gene
... etc ...

The second line creates a connection to the oPOSSUM server, and the third/fourth query the conserved_tfbss and external_gene_ids tables using SQLAlchemy syntax.

Naturally, for heavy analyses, you are suggested to set up your own copy of the database. See here for instructions on how to download the data.

You can get a feeling for the structure of the database by running the following:

>>> for cls in o.all_orm_classes:
>>>    print cls.query.first()

The main table you should probably care about is ConservedTfbs, which contains matches in the vicinity of each gene, annotated with match score and conservation level.

An example using the ucscgenome package to verify that TFBS sequences are indeed correct:

>>> c = o.ConservedTfbs.query.filter(o.ConservedTfbs.strand==1).first()
>>> c.gene.chr, c.absolute_start, c.absolute_end, c.seq
('X', 99890235L, 99890253L, 'AGAAACATTGCATACTGC')
>>> from ucscgenome import Genome
>>> g = Genome('hg19')
>>> g['chrX'][99890235:99890253]
'AGAAACATTGCATACTGC'

Note

The author of this package is not associated with the creators and maintainers of the oPOSSUM3 tool.

See also

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyopossum3-0.1.zip (9.3 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page