Pisum sativum (pissa)

SELECT species.id AS species_id, species.code AS species_code, species.name AS species_name, species.data_type AS species_data_type, species.color AS species_color, species.highlight AS species_highlight, species.sequence_count AS species_sequence_count, species.network_count AS species_network_count, species.profile_count AS species_profile_count, species.description AS species_description FROM species WHERE species.id = %(param_1)s

SELECT anon_1.sequence_go_id AS anon_1_sequence_go_id, anon_1.sequence_go_sequence_id AS anon_1_sequence_go_sequence_id, anon_1.sequence_go_go_id AS anon_1_sequence_go_go_id, anon_1.sequence_go_evidence AS anon_1_sequence_go_evidence, anon_1.sequence_go_source AS anon_1_sequence_go_source, anon_1.sequence_go_predicted AS anon_1_sequence_go_predicted, anon_1.sequence_go_prediction_data AS anon_1_sequence_go_prediction_data, 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, go_1.id AS go_1_id, go_1.label AS go_1_label, go_1.name AS go_1_name, go_1.type AS go_1_type, go_1.description AS go_1_description, go_1.obsolete AS go_1_obsolete, go_1.is_a AS go_1_is_a, go_1.extended_go AS go_1_extended_go, go_1.species_counts AS go_1_species_counts FROM (SELECT sequence_go.id AS sequence_go_id, sequence_go.sequence_id AS sequence_go_sequence_id, sequence_go.go_id AS sequence_go_go_id, sequence_go.evidence AS sequence_go_evidence, sequence_go.source AS sequence_go_source, sequence_go.predicted AS sequence_go_predicted, sequence_go.prediction_data AS sequence_go_prediction_data FROM sequence_go INNER JOIN sequences ON sequences.id = sequence_go.sequence_id WHERE sequences.species_id = %(species_id_1)s LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN sequences AS sequences_1 ON sequences_1.id = anon_1.sequence_go_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 LEFT OUTER JOIN GO AS go_1 ON go_1.id = anon_1.sequence_go_go_id