Changes between Version 1 and Version 2 of ProteinComplexInventory

Timestamp:

Sep 7, 2014, 5:55:40 PM (7 years ago)

Author:

vw253

Comment:

--

ProteinComplexInventory

@@ -9 +9 @@
 generate_complexes.sql is:
 SELECT
- t.acc,
- t.name,
- gene_product.symbol,
- gene_product.full_name,
- evidence.code,
- dbxref.xref_dbname
+t.acc,
+t.name,
+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
+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';
+species.genus = 'Schizosaccharomyces' AND
+species.species = 'pombe' AND
+cc.name='macromolecular complex';