An alteranate high-throughput sequencing chado representation

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

An alteranate high-throughput sequencing chado representation

Karl O. Pinc

Here at Babase we want to store high-throughput
sequencing SNV analysis in Chado.  We were
not happy with the existing approaches and
came up with our own.  We welcome any feedback.

This is a work in progress, but the broad outlines
of our storage model seem clear at this point.

We re-analyze the
same site in the same or different individuals
over time.  The central idea behind our approach
is to store each site ever analyzed as a single
feature, per individual analyzed.  The
information on the overall analysis is a row
in the the ANALYSIS table.  The results relating
to the analysis of each site on each individual
are stored in ANALYSISFEATURE rows, and related

Among other advantages this lets us lift
old results onto a new reference genome
by adding a relatively few FEATURELOC rows
and lets us re-analyze the same sites and
relate these analysis per-individual
as well as per-site.

Note that we have made a number of extensions
to Chado's Analysis module.  It would be nice if
these made it back into Chado.

I'll digress here and talk about the extensions.
Most are entirely un-controversial.  There is
a new column:


And there are the following new tables:

  ANALYSIS_DBXREF (Analysis to External Database Object
  ANALYSIS_CVTERM (Analysis Typing/Tagging)
  ANALYSIS_RELATIONSHIP (Analysis Inter-Relationships)

There is also an

  ANALYSIS_ND_EXPERIMENT (Analysis to Natural Diversity
                          Experiment Result Set

table, which allows for relationships between
analysis and nd experiments.  This new table
lets us record the material that was fed
to the high throughput sequencer and it's preparation.

You can find a broad outline here:

or here:

Some specifics of the storage model are here, particularly the part
before the option detail:

The ER diagrams should be helpful:

For details on the extensions made to Chado see:

Thanks for any feedback.


Karl <[hidden email]>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein

Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
Gmod-schema mailing list
[hidden email]