home / zeropm-v0-0-4

consensus_index

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

16 rows where inventory_id = 3445

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11307 11307 3445 3445 10573 1 0.0670770803768177
11308 11308 3445 3445 102086 1 0.0670770803768177
11309 11309 3445 3445 119793 4 0.123714583050682
11310 11310 3445 3445 150125 1 0.100615620565227
11311 11311 3445 3445 150528 1 0.0503078102826133
11312 11312 3445 3445 170726 1 0.0201231241130453
11313 11313 3445 3445 184046 1 0.0167692700942044
11314 11314 3445 3445 192351 2 0.0299977822909563
11315 11315 3445 3445 201303 1 0.0335385401884089
11316 11316 3445 3445 207120 2 0.0537813114161034
11317 11317 3445 3445 216017 1 0.201231241130453
11318 11318 3445 3445 229735 1 0.0154793262408041
11319 11319 3445 3445 231927 1 0.0251539051413066
11320 11320 3445 3445 251239 1 0.100615620565227
11321 11321 3445 3445 261621 1 0.0182937491936776
11322 11322 3445 3445 294663 1 0.0670770803768177
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 1856.22ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website