home / zeropm-v0-0-4

consensus_index

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

20 rows where inchi_id = 31982

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
999 999 218 218 31982 1 0.172392627512783
47320 47320 14570 14570 31982 1 0.165453705809917
122064 122064 42405 42405 31982 1 0.165453705809917
174720 174720 62410 62410 31982 1 0.170128427482142
200215 200215 71206 71206 31982 1 0.172392627512783
300016 300016 101604 101604 31982 1 0.172392627512783
461733 461733 165903 165903 31982 1 0.172392627512783
526667 526667 209524 209524 31982 1 0.172392627512783
526670 526670 209525 209525 31982 1 0.167800937896422
526673 526673 209526 209526 31982 1 0.167800937896422
596185 596185 232118 232118 31982 1 0.172392627512783
668985 668985 239670 239670 31982 1 0.170546788899997
737572 737572 260058 260058 31982 1 0.1733263323934
737575 737575 260059 260059 31982 1 0.172392627512783
737578 737578 260060 260060 31982 1 0.165453705809917
917446 917446 325200 325200 31982 1 0.0920920111392655
917615 917615 325263 325263 31982 4 0.392156862745098
934175 934175 332949 332949 31982 1 0.167800937896422
1654496 1654496 501300 501300 31982 1 0.165453705809917
1741872 1741872 533551 533551 31982 1 0.165453705809917
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 905.664ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website