consensus_index

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

19 rows where inchi_id = 43749

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
8634 8634 2612 2612 43749 8 0.562476368502435
115131 115131 40164 40164 43749 1 0.149439601494396
189308 189308 67451 67451 43749 12 0.636363636363636
234104 234104 79993 79993 43749 8 0.562476368502435
244180 244180 83092 83092 43749 3 0.261744966442953
431119 431119 155169 155169 43749 1 0.198300283286119
518210 518210 207300 207300 43749 1 0.198300283286119
673898 673898 240953 240953 43749 1 0.149439601494396
704399 704399 250779 250779 43749 12 0.383264392395412
747257 747257 262814 262814 43749 5 0.259800083110909
747264 747264 262815 262815 43749 1 0.149439601494396
801705 801705 279646 279646 43749 8 0.625
801707 801707 279647 279647 43749 8 0.562476368502435
938475 938475 335338 335338 43749 4 0.833333333333333
942550 942550 337439 337439 43749 1 0.196078431372549
1617822 1617822 488500 488500 43749 1 0.149439601494396
1623444 1623444 490240 490240 43749 8 0.625
1720585 1720585 526963 526963 43749 1 0.196078431372549
1724563 1724563 528099 528099 43749 4 0.833333333333333 
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)
);