SELECT DISTINCT(s.name)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, o.genus, o.species
 FROM feature f, cvterm cvt, organism o
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.is_obsolete = 'f' AND f.uniquename LIKE 'FBgn%' AND
 f.organism_id = o.organism_id;

SELECT DISTINCT(s.name)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'fullname' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBgn0000011';

SELECT accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'FlyBase Annotation IDs' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'promoted_gene_type' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.name = 'ab';

SELECT timeaccessioned, timelastmodified
 FROM feature f
 WHERE uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_gene_model_status' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_genetic_status' AND f.uniquename = 'FBgn0000011';

SELECT a.uniquename
 FROM feature f, featureloc fl, feature a
 WHERE f.feature_id = fl.feature_id AND fl.srcfeature_id = a.feature_id AND
 f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'promoted_genetic_location' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_computed_cyto' AND f.uniquename = 'FBgn0000011';

SELECT s.uniquename, fmin, fmax, strand
 FROM feature f, featureloc fl, feature s
 WHERE f.feature_id = fl.feature_id AND fl.srcfeature_id = s.feature_id AND
 f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_computed_cyto' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_computed_cyto' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_experimental_cyto' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'cyto_loc_comment' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'cyto_loc_comment' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000060';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'genetic_location' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = subject_id AND object_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'recom_right_end' AND
 f.uniquename = 'FBgn0000051';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = subject_id AND object_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'recom_left_end' AND
 f.uniquename = 'FBgn0000051';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'cyto_loc_comment' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000060';

SELECT fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = p.pub_id AND
 cvt.name = 'gene_order' AND fp.VALUE LIKE 'Gene order: In direction%' AND
 f.uniquename = 'FBgn0000011';

SELECT fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = p.pub_id AND
 cvt.name = 'gene_order' AND fp.VALUE LIKE 'Gene order: In direction%' AND
 f.uniquename = 'FBgn0000053';

SELECT f.uniquename, f.name, s.name AS synonym, synonym_sgml, cvt.name, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 cvt.name = 'symbol' AND fs.is_current = 'f' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, s.name AS synonym, synonym_sgml, cvt.name, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 cvt.name = 'fullname' AND fs.is_current = 'f' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, accession, db.name
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 'f' AND d.db_id = db.db_id AND
 db.name = 'FlyBase' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p,
 cv
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = p.pub_id AND
 cvt.cv_id = cv.cv_id AND cv.name = 'annotation property type' AND
 cvt.name = 'comment' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_supporting_accessions' AND f.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, fd.is_current, db.name, dbx.accession
 FROM feature g, feature_dbxref fd, dbxref dbx, db, cvterm gt
 WHERE g.type_id = gt.cvterm_id AND gt.name = 'gene' AND
 g.uniquename LIKE 'FBgn%' AND g.is_obsolete = 'f' AND
 g.feature_id = fd.feature_id AND fd.dbxref_id = dbx.dbxref_id AND
 dbx.db_id = db.db_id AND db.name = 'UniProt/Swiss-Prot' AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, fd.is_current, db.name, dbx.accession
 FROM feature g, feature_dbxref fd, dbxref dbx, db, cvterm gt
 WHERE g.type_id = gt.cvterm_id AND gt.name = 'gene' AND
 g.uniquename LIKE 'FBgn%' AND g.is_obsolete = 'f' AND
 g.feature_id = fd.feature_id AND fd.dbxref_id = dbx.dbxref_id AND
 dbx.db_id = db.db_id AND db.name = 'UniProt/TrEMBL' AND
 g.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, c.uniquename, c.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature c
 WHERE f.feature_id = subject_id AND object_id = c.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'maps_to_clone' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, c.uniquename, c.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature c
 WHERE f.feature_id = subject_id AND object_id = c.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'nomaps_to_clone' AND
 f.uniquename = 'FBgn0003308';

SELECT f.uniquename, f.name, c.uniquename, c.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature c
 WHERE f.feature_id = subject_id AND object_id = c.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'identified_with' AND
 f.uniquename = 'FBgn0000011';

SELECT cvt.name
 FROM feature f, feature_relationship fr, feature m, cvterm cvt
 WHERE f.uniquename LIKE 'FBgn%' AND f.feature_id = object_id AND
 subject_id = m.feature_id AND m.type_id = cvt.cvterm_id AND
 cvt.name IN ('aberration_junction','complex_substitution',
 'deletion','enhancer',
 'insertion_site','point_mutation',
 'protein_binding_site','regulatory_region',
 'rescue_fragment','sequence_variant',
 'transposable_element_target_site_duplication','uncharacterized_change_in_nucleotide_sequence') AND f.uniquename = 'FBgn0000011';

SELECT m.uniquename AS mutation, s.uniquename AS arm, strand, fmin, fmax
 FROM featureloc fl, feature f, feature_relationship fr, feature m, cvterm cvt,
 feature s
 WHERE f.uniquename LIKE 'FBgn%' AND f.feature_id = object_id AND
 subject_id = m.feature_id AND m.type_id = cvt.cvterm_id AND
 cvt.name IN ('aberration_junction','complex_substitution',
 'deletion','enhancer',
 'insertion_site','point_mutation',
 'protein_binding_site','regulatory_region',
 'rescue_fragment','sequence_variant',
 'transposable_element_target_site_duplication','uncharacterized_change_in_nucleotide_sequence') AND m.feature_id = fl.feature_id AND
 fl.srcfeature_id = s.feature_id AND f.uniquename = 'FBgn0000011';

SELECT m.uniquename, p.uniquename, cvt2.name, fp.VALUE
 FROM feature f, feature_relationship fr, feature m, feature_pub mp, pub p,
 cvterm cvt, cvterm cvt2, featureprop fp
 WHERE f.uniquename LIKE 'FBgn%' AND f.feature_id = object_id AND
 su\ bject_id = m.feature_id AND m.type_id = cvt.cvterm_id AND
 cvt.name IN ('aberration_junction','complex_substitution',
 'deletion','enhancer',
 'insertion_site','point_mutation',
 'protein_binding_site','regulatory_region',
 'rescue_fragment','sequence_variant',
 'transposable_element_target_site_duplication','uncharacterized_change_in_nucleotide_sequence') AND m.feature_id = mp.feature_id AND
 mp.pub_id = p.pub_id AND m.feature_id = fp.feature_id AND
 fp.type_id = cvt2.cvterm_id AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'dedb' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'EPD' AND f.uniquename = 'FBgn0000042';

SELECT p.uniquename, p.name, p.seqlen, fmin, fmax, strand, a.uniquename AS arm
 FROM feature f, feature p, feature_relationship fr, cvterm cvt, featureloc fl,
 feature a, cvterm cvt2
 WHERE f.feature_id = object_id AND subject_id = p.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'partof' AND
 p.type_id = cvt2.cvterm_id AND cvt2.name IN ('mRNA', 'snoRNA',
 'ncRNA', 'snRNA',
 'tRNA','rRNA',
 'miRNA', 'pseudogene') AND
 p.feature_id = fl.feature_id AND fl.srcfeature_id = a.feature_id AND
 f.uniquename = 'FBgn0000011';

SELECT t.uniquename, t.name, p.uniquename, p.name, p.seqlen
 FROM feature g, feature_relationship fr, cvterm cvt, feature t, cvterm cvt2,
 feature p, feature_relationship fr2, cvterm cvt3, cvterm cvt4
 WHERE g.feature_id = fr.object_id AND fr.subject_id = t.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'partof' AND
 t.type_id = cvt2.cvterm_id AND cvt2.name IN ('mRNA', 'snoRNA',
 'ncRNA', 'snRNA',
 'tRNA','rRNA',
 'miRNA', 'pseudogene') AND
 t.feature_id = fr2.object_id AND fr2.subject_id = p.feature_id AND
 fr2.type_id = cvt3.cvterm_id AND cvt3.name = 'producedby' AND
 p.type_id = cvt4.cvterm_id AND cvt4.name = 'protein' AND
 p.seqlen IS NOT NULL AND
 g.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_reported_sizes' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_comment' AND f.uniquename = 'FBgn0000038';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'MIR' AND f.uniquename = 'FBgn0064191';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'Rfam' AND f.uniquename = 'FBgn0000810';

SELECT g.uniquename, g.name, t.uniquename, t.name, p.uniquename, p.name, p.seqlen, fmin, fmax, strand, a.uniquename, cvt5.name, fp.VALUE
 FROM feature g, feature_relationship fr, cvterm cvt, feature t, cvterm cvt2,
 feature p, feature_relationship fr2, cvterm cvt3, cvterm cvt4, featureloc fl,
 feature a, featureprop fp, cvterm cvt5
 WHERE g.feature_id = fr.object_id AND fr.subject_id = t.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'partof' AND
 t.type_id = cvt2.cvterm_id AND cvt2.name IN ('mRNA', 'snoRNA',
 'ncRNA', 'snRNA',
 'tRNA', 'rRNA',
 'miRNA', 'pseudogene') AND
 t.feature_id = fr2.object_id AND fr2.subject_id = p.feature_id AND
 fr2.type_id = cvt3.cvterm_id AND cvt3.name = 'producedby' AND
 p.type_id = cvt4.cvterm_id AND cvt4.name = 'protein' AND
 p.seqlen IS NOT NULL AND
 p.feature_id = fl.feature_id AND fl.srcfeature_id = a.feature_id AND
 p.feature_id = fp.feature_id AND fp.type_id = cvt5.cvterm_id AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, t.uniquename, t.name, p.uniquename, p.name, p.seqlen, fmin, fmax, strand, a.uniquename, d.accession
 FROM feature g, feature_relationship fr, cvterm cvt, feature t, cvterm cvt2,
 feature p, feature_relationship fr2, cvterm cvt3, cvterm cvt4, featureloc fl,
 feature a, feature_dbxref fd, dbxref d, db
 WHERE g.feature_id = fr.object_id AND fr.subject_id = t.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'partof' AND
 t.type_id = cvt2.cvterm_id AND cvt2.name IN ('mRNA', 'snoRNA',
 'ncRNA', 'snRNA',
 'tRNA', 'rRNA',
 'miRNA', 'pseudogene') AND
 t.feature_id = fr2.object_id AND fr2.subject_id = p.feature_id AND
 fr2.type_id = cvt3.cvterm_id AND cvt3.name = 'producedby' AND
 p.type_id = cvt4.cvterm_id AND cvt4.name = 'protein' AND
 p.seqlen IS NOT NULL AND
 p.feature_id = fl.feature_id AND fl.srcfeature_id = a.feature_id AND
 p.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 d.db_id = db.db_id AND db.name = 'GB_protein' AND
 g.uniquename = 'FBgn0051371';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'GCR' AND f.uniquename = 'FBgn0004168';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'INTERPRO' AND f.uniquename = 'FBgn0015570';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'MEROPS' AND f.uniquename = 'FBgn0004648';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'MITODROME' AND f.uniquename = 'FBgn0027085';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'NRL_3D' AND f.uniquename = 'FBgn0003470';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'panther' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'PDB' AND f.uniquename = 'FBgn0003659';

SELECT f.uniquename, accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'TF' AND f.uniquename = 'FBgn0000014';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'bdgpinsituexpr' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'kwexpression' AND f.uniquename = 'FBgn0000014';

SELECT f.uniquename, f.name, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'molecular_info' AND f.uniquename = 'FBgn0000014';

SELECT g.uniquename, g.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, feature a, cvterm cvt
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 NOT EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, featureprop fp,
 cvterm cvt3
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 NOT EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt3.cvterm_id AND
 cvt3.name = 'promoted_allele_class' AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 cvtermprop cvtp, feature_cvterm fcv
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 NOT EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fcv.feature_id AND fcv.cvterm_id = cvt4.cvterm_id AND
 cvt4.cvterm_id = cvtp.cvterm_id AND cvtp.VALUE = 'origin_of_mutation' AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt3.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, featureprop fp,
 cvterm cvt3
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 NOT EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt3.cvterm_id AND
 cvt3.name LIKE 'derived_stock_%' AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt3.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, featureprop fp,
 cvterm cvt3
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 NOT EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt3.cvterm_id AND
 cvt3.name IN ('molecular_info','aminoacid_rep',
 'nucleotide_rep') AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, feature a, cvterm cvt
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, featureprop fp,
 cvterm cvt3
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt3.cvterm_id AND
 cvt3.name = 'promoted_allele_class' AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 cvtermprop cvtp, feature_cvterm fcv
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fcv.feature_id AND fcv.cvterm_id = cvt4.cvterm_id AND
 cvt4.cvterm_id = cvtp.cvterm_id AND cvtp.VALUE = 'origin_of_mutation' AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt3.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, featureprop fp,
 cvterm cvt3
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt3.cvterm_id AND
 cvt3.name LIKE 'derived_stock_%' AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt3.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, featureprop fp,
 cvterm cvt3
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 EXISTS (SELECT *
 FROM feature_relationship fr2, feature t, cvterm cvt2, cvterm cvt3
 WHERE fr2.subject_id = a.feature_id AND fr2.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND fr2.object_id = t.feature_id AND
 t.type_id = cvt3.cvterm_id AND cvt3.name = 'transgenic_transposon') AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt3.cvterm_id AND
 cvt3.name IN ('molecular_info','aminoacid_rep',
 'nucleotide_rep') AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class'AND fp.VALUE LIKE '%lethal%' AND g.uniquename = 'FBgn0000011' UNION
SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class' AND fp.VALUE LIKE '%viable%' AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class'AND fp.VALUE LIKE '%fertile%' AND g.uniquename = 'FBgn0000011' UNION
SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class' AND fp.VALUE LIKE '%sterile%' AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class'AND fp.VALUE NOT LIKE '%lethal%' AND
 g.uniquename = 'FBgn0000011' INTERSECT
SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class' AND fp.VALUE NOT
 LIKE '%viable%' AND g.uniquename = 'FBgn0000011' INTERSECT
SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class'AND fp.VALUE NOT LIKE '%fertile%' AND
 g.uniquename = 'FBgn0000011' INTERSECT
SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_class' AND fp.VALUE NOT
 LIKE '%sterile%' AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, a.uniquename, a.name, cvt4.name, fp.VALUE
 FROM feature g, feature_relationship fr, feature a, cvterm cvt, cvterm cvt4,
 featureprop fp
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.feature_id = fp.feature_id AND fp.type_id = cvt4.cvterm_id AND
 cvt4.name = 'derived_pheno_manifest' AND g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('useful_Dp_direct', 'useful_Dp_from_cyto') AND
 g.uniquename = 'FBgn0000022';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('deletes', 'molec_deletes') AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('part_deletes', 'molec_partdeletes') AND
 g.uniquename = 'FBgn0000014';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('nondeletes', 'molec_nondeletes') AND
 g.uniquename = 'FBgn0000014';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('duplicates', 'molec_dups') AND
 g.uniquename = 'FBgn0000014';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('part_duplicates', 'molec_partdups') AND
 g.uniquename = 'FBgn0000014';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name
 FROM feature g, feature_relationship fr, cvterm cvt, feature a
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('nonduplicates', 'molec_nondups') AND
 g.uniquename = 'FBgn0000022';

SELECT g.uniquename, g.name, t.uniquename, t.name, frtp.name, frp.VALUE
 FROM feature g, feature t, cvterm frtp, cvterm gtp, cvterm ttp,
 cvterm frpt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE subject_id = g.feature_id AND g.type_id = gtp.cvterm_id AND
 gtp.name = 'gene' AND g.is_analysis = 'f' AND
 g.is_obsolete = 'f' AND fr.type_id = frtp.cvterm_id AND
 frtp.name = 'derived_assoc_heat_shock_construct' AND object_id = t.feature_id AND
 t.type_id = ttp.cvterm_id AND ttp.name = 'transgenic_transposon' AND
 t.is_analysis = 'f' AND t.is_obsolete = 'f' AND
 frp.type_id = frpt.cvterm_id AND frpt.name = 'has_expression_data' AND
 g.uniquename = 'FBgn0000015';

