consensus_index

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

12 rows where inchi_id = 60090

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31169 31169 9129 9129 60090 8 0.9
48630 48630 14962 14962 60090 1 0.0248423475690446
87211 87211 31229 31229 60090 1 0.0248423475690446
134799 134799 47774 47774 60090 1 0.0248423475690446
244933 244933 83349 83349 60090 7 0.888888888888889
547905 547905 216643 216643 60090 7 0.888888888888889
671831 671831 240437 240437 60090 1 0.0248423475690446
719102 719102 254260 254260 60090 8 0.9
743112 743112 261643 261643 60090 1 0.0248423475690446
898837 898837 316015 316015 60090 4 0.833333333333333
1629291 1629291 492271 492271 60090 8 0.9
1656141 1656141 501837 501837 60090 1 0.0248423475690446 
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)
);