consensus_index

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

13 rows where inventory_id = 59643

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
166689 166689 59643 59643 1639 2 0.0437799694690311
166690 166690 59643 59643 16464 2 0.0228633433889428
166691 166691 59643 59643 43799 2 0.119896384225379
166692 166692 59643 59643 43800 2 0.0799309228169193
166693 166693 59643 59643 45865 2 0.239792768450758
166694 166694 59643 59643 137983 2 0.0244737469464047
166695 166695 59643 59643 138063 1 0.0299740960563447
166696 166696 59643 59643 140401 2 0.239792768450758
166697 166697 59643 59643 170702 2 0.0252763771580587
166698 166698 59643 59643 173839 2 0.0437799694690311
166699 166699 59643 59643 208325 1 0.0266436409389731
166700 166700 59643 59643 219377 2 0.0342561097786797
166701 166701 59643 59643 237645 2 0.0599481921126895 
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)
);