Changes between Version 24 and Version 25 of ProteinComplexInventory


Ignore:
Timestamp:
Jan 8, 2015, 1:49:35 PM (6 years ago)
Author:
vw253
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ProteinComplexInventory

    v24 v25  
    99
    1010generate_complexes.sql is:
    11 SELECT t.acc, t.name, xref_key as systematic_id, gene_product.symbol, gene_product.full_name, evidence.code, dbx
    12 ref.xref_dbname FROM term AS cc INNER JOIN graph_path AS tcl ON cc.id = tcl.term1_id INNER JOIN graph_path AS ac
    13 l ON tcl.term2_id = acl.term1_id INNER JOIN term AS t ON t.id=acl.term1_id INNER JOIN association ON association
    14 .term_id = acl.term2_id INNER JOIN gene_product ON association.gene_product_id = gene_product.id INNER JOIN spec
    15 ies ON gene_product.species_id = species.id INNER JOIN evidence ON evidence.association_id = association.id INNE
    16 R JOIN dbxref ON dbxref.id = gene_product.dbxref_id WHERE species.genus = 'Schizosaccharomyces' AND species.spec
    17 ies = 'pombe' AND cc.name='macromolecular complex';
     11
     12 SELECT t.acc, t.name, xref_key as systematic_id, gene_product.symbol, gene_product.full_name, evidence.code, dbxref.xref_dbname FROM term AS cc IN
     13NER JOIN graph_path AS tcl ON cc.id = tcl.term1_id INNER JOIN graph_path AS acl ON tcl.term2_id = acl.term1_id INNER JOIN term AS t ON t.id=acl.ter
     14m1_id INNER JOIN association ON association.term_id = acl.term2_id INNER JOIN gene_product ON association.gene_product_id = gene_product.id INNER J
     15OIN species ON gene_product.species_id = species.id INNER JOIN evidence ON evidence.association_id = association.id INNER JOIN dbxref ON dbxref.id
     16= gene_product.dbxref_id WHERE species.genus = 'Saccharomyces' AND species.species = 'cerevisiae' AND cc.name='macromolecular complex';
    1817
    1918remove duplicate rows