SELECT g.uniquename, g.name, t.uniquename, t.name, frtp.name, frp.VALUE
 FROM feature g, feature t, cvterm frtp, cvterm gtp, cvterm ttp,
 cvterm frpt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE subject_id = g.feature_id AND g.type_id = gtp.cvterm_id AND
 gtp.name = 'gene' AND g.is_analysis = 'f' AND
 g.is_obsolete = 'f' AND fr.type_id = frtp.cvterm_id AND
 frtp.name = 'derived_assoc_UAS_construct' AND object_id = t.feature_id AND
 t.type_id = ttp.cvterm_id AND ttp.name = 'transgenic_transposon' AND
 t.is_analysis = 'f' AND t.is_obsolete = 'f' AND
 frp.type_id = frpt.cvterm_id AND frpt.name = 'has_expression_data' AND
 g.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, t.uniquename, t.name, frtp.name, frp.VALUE
 FROM feature g, feature t, cvterm frtp, cvterm gtp, cvterm ttp,
 cvterm frpt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE subject_id = g.feature_id AND g.type_id = gtp.cvterm_id AND
 gtp.name = 'gene' AND g.is_analysis = 'f' AND
 g.is_obsolete = 'f' AND fr.type_id = frtp.cvterm_id AND
 frtp.name = 'derived_assoc_characterization_construct' AND object_id = t.feature_id AND
 t.type_id = ttp.cvterm_id AND ttp.name = 'transgenic_transposon' AND
 t.is_analysis = 'f' AND t.is_obsolete = 'f' AND
 frp.type_id = frpt.cvterm_id AND frpt.name = 'has_expression_data' AND
 g.uniquename = 'FBgn0000009';

SELECT g.uniquename, g.name, t.uniquename, t.name, frtp.name, frp.VALUE
 FROM feature g, feature t, cvterm frtp, cvterm gtp, cvterm ttp,
 cvterm frpt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE subject_id = g.feature_id AND g.type_id = gtp.cvterm_id AND
 gtp.name = 'gene' AND g.is_analysis = 'f' AND
 g.is_obsolete = 'f' AND fr.type_id = frtp.cvterm_id AND
 frtp.name = 'derived_assoc_vital_reporter_construct' AND object_id = t.feature_id AND
 t.type_id = ttp.cvterm_id AND ttp.name = 'transgenic_transposon' AND
 t.is_analysis = 'f' AND t.is_obsolete = 'f' AND
 frp.type_id = frpt.cvterm_id AND frpt.name = 'has_expression_data' AND
 g.uniquename = 'FBgn0000042';

SELECT g.uniquename, g.name, t.uniquename, t.name, frtp.name, frp.VALUE
 FROM feature g, feature t, cvterm frtp, cvterm gtp, cvterm ttp,
 cvterm frpt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE subject_id = g.feature_id AND g.type_id = gtp.cvterm_id AND
 gtp.name = 'gene' AND g.is_analysis = 'f' AND
 g.is_obsolete = 'f' AND fr.type_id = frtp.cvterm_id AND
 frtp.name = 'derived_assoc_reporter_construct' AND object_id = t.feature_id AND
 t.type_id = ttp.cvterm_id AND ttp.name = 'transgenic_transposon' AND
 t.is_analysis = 'f' AND t.is_obsolete = 'f' AND
 frp.type_id = frpt.cvterm_id AND frpt.name = 'has_expression_data' AND
 g.uniquename = 'FBgn0000014';

SELECT stp.name, s.uniquename, s.name, frtp.name, otp.name, o.uniquename, o.name, frcvt.name, frp.VALUE
 FROM feature s, feature o, cvterm frtp, cvterm otp, cvterm stp,
 cvterm frcvt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE s.feature_id = subject_id AND object_id = o.feature_id AND
 fr.type_id = frtp.cvterm_id AND frtp.name = 'derived_assoc_insertion_of_mobile_activating_element' AND
 o.type_id = otp.cvterm_id AND stp.name = 'gene' AND
 s.type_id = stp.cvterm_id AND otp.name = 'transposable_element_insertion_site' AND
 s.is_obsolete = 'f' AND s.is_analysis = 'f' AND
 o.is_obsolete = 'f' AND o.is_analysis = 'f' AND
 frp.type_id = frcvt.cvterm_id AND frcvt.name = 'has_expression_data' AND
 s.uniquename = 'FBgn0000011';

SELECT stp.name, s.uniquename, s.name, frtp.name, otp.name, o.uniquename, o.name, frcvt.name, frp.VALUE
 FROM feature s, feature o, cvterm frtp, cvterm otp, cvterm stp,
 cvterm frcvt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE s.feature_id = subject_id AND object_id = o.feature_id AND
 fr.type_id = frtp.cvterm_id AND frtp.name = 'derived_assoc_insertion_of_enhancer_trap' AND
 o.type_id = otp.cvterm_id AND stp.name = 'gene' AND
 s.type_id = stp.cvterm_id AND otp.name = 'transposable_element_insertion_site' AND
 s.is_obsolete = 'f' AND s.is_analysis = 'f' AND
 o.is_obsolete = 'f' AND o.is_analysis = 'f' AND
 frp.type_id = frcvt.cvterm_id AND frcvt.name = 'has_expression_data' AND
 s.uniquename = 'FBgn0000011';

SELECT stp.name, s.uniquename, s.name, frtp.name, otp.name, o.uniquename, o.name, frcvt.name, frp.VALUE
 FROM feature s, feature o, cvterm frtp, cvterm otp, cvterm stp,
 cvterm frcvt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE s.feature_id = subject_id AND object_id = o.feature_id AND
 fr.type_id = frtp.cvterm_id AND frtp.name = 'derived_assoc_insertion_of_enhancer_trap_binary_system' AND
 o.type_id = otp.cvterm_id AND stp.name = 'gene' AND
 s.type_id = stp.cvterm_id AND otp.name = 'transposable_element_insertion_site' AND
 s.is_obsolete = 'f' AND s.is_analysis = 'f' AND
 o.is_obsolete = 'f' AND o.is_analysis = 'f' AND
 frp.type_id = frcvt.cvterm_id AND frcvt.name = 'has_expression_data' AND
 s.uniquename = 'FBgn0000157';

SELECT stp.name, s.uniquename, s.name, frtp.name, otp.name, o.uniquename, o.name, frcvt.name, frp.VALUE
 FROM feature s, feature o, cvterm frtp, cvterm otp, cvterm stp,
 cvterm frcvt, feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE s.feature_id = subject_id AND object_id = o.feature_id AND
 fr.type_id = frtp.cvterm_id AND frtp.name = 'derived_assoc_misc_insertion' AND
 o.type_id = otp.cvterm_id AND stp.name = 'gene' AND
 s.type_id = stp.cvterm_id AND otp.name = 'transposable_element_insertion_site' AND
 s.is_obsolete = 'f' AND s.is_analysis = 'f' AND
 o.is_obsolete = 'f' AND o.is_analysis = 'f' AND
 frp.type_id = frcvt.cvterm_id AND frcvt.name = 'has_expression_data' AND
 s.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'gene_phenotypes' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cv.name || accession AS SO_accession, cvt.name, p.uniquename
 FROM feature f, feature_cvterm fc, cvterm cvt, cv, dbxref d,
 db, pub p, cvterm gft
 WHERE f.feature_id = fc.feature_id AND fc.cvterm_id = cvt.cvterm_id AND
 cvt.cv_id = cv.cv_id AND cv.name = 'SO' AND
 cvt.dbxref_id = d.dbxref_id AND d.db_id = db.db_id AND
 fc.pub_id = p.pub_id AND f.type_id = gft.cvterm_id AND
 gft.name = 'gene' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, fcpt.name, fcp.VALUE, p.uniquename
 FROM feature f, feature_cvterm fc, cvterm cvt, cv, cvterm fcpt,
 pub p, feature_cvtermprop fcp
 WHERE f.feature_id = fc.feature_id AND fc.cvterm_id = cvt.cvterm_id AND
 fc.pub_id = p.pub_id AND fc.feature_cvterm_id = fcp.feature_cvterm_id AND
 cvt.cv_id = cv.cv_id AND fcp.type_id = fcpt.cvterm_id AND
 cv.name = 'molecular_function' AND fcpt.name = 'evidence_code' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, cvt2.name, fcp.VALUE, p.uniquename
 FROM feature f, feature_cvterm fc, cvterm cvt, cv, pub p,
 feature_cvtermprop fcp, cvterm cvt2
 WHERE f.feature_id = fc.feature_id AND fc.cvterm_id = cvt.cvterm_id AND
 fc.pub_id = p.pub_id AND fc.feature_cvterm_id = fcp.feature_cvterm_id AND
 fcp.type_id = cvt2.cvterm_id AND cvt2.name = 'evidence_code' AND
 cvt.cv_id = cv.cv_id AND cv.name = 'biological_process' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, cvt2.name, fcp.VALUE, p.uniquename
 FROM feature f, feature_cvterm fc, cvterm cvt, cv, pub p,
 feature_cvtermprop fcp, cvterm cvt2
 WHERE f.feature_id = fc.feature_id AND fc.cvterm_id = cvt.cvterm_id AND
 fc.pub_id = p.pub_id AND fc.feature_cvterm_id = fcp.feature_cvterm_id AND
 fcp.type_id = cvt2.cvterm_id AND cvt2.name = 'evidence_code' AND
 cvt.cv_id = cv.cv_id AND cv.name = 'cellular_component' AND
 f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'wild_type_role' AND f.uniquename = 'FBgn0000011';

SELECT g.uniquename, g.name, cvt.name, a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature g, cvterm cvt, feature a, feature_relationship_pub frpb, pub p,
 feature_relationship fr LEFT OUTER JOIN feature_relationshipprop frp ON (fr.feature_relationship_id = frp.feature_relationship_id)
 WHERE g.feature_id = subject_id AND object_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'interacts_genetically' AND
 fr.feature_relationship_id = frpb.feature_relationship_id AND frpb.pub_id = p.pub_id AND
 g.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'flygrid' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'hybrigenics' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature o
 WHERE f.feature_id = object_id AND subject_id = o.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'putative_ortholog_of' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = object_id AND subject_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'homologue' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'orthologs' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = subject_id AND object_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('fnally_comps', 'fnaly_noncomps',
 'fnally_partcomps') AND
 f.uniquename = 'FBgn0010602';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = object_id AND subject_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('fnally_comps', 'fnaly_noncomps',
 'fnally_partcomps') AND
 f.uniquename = 'FBgn0000099';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'gain_of_fn_species' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND fp.VALUE LIKE 'Gain of function effect%' AND
 f.uniquename = 'FBgn0000490';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'gain_of_fn_species' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND fp.VALUE LIKE 'No gain of function effect%' AND
 f.uniquename = 'FBgn0013263';

SELECT f.uniquename, f.name, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name LIKE 'derived_stock_%' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'availability' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0003200';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature o
 WHERE f.feature_id = object_id AND subject_id = o.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'derived_assoc_BAC' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'geo' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'hdri' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'drsc' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'reported_antibod_gen' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'discoverer' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'etymology' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000953';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'identified_by' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0011737';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = subject_id AND object_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('dom_position_effect', 'no_position_effect',
 'rec_position_effect') AND
 f.uniquename = 'FBgn0000012';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'identity_source' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'merge_source' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000008';

SELECT o.uniquename, o.name, cvt.name, f.uniquename, f.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = object_id AND subject_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'member_gene_of' AND
 o.uniquename = 'FBgn0053354';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name, p.uniquename
 FROM feature f, feature_relationship fr, cvterm cvt, feature o, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = object_id AND subject_id = o.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'member_gene_of' AND
 f.uniquename = 'FBgn0000002';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature o
 WHERE f.feature_id = subject_id AND object_id = o.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name IN ('encoded_by','has_component_gene') AND
 f.uniquename = 'FBgn0061475';

SELECT f.uniquename, f.name, cvt.name, o.uniquename, o.name
 FROM feature f, feature_relationship fr, cvterm cvt, feature o
 WHERE f.feature_id = subject_id AND object_id = o.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'included_in' AND
 f.uniquename = 'FBgn0015015';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'gene_relationships' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000042';

SELECT f.uniquename, fp.VALUE, p.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub p
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'misc' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'foreign_seq_data' AND f.uniquename = 'FBgn0014442';

SELECT p.uniquename, p.name, p.seqlen, db.name, dx.accession
 FROM feature f, feature p, feature_relationship fr, cvterm cvt, cvterm cvt2,
 feature_dbxref fd, dbxref dx, db
 WHERE f.feature_id = object_id AND subject_id = p.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'partof' AND
 p.type_id = cvt2.cvterm_id AND cvt2.name IN ('mRNA', 'snoRNA',
 'ncRNA', 'snRNA',
 'tRNA','rRNA',
 'miRNA', 'pseudogene') AND
 p.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND db.name = 'REFSEQ' AND
 f.uniquename = 'FBgn0000011';

SELECT p.uniquename, p.name, p.seqlen, db.name, dx.accession
 FROM feature g, feature_relationship fr, cvterm cvt, feature t, cvterm cvt2,
 feature p, feature_relationship fr2, cvterm cvt3, cvterm cvt4, fea\ ture_dbxref fd,
 dbxref dx, db
 WHERE g.feature_id = fr.object_id AND fr.subject_id = t.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'partof' AND
 t.type_id = cvt2.cvterm_id AND cvt2.name IN ('mRNA', 'snoRNA',
 'ncRNA', 'snRNA',
 'tRNA','rRNA',
 'miRNA', 'pseudogene') AND
 t.feature_id = fr2.object_id AND fr2.subject_id = p.feature_id AND
 fr2.type_id = cvt3.cvterm_id AND cvt3.name = 'producedby' AND
 p.type_id = cvt4.cvterm_id AND cvt4.name = 'protein' AND
 p.seqlen IS NOT NULL AND
 p.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND db.name = 'REFSEQ' AND
 g.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND db.name = 'UniProt/Swiss-Prot' AND
 f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND db.name = 'UniProt/TrEMBL' AND
 f.uniquename = 'FBgn0000015';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'flight' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'flight' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, db, dbxref dx, dbxrefprop dxp,
 cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.db_id = db.db_id AND dx.dbxref_id = dxp.dbxref_id AND
 dxp.type_id = cvt.cvterm_id AND cvt.name = 'linkout' AND
 db.name = 'if' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, cvt.name AS pub_type, p.uniquename AS FBrf_id, miniref AS citation
 FROM feature f, feature_pub fp, pub p, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.pub_id = p.pub_id AND
 p.type_id = cvt.cvterm_id AND f.uniquename = 'FBgn0000011' ORDER BY cvt.name;

SELECT DISTINCT(s.name)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2,
 feature_relationship fr, cvterm cvt3
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.feature_id = subject_id AND
 fr.type_id = cvt3.cvterm_id AND cvt3.name = 'alleleof' AND
 f.uniquename = 'FBal0000067';

SELECT f.uniquename, f.name, o.genus, o.species
 FROM feature f, cvterm cvt, organism o
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBal0000067' AND
 f.organism_id = o.organism_id;

SELECT DISTINCT(s.name)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'fullname' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBal0000046';

SELECT f.uniquename
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.name = 'ab[1];

SELECT timeaccessioned, timelastmodified
 FROM feature f
 WHERE uniquename = 'FBal0000046';

SELECT g.uniquename, g.name
 FROM feature a, feature g, feature_relationship fr, cvterm cvt
 WHERE g.feature_id = object_id AND subject_id = a.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'alleleof' AND
 a.uniquename = 'FBal0000046';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'promoted_allele_class';

SELECT f.feature_id, f.uniquename, f.name, cvt.cvterm_id, cvt.name, cvtp.type_id, cvtp.VALUE, p.uniquename
 FROM cvterm cvt, cvtermprop cvtp, feature f, feature_cvterm fcv, pub p
 WHERE f.feature_id = cv.feature_id AND fcv.cvterm_id = cvt.cvterm_id AND
 cvt.cvterm_id = cvtp.cvterm_id AND fcv.pub_id = p.pub_id AND
 cvtp.VALUE = 'origin_of_mutation' AND f.uniquename = 'FBal0000049' AND
 p.uniquename = 'unattributed';

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_allele_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT f.feature_id, f.uniquename, f.name, cvt.cvterm_id, cvt.name, cvtp.type_id, cvtp.VALUE, p.uniquename
 FROM cvterm cvt, cvtermprop cvtp, feature f, feature_cvterm fcv, pub p
 WHERE f.feature_id = cv.feature_id AND fcv.cvterm_id = cvt.cvterm_id AND
 cvt.cvterm_id = cvtp.cvterm_id AND fcv.pub_id = p.pub_id AND
 cvtp.VALUE = 'origin_of_mutation' AND f.uniquename = 'FBal0000049' AND
 p.uniquename != 'unattributed';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_supporting_accessions' AND a.uniquename LIKE 'FBal%';

