Changes between Version 1 and Version 2 of ProteinComplexInventory


Ignore:
Timestamp:
Sep 7, 2014, 5:55:40 PM (6 years ago)
Author:
vw253
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ProteinComplexInventory

    v1 v2  
    99generate_complexes.sql is:
    1010SELECT
    11  t.acc,
    12  t.name,
    13  gene_product.symbol,
    14  gene_product.full_name,
    15  evidence.code,
    16  dbxref.xref_dbname
     11t.acc,
     12t.name,
     13gene_product.symbol,
     14gene_product.full_name,
     15evidence.code,
     16dbxref.xref_dbname
    1717FROM
    18  term AS cc INNER JOIN
    19  graph_path AS tcl ON cc.id = tcl.term1_id INNER JOIN
    20  graph_path AS acl ON tcl.term2_id = acl.term1_id INNER JOIN
    21  term AS t ON t.id=acl.term1_id INNER JOIN
    22  association ON association.term_id = acl.term2_id INNER JOIN
    23  gene_product ON association.gene_product_id = gene_product.id INNER JOIN
    24  species ON gene_product.species_id = species.id INNER JOIN
    25  evidence ON evidence.association_id = association.id INNER JOIN
    26  dbxref ON dbxref.id =  gene_product.dbxref_id
     18term AS cc INNER JOIN
     19graph_path AS tcl ON cc.id = tcl.term1_id INNER JOIN
     20graph_path AS acl ON tcl.term2_id = acl.term1_id INNER JOIN
     21term AS t ON t.id=acl.term1_id INNER JOIN
     22association ON association.term_id = acl.term2_id INNER JOIN
     23gene_product ON association.gene_product_id = gene_product.id INNER JOIN
     24species ON gene_product.species_id = species.id INNER JOIN
     25evidence ON evidence.association_id = association.id INNER JOIN
     26dbxref ON dbxref.id =  gene_product.dbxref_id
    2727WHERE
    28  species.genus = 'Schizosaccharomyces' AND
    29  species.species = 'pombe' AND
    30  cc.name='macromolecular complex';
     28species.genus = 'Schizosaccharomyces' AND
     29species.species = 'pombe' AND
     30cc.name='macromolecular complex';
    3131
    3232