dbcls / humandbs

0 stars 0 forks source link

"Data Set ID": DATA(SET) のid体型の確認 #4

Open tfuji opened 1 month ago

tfuji commented 1 month ago

NBDCヒトデータベースにおけるdatasetの定義を確認する必要がある。またjga-studyとjga-datasetなど同一データベースにおける異なるID体型が混在しているので、方針を確認する。 例)

%ruby bin/split_data_each_dataset_from_humandb_both.json.rb json_from_joomla/humandb_20231223_both.json |jq -r '[."NBDC Research ID", .id]|@tsv' 
hum0429.v1  JGAS000643
hum0427.v1  JGAS000645
hum0416.v1  E-GEAD-635
hum0414.v1  DRA016800
hum0413.v1  JGAS000628
hum0411.v1  JGAS000625
hum0409.v1  JGAS000619
hum0406.v1  JGAS000617
hum0406.v1  E-GEAD-623
hum0403.v1  JGAS000622
hum0401.v1  JGAS000618
hum0390.v1  JGAS000621
hum0389.v1  JGAS000605
hum0386.v1  DRA015813
hum0385.v1  JGAS000597
hum0383.v1  JGAS000602
hum0382.v1  JGAS000587
hum0381.v1  JGAS000588
hum0379.v1  JGAS000578
hum0377.v1  JGAS000579
hum0376.v2  JGAS000585
hum0376.v2  JGAS000585 (Data addition)
hum0372.v1  JGAS000572
hum0372.v1  MTBKS213
hum0372.v1  MTBKS214
hum0371.v1  JGAS000574
hum0369.v1  JGAS000562
hum0368.v1  JGAS000559
hum0367.v1  JGAS000558
hum0366.v1  E-GEAD-551
hum0366.v1  E-GEAD-552
hum0365.v1  JGAS000569
hum0364.v1  hum0364.v1.wgs-ms.v1
hum0360.v1  JGAS000546
hum0359.v1  JGAS000548
hum0358.v2  JGAS000582
hum0358.v2  JGAS000586
hum0358.v2  JGAS000640
hum0357.v4  JGAS000557
hum0357.v4  JGAS000557 (data deleted)
hum0357.v4  JGAS000557 (data added)
hum0357.v4  JGAS000609
hum0357.v4  JGAS000610
hum0356.v1  DRA015288
hum0356.v1  E-GEAD-579
hum0355.v1  JGAS000544
hum0354.v2  hum0354.v1.qRT-PCR.v1
hum0354.v2  hum0354.v2.qRT-PCR.v1
hum0352.v1  JGAS000545
hum0351.v1  JGAS000540
hum0348.v1  JGAS000537
hum0347.v2  hum0347.v1.freq.v1
hum0347.v2  hum0347.v2.gwas.v1
hum0345.v1  JGAS000528
hum0345.v1  JGAS000551
hum0344.v2  JGAS000535
hum0344.v2  JGAS000611
hum0343.v2  hum0343.v1.covid19.v1
hum0343.v2  hum0343.v1.count.v1
hum0343.v2  hum0343.v2.qtl.v1
hum0342.v1  JGAS000538
hum0340.v1  JGAS000520
hum0338.v1  JGAS000575
hum0335.v1  DRA014819
hum0332.v1  JGAS000510
hum0331.v1  hum0331.v1.freq.v1
hum0328.v1  JGAS000509
hum0327.v1  JGAS000507
hum0324.v1  JGAS000515
hum0323.v1  JGAS000489
hum0321.v1  JGAS000482
hum0320.v1  JGAS000480
hum0319.v1  JGAS000487
hum0318.v1  JGAS000487
hum0317.v1  JGAS000413
hum0316.v1  JGAS000535
hum0315.v2  JGAS000385
hum0315.v2  JGAS000385 (Data addition)
hum0314.v1  JGAS000383
hum0311.v5  JGAS000412
hum0311.v5  JGAS000541
hum0311.v5  JGAS000561
hum0311.v5  JGAS000561 (Data addition)
hum0311.v5  hum0311.v5.gwas.v1
hum0309.v1  JGAS000418
hum0308.v1  JGAS000417
hum0307.v1  JGAS000416
hum0306.v1  JGAS000361
hum0305.v1  JGAS000377
hum0304.v1  JGAS000370
hum0302.v1  JGAS000382
hum0301.v1  JGAS000368
hum0300.v1  JGAS000367
hum0299.v1  DRA012759
hum0297.v1  JGAS000348
hum0293.v1  JGAS000320
hum0292.v1  JGAS000330
hum0291.v2  JGAS000359
hum0291.v2  JGAS000359 (data addition)
hum0290.v1  JGAS000321
hum0289.v1  JGAS000317
hum0287.v2  JGAS000310
hum0287.v2  JGAS000573
hum0286.v2  JGAS000311
hum0286.v2  JGAS000523
hum0284.v1  JGAS000309
hum0280.v1  DRA012560
hum0279.v1  JGAS000307
hum0278.v1  JGAS000304
hum0278.v1  JGAS000305
hum0277.v3  JGAS000303
hum0277.v3  JGAS000564
hum0277.v3  JGAS000564 (Data addition)
hum0276.v1  JGAS000308
hum0275.v1  JGAS000313
hum0274.v1  JGAS000294
hum0273.v1  JGAS000300
hum0272.v2  JGAS000285
hum0272.v2  JGAS000285 (Data addition)
hum0271.v1  JGAS000288
hum0270.v1  JGAS000282
hum0269.v1  JGAS000295
hum0268.v1  JGAS000280
hum0266.v1  JGAS000281
hum0264.v2  hum0264.v1.gwas.v1
hum0264.v2  JGAS000508
hum0263.v1  JGAS000292
hum0262.v1  JGAS000267
hum0261.v2  hum0261.v1.rhm.v1
hum0261.v2  hum0261.v1.gwas.v1
hum0261.v2  hum0261.v2.gwas.v1
hum0257.v2  JGAS000263
hum0257.v2  E-GEAD-414
hum0257.v2  JGAS000264
hum0257.v2  E-GEAD-416
hum0257.v2  E-GEAD-417
hum0257.v2  JGAS000262
hum0257.v2  E-GEAD-415
hum0257.v2  JGAS000514
hum0257.v2  GSE202023
hum0254.v1  JGAS000257
hum0252.v2  JGAS000301
hum0252.v2  JGAS000553
hum0251.v1  JGAS000278
hum0250.v1  JGAS000277
hum0249.v1  JGAS000248
hum0247.v1  JGAS000249
hum0247.v1  DRA010773
hum0245.v1  JGAS000276
hum0243.v1  JGAS000253
hum0242.v1  JGAS000243
hum0240.v1  JGAS000258
hum0239.v1  JGAS000241
hum0238.v1  JGAS000240
hum0237.v1  hum0237.v1.gwas.v1
hum0236.v1  JGAS000245
hum0233.v1  JGAS000236
hum0232.v1  JGAS000231
hum0229.v1  JGAS000230
hum0227.v1  JGAS000228
hum0226.v1  JGAS000229
hum0225.v1  JGAS000226
hum0223.v1  JGAS000232
hum0222.v1  JGAS000224
hum0221.v1  JGAS000225
hum0220.v1  JGAS000223
hum0218.v1  E-GEAD-344
hum0217.v1  JGAS000217
hum0216.v4  JGAS000216
hum0216.v4  JGAS000244
hum0216.v4  JGAS000216 (Data addition)
hum0216.v4  JGAS000279
hum0215.v1  JGAS000532
hum0214.v8  JGAS000220
hum0214.v8  E-GEAD-397
hum0214.v8  E-GEAD-398
hum0214.v8  E-GEAD-420
hum0214.v8  JGAS000296
hum0214.v8  JGAS000486
hum0214.v8  JGAS000598
hum0214.v8  JGAS000485
hum0213.v1  JGAS000238
hum0210.v1  JGAS000211
hum0209.v1  hum0209.v1.var.v1
hum0208.v1  JGAS000214
hum0207.v1  hum0207.v1.RNA.v1
hum0207.v1  hum0207.v1.ChIP.v1
hum0207.v1  hum0207.v1.HiC.v1
hum0207.v1  hum0207.v1.eQTL.v1
hum0206.v1  JGAS000207
hum0203.v1  JGAS000206
hum0202.v1  JGAS000379
hum0201.v7  JGAS000199
hum0201.v7  JGAS000237
hum0201.v7  JGAS000256
hum0201.v7  JGAS000378
hum0201.v7  JGAS000350
hum0201.v7  JGAS000550
hum0201.v7  JGAD000687
hum0200.v5  JGAS000202
hum0200.v5  JGAS000265
hum0200.v5  JGAS000202 (Data addition)
hum0200.v5  JGAS000290
hum0200.v5  JGAS000387
hum0199.v1  JGAS000198
hum0197.v18 JGAS000205
hum0197.v18 hum0197.v2.gwas.v1
hum0197.v18 JGAS000260
hum0197.v18 hum0197.v3.gwas.v1
hum0197.v18 JGAS000316
hum0197.v18 JGAS000415
hum0197.v18 hum0197.v5.gwas.v1
hum0197.v18 hum0197.v5.finemap.v1
hum0197.v18 JGAS000504
hum0197.v18 hum0197.v6.eqtl.v1
hum0197.v18 JGAS000530
hum0197.v18 JGAS000531
hum0197.v18 hum0197.v9.gwas.GCT.v1
hum0197.v18 hum0197.v10.gwas.v1
hum0197.v18 JGAS000543
hum0197.v18 hum0197.v12
hum0197.v18 JGAS000543 (data addition)
hum0197.v18 JGAS000593
hum0197.v18 hum0197.v3.gwas.v1 (data addition)
hum0197.v18 JGAS000600
hum0197.v18 hum0197.v16.gwas.v1
hum0197.v18 hum0197.v17.hic-gwas.v1
hum0197.v18 hum0197.v18.gwas.v1
hum0196.v1  hum0196.v1.gwas.v1
hum0195.v3  JGAS000190
hum0195.v3  JGAS000234
hum0195.v3  JGAS000269
hum0195.v3  JGAS000269 (Dataset addition)
hum0194.v1  JGAS000189
hum0192.v1  JGAS000196
hum0191.v1  DRA008575
hum0188.v1  JGAS000179
hum0187.v2  JGAS000194
hum0187.v2  JGAS000233
hum0184.v2  JGAS000239
hum0184.v2  JGAS000239 (Dataset addition)
hum0182.v5  JGAS000180
hum0182.v5  DRA008482
hum0182.v5  JGAS000516
hum0181.v1  hum0181.v1.apcc.v1
hum0180.v1  JGAS000170
hum0179.v1  JGAS000186
hum0179.v1  DRA009794
hum0177.v1  JGAS000197
hum0176.v1  JGAS000172
hum0175.v1  JGAS000174
hum0174.v5  JGAS000173
hum0174.v5  JGAS000173 (Data addition)
hum0174.v5  JGAS000580
hum0174.v5  JGAS000286
hum0174.v5  JGAS000505
hum0173.v1  JGAS000171
hum0169.v2  JGAS000178
hum0169.v2  JGAS000178 (Data addition)
hum0168.v1  JGAS000169
hum0167.v1  hum0167.v1.meta.v1
hum0166.v1  hum0166.v1.gwas.v1
hum0165.v1  JGAS000162
hum0164.v1  JGAS000160
hum0163.v3  hum0163.v1.freq.v1
hum0163.v3  hum0163.v2.nat2.v1
hum0163.v3  hum0163.v3.BPgwas.v1
hum0161.v2  JGAS000156
hum0161.v2  JGAS000688
hum0160.v2  JGAS000155
hum0160.v2  JGAS000155 (Data addition)
hum0159.v2  JGAS000157
hum0159.v2  JGAD000689
hum0158.v3  JGAS000151
hum0158.v3  JGAS000151 (Data addition)
hum0157.v1  JGAS000164
hum0156.v1  JGAS000227
hum0153.v1  JGAS000177
hum0152.v2  JGAS000182
hum0152.v2  JGAS000529
hum0148.v1  JGAS000149
hum0147.v3  JGAS000145
hum0147.v3  JGAS000312
hum0147.v3  JGAS000454
hum0146.v1  DRA007187
hum0145.v1  JGAS000222
hum0144.v1  JGAS000147
hum0141.v1  JGAS000135
hum0140.v1  JGAS000158
hum0139.v1  JGAS000136
hum0138.v2  JGAS000134
hum0138.v2  JGAS000134 (Data addition)
hum0137.v1  JGAS000144
hum0136.v3  hum0136.v1.gwas.v1
hum0136.v3  hum0136.v2.hep-gwas.v1
hum0136.v3  JGAS000341
hum0134.v1  JGAS000087
hum0133.v1  JGAS000086
hum0132.v1  JGAS000137
hum0131.v1  JGAS000132
hum0130.v2  JGAS000150
hum0130.v2  JGAS000289
hum0129.v1  JGAS000131
hum0128.v1  JGAS000153
hum0127.v2  JGAS000130
hum0127.v2  JGAS000274
hum0126.v2  hum0126.v1.gwas.v1
hum0126.v2  hum0126.v2.imp-gwas.v1
hum0125.v1  JGAS000127
hum0124.v1  JGAS000129
hum0122.v1  DRA006622
hum0122.v1  DRA007336
hum0122.v1  DRA008459
hum0122.v1  E-GEAD-311
hum0120.v4  JGAS000221
hum0120.v4  DRA011183
hum0120.v4  DRA011184
hum0120.v4  DRA011185
hum0120.v4  E-GEAD-396
hum0120.v4  DRA010902
hum0120.v4  JGAS000549
hum0119.v1  JGAS000126
hum0118.v1  JGAS000124
hum0117.v1  JGAS000125
hum0116.v1  JGAS000122
hum0115.v1  JGAS000121
hum0115.v1  DRA006296
hum0114.v3  hum0114.v1.gwas.v1
hum0114.v3  DRA007411
hum0114.v3  JGAS000314
hum0113.v3  JGAS000119
hum0113.v3  JGAS000142
hum0113.v3  JGAS000318
hum0112.v1  JGAS000112
hum0112.v1  (JGA000122)
hum0111.v3  JGAS000103
hum0111.v3  JGAS000141
hum0111.v3  JGAS000242
hum0108.v1  JGAS000111
hum0107.v2  JGAS000099
hum0107.v2  JGAS000218
hum0106.v1  JGAS000139
hum0103.v4  JGAS000109
hum0103.v4  JGAS000109 (Data addition)
hum0103.v4  JGAS000389
hum0101.v1  JGAS000098
hum0099.v1  JGAS000085
hum0099.v1  hum0099.v1.eqtl.v1
hum0097.v1  JGAS000094
hum0096.v2  JGAS000090
hum0096.v2  JGAS000138
hum0095.v1  JGAS000092
hum0094.v11 JGAS000095
hum0094.v11 JGAS000105
hum0094.v11 JGAS000113
hum0094.v11 JGAS000128
hum0094.v11 JGAS000215
hum0094.v11 JGAS000270
hum0094.v11 JGAS000297
hum0094.v11 JGAS000360
hum0094.v11 JGAS000095 (Data addition)
hum0094.v11 JGAS000335
hum0094.v11 JGAS000534
hum0091.v1  JGAS000082
hum0091.v1  JGAS000165
hum0091.v1  JGAS000081
hum0090.v1  JGAS000078
hum0090.v1  JGAS000079
hum0090.v1  JGAS000080
hum0088.v2  JGAS000077
hum0088.v2  JGAS000096
hum0088.v2  JGAS000077 (Data addition)
hum0086.v3  JGAS000073(JGA000074)
hum0086.v3  JGAS000107(JGA000117)
hum0085.v2  JGAS000108
hum0085.v2  JGAS000108
hum0085.v2  (Data addition)
hum0083.v2  JGAS000070
hum0083.v2  JGAS000488
hum0082.v2  hum0082.v1.AFFY6.0.v1
hum0082.v2  JGAS000120
hum0082.v2  hum0082.v1.Axiom.v1
hum0079.v1  JGAS000068
hum0076.v1  hum0076.v1
hum0075.v3  hum0075.v1.gwas.v1
hum0075.v3  hum0075.v1.virus.v1
hum0075.v3  hum0075.v1.clear.v1
hum0075.v3  hum0075.v2.hcc.v1
hum0075.v3  hum0075.v3.Thai-gwas.v1
hum0074.v2  hum0074.v1.vr.v1
hum0074.v2  hum0074.v1.plt.v1
hum0074.v2  hum0074.v1.Hb.v1
hum0074.v2  hum0074.v2.hcc.v1
hum0072.v1  hum0072.v1.nrc.v1
hum0072.v1  hum0072.v1.ehs.v1
hum0070.v1  JGAS000115
hum0069.v1  JGAS000064
hum0068.v8  JGAS000065
hum0068.v8  JGAS000349
hum0068.v8  JGAS000349 (Data addition)
hum0068.v8  JGAD000670
hum0068.v8  JGAS000570
hum0068.v8  JGAS000570 (Data addition)
hum0067.v1  JGAS000076
hum0066.v1  JGAS000060
hum0065.v1  JGAS000089
hum0064.v1  JGAS000061
hum0061.v1  JGAS000057
hum0060.v1  JGAS000075
hum0059.v1  JGAS000104
hum0058.v1  JGAS000091
hum0056.v1  hum0056.v1.freq.v1
hum0056.v1  hum0056.v1.ch3.v1
hum0056.v1  hum0056.v1.fpkm.v1
hum0055.v1  JGAS000059
hum0053.v2  JGAS000062
hum0053.v2  JGAS000176
hum0050.v1  JGAS000053
hum0048.v1  DRA004251
hum0045.v1  JGAS000047
hum0044.v1  DRA004162
hum0042.v1  hum0042.v1.TMJ.v1
hum0042.v1  hum0042.v1.3MA.v1
hum0041.v1  JGAS000052
hum0040.v1  JGAS000038
hum0039.v1  JGAS000039
hum0038.v1  JGAS000041
hum0037.v1  JGAS000035
hum0036.v1  DRA003736
hum0035.v5  JGAS000036
hum0035.v5  JGAS000046
hum0035.v5  JGAS000088
hum0035.v5  JGAS000188
hum0035.v5  JGAS000204
hum0035.v5  JGAS000246
hum0034.v1  JGAS000037
hum0033.v1  DRA003516
hum0032.v1  JGAS000026
hum0032.v1  JGAS000027
hum0032.v1  JGAS000028
hum0030.v1  JGAS000022
hum0029.v2  hum0029.v1.freq.v1
hum0029.v2  hum0029.v2.var.v1
hum0028.v2  JGAS000018
hum0027.v1  JGAS000024
hum0027.v1  JGAS000040
hum0024.v1  JGAS000023
hum0023.v1  JGAS000016
hum0022.v1  JGAS000017
hum0021.v3  JGAS000014
hum0021.v3  JGAS000273
hum0021.v3  JGAS000273 (Data addition)
hum0020.v1  JGAS000013
hum0019.v1  JGAS000011
hum0018.v1  JGAS000009
hum0017.v1  JGAS000021
hum0016.v1  DRA002604
hum0015.v3  hum0015.v1.freq.v1
hum0015.v3  JGAS000159
hum0015.v3  hum0015.v3.3.5kjpnv2.v1
hum0014.v31 hum0014.v1.freq.v1
hum0014.v31 hum0014.v2.jsnp.934ctrl.v1
hum0014.v31 35 Dieases
hum0014.v31 hum0014.v2.jsnp.182ec.v1
hum0014.v31 hum0014.v2.jsnp.92als.v1
hum0014.v31 hum0014.v3.T2DM-1.v1
hum0014.v31 hum0014.v3.T2DM-2.v1
hum0014.v31 hum0014.v4.AD.v1
hum0014.v31 hum0014.v5.AF.v1
hum0014.v31 JGAS000101
hum0014.v31 hum0014.v6.158k.v1
hum0014.v31 JGAS000114
hum0014.v31 hum0014.v7.POAG.v1
hum0014.v31 hum0014.v8.58qt.v1
hum0014.v31 hum0014.v9.Men.v1
hum0014.v31 hum0014.v9.MP.v1
hum0014.v31 JGAS000140
hum0014.v31 hum0014.v12.T2DMwN.v1
hum0014.v31 hum0014.v13.T2DMmeta.v1
hum0014.v31 hum0014.v14.smok.v1
hum0014.v31 hum0014.v15.ht.v1
hum0014.v31 JGAS000203
hum0014.v31 hum0014.v17
hum0014.v31 hum0014.v18
hum0014.v31 hum0014.v19
hum0014.v31 hum0014.v20.cad.v1
hum0014.v31 hum0014.v21
hum0014.v31 JGAS000293
hum0014.v31 JGAS000114 (Data addition)
hum0014.v31 JGAS000327
hum0014.v31 JGAS000346
hum0014.v31 JGAS000381
hum0014.v31 JGAS000414
hum0014.v31 hum0014.v27.surv.v1
hum0014.v31 hum0014.v28.MEs.v1
hum0014.v31 hum0014.v29.AF.v1
hum0014.v31 JGAS000347
hum0014.v31 JGAS000592
hum0014.v31 JGAD000690
hum0014.v31 JGAD000758
hum0014.v31 JGAD000679
hum0013.v1  hum0013.v1.freq.v1
hum0012.v1  JGAS000012
hum0011.v1  JGAS000015
hum0010.v1  JGAS000008
hum0009.v3  DRA003802
hum0009.v3  JGAS000006
hum0009.v3  hum0009v1.CpG.v1
hum0008.v1  JGAS000007
hum0007.v1  JGAS000005
hum0006.v5  JGAS000004
hum0006.v5  JGAS000004 data addition
hum0006.v5  JGAS000106
hum0006.v5  JGAS000146
hum0006.v5  JGAS000325
hum0005.v8  DRA001273
hum0005.v8  JGAS000032
hum0005.v8  DRA003791
hum0005.v8  JGAS000093
hum0005.v8  JGAS000123
hum0005.v8  JGAS000166
hum0005.v8  JGAS000191
hum0005.v8  JGAS000192
hum0005.v8  JGAS000200
hum0005.v8  JGAS000201
hum0005.v8  JGAS000323
hum0005.v8  JGAS000490
hum0004.v1  JGAS000001
hum0001.v1  JGAS000002
tfuji commented 1 month ago

