consensus_index

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

11 rows where inchi_id = 297871

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39987 39987 12099 12099 297871 1 0.0789473684210526
101563 101563 35854 35854 297871 1 0.0789473684210526
145435 145435 51853 51853 297871 2 0.108113027381255
280872 280872 95255 95255 297871 1 0.0787589498806683
802517 802517 279864 279864 297871 1 0.0779220779220779
802522 802522 279865 279865 297871 1 0.0779220779220779
1057111 1057111 373738 373738 297871 1 0.0789473684210526
1280624 1280624 421346 421346 297871 1 0.0789473684210526
1497215 1497215 463349 463349 297871 1 0.0789473684210526
1599864 1599864 483297 483297 297871 1 0.0789473684210526
1645815 1645815 498275 498275 297871 1 0.0789473684210526 
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)
);