consensus_index

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

12 rows where inchi_id = 119990

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5548 5548 1672 1672 119990 5 0.524986292883518
135138 135138 47893 47893 119990 6 0.254496378168507
204973 204973 72644 72644 119990 3 0.51638018123073
228033 228033 78396 78396 119990 6 0.470860016171139
487458 487458 181331 181331 119990 1 0.191489361702128
520086 520086 207770 207770 119990 9 0.47458439644757
520088 520088 207771 207771 119990 3 0.533682447654332
530833 530833 210623 210623 119990 1 0.599254417849115
577752 577752 226350 226350 119990 1 0.378378378378378
957435 957435 344268 344268 119990 3 0.533682447654332
1684467 1684467 512176 512176 119990 1 0.192307692307692
1722979 1722979 527667 527667 119990 3 0.533682447654332 
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)
);