consensus_index

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

25 rows where inchi_id = 199861

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27309 27309 7924 7924 199861 2 0.110665830597077
43871 43871 13382 13382 199861 2 0.122785239637319
102749 102749 36186 36186 199861 2 0.110665830597077
158918 158918 57197 57197 199861 3 0.0649047900598718
162695 162695 58264 58264 199861 1 0.102283664644782
229218 229218 78640 78640 199861 2 0.19047619047619
230881 230881 79033 79033 199861 4 0.161710302282994
435189 435189 156253 156253 199861 1 0.1875
435786 435786 156385 156385 199861 2 0.110351819241632
565359 565359 222059 222059 199861 3 0.0649047900598718
578327 578327 226524 226524 199861 1 0.1875
697974 697974 248812 248812 199861 4 0.126568923590031
719112 719112 254262 254262 199861 4 0.123816459290461
790782 790782 276106 276106 199861 4 0.126410366367529
790789 790789 276107 276107 199861 2 0.0707148088241407
790798 790798 276108 276108 199861 4 0.161710302282994
790807 790807 276109 276109 199861 3 0.0656830736048633
790813 790813 276110 276110 199861 2 0.110351819241632
790818 790818 276111 276111 199861 2 0.110351819241632
823760 823760 285936 285936 199861 1 0.0783548827673343
823769 823769 285937 285937 199861 1 0.102283664644782
915731 915731 324505 324505 199861 2 0.110351819241632
1622216 1622216 489802 489802 199861 2 0.108321540297344
1723983 1723983 527929 527929 199861 2 0.110351819241632
1738020 1738020 532385 532385 199861 1 0.102283664644782 
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)
);