consensus_index

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

10 rows where inventory_id = 404172

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1216806 1216806 404172 404172 3960 1 0.087288783654121
1216807 1216807 404172 404172 7005 9 0.309033072883966
1216808 1216808 404172 404172 35001 1 0.0349155134616484
1216809 1216809 404172 404172 76680 1 0.0698310269232968
1216810 1216810 404172 404172 139500 1 0.0387950149573871
1216811 1216811 404172 404172 155111 2 0.174577567308242
1216812 1216812 404172 404172 172317 1 0.0581925224360807
1216813 1216813 404172 404172 216508 1 0.0436443918270605
1216814 1216814 404172 404172 226229 1 0.116385044872161
1216815 1216815 404172 404172 290172 1 0.049879304945212 
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)
);