consensus_index

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

18 rows where inchi_id = 138846

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
167539 167539 59873 59873 138846 1 0.185959386224063
180428 180428 64464 64464 138846 1 0.039994602388124
204461 204461 72484 72484 138846 1 0.0544674953884614
212841 212841 74251 74251 138846 1 0.0544674953884614
287698 287698 97445 97445 138846 1 0.188698147169853
424212 424212 153298 153298 138846 1 0.0544674953884614
501835 501835 200051 200051 138846 2 0.347467805589132
512691 512691 206040 206040 138846 1 0.0544674953884614
512699 512699 206041 206041 138846 1 0.0544674953884614
544015 544015 215201 215201 138846 1 0.0399631859413056
550284 550284 217545 217545 138846 1 0.198569692245327
664564 664564 238124 238124 138846 1 0.0544674953884614
723487 723487 255713 255713 138846 1 0.0546676709255394
833324 833324 289216 289216 138846 1 0.0544674953884614
873635 873635 301771 301771 138846 1 0.1875
895280 895280 314309 314309 138846 1 0.198569692245327
1648452 1648452 499164 499164 138846 1 0.117111611448966
1737380 1737380 532213 532213 138846 1 0.185959386224063 
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)
);