consensus_index

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

16 rows where inchi_id = 138052

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9330 9330 2829 2829 138052 1 0.230769230769231
148056 148056 53281 53281 138052 1 0.00327007058581385
201485 201485 71494 71494 138052 1 0.230769230769231
209697 209697 73889 73889 138052 1 0.00400054316282202
236075 236075 80484 80484 138052 2 0.100532950102548
422302 422302 153107 153107 138052 1 0.00400054316282202
553689 553689 218483 218483 138052 1 0.00400054316282202
663267 663267 237794 237794 138052 1 0.00400054316282202
706791 706791 251131 251131 138052 2 0.201980198019802
712405 712405 252491 252491 138052 1 0.00348912011247223
803910 803910 280233 280233 138052 2 0.200956937799043
803915 803915 280234 280234 138052 2 0.231454005934718
813258 813258 282807 282807 138052 1 0.00400054316282202
1624183 1624183 490452 490452 138052 2 0.200956937799043
1714913 1714913 525434 525434 138052 1 0.00400054316282202
1725056 1725056 528220 528220 138052 1 0.226415094339623 
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)
);