consensus_index

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

12 rows where inchi_id = 55242

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9285 9285 2814 2814 55242 3 0.454545454545455
64048 64048 20761 20761 55242 6 0.473684210526316
206511 206511 73190 73190 55242 3 0.454545454545455
369057 369057 125556 125556 55242 6 0.473684210526316
529830 529830 210293 210293 55242 6 0.257215420917065
529840 529840 210294 210294 55242 3 0.454545454545455
550500 550500 217611 217611 55242 3 0.454545454545455
715740 715740 253251 253251 55242 9 0.25795884942164
737158 737158 259953 259953 55242 6 0.473684210526316
818295 818295 284097 284097 55242 3 0.454545454545455
937166 937166 334707 334707 55242 3 0.454545454545455
1757186 1757186 538692 538692 55242 5 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)
);