{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["content","S1","S2","S3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"content","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"flags":["formulas_cached_only"]}
["content","Supplementary table"]
["Two-Sample MR Analysis and BWMR Analysis","S1"]
["Genetic Correlation and Overlap","S2"]
["Mediation Analysis: GM-Blood Metabolites-IS","S3"]

{"sheet":"S1","index":1,"n_rows":26,"n_cols":17,"rows_kept":26,"merged":[[0,0,0,10]],"flags":["formulas_cached_only"]}
["Two-Sample MR Analysis and BWMR Analysis"]
["exposure","outcome","method","SNP","b","se","pval","FDR","OR","lower","upper"]
["class Betaproteobacteria","Ischemic stroke","Inverse variance weighted",48,-0.066951922,0.028725961,0.019768588,">0.05",0.935240164732533,0.884038375966452,0.989407461834132]
["class Clostridia","Ischemic stroke","Inverse variance weighted",51,-0.056527145,0.025955833,0.029419403,">0.05",0.945040831013609,0.898165815741002,0.994362239834376]
["family Porphyromonadaceae","Ischemic stroke","Inverse variance weighted",50,-0.062838305,0.029074348,0.030672391,">0.05",0.93909530842924,0.887076524429417,0.994164510081092]
["genus Coprobacter","Ischemic stroke","Inverse variance weighted",48,-0.045324939,0.017019732,0.007742858,">0.05",0.955686891431551,0.924332324252558,0.988105046734843]
["genus Lachnospira","Ischemic stroke","Inverse variance weighted",9,-0.136419699,0.060818256,0.024892203,">0.05",0.872476378172368,0.774433503018669,0.982931429879555]
["genus Oscillibacter","Ischemic stroke","Inverse variance weighted",50,0.042924716,0.018584092,0.02090167,">0.05",1.04385930598842,1.00652106584502,1.08258265790374]
["genus Ruminiclostridium","Ischemic stroke","Inverse variance weighted",53,0.0863435461044546,0.025856341285639,0.00083972667639743,"<0.05",1.09018079122893,1.03630874685656,1.14685334961188]
["genus Slackia","Ischemic stroke","Inverse variance weighted",32,-0.042503478,0.020129612,0.034730202,">0.05",0.958387132244704,0.921311097445258,0.996955206334963]
["order Burkholderiales","Ischemic stroke","Inverse variance weighted",57,-0.0734771610153786,0.0235001308901268,0.00176798082419921,"<0.05",0.929157366574283,0.88733080526676,0.972955527673482]
[]
["exposure","outcome","method","SNP","b","se","pval","FDR","OR","or_lci95","or_uci95","Q","Q_df","Q_pval","egger_intercept","se","pval"]
["genus Ruminiclostridium","Ischemic stroke","MR Egger",53,0.0746792160248852,0.0735746379642264,0.314890918941349,0.444076936968569,1.07753843837448,0.932834877112055,1.24468875967535,59.2650173583567,51,0.199576286203328]
["genus Ruminiclostridium","Ischemic stroke","Weighted median",53,0.0769925910727843,0.035618898852181,0.0306516654348395,0.105365099932261,1.08003407446911,1.00720538407704,1.15812883891924]
["genus Ruminiclostridium","Ischemic stroke","Inverse variance weighted",53,0.0863435461044546,0.025856341285639,0.00083972667639743,0.0434855739723754,1.0901807913428,1.03630874638463,1.14685335037374,59.2984297443918,52,0.22681164597314,0.000776813551652073,0.00458117801633776,0.866022019139967]
["genus Ruminiclostridium","Ischemic stroke","Simple mode",53,0.234781956924538,0.0948192312477313,0.016575194106755,0.0875610385832128,1.26463299420123,1.05015341569174,1.52291711489499]
["genus Ruminiclostridium","Ischemic stroke","Weighted mode",53,0.227746848958515,0.090735244251958,0.015223342908087,0.0875610385832128,1.25576738636902,1.05117204000391,1.50018424069023]
["genus Ruminiclostridium","Ischemic stroke","IVW-BWMR",53,0.065,0.023,0.005,0.009,1.06715902438419,1.02011972718411,1.11636737627669]
[]
["order Burkholderiales","Ischemic stroke","MR Egger",57,-0.126955461000485,0.0522562080712673,0.0184138330119814,0.0875610385832128,0.880772900467352,0.795028251230529,0.975765202050324,66.3469472493602,55,0.140533687658115]
["order Burkholderiales","Ischemic stroke","Weighted median",57,-0.0661035097900615,0.033641503312761,0.0494212709199391,0.129436661933174,0.936033970597195,0.87630519177501,0.999833850507306]
["order Burkholderiales","Ischemic stroke","Inverse variance weighted",57,-0.0734771610153786,0.0235001308901268,0.00176798082419921,0.0434855739723754,0.929157366559994,0.887330805444202,0.972955527448992,67.9284036155465,56,0.131831543213349,0.00440176331247345,0.00384438794872255,0.257173843500757]
["order Burkholderiales","Ischemic stroke","Simple mode",57,-0.0803102211876268,0.0747444112396297,0.287222417008569,0.415716656196612,0.922830020551809,0.797072795705046,1.06842844395205]
["order Burkholderiales","Ischemic stroke","Weighted mode",57,-0.123868314861585,0.0666594066473908,0.0683960476904374,0.163555766216263,0.883496176539041,0.775287964232916,1.00680718645157]
["order Burkholderiales","Ischemic stroke","IVW-BWMR",57,-0.061,0.022,0.006,0.009,0.94082323977601,0.901117156874077,0.982278898754026]

{"sheet":"S2","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,0,0,6],[1,0,1,1],[1,2,1,4],[1,5,1,6]],"flags":["formulas_cached_only"]}
["Genetic Correlation and Overlap"]
[null,null,"LDSC",null,null,"GPA"]
["trait1","trait2","rg","rg_se","rg_p","statistics","pvalue"]
["genus Anaerostipes","IS",-0.368860462,0.150600006,0.014314508,5.2,0.02259003]
["genus Bacteroides","IS",0.440023299,0.182691537,0.016015648,0.055,0.829112]
["genus Lachnoclostridium","IS",0.294011941,0.143475163,0.040440765,3.9,0.04828117]
["genus Lachnospiraceae","IS",-0.478508714,0.22668279,0.034779387,0.035,0.8517762]
["genus Subdoligranulum","IS",-0.491351632,0.243398358,0.043516972,0.286,0.5930447]
["order Bacteroidales","IS",0.419973155,0.212977269,0.048619265,0.816,0.3662072]
["order Lactobacillales","IS",0.394254821,0.189372841,0.037351845,0.032,0.858397]
["family Bacteroidaceae","IS",0.440023299,0.182691537,0.016015648,-0.011,1]
["family Prevotellaceae","IS",-0.575468561,0.254169101,0.023566925,2.107,0.1466087]
["family Streptococcaceae","IS",0.312157537,0.15815308,0.048408095,1.147,0.2841677]
["class Bacteroidia","IS",0.419879507,0.212925494,0.048614736,0.817,0.3662043]

{"sheet":"S3","index":3,"n_rows":64,"n_cols":14,"rows_kept":64,"merged":[[0,0,0,13],[4,0,4,13],[5,0,5,13],[8,0,8,13],[9,0,9,13],[13,0,13,13],[17,0,17,13],[21,0,21,13],[22,0,22,13],[23,0,23,13],[28,0,28,13],[32,0,32,13],[36,0,36,13],[44,0,44,13],[48,0,48,13],[52,0,52,13],[56,0,56,13],[60,0,60,13]],"flags":["formulas_cached_only"]}
["Mediation Analysis: GM-Blood Metabolites-IS"]
["exposure","outcome","method","nsnp","β","se","OR","lower","upper","pval","β0","mediated effect","direct effect","proportion mediated"]
["genus Ruminiclostridium","Pyruvate","IVW",35,-0.0323447025835791,0.0138336491373,0.968172792487277,0.942274491087019,0.994782905596079,0.0193811332190802,0.0863435461044546,0.00434666469290642,0.0819968814115482,0.0503415123540098]
["Pyruvate","Ischemic stroke","IVW",54,-0.134385675109381,0.0676132271926129,0.874252822117346,0.765743822987104,0.998137985623707,0.0468598348244087]
["No common SNPs were extracted in the multivariable exposure, or the extracted SNPs were excluded after harmonization, indicating that the causal relationship between the multivariable and the outcome is independent"]
[]
["genus Ruminiclostridium","Arachidonate","IVW",35,0.0223629961111875,0.00830180186726932,1.02261492223191,1.00611005477634,1.03939054600131,0.00706526947393869,0.0863435461044546,0.00622580492188891,0.08011774118256569,0.07210504088350975]
["Arachidonate","Ischemic stroke","IVW",69,0.278397621272864,0.120859261438284,1.32101135465121,1.04238720212879,1.67411015364885,0.0212515118346842]
["No common SNPs were extracted in the multivariable exposure, or the extracted SNPs were excluded after harmonization, indicating that the causal relationship between the multivariable and the outcome is independent"]
[]
["genus Ruminiclostridium","Free cholesterol to total lipids ratio in large VLDL","IVW",52,0.0228648228913969,0.011366088450836,1.02312822679476,1.00058746300884,1.04617677830623,0.0442547003512157,0.0863435461044546,0.00159061499980244,0.08475293110465217,0.01842193275080665]
["Free cholesterol to total lipids ratio in large VLDL","Ischemic stroke","IVW",150,0.0695660319503686,0.031433197436973,1.07204284800099,1.00798870666393,1.14016740500372,0.026888071050874]
["Free cholesterol to total lipids ratio in large VLDL","Ischemic stroke","MVMR-IVW",34,0.0545239,0.05010512,1.05603771541352,0.957258187800843,1.16501030817803,0.2765112]
[]
["genus Ruminiclostridium","Triglycerides in medium LDL","IVW",52,0.0348301378345584,0.0126767719242492,1.03544381130422,1.01003366792824,1.06149321593147,0.00600412969329469,0.0863435461044546,0.0018228038909038607,0.08452074221355074,0.02111106125637593]
["Triglycerides in medium LDL","Ischemic stroke","IVW",187,0.0523340992666207,0.0250627937953266,1.05372773309214,1.00321618361598,1.10678251968125,0.0367870894938265]
["Triglycerides in medium LDL","Ischemic stroke","MVMR-IVW",47,0.06215106,0.04156107,1.06412307901978,0.980876580519001,1.15443466567771,0.1348061]
[]
["genus Ruminiclostridium","Triglycerides to total lipids ratio in small HDL","IVW",52,0.0280359619672951,0.0124313370089471,1.02843266825203,1.00367728616707,1.05379863398835,0.0241166864668052,0.0863435461044546,0.0015376806498829938,0.08480586545457161,0.017808866085054876]
["Triglycerides to total lipids ratio in small HDL","Ischemic stroke","IVW",216,0.0548467233504151,0.0267581880402541,1.05637868371016,1.0024035584464,1.11326013759046,0.0403920170281853]
["Triglycerides to total lipids ratio in small HDL","Ischemic stroke","MVMR-IVW",45,-0.01087546,0.034071,0.989183464013073,0.925283945931806,1.05749584198343,0.7495749]
[]
[]
[]
["id.exposure","id.outcome","method","nsnp","b","se","OR","lower","upper","pval","β0","mediated effect","direct effect","proportion mediated"]
["order Burkholderiales","Apolipoprotein A1","IVW",52,0.0245498400683809,0.011249358518098,1.02485366854118,1.00250422671073,1.04770136019126,0.0290850061981505,-0.0734771610153786,-0.0018399105477760944,-0.07163725046760251,0.025040577539339134]
["Apolipoprotein A1","Ischemic stroke","IVW",200,-0.0749459280651615,0.0293032197609594,0.92779365263063,0.876007839223949,0.982640820456886,0.0105397112784924]
["Apolipoprotein A1","Ischemic stroke","MVMR-IVW",35,-0.0765461,0.03715479,0.926310210403805,0.861250833909393,0.996284209100241,0.03937992]
[]
["order Burkholderiales","Citrate","IVW",52,0.0257473158355361,0.0113941565441563,1.02608164129998,1.00342060524327,1.04925444934193,0.0238402017570278,-0.0734771610153786,-0.0018158627709641939,-0.0716612982444144,0.02471329520453489]
["Citrate","Ischemic stroke","IVW",137,-0.07052629418007,0.0347590557530926,0.93190323573997,0.87052914135786,0.997604329968804,0.0424577919988031]
["Citrate","Ischemic stroke","MVMR-IVW",26,{"$nulls":5},0.7322114]
[]
["order Burkholderiales","Free cholesterol in HDL","IVW",52,0.0232958429580867,0.0113500947756367,1.02356931057421,1.0010502078825,1.04659499123979,0.0401230330867753,-0.0734771610153786,-0.0013894456312289825,-0.07208771538414961,0.01890989815104825]
["Free cholesterol in HDL","Ischemic stroke","IVW",230,-0.0596435009340009,0.0284614210272952,0.94210033155097,0.890984822257307,0.996148320977944,0.0361184783578037]
["Free cholesterol in HDL","Ischemic stroke","MVMR-IVW",{"$nulls":6},0.245829]
[]
["order Burkholderiales","Total lipids in HDL","IVW",52,0.0236124239318894,0.011313107032402,1.0238934044684,1.0014397697547,1.04685048005502,0.0368724002384737,-0.0734771610153786,-0.0015326372648434793,-0.07194452375053512,0.020858689198983912]
["Total lipids in HDL","Ischemic stroke","IVW",219,-0.0649080869149397,0.0279119929316069,0.937153596017459,0.887261440430997,0.989851268755499,0.0200476369777449]
["Total lipids in HDL","Ischemic stroke","MVMR-IVW",{"$nulls":6},0.08805452]
[]
["order Burkholderiales","Concentration of HDL particles","IVW",52,0.0243085351917594,0.011169659218241,1.02460639606193,1.00241892424794,1.04728496385745,0.029532796513991,-0.0734771610153786,-0.0016932055865882497,-0.07178395542879035,0.023043971258414103]
["Concentration of HDL particles","Ischemic stroke","IVW",185,-0.0696547765314237,0.0293343537183102,0.932715759264876,0.880601474848153,0.987914184144497,0.0175721623955201]
["Concentration of HDL particles","Ischemic stroke","MVMR-IVW",{"$nulls":6},0.08974896]
[]
["order Burkholderiales","Phospholipids in HDL","IVW",52,0.0230541108635061,0.0111744388695678,1.02332191102103,1.0011528746096,1.04598184766145,0.0391020568442796,-0.0734771610153786,-0.0017014309414995622,-0.07177573007387904,0.02315591563402207]
["Phospholipids in HDL","Ischemic stroke","IVW",194,-0.0738016292006677,0.0277787112554031,0.928855933647179,0.879635288273289,0.980830756761913,0.00788933947952059]
["Phospholipids in HDL","Ischemic stroke","MVMR-IVW",{"$nulls":6},0.08945725]
[]
["order Burkholderiales","Total lipids in medium HDL","IVW",52,0.0225438703632248,0.0111174788464274,1.02279990341199,1.00075389519624,1.045331571969,0.0425820717548309,-0.0734771610153786,-0.001457863173283421,-0.07201929784209518,0.01984103840073916]
["Total lipids in medium HDL","Ischemic stroke","IVW",188,-0.0646678298710231,0.0275706715771335,0.937378780779002,0.888068546362005,0.989426978642874,0.0190000632220959]
["Total lipids in medium HDL","Ischemic stroke","MVMR-IVW",{"$nulls":6},0.02459768]
[]
["order Burkholderiales","Concentration of medium HDL particles","IVW",52,0.0237422722799631,0.0112513920559002,1.02402636361124,1.00169097176308,1.04685978303783,0.0348443101601367,-0.0734771610153786,-0.001474383243398088,-0.07200277777198051,0.020065871122722106]
["Concentration of medium HDL particles","Ischemic stroke","IVW",200,-0.0620995002505455,0.0280010314871513,0.939789373096237,0.889601632173586,0.99280850421403,0.0265713648658901]
["Concentration of medium HDL particles","Ischemic stroke","MVMR-IVW",{"$nulls":6},0.01313554]
[]
["order Burkholderiales","Phospholipids in medium HDL","IVW",52,0.0216649808500647,0.0109720970650222,1.02190137074076,1.00015968362807,1.04411568334141,0.0483189627110151,-0.0734771610153786,-0.0011382385027687834,-0.07233892251260982,0.015491051736886686]
["Phospholipids in medium HDL","Ischemic stroke","IVW",183,-0.05253817257657,0.0245442793085748,0.94881810113112,0.9042540223932,0.995578417944379,0.0323106224767899]
["Phospholipids in medium HDL","Ischemic stroke","MVMR-IVW",46,-0.07593088,0.03370525,0.926880270309597,0.867627182359333,0.990179944746577,0.02427235]
[]
["order Burkholderiales","Total concentration of lipoprotein particles","IVW",52,0.0247591172051442,0.0110507085583736,1.02506816928662,1.00310453648256,1.04751271025968,0.0250584533147312,-0.0734771610153786,-0.002198959908898606,-0.07127820110647999,0.029927121278384296]
["Total concentration of lipoprotein particles","Ischemic stroke","IVW",188,-0.0888141483672014,0.0283860166252,0.915015615254796,0.865497544619686,0.967366783839942,0.00175522163622774]
["Total concentration of lipoprotein particles","Ischemic stroke","MVMR-IVW",45,-0.1039518,0.04783161,0.901268737527439,0.820614560341921,0.989850017901038,0.0297588]