home / zeropm-v0-0-4

consensus_index

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

7 rows where inventory_id = 221336

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
563163 563163 221336 221336 36256 2 0.318635178642688
563164 563164 221336 221336 120368 2 0.183964106162641
563165 563165 221336 221336 187200 1 0.0637270357285377
563166 563166 221336 221336 198881 1 0.0796587946606721
563167 563167 221336 221336 314191 1 0.0531058631071147
563168 563168 221336 221336 314778 1 0.159317589321344
563169 563169 221336 221336 334440 1 0.0455193112346697
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 855.387ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website