Sha256: 93b28738eb342149c6d25663440f1af073f37548763c5d691c7b367903b900ce

Contents?: true

Size: 707 Bytes

Versions: 4

Compression:

Stored size: 707 Bytes

Contents

SELECT 
  db."name", 
  db.description, 
  db.urlprefix, 
  db.url, 
  db.db_id
FROM 
  public.cvterm gene, 
  public.cvterm_relationship is_a_relationship, 
  public.cvterm biological_region, 
  public.dbxref, 
  public.cvterm is_a_cvterm, 
  public.dbxref is_a_dbxref, 
  public.db
WHERE 
  gene.cvterm_id = is_a_relationship.subject_id AND
  is_a_relationship.object_id = biological_region.cvterm_id AND
  is_a_relationship.type_id = is_a_cvterm.cvterm_id AND
  biological_region.dbxref_id = dbxref.dbxref_id AND
  is_a_cvterm.dbxref_id = is_a_dbxref.dbxref_id AND
  is_a_dbxref.db_id = db.db_id AND
  gene.cv_id = 10 AND 
  gene."name" = 'gene' AND 
  biological_region."name" = 'biological_region';

Version data entries

4 entries across 4 versions & 1 rubygems

Version Path
obo-0.1.5 test/data/temp
obo-0.1.4 test/data/temp
obo-0.1.3 test/data/temp
obo-0.1.0 test/data/temp