home / zeropm-v0-0-4

consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

37 rows where inchi_id = 145114

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
21057 21057 6210 6210 145114 1 0.3125
45190 45190 13802 13802 145114 1 0.153846153846154
118750 118750 41402 41402 145114 1 0.153846153846154
132462 132462 47097 47097 145114 1 0.153846153846154
149718 149718 53800 53800 145114 1 0.166816619031002
219522 219522 76046 76046 145114 1 0.3125
295828 295828 100117 100117 145114 1 0.153846153846154
428762 428762 154507 154507 145114 1 0.310344827586207
515935 515935 206774 206774 145114 1 0.310344827586207
524846 524846 209123 209123 145114 1 0.153846153846154
531110 531110 210710 210710 145114 1 0.317073170731707
541082 541082 214306 214306 145114 1 0.153846153846154
665032 665032 238254 238254 145114 1 0.153846153846154
668563 668563 239526 239526 145114 1 0.153846153846154
736911 736911 259852 259852 145114 1 0.317073170731707
838383 838383 290845 290845 145114 1 0.153846153846154
860056 860056 297440 297440 145114 1 0.3125
860058 860058 297441 297441 145114 1 0.310344827586207
860060 860060 297442 297442 145114 1 0.3125
1124377 1124377 384335 384335 145114 1 0.153846153846154
1124381 1124381 384336 384336 145114 1 0.153846153846154
1124385 1124385 384337 384337 145114 1 0.153846153846154
1362392 1362392 433403 433403 145114 1 0.153846153846154
1362396 1362396 433404 433404 145114 1 0.153846153846154
1362400 1362400 433405 433405 145114 1 0.153846153846154
1362404 1362404 433406 433406 145114 1 0.153846153846154
1362408 1362408 433407 433407 145114 1 0.153846153846154
1362412 1362412 433408 433408 145114 1 0.153846153846154
1362416 1362416 433409 433409 145114 1 0.153846153846154
1362420 1362420 433410 433410 145114 1 0.153846153846154
1548532 1548532 471434 471434 145114 1 0.153846153846154
1548536 1548536 471435 471435 145114 1 0.153846153846154
1548540 1548540 471436 471436 145114 1 0.153846153846154
1604064 1604064 484646 484646 145114 1 0.153846153846154
1614381 1614381 487412 487412 145114 1 0.3125
1651866 1651866 500319 500319 145114 1 0.153846153846154
1739276 1739276 532750 532750 145114 1 0.153846153846154
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 849.997ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website