Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Empty drug_aliases_sources table #603

Open
codewarrior2000 opened this issue Mar 6, 2022 · 0 comments
Open

Empty drug_aliases_sources table #603

codewarrior2000 opened this issue Mar 6, 2022 · 0 comments

Comments

@codewarrior2000
Copy link

codewarrior2000 commented Mar 6, 2022

Up until the 2020-Nov version of the data.sql file, we were able to run the following query to get a full result set. However since then, subsequent versions of the data.sql file have no rows of data in the drug_aliases_sources table. Is the data forthcoming or has the data been re-located to another part of the database?
(We also noticed that two other tables, gene_gene_interaction_claims gene_gene_interaction_claim_attributes, are also not populated with data.)

      SELECT
            drug_aliases.alias,
            sources.source_db_name AS alias_source
        FROM drug_aliases
        JOIN drug_aliases_sources ON drug_aliases.id = drug_aliases_sources.drug_alias_id
        JOIN sources ON drug_aliases_sources.source_id = sources.id
        WHERE drug_id = "491e1cea-f7c0-483e-86e3-a13809f2afa3"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant