home / zeropm-v0-0-4

consensus_index

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

23 rows where inchi_id = 142231

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
47784 47784 14704 14704 142231 1 0.173913043478261
115124 115124 40159 40159 142231 1 0.173913043478261
144850 144850 51648 51648 142231 1 0.0259695363931322
191375 191375 68076 68076 142231 1 0.0388869960552683
191384 191384 68077 68077 142231 2 0.0376974077236745
300678 300678 101790 101790 142231 1 0.0849342770475228
462131 462131 166016 166016 142231 1 0.0849342770475228
463484 463484 166524 166524 142231 1 0.0370731477028367
502964 502964 201272 201272 142231 1 0.0375202299949489
526913 526913 209575 209575 142231 1 0.0849342770475228
526918 526918 209576 209576 142231 1 0.0849342770475228
595441 595441 231909 231909 142231 1 0.0849342770475228
597206 597206 235341 235341 142231 1 0.115727002967359
669791 669791 239876 239876 142231 2 0.132746168732419
737453 737453 260029 260029 142231 1 0.0373697239301555
739059 739059 260459 260459 142231 1 0.115727002967359
739062 739062 260460 260460 142231 1 0.173913043478261
1654913 1654913 501426 501426 142231 1 0.173913043478261
1741825 1741825 533541 533541 142231 1 0.0373697239301555
1742319 1742319 533658 533658 142231 1 0.0388869960552683
1742330 1742330 533659 533659 142231 1 0.0259695363931322
1742996 1742996 533843 533843 142231 1 0.0306652592270122
1743274 1743274 533911 533911 142231 1 0.0370731477028367
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 791.542ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website