consensus_index

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

9 rows where inchi_id = 83172

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
216348 216348 75120 75120 83172 7 0.620689655172414
249970 249970 84997 84997 83172 1 0.310344827586207
418975 418975 149688 149688 83172 1 0.0348000595324032
533045 533045 211461 211461 83172 1 0.310344827586207
535085 535085 212310 212310 83172 10 0.377358490566038
733012 733012 258504 258504 83172 8 0.413793103448276
907516 907516 320368 320368 83172 1 0.3
1612024 1612024 486646 486646 83172 8 0.413793103448276
1717631 1717631 526040 526040 83172 8 0.413793103448276 
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)
);