SELECT g.uniquename, g.name, fd.is_current, db.name, dbx.accession
 FROM feature g, feature_dbxref fd, dbxref dbx, db, cvterm gt
 WHERE g.type_id = gt.cvterm_id AND gt.name = 'gene' AND
 g.uniquename LIKE 'FBal%' AND g.is_obsolete = 'f' AND
 g.feature_id = fd.feature_id AND fd.dbxref_id = dbx.dbxref_id AND
 dbx.db_id = db.db_id AND db.name = 'UniProt/Swiss-Prot';

SELECT g.uniquename, g.name, fd.is_current, db.name, dbx.accession
 FROM feature g, feature_dbxref fd, dbxref dbx, db, cvterm gt
 WHERE g.type_id = gt.cvterm_id AND gt.name = 'gene' AND
 g.uniquename LIKE 'FBal%' AND g.is_obsolete = 'f' AND
 g.feature_id = fd.feature_id AND fd.dbxref_id = dbx.dbxref_id AND
 dbx.db_id = db.db_id AND db.name = 'UniProt/TrEMBL';

SELECT pr.uniquename, pr.name p.uniquename
 FROM feature f, feature_relationship fr, feature pr, cvterm cvt, feature_relationship_pub frp,
 pub p
 WHERE f.feature_id = fr.object_id AND fr.subject_id = pr.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'progenitor' AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 f.uniquename = 'FBal0000080';

SELECT a.uniquename, a.name, cvt.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name IN ('molecular_info','aminoacid_rep',
 'nucleotide_sub') AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT f.uniquename, f.name, cvtp.VALUE, cvt.name, p.uniquename
 FROM feature f, feature_genotype fg, phendesc ph, environment e, environment_cvterm ec,
 cvterm cvt, cvtermprop cvtp, pub p, cvterm gtp
 WHERE f.feature_id = fg.feature_id AND fg.genotype_id = ph.genotype_id AND
 ph.environment_id = e.environment_id AND ph.pub_id = p.pub_id AND
 e.environment_id = ec.environment_id AND ec.cvterm_id = cvt.cvterm_id AND
 cvt.cvterm_id = cvtp.cvterm_id AND cvtp.VALUE = 'mode_of_assay' AND
 f.is_obsolete = 'f' AND f.is_analysis = 'f' AND
 f.type_id = gtp.cvterm_id AND gtp.name = 'gene' AND
 f.uniquename LIKE 'FBal%';

SELECT i.uniquename, i.name, p.uniquename
 FROM feature a, feature_relationship fr, feature i, cvterm cvt, cvterm cvt2,
 feature_relationship_pub frp, pub p
 WHERE a.feature_id = subject_id AND object_id = i.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 i.type_id = cvt.cvterm_id AND fr.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND cvt.name = 'transposable_element_insertion_site' AND
 a.uniquename LIKE 'FBal%';

SELECT a.uniquename, a.name, i.uniquename, i.name, p.uniquename
 FROM feature a, feature_relationship fr, feature i, cvterm itp, cvterm frtp,
 feature_relationship_pub frp, pub p
 WHERE a.feature_id = subject_id AND object_id = i.feature_id AND
 fr.type_id = frtp.cvterm_id AND frtp.name = 'associated_with' AND
 fr.feature_relationship_id = frp.feature_relationship_id AND frp.pub_id = p.pub_id AND
 i.type_id = itp.cvterm_id AND itp.name = 'transgenic_transposon' AND
 a.uniquename LIKE 'FBal%';

SELECT a.uniquename, a.name, t.uniquename, t.name
 FROM feature a, feature_relationship fr, feature t, cvterm cvt
 WHERE a.feature_id = fr.subject_id AND fr.object_id = t.feature_id AND
 fr.type_id = cvt.cvterm_id AND cvt.name = 'included_in' AND
 a.uniquename LIKE 'FBal%';

SELECT a.uniquename, a.name, i.uniquename, i.name, p.uniquename
 FROM feature a, feature_relationship fr, feature i, cvterm cvt, feature_relationship_pub frp,
 pub p, cvterm cvt2
 WHERE a.feature_id = object_id AND subject_id = i.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND fr.type_id = cvt2.cvterm_id AND
 cvt2.name = 'associated_with' AND frp.pub_id = p.pub_id AND
 i.type_id = cvt.cvterm_id AND cvt.name = 'chromosome_structure_variation' AND
 a.uniquename LIKE 'FBal%';

SELECT a.uniquename, a.name, i.uniquename, i.name, p.uniquename
 FROM feature a, feature_relationship fr, feature i, cvterm cvt, feature_relationship_pub frp,
 pub p, cvterm cvt2
 WHERE a.feature_id = subject_id AND object_id = i.feature_id AND
 fr.feature_relationship_id = frp.feature_relationship_id AND fr.type_id = cvt2.cvterm_id AND
 cvt2.name = 'carried_on' AND frp.pub_id = p.pub_id AND
 i.type_id = cvt.cvterm_id AND cvt.name = 'chromosome_structure_variation' AND
 a.uniquename LIKE 'FBal%';

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'cyto_change_comment' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_pheno_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_pheno_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_allele_pheno_description' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_enhanceable_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-enhanceable_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_suppressible_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-suppressible_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_enhancer_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-enhancer_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_suppressor_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-suppressor_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_other_class' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_enhanceable_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-enhanceable_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_suppressible_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-suppressible_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_enhancer_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-enhancer_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_suppressor_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non-suppressor_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_other_manifest' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_allele_interaction_comment' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_allele_xeno_interaction_comment' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_complements' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_part_complements' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non_complements' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_rescued_by' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_part_rescued_by' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non_rescued_by' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_rescues' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_part_rescues' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_non_rescues' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE, p.uniquename
 FROM feature a, featureprop frp, featureprop_pub frpp, pub p, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_allele_complementation_comment' AND frp.featureprop_id = frpp.featureprop_id AND
 frpp.pub_id = p.pub_id;

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Bloomington';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Kyoto';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Szeged';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Tucson';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Carpenter';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Garcia-Bellido';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Harvard';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Nusslein-Volhard';

SELECT a.uniquename, a.name, frp.VALUE
 FROM feature a, featureprop frp, cvterm cvt
 WHERE a.feature_id = frp.feature_id AND frp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_stock_Saxton';

SELECT DISTINCT(s.name)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename, f.name, o.genus, o.species
 FROM feature f, cvterm cvt, organism o
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.is_obsolete = 'f' AND f.uniquename LIKE 'FBgn%' AND
 f.organism_id = o.organism_id;

SELECT DISTINCT(s.name)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'fullname' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBgn0000011';

SELECT accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'FlyBase Annotation IDs' AND f.uniquename = 'FBgn0000011';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'promoted_gene_type' AND f.uniquename = 'FBgn0000011';

SELECT f.uniquename
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'gene' AND
 f.name = 'ab';

SELECT timeaccessioned, timelastmodified
 FROM feature f
 WHERE uniquename = 'FBgn0000011';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_bodypart_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490'; NOTE that this will RETURN a structured string that contains stage information IN the bracketed 't' portion OF the statement.;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_bodypart_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490'; NOTE that this will RETURN a structured string that contains tissue/POSITION information IN the bracketed 'a' (AND 'p') portion OF the statement.;

NOTE: the pub uniquename associated WITH a statement IS returned USING the queries above. TO directly GET a specific pub association you need either the featureprop_id OR the feature_id/rank/featureprop.type_id UNIQUE KEY VALUES WITH which you can:
SELECT uniquename
 FROM featureprop fp, featureprop_pub, pub
 WHERE fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = pub.pub_id AND
 fp.featureprop_id = ?;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_bodypart_expression_text' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_mode_of_assay' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_bodypart_expression_marker' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_subcellular_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

NOTE: the pub uniquename associated WITH a statement IS returned USING the queries above. TO directly GET a specific pub association you need either the featureprop_id OR the feature_id/rank/featureprop.type_id UNIQUE KEY VALUES WITH which you can:
SELECT uniquename
 FROM featureprop fp, featureprop_pub, pub
 WHERE fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = pub.pub_id AND
 fp.featureprop_id = ?;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_transcript_subcellular_expression_text' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_bodypart_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490'; NOTE that this will RETURN a structured string that contains stage information IN the bracketed 't' portion OF the statement.;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_bodypart_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490'; NOTE that this will RETURN a structured string that contains stage information IN the bracketed 'a' (AND 'p') portion OF the statement.;

NOTE: the pub uniquename associated WITH a statement IS returned USING the queries above. TO directly GET a specific pub association you need either the featureprop_id OR the feature_id/rank/featureprop.type_id UNIQUE KEY VALUES WITH which you can:
SELECT uniquename
 FROM featureprop fp, featureprop_pub, pub
 WHERE fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = pub.pub_id AND
 fp.featureprop_id = ?;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_bodypart_expression_text' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_bodypart_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490'; NOTE: assay IS found IN the 'as' bracketed tag IN the statement;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_bodypart_expression_marker' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_subcellular_expression_cv' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

NOTE: the pub uniquename associated WITH a statement IS returned USING the queries above. TO directly GET a specific pub association you need either the featureprop_id OR the feature_id/rank/featureprop.type_id UNIQUE KEY VALUES WITH which you can:
SELECT uniquename
 FROM featureprop fp, featureprop_pub, pub
 WHERE fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = pub.pub_id AND
 fp.featureprop_id = ?;

SELECT VALUE, pub.uniquename
 FROM feature f, featureprop fp, cvterm cvt, featureprop_pub fpp, pub
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_polypeptide_subcellular_expression_text' AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = pub.pub_id AND f.uniquename = 'FBgn0000490';

SELECT s.synonym_sgml
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND (cvt.name = 'pseudogene' OR
 cvt.name LIKE '%RNA') AND f.feature_id = fs.feature_id AND
 fs.synonym_id = s.synonym_id AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND s.type_id = cvt2.cvterm_id AND
 cvt2.name = 'symbol' AND f.is_obsolete = 'f' AND
 f.uniquename = 'FBtr0087703' GROUP BY s.synonym_sgml;

SELECT o.genus, o.species
 FROM feature f, cvterm cvt, organism o
 WHERE f.type_id = cvt.cvterm_id AND (cvt.name = 'pseudogene' OR
 cvt.name LIKE '%RNA') AND f.is_obsolete = 'f' AND
 f.uniquename = 'FBtr0087703' AND f.organism_id = o.organism_id;

SELECT accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'FlyBase Annotation IDs' AND f.uniquename = 'FBtr0087703';

SELECT f.uniquename
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND (cvt.name = 'pseudogene' OR
 cvt.name LIKE '%RNA') AND f.name = 'cnn-RA' AND
 f.is_analysis=FALSE AND f.is_obsolete=FALSE;

SELECT cvt.name
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND f.uniquename = 'FBtr0087703' AND
 f.is_analysis=FALSE AND f.is_obsolete=FALSE;

SELECT DISTINCT(g.uniquename),g.name
 FROM feature tr, feature g, feature_relationship fr, cvterm fr_type, cvterm tr_type,
 cvterm g_type
 WHERE tr.uniquename='FBtr0087703' AND tr.is_obsolete=FALSE AND
 tr.is_analysis=FALSE AND fr_type.name='partof' AND
 g_type.name='gene' AND tr.feature_id=fr.subject_id AND
 fr.object_id=g.feature_id;

SELECT timeaccessioned, timelastmodified
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND (cvt.name = 'pseudogene' OR
 cvt.name LIKE '%RNA') AND f.uniquename = 'FBtr0087703' AND
 f.is_analysis=FALSE AND f.is_obsolete=FALSE;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtr0087703' AND fp_type.name='score' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtr0087703' AND fp_type.name='score_text' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT seqlen
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND (cvt.name = 'pseudogene' OR
 cvt.name LIKE '%RNA') AND f.uniquename = 'FBtr0087703' AND
 f.is_analysis=FALSE AND f.is_obsolete=FALSE;

SELECT clone.name, clone.uniquename
 FROM feature tr, feature cDNA, feature clone, feature_relationship fr1, feature_relationshipprop fr1_prop,
 feature_relationship fr2, cvterm fr1_type, cvterm cDNA_type, cvterm clone_type
 WHERE tr.uniquename = 'FBtr0070000' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND fr1_type.name='supports' AND
 fr1_prop.VALUE='exact' AND cDNA_type.name='cDNA' AND
 clone_type.name='cDNA_clone' AND tr.feature_id=fr1.object_id AND
 fr1.feature_relationship_id=fr1_prop.feature_relationship_id AND fr1.subject_id=cDNA.feature_id AND
 cDNA.type_id=cDNA_type.cvterm_id AND cDNA.feature_id=fr2.subject_id AND
 fr2.object_id=clone.feature_id AND clone.type_id=clone_type.cvterm_id;

SELECT clone.name, clone.uniquename
 FROM feature tr, feature cDNA, feature clone, feature_relationship fr1, feature_relationshipprop fr1_prop,
 feature_relationship fr2, cvterm fr1_type, cvterm cDNA_type, cvterm clone_type
 WHERE tr.uniquename = 'FBtr0005088' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND fr1_type.name='supports' AND
 fr1_prop.VALUE='full' AND cDNA_type.name='cDNA' AND
 clone_type.name='cDNA_clone' AND tr.feature_id=fr1.object_id AND
 fr1.feature_relationship_id=fr1_prop.feature_relationship_id AND fr1.subject_id=cDNA.feature_id AND
 cDNA.type_id=cDNA_type.cvterm_id AND cDNA.feature_id=fr2.subject_id AND
 fr2.object_id=clone.feature_id AND clone.type_id=clone_type.cvterm_id;

SELECT clone.name, clone.uniquename
 FROM feature tr, feature cDNA, feature clone, feature_relationship fr1, feature_relationshipprop fr1_prop,
 feature_relationship fr2, cvterm fr1_type, cvterm cDNA_type, cvterm clone_type
 WHERE tr.uniquename = 'FBtr0005009' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND fr1_type.name='supports' AND
 fr1_prop.VALUE IN ('not_five','not_three',
 'not_ends') AND cDNA_type.name='cDNA' AND
 clone_type.name='cDNA_clone' AND tr.feature_id=fr1.object_id AND
 fr1.feature_relationship_id=fr1_prop.feature_relationship_id AND fr1.subject_id=cDNA.feature_id AND
 cDNA.type_id=cDNA_type.cvterm_id AND cDNA.feature_id=fr2.subject_id AND
 fr2.object_id=clone.feature_id AND clone.type_id=clone_type.cvterm_id;

SELECT clone.name, clone.uniquename
 FROM feature tr, feature EST, feature clone, feature_relationship fr1, feature_relationshipprop fr1_prop,
 feature_relationship fr2, cvterm fr1_type, cvterm EST_type, cvterm clone_type
 WHERE tr.uniquename = 'FBtr0005009' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND fr1_type.name='supports' AND
 fr1_prop.VALUE='full' AND EST_type.name='EST' AND
 clone_type.name='cDNA_clone' AND tr.feature_id=fr1.object_id AND
 fr1.feature_relationship_id=fr1_prop.feature_relationship_id AND fr1.subject_id=EST.feature_id AND
 EST.type_id=EST_type.cvterm_id AND EST.feature_id=fr2.subject_id AND
 fr2.object_id=clone.feature_id AND clone.type_id=clone_type.cvterm_id;

SELECT clone.name, clone.uniquename
 FROM feature tr, feature EST, feature clone, feature_relationship fr1, feature_relationshipprop fr1_prop,
 feature_relationship fr2, cvterm fr1_type, cvterm EST_type, cvterm clone_type
 WHERE tr.uniquename = 'FBtr0005009' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND fr1_type.name='supports' AND
 fr1_prop.VALUE IN ('not_five','not_three',
 'not_ends') AND EST_type.name='EST' AND
 clone_type.name='cDNA_clone' AND tr.feature_id=fr1.object_id AND
 fr1.feature_relationship_id=fr1_prop.feature_relationship_id AND fr1.subject_id=EST.feature_id AND
 EST.type_id=EST_type.cvterm_id AND EST.feature_id=fr2.subject_id AND
 fr2.object_id=clone.feature_id AND clone.type_id=clone_type.cvterm_id;

SELECT residues
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND (cvt.name = 'pseudogene' OR
 cvt.name LIKE '%RNA') AND f.uniquename = 'FBtr0005009' AND
 f.is_analysis=FALSE AND f.is_obsolete=FALSE;

