home / zeropm-v0-0-4

consensus_index

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

16 rows where inventory_id = 42043

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
120900 120900 42043 42043 7801 3 0.107432023527468
120901 120901 42043 42043 130556 8 0.173775683829073
120902 120902 42043 42043 136391 2 0.107432023527468
120903 120903 42043 42043 197767 2 0.0509594831981394
120904 120904 42043 42043 197769 2 0.0434583932918201
120905 120905 42043 42043 197771 2 0.0379829561764327
120906 120906 42043 42043 227352 1 0.0201435044114003
120907 120907 42043 42043 229306 2 0.0861372480873477
120908 120908 42043 42043 230121 2 0.0416082437971247
120909 120909 42043 42043 245401 2 0.0402870088228005
120910 120910 42043 42043 255538 2 0.0438589399461623
120911 120911 42043 42043 264660 1 0.0189585923872002
120912 120912 42043 42043 267987 3 0.127903280371931
120913 120913 42043 42043 277630 2 0.0269517513881217
120914 120914 42043 42043 310149 1 0.0230211478987432
120915 120915 42043 42043 332546 2 0.0416082437971247
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 1850.687ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website