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 = 5386

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1803 1803 450 450 5386 6 0.875
76600 76600 27453 27453 5386 5 0.857142857142857
80060 80060 28887 28887 5386 6 0.615384615384615
188593 188593 67138 67138 5386 7 0.888888888888889
207383 207383 73422 73422 5386 6 0.875
419343 419343 150027 150027 5386 2 0.630993034743972
428770 428770 154510 154510 5386 1 0.239130434782609
429456 429456 154709 154709 5386 1 0.1875
515942 515942 206778 206778 5386 1 0.241935483870968
589752 589752 230209 230209 5386 4 0.833333333333333
676486 676486 241762 241762 5386 10 0.916666666666667
740955 740955 261049 261049 5386 1 0.1875
874796 874796 302375 302375 5386 4 0.833333333333333
999066 999066 357991 357991 5386 7 0.888888888888889
999067 999067 357992 357992 5386 7 0.888888888888889
999068 999068 357993 357993 5386 7 0.888888888888889
999069 999069 357994 357994 5386 7 0.888888888888889
999070 999070 357995 357995 5386 7 0.888888888888889
999071 999071 357996 357996 5386 7 0.888888888888889
1210106 1210106 402381 402381 5386 7 0.888888888888889
1210107 1210107 402382 402382 5386 7 0.888888888888889
1210108 1210108 402383 402383 5386 7 0.888888888888889
1210109 1210109 402384 402384 5386 7 0.888888888888889
1210110 1210110 402385 402385 5386 7 0.888888888888889
1210111 1210111 402386 402386 5386 7 0.888888888888889
1210112 1210112 402387 402387 5386 7 0.888888888888889
1453721 1453721 451514 451514 5386 7 0.888888888888889
1453722 1453722 451515 451515 5386 7 0.888888888888889
1453723 1453723 451516 451516 5386 7 0.888888888888889
1453724 1453724 451517 451517 5386 7 0.888888888888889
1453725 1453725 451518 451518 5386 7 0.888888888888889
1592001 1592001 480554 480554 5386 7 0.888888888888889
1711802 1711802 524025 524025 5386 7 0.888888888888889
1764671 1764671 542723 542723 5386 7 0.888888888888889
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 1953.831ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website