consensus_index

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

10 rows where inventory_id = 33351

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
93775 93775 33351 33351 20977 2 0.247802909345645
93776 93776 33351 33351 92184 5 0.142325397164411
93777 93777 33351 33351 143161 4 0.247802909345645
93778 93778 33351 33351 157657 3 0.0826009697818816
93779 93779 33351 33351 204514 1 0.0354004156208064
93780 93780 33351 33351 207883 1 0.0413004848909408
93781 93781 33351 33351 215002 1 0.0619507273364112
93782 93782 33351 33351 237585 2 0.0413004848909408
93783 93783 33351 33351 247884 1 0.0495605818691289
93784 93784 33351 33351 277625 2 0.0391810802174231 
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)
);