consensus_index

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

28 rows where inchi_id = 30242

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
37271 37271 11173 11173 30242 6 0.473684210526316
87250 87250 31238 31238 30242 6 0.384615384615385
165602 165602 59319 59319 30242 6 0.473684210526316
269002 269002 91192 91192 30242 6 0.473684210526316
373498 373498 127326 127326 30242 2 0.321469978651042
373710 373710 127409 127409 30242 1 0.3125
504897 504897 201972 201972 30242 6 0.384615384615385
524042 524042 208884 208884 30242 8 0.388059701492537
524045 524045 208885 208885 30242 6 0.384615384615385
566556 566556 222431 222431 30242 6 0.473684210526316
696606 696606 248348 248348 30242 6 0.473684210526316
788237 788237 275264 275264 30242 6 0.473684210526316
788239 788239 275265 275265 30242 6 0.473684210526316
1048269 1048269 370999 370999 30242 6 0.473684210526316
1048271 1048271 371000 371000 30242 6 0.473684210526316
1048273 1048273 371001 371001 30242 6 0.473684210526316
1269647 1269647 417935 417935 30242 6 0.473684210526316
1269649 1269649 417936 417936 30242 6 0.473684210526316
1269651 1269651 417937 417937 30242 6 0.473684210526316
1269653 1269653 417938 417938 30242 6 0.473684210526316
1269655 1269655 417939 417939 30242 6 0.473684210526316
1269657 1269657 417940 417940 30242 6 0.473684210526316
1490393 1490393 461214 461214 30242 6 0.473684210526316
1490395 1490395 461215 461215 30242 6 0.473684210526316
1490397 1490397 461216 461216 30242 6 0.473684210526316
1597900 1597900 482613 482613 30242 6 0.473684210526316
1640457 1640457 496288 496288 30242 6 0.473684210526316
1733669 1733669 531030 531030 30242 3 0.454545454545455 
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)
);