consensus_index

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

27 rows where inchi_id = 103984

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31940 31940 9381 9381 103984 1 0.18214538395099
39449 39449 11911 11911 103984 6 0.392676243814934
79114 79114 28571 28571 103984 1 0.18214538395099
129006 129006 46017 46017 103984 2 0.0807042845647009
159948 159948 57514 57514 103984 11 0.323303207653434
249087 249087 84711 84711 103984 2 0.150203560683408
278829 278829 94536 94536 103984 6 0.328923896324836
342313 342313 115536 115536 103984 3 0.105631739200376
442505 442505 158613 158613 103984 2 0.150203560683408
453640 453640 162912 162912 103984 6 0.328923896324836
479151 479151 175108 175108 103984 2 0.119521912350598
534546 534546 212129 212129 103984 3 0.224809459673838
559953 559953 220263 220263 103984 6 0.330893830951923
703873 703873 250633 250633 103984 6 0.392676243814934
733317 733317 258590 258590 103984 2 0.146437429028994
800852 800852 279371 279371 103984 6 0.392676243814934
800856 800856 279372 279372 103984 3 0.406779661016949
852807 852807 295035 295035 103984 1 0.18214538395099
852812 852812 295036 295036 103984 1 0.190074540970748
852817 852817 295037 295037 103984 1 0.191286497410388
852822 852822 295038 295038 103984 1 0.18214538395099
852827 852827 295039 295039 103984 1 0.177652684419504
852833 852833 295040 295040 103984 3 0.228451506744855
1631064 1631064 492921 492921 103984 1 0.18214538395099
1644927 1644927 497938 497938 103984 6 0.330893830951923
1728351 1728351 529280 529280 103984 1 0.18214538395099
1735795 1735795 531743 531743 103984 6 0.392676243814934 
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)
);