home / zeropm-v0-0-4

consensus_index

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

29 rows where inchi_id = 31490

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
20190 20190 5936 5936 31490 1 0.173228346456693
27149 27149 7896 7896 31490 8 0.521739130434783
96914 96914 34342 34342 31490 1 0.173228346456693
145378 145378 51833 51833 31490 1 0.211119597865885
178771 178771 63723 63723 31490 1 0.134831460674157
219125 219125 75940 75940 31490 1 0.133971291866029
230432 230432 78952 78952 31490 8 0.519685039370079
251966 251966 85611 85611 31490 2 0.14181859017629
428441 428441 154419 154419 31490 1 0.133971291866029
435614 435614 156348 156348 31490 7 0.517241379310345
515739 515739 206728 206728 31490 1 0.133971291866029
520739 520739 207914 207914 31490 8 0.521739130434783
565870 565870 222199 222199 31490 8 0.521739130434783
697343 697343 248626 248626 31490 8 0.521739130434783
736511 736511 259757 259757 31490 1 0.173228346456693
789733 789733 275815 275815 31490 4 0.506024096385542
789736 789736 275816 275816 31490 8 0.521739130434783
859170 859170 297218 297218 31490 1 0.173228346456693
859173 859173 297219 297219 31490 1 0.133971291866029
930404 930404 331219 331219 31490 4 0.506024096385542
933346 933346 332538 332538 31490 1 0.168674698795181
1049365 1049365 371291 371291 31490 8 0.521739130434783
1271151 1271151 418307 418307 31490 8 0.521739130434783
1491286 1491286 461448 461448 31490 8 0.521739130434783
1598134 1598134 482685 482685 31490 8 0.521739130434783
1614073 1614073 487314 487314 31490 1 0.173228346456693
1621976 1621976 489761 489761 31490 8 0.521739130434783
1718698 1718698 526381 526381 31490 1 0.168674698795181
1723750 1723750 527888 527888 31490 8 0.521739130434783
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 1089.729ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website