consensus_index

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

22 rows where inchi_id = 97917

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
38020 38020 11444 11444 97917 2 0.473684210526316
121248 121248 42150 42150 97917 2 0.473684210526316
174529 174529 62344 62344 97917 1 0.229344310496913
272801 272801 92545 92545 97917 2 0.470588235294118
451661 451661 162092 162092 97917 2 0.461538461538462
563814 563814 221540 221540 97917 2 0.473684210526316
667855 667855 239329 239329 97917 2 0.473684210526316
794012 794012 277127 277127 97917 1 0.466666666666667
794014 794014 277128 277128 97917 2 0.461538461538462
794016 794016 277129 277129 97917 2 0.473684210526316
881727 881727 306411 306411 97917 1 0.454545454545455
1052407 1052407 372146 372146 97917 2 0.473684210526316
1052409 1052409 372147 372147 97917 2 0.473684210526316
1274717 1274717 419362 419362 97917 2 0.473684210526316
1274719 1274719 419363 419363 97917 2 0.473684210526316
1274721 1274721 419364 419364 97917 2 0.473684210526316
1274723 1274723 419365 419365 97917 2 0.473684210526316
1493516 1493516 462081 462081 97917 2 0.473684210526316
1493518 1493518 462082 462082 97917 2 0.473684210526316
1598720 1598720 482884 482884 97917 2 0.473684210526316
1642377 1642377 497026 497026 97917 2 0.473684210526316
1734588 1734588 531345 531345 97917 2 0.473684210526316 
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)
);