consensus_index

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

11 rows where inventory_id = 42307

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121724 121724 42307 42307 138366 1 0.0361019676286709
121725 121725 42307 42307 138370 4 0.103772683351517
121726 121726 42307 42307 183681 4 0.0701088329046554
121727 121727 42307 42307 216323 4 0.288815741029367
121728 121728 42307 42307 230867 3 0.0585545225480608
121729 121729 42307 42307 257628 2 0.117908532534293
121730 121730 42307 42307 258438 3 0.0929495106902874
121731 121731 42307 42307 267246 1 0.0412593915756238
121732 121732 42307 42307 271596 1 0.0288815741029367
121733 121733 42307 42307 294543 1 0.0320906378921519
121734 121734 42307 42307 329384 2 0.0355507601816056 
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)
);