consensus_index

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

15 rows where inchi_id = 231987

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4766 4766 1448 1448 231987 2 0.0916814548464297
45459 45459 13854 13854 231987 1 0.0995582645862173
122369 122369 42500 42500 231987 1 0.0995582645862173
162553 162553 58229 58229 231987 2 0.0982365839922265
200353 200353 71248 71248 231987 1 0.146598177453382
296151 296151 100193 100193 231987 1 0.146598177453382
459723 459723 165275 165275 231987 1 0.0997000640913612
525161 525161 209176 209176 231987 1 0.0997000640913612
525167 525167 209177 209177 231987 1 0.0997000640913612
525173 525173 209178 209178 231987 1 0.104719115658499
540782 540782 214242 214242 231987 1 0.0514261562370506
726292 726292 256540 256540 231987 1 0.0995582645862173
838768 838768 290948 290948 231987 1 0.0995582645862173
1652170 1652170 500387 500387 231987 1 0.0950314056335141
1739551 1739551 532804 532804 231987 1 0.0995582645862173 
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)
);