home / zeropm-v0-0-4

consensus_index

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

17 rows where inchi_id = 39572

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3647 3647 1032 1032 39572 15 0.486486486486487
3650 3650 1033 1033 39572 1 0.20979020979021
13170 13170 4034 4034 39572 4 0.432136581898648
42920 42920 13019 13019 39572 4 0.432136581898648
60621 60621 19323 19323 39572 8 0.625
79820 79820 28810 28810 39572 8 0.625
157251 157251 56542 56542 39572 8 0.625
205776 205776 72934 72934 39572 1 0.253012048192771
285997 285997 96887 96887 39572 1 0.206555426694659
288542 288542 97714 97714 39572 4 0.432136581898648
352501 352501 119214 119214 39572 7 0.620689655172414
501916 501916 200205 200205 39572 3 0.690983005625053
529391 529391 210187 210187 39572 8 0.478260869565217
561394 561394 220770 220770 39572 11 0.482758620689655
948094 948094 339910 339910 39572 2 0.424431771143369
1679479 1679479 510133 510133 39572 8 0.625
1754522 1754522 537640 537640 39572 4 0.6
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 955.222ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website