consensus_index

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

10 rows where inventory_id = 299973

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
869671 869671 299973 299973 57118 1 0.206095940178693
869672 869672 299973 299973 58885 1 0.206095940178693
869673 869673 299973 299973 67859 1 0.0515239850446732
869674 869674 299973 299973 93119 1 0.206095940178693
869675 869675 299973 299973 141692 1 0.103047970089346
869676 869676 299973 299973 145584 1 0.0343493233631155
869677 869677 299973 299973 168818 2 0.042069157624747
869678 869678 299973 299973 195863 1 0.0412191880357386
869679 869679 299973 299973 200085 1 0.0294422771683847
869680 869680 299973 299973 339890 1 0.0228995489087437 
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)
);