Changes between Version 20 and Version 21 of ProteinComplexInventory


Ignore:
Timestamp:
Nov 12, 2014, 12:13:16 PM (6 years ago)
Author:
vw253
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ProteinComplexInventory

    v20 v21  
    99
    1010generate_complexes.sql is:
    11 SELECT
    12 t.acc,
    13 t.name,
    14 xref_key as systematic_id,
    15 gene_product.symbol,
    16 gene_product.full_name,
    17 evidence.code,
    18 dbxref.xref_dbname
    19 FROM
    20 term AS cc INNER JOIN
    21 graph_path AS tcl ON cc.id = tcl.term1_id INNER JOIN
    22 graph_path AS acl ON tcl.term2_id = acl.term1_id INNER JOIN
    23 term AS t ON t.id=acl.term1_id INNER JOIN
    24 association ON association.term_id = acl.term2_id INNER JOIN
    25 gene_product ON association.gene_product_id = gene_product.id INNER JOIN
    26 species ON gene_product.species_id = species.id INNER JOIN
    27 evidence ON evidence.association_id = association.id INNER JOIN
    28 dbxref ON dbxref.id =  gene_product.dbxref_id
    29 WHERE
    30 species.genus = 'Schizosaccharomyces' AND
    31 species.species = 'pombe' AND
    32 cc.name='macromolecular complex';
    33 
     11SELECT t.acc, t.name, xref_key as systematic_id, gene_product.symbol, gene_product.full_name, evidence.code, dbx
     12ref.xref_dbname FROM term AS cc INNER JOIN graph_path AS tcl ON cc.id = tcl.term1_id INNER JOIN graph_path AS ac
     13l 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
     15ies ON gene_product.species_id = species.id INNER JOIN evidence ON evidence.association_id = association.id INNE
     16R JOIN dbxref ON dbxref.id = gene_product.dbxref_id WHERE species.genus = 'Schizosaccharomyces' AND species.spec
     17ies = 'pombe' AND cc.name='macromolecular complex';
    3418
    3519remove duplicate rows