Changes between Version 26 and Version 27 of ProteinComplexInventory


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

--

Legend:

Unmodified
Added
Removed
Modified
  • ProteinComplexInventory

    v26 v27  
    1010generate_complexes.sql is:
    1111
    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 NER 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.term1_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
    13 OIN species ON gene_product.species_id = species.id INNER JOIN evidence ON evidence.association_id = association.id INNER JOIN dbxref ON dbxref.id = gene_product.dbxref_id WHERE species.genus = 'Saccharomyces' AND species.species = 'cerevisiae' AND cc.name='macromolecular complex';
     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 NER 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.term1_id INNER JOIN association ON association.term_id = acl.term2_id INNER JOIN gene_product ON association.gene_product_id = gene_product.id INNER JOIN species ON gene_product.species_id = species.id INNER JOIN evidence ON evidence.association_id = association.id INNER JOIN dbxref ON dbxref.id = gene_product.dbxref_id WHERE species.genus = 'Saccharomyces' AND species.species = 'cerevisiae' AND cc.name='macromolecular complex';
    1413
    1514remove duplicate rows