home / zeropm-v0-0-4

consensus_index

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

11 rows where inchi_id = 143789

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
67872 67872 22552 22552 143789 1 0.259842519685039
82516 82516 29721 29721 143789 1 0.259842519685039
178167 178167 63482 63482 143789 1 0.2625
288646 288646 97750 97750 143789 3 0.0913614143896622
383857 383857 131517 131517 143789 1 0.258620689655172
544547 544547 215448 215448 143789 1 0.253012048192771
722634 722634 255416 255416 143789 1 0.259842519685039
831287 831287 288481 288481 143789 1 0.12476370510397
831291 831291 288482 288482 143789 1 0.253012048192771
1699078 1699078 518250 518250 143789 1 0.259842519685039
1759460 1759460 539924 539924 143789 1 0.259842519685039
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 1964.699ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website