SELECT s.synonym_sgml
 FROM feature tr, feature g, feature otr, cvterm tr_type, cvterm g_type,
 cvterm otr_type, feature_relationship fr1, feature_relationship fr2, cvterm fr1_type, cvterm fr2_type,
 featureloc fl, feature_synonym fs, synonym s, cvterm s_type
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND otr.uniquename ~ '^FBtr[0-9]+$' AND
 g.uniquename ~ '^FBgn[0-9]+$' AND (tr_type.name = 'pseudogene' OR
 tr_type.name LIKE '%RNA') AND (otr_type.name = 'pseudogene' OR
 otr_type.name LIKE '%RNA') AND g_type.name='gene' AND
 fr1_type.name='partof' AND fr2_type.name='partof' AND
 otr.uniquename != tr.uniquename AND fs.is_current=TRUE AND
 fs.is_internal=FALSE AND s_type.name='symbol' AND
 tr.feature_id=fr1.subject_id AND fr1.object_id=g.feature_id AND
 g.feature_id=fr2.object_id AND fr2.subject_id=otr.feature_id AND
 fr1.type_id=fr1_type.cvterm_id AND fr2.type_id=fr2_type.cvterm_id AND
 tr.type_id=tr_type.cvterm_id AND g.type_id=g_type.cvterm_id AND
 otr.type_id=otr_type.cvterm_id AND otr.feature_id=fl.feature_id AND
 otr.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT otr.uniquename
 FROM feature tr, feature g, feature otr, cvterm tr_type, cvterm g_type,
 cvterm otr_type, feature_relationship fr1, feature_relationship fr2, cvterm fr1_type, cvterm fr2_type,
 featureloc fl
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND otr.uniquename ~ '^FBtr[0-9]+$' AND
 g.uniquename ~ '^FBgn[0-9]+$' AND (tr_type.name = 'pseudogene' OR
 tr_type.name LIKE '%RNA') AND (otr_type.name = 'pseudogene' OR
 otr_type.name LIKE '%RNA') AND g_type.name='gene' AND
 fr1_type.name='partof' AND fr2_type.name='partof' AND
 otr.uniquename != tr.uniquename AND tr.feature_id=fr1.subject_id AND
 fr1.object_id=g.feature_id AND g.feature_id=fr2.object_id AND
 fr2.subject_id=otr.feature_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr2.type_id=fr2_type.cvterm_id AND tr.type_id=tr_type.cvterm_id AND
 g.type_id=g_type.cvterm_id AND otr.type_id=otr_type.cvterm_id AND
 otr.feature_id=fl.feature_id;

SELECT otr.seqlen
 FROM feature tr, feature g, feature otr, cvterm tr_type, cvterm g_type,
 cvterm otr_type, feature_relationship fr1, feature_relationship fr2, cvterm fr1_type, cvterm fr2_type,
 featureloc fl
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND otr.uniquename ~ '^FBtr[0-9]+$' AND
 g.uniquename ~ '^FBgn[0-9]+$' AND (tr_type.name = 'pseudogene' OR
 tr_type.name LIKE '%RNA') AND (otr_type.name = 'pseudogene' OR
 otr_type.name LIKE '%RNA') AND g_type.name='gene' AND
 fr1_type.name='partof' AND fr2_type.name='partof' AND
 otr.uniquename != tr.uniquename AND tr.feature_id=fr1.subject_id AND
 fr1.object_id=g.feature_id AND g.feature_id=fr2.object_id AND
 fr2.subject_id=otr.feature_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr2.type_id=fr2_type.cvterm_id AND tr.type_id=tr_type.cvterm_id AND
 g.type_id=g_type.cvterm_id AND otr.type_id=otr_type.cvterm_id AND
 otr.feature_id=fl.feature_id;

SELECT s.synonym_sgml
 FROM feature tr, feature p, cvterm tr_type, cvterm p_type, feature_relationship fr1,
 cvterm fr1_type, featureloc fl, feature_synonym fs, synonym s, cvterm s_type
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND p.uniquename ~ '^FBpp[0-9]+$' AND
 (tr_type.NAME = 'pseudogene' OR tr_type.NAME LIKE '%RNA') AND
 p_type.NAME='protein' AND fr1_type.NAME='producedby' AND
 fs.is_current=TRUE AND fs.is_internal=FALSE AND
 s_type.NAME='symbol' AND tr.feature_id=fr1.object_id AND
 fr1.subject_id=p.feature_id AND fr1.type_id=fr1_type.cvterm_id AND
 tr.type_id=tr_type.cvterm_id AND p.feature_id=fl.feature_id AND
 p.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT p.uniquename
 FROM feature tr, feature p, cvterm tr_type, cvterm p_type, feature_relationship fr1,
 cvterm fr1_type, featureloc fl
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND p.uniquename ~ '^FBpp[0-9]+$' AND
 (tr_type.NAME = 'pseudogene' OR tr_type.NAME LIKE '%RNA') AND
 p_type.NAME='protein' AND fr1_type.NAME='producedby' AND
 tr.feature_id=fr1.object_id AND fr1.subject_id=p.feature_id AND
 fr1.type_id=fr1_type.cvterm_id AND tr.type_id=tr_type.cvterm_id AND
 p.feature_id=fl.feature_id;

SELECT p.seqlen
 FROM feature tr, feature p, cvterm tr_type, cvterm p_type, feature_relationship fr1,
 cvterm fr1_type, featureloc fl
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND p.uniquename ~ '^FBpp[0-9]+$' AND
 (tr_type.NAME = 'pseudogene' OR tr_type.NAME LIKE '%RNA') AND
 p_type.NAME='protein' AND fr1_type.NAME='producedby' AND
 tr.feature_id=fr1.object_id AND fr1.subject_id=p.feature_id AND
 fr1.type_id=fr1_type.cvterm_id AND tr.type_id=tr_type.cvterm_id AND
 p.feature_id=fl.feature_id;

SELECT s.synonym_sgml
 FROM feature tr, feature g, feature otr, feature op, cvterm g_type,
 cvterm otr_type, cvterm op_type, feature_relationship fr1, feature_relationship fr2, feature_relationship fr3,
 cvterm fr1_type, cvterm fr2_type, cvterm fr3_type, featureloc fl, feature_synonym fs,
 synonym s, cvterm s_type
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND (otr_type.name = 'pseudogene' OR
 otr_type.name LIKE '%RNA') AND g_type.name='gene' AND
 op_type.name='protein' AND fr1_type.name='partof' AND
 fr2_type.name='partof' AND fr3_type.name='producedby' AND
 otr.uniquename != tr.uniquename AND fs.is_current=TRUE AND
 fs.is_internal=FALSE AND s_type.name='symbol' AND
 tr.feature_id=fr1.subject_id AND fr1.object_id=g.feature_id AND
 g.feature_id=fr2.object_id AND fr2.subject_id=otr.feature_id AND
 otr.feature_id=fr3.object_id AND fr3.subject_id=op.feature_id AND
 fr1.type_id=fr1_type.cvterm_id AND fr2.type_id=fr2_type.cvterm_id AND
 fr3.type_id=fr3_type.cvterm_id AND g.type_id=g_type.cvterm_id AND
 otr.type_id=otr_type.cvterm_id AND op.type_id=op_type.cvterm_id AND
 op.feature_id=fl.feature_id AND op.feature_id=fs.feature_id AND
 fs.synonym_id=s.synonym_id AND s.type_id=s_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT op.uniquename
 FROM feature tr, feature g, feature otr, feature op, cvterm g_type,
 cvterm otr_type, cvterm op_type, feature_relationship fr1, feature_relationship fr2, feature_relationship fr3,
 cvterm fr1_type, cvterm fr2_type, cvterm fr3_type, featureloc fl
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND (otr_type.name = 'pseudogene' OR
 otr_type.name LIKE '%RNA') AND g_type.name='gene' AND
 op_type.name='protein' AND fr1_type.name='partof' AND
 fr2_type.name='partof' AND fr3_type.name='producedby' AND
 otr.uniquename != tr.uniquename AND tr.feature_id=fr1.subject_id AND
 fr1.object_id=g.feature_id AND g.feature_id=fr2.object_id AND
 fr2.subject_id=otr.feature_id AND otr.feature_id=fr3.object_id AND
 fr3.subject_id=op.feature_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr2.type_id=fr2_type.cvterm_id AND fr3.type_id=fr3_type.cvterm_id AND
 g.type_id=g_type.cvterm_id AND otr.type_id=otr_type.cvterm_id AND
 op.type_id=op_type.cvterm_id AND op.feature_id=fl.feature_id;

SELECT op.seqlen
 FROM feature tr, feature g, feature otr, feature op, cvterm g_type,
 cvterm otr_type, cvterm op_type, feature_relationship fr1, feature_relationship fr2, feature_relationship fr3,
 cvterm fr1_type, cvterm fr2_type, cvterm fr3_type, featureloc fl
 WHERE tr.uniquename='FBtr0087703' AND tr.is_analysis=FALSE AND
 tr.is_obsolete=FALSE AND (otr_type.name = 'pseudogene' OR
 otr_type.name LIKE '%RNA') AND g_type.name='gene' AND
 op_type.name='protein' AND fr1_type.name='partof' AND
 fr2_type.name='partof' AND fr3_type.name='producedby' AND
 otr.uniquename != tr.uniquename AND tr.feature_id=fr1.subject_id AND
 fr1.object_id=g.feature_id AND g.feature_id=fr2.object_id AND
 fr2.subject_id=otr.feature_id AND otr.feature_id=fr3.object_id AND
 fr3.subject_id=op.feature_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr2.type_id=fr2_type.cvterm_id AND fr3.type_id=fr3_type.cvterm_id AND
 g.type_id=g_type.cvterm_id AND otr.type_id=otr_type.cvterm_id AND
 op.type_id=op_type.cvterm_id AND op.feature_id=fl.feature_id;

SELECT fp.VALUE
 FROM feature tr, featureprop fp, cvterm fp_type
 WHERE tr.uniquename='FBtr0000021' AND fp_type.name='comment' AND
 tr.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT f.uniquename, f.name, s.name AS synonym, synonym_sgml, cvt.name, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 fs.is_current = 'f' AND f.uniquename = 'FBtr0087703';

SELECT p.uniquename, p.miniref, p.title
 FROM feature f, pub p, feature_pub fp
 WHERE f.uniquename = 'FBtr0087703' AND f.feature_id=fp.feature_id AND
 fp.pub_id=p.pub_id;

SELECT s.synonym_sgml
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'protein' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBpp0086822' GROUP BY s.synonym_sgml;

SELECT o.genus, o.species
 FROM feature f, cvterm cvt, organism o
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'protein' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBpp0086822' AND
 f.organism_id = o.organism_id;

SELECT accession
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 't' AND d.db_id = db.db_id AND
 db.name = 'FlyBase Annotation IDs' AND f.uniquename = 'FBpp0086822';

SELECT f.uniquename
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'protein' AND
 f.name = 'cnn-PA' AND f.is_analysis=FALSE AND
 f.is_obsolete=FALSE;

SELECT DISTINCT(g.uniquename),g.name
 FROM feature p, feature tr, feature g, feature_relationship fr1, feature_relationship fr2,
 cvterm fr1_type, cvterm fr2_type, cvterm p_type, cvterm g_type
 WHERE p.uniquename='FBpp0086822' AND p.is_obsolete=FALSE AND
 p.is_analysis=FALSE AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND p_type.name='protein' AND
 g_type.name='gene' AND p.feature_id=fr1.subject_id AND
 fr1.object_id=tr.feature_id AND tr.feature_id=fr2.subject_id AND
 fr2.object_id=g.feature_id;

SELECT timeaccessioned, timelastmodified
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'protein' AND
 f.uniquename = 'FBpp0086822' AND f.is_analysis=FALSE AND
 f.is_obsolete=FALSE;

SELECT seqlen
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'protein' AND
 f.uniquename = 'FBpp0086822' AND f.is_analysis=FALSE AND
 f.is_obsolete=FALSE;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_isoelectric_point' AND f.uniquename = 'FBpp0086822';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'derived_molecular_weight' AND f.uniquename = 'FBpp0086822';

SELECT residues
 FROM feature f, cvterm cvt
 WHERE f.type_id = cvt.cvterm_id AND cvt.name = 'protein' AND
 f.uniquename = 'FBpp0086822' AND f.is_analysis=FALSE AND
 f.is_obsolete=FALSE;

SELECT s.synonym_sgml
 FROM feature pp, feature_relationship fr, cvterm fr_type, feature tr, feature_synonym fs,
 synonym s, cvterm s_type
 WHERE pp.uniquename='FBpp0086822' AND fr_type.name='producedby' AND
 s_type.name='symbol' AND fs.is_current=TRUE AND
 pp.feature_id=fr.subject_id AND fr.type_id=fr_type.cvterm_id AND
 fr.object_id=tr.feature_id AND tr.feature_id=fs.feature_id AND
 fs.synonym_id=s.synonym_id AND s.type_id=s_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT tr.uniquename
 FROM feature pp, feature_relationship fr, cvterm fr_type, feature tr
 WHERE pp.uniquename='FBpp0086822' AND fr_type.name='producedby' AND
 pp.feature_id=fr.subject_id AND fr.type_id=fr_type.cvterm_id AND
 fr.object_id=tr.feature_id;

SELECT tr.seqlen
 FROM feature pp, feature_relationship fr, cvterm fr_type, feature tr
 WHERE pp.uniquename='FBpp0086822' AND fr_type.name='producedby' AND
 pp.feature_id=fr.subject_id AND fr.type_id=fr_type.cvterm_id AND
 fr.object_id=tr.feature_id;

SELECT s.synonym_sgml
 FROM feature pp, feature tr, feature g, feature otr, feature_relationship fr1,
 feature_relationship fr2, feature_relationship fr3, cvterm fr1_type, cvterm fr2_type, cvterm fr3_type,
 feature_synonym fs, synonym s, cvterm s_type, featureloc fl
 WHERE pp.uniquename='FBpp0086822' AND otr.is_analysis=FALSE AND
 otr.is_obsolete=FALSE AND otr.uniquename LIKE 'FBtr%' AND
 otr.uniquename != tr.uniquename AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND fr3_type.name='partof' AND
 fs.is_current=TRUE AND fs.is_internal=FALSE AND
 s_type.name='symbol' AND pp.feature_id=fr1.subject_id AND
 fr1.type_id=fr1_type.cvterm_id AND fr1.object_id=tr.feature_id AND
 tr.feature_id=fr2.subject_id AND fr2.type_id=fr2_type.cvterm_id AND
 fr2.object_id=g.feature_id AND g.feature_id=fr3.object_id AND
 fr3.type_id=fr3_type.cvterm_id AND fr3.subject_id=otr.feature_id AND
 otr.feature_id=fs.feature_id AND otr.feature_id=fl.feature_id AND
 fs.synonym_id=s.synonym_id AND s.type_id=s_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT otr.uniquename
 FROM feature pp, feature tr, feature g, feature otr, feature_relationship fr1,
 feature_relationship fr2, feature_relationship fr3, cvterm fr1_type, cvterm fr2_type, cvterm fr3_type,
 featureloc fl
 WHERE pp.uniquename='FBpp0086822' AND otr.is_analysis=FALSE AND
 otr.is_obsolete=FALSE AND otr.uniquename LIKE 'FBtr%' AND
 otr.uniquename != tr.uniquename AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND fr3_type.name='partof' AND
 pp.feature_id=fr1.subject_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr1.object_id=tr.feature_id AND tr.feature_id=fr2.subject_id AND
 fr2.type_id=fr2_type.cvterm_id AND fr2.object_id=g.feature_id AND
 g.feature_id=fr3.object_id AND fr3.type_id=fr3_type.cvterm_id AND
 fr3.subject_id=otr.feature_id AND otr.feature_id=fl.feature_id;

SELECT otr.seqlen
 FROM feature pp, feature tr, feature g, feature otr, feature_relationship fr1,
 feature_relationship fr2, feature_relationship fr3, cvterm fr1_type, cvterm fr2_type, cvterm fr3_type,
 featureloc fl
 WHERE pp.uniquename='FBpp0086822' AND otr.is_analysis=FALSE AND
 otr.is_obsolete=FALSE AND otr.uniquename LIKE 'FBtr%' AND
 otr.uniquename != tr.uniquename AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND fr3_type.name='partof' AND
 pp.feature_id=fr1.subject_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr1.object_id=tr.feature_id AND tr.feature_id=fr2.subject_id AND
 fr2.type_id=fr2_type.cvterm_id AND fr2.object_id=g.feature_id AND
 g.feature_id=fr3.object_id AND fr3.type_id=fr3_type.cvterm_id AND
 fr3.subject_id=otr.feature_id AND otr.feature_id=fl.feature_id;

