consensus_index

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

28 rows where inchi_id = 31905

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
2604 2604 712 712 31905 11 0.482758620689655
27265 27265 7917 7917 31905 8 0.625
47176 47176 14486 14486 31905 1 0.0220700462709996
78648 78648 28422 28422 31905 8 0.625
104352 104352 36789 36789 31905 1 0.0220700462709996
159020 159020 57248 57248 31905 1 0.0220700462709996
180384 180384 64444 64444 31905 13 0.484848484848485
202372 202372 71745 71745 31905 11 0.482758620689655
230691 230691 79005 79005 31905 7 0.620689655172414
435727 435727 156371 156371 31905 7 0.620689655172414
461626 461626 165860 165860 31905 1 0.0220700462709996
520827 520827 207932 207932 31905 8 0.478260869565217
520830 520830 207933 207933 31905 8 0.478260869565217
533897 533897 211852 211852 31905 1 0.0220700462709996
565496 565496 222095 222095 31905 8 0.625
662134 662134 237284 237284 31905 4 0.6
697750 697750 248760 248760 31905 12 0.483870967741935
734046 734046 258900 258900 31905 1 0.0220700462709996
790424 790424 276012 276012 31905 8 0.625
790426 790426 276013 276013 31905 8 0.478260869565217
790429 790429 276014 276014 31905 5 0.608695652173913
790431 790431 276015 276015 31905 5 0.608695652173913
854573 854573 295594 295594 31905 1 0.0220700462709996
936575 936575 334431 334431 31905 4 0.6
1622118 1622118 489790 489790 31905 8 0.625
1654347 1654347 501198 501198 31905 1 0.0220700462709996
1723862 1723862 527914 527914 31905 7 0.620689655172414
1741672 1741672 533454 533454 31905 1 0.0220700462709996 
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)
);