Question: Coverage table and exons
gravatar for Swimming bird
13 months ago by
Swimming bird20 wrote:

I am working on a NGS database and I found a problem to create the table for coverage data. Each row is a contains an interval of the entire exome sequenced. In some cases, there are multiple transcripts per interval. For this reason, I created an extra table to collect all the NMs ids.

The problem I found is related to the exons because in most cases there is more than one exon and they are separated by commas, for example: "1, 2, 3". As the exons are represented as numbers, creating an extra table is a nonsense and using ENUM is not an option. I think the best solution is consider the field as text but, is it correct?

exons ngs mysql database coverage • 230 views
ADD COMMENTlink written 13 months ago by Swimming bird20
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1987 users visited in the last hour