home / zeropm-v0-0-4

consensus_index

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

12 rows where inchi_id = 147998

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19343 19343 5685 5685 147998 1 0.310344827586207
78629 78629 28412 28412 147998 1 0.310344827586207
217609 217609 75478 75478 147998 1 0.307692307692308
427388 427388 154095 154095 147998 1 0.310344827586207
514983 514983 206538 206538 147998 1 0.310344827586207
533686 533686 211724 211724 147998 1 0.310344827586207
895630 895630 314511 314511 147998 1 0.3
1173395 1173395 393910 393910 147998 1 0.310344827586207
1428887 1428887 445534 445534 147998 1 0.310344827586207
1586299 1586299 478898 478898 147998 1 0.310344827586207
1606844 1606844 485457 485457 147998 1 0.310344827586207
1612866 1612866 486927 486927 147998 1 0.310344827586207
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 1244.246ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website