consensus_index

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

14 rows where inventory_id = 57147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
158672 158672 57147 57147 1235 2 0.151743199129967
158673 158673 57147 57147 9328 1 0.101162132753311
158674 158674 57147 57147 31902 8 0.303486398259933
158675 158675 57147 57147 48605 1 0.0606972796519867
158676 158676 57147 57147 72769 1 0.0758715995649833
158677 158677 57147 57147 84210 1 0.0275896725690849
158678 158678 57147 57147 171576 1 0.0303486398259933
158679 158679 57147 57147 179388 1 0.0505810663766556
158680 158680 57147 57147 183363 1 0.0379357997824917
158681 158681 57147 57147 183514 1 0.0337207109177704
158682 158682 57147 57147 221686 1 0.0433551997514191
158683 158683 57147 57147 252412 1 0.0252905331883278
158684 158684 57147 57147 253801 1 0.0233451075584564
158685 158685 57147 57147 314908 1 0.0216775998757095 
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)
);