RNAcentral / rnacentral-webcode

RNAcentral website source code
https://rnacentral.org
Apache License 2.0
32 stars 9 forks source link

Switch to using sequence_regions table for coordinates #438

Closed blakesweeney closed 4 years ago

blakesweeney commented 5 years ago

This sequence: https://test.rnacentral.org/rna/URS00002F21DA/7227 has a funny display for coordinates because it is pulling the coordinates from rnc_coordinates. This table is outdated and not as nice to work with as the rnc_sequence_regions table. It would help a lot if we only used the rnc_sequence_regions table to get the coordinates for mapped and given coordinates.

AntonPetrov commented 5 years ago

Can this be closed?

blakesweeney commented 5 years ago

I think @BurkovBA has made this change, yes.

BurkovBA commented 5 years ago

There's an issue with Annotations still using the old xrefs and rnc_coordinates table for coordinates. We need to move it to rnc_sequence_regions.

blakesweeney commented 5 years ago

We should make that change this release. I'm planning on removing the old tables and code to populate them for release 12.

AntonPetrov commented 4 years ago