consensus_index

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

8 rows where inventory_id = 1523

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5056 5056 1523 1523 2658 12 0.314234054537609
5057 5057 1523 1523 17894 2 0.0628468109075217
5058 5058 1523 1523 52688 1 0.0523723424229348
5059 5059 1523 1523 73284 2 0.111098515421643
5060 5060 1523 1523 75401 1 0.10474468484587
5061 5061 1523 1523 141770 1 0.10474468484587
5062 5062 1523 1523 168866 1 0.0785585136344022
5063 5063 1523 1523 210579 1 0.157117027268804 
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)
);