home / zeropm-v0-0-4

consensus_index

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

10 rows where inchi_id = 23767

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22830 22830 6704 6704 23767 1 0.0630946419629444
119385 119385 41554 41554 23767 1 0.0630946419629444
131524 131524 46696 46696 23767 1 0.0542583362229895
330738 330738 111475 111475 23767 8 0.625
474322 474322 172448 172448 23767 8 0.625
673223 673223 240781 240781 23767 1 0.0542583362229895
745854 745854 262400 262400 23767 1 0.0630946419629444
779444 779444 272563 272563 23767 4 0.6
779446 779446 272564 272564 23767 7 0.620689655172414
938671 938671 335412 335412 23767 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 1204.261ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website