home / zeropm-v0-0-4

consensus_index

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

12 rows where inchi_id = 313750

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22868 22868 6714 6714 313750 1 0.137931034482759
79552 79552 28706 28706 313750 1 0.137931034482759
130322 130322 46382 46382 313750 3 0.127064803049555
144122 144122 51392 51392 313750 1 0.133333333333333
222068 222068 76796 76796 313750 1 0.137931034482759
430663 430663 155052 155052 313750 1 0.137931034482759
592646 592646 231048 231048 313750 1 0.137931034482759
673263 673263 240792 240792 313750 2 0.13953488372093
745981 745981 262431 262431 313750 1 0.137931034482759
745987 745987 262433 262433 313750 1 0.137931034482759
1617364 1617364 488364 488364 313750 1 0.137931034482759
1720278 1720278 526865 526865 313750 1 0.137931034482759
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 1268.196ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website