Spreadsheet: 53a873fe-1a2a-45c2-a3f2-f97ec9d7317f
Sheet: Mass

Gland type | Treatment | Sex | MBQ (ug) | EBQ (ug) | 15ene (ug) | 17diene (ug) | 17ene (ug) | Quinones (nmol) | Quinones - percentage in whole beetle | Alkenes (nmol) | Alkenes - percentage in whole beetle | Molar ratio Q/A | Mass ratio Q/A | Molar ratio MBQ/EBQ | Mass ratio MBQ/EBQ | Molar ratio 15ene /A | Molar ratio 17diene /A | Molar ratio 17ene /A
Prothoracic glands | [NAME] | male | 5.39 ±1.63 | 7.08 ±2.15 | 4.71 ±1.2 | 2.39 ±0.64 | 1.08 ±0.27 | 96.21 ±28.97 | 0.3952915074571675 | 37.06 ±9.44 | 0.4081497797356828 | 2.596060442525634 | 1.524449877750611 | 0.8486954124515996 | 0.7612994350282485 | 0.604505343673224 | 0.2729736135024856 | 0.1223063415543655
 |  | female | 5.66 ±2.15 | 7.41 ±1.93 | 4.8 ±1.21 | 2.74 ±0.68 | 1.06 ±0.25 | 100.81 ±29.82 | 0.4159858050672608 | 38.84 ±9.54 | 0.4287922278648709 | 2.595520082389289 | 1.519767441860465 | 0.8515194460699818 | 0.7638326585695007 | 0.587823126372567 | 0.2986066837766116 | 0.1145400264877053
 | E | male | 5.62 ±1.2 | 6.76 ±1.74 | 4.27 ±0.89 | 0.72 ±0.21 | 1.01 ±0.21 | 95.77 ±20.31 | 0.3754950009801999 | 27.61 ±5.52 | 0.3863159367566811 | 3.468670771459616 | 2.063333333333333 | 0.9267998754894603 | 0.8313609467455622 | 0.735607452575198 | 0.1103809868750108 | 0.1535272964768814
 |  | female | 4.68 ±1.01 | 6.35 ±1.28 | 4.09 ±0.98 | 2.34 ±0.55 | 0.88 ±0.22 | 84.99 ±17.07 | 0.3797417452303293 | 33.05 ±7.88 | 0.446079092995006 | 2.571558245083208 | 1.508891928864569 | 0.821615218451676 | 0.7370078740157481 | 0.5886220085337239 | 0.2996902240472589 | 0.1117485363322746
 | GT39 | male | 0.47 ±2 | 0.58 ±2.46 | 1.83 ±0.81 | 1.2 ±0.43 | 0.44 ±0.19 | 8.12 ±34.47 | 0.813627254509018 | 15.62 ±6.35 | 0.2422080942781827 | 0.5198463508322663 | 0.302593659942363 | 0.9033711389143187 | 0.810344827586207 | 0.5572559474739679 | 0.3251834237749731 | 0.1182230834117054
 |  | female | 0 ±0 | 0 ±0 | 1.48 ±0.57 | 1.14 ±0.42 | 0.35 ±0.14 | 0 ±0 | NA | 13.29 [NAME] | 0.4126047811238746 | 0 | 0 | NA | NA | 0.529689527494036 | 0.36308478746402 | 0.110528353001538
 | GT62 | male | 0 ±0 | 0 ±0 | 0.79 [NAME] | 0.67 ±0.29 | 0.2 ±0.08 | 0 ±0 | NA | 7.42 [NAME] | 0.2148856067187953 | 0 | 0 | NA | NA | 0.5064164892285854 | 0.3822073902936437 | 0.1131245137766992
 |  | female | 0 ±0 | 0 ±0 | 0.4 ±0.26 | 0.35 ±0.22 | 0.1 ±0.06 | 0 ±0 | NA | 3.84 ±2.4 | 0.1437125748502994 | 0 | 0 | NA | NA | 0.4954654997463216 | 0.3858024691358025 | 0.1092947776332172
 | GT63 | male | 0 ±0 | 0 ±0 | 4.58 ±1.82 | 2.84 ±1.09 | 1.14 ±0.46 | 0 ±0 | NA | 38.58 ±15.09 | 0.4887256143906765 | 0 | 0 | NA | NA | 0.5646611480779231 | 0.3115905656081913 | 0.1240147274668667
 |  | female | 0 ±0 | 0 ±0 | 4.6 ±2.41 | 3.06 ±1.6 | 1.11 ±0.56 | 0 ±0 | 0 | 39.49 ±20.48 | 0.5828782287822879 | 0 | 0 | NA | NA | 0.5540581531728934 | 0.3279914143423893 | 0.1179686148857496
