home / zeropm-v0-0-4

consensus_index

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

34 rows where inchi_id = 197007

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1471 1471 334 334 197007 1 0.139130434782609
20937 20937 6177 6177 197007 1 0.173228346456693
100911 100911 35664 35664 197007 1 0.173228346456693
178788 178788 63729 63729 197007 1 0.173228346456693
204315 204315 72452 72452 197007 1 0.137931034482759
219266 219266 75991 75991 197007 1 0.137931034482759
428569 428569 154460 154460 197007 1 0.173228346456693
515820 515820 206747 206747 197007 1 0.173228346456693
515823 515823 206748 206748 197007 1 0.173228346456693
515826 515826 206749 206749 197007 1 0.173228346456693
531402 531402 210784 210784 197007 1 0.173228346456693
736668 736668 259793 259793 197007 1 0.175438596491228
859468 859468 297306 297306 197007 1 0.173228346456693
859471 859471 297307 297307 197007 1 0.172413793103448
859474 859474 297308 297308 197007 1 0.170212765957447
903572 903572 318491 318491 197007 1 0.168674698795181
1176842 1176842 394875 394875 197007 1 0.173228346456693
1176845 1176845 394876 394876 197007 1 0.173228346456693
1176848 1176848 394877 394877 197007 1 0.173228346456693
1176851 1176851 394878 394878 197007 1 0.173228346456693
1176854 1176854 394879 394879 197007 1 0.173228346456693
1432399 1432399 446543 446543 197007 1 0.173228346456693
1432402 1432402 446544 446544 197007 1 0.173228346456693
1432405 1432405 446545 446545 197007 1 0.173228346456693
1432408 1432408 446546 446546 197007 1 0.173228346456693
1432411 1432411 446547 446547 197007 1 0.173228346456693
1588771 1588771 479587 479587 197007 1 0.173228346456693
1588774 1588774 479588 479588 197007 1 0.173228346456693
1588777 1588777 479589 479589 197007 1 0.173228346456693
1588780 1588780 479590 479590 197007 1 0.173228346456693
1588783 1588783 479591 479591 197007 1 0.173228346456693
1607481 1607481 485642 485642 197007 1 0.173228346456693
1614227 1614227 487365 487365 197007 1 0.173228346456693
1718768 1718768 526401 526401 197007 1 0.170212765957447
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 853.758ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website