consensus_index

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

10 rows where inventory_id = 295030

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
852747 852747 295030 295030 8730 1 0.147859008961714
852748 852748 295030 295030 12669 1 0.0422454311319181
852749 852749 295030 295030 47694 2 0.147859008961714
852750 852750 295030 295030 83483 8 0.295718017923427
852751 852751 295030 295030 121344 1 0.0492863363205712
852752 852752 295030 295030 141771 1 0.0328575575470475
852753 852753 295030 295030 147176 1 0.0739295044808568
852754 852754 295030 295030 164517 1 0.0591436035846854
852755 852755 295030 295030 233899 1 0.0369647522404284
852756 852756 295030 295030 332416 1 0.0985726726411423 
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)
);