check-db.yaml

'PomBase::Check::FeatureCount':
  min_count: 10000
query_checks:
  - name: pombe_genes
    expected: '>= 6980'
    query: |
      select count(*) from feature f, cvterm cvt, organism o where
      f.type_id = cvt.cvterm_id and f.organism_id = o.organism_id and
      o.common_name = 'pombe' and cvt.name = 'gene';
  - name: no_duplicate_pombe_gene_names
    expected: 0
    query: |
      with duplicates as (select count(feature_id), name from feature where
      name is not null and type_id = (select cvterm_id from cvterm where cv_id
      = (select cv_id from cv where name = 'sequence') and name = 'gene') and
      organism_id = (select organism_id from organism where abbreviation =
      'Spombe') group by name having count(feature_id) > 1) select count(*)
      from duplicates;