|
|
(164 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
− | ==Generating gene sets with and without concise descriptions==
| |
| | | |
− | ====Set of genes with a concise description====
| |
− | Query for all genes with a concise description from Postgres:
| |
− | Relevant postgres table names:
| |
− | *con_wbgene: Stores the WBGene ID and gene names
| |
− | *con_desctype: Type of description (relevant for us: Concise_description)
| |
− | *con_desctext: Text of the concise description
| |
− |
| |
− | Query for all WBGenes that have a concise description (in con_desctext AND con_desctype):
| |
− |
| |
− | SELECT DISTINCT(con_wbgene) FROM con_wbgene WHERE joinkey IN (SELECT joinkey FROM con_desctext WHERE con_desctext IS NOT NULL) AND joinkey IN (SELECT joinkey FROM con_desctype WHERE con_desctype IS NOT NULL) ORDER BY con_wbgene;
| |
− |
| |
− | #of genes with a concise description (as of 05.07.2014)=6,624
| |
− |
| |
− | ====Set of genes with no concise description====
| |
− | ====Set of genes with no concise description and at least one published paper====
| |
− |
| |
− | ==Semantic categories targeted for extraction from the literature==
| |
− |
| |
− | 1. Molecular identity
| |
− |
| |
− | 2. Orthology/Similarity
| |
− |
| |
− | Wild type Function
| |
− | 3. Processes
| |
− | 4. Pathways
| |
− |
| |
− | 5. Mutant Phenotypes
| |
− |
| |
− | Interactions
| |
− | 6. Genetic
| |
− | 7. Physical
| |
− |
| |
− | 8. Molecular Function
| |
− |
| |
− | Expression
| |
− | 9. Tissue expression
| |
− | 10. Sub-cellular localization
| |