consensus_index

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

8 rows where inventory_id = 100406

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
296841 296841 100406 100406 7167 1 0.0372308661760438
296842 296842 100406 100406 56793 1 0.0521232126464613
296843 296843 100406 100406 74516 2 0.130308031616153
296844 296844 100406 100406 91935 1 0.260616063232306
296845 296845 100406 100406 113780 3 0.180701085718998
296846 296846 100406 100406 138980 3 0.125291135070667
296847 296847 100406 100406 164426 1 0.0434360105387177
296848 296848 100406 100406 170440 4 0.154963238339929 
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)
);