consensus_index

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

12 rows where inchi_id = 43416

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
39643 39643 11985 11985 43416 6 0.341968911917098
84814 84814 30521 30521 43416 6 0.341968911917098
133737 133737 47442 47442 43416 6 0.341968911917098
172113 172113 61434 61434 43416 1 0.3125
279563 279563 94806 94806 43416 5 0.470588235294118
519540 519540 207635 207635 43416 1 0.317073170731707
704128 704128 250718 250718 43416 6 0.341968911917098
801292 801292 279529 279529 43416 6 0.341968911917098
801295 801295 279530 279530 43416 5 0.470588235294118
884102 884102 307647 307647 43416 3 0.454545454545455
1619440 1619440 489027 489027 43416 1 0.3125
1645258 1645258 498068 498068 43416 6 0.341968911917098 
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)
);