Changes between Version 20 and Version 21 of ProteinComplexInventory

Timestamp:

Nov 12, 2014, 12:13:16 PM (6 years ago)

Author:

vw253

Comment:

--

ProteinComplexInventory

@@ -9 +9 @@
 
 generate_complexes.sql is:
-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 INNER 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 = 'Schizosaccharomyces' AND
-species.species = 'pombe' AND
-cc.name='macromolecular complex';
-
+SELECT t.acc, t.name, xref_key as systematic_id, gene_product.symbol, gene_product.full_name, evidence.code, dbx
+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
+l 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 spec
+ies ON gene_product.species_id = species.id INNER JOIN evidence ON evidence.association_id = association.id INNE
+R JOIN dbxref ON dbxref.id = gene_product.dbxref_id WHERE species.genus = 'Schizosaccharomyces' AND species.spec
+ies = 'pombe' AND cc.name='macromolecular complex';
 
 remove duplicate rows