Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MySQL: Write a query to return the Codon_sequence for all amino acids sorted from smallest to highest molecular mass. Name Alanine Arginine Asparagine Aspartic acid

MySQL:

Write a query to return the Codon_sequence for all amino acids sorted from smallest

to highest molecular mass.

image text in transcribed

image text in transcribed

image text in transcribed

Name Alanine Arginine Asparagine Aspartic acid Cysteine Glutamic acid Glutamine Glycine Histidine Isoleucine Leucine Lysine Molecular_mass Polarity Charge 89 non polar uncharged 175 polar positive 132 polar uncharged 132 polar negative 121 polar uncharged 146 polar negative 146 polar uncharged 75 non polar uncharged 155 polar positive 131 non polar uncharged 131 non polar uncharged 147 polar positive 149 non polar uncharged 165 non polar uncharged 115 non polar uncharged 105 polar uncharged 119 polar uncharged 204 non polar uncharged 181 polar uncharged 117 non polar uncharged Methionine Phenylalanine Proline Serine Threonine Tryptophan Tyrosine Valine Codon_id Codon_sequence c1 TTT Position 1 T Position2 T Position3 Amino_acid_id T a5 c10 ATC A T C a8 c11 ATA A T a8 c12 ATG A T a 11 c13 GTT G T T a 18 c14 GTC G T a 18 c15 GTA G T 0 0 0 0 A a 18 c16 GTG G T a 18 c17 T T a 16 TCT TCC c18 T 0 0 0 a 16 c19 TCA T A a 16 c2 TTC T T a5 c20 TCG T C G a 16 c21 CCT T a 13 c22 CCC a 13 c23 CCA c A a13 c24 CCG G a 13 c25 ACT A C T a 17 c26 ACC A a17 c27 ACA A A a17 c28 ACG A G a 17 c29 GCT G T a 1 c3 TTA T T A a 10 c30 GCC G C C a1 C31 GCA G A a 1 Code a1 Ala Leu Met Amino_id Symbol Name Alanine a 10 L Leucine a 11 M Methionine a12 N Asparagine a 13 P Proline a 14 Glutamine a 16 S Serine Asn Pro Gin Ser a 17 T Threonine Thr a 18 V Val Valine Tryptophan a 19 W Trp a2 Cys Cysteine Tyrosine a20 Y Tyr a21 Stop a22 Stop a23 D a4 E a5 F Stop Aspartic acid Asp Glutamic acid Glu Phenylalanine Phe Glycine Gly Histidine His Isoleucine lle a6 G a7 . a8 1 a9 K Lysine Lys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

More Books

Students also viewed these Databases questions