Coverage table and exons
0
0
Entering edit mode
5.5 years ago

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?

mysql database exons ngs coverage • 705 views
ADD COMMENT

Login before adding your answer.

Traffic: 1429 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6