SELECT s.synonym_sgml
 FROM feature pp, feature tr, feature g, feature otr, feature opp,
 feature_relationship fr1, feature_relationship fr2, feature_relationship fr3, feature_relationship fr4, cvterm fr1_type,
 cvterm fr2_type, cvterm fr3_type, cvterm fr4_type, feature_synonym fs, synonym s,
 cvterm s_type, featureloc otrfl, featureloc oppfl
 WHERE pp.uniquename='FBpp0086822' AND opp.is_obsolete=FALSE AND
 opp.is_analysis=FALSE AND opp.uniquename LIKE 'FBpp%' AND
 opp.uniquename != pp.uniquename AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND fr3_type.name='partof' AND
 fr4_type.name='producedby' AND fs.is_current=TRUE AND
 fs.is_internal=FALSE AND s_type.name='symbol' AND
 pp.feature_id=fr1.subject_id AND fr1.type_id=fr1_type.cvterm_id AND
 fr1.object_id=tr.feature_id AND tr.feature_id=fr2.subject_id AND
 fr2.type_id=fr2_type.cvterm_id AND fr2.object_id=g.feature_id AND
 g.feature_id=fr3.object_id AND fr3.type_id=fr3_type.cvterm_id AND
 fr3.subject_id=otr.feature_id AND otr.feature_id=fr4.object_id AND
 fr4.type_id=fr4_type.cvterm_id AND fr4.subject_id=opp.feature_id AND
 otr.feature_id=otrfl.feature_id AND opp.feature_id=oppfl.feature_id AND
 opp.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT opp.uniquename
 FROM feature pp, feature tr, feature g, feature otr, feature opp,
 feature_relationship fr1, feature_relationship fr2, feature_relationship fr3, feature_relationship fr4, cvterm fr1_type,
 cvterm fr2_type, cvterm fr3_type, cvterm fr4_type, featureloc otrfl, featureloc oppfl
 WHERE pp.uniquename='FBpp0086822' AND opp.uniquename LIKE 'FBpp%' AND
 opp.uniquename != pp.uniquename AND opp.is_analysis=FALSE AND
 opp.is_obsolete=FALSE AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND fr3_type.name='partof' AND
 fr4_type.name='producedby' AND pp.feature_id=fr1.subject_id AND
 fr1.type_id=fr1_type.cvterm_id AND fr1.object_id=tr.feature_id AND
 tr.feature_id=fr2.subject_id AND fr2.type_id=fr2_type.cvterm_id AND
 fr2.object_id=g.feature_id AND g.feature_id=fr3.object_id AND
 fr3.type_id=fr3_type.cvterm_id AND fr3.subject_id=otr.feature_id AND
 otr.feature_id=fr4.object_id AND fr4.type_id=fr4_type.cvterm_id AND
 fr4.subject_id=opp.feature_id AND otr.feature_id=otrfl.feature_id AND
 opp.feature_id=oppfl.feature_id;

SELECT opp.seqlen
 FROM feature pp, feature tr, feature g, feature otr, feature opp,
 feature_relationship fr1, feature_relationship fr2, feature_relationship fr3, feature_relationship fr4, cvterm fr1_type,
 cvterm fr2_type, cvterm fr3_type, cvterm fr4_type, featureloc otrfl, featureloc oppfl
 WHERE pp.uniquename='FBpp0086822' AND opp.uniquename LIKE 'FBpp%' AND
 opp.uniquename != pp.uniquename AND opp.is_analysis=FALSE AND
 opp.is_obsolete=FALSE AND fr1_type.name='producedby' AND
 fr2_type.name='partof' AND fr3_type.name='partof' AND
 fr4_type.name='producedby' AND pp.feature_id=fr1.subject_id AND
 fr1.type_id=fr1_type.cvterm_id AND fr1.object_id=tr.feature_id AND
 tr.feature_id=fr2.subject_id AND fr2.type_id=fr2_type.cvterm_id AND
 fr2.object_id=g.feature_id AND g.feature_id=fr3.object_id AND
 fr3.type_id=fr3_type.cvterm_id AND fr3.subject_id=otr.feature_id AND
 otr.feature_id=fr4.object_id AND fr4.type_id=fr4_type.cvterm_id AND
 fr4.subject_id=opp.feature_id AND otr.feature_id=otrfl.feature_id AND
 opp.feature_id=oppfl.feature_id;

SELECT db.name,dbx.accession
 FROM feature f, feature_dbxref fdbx, dbxref dbx, db
 WHERE f.uniquename='FBpp0086822' AND fdbx.is_current=TRUE AND
 db.name IN ('GB_protein','REFSEQ') AND f.feature_id=fdbx.feature_id AND
 fdbx.dbxref_id=dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT f.uniquename, f.name, s.name AS synonym, synonym_sgml, cvt.name, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 fs.is_current = 'f' AND f.uniquename = 'FBpp0086822';

SELECT p.uniquename, p.miniref, p.title
 FROM feature f, pub p, feature_pub fp
 WHERE f.uniquename = 'FBpp0086822' AND f.feature_id=fp.feature_id AND
 fp.pub_id=p.pub_id;

SELECT DISTINCT(s.synonym_sgml)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt.cvterm_id AND cvt.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBti0000001';

SELECT o.genus, o.species
 FROM feature f, organism o
 WHERE f.is_obsolete = 'f' AND f.uniquename ='FBti0000001' AND
 f.organism_id = o.organism_id;

SELECT cvterm.name
 FROM feature f, cvterm
 WHERE f.type_id=cvterm.cvterm_id AND f.uniquename = 'FBti0000001';

SELECT timeaccessioned, timelastmodified
 FROM feature f
 WHERE uniquename = 'FBti0000001' AND is_obsolete='f';

SELECT fp.name
 FROM feature f, feature fp, feature_relationship fr
 WHERE fr.subject_id=f.feature_id AND fr.object_id=fp.feature_id AND
 fr.type_id=27 AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f';

SELECT fg.name
 FROM feature fg, feature f, feature_relationship fr, cvterm cvt
 WHERE fr.subject_id=fg.feature_id AND f.feature_id=fr.object_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fg.type_id=219 AND fg.uniquename LIKE 'FBgn%' AND
 fg.organism_id=f.organism_id AND f.uniquename='FBti0000001';

SELECT fg.name
 FROM feature fg, feature f, feature_relationship fr, cvterm cvt
 WHERE fr.subject_id=fg.feature_id AND f.feature_id=fr.object_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fg.type_id=219 AND fg.uniquename LIKE 'FBal%' AND
 fg.organism_id=f.organism_id AND f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE cvt.name='originating_line' AND cvt.cvterm_id=fp.type_id AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001' AND
 fp.feature_id=f.feature_id;

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_expression_data';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 cvt.name='curated_phenotype';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_chromosome_location';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_genomic_cyto_location';

SELECT src.uniquename fl.fmin, fl.fmax
 FROM feature f, featureloc fl, feature src
 WHERE fl.feature_id=f.feature_id AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001' AND fl.srcfeature_id=src.feature_id;

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, cvterm cvt, pub, featureprop_pub frp
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 frp.pub_id=pub.pub_id AND frp.featureprop_id=fp.featureprop_id AND
 cvt.name='curated_chromosomal_location';

SELECT src.uniquename fl.fmin, fl.fmax, pub.uniquename
 FROM feature f, featureloc fl,featureloc_pub, flp, pub,
 feature src
 WHERE fl.feature_id=f.feature_id AND flp.pub_id=pub.pub_id AND
 flp.featureloc_id=fl.featureloc_id AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001' AND fl.srcfeature_id=src.feature_id;

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, featureprop_pub, fpp, pub, feature f,
 cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fpp.featureprop_id=fp.featureprop_id AND
 pub.pub_id=fpp.pub_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 cvt.name='chromosomal_orientation';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_comput_cyto_location';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, cvterm cvt, pub, featureprop_pub frp
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 frp.pub_id=pub.pub_id AND frp.featureprop_id=fp.featureprop_id AND
 cvt.name='curated_cytological_location';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, cvterm cvt, pub, featureprop_pub frp
 WHERE fp.feature_id=f.feature_id AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f' AND fp.type_id=cvt.cvterm_id AND
 frp.pub_id=pub.pub_id AND frp.featureprop_id=fp.featureprop_id AND
 cvt.name='gen_loc_comment';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='transposable_element_flanking_region' AND
 f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='producedby' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name!='natural_transposon' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM feature f, feature_relationship fr, feature ft, featureprop fp, cvterm cvt,
 cvterm cvt2
 WHERE f.feature_id=fr.subject_id AND fr.object_id=ft.feature_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='producedby' AND
 ft.feature_id=fp.feature_id AND fp.type_id=cvt2.cvterm_id AND
 (cvt2.name='compiled_kb_length' OR cvt2.name='kb_length') AND
 f1.is_obsolete='f' AND f1.uniquename='FBti0000001';

SELECT fp.name
 FROM feature f, feature_relationship fr1, feature_relationship fr2, feature fp, cvterm c1,
 cvterm c2
 WHERE fr1.type_id=c1.cvterm_id AND c1.name='producedby' AND
 f.feature_id=fr1.subject_id AND fr1.object_id=fr2.object_id AND
 fr2.object_id=fp.feature_id AND fr2.type_id=c2.cvterm_id AND
 c2.name='derived_tp_assoc_alleles' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fo.uniquename, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, feature_relationship_pub frp, pub,
 cvterm cvt
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' frp.feature_relationship_id=fr.feature_relationship_id AND
 frp.pub_id=pub.pub_id AND fo.uniquename LIKE 'FBgn%' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.name, frp.VALUE, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, feature_relationshipprop frp, feature_relationshipprop_pub frpp,
 pub, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fo.uniquename LIKE 'FBgn%' AND frp.feature_relationshipprop_id=frpp.feature_relationshipprop_id AND
 frpp.pub_id=pub.pub_id AND fr.feature_relationship_id=frp.feature_relationship_id AND
 frp.type_id= cvt2.cvterm_id AND cvt2.name='relative_orientation' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fo.uniquename LIKE 'FBal%' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, featureprop_pub frp, pub, feature f, cvterm cvt
 WHERE cvt.name='originating_line' AND cvt.cvterm_id=fp.type_id AND
 frp.featureprop_id=fp.featureprop_id AND frp.pub_id=pub.pub_id AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001' AND
 fp.feature_id=f.feature_id;

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp,featureprop_pub frp, pub, feature f, cvterm cvt
 WHERE cvt.name='is_multiple_insertion_line' AND frp.featureprop_id=fp.featureprop_id AND
 frp.pub_id=pub.pub_id AND cvt.cvterm_id=fp.type_id AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001' AND
 fp.feature_id=f.feature_id;

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='transposed_descendant_of' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='transgenic_transposon_insertion_site' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='recombinant_descendant_of' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='transgenic_transposon_insertion_site' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='replacement_descendant_of' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='transgenic_transposon_insertion_site' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='modified_descendant_of' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='transgenic_transposon_insertion_site' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='chromosome_structure_variation' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='single balancer' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Bloomington' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Kyoto' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Szeged' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Tucson' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Carpenter' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Garcia-Bellido' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Harvard' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Nusslein-Volhard' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE
 FROM featureprop fp, feature f, cvterm cvt
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='derived_stock_Saxton' AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='availablility' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='comment' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBti0000001';

SELECT s.synonym_sgml, pub.uniquename
 FROM feature_synonym fs, feature f, synonym s, pub
 WHERE fs.feature_id=f.feature_id AND fs.synonym_id=s.synonym_id AND
 fs.is_internal='f' AND fs.pub_id=pub.pub_id AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT dbxref.accession
 FROM dbxref, feature_dbxref fd, feature f, db
 WHERE f.feature_id=fd.feature_id AND dbxref.dbxref_id=fd.dbxref_id AND
 fd.is_current='f' AND dbxref.db_id=db.db_id AND
 db.name='FlyBase' AND f.uniquename='FBti0000001' AND
 f.is_obsolete='f';

SELECT f.uniquename, f.name, cvt.name AS pub_type, p.uniquename AS FBrf_id, miniref AS citation
 FROM feature f, feature_pub fp, pub p, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.pub_id = p.pub_id AND
 p.type_id = cvt.cvterm_id AND f.uniquename = 'FBti0000001' ORDER BY cvt.name;

SELECT name
 FROM feature
 WHERE uniquename = 'FBcl0000001' AND is_obsolete=FALSE;

SELECT o.genus, o.species
 FROM feature f, organism o
 WHERE f.is_obsolete = 'f' AND f.uniquename = 'FBcl0000001' AND
 f.organism_id = o.organism_id;

SELECT name
 FROM feature
 WHERE uniquename = 'FBcl0000001' AND is_obsolete=FALSE;

SELECT uniquename
 FROM feature
 WHERE uniquename = 'FBcl0000001' AND is_obsolete=FALSE;

SELECT cvt.NAME
 FROM feature f, cvterm cvt
 WHERE f.uniquename = 'FBcl0000001' AND f.is_obsolete=FALSE AND
 f.type_id=cvt.cvterm_id;

SELECT timeaccessioned, timelastmodified
 FROM feature
 WHERE uniquename = 'FBcl0000001' AND is_obsolete=FALSE;

SELECT DISTINCT g.name
 FROM feature c, feature evidence, feature tr, feature g, feature_relationship fr1,
 feature_relationship fr2, feature_relationship fr3, cvterm evidence_type, cvterm fr2_type, cvterm g_type
 WHERE c.uniquename='FBcl0000001' AND evidence_type.name IN ('cDNA','EST') AND
 fr2_type.name='supports' AND g_type.name = 'gene' AND
 c.feature_id=fr1.object_id AND fr1.subject_id=evidence.feature_id AND
 evidence.type_id=evidence_type.cvterm_id AND evidence.feature_id=fr2.subject_id AND
 fr2.type_id=fr2_type.cvterm_id AND fr2.object_id=tr.feature_id AND
 tr.feature_id=fr3.subject_id AND fr3.object_id=g.feature_id AND
 g.type_id=g_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'status' AND f.uniquename = 'FBcl0000003';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'problem' AND f.uniquename = 'FBcl0000248';

SELECT l.name
 FROM feature f, library_feature lf, library l
 WHERE f.uniquename='FBcl0000001' AND f.feature_id=lf.feature_id AND
 lf.library_id=l.library_id;

SELECT lp.VALUE
 FROM feature f, library_feature lf, library l, libraryprop lp, cvterm lp_type
 WHERE f.uniquename='FBcl0394020' AND lp_type.name='strain' AND
 f.feature_id=lf.feature_id AND lf.library_id=l.library_id AND
 l.library_id=lp.library_id AND lp.type_id=lp_type.cvterm_id;

SELECT lbp.VALUE FROM feature f, library_feature lf, library l, libraryprop lbp, cvterm cvt WHERE f.uniquename='FBcl0000001' AND
 cvt.name='stage' AND f.feature_id=lf.feature_id AND lf.library_id=l.library_id AND
 l.library_id=lbp.library_id AND lbp.type_id=cvt.cvterm_id;

SELECT DISTINCT cvt.name FROM feature f, library_feature lf, library l, library_cvterm lcvt, cvterm cvt, cv
 WHERE f.uniquename='FBcl0000001' AND cv.name IN ('FlyBase anatomy CV','cellular_component') AND
 f.feature_id=lf.feature_id AND lf.library_id=l.library_id AND l.library_id=lcvt.library_id AND lcvt.cvterm_id=cvt.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature cl, feature vector, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm vector_type
 WHERE cl.uniquename = 'FBcl0000001' AND fs.is_current = TRUE AND
 fs.is_internal = FALSE AND fs_type.NAME = 'symbol' AND
 vector_type.name='engineered_construct' AND cl.feature_id=fr.object_id AND
 fr.subject_id=vector.feature_id AND vector.type_id=vector_type.cvterm_id AND
 vector.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id;

