home / zeropm-v0-0-4

consensus_index

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

7 rows where inchi_id = 2547

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
75935 75935 26844 26844 2547 5 0.857142857142857
151701 151701 54492 54492 2547 4 0.233883075176258
502203 502203 200463 200463 2547 3 0.357816655472105
586821 586821 229163 229163 2547 3 0.36045366724938
836914 836914 290361 290361 2547 1 0.196388259965631
879447 879447 305304 305304 2547 4 0.833333333333333
879743 879743 305464 305464 2547 3 0.36045366724938
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)
);
Powered by Datasette · Queries took 2084.072ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website