home / zeropm-v0-0-4

consensus_index

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

15 rows where inventory_id = 101202

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
299459 299459 101202 101202 83485 2 0.0432176777483156
299460 299460 101202 101202 195804 1 0.0426132049332206
299461 299461 101202 101202 205296 4 0.255679229599324
299462 299462 101202 101202 206154 4 0.127839614799662
299463 299463 101202 101202 241347 1 0.063919807399831
299464 299464 101202 101202 248076 1 0.0365256042284748
299465 299465 101202 101202 256472 2 0.0466804271790307
299466 299466 101202 101202 259398 2 0.0301320861763724
299467 299467 101202 101202 262851 2 0.0852264098664413
299468 299468 101202 101202 274707 2 0.0451981292645585
299469 299469 101202 101202 287254 2 0.0269509571977001
299470 299470 101202 101202 292136 1 0.0255679229599324
299471 299471 101202 101202 292238 1 0.0232435663272113
299472 299472 101202 101202 292303 1 0.0213066024666103
299473 299473 101202 101202 325196 2 0.044508040965209
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 949.393ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website