sqlite 3.37.0 2021-11-10 15:23:00 8b53ffe99df6f5443bd22a9d95433819eb44c7e8f044c2f3e9d52661741dalt1

X_REAL_IP=18.117.172.189 - X_Forwarded=18.117.172.189, Host=pmb-bordeaux.fr - authorization fixed by rules

HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

SESSID = clfo0ujnjlq0gl40nqkv29v6ls - Session API-Key : 

SELECT  f1.PlantID, f1.Rank, f1.PlantNum, f1.Treatment,
       f2.SampleID, f2.Truss, f2.DevStage, f2.FruitAge, f2.HarvestDate, f2.HarvestHour, f2.FruitPosition, f2.FruitDiameter, f2.FruitHeight, f2.FruitFW, f2.FruitDW, f2.DW,
       f3.AliquotID,
       f5.PGM, f5.cFBPase, f5.PyrK, f5.CitS, f5.PFP, f5.Aconitase, f5.PFK, f5.FruK, f5.pFBPase, f5.GluK, f5.NAD_ISODH, f5.Enolase, f5.NADP_ISODH, f5.PEPC, f5.Aldolase, f5.Succ_CoA_ligase, f5.NAD_MalDH, f5.AlaAT, f5.Fumarase, f5.AspAT, f5.NADP_GluDH, f5.NAD_GAPDH, f5.NADP_GAPDH, f5.NAD_GluDH, f5.TPI, f5.PGK, f5.Neutral_Inv, f5.Acid_Inv, f5.G6PDH, f5.UGPase, f5.SuSy, f5.NAD_ME, f5.ShiDH, f5.NADP_ME, f5.PGI, f5.StarchS, f5.AGPase, f5.SPS,
       f6.PoolID,
       f8.glucose, f8.saccharose, f8.fructose, f8.galactose, f8.mannose, f8.rhamnose, f8.acetate, f8.chlorogenate, f8.citrate, f8.fumarate, f8.galacturonate, f8.malate, f8.quinate, f8.alanine, f8.asparagine, f8.aspartate, f8.GABA, f8.glutamine, f8.glutamate, f8.isoleucine, f8.phenylalanine, f8.tryptophane, f8.tyrosine, f8.valine, f8.pyroglutamate, f8.trigonelline, f8.choline, f8.inositol 
FROM plants.txt f1 
JOIN samples.txt f2 ON (f1.PlantID=f2.PlantID) 
JOIN aliquots.txt f3 ON (f2.SampleID=f3.SampleID) 
JOIN enzymes.txt f5 ON (f3.AliquotID=f5.AliquotID) 
JOIN pools.txt f6 ON (f2.SampleID=f6.SampleID) 
JOIN qnmr_metabo.txt f8 ON (f6.PoolID=f8.PoolID) 
WHERE f1.Treatment='Control'