SELECT fls.seqlen
 FROM feature cl, feature fls, feature_relationship fr, cvterm fls_type
 WHERE cl.uniquename='FBcl0000003' AND fls_type.name IN ('cDNA','BAC_cloned_genomic_insert') AND
 cl.feature_id=fr.object_id AND fr.subject_id=fls.feature_id AND
 fls.type_id=fls_type.cvterm_id;

SELECT dbx.accession
 FROM feature cl, feature fls, feature_relationship fr, cvterm fls_type, feature_dbxref fdbx,
 dbxref dbx, db
 WHERE cl.uniquename='FBcl0000003' AND fls_type.name IN ('cDNA','BAC_cloned_genomic_insert') AND
 db.name='GB' AND fdbx.is_current=TRUE AND
 cl.feature_id=fr.object_id AND fr.subject_id=fls.feature_id AND
 fls.type_id=fls_type.cvterm_id AND fls.feature_id=fdbx.feature_id AND
 fdbx.dbxref_id=dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT fls.residues
 FROM feature cl, feature fls, feature_relationship fr, cvterm fls_type
 WHERE cl.uniquename='FBcl0000003' AND fls_type.name IN ('cDNA','BAC_cloned_genomic_insert') AND
 cl.feature_id=fr.object_id AND fr.subject_id=fls.feature_id AND
 fls.type_id=fls_type.cvterm_id;

SELECT fiveps.seqlen
 FROM feature cl, feature fiveps, feature_relationship fr, cvterm fiveps_type
 WHERE cl.uniquename='FBcl0000001' AND fiveps_type.name='EST' AND
 fiveps.is_obsolete=FALSE AND (fiveps.name LIKE '%5prime' OR
 fiveps.name LIKE '%contig1') AND cl.feature_id=fr.object_id AND
 fr.subject_id=fiveps.feature_id AND fiveps.type_id=fiveps_type.cvterm_id;

SELECT DISTINCT dbx.accession
 FROM feature cl, feature fiveps, feature_relationship fr, cvterm fiveps_type, feature_dbxref fdbx,
 dbxref dbx, db
 WHERE cl.uniquename='FBcl0000001' AND fiveps_type.name='EST' AND
 db.name='GB' AND fdbx.is_current=TRUE AND
 fiveps.is_obsolete=FALSE AND (fiveps.name LIKE '%5prime' OR
 fiveps.name LIKE '%contig1') AND cl.feature_id=fr.object_id AND
 fr.subject_id=fiveps.feature_id AND fiveps.type_id=fiveps_type.cvterm_id AND
 fiveps.feature_id=fdbx.feature_id AND fdbx.dbxref_id=dbx.dbxref_id AND
 dbx.db_id=db.db_id;

SELECT fiveps.residues
 FROM feature cl, feature fiveps, feature_relationship fr, cvterm fiveps_type
 WHERE cl.uniquename='FBcl0000001' AND fiveps_type.name='EST' AND
 fiveps.is_obsolete=FALSE AND (fiveps.name LIKE '%5prime' OR
 fiveps.name LIKE '%contig1') AND cl.feature_id=fr.object_id AND
 fr.subject_id=fiveps.feature_id AND fiveps.type_id=fiveps_type.cvterm_id;

SELECT threeps.seqlen
 FROM feature cl, feature threeps, feature_relationship fr, cvterm threeps_type
 WHERE cl.uniquename='FBcl0000002' AND threeps_type.name='EST' AND
 threeps.is_obsolete=FALSE AND (threeps.name LIKE '%3prime' OR
 threeps.name LIKE '%contig2') AND cl.feature_id=fr.object_id AND
 fr.subject_id=threeps.feature_id AND threeps.type_id=threeps_type.cvterm_id;

SELECT DISTINCT dbx.accession
 FROM feature cl, feature threeps, feature_relationship fr, cvterm threeps_type, feature_dbxref fdbx,
 dbxref dbx, db
 WHERE cl.uniquename='FBcl0000002' AND threeps_type.name='EST' AND
 db.name='GB' AND fdbx.is_current=TRUE AND
 threeps.is_obsolete=FALSE AND (threeps.name LIKE '%3prime' OR
 threeps.name LIKE '%contig2') AND cl.feature_id=fr.object_id AND
 fr.subject_id=threeps.feature_id AND threeps.type_id=threeps_type.cvterm_id AND
 threeps.feature_id=fdbx.feature_id AND fdbx.dbxref_id=dbx.dbxref_id AND
 dbx.db_id=db.db_id;

SELECT threeps.residues
 FROM feature cl, feature threeps, feature_relationship fr, cvterm threeps_type
 WHERE cl.uniquename='FBcl0000002' AND threeps_type.name='EST' AND
 threeps.is_obsolete=FALSE AND (threeps.name LIKE '%3prime' OR
 threeps.name LIKE '%contig2') AND cl.feature_id=fr.object_id AND
 fr.subject_id=threeps.feature_id AND threeps.type_id=threeps_type.cvterm_id;

SELECT partial.seqlen
 FROM feature cl, feature partial, feature_relationship fr, cvterm partial_type
 WHERE cl.uniquename='FBcl0000111' AND partial_type.name='EST' AND
 partial.is_obsolete=FALSE AND partial.name !~ '(5prime|contig1|3prime|contig2)$' AND
 cl.feature_id=fr.object_id AND fr.subject_id=partial.feature_id AND
 partial.type_id=partial_type.cvterm_id;

SELECT DISTINCT dbx.accession
 FROM feature cl, feature partial, feature_relationship fr, cvterm partial_type, feature_dbxref fdbx,
 dbxref dbx, db
 WHERE cl.uniquename='FBcl0000111' AND partial_type.name='EST' AND
 db.name='GB' AND fdbx.is_current=TRUE AND
 partial.is_obsolete=FALSE AND partial.name !~ '(5prime|contig1|3prime|contig2)$' AND
 cl.feature_id=fr.object_id AND fr.subject_id=partial.feature_id AND
 partial.type_id=partial_type.cvterm_id AND partial.feature_id=fdbx.feature_id AND
 fdbx.dbxref_id=dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT partial.residues
 FROM feature cl, feature partial, feature_relationship fr, cvterm partial_type
 WHERE cl.uniquename='FBcl0000111' AND partial_type.name='EST' AND
 partial.is_obsolete=FALSE AND partial.name !~ '(5prime|contig1|3prime|contig2)$' AND
 cl.feature_id=fr.object_id AND fr.subject_id=partial.feature_id AND
 partial.type_id=partial_type.cvterm_id;

SELECT lp.VALUE
 FROM feature f, library_feature lf, library l, libraryprop lp, cvterm lp_type
 WHERE f.uniquename='FBcl0000111' AND lp_type.name='comment' AND
 f.feature_id=lf.feature_id AND lf.library_id=l.library_id AND
 l.library_id=lp.library_id AND lp.type_id=lp_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature f, library_feature lf, library l, library_synonym ls, synonym s
 WHERE f.uniquename='FBcl0000111' AND f.feature_id=lf.feature_id AND
 lf.library_id=l.library_id AND l.library_id=ls.library_id AND
 ls.synonym_id=s.synonym_id;

SELECT p.uniquename
 FROM feature f, library_feature lf, library l, library_pub lp, pub p
 WHERE f.uniquename='FBcl0000111' AND f.feature_id=lf.feature_id AND
 lf.library_id=l.library_id AND l.library_id=lp.library_id AND
 lp.pub_id=p.pub_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.type_id = cvt.cvterm_id AND
 cvt.name = 'comment' AND f.uniquename = 'FBcl0000001';

SELECT f.uniquename, f.name, s.name AS synonym, synonym_sgml, cvt.name, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 fs.is_current = 'f' AND f.uniquename = 'FBcl0000001' AND
 cvt.name='symbol';

SELECT f.uniquename, f.name, s.name AS synonym, synonym_sgml, cvt.name, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 fs.is_current = 'f' AND f.uniquename = 'FBcl0000001' AND
 cvt.name='fullname';

SELECT dbxref.accession
 FROM dbxref, feature_dbxref fd, feature f, db
 WHERE f.feature_id=fd.feature_id AND dbxref.dbxref_id=fd.dbxref_id AND
 fd.is_current='f' AND dbxref.db_id=db.db_id AND
 db.name='FlyBase' AND f.uniquename='FBcl0006217' AND
 f.is_obsolete='f';

SELECT p.uniquename, p.miniref, p.title
 FROM feature f, pub p, feature_pub fp
 WHERE f.uniquename = 'FBcl0006217' AND f.feature_id=fp.feature_id AND
 fp.pub_id=p.pub_id;

SELECT sc.uniquename
 FROM stock s, stockcollection_stock scs, stockcollection sc
 WHERE s.uniquename='FBst0000001' AND s.stock_id=scs.stock_id AND
 scs.stockcollection_id=sc.stockcollection_id;

SELECT sc_type.name
 FROM stock s, stockcollection_stock scs, stockcollection sc, cvterm sc_type
 WHERE s.uniquename='FBst0000001' AND s.stock_id=scs.stock_id AND
 scs.stockcollection_id=sc.stockcollection_id AND sc.type_id=sc_type.cvterm_id;

SELECT name
 FROM stock s
 WHERE s.uniquename='FBst0000001';

SELECT genus,species
 FROM stock s, organism o
 WHERE s.uniquename='FBst0000001' AND s.organism_id=o.organism_id;

SELECT uniquename
 FROM stock s
 WHERE s.uniquename='FBst0000001';

SELECT description
 FROM stock s
 WHERE s.uniquename='FBst0000001';

SELECT genotype.name
 FROM stock s, stock_genotype sg, genotype
 WHERE s.uniquename='FBst0000001' AND s.stock_id=sg.stock_id AND
 sg.genotype_id=genotype.genotype_id;

SELECT s_type.name
 FROM stock s, cvterm s_type
 WHERE s.uniquename='FBst0000001' AND s.type_id=s_type.cvterm_id;

SELECT cvt.name
 FROM stock s, stock_cvterm scvt, cvterm cvt
 WHERE s.uniquename='FBst0000001' AND s.stock_id=scvt.stock_id AND
 scvt.cvterm_id=cvt.cvterm_id;

SELECT scp.VALUE
 FROM stock s, stockcollection_stock scs, stockcollection sc, stockcollectionprop scp, cvterm scp_type
 WHERE s.uniquename='FBst0000001' AND scp_type.name IN ('request_text', 'homepage_url',
 'order_url', 'request_text',
 'email_order_contact_name') AND
 s.stock_id=scs.stock_id AND scs.stockcollection_id=sc.stockcollection_id AND
 sc.stockcollection_id=scp.stockcollection_id AND scp.type_id=scp_type.cvterm_id;

SELECT s.synonym_sgml
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.NAME = 'chromosome_structure_variation' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.NAME = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBab0000001' GROUP BY s.synonym_sgml;

SELECT o.genus, o.species
 FROM feature f, organism o
 WHERE f.uniquename='FBab0000001' AND f.organism_id=o.organism_id;

SELECT uniquename
 FROM feature f
 WHERE f.uniquename='FBab0000001';

SELECT c.name
 FROM feature f, cvterm c, feature_cvterm fc, feature_cvtermprop cp, cvterm c1,
 cvterm c2, pub p
 WHERE f.type_id = c1.cvterm_id AND c1.name = 'chromosome_structure_variation' AND
 f.feature_id = fc.feature_id AND fc.cvterm_id = c.cvterm_id AND
 cp.feature_cvterm_id = fc.feature_cvterm_id AND cp.type_id = c2.cvterm_id AND
 c2.name = 'wt_class' AND fc.pub_id = p.pub_id AND
 p.uniquename LIKE 'FBrf%' AND f.uniquename='FBab0000001';

SELECT timeaccessioned,timelastmodified
 FROM feature f
 WHERE f.uniquename='FBab0000001';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBab0000001' AND fp_type.name = 'computed_map' AND
 f.feature_id = fp.feature_id AND fp.type_id = fp_type.cvterm_id;

SELECT s.uniquename, fmin, fmax, miniref AS citation
 FROM feature f, feature b, feature_relationship fr, cvterm cvt1, cvterm cvt2,
 featureloc fl, feature s, featureloc_pub flp, pub p
 WHERE f.uniquename = 'FBab0030010' AND f.feature_id = fr.object_id AND
 fr.type_id = cvt1.cvterm_id AND cvt1.name = 'break_of' AND
 fr.subject_id = b.feature_id AND b.type_id = cvt2.cvterm_id AND
 cvt2.name = 'breakpoint' AND b.feature_id = fl.feature_id AND
 fl.srcfeature_id = s.feature_id AND fl.featureloc_id = flp.featureloc_id AND
 flp.pub_id = p.pub_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBab0000001' AND fp_type.name = 'deleted_segment' AND
 f.feature_id = fp.feature_id AND fp.type_id = fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename LIKE 'FBab%' AND f.organism_id = 1 AND
 fp_type.name = 'derived_computed_breakpoint' AND f.feature_id = fp.feature_id AND
 fp.type_id = fp_type.cvterm_id UNION
SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename LIKE 'FBab%' AND f.organism_id != 1 AND
 fp_type.name = 'non_Dmel_location' AND f.feature_id = fp.feature_id AND
 fp.type_id = fp_type.cvterm_id;

SELECT fp.VALUE , miniref AS citation
 FROM feature f, featureprop fp, cvterm fp_type, featureprop_pub fpp, pub p
 WHERE f.uniquename='FBab0044894' AND fp_type.name = 'new_order' AND
 f.feature_id = fp.feature_id AND fp.type_id = fp_type.cvterm_id AND
 fp.featureprop_id = fpp.featureprop_id AND fpp.pub_id = p.pub_id;

SELECT s.synonym_sgml
 FROM feature ab, feature prog, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ab.uniquename = 'FBab0030010' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='progenitor' AND ab.feature_id=fr.subject_id AND
 fr.type_id=fr_type.cvterm_id AND fr.object_id=prog.feature_id AND
 prog.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT c.name
 FROM feature f, cvterm c, feature_cvterm fc, cvtermprop cp, cvterm c1,
 pub p
 WHERE f.type_id = c1.cvterm_id AND c1.name = 'chromosome_structure_variation' AND
 f.feature_id = fc.feature_id AND fc.cvterm_id = c.cvterm_id AND
 c.cvterm_id = cp.cvterm_id AND cp.VALUE = 'origin_of_mutation' AND
 fc.pub_id = p.pub_id AND p.uniquename LIKE 'FBrf%' AND
 f.uniquename='FBab0030010';

SELECT c.name
 FROM feature f, cvterm c, feature_cvterm fc, feature_cvtermprop cp, cvterm c1,
 cvterm c2, pub p
 WHERE f.type_id = c1.cvterm_id AND c1.name = 'chromosome_structure_variation' AND
 f.feature_id = fc.feature_id AND fc.cvterm_id = c.cvterm_id AND
 cp.feature_cvterm_id = fc.feature_cvterm_id AND cp.type_id = c2.cvterm_id AND
 c2.name = 'aberr_class' AND fc.pub_id = p.pub_id AND
 p.uniquename LIKE 'FBrf%' AND f.uniquename='FBab0030010';

SELECT fp.VALUE, miniref AS citation
 FROM feature f, featureprop fp, cvterm fp_type , featureprop_pun fpp, pub p
 WHERE f.uniquename LIKE 'FBab%' AND f.organism_id = 1 AND
 fp_type.name = 'derived_attributed_breakpoint' AND f.feature_id = fp.feature_id AND
 fp.type_id = fp_type.cvterm_id AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND p.uniquename lik 'FBrf%' UNION
SELECT fp.VALUE, miniref AS citation
 FROM feature f, featureprop fp, cvterm fp_type , featureprop_pun fpp, pub p
 WHERE f.uniquename LIKE 'FBab%' AND f.organism_id != 1 AND
 fp_type.name = 'non_Dmel_location' AND f.feature_id = fp.feature_id AND
 fp.type_id = fp_type.cvterm_id AND fp.featureprop_id = fpp.featureprop_id AND
 fpp.pub_id = p.pub_id AND p.uniquename lik 'FBrf%';

SELECT s.synonym_sgml
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.NAME = 'single balancer' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.NAME = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBba0000005' GROUP BY s.synonym_sgml;

SELECT o.genus, o.species
 FROM feature f, organism o
 WHERE f.uniquename='FBba0000005' AND f.organism_id=o.organism_id;

SELECT uniquename
 FROM feature f
 WHERE f.uniquename='FBba0000005';

SELECT timeaccessioned,timelastmodified
 FROM feature f
 WHERE f.uniquename='FBba0000005';

