home / zeropm-v0-0-4

consensus_index

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

10 rows where inventory_id = 456886

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1475647 1475647 456886 456886 5512 1 0.147731269785438
1475648 1475648 456886 456886 9860 8 0.295462539570876
1475649 1475649 456886 456886 20084 1 0.049243756595146
1475650 1475650 456886 456886 21698 1 0.147731269785438
1475651 1475651 456886 456886 75772 1 0.0369328174463595
1475652 1475652 456886 456886 87504 1 0.0422089342244108
1475653 1475653 456886 456886 87505 1 0.0984875131902919
1475654 1475654 456886 456886 138865 1 0.0590925079141752
1475655 1475655 456886 456886 157901 1 0.073865634892719
1475656 1475656 456886 456886 207744 1 0.0328291710634306
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 1903.825ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website