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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!