026216 0 - 0
SubtargetsController::$here = "/nysgrc/subtargets/index/026216"
PaginatorHelper::$here = "/nysgrc/subtargets/index/026216"
DateHelper::$here = "/nysgrc/subtargets/index/026216"
JqueryEngineHelper::$here = "/nysgrc/subtargets/index/026216"
JsHelper::$here = "/nysgrc/subtargets/index/026216"
FormHelper::$here = "/nysgrc/subtargets/index/026216"
JavascriptHelper::$here = "/nysgrc/subtargets/index/026216"
AjaxHelper::$here = "/nysgrc/subtargets/index/026216"
SessionHelper::$time = 1576145010
SessionHelper::$sessionTime = 1576157010
SessionHelper::$here = "/nysgrc/subtargets/index/026216"
HtmlHelper::$here = "/nysgrc/subtargets/index/026216"
ActionsHelper::$here = "/nysgrc/subtargets/index/026216"
"id" => "16955",
"target_id" => "026216",
"inserted" => "2013-01-04 14:00:46.448891+00",
"updated" => "2013-01-04 14:00:46.448891+00",
"id" => "28228",
"local_target_id" => "026216",
"locus_tag" => "CJE0412",
"ncbi_gi" => "57237418",
"ncbi_accession" => "YP_178431.1",
"ncbi_geneid" => "3231174",
"common_name" => "coproporphyrinogen III oxidase [Campylobacter jejuni RM1221]",
"ncbi_coded_by_region" => "complement(NC_003912.7:367039..368409)",
"sequence" => "MNLFQNLALKYSHTMMEKSLQKGFNVELLKQPKEKIPKQDKSYMLYAHVPFCHTFCPYCSFHKYYYDENLAKVYFQNLREEIKIMKDKGFDFTSMYVGGGTTLIDEEELLKTLELCKKLFNIKEISCESDPNHIDPNKLSMFKGIIDRLSCGIQSFDDETLKKVARYNKFGSSKELQEKISKALGILPIFSIDLIFNLPGQNEKQLLNDLEIAKNLAPQQITTYPLMKSNLTKDNIAKSLGVSIKDNEFTYYQIIREFFKDYTQNNGWSFSLEKNKLNDEYVSSHHEYLGVGSGAFSFLDGELLINAFNLNDYAKFIQEKQNANIAKACFDKKEIIKYVFLTEIFSGKIEIDKFNKTLNCNLEKELFIELLGLKTSGAIIKDQNALIATEFGQYLFVVLMKDFYTGMDLVRAVFRDDKRLKNKDYIDIMKENIDPLNSASMEFKSGDKLKGTNNHH",
"sequence_length" => "456",
"dna_sequence" => "ATGAATTTATTTCAAAATTTAGCTTTAAAATACTCTCATACTATGATGGAAAAATCCCTTCAAAAAGGTTTCAATGTCGAACTTTTAAAACAACCCAAAGAAAAAATTCCAAAACAAGACAAAAGCTATATGCTTTATGCTCATGTACCTTTTTGCCATACCTTTTGTCCTTATTGTAGCTTTCATAAATATTATTATGATGAAAATTTAGCCAAAGTATATTTTCAAAATCTTAGAGAAGAAATTAAAATCATGAAAGATAAAGGTTTTGATTTTACCTCCATGTATGTGGGTGGTGGTACAACACTGATTGATGAAGAGGAATTATTAAAAACCTTAGAACTTTGTAAAAAGTTATTTAATATAAAAGAAATTTCATGCGAAAGCGATCCAAATCATATTGATCCAAATAAGCTTTCTATGTTTAAAGGTATAATTGATCGTTTAAGTTGCGGGATTCAAAGTTTTGATGATGAAACTTTGAAAAAAGTGGCAAGATATAATAAATTTGGTTCATCTAAAGAACTTCAAGAAAAAATTTCAAAAGCTTTAGGAATTTTACCTATTTTTAGTATAGATCTTATTTTCAATCTTCCAGGACAAAACGAAAAACAACTTTTAAATGACTTAGAAATTGCTAAAAATTTAGCCCCGCAACAAATCACAACCTATCCTTTAATGAAATCAAATCTTACCAAAGATAATATCGCTAAAAGTCTAGGAGTGAGCATTAAAGATAATGAATTTACTTATTATCAAATCATACGAGAATTTTTTAAAGACTATACCCAAAACAATGGTTGGAGTTTTTCTTTAGAAAAAAACAAGCTTAATGACGAATATGTCAGTTCTCATCATGAATACCTAGGAGTAGGCAGCGGAGCTTTTAGCTTTTTAGATGGGGAGCTTTTAATCAATGCATTTAATCTAAATGATTATGCTAAATTTATACAAGAAAAACAAAATGCTAATATAGCCAAAGCTTGTTTTGATAAAAAAGAAATTATCAAATATGTCTTTTTAACTGAAATTTTTTCAGGGAAAATAGAAATTGATAAATTTAATAAAACTCTAAATTGCAATCTCGAAAAAGAACTTTTCATAGAACTTTTAGGACTTAAAACAAGTGGTGCCATCATAAAAGATCAAAATGCTTTAATCGCAACTGAATTTGGTCAATATCTTTTTGTGGTTTTAATGAAAGATTTTTACACAGGAATGGATCTTGTGCGCGCAGTATTTAGAGATGATAAGCGTCTTAAAAATAAAGATTATATCGATATCATGAAAGAAAATATTGATCCGCTTAACTCCGCTAGTATGGAATTTAAAAGCGGAGACAAACTAAAAGGGACGAACAACCATCATTAA",
"inserted" => "2012-08-06 13:12:53.433082+00",
"updated" => "2012-08-06 13:12:53.433082+00",
"translated_dna_sequence" => "MNLFQNLALKYSHTMMEKSLQKGFNVELLKQPKEKIPKQDKSYMLYAHVPFCHTFCPYCSFHKYYYDENLAKVYFQNLREEIKIMKDKGFDFTSMYVGGGTTLIDEEELLKTLELCKKLFNIKEISCESDPNHIDPNKLSMFKGIIDRLSCGIQSFDDETLKKVARYNKFGSSKELQEKISKALGILPIFSIDLIFNLPGQNEKQLLNDLEIAKNLAPQQITTYPLMKSNLTKDNIAKSLGVSIKDNEFTYYQIIREFFKDYTQNNGWSFSLEKNKLNDEYVSSHHEYLGVGSGAFSFLDGELLINAFNLNDYAKFIQEKQNANIAKACFDKKEIIKYVFLTEIFSGKIEIDKFNKTLNCNLEKELFIELLGLKTSGAIIKDQNALIATEFGQYLFVVLMKDFYTGMDLVRAVFRDDKRLKNKDYIDIMKENIDPLNSASMEFKSGDKLKGTNNHH*",
$rand	=	583601946
98 SELECT "Subtarget"."id" AS "Subtarget__id", "Subtarget"."target_id" AS "Subtarget__target_id", "Subtarget"."sequence_start" AS "Subtarget__sequence_start", "Subtarget"."sequence_end" AS "Subtarget__sequence_end", "Subtarget"."mutation" AS "Subtarget__mutation", "Subtarget"."sequence" AS "Subtarget__sequence", "Subtarget"."dna_sequence" AS "Subtarget__dna_sequence", "Subtarget"."sequence_comments" AS "Subtarget__sequence_comments", "Subtarget"."date_selected" AS "Subtarget__date_selected", "Subtarget"."priority" AS "Subtarget__priority", "Subtarget"."inserted" AS "Subtarget__inserted", "Subtarget"."updated" AS "Subtarget__updated", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."local_target_id" AS "Target__local_target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."study_id" AS "Target__study_id", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."ec" AS "Target__ec", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."type" AS "Target__type", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification" FROM "protein_subtarget" AS "Subtarget" LEFT JOIN "protein_target" AS "Target" ON ("Subtarget"."target_id" = "Target"."target_id") WHERE "Subtarget"."id" = '026216' LIMIT 1 0 0 7
100 SELECT "Subtarget"."id" AS "Subtarget__id", "Subtarget"."target_id" AS "Subtarget__target_id", "Subtarget"."sequence_start" AS "Subtarget__sequence_start", "Subtarget"."sequence_end" AS "Subtarget__sequence_end", "Subtarget"."mutation" AS "Subtarget__mutation", "Subtarget"."sequence" AS "Subtarget__sequence", "Subtarget"."dna_sequence" AS "Subtarget__dna_sequence", "Subtarget"."sequence_comments" AS "Subtarget__sequence_comments", "Subtarget"."date_selected" AS "Subtarget__date_selected", "Subtarget"."priority" AS "Subtarget__priority", "Subtarget"."inserted" AS "Subtarget__inserted", "Subtarget"."updated" AS "Subtarget__updated", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."local_target_id" AS "Target__local_target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."study_id" AS "Target__study_id", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."ec" AS "Target__ec", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."type" AS "Target__type", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification" FROM "protein_subtarget" AS "Subtarget" LEFT JOIN "protein_target" AS "Target" ON ("Subtarget"."target_id" = "Target"."target_id") WHERE "Subtarget"."id" = '026216' LIMIT 1 0 0 3
101 SELECT COUNT(*) AS "count" FROM "protein_subtarget" AS "Subtarget" LEFT JOIN "protein_target" AS "Target" ON ("Subtarget"."target_id" = "Target"."target_id") WHERE "Subtarget"."target_id"='026216' 1 1 3
102 SELECT "Subtarget"."id" AS "Subtarget__id", "Subtarget"."target_id" AS "Subtarget__target_id", "Subtarget"."sequence_start" AS "Subtarget__sequence_start", "Subtarget"."sequence_end" AS "Subtarget__sequence_end", "Subtarget"."mutation" AS "Subtarget__mutation", "Subtarget"."sequence" AS "Subtarget__sequence", "Subtarget"."dna_sequence" AS "Subtarget__dna_sequence", "Subtarget"."sequence_comments" AS "Subtarget__sequence_comments", "Subtarget"."date_selected" AS "Subtarget__date_selected", "Subtarget"."priority" AS "Subtarget__priority", "Subtarget"."inserted" AS "Subtarget__inserted", "Subtarget"."updated" AS "Subtarget__updated", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."local_target_id" AS "Target__local_target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."study_id" AS "Target__study_id", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."ec" AS "Target__ec", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."type" AS "Target__type", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification" FROM "protein_subtarget" AS "Subtarget" LEFT JOIN "protein_target" AS "Target" ON ("Subtarget"."target_id" = "Target"."target_id") WHERE "Subtarget"."target_id"='026216' ORDER BY "Subtarget"."id" ASC LIMIT 100 1 1 3
103 SELECT "Assignment"."id" AS "Assignment__id", "Assignment"."subtarget_id" AS "Assignment__subtarget_id", "Assignment"."lab_id" AS "Assignment__lab_id", "Assignment"."date_assigned" AS "Assignment__date_assigned", "Assignment"."inserted" AS "Assignment__inserted", "Assignment"."updated" AS "Assignment__updated" FROM "protein_subtarget_assignment" AS "Assignment" WHERE "Assignment"."subtarget_id" = ('16955') 1 1 1