Skip to main content

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

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

Metadata

Release files for pyopossum3 0.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pyopossum3 0.1
File Size Uploaded
pyopossum3-0.1.zip 9.3 kB Details

Release files / pyopossum3-0.1.zip

Download URL pyopossum3-0.1.zip
Size 9.3 kB
Tags Source
SHA-256 checksum
How to use checksums
ac30c27a85a0684d501b84af25084d612c8ab67168e530faf3faa531f8d2eb13
BLAKE2b-256 checksum
How to use checksums
e3f6e5e092924566a9da2aa23868a139604db50fada550ac519d761c570cf41c
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

0.2

1 release file

This release

0.1 This release

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page