consensus_index

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

8 rows where inchi_id = 23897

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
125383 125383 44791 44791 23897 8 0.387096774193548
139031 139031 49530 49530 23897 1 0.304347826086957
264925 264925 89763 89763 23897 1 0.239130434782609
330952 330952 111544 111544 23897 6 0.382978723404255
474406 474406 172487 172487 23897 6 0.382978723404255
570903 570903 223796 223796 23897 6 0.382978723404255
888198 888198 309751 309751 23897 3 0.375
1669859 1669859 506551 506551 23897 6 0.384615384615385 
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)
);