consensus_index

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

13 rows where inchi_id = 14938

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
12814 12814 3946 3946 14938 1 0.187951807228916
19676 19676 5762 5762 14938 1 0.187951807228916
129831 129831 46279 46279 14938 2 0.189473684210526
218129 218129 75639 75639 14938 2 0.314285714285714
318489 318489 107310 107310 14938 8 0.478260869565217
427734 427734 154202 154202 14938 2 0.314285714285714
533050 533050 211464 211464 14938 2 0.314285714285714
735442 735442 259405 259405 14938 1 0.187951807228916
857267 857267 296504 296504 14938 1 0.304347826086957
857272 857272 296505 296505 14938 1 0.187951807228916
857274 857274 296506 296506 14938 1 0.304347826086957
944375 944375 338197 338197 14938 1 0.3
1613367 1613367 487068 487068 14938 1 0.187951807228916 
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)
);