jga_study-humIDの親子関係を確認


%ruby bin/count_relationships_file_input.rb dblink/jga_study-humID/jga_study2humID.tsv 
{"id":"hum0006","frequency":4,"related_ids":["JGAS000004","JGAS000106","JGAS000146","JGAS000325"]}
{"id":"hum0027","frequency":2,"related_ids":["JGAS000024","JGAS000040"]}
{"id":"hum0032","frequency":3,"related_ids":["JGAS000026","JGAS000027","JGAS000028"]}
{"id":"hum0035","frequency":6,"related_ids":["JGAS000036","JGAS000046","JGAS000088","JGAS000188","JGAS000204","JGAS000246"]}
{"id":"hum0005","frequency":10,"related_ids":["JGAS000032","JGAS000093","JGAS000123","JGAS000166","JGAS000191","JGAS000192","JGAS000200","JGAS000201","JGAS000323","JGAS000490"]}
{"id":"hum0031","frequency":4,"related_ids":["JGAS000042","JGAS000043","JGAS000044","JGAS000045"]}
{"id":"hum0053","frequency":2,"related_ids":["JGAS000062","JGAS000176"]}
{"id":"hum0068","frequency":2,"related_ids":["JGAS000065","JGAS000349"]}
{"id":"hum0083","frequency":2,"related_ids":["JGAS000070","JGAS000488"]}
{"id":"hum0086","frequency":2,"related_ids":["JGAS000073","JGAS000107"]}
{"id":"hum0088","frequency":2,"related_ids":["JGAS000077","JGAS000096"]}
{"id":"hum0090","frequency":3,"related_ids":["JGAS000078","JGAS000079","JGAS000080"]}
{"id":"hum0091","frequency":3,"related_ids":["JGAS000082","JGAS000165","JGAS000081"]}
{"id":"hum0094","frequency":9,"related_ids":["JGAS000095","JGAS000105","JGAS000128","JGAS000113","JGAS000215","JGAS000270","JGAS000297","JGAS000360","JGAS000335"]}
{"id":"hum0096","frequency":2,"related_ids":["JGAS000090","JGAS000138"]}
{"id":"hum0103","frequency":2,"related_ids":["JGAS000109","JGAS000389"]}
{"id":"hum0014","frequency":9,"related_ids":["JGAS000114","JGAS000101","JGAS000140","JGAS000203","JGAS000327","JGAS000293","JGAS000346","JGAS000381","JGAS000414"]}
{"id":"hum0107","frequency":2,"related_ids":["JGAS000099","JGAS000218"]}
{"id":"hum0111","frequency":3,"related_ids":["JGAS000103","JGAS000141","JGAS000242"]}
{"id":"hum0113","frequency":3,"related_ids":["JGAS000119","JGAS000142","JGAS000318"]}
{"id":"hum0120","frequency":2,"related_ids":["JGAS000221","JGAS000549"]}
{"id":"hum0127","frequency":2,"related_ids":["JGAS000130","JGAS000274"]}
{"id":"hum0130","frequency":2,"related_ids":["JGAS000150","JGAS000289"]}
{"id":"hum0147","frequency":2,"related_ids":["JGAS000145","JGAS000312"]}
{"id":"hum0152","frequency":2,"related_ids":["JGAS000182","JGAS000529"]}
{"id":"hum0182","frequency":2,"related_ids":["JGAS000180","JGAS000516"]}
{"id":"hum0187","frequency":2,"related_ids":["JGAS000194","JGAS000233"]}
{"id":"hum0195","frequency":3,"related_ids":["JGAS000190","JGAS000234","JGAS000269"]}
{"id":"hum0197","frequency":8,"related_ids":["JGAS000205","JGAS000260","JGAS000316","JGAS000415","JGAS000504","JGAS000531","JGAS000530","JGAS000543"]}
{"id":"hum0200","frequency":4,"related_ids":["JGAS000202","JGAS000265","JGAS000290","JGAS000387"]}
{"id":"hum0201","frequency":6,"related_ids":["JGAS000199","JGAS000237","JGAS000256","JGAS000550","JGAS000350","JGAS000378"]}
{"id":"hum0214","frequency":3,"related_ids":["JGAS000220","JGAS000296","JGAS000486"]}
{"id":"hum0216","frequency":3,"related_ids":["JGAS000216","JGAS000244","JGAS000279"]}
{"id":"hum0257","frequency":3,"related_ids":["JGAS000263","JGAS000262","JGAS000264"]}
{"id":"hum0278","frequency":2,"related_ids":["JGAS000304","JGAS000305"]}
{"id":"hum0286","frequency":2,"related_ids":["JGAS000311","JGAS000523"]}
{"id":"hum0311","frequency":3,"related_ids":["JGAS000412","JGAS000541","JGAS000561"]}
{"id":"hum0345","frequency":2,"related_ids":["JGAS000528","JGAS000551"]}
tfuji commented 1 month ago

