OnWorks favicon

gmod_load_cvterms.plp - Online in the Cloud

Run gmod_load_cvterms.plp in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command gmod_load_cvterms.plp that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator



load_cvterms.pl - compares which terms are new in the file compared to the database and
inserts them


Usage: perl load_cvterms.pl -H dbhost -D dbname [-vdntuFo] file


-g GMOD database profile name (can provide host, DB name, password, username, and
driver) Default: 'default'

-s database name for linking (must be in db table, e.g. GO )

-n controlled vocabulary name (e.g 'biological_process'). optional. If not given,
terms of all namespaces related with database name will be handled.

-F File format. Can be obo or go_flat and others supported by Bio::OntologyIO.
Default: obo

-u update all the terms. Without -u, the terms in the database won't be updated to
the contents of the file, in terms of definitions, etc. New terms will still be

-v verbose output

-o outfile for writing errors and verbose messages (optional)

-t trial mode. Don't perform any store operations at all. (trial mode cannot test
inserting associated data for new terms)

The following options are required if not using GMOD profile

-H hostname for database [required if -p isn't used]

-D database name [required if -p isn't used]

-p password (if you need to provide a password to connect to your db)

-r username (if you need to provide a username to connect to your database)

-d driver name (e.g. 'Pg' for postgres). Driver name can be provided in gmod_config

The script parses the ontology in the file and the corresponding ontology in the database,
if present. It compares which terms are new in the file compared to the database and
inserts them, and compares all the relationships that are new and inserts them. It removes
the relationships that were not specified in the file from the database. It never removes
a term entry from the database.

This script works with Chado schema (see gmod.org) and accesse the following tables:


Terms that are in the database but not in the file are set to is_obsolete=1. All the
terms that are present in the database are updated (if using -u option) to reflect the
term definitions that are in the file. New terms that are in the file but not in the
database are stored. The following data are associated with each term insert/update:

Term name
Term definition
Relationships with other terms
Secondary ids
Definition dbxrefs

Use gmod_load_cvterms.plp online using onworks.net services

Free Servers & Workstations

Download Windows & Linux apps

  • 1
    Osu! is a simple rhythm game with a well
    thought out learning curve for players
    of all skill levels. One of the great
    aspects of Osu! is that it is
    Download Osu!
  • 2
    LIBPNG: PNG reference library
    LIBPNG: PNG reference library
    Reference library for supporting the
    Portable Network Graphics (PNG) format.
    Audience: Developers. Programming
    Language: C. This is an application that
    can also...
    Download LIBPNG: PNG reference library
  • 3
    Metal detector based on  RP2040
    Metal detector based on RP2040
    Based on Raspberry Pi Pico board, this
    metal detector is included in pulse
    induction metal detectors category, with
    well known advantages and disadvantages.
    Download Metal detector based on RP2040
  • 4
    PAC Manager
    PAC Manager
    PAC is a Perl/GTK replacement for
    SecureCRT/Putty/etc (linux
    ssh/telnet/... gui)... It provides a GUI
    to configure connections: users,
    passwords, EXPECT regula...
    Download PAC Manager
  • 5
    GeoServer is an open-source software
    server written in Java that allows users
    to share and edit geospatial data.
    Designed for interoperability, it
    publishes da...
    Download GeoServer
  • 6
    Firefly III
    Firefly III
    A free and open-source personal finance
    manager. Firefly III features a
    double-entry bookkeeping system. You can
    quickly enter and organize your
    transactions i...
    Download Firefly III
  • More »

Linux commands