home / zeropm-v0-0-4

consensus_index

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

21 rows where inchi_id = 34123

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27397 27397 7948 7948 34123 8 0.461538461538462
116402 116402 40593 40593 34123 8 0.461538461538462
125268 125268 44773 44773 34123 3 0.260492040520984
190149 190149 67801 67801 34123 8 0.461538461538462
231379 231379 79173 79173 34123 8 0.282708165428573
251210 251210 85353 85353 34123 2 0.120216497367688
321524 321524 108336 108336 34123 3 0.28837678327727
330413 330413 111379 111379 34123 1 0.122816804787974
435924 435924 156428 156428 34123 8 0.282708165428573
443201 443201 158863 158863 34123 1 0.0966388747624598
530890 530890 210640 210640 34123 2 0.120216497367688
555290 555290 218902 218902 34123 2 0.282708110638294
564252 564252 221686 221686 34123 11 0.230620452723235
574795 574795 225192 225192 34123 2 0.339612331977836
699245 699245 249202 249202 34123 12 0.283375770797649
891917 891917 312811 312811 34123 1 0.112088939694063
891928 891928 312819 312819 34123 1 0.0966388747624598
891944 891944 312826 312826 34123 2 0.346950805651904
893039 893039 313307 313307 34123 4 0.452830188679245
1622433 1622433 489869 489869 34123 8 0.461538461538462
1724079 1724079 527953 527953 34123 8 0.461538461538462
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)
);
Powered by Datasette · Queries took 781.266ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website