consensus_index

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

10 rows where inventory_id = 248984

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
698486 698486 248984 248984 32971 11 0.300235077843443
698487 698487 248984 248984 41260 2 0.0715011121334531
698488 698488 248984 248984 53040 2 0.0923075388427243
698489 698489 248984 248984 93554 6 0.0998291029950728
698490 698490 248984 248984 136666 2 0.0753687898589376
698491 698491 248984 248984 189082 3 0.159881347197236
698492 698492 248984 248984 195495 1 0.039970336799309
698493 698493 248984 248984 195830 1 0.0639525388788944
698494 698494 248984 248984 218390 1 0.045680384913496
698495 698495 248984 248984 237248 2 0.0412811863376067 
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)
);