consensus_index

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

18 rows where inventory_id = 156687

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
436890 436890 156687 156687 14033 1 0.0278057644613666
436891 436891 156687 156687 24189 2 0.0303474980846277
436892 436892 156687 156687 44866 7 0.2502518801523
436893 436893 156687 156687 44867 1 0.0834172933840998
436894 436894 156687 156687 45344 1 0.0834172933840998
436895 436895 156687 156687 75665 1 0.0156407425095187
436896 436896 156687 156687 84307 1 0.0500503760304599
436897 436897 156687 156687 136277 2 0.0559580215517672
436898 436898 156687 156687 154560 1 0.01668345867682
436899 436899 156687 156687 169434 1 0.12512594007615
436900 436900 156687 156687 186000 1 0.0312814850190374
436901 436901 156687 156687 196803 1 0.0227501709229363
436902 436902 156687 156687 201068 1 0.0192501446271
436903 436903 156687 156687 205935 1 0.020854323346025
436904 436904 156687 156687 233350 1 0.0417086466920499
436905 436905 156687 156687 234499 1 0.0625629700380749
436906 436906 156687 156687 240083 1 0.0357502685931856
436907 436907 156687 156687 275380 1 0.0178751342965928 
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)
);