home / zeropm-v0-0-4

consensus_index

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

16 rows where inchi_id = 45297

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1433 1433 320 320 45297 11 0.465116279069767
100146 100146 35411 35411 45297 8 0.461538461538462
128842 128842 45953 45953 45297 8 0.461538461538462
200654 200654 71294 71294 45297 11 0.465116279069767
208139 208139 73662 73662 45297 7 0.888888888888889
511204 511204 205858 205858 45297 8 0.461538461538462
511208 511208 205859 205859 45297 8 0.461538461538462
558439 558439 219832 219832 45297 11 0.465116279069767
662783 662783 237642 237642 45297 7 0.888888888888889
662784 662784 237643 237643 45297 8 0.461538461538462
706781 706781 251129 251129 45297 11 0.377952755905512
803899 803899 280230 280230 45297 7 0.620689655172414
803901 803901 280231 280231 45297 8 0.461538461538462
896000 896000 314701 314701 45297 4 0.833333333333333
1607702 1607702 485696 485696 45297 8 0.461538461538462
1714281 1714281 525329 525329 45297 4 0.833333333333333
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 813.144ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website