home / zeropm-v0-0-4

consensus_index

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

6 rows where inventory_id = 102226

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
302013 302013 102226 102226 1747 8 0.237111793615346
302014 302014 102226 102226 47697 2 0.0684482789359274
302015 302015 102226 102226 99743 1 0.335326714329432
302016 302016 102226 102226 225051 5 0.173458425815903
302017 302017 102226 102226 276659 3 0.0838316785823581
302018 302018 102226 102226 281131 2 0.0865809853424229
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 907.872ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website