consensus_index

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

12 rows where inchi_id = 31117

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
58341 58341 18401 18401 31117 7 0.888888888888889
78364 78364 28329 28329 31117 7 0.888888888888889
184604 184604 65918 65918 31117 7 0.888888888888889
189861 189861 67670 67670 31117 3 0.690983005625053
341757 341757 115334 115334 31117 6 0.875
501954 501954 200262 200262 31117 2 0.630993034743972
566063 566063 222268 222268 31117 4 0.833333333333333
697140 697140 248521 248521 31117 7 0.888888888888889
789380 789380 275688 275688 31117 4 0.833333333333333
919992 919992 326378 326378 31117 4 0.833333333333333
1675013 1675013 508429 508429 31117 5 0.857142857142857
1752573 1752573 536911 536911 31117 6 0.875 
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)
);