consensus_index

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

25 rows where inchi_id = 115886

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7331 7331 2196 2196 115886 2 0.345611808258325
34909 34909 10338 10338 115886 2 0.342857142857143
84321 84321 30340 30340 115886 2 0.342857142857143
157419 157419 56608 56608 115886 3 0.300690464575554
201656 201656 71539 71539 115886 2 0.345611808258325
258794 258794 87626 87626 115886 2 0.345611808258325
446328 446328 159878 159878 115886 2 0.341968911917098
499946 499946 197172 197172 115886 2 0.378378378378378
576137 576137 225843 225843 115886 2 0.345611808258325
661055 661055 236669 236669 115886 2 0.345611808258325
687218 687218 245090 245090 115886 3 0.300690464575554
771467 771467 269921 269921 115886 2 0.342857142857143
771471 771471 269922 269922 115886 2 0.301340540449725
889593 889593 310717 310717 115886 1 0.336
1036399 1036399 367276 367276 115886 2 0.342857142857143
1036403 1036403 367277 367277 115886 2 0.342857142857143
1036407 1036407 367278 367278 115886 2 0.342857142857143
1255809 1255809 413686 413686 115886 2 0.342857142857143
1255813 1255813 413687 413687 115886 2 0.342857142857143
1255817 1255817 413688 413688 115886 2 0.342857142857143
1255821 1255821 413689 413689 115886 2 0.342857142857143
1481812 1481812 458449 458449 115886 2 0.342857142857143
1595447 1595447 481582 481582 115886 2 0.342857142857143
1635705 1635705 494504 494504 115886 2 0.342857142857143
1731320 1731320 530158 530158 115886 2 0.341968911917098 
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)
);