Question: Give the commands for opening a MYSQL program, and then connecting to a database called my_chado. Then write an SQL query that lists the types

Give the commands for opening a MYSQL program, and then connecting to a database called my_chado. Then write an SQL query that lists the types of features in a feature table and gives the count of each. The database contains two tables: 1. feature: all of the feature types are stored in this table: the type_id column gives each different type a different numerical designation. 2. cvterm: each of the numerical types from the feature table is given a plain language name based on names in this table. Each numerical type has a unique identifier listed in a cvterm_id field. 3. The cvterm_id can be linked directly to the type_id field in the feature table.

The output must look like this example:

+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +

: feature type : feature count

+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +

: assembly : 1

: exon : 4200:

:gene : 4200:

: mRNA : 4200:

: polypeptide : 4200:

+- - - - - - - - - - - - - - - + - - - - - - - - - - - - +

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!