Abdominal glands | [NAME] | male | 8.43 ±2.53 | 10.63 ±3.05 | 9.91 ±2.61 | 0.51 ±0.17 | 1.06 ±0.28 | 147.18 ±42.85 | 0.6047084925428325 | 53.74 ±14.1 | 0.5918502202643172 | 2.738742091551917 | 1.6602787456446 | 0.8840781502787513 | 0.7930385700846659 | 0.877123293335803 | 0.04016989502661256 | 0.0827825572903326
 |  | female | 7.51 ±1.75 | 10.84 ±2.79 | 9.58 ±1.95 | 0.66 ±0.16 | 0.94 ±0.18 | 141.24 ±33.39 | 0.5828175290913593 | 52.32 ±10.32 | 0.5776109516449548 | 2.69954128440367 | 1.641323792486583 | 0.7723372864259616 | 0.6928044280442804 | 0.8709283463430755 | 0.05339546623950293 | 0.07540336952310031
 | E | male | 9.22 ±2.45 | 10.81 ±2.94 | 7.77 ±1.84 | 0.51 ±0.13 | 0.93 ±0.22 | 154.99 ±36.25 | 0.6076847676926093 | 43.01 ±10.08 | 0.6017909612424793 | 3.603580562659847 | 2.174809989142237 | 0.9508271502860256 | 0.8529139685476411 | 0.8592830169048506 | 0.05019135453918063 | 0.09074947916385614
 |  | female | 7.61 ±2.48 | 10.32 ±2.93 | 7.39 ±1.71 | 0.57 ±0.16 | 0.81 ±0.19 | 138.27 ±41.23 | 0.6178008131897592 | 40.95 ±9.48 | 0.5527061681738427 | 3.376556776556777 | 2.044469783352338 | 0.8220558166213137 | 0.7374031007751938 | 0.8583712921612464 | 0.0589181541562494 | 0.08301598934074696
 | GT39 | male | 0 ±0 | 0.11 ±0.46 | 8.99 ±3.24 | 0.48 ±0.14 | 1.02 ±0.39 | 0.84 ±3.37 | 0.08416833667334668 | 49.04 ±17.59 | 0.7604279733291984 | 0.01712887438825449 | 0.01048617731172545 | 0 | 0 | 0.871954618476887 | 0.04143038400787178 | 0.0872931861814407
 |  | female | 0 ±0 | 0 ±0 | 3.41 ±1.89 | 0.24 ±0.16 | 0.32 ±0.18 | 0 ±0 | NA | 18.61 ±10.34 | 0.5777708786091276 | 0 | 0 | NA | NA | 0.8715507039062647 | 0.05458748070247264 | 0.07216626692944508
 | GT62 | male | 0 ±0 | 0 ±0 | 5.17 ±3.71 | 0.32 ±0.21 | 0.56 ±0.38 | 0 ±0 | NA | 28.3 ±20.07 | 0.8195771792644078 | 0 | 0 | NA | NA | 0.8689379393430896 | 0.047862097332062 | 0.08304858297613792
 |  | female | 0 ±0 | 0 ±0 | 4.11 ±2.25 | 0.33 ±0.17 | 0.41 ±0.22 | 0 ±0 | NA | 22.7 ±12.34 | 0.8495508982035929 | 0 | 0 | NA | NA | 0.861193249250699 | 0.06153415845045801 | 0.07580339114790184
 | GT63 | male | 0 ±0 | 0 ±0 | 7.35 ±4.46 | 0.36 ±0.22 | 0.81 ±0.46 | 0 ±0 | NA | 39.85 ±23.97 | 0.5048137826197112 | 0 | 0 | NA | NA | 0.8772909827377781 | 0.03823863296887136 | 0.08530752229620045
 |  | female | 0.06 ±0.17 | 0.27 ±0.64 | 4.94 ±3.59 | 0.33 ±0.27 | 0.55 ±0.41 | 2.5 ±6.11 | 1 | 27.18 ±19.86 | 0.4011808118081181 | 0.09197939661515821 | 0.05670103092783505 | 0.2477329837211843 | 0.2222222222222222 | 0.8644943289172023 | 0.05139166287069157 | 0.08492662632868092
