consensus_index

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

12 rows where inchi_id = 170020

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
9293 9293 2817 2817 170020 1 0.153846153846154
17523 17523 5142 5142 170020 1 0.173228346456693
132425 132425 47077 47077 170020 1 0.153846153846154
203139 203139 71988 71988 170020 1 0.153846153846154
214750 214750 74654 74654 170020 1 0.153846153846154
425525 425525 153575 153575 170020 1 0.153846153846154
513968 513968 206302 206302 170020 1 0.173228346456693
537458 537458 213247 213247 170020 2 0.155844155844156
729820 729820 257499 257499 170020 2 0.155844155844156
846080 846080 293046 293046 170020 1 0.173228346456693
846084 846084 293047 293047 170020 1 0.153846153846154
1611014 1611014 486311 486311 170020 1 0.173228346456693 
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)
);