consensus_index

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

12 rows where inchi_id = 128445

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9286 9286 2814 2814 128445 1 0.454545454545455
64049 64049 20761 20761 128445 2 0.473684210526316
206512 206512 73190 73190 128445 1 0.454545454545455
369058 369058 125556 125556 128445 2 0.473684210526316
529831 529831 210293 210293 128445 2 0.257215420917065
529841 529841 210294 210294 128445 1 0.454545454545455
550501 550501 217611 217611 128445 1 0.454545454545455
715741 715741 253251 253251 128445 3 0.25795884942164
737159 737159 259953 259953 128445 2 0.473684210526316
818296 818296 284097 284097 128445 1 0.454545454545455
937167 937167 334707 334707 128445 1 0.454545454545455
1757187 1757187 538692 538692 128445 1 0.466666666666667 
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)
);