蛋白質100gあたりのアミノ酸組成

食事で摂取する蛋白質100gあたりのアミノ酸組成が何gずつあるのか述べた論文があったのでテーブルを作成してマスターにしておきます．

USE NSTDB;

GO

IF OBJECT_ID('dbo.M_AminoAcid') IS NOT NULL 

	DROP TABLE dbo.M_AminoAcid;

GO

CREATE TABLE dbo.M_AminoAcid(

	AA	nchar(3)	NOT NULL CONSTRAINT PK_AMINOACID PRIMARY KEY, 

	AminoAcid	nvarchar(13)	NOT NULL,

	dailydose	decimal(2, 1)	NOT NULL,

	unit	nchar(10)	NOT NULL,

	Essential	nchar(1)	NOT NULL);

INSERT INTO dbo.M_AminoAcid VALUES('His', 'Histidine', 1.6, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Ile', 'Isoleucine', 5.2, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Leu', 'Leucine', 7.4, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Lys', 'Lysine', 5.0, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Met', 'Methionine', 1.4, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Phe', 'Phenylalanine', 4.6, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Thr', 'Threonine', 4.0, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Trp', 'Tryptophan', 0.8, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Val', 'Valine', 4.8, 'g/100g/day', 'E');

INSERT INTO dbo.M_AminoAcid VALUES('Ala', 'Alanine', 5.8, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Arg', 'Arginine', 5.4, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Asn', 'Asparagine', 7.4, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Asp', 'Aspartic acid', 3.2, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Cys', 'Cysteine', 2.2, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Gln', 'Glutamine', 9.6, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Glu', 'Glutamic acid', 8.0, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Gly', 'Glycine', 7.6, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Pro', 'Proline', 5.6, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Ser', 'Serine', 7.2, 'g/100g/day', 'N');

INSERT INTO dbo.M_AminoAcid VALUES('Tyr', 'Tyrosine', 2.2, 'g/100g/day', 'N');

なお，以下のクエリを実行しても合計100gにはなりません．

SELECT SUM(dailydose) FROM dbo.M_AminoAcid;

渡辺　明治　Pharma Medica 20(9)2002, 197-212