search

jazdrv / dnaTools

GNU General Public License v3.0
2 stars 4 forks source link

variant table normalization #1

Closed jeftreece closed 6 years ago

jeftreece commented 6 years ago

https://github.com/jazdrv/dnaTools/blob/d05df2273eeffc4a616c8bb56b3cd71a952e95e6/sql/schema-v2.sql#L92

I'm thinking the ref and alt should indeed be normalized. There's a somewhat limited set of possible values for them. This may not be the most efficient data structure for representing a variant.

jeftreece commented 6 years ago

Right now, anc and der are normalized as alleles table. This may be a good choice if there are a lot of operations on indels (e.g. merging "identical" indels) because some of the work is already done in creating this table. I'm not sure if we'll want to leave it this way.

jeftreece commented 6 years ago

Right now, anc and der are normalized as alleles table. This may be a good choice if there are a lot of operations on indels (e.g. merging "identical" indels) because some of the work is already done in creating this table. I'm not sure if we'll want to leave it this way.

jeftreece commented 6 years ago

no need to track this at this time