home / zeropm-v0-0-4

consensus_index

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

13 rows where inventory_id = 101346

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
299707 299707 101346 101346 118741 4 0.103594184768125
299708 299708 101346 101346 215683 3 0.228838903318207
299709 299709 101346 101346 215795 2 0.0372218165626507
299710 299710 101346 101346 215853 2 0.0770564809981323
299711 299711 101346 101346 234957 1 0.0360398689156834
299712 299712 101346 101346 234958 1 0.032035439036163
299713 299713 101346 101346 237271 1 0.0262108137568607
299714 299714 101346 101346 259479 1 0.0576637902650935
299715 299715 101346 101346 262078 2 0.0385282404990661
299716 299716 101346 101346 285282 2 0.166461024160229
299717 299717 101346 101346 291976 1 0.0240265792771223
299718 299718 101346 101346 295390 2 0.0461679813827659
299719 299719 101346 101346 330498 1 0.0288318951325467
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)
);
Powered by Datasette · Queries took 958.852ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website