Prothoracic and abdominal glands | [NAME] | male | 13.82 ±3.61 | 17.71 ±4.6 | 14.62 ±3.17 | 2.9 ±0.71 | 2.14 ±0.46 | 243.39 ±62.9 |  | 90.8 ±19.16 |  | 2.680506607929515 | 1.603763987792472 | 0.8699330467318155 | 0.7803500846979108 | 0.7658543372290278 | 0.1351886814441881 | 0.09891418113201826
 |  | female | 13.2 ±3.18 | 18.25 ±4.17 | 14.31 ±2.65 | 3.36 ±0.73 | 1.97 ±0.34 | 242.34 ±54.2 |  | 90.58 ±16.24 |  | 2.675425038639876 | 1.60132382892057 | 0.806319957974704 | 0.7232876712328766 | 0.7514359515693386 | 0.1570128308922745 | 0.09127766988736603
 | E | male | 15.08 ±3.09 | 17.89 ±4.19 | 12.23 ±2.15 | 1.22 ±0.29 | 1.94 ±0.33 | 255.05 ±46.67 |  | 71.47 ±12.41 |  | 3.568630194487198 | 2.142300194931774 | 0.9396959348976839 | 0.8429290106204583 | 0.8139305078244876 | 0.07225438875082082 | 0.1139222576544585
 |  | female | 12.32 ±2.99 | 16.72 ±3.26 | 11.51 ±1.82 | 2.91 ±0.57 | 1.68 ±0.25 | 223.81 ±47.42 |  | 74.09 ±11.15 |  | 3.020785531110811 | 1.803726708074534 | 0.8214304197070849 | 0.736842105263158 | 0.7389250352270151 | 0.1662499705420477 | 0.09516567275845739
 | GT39 | male | 0.53 ±2.12 | 0.77 ±3.07 | 10.78 ±3.81 | 1.68 ±0.55 | 1.46 ±0.54 | 9.98 ±39.93 |  | 64.49 ±22.3 |  | 0.1547526748333075 | 0.09339080459770116 | 0.7673287872402917 | 0.6883116883116883 | 0.7950803789385539 | 0.1102668803087473 | 0.09501476838624114
 |  | female | 0 ±0 | 0 ±0 | 4.94 ±2.09 | 1.4 ±0.5 | 0.67 ±0.24 | 0 ±0 |  | 32.21 ±12.52 |  | 0 | 0 | NA | NA | 0.7294925755966953 | 0.1839778306714041 | 0.08730009434794822
 | GT62 | male | 0 ±0 | 0 ±0 | 5.72 ±3.69 | 0.99 ±0.3 | 0.74 ±0.36 | 0 ±0 |  | 34.53 ±19.79 |  | 0 | 0 | NA | NA | 0.7879235888233423 | 0.1213575496807469 | 0.08994267017739647
 |  | female | 0 ±0 | 0 ±0 | 4.53 ±2.32 | 0.7 ±0.3 | 0.52 ±0.23 | 0 ±0 |  | 26.72 ±12.92 |  | 0 | 0 | NA | NA | 0.8063923522817379 | 0.1108893324462187 | 0.0816765763390749
 | GT63 | male | 0 ±0 | 0 ±0 | 11.99 ±5.35 | 3.23 ±1.18 | 1.97 ±0.73 | 0 ±0 |  | 78.94 ±31.9 |  | 0 | 0 | NA | NA | 0.7224481996807779 | 0.1731942953123597 | 0.1047369057309047
 |  | female | 0.06 ±0.17 | 0.27 ±0.64 | 9.65 ±4.4 | 3.5 ±1.71 | 1.67 ±0.72 | 2.5 ±6.11 |  | 67.75 ±29.63 |  | 0.03690036900369004 | 0.0222672064777328 | 0.2477329837211843 | 0.2222222222222222 | 0.6774896516088449 | 0.2186688533552002 | 0.1034517416983462