consensus_index

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

12 rows where inchi_id = 38378

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27605 27605 8010 8010 38378 7 0.620689655172414
60740 60740 19381 19381 38378 1 0.3125
110028 110028 38532 38532 38378 1 0.3125
154202 154202 55437 55437 38378 4 0.6
162778 162778 58301 58301 38378 1 0.241935483870968
232632 232632 79569 79569 38378 6 0.615384615384615
353104 353104 119436 119436 38378 1 0.310344827586207
353143 353143 119452 119452 38378 1 0.192307692307692
482992 482992 177673 177673 38378 1 0.310344827586207
1622965 1622965 490075 490075 38378 6 0.615384615384615
1679727 1679727 510231 510231 38378 1 0.3125
1724293 1724293 528018 528018 38378 7 0.620689655172414 
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)
);