home / zeropm-v0-0-4

consensus_index

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

12 rows where inventory_id = 1056

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3713 3713 1056 1056 2874 1 0.191149231032198
3714 3714 1056 1056 15625 1 0.031858205172033
3715 3715 1056 1056 19881 2 0.0551800299959147
3716 3716 1056 1056 54769 1 0.095574615516099
3717 3717 1056 1056 56706 1 0.0273070330045997
3718 3718 1056 1056 79616 15 0.177649697208735
3719 3719 1056 1056 84319 3 0.0662677372098143
3720 3720 1056 1056 90475 2 0.0382298462064396
3721 3721 1056 1056 140927 1 0.0238936538790247
3722 3722 1056 1056 148556 1 0.095574615516099
3723 3723 1056 1056 152516 1 0.095574615516099
3724 3724 1056 1056 215832 1 0.095574615516099
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 883.484ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website