consensus_index

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

12 rows where inchi_id = 16799

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19611 19611 5756 5756 16799 1 0.00564222257954052
101215 101215 35757 35757 16799 1 0.00564222257954052
130056 130056 46319 46319 16799 1 0.0047447132115906
321086 321086 108201 108201 16799 4 0.378378378378378
735295 735295 259368 259368 16799 1 0.0047447132115906
857053 857053 296438 296438 16799 1 0.00564222257954052
1174299 1174299 394119 394119 16799 1 0.00564222257954052
1429683 1429683 445744 445744 16799 1 0.00564222257954052
1586924 1586924 479041 479041 16799 1 0.00564222257954052
1607051 1607051 485510 485510 16799 1 0.00564222257954052
1613303 1613303 487061 487061 16799 1 0.00564222257954052
1665942 1665942 505116 505116 16799 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)
);