consensus_index

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

13 rows where inchi_id = 106999

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27866 27866 8086 8086 106999 2 0.473684210526316
93210 93210 33145 33145 106999 2 0.473684210526316
155428 155428 55893 55893 106999 2 0.473684210526316
234384 234384 80051 80051 106999 1 0.470588235294118
436596 436596 156625 156625 106999 1 0.470588235294118
559330 559330 220056 220056 106999 1 0.470588235294118
704626 704626 250836 250836 106999 3 0.388888888888889
801996 801996 279723 279723 106999 1 0.470588235294118
801998 801998 279724 279724 106999 2 0.473684210526316
802000 802000 279725 279725 106999 1 0.454545454545455
879690 879690 305437 305437 106999 1 0.454545454545455
1623536 1623536 490264 490264 106999 2 0.473684210526316
1724669 1724669 528123 528123 106999 1 0.466666666666667 
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)
);