SELECT s.synonym_sgml
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt, cvterm cvt2
 WHERE f.type_id = cvt.cvterm_id AND cvt.NAME = 'single balancer' AND
 f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.NAME = 'nickname' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBba0000005' GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM feature ba, feature pab, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000005' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='variant_of' AND ba.feature_id=fr.subject_id AND
 fr.type_id=fr_type.cvterm_id AND fr.object_id=pab.feature_id AND
 pab.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT fp.VALUE
 FROM feature ba, feature pab, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE ba.uniquename = 'FBba0000005' AND fp_type.NAME='new_order' AND
 fr_type.NAME='variant_of' AND ba.feature_id=fr.subject_id AND
 fr.type_id=fr_type.cvterm_id AND fr.object_id=pab.feature_id AND
 pab.feature_id = fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT s.synonym_sgml
 FROM feature ba, feature prog, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000005' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='progenitor' AND ba.feature_id=fr.subject_id AND
 fr.type_id=fr_type.cvterm_id AND fr.object_id=prog.feature_id AND
 prog.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT fp.VALUE, p.miniref
 FROM feature ba, featureprop fp, featureprop_pub fpp, pub p, cvterm fp_type
 WHERE ba.uniquename='FBba0000005' AND fp_type.NAME='balancer_status' AND
 p.uniquename ~ '^FBrf[0-9]+$' AND ba.feature_id=fp.feature_id AND
 fp.type_id=fp_type.cvterm_id AND fp.featureprop_id=fpp.featureprop_id AND
 fpp.pub_id=p.pub_id;

SELECT s.synonym_sgml
 FROM feature ba, feature al, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000005' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='carried_on' AND ba.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=al.feature_id AND
 al.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM feature ba, feature ti, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000473' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='associated_with' AND ba.feature_id=fr.subject_id AND
 fr.type_id=fr_type.cvterm_id AND fr.object_id=ti.feature_id AND
 ti.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000006' AND fp_type.NAME='discoverer' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Bloomington' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000002' AND fp_type.NAME='derived_stock_Bloomington' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000003' AND fp_type.NAME='derived_stock_Szeged' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Tucson' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Carpenter' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Garcia-Bellido' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Harvard' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Nusslein-Volhard' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='derived_stock_Saxton' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000001' AND fp_type.NAME='availability' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT s.synonym_sgml
 FROM feature ba, feature g, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000116' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='rec_position_effect' AND ba.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=g.feature_id AND
 g.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM feature ba, feature g, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000119' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='dom_position_effect' AND ba.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=g.feature_id AND
 g.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM feature ba, feature g, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE ba.uniquename = 'FBba0000119' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='no_position_effect' AND ba.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=g.feature_id AND
 g.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id GROUP BY s.synonym_sgml;

SELECT fp.VALUE
 FROM feature ba, featureprop fp, cvterm fp_type
 WHERE ba.uniquename ='FBba0000002' AND fp_type.NAME='misc' AND
 ba.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT f.uniquename, f.NAME, s.NAME AS synonym, synonym_sgml, cvt.NAME, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 fs.is_current = 'f' AND f.uniquename = 'FBba0000116' AND
 cvt.name='symbol';

SELECT f.uniquename, f.NAME, s.NAME AS synonym, synonym_sgml, cvt.NAME, p.uniquename
 FROM cvterm cvt, feature f, feature_synonym fs, synonym s, pub p
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.pub_id = p.pub_id AND s.type_id = cvt.cvterm_id AND
 fs.is_current = 'f' AND f.uniquename = 'FBba0000116' AND
 cvt.name='fullname';

SELECT f.uniquename, f.NAME, accession, db.NAME
 FROM feature f, feature_dbxref fd, dbxref d, db
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = d.dbxref_id AND
 fd.is_current = 'f' AND d.db_id = db.db_id AND
 db.NAME = 'FlyBase' AND f.uniquename = 'FBba0000005';

SELECT p.uniquename, p.miniref, p.title
 FROM feature f, pub p, feature_pub fp
 WHERE f.uniquename = 'FBba0000005' AND f.feature_id=fp.feature_id AND
 fp.pub_id=p.pub_id;

SELECT p.uniquename, p.pyear, p.title, array_to_string( array(
SELECT pa.surname || ', ' || pa.givennames
 FROM pubauthor pa
 WHERE pa.pub_id=p.pub_id), ', ' ) AS authors, (SELECT pp.VALUE
 FROM pubprop pp, cvterm pp_type
 WHERE pp_type.name='pubmed_fulltext_url' AND pp.pub_id=p.pub_id AND
 pp.type_id=pp_type.cvterm_id) AS fulltext_url, (SELECT pub_in.miniref
 FROM pub pub_in, pub_relationship pr, cvterm pr_type
 WHERE pr_type.name='published_in' AND p.pub_id=pr.subject_id AND
 pr.object_id=pub_in.pub_id AND pr.type_id=pr_type.cvterm_id) AS journal, p.volume, p.issue, p.pages
 FROM pub p
 WHERE p.uniquename='FBrf0126983';

SELECT uniquename
 FROM pub
 WHERE uniquename='FBrf0126983';

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND cvt.name='cam_offprint' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT dbx.accession
 FROM pub p, pub_dbxref pdbx, dbxref dbx, db
 WHERE p.uniquename='FBrf0126983' AND db.name='pubmed' AND
 pdbx.is_current=TRUE AND p.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id = dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND cvt.name='pubmed_abstract' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0188865' AND cvt.name='conf_abs_text' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT dbx.accession
 FROM pub p, pub_dbxref pdbx, dbxref dbx, db
 WHERE p.uniquename='FBrf0126983' AND db.name='biosis' AND
 pdbx.is_current=TRUE AND p.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id = dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT dbx.accession
 FROM pub p, pub_dbxref pdbx, dbxref dbx, db
 WHERE p.uniquename='FBrf0025508' AND db.name='zoorec_id' AND
 pdbx.is_current=TRUE AND p.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id = dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0148886' AND cvt.name='associated_text' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0188739' AND cvt.name='perscommtext' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0191798' AND cvt.name='deposited_files' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT related_pub.uniquename, related_pub.miniref, pub_type.name
 FROM pub p, pub_relationship pr, pub related_pub, cvterm rel_type, cvterm pub_type
 WHERE p.uniquename='FBrf0000634' AND rel_type.name='related_to' AND
 p.pub_id=pr.object_id AND pr.subject_id=related_pub.pub_id AND
 pr.type_id=rel_type.cvterm_id AND related_pub.type_id=pub_type.cvterm_id UNION
SELECT related_pub.uniquename, related_pub.miniref, pub_type.name
 FROM pub p, pub_relationship pr, pub related_pub, cvterm rel_type, cvterm pub_type
 WHERE p.uniquename='FBrf0000634' AND rel_type.name='related_to' AND
 p.pub_id=pr.subject_id AND pr.object_id=related_pub.pub_id AND
 pr.type_id=rel_type.cvterm_id AND related_pub.type_id=pub_type.cvterm_id;

SELECT related_pub.uniquename, related_pub.miniref, pub_type.name
 FROM pub p, pub_relationship pr, pub related_pub, cvterm rel_type, cvterm pub_type
 WHERE p.uniquename='FBrf0000424' AND rel_type.name='also_in' AND
 p.pub_id=pr.object_id AND pr.subject_id=related_pub.pub_id AND
 pr.type_id=rel_type.cvterm_id AND related_pub.type_id=pub_type.cvterm_id UNION
SELECT related_pub.uniquename, related_pub.miniref, pub_type.name
 FROM pub p, pub_relationship pr, pub related_pub, cvterm rel_type, cvterm pub_type
 WHERE p.uniquename='FBrf0000424' AND rel_type.name='also_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=related_pub.pub_id AND
 pr.type_id=rel_type.cvterm_id AND related_pub.type_id=pub_type.cvterm_id;

SELECT dbx.accession
 FROM pub p, pub_dbxref pdbx, dbxref dbx, db
 WHERE p.uniquename='FBrf0000810' AND db.name='FlyBase' AND
 pdbx.is_current=FALSE AND p.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id = dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0000002' AND cvt.name='languages' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT pp.VALUE
 FROM pub p, pubprop pp, cvterm cvt
 WHERE p.uniquename='FBrf0064412' AND cvt.name='abstract_languages' AND
 p.pub_id=pp.pub_id AND pp.type_id=cvt.cvterm_id;

SELECT dbx.accession
 FROM pub p, pub_dbxref pdbx, dbxref dbx, db
 WHERE p.uniquename='FBrf0019088' AND db.name='isbn' AND
 pdbx.is_current=TRUE AND p.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id = dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT pubplace
 FROM pub
 WHERE uniquename ='FBrf0075564';

SELECT pub_in.miniref
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pub_in.title
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT array_to_string( array(
SELECT pa.surname || ', ' || pa.givennames
 FROM pubauthor pa
 WHERE pa.pub_id=pub_in.pub_id), ', ' ) AS authors
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0191612' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pub_in.volume
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pub_in.pyear
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pub_in.pages
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pub_in.publisher
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pub_in.pubplace
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type
 WHERE p.uniquename='FBrf0126983' AND rel_type.name='published_in' AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id;

SELECT pp.VALUE
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type, pubprop pp,
 cvterm pp_type
 WHERE p.uniquename='FBrf0002356' AND rel_type.name='published_in' AND
 pp_type.name='languages' AND p.pub_id=pr.subject_id AND
 pr.object_id=pub_in.pub_id AND pr.type_id=rel_type.cvterm_id AND
 pp.type_id=pp_type.cvterm_id AND pub_in.pub_id=pp.pub_id;

SELECT dbx.accession
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type, pub_dbxref pdbx,
 dbxref dbx, db
 WHERE p.uniquename='FBrf0000051' AND rel_type.name='published_in' AND
 db.name IN ('isbn','issn') AND pdbx.is_current=TRUE AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id AND pub_in.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id=dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT dbx.accession
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type, pub_dbxref pdbx,
 dbxref dbx, db
 WHERE p.uniquename='FBrf0000015' AND rel_type.name='published_in' AND
 db.name='coden' AND pdbx.is_current=TRUE AND
 p.pub_id=pr.subject_id AND pr.object_id=pub_in.pub_id AND
 pr.type_id=rel_type.cvterm_id AND pub_in.pub_id=pdbx.pub_id AND
 pdbx.dbxref_id=dbx.dbxref_id AND dbx.db_id=db.db_id;

SELECT pp.VALUE
 FROM pub p, pub pub_in, pub_relationship pr, cvterm rel_type, pubprop pp,
 cvterm pp_type
 WHERE p.uniquename='FBrf0002356' AND rel_type.name='published_in' AND
 pp_type.name='deposted_files' AND p.pub_id=pr.subject_id AND
 pr.object_id=pub_in.pub_id AND pr.type_id=rel_type.cvterm_id AND
 pp.type_id=pp_type.cvterm_id AND pub_in.pub_id=pp.pub_id;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBgn%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBtr%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBpp%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBal%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename ~ 'FB(tp|ms|mc)[0-9]+$' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBti%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBab%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBba%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBcl%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT s.synonym_sgml
 FROM pub p, feature_pub fp, feature f, feature_synonym fs, synonym s,
 cvterm cvt
 WHERE p.uniquename='FBrf0126983' AND f.uniquename LIKE 'FBte%' AND
 cvt.name='symbol' AND fs.is_current=TRUE AND
 p.pub_id=fp.pub_id AND fp.feature_id=f.feature_id AND
 f.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=cvt.cvterm_id GROUP BY s.synonym_sgml;

SELECT DISTINCT s.synonym_sgml
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt.cvterm_id AND cvt.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBtp0000001';

SELECT f.uniquename
 FROM feature f
 WHERE f.uniquename = 'FBtp0000001';

SELECT cvt.name
 FROM feature f, cvterm cvt
 WHERE f.uniquename = 'FBtp0000001' AND f.type_id=cvt.cvterm_id;

SELECT f.timeaccessioned,f.timelastmodified
 FROM feature f
 WHERE f.uniquename = 'FBtp0000001';

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0018202' AND (fp_type.name='kb_length' OR
 fp_type.name='compiled_kb_length') AND f.feature_id=fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0036669' AND fp_type.name='derived_expression_data' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature tp, feature ins, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE tp.uniquename='FBtp0036624' AND fs.is_current='t' AND
 fs.is_internal='f' AND fs_type.NAME='symbol' AND
 fr_type.NAME='producedby' AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=ins.feature_id AND
 ins.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=fs_type.cvterm_id;

SELECT o.genus,o.species
 FROM feature f, organism o
 WHERE f.uniquename='FBtp0000001' AND f.organism_id=o.organism_id;

SELECT cvt.name
 FROM feature f, feature_cvterm fcvt, cvterm cvt, cv
 WHERE f.uniquename='FBtp0022777' AND cv.name='transgene_description' AND
 f.feature_id=fcvt.feature_id AND fcvt.cvterm_id=cvt.cvterm_id AND
 cvt.cv_id=cv.cv_id;

SELECT fcvtp.VALUE
 FROM feature f, feature_cvterm fcvt, feature_cvtermprop fcvtp, cvterm cvt, cv
 WHERE f.uniquename='FBtp0022777' AND cv.name='transgene_description' AND
 fcvt.feature_cvterm_id=fcvtp.feature_cvterm_id AND f.feature_id=fcvt.feature_id AND
 fcvt.cvterm_id=cvt.cvterm_id AND cvt.cv_id=cv.cv_id;

SELECT p.uniquename
 FROM feature f, feature_cvterm fcvt, pub p, cvterm cvt, cv
 WHERE f.uniquename='FBtp0022777' AND cv.name='transgene_description' AND
 fcvt.pub_id=p.pub_id AND f.feature_id=fcvt.feature_id AND
 fcvt.cvterm_id=cvt.cvterm_id AND cvt.cv_id=cv.cv_id;

SELECT cvt.name
 FROM feature f, feature_cvterm fcvt, cvterm cvt, cv
 WHERE f.uniquename='FBtp0022777' AND cv.name='transgene_uses' AND
 f.feature_id=fcvt.feature_id AND fcvt.cvterm_id=cvt.cvterm_id AND
 cvt.cv_id=cv.cv_id;

SELECT fcvtp.VALUE
 FROM feature f, feature_cvterm fcvt, feature_cvtermprop fcvtp, cvterm cvt, cv
 WHERE f.uniquename='FBtp0022777' AND cv.name='transgene_uses' AND
 fcvt.feature_cvterm_id=fcvtp.feature_cvterm_id AND f.feature_id=fcvt.feature_id AND
 fcvt.cvterm_id=cvt.cvterm_id AND cvt.cv_id=cv.cv_id;

SELECT p.uniquename
 FROM feature f, feature_cvterm fcvt, pub p, cvterm cvt, cv
 WHERE f.uniquename='FBtp0022777' AND cv.name='transgene_uses' AND
 fcvt.pub_id=p.pub_id AND f.feature_id=fcvt.feature_id AND
 fcvt.cvterm_id=cvt.cvterm_id AND cvt.cv_id=cv.cv_id;

SELECT arm.name, fl.fmin+1, fl.fmax
 FROM feature f, featureloc fl, feature arm
 WHERE f.uniquename='FBtp0000078' AND f.feature_id=fl.feature_id AND
 fl.srcfeature_id=arm.feature_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0036625' AND fp_type.name='comment' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0018202' AND (fp_type.name='kb_length' OR
 fp_type.name='compiled_kb_length') AND f.feature_id=fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0000078' AND fp_type.name='original_left_end' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0000078' AND fp_type.name='original_right_end' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fr.rank
 FROM feature f, feature seg, feature_relationship fr, cvterm fr_type
 WHERE f.uniquename='FBtp0000078' AND fr_type.name='partof' AND
 f.feature_id=fr.object_id AND fr.subject_id=seg.feature_id AND
 fr.type_id=fr_type.cvterm_id;

