home / zeropm-v0-0-4

consensus_index

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

16 rows where inchi_id = 118642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
52606 52606 16347 16347 118642 4 0.461538461538462
68430 68430 22866 22866 118642 1 0.191091397461567
98269 98269 34837 34837 118642 1 0.180070216802505
98272 98272 34838 34838 118642 4 0.466666666666667
193229 193229 68731 68731 118642 1 0.186504277457136
193232 193232 68732 68732 118642 3 0.454545454545455
318378 318378 107269 107269 118642 4 0.461538461538462
384912 384912 131998 131998 118642 1 0.191091397461567
469383 469383 169778 169778 118642 4 0.461538461538462
492482 492482 185408 185408 118642 1 0.191091397461567
687154 687154 245063 245063 118642 4 0.466666666666667
722932 722932 255538 255538 118642 1 0.185842209749562
832181 832181 288847 288847 118642 1 0.186504277457136
832185 832185 288848 288848 118642 1 0.186504277457136
1664714 1664714 504653 504653 118642 4 0.466666666666667
1747277 1747277 535164 535164 118642 4 0.466666666666667
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 2411.309ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website