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 = 31683

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
154076 154076 55371 55371 31683 4 0.6
270076 270076 91572 91572 31683 8 0.413793103448276
326670 326670 110094 110094 31683 4 0.311235801799261
450616 450616 161662 161662 31683 8 0.413793103448276
697535 697535 248674 248674 31683 7 0.620689655172414
790048 790048 275902 275902 31683 7 0.620689655172414
790050 790050 275903 275903 31683 4 0.6
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 958.424ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website