Question: I need the query or command you used within MySQL for each of these questions. Here is a part of the 40 some-odd tables shown
I need the query or command you used within MySQL for each of these questions.
Here is a part of the 40 some-odd tables shown when you run the command show tables;
...
| cm_genes |
| cm_proteins |
| cv |
| cvterm |
| cvterm_dbxref |
| cvterm_relationship |
| cvtermpath |
| cvtermprop |
| cvtermsynonym |
| db |
...
Here is the cv table shown with describe cv;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| cv_id | int(11) | NO | PRI | NULL | |
| name | varchar(255) | NO | UNI | NULL | |
| definition | varchar(255) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
These are the questions
1) Which ID (cv_id) corresponds to the GO ontology stored in the database?
2) How many controlled vocabulary terms (cvterm table) are linked to the GO ontology?
3) Which ontology in the database has the most linked terms?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
