home / zeropm-v0-0-4

consensus_index

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

20 rows where inchi_id = 139100

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
49365 49365 15158 15158 139100 4 0.473684210526316
122060 122060 42402 42402 139100 4 0.473684210526316
186024 186024 66355 66355 139100 4 0.340909090909091
268957 268957 91172 91172 139100 1 0.172413793103448
305275 305275 103199 103199 139100 4 0.470588235294118
450191 450191 161480 161480 139100 1 0.172413793103448
464425 464425 166900 166900 139100 4 0.470588235294118
465433 465433 168053 168053 139100 2 0.455695089190719
527369 527369 209674 209674 139100 4 0.340909090909091
588050 588050 229671 229671 139100 4 0.470588235294118
677044 677044 241915 241915 139100 4 0.473684210526316
752546 752546 264486 264486 139100 4 0.340909090909091
752549 752549 264487 264487 139100 4 0.473684210526316
1001325 1001325 358527 358527 139100 2 0.149844697475966
1212464 1212464 402943 402943 139100 2 0.149844697475966
1455497 1455497 451939 451939 139100 2 0.149844697475966
1592325 1592325 480647 480647 139100 2 0.149844697475966
1657843 1657843 502360 502360 139100 4 0.473684210526316
1657854 1657854 502364 502364 139100 2 0.149844697475966
1743878 1743878 534074 534074 139100 2 0.454545454545455
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 837.54ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website