consensus_index

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

14 rows where inchi_id = 4922

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
81514 81514 29369 29369 4922 8 0.625
81516 81516 29370 29370 4922 1 0.167974169148148
147197 147197 52975 52975 4922 1 0.144574588836802
217823 217823 75551 75551 4922 1 0.149140791979019
224144 224144 77344 77344 4922 8 0.413793103448276
233562 233562 79825 79825 4922 2 0.197559771444103
427521 427521 154141 154141 4922 1 0.149140791979019
432207 432207 155462 155462 4922 7 0.620689655172414
515059 515059 206548 206548 4922 1 0.149140791979019
667088 667088 238925 238925 4922 1 0.144305822910695
734849 734849 259224 259224 4922 1 0.144305822910695
856171 856171 296172 296172 4922 1 0.149140791979019
879127 879127 305162 305162 4922 1 0.173681297521571
1615594 1615594 487802 487802 4922 1 0.169304444390518 
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)
);