consensus_index

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

10 rows where inchi_id = 129004

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
50363 50363 15628 15628 129004 2 0.277777777777778
103048 103048 36256 36256 129004 2 0.277777777777778
151134 151134 54174 54174 129004 2 0.277777777777778
308946 308946 104387 104387 129004 1 0.276923076923077
466276 466276 168416 168416 129004 1 0.272727272727273
582961 582961 227896 227896 129004 1 0.275862068965517
681462 681462 243403 243403 129004 2 0.277777777777778
958504 958504 344819 344819 129004 1 0.272727272727273
1660356 1660356 503230 503230 129004 2 0.277777777777778
1745139 1745139 534529 534529 129004 2 0.277777777777778 
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)
);