Chado
Chado copied to clipboard
GMOD
the GMOD database schema
**[ This PR is meant to replace #108 with a local branch and including the updates needed for review. The following description is @guignonv's original PR description. This PR is...
I'm finding the version numbers we attach to our Flyway migrations a bit confusing for these reasons: - Flyway migrations have a prefix of `1.3.3` but the current Chado version...
The proposed contact_dbxref table would be used to link contacts from `contact` to `dbxref` for the purpose of storing values such as the contact's ORCID or Google Scholar ID, or...
I'd like to bring a discussion (yesterday on gather.town) here for the community. The main strength of a schema like Chado is to normalize how biological data are stored. Then,...
It was proposed in our Tripal/Chado discussion this morning to move the frange, SO and genetic_code tables into the base schema of Chado and no longer have them separate. This...
This issue imported from the [Chado v1.4 requested changes](https://docs.google.com/document/d/1t_Jb4XxUPtgGRSKtznsqvjTjmR4vpFHPQROMQ0OZK9A/edit) google doc: http://gmod.827538.n3.nabble.com/Property-tables-and-units-td4047268.html#a4047297 How to deal with numerical values? Otherwise can’t naively sort or filter values in a query. To solve...
Hello, here is the table cvterm. The column dbxref_id couldn't be null nut the foreign key is set to on delete set null. I have checked other tables with dbxref_id...
For people doing plant characterization or breeding, it may be useful to store environmental data (climatic data and other). Those data are related to a specific geo-location and are taken...
Are the `frange` and other ancillary schemas that come with Chado still needed? We're wondering if for Tripal v4 we need to keep supporting those schemas.
I used the following command to load annotations from a gff file to chado database: ``` gmod_bulk_load_gff3.pl --organism --gfffile --remove_lock ``` The file runs but creates the following error for...
