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 = 1120

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3884 3884 1120 1120 67858 1 0.0552486187845304
3885 3885 1120 1120 87549 8 0.331491712707182
3886 3886 1120 1120 136548 1 0.0828729281767956
3887 3887 1120 1120 143933 1 0.0662983425414365
3888 3888 1120 1120 163294 1 0.165745856353591
3889 3889 1120 1120 174008 1 0.165745856353591
3890 3890 1120 1120 243820 1 0.110497237569061
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 1652.235ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website