consensus_index

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

15 rows where inchi_id = 1381

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48138 48138 14817 14817 1381 8 0.625
301545 301545 102085 102085 1381 8 0.478260869565217
319980 319980 107838 107838 1381 1 0.0939759036144578
470119 470119 170137 170137 1381 1 0.114982578397213
575535 575535 225450 225450 1381 1 0.0939759036144578
898720 898720 315962 315962 1381 4 0.6
899488 899488 316318 316318 1381 1 0.113207547169811
1037460 1037460 367609 367609 1381 1 0.115384615384615
1037464 1037464 367610 367610 1381 1 0.115384615384615
1256937 1256937 414040 414040 1381 1 0.115384615384615
1256941 1256941 414041 414041 1381 1 0.115384615384615
1482609 1482609 458700 458700 1381 1 0.115384615384615
1482613 1482613 458701 458701 1381 1 0.115384615384615
1595619 1595619 481639 481639 1381 1 0.115384615384615
1665487 1665487 504944 504944 1381 1 0.115384615384615 
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)
);