consensus_index

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

12 rows where inchi_id = 31919

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3865 3865 1114 1114 31919 1 0.0531712875047474
141156 141156 50326 50326 31919 1 0.0532257121132362
200806 200806 71341 71341 31919 1 0.053030303030303
213719 213719 74361 74361 31919 2 0.0533130236100533
270304 270304 91660 91660 31919 8 0.625
271829 271829 92208 92208 31919 1 0.19047619047619
424819 424819 153369 153369 31919 1 0.062667860340197
513311 513311 206110 206110 31919 1 0.0630003315806925
513318 513318 206111 206111 31919 1 0.062667860340197
540499 540499 214156 214156 31919 1 0.062667860340197
665259 665259 238295 238295 31919 2 0.0633025863628142
665266 665266 238296 238296 31919 1 0.062667860340197 
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)
);