SELECT frp.VALUE
 FROM feature f, feature seg, feature_relationship fr, cvterm fr_type, cvterm frp_type,
 feature_relationshipprop frp
 WHERE f.uniquename='FBtp0000078' AND fr_type.name='partof' AND
 frp_type.name='relative_orientation' AND f.feature_id=fr.object_id AND
 fr.subject_id=seg.feature_id AND fr.type_id=fr_type.cvterm_id AND
 fr.feature_relationship_id=frp.feature_relationship_id AND frp.type_id=frp_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature f, feature seg, feature_relationship fr, cvterm fr_type, feature_synonym fs,
 synonym s, cvterm s_type
 WHERE f.uniquename='FBtp0000078' AND fr_type.name='partof' AND
 fs.is_current=TRUE AND s_type.name='symbol' AND
 f.feature_id=fr.object_id AND fr.subject_id=seg.feature_id AND
 fr.type_id=fr_type.cvterm_id AND seg.feature_id=fs.feature_id AND
 fs.synonym_id=s.synonym_id AND s.type_id=s_type.cvterm_id;

SELECT p.uniquename
 FROM feature f, feature seg, feature_relationship fr, cvterm fr_type, feature_relationship_pub frp,
 pub p
 WHERE f.uniquename='FBtp0000078' AND fr_type.name='partof' AND
 f.feature_id=fr.object_id AND fr.subject_id=seg.feature_id AND
 fr.type_id=fr_type.cvterm_id AND fr.feature_relationship_id=frp.feature_relationship_id AND
 frp.pub_id=p.pub_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0022777' AND fp_type.name='derived_transgene_features' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0022777' AND fp_type.name='derived_transgene_features' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT p.uniquename
 FROM feature f, featureprop fp, featureprop_pub fpp, pub p, cvterm fp_type
 WHERE f.uniquename='FBtp0022777' AND fp_type.name='derived_transgene_features' AND
 f.feature_id=fp.feature_id AND fp.type_id=fp_type.cvterm_id AND
 fp.featureprop_id=fpp.featureprop_id AND fpp.pub_id=p.pub_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature tp, feature al, feature_relationship fr, feature_synonym fs, synonym s,
 cvterm fs_type, cvterm fr_type
 WHERE tp.uniquename = 'FBtp0022777' AND fs.is_current = 't' AND
 fs.is_internal = 'f' AND fs_type.NAME = 'symbol' AND
 fr_type.NAME='derived_tp_assoc_alleles' AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=al.feature_id AND
 al.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 s.type_id = fs_type.cvterm_id;

SELECT p.uniquename
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, feature_relationship_pub frp,
 pub p
 WHERE tp.uniquename = 'FBtp0022777' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND fr.feature_relationship_id=frp.feature_relationship_id AND
 frp.pub_id=p.pub_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0022777' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 fp_type.name='molecular_info' AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=al.feature_id AND
 al.feature_id = fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0022777' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 fp_type.name='derived_pheno_class' AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=al.feature_id AND
 al.feature_id = fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0022777' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 fp_type.name='derived_pheno_manifest' AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=al.feature_id AND
 al.feature_id = fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0022777' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 fp_type.name='derived_allele_phendesc' AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=al.feature_id AND
 al.feature_id = fp.feature_id AND fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0036669' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_cv' OR fp_type.name='derived_polypeptide_bodypart_expression_cv') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0036669' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_cv' OR fp_type.name='derived_polypeptide_bodypart_expression_cv') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT DISTINCT p.uniquename
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 featureprop_pub fpp, pub p, cvterm fp_type
 WHERE tp.uniquename = 'FBtp0036669' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_cv' OR fp_type.name='derived_polypeptide_bodypart_expression_cv') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id AND fp.featureprop_id=fpp.featureprop_id AND
 fpp.pub_id=p.pub_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0001557' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_text' OR fp_type.name='derived_polypeptide_bodypart_expression_text') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT DISTINCT p.uniquename
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 featureprop_pub fpp, pub p, cvterm fp_type
 WHERE tp.uniquename = 'FBtp0001557' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_text' OR fp_type.name='derived_polypeptide_bodypart_expression_text') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id AND fp.featureprop_id=fpp.featureprop_id AND
 fpp.pub_id=p.pub_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0036669' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_cv' OR fp_type.name='derived_polypeptide_bodypart_expression_cv') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT fp.VALUE
 FROM feature tp, feature al, feature_relationship fr, cvterm fr_type, featureprop fp,
 cvterm fp_type
 WHERE tp.uniquename = 'FBtp0000365' AND fr_type.NAME='derived_tp_assoc_alleles' AND
 (fp_type.name='derived_transcript_bodypart_expression_marker' OR fp_type.name='derived_polypeptide_bodypart_expression_marker') AND
 tp.feature_id=fr.object_id AND fr.type_id=fr_type.cvterm_id AND
 fr.subject_id=al.feature_id AND al.feature_id = fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature tp, feature al, feature tr, feature gn, feature_relationship fr1,
 feature_relationship fr2, feature_relationship fr3, cvterm fr1_type, cvterm fr2_type, cvterm fr3_type,
 feature_synonym fs, synonym s, cvterm s_type
 WHERE tp.uniquename = 'FBtp0000362' AND fr1_type.NAME='derived_tp_assoc_alleles' AND
 fr2_type.name='partof' AND fr3_type.name='attributed_as_expression_of' AND
 fs.is_current=TRUE AND fs.is_internal=FALSE AND
 s_type.name='symbol' AND tp.feature_id=fr1.object_id AND
 fr1.type_id=fr1_type.cvterm_id AND fr1.subject_id=al.feature_id AND
 al.feature_id = fr2.object_id AND fr2.type_id=fr2_type.cvterm_id AND
 fr2.subject_id=tr.feature_id AND tr.feature_id=fr3.subject_id AND
 fr3.type_id=fr3_type.cvterm_id AND fr3.object_id=gn.feature_id AND
 gn.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature tp, feature prog, feature_relationship fr, cvterm fr_type, feature_synonym fs,
 synonym s, cvterm s_type
 WHERE tp.uniquename='FBtp0001096' AND fr_type.name='in_vitro_descendant_of' AND
 s_type.name='symbol' AND fs.is_current=TRUE AND
 fs.is_internal=FALSE AND tp.feature_id=fr.subject_id AND
 fr.type_id=fr_type.cvterm_id AND fr.object_id=prog.feature_id AND
 prog.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature tp, feature descn, feature_relationship fr, cvterm fr_type, feature_synonym fs,
 synonym s, cvterm s_type
 WHERE tp.uniquename='FBmc0001085' AND fr_type.name='in_vitro_descendant_of' AND
 s_type.name='symbol' AND fs.is_current=TRUE AND
 fs.is_internal=FALSE AND tp.feature_id=fr.object_id AND
 fr.type_id=fr_type.cvterm_id AND fr.subject_id=descn.feature_id AND
 descn.feature_id=fs.feature_id AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id;

SELECT fp.VALUE
 FROM feature f, featureprop fp, cvterm fp_type
 WHERE f.uniquename='FBtp0036625' AND (fp_type.name='comment' OR
 fp_type.name='restriction_sites') AND f.feature_id=fp.feature_id AND
 fp.type_id=fp_type.cvterm_id;

SELECT DISTINCT s.synonym_sgml
 FROM feature tp, feature_synonym fs, synonym s, cvterm s_type
 WHERE tp.uniquename='FBtp0036625' AND tp.feature_id=fs.feature_id AND
 fs.is_internal=FALSE AND fs.synonym_id=s.synonym_id AND
 s.type_id=s_type.cvterm_id AND s_type.name='symbol';

SELECT dbx.accession
 FROM feature tp, feature_dbxref fdbx, dbxref dbx, db
 WHERE tp.uniquename='FBtp0023480' AND tp.feature_id=fdbx.feature_id AND
 fdbx.is_current=FALSE AND fdbx.dbxref_id=dbx.dbxref_id AND
 dbx.db_id=db.db_id AND db.name='FlyBase';

SELECT p.uniquename, p.miniref, p.title
 FROM feature f, pub p, feature_pub fp
 WHERE f.uniquename = 'FBtp0023480' AND f.feature_id=fp.feature_id AND
 fp.pub_id=p.pub_id;

SELECT DISTINCT(s.synonym_sgml)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt2
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'symbol' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBte0000001';

SELECT o.genus, o.species
 FROM feature f, organism o
 WHERE f.is_obsolete = 'f' AND f.uniquename ='FBte0000001' AND
 f.organism_id = o.organism_id;

SELECT DISTINCT(s.synonym_sgml)
 FROM feature f, feature_synonym fs, synonym s, cvterm cvt2
 WHERE f.feature_id = fs.feature_id AND fs.synonym_id = s.synonym_id AND
 fs.is_current = 't' AND fs.is_internal = 'f' AND
 s.type_id = cvt2.cvterm_id AND cvt2.name = 'fullname' AND
 f.is_obsolete = 'f' AND f.uniquename = 'FBte0000001';

SELECT timeaccessioned, timelastmodified
 FROM feature f
 WHERE uniquename = 'FBte0000001' AND is_obsolete='f';

SELECT fp.VALUE , pub.uniquename
 FROM featureprop fp, feature f, cvterm cvt, featureprop_pub fpp, pub
 WHERE cvt.name='TE_total_length' AND cvt.cvterm_id=fp.type_id AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001' AND
 fp.featureprop_id=fpp.featureprop_id AND fpp.pub_id=pub.pub_id AND
 fp.feature_id=f.feature_id;

SELECT fp.VALUE , pub.uniquename
 FROM featureprop fp, feature f, cvterm cvt, featureprop_pub fpp, pub
 WHERE cvt.name='TE_repeat_length' AND cvt.cvterm_id=fp.type_id AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001' AND
 fp.featureprop_id=fpp.featureprop_id AND fpp.pub_id=pub.pub_id AND
 fp.feature_id=f.feature_id;

SELECT fp.name
 FROM feature f, feature fp, feature_relationship fr, cvterm cvt
 WHERE fr.subject_id=f.feature_id AND fr.object_id=fp.feature_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='has_component_gene' AND
 f.uniquename='FBte0000001' AND f.is_obsolete='f';

SELECT dbxref.accession
 FROM dbxref, feature_dbxref fd, feature f, db
 WHERE f.feature_id=fd.feature_id AND dbxref.dbxref_id=fd.dbxref_id AND
 fd.is_current='f' AND dbxref.db_id=db.db_id AND
 db.name LIKE 'GB%' AND f.uniquename='FBte0000001' AND
 f.is_obsolete='f';

SELECT fo.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, cvterm cvt2
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND cvt.name='associated_with' AND
 fo.type_id= cvt2.cvterm_id AND cvt2.name='transposable_element_flanking_region' AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001';

SELECT c.name
 FROM cvterm c, feature f, feature_cvterm fc, cv
 WHERE fc.feature_id=f.feature_id AND c.cvterm_id=fc.cvterm_id AND
 c.cv_id=cv.cv_id AND cv.name='SO' AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='TE_copies_in_genome' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT s.name
 FROM feature f, feature_relationship fr, cvterm c, feature s
 WHERE f.feature_id=fr.object_id AND fr.type_id=c.cvterm_id AND
 c.name='producedby' AND fr.subject_id=s.feature_id AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='TE_copies_in_sequenced_genome' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='TE_duplication_length' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='TE_target_sequence' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fo.name, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, feature_relationship_pub frp,
 pub
 WHERE fo.feature_id=fr.object_id AND f.feature_id=fr.subject_id AND
 fr.type_id=cvt.cvterm_id AND frp.feature_relationship_id=fr.feature_relationship_id AND
 pub.pub_id=frp.pub_id AND cvt.name='isolate_of' AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001';

SELECT fo.name, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, feature_relationship_pub frp,
 pub
 WHERE fo.feature_id=fr.subject_id AND fo.is_obsolete='f' AND
 f.feature_id=fr.object_id AND fr.type_id=cvt.cvterm_id AND
 frp.feature_relationship_id=fr.feature_relationship_id AND pub.pub_id=frp.pub_id AND
 cvt.name='in_vitro_descendant_of' AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fo.name, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, feature_relationship_pub frp,
 pub
 WHERE fo.feature_id=fr.subject_id AND fo.is_obsolete='f' AND
 f.feature_id=fr.object_id AND fr.type_id=cvt.cvterm_id AND
 frp.feature_relationship_id=fr.feature_relationship_id AND pub.pub_id=frp.pub_id AND
 (cvt.name='in_vitro_descendant_of' OR cvt.name='belongs_to') AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001';

SELECT fo.name, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, feature_relationship_pub frp,
 pub
 WHERE fo.feature_id=fr.subject_id AND fo.is_obsolete='f' AND
 f.feature_id=fr.object_id AND fr.type_id=cvt.cvterm_id AND
 frp.feature_relationship_id=fr.feature_relationship_id AND pub.pub_id=frp.pub_id AND
 cvt.name='alleleof' AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fo.name, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, feature_relationship_pub frp,
 pub
 WHERE fo.feature_id=fr.subject_id AND fo.is_obsolete='f' AND
 f.feature_id=fr.object_id AND fr.type_id=cvt.cvterm_id AND
 frp.feature_relationship_id=fr.feature_relationship_id AND pub.pub_id=frp.pub_id AND
 cvt.name='homologue' AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001' UNION
SELECT fo.name, pub.uniquename
 FROM feature fo, feature f, feature_relationship fr, cvterm cvt, feature_relationship_pub frp,
 pub
 WHERE fo.feature_id=fr.object_id AND fo.is_obsolete='f' AND
 f.feature_id=fr.subject_id AND fr.type_id=cvt.cvterm_id AND
 frp.feature_relationship_id=fr.feature_relationship_id AND pub.pub_id=frp.pub_id AND
 cvt.name='homologue' AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='comment' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='etymology' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT fp.VALUE, pub.uniquename
 FROM featureprop fp, feature f, featureprop_pub frp, cvterm cvt, pub
 WHERE fp.feature_id=f.feature_id AND fp.type_id=cvt.cvterm_id AND
 cvt.name='phylogentic_range' AND pub.pub_id=frp.pub_id AND
 frp.featureprop_id=fp.featureprop_id AND f.is_obsolete='f' AND
 f.uniquename='FBte0000001';

SELECT dbxref.accession
 FROM dbxref, feature_dbxref fd, feature f, db
 WHERE f.feature_id=fd.feature_id AND dbxref.dbxref_id=fd.dbxref_id AND
 fd.is_current='f' AND dbxref.db_id=db.db_id AND
 (db.name LIKE 'GB%' OR db.name ='UNIPROT/TREMBL' )AND f.uniquename='FBte0000001' AND
 f.is_obsolete='f' AND fd.is_current='t';

SELECT f.uniquename, f.name, db.name, accession
 FROM feature f, feature_dbxref fd, dbxref dx, dbxrefprop dxp, cvterm cvt
 WHERE f.feature_id = fd.feature_id AND fd.dbxref_id = dx.dbxref_id AND
 dx.dbxref_id = dxp.dbxref_id AND dxp.type_id = cvt.cvterm_id AND
 cvt.name = 'linkout' AND f.is_obsolete='f' AND
 f.uniquename = 'FBsf0000000001';

SELECT s.synonym_sgml, pub.uniquename
 FROM feature_synonym fs, feature f, synonym s, cvterm cvt, pub
 WHERE fs.feature_id=f.feature_id AND fs.synonym_id=s.synonym_id AND
 fs.is_internal='f' AND fs.pub_id=pub.pub_id AND
 cvt.cvterm_id=s.type_id AND cvt.name='symbol' AND
 f.is_obsolete='f' AND f.uniquename='FBti0000001';

SELECT s.synonym_sgml, pub.uniquename
 FROM feature_synonym fs, feature f, synonym s, cvterm cvt, pub
 WHERE fs.feature_id=f.feature_id AND fs.synonym_id=s.synonym_id AND
 fs.is_internal='f' AND fs.pub_id=pub.pub_id AND
 cvt.cvterm_id=s.type_id AND cvt.name='fullname' AND
 f.is_obsolete='f' AND f.uniquename='FBte0000001';

SELECT dbxref.accession
 FROM dbxref, feature_dbxref fd, feature f, db
 WHERE f.feature_id=fd.feature_id AND dbxref.dbxref_id=fd.dbxref_id AND
 fd.is_current='f' AND dbxref.db_id=db.db_id AND
 db.name='FlyBase' AND f.uniquename='FBte0000001' AND
 f.is_obsolete='f';

SELECT f.uniquename, f.name, cvt.name AS pub_type, p.uniquename AS FBrf_id, miniref AS citation
 FROM feature f, feature_pub fp, pub p, cvterm cvt
 WHERE f.feature_id = fp.feature_id AND fp.pub_id = p.pub_id AND
 p.type_id = cvt.cvterm_id AND f.uniquename = 'FBte0000001' ORDER BY cvt.name;