Heatmap

SELECT anon_1.expression_profiles_id AS anon_1_expression_profiles_id, anon_1.expression_profiles_species_id AS anon_1_expression_profiles_species_id, anon_1.expression_profiles_probe AS anon_1_expression_profiles_probe, anon_1.expression_profiles_sequence_id AS anon_1_expression_profiles_sequence_id, xrefs_1.id AS xrefs_1_id, xrefs_1.platform AS xrefs_1_platform, xrefs_1.name AS xrefs_1_name, xrefs_1.url AS xrefs_1_url, sequences_1.id AS sequences_1_id, sequences_1.species_id AS sequences_1_species_id, sequences_1.name AS sequences_1_name, sequences_1.description AS sequences_1_description, sequences_1.type AS sequences_1_type, sequences_1.is_mitochondrial AS sequences_1_is_mitochondrial, sequences_1.is_chloroplast AS sequences_1_is_chloroplast FROM (SELECT expression_profiles.id AS expression_profiles_id, expression_profiles.species_id AS expression_profiles_species_id, expression_profiles.probe AS expression_profiles_probe, expression_profiles.sequence_id AS expression_profiles_sequence_id FROM expression_profiles WHERE TRUE = 1 ORDER BY expression_profiles.species_id LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN sequences AS sequences_1 ON sequences_1.id = anon_1.expression_profiles_sequence_id LEFT OUTER JOIN (sequence_xref AS sequence_xref_1 INNER JOIN xrefs AS xrefs_1 ON xrefs_1.id = sequence_xref_1.xref_id) ON sequences_1.id = sequence_xref_1.sequence_id ORDER BY anon_1.expression_profiles_species_id