search

tripal / tripal_analysis_expression

Extension module for the Tripal toolset to show differential expression data. This module was made for Drupal 7, Tripal 3, and Chado 1.3.
GNU General Public License v2.0
4 stars 11 forks source link

Issue #419 sql returns only organisms with expression data #420

Closed dsenalik closed 2 years ago

dsenalik commented 2 years ago

This single change now shows only organisms with expression data in the heatmap query form at /tripal_expression, using only organisms present in the expression_feature table.

As an aside, this form SELECT DISTINCT O.* FROM expression_feature EF LEFT JOIN organism O on EF.organism_id=O.organism_id; was noticeably slower, so I used a subquery.

spficklin commented 2 years ago

Looks good!

spficklin commented 2 years ago

Looks good!