home / zeropm-v0-0-4

consensus_index

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

14 rows where inchi_id = 186942

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48635 48635 14962 14962 186942 3 0.0910886077531637
87216 87216 31229 31229 186942 3 0.0910886077531637
134804 134804 47774 47774 186942 3 0.0910886077531637
243674 243674 82896 82896 186942 1 0.127320944816675
302914 302914 102513 102513 186942 2 0.153743404041714
549150 549150 217059 217059 186942 1 0.1875
593669 593669 231347 231347 186942 1 0.144976087552006
671836 671836 240437 240437 186942 3 0.0910886077531637
717644 717644 253829 253829 186942 1 0.130010179379062
743117 743117 261643 261643 186942 3 0.0910886077531637
743127 743127 261644 261644 186942 1 0.144976087552006
821228 821228 285135 285135 186942 1 0.127320944816675
887977 887977 309611 309611 186942 1 0.146849929364008
1656146 1656146 501837 501837 186942 3 0.0910886077531637
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 607.471ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website