consensus_index

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

20 rows where inchi_id = 85227

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
19514 19514 5745 5745 85227 8 0.461538461538462
29723 29723 8609 8609 85227 1 0.230769230769231
84388 84388 30368 30368 85227 8 0.461538461538462
128732 128732 45917 45917 85227 12 0.37847866419295
218014 218014 75607 75607 85227 8 0.375903614457831
240326 240326 81685 81685 85227 2 0.200514138817481
427662 427662 154182 154182 85227 8 0.375903614457831
438757 438757 157249 157249 85227 1 0.157894736842105
515101 515101 206556 206556 85227 7 0.375
552581 552581 218201 218201 85227 2 0.143712574850299
713338 713338 252672 252672 85227 1 0.230769230769231
735119 735119 259321 259321 85227 8 0.461538461538462
814802 814802 283115 283115 85227 1 0.226415094339623
814806 814806 283116 283116 85227 1 0.230769230769231
856707 856707 296359 296359 85227 8 0.461538461538462
856712 856712 296360 296360 85227 8 0.375903614457831
872917 872917 301449 301449 85227 1 0.226415094339623
944450 944450 338239 338239 85227 4 0.452830188679245
1613181 1613181 487043 487043 85227 8 0.461538461538462
1726347 1726347 528591 528591 85227 1 0.230769230769231 
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)
);