consensus_index

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

12 rows where inchi_id = 23591

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
36049 36049 10745 10745 23591 6 0.473684210526316
114468 114468 39918 39918 23591 6 0.473684210526316
186428 186428 66452 66452 23591 15 0.205752076912086
264469 264469 89595 89595 23591 6 0.473684210526316
448300 448300 160705 160705 23591 6 0.473684210526316
571071 571071 223860 223860 23591 6 0.473684210526316
692437 692437 246935 246935 23591 6 0.473684210526316
779321 779321 272516 272516 23591 6 0.473684210526316
779323 779323 272517 272517 23591 6 0.473684210526316
779325 779325 272518 272518 23591 3 0.454545454545455
901246 901246 317236 317236 23591 3 0.454545454545455
1732482 1732482 530593 530593 23591 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)
);