consensus_index

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

12 rows where inventory_id = 76974

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
222768 222768 76974 76974 3517 8 0.283305011276429
222769 222769 76974 76974 10997 1 0.0944350037588097
222770 222770 76974 76974 30754 2 0.0817831122616082
222771 222771 76974 76974 110204 1 0.0472175018794048
222772 222772 76974 76974 139939 1 0.0354131264095536
222773 222773 76974 76974 148957 1 0.0566610022552858
222774 222774 76974 76974 159907 1 0.0314783345862699
222775 222775 76974 76974 185466 2 0.141652505638215
222776 222776 76974 76974 238080 1 0.0708262528191073
222777 222777 76974 76974 241138 1 0.0566610022552858
222778 222778 76974 76974 241464 1 0.0404721444680613
222779 222779 76974 76974 247230 1 0.0472175018794048 
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)
);