home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 71341

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
200804 200804 71341 71341 15321 1 0.0454545454545455
200805 200805 71341 71341 16330 1 0.159090909090909
200806 200806 71341 71341 31919 1 0.053030303030303
200807 200807 71341 71341 74055 12 0.318181818181818
200808 200808 71341 71341 147754 1 0.159090909090909
200809 200809 71341 71341 152426 1 0.0795454545454545
200810 200810 71341 71341 157251 1 0.0636363636363636
200811 200811 71341 71341 219463 1 0.106060606060606
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 1153.075ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website