jga_study-jga_datasetの親子関係を確認

%ruby bin/count_relationships_file_input.rb dblink/jga_study-jga_dataset/jga_study2jga_dataset.tsv 
{"id":"JGAS000101","frequency":2,"related_ids":["JGAD000101","JGAD000102"]}
{"id":"JGAS000114","frequency":63,"related_ids":["JGAD000123","JGAD000124","JGAD000144","JGAD000145","JGAD000146","JGAD000147","JGAD000148","JGAD000149","JGAD000150","JGAD000151","JGAD000152","JGAD000153","JGAD000154","JGAD000155","JGAD000156","JGAD000157","JGAD000158","JGAD000159","JGAD000160","JGAD000161","JGAD000162","JGAD000163","JGAD000164","JGAD000165","JGAD000166","JGAD000167","JGAD000168","JGAD000169","JGAD000170","JGAD000171","JGAD000172","JGAD000173","JGAD000174","JGAD000175","JGAD000176","JGAD000177","JGAD000178","JGAD000179","JGAD000180","JGAD000181","JGAD000182","JGAD000183","JGAD000184","JGAD000185","JGAD000186","JGAD000187","JGAD000188","JGAD000189","JGAD000190","JGAD000191","JGAD000192","JGAD000193","JGAD000194","JGAD000195","JGAD000196","JGAD000197","JGAD000198","JGAD000199","JGAD000200","JGAD000201","JGAD000430","JGAD000410","JGAD000220"]}
{"id":"JGAS000120","frequency":2,"related_ids":["JGAD000130","JGAD000131"]}
{"id":"JGAS000149","frequency":3,"related_ids":["JGAD000223","JGAD000224","JGAD000225"]}
{"id":"JGAS000202","frequency":3,"related_ids":["JGAD000287","JGAD000307","JGAD000308"]}
{"id":"JGAS000220","frequency":5,"related_ids":["JGAD000309","JGAD000310","JGAD000371","JGAD000372","JGAD000373"]}
{"id":"JGAS000233","frequency":3,"related_ids":["JGAD000328","JGAD000329","JGAD000330"]}
{"id":"JGAS000239","frequency":2,"related_ids":["JGAD000339","JGAD000625"]}
{"id":"JGAS000293","frequency":2,"related_ids":["JGAD000399","JGAD000400"]}