CREATE TABLE IF NOT EXISTS "FRIM1Quantities"(  "PoolID" TEXT,  "Mass" TEXT,  "glutamate" TEXT,  "aspartate" TEXT,  "glycerate" TEXT,  "G6P" TEXT,  "F6P" TEXT,  "succinate" TEXT,  "malate" TEXT,  "OG" TEXT,  "UDPG" TEXT,  "R5P" TEXT,  "G1P" TEXT,  "Ru5PandX5P" TEXT,  "DHAP" TEXT,  "AMP" TEXT,  "FBP" TEXT,  "shikimate" TEXT,  "RuBP" TEXT,  "S7P" TEXT,  "NAD" TEXT,  "SBP" TEXT,  "aconitate" TEXT,  "ADPG" TEXT,  "NADP" TEXT,  "ADP" TEXT)
CREATE TABLE IF NOT EXISTS "aliquots"(  "SampleID" TEXT,  "AliquotID" TEXT)
CREATE TABLE IF NOT EXISTS "aminoacids"(  "AliquotID" TEXT,  "His" TEXT,  "Asn" TEXT,  "Ser" TEXT,  "Gln" TEXT,  "Gly" TEXT,  "Asp" TEXT,  "Glu" TEXT,  "Thr" TEXT,  "Ala" TEXT,  "Pro" TEXT,  "Tyr" TEXT,  "Lys" TEXT,  "Val" TEXT,  "Ile" TEXT,  "Leu" TEXT,  "Phe" TEXT)
CREATE TABLE IF NOT EXISTS "compounds"(  "AliquotID" TEXT,  "MassBefore" TEXT,  "MassMIA" TEXT,  "RDT" TEXT,  "Starch1" TEXT,  "Starch2" TEXT,  "RHAMNOSE" TEXT,  "ARABINOSE" TEXT,  "XYLOSE" TEXT,  "MANNOSE" TEXT,  "GALACTOSE" TEXT,  "GLUCOSE" TEXT,  "OsesN" TEXT,  "PoidsAU" TEXT,  "PoidsTotal" TEXT,  "PP" TEXT,  "RhamnoseFW" TEXT,  "ArabinoseFW" TEXT,  "XyloseFW" TEXT,  "MannoseFW" TEXT,  "GalactoseFW" TEXT,  "GlucoseFW" TEXT,  "OsesAcidsFW" TEXT,  "TotFW" TEXT)
CREATE TABLE IF NOT EXISTS "enzymes"(  "AliquotID" TEXT,  "PGM" TEXT,  "cFBPase" TEXT,  "PyrK" TEXT,  "CitS" TEXT,  "PFP" TEXT,  "Aconitase" TEXT,  "PFK" TEXT,  "FruK" TEXT,  "pFBPase" TEXT,  "GluK" TEXT,  "NAD_ISODH" TEXT,  "Enolase" TEXT,  "NADP_ISODH" TEXT,  "PEPC" TEXT,  "Aldolase" TEXT,  "Succ_CoA_ligase" TEXT,  "NAD_MalDH" TEXT,  "AlaAT" TEXT,  "Fumarase" TEXT,  "AspAT" TEXT,  "NADP_GluDH" TEXT,  "NAD_GAPDH" TEXT,  "NADP_GAPDH" TEXT,  "NAD_GluDH" TEXT,  "TPI" TEXT,  "PGK" TEXT,  "Neutral_Inv" TEXT,  "Acid_Inv" TEXT,  "G6PDH" TEXT,  "UGPase" TEXT,  "SuSy" TEXT,  "NAD_ME" TEXT,  "ShiDH" TEXT,  "NADP_ME" TEXT,  "PGI" TEXT,  "StarchS" TEXT,  "AGPase" TEXT,  "SPS" TEXT)
CREATE TABLE IF NOT EXISTS "lipids_ag"(  "AliquotID" TEXT,  "DW" TEXT,  "M_AG" TEXT,  "AG" TEXT,  "C16_0" TEXT,  "C18_2" TEXT,  "C18_3" TEXT,  "C18_0" TEXT)
CREATE TABLE IF NOT EXISTS "out"(  "" TEXT)
CREATE TABLE IF NOT EXISTS "plants"(  "PlantID" TEXT,  "Rank" TEXT,  "PlantNum" TEXT,  "Treatment" TEXT)
CREATE TABLE IF NOT EXISTS "plato_HexosesP"(  "AliquotID" TEXT,  "F6P" TEXT,  "G6P" TEXT,  "G1P" TEXT)
CREATE TABLE IF NOT EXISTS "pools"(  "SampleID" TEXT,  "PoolID" TEXT)
CREATE TABLE IF NOT EXISTS "qnmr_metabo"(  "PoolID" TEXT,  "glucose" TEXT,  "saccharose" TEXT,  "fructose" TEXT,  "galactose" TEXT,  "mannose" TEXT,  "rhamnose" TEXT,  "acetate" TEXT,  "chlorogenate" TEXT,  "citrate" TEXT,  "fumarate" TEXT,  "galacturonate" TEXT,  "malate" TEXT,  "quinate" TEXT,  "alanine" TEXT,  "asparagine" TEXT,  "aspartate" TEXT,  "GABA" TEXT,  "glutamine" TEXT,  "glutamate" TEXT,  "isoleucine" TEXT,  "phenylalanine" TEXT,  "tryptophane" TEXT,  "tyrosine" TEXT,  "valine" TEXT,  "pyroglutamate" TEXT,  "trigonelline" TEXT,  "choline" TEXT,  "inositol" TEXT)
CREATE TABLE IF NOT EXISTS "qnmr_pools"(  "PoolID" TEXT,  "weighing1" TEXT,  "weighing2" TEXT,  "DryFreshWeightRatio" TEXT)
CREATE TABLE IF NOT EXISTS "samples"(  "SampleID" TEXT,  "PlantID" TEXT,  "Truss" TEXT,  "DevStage" TEXT,  "FruitAge" TEXT,  "HarvestDate" TEXT,  "HarvestHour" TEXT,  "FruitPosition" TEXT,  "FruitDiameter" TEXT,  "FruitHeight" TEXT,  "FruitFW" TEXT,  "FruitDW" TEXT,  "DW" TEXT)
CREATE INDEX plants_idx ON plants (PlantID)
CREATE INDEX samples_idx ON samples (SampleID)
CREATE INDEX aliquots_idx ON aliquots (AliquotID)
CREATE INDEX cellwall_metabo_idx ON compounds (AliquotID)
CREATE INDEX cellwall_metaboFW_idx ON compounds (AliquotID)
CREATE INDEX activome_idx ON enzymes (AliquotID)
CREATE INDEX pools_idx ON pools (PoolID)
CREATE INDEX qMS_metabo_idx ON FRIM1Quantities (PoolID)
CREATE INDEX qNMR_metabo_idx ON qnmr_metabo (PoolID)
CREATE INDEX plato_hexosesP_idx ON plato_HexosesP (AliquotID)
CREATE INDEX lipids_AG_idx ON lipids_ag (AliquotID)
CREATE INDEX AminoAcid_idx ON aminoacids (AliquotID)