Biostar Beta. Not for public use.
Question: Coverage table and exons
Entering edit mode

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?

Login before adding your answer.

Similar Posts
Loading Similar Posts
Powered by the version 2.0