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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
159905 159905 57501 57501 42803 5 0.283018867924528
159906 159906 57501 57501 42843 1 0.0566037735849057
159907 159907 57501 57501 101846 1 0.283018867924528
159908 159908 57501 57501 141671 1 0.0707547169811321
159909 159909 57501 57501 213227 1 0.0471698113207547
159910 159910 57501 57501 225160 1 0.141509433962264
159911 159911 57501 57501 238925 1 0.0943396226415094
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 2426.42ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website