home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 42486

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
122320 122320 42486 42486 9272 3 0.258193115252546
122321 122321 42486 42486 107325 1 0.0542171568074359
122322 122322 42486 42486 121807 6 0.325302940844616
122323 122323 42486 42486 183405 1 0.046471848692088
122324 122324 42486 42486 223131 1 0.0813257352111539
122325 122325 42486 42486 234744 1 0.108434313614872
122326 122326 42486 42486 296395 1 0.0650605881689231
122327 122327 42486 42486 329439 1 0.040662867605577
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 1017.652ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website