home / zeropm-v0-0-4

consensus_index

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

22 rows where inchi_id = 31079

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
58315 58315 18393 18393 31079 5 0.857142857142857
60530 60530 19283 19283 31079 1 0.294638159587951
64351 64351 20893 20893 31079 5 0.608695652173913
109922 109922 38475 38475 31079 7 0.888888888888889
174948 174948 62482 62482 31079 1 0.146443514644351
175661 175661 62667 62667 31079 7 0.888888888888889
341696 341696 115310 115310 31079 6 0.875
351981 351981 119012 119012 31079 1 0.271358205008539
370478 370478 126103 126103 31079 4 0.532491436537994
376077 376077 128394 128394 31079 1 0.461538461538462
429364 429364 154678 154678 31079 1 0.145808019441069
516514 516514 206909 206909 31079 1 0.145808019441069
516522 516522 206910 206910 31079 1 0.145808019441069
566101 566101 222278 222278 31079 4 0.833333333333333
595010 595010 231779 231779 31079 1 0.145808019441069
597297 597297 235366 235366 31079 1 0.145808019441069
670504 670504 240082 240082 31079 1 0.146228835300154
740437 740437 260878 260878 31079 1 0.145808019441069
789289 789289 275659 275659 31079 4 0.833333333333333
830952 830952 288390 288390 31079 1 0.208816705336427
832328 832328 288897 288897 31079 1 0.208816705336427
882897 882897 307053 307053 31079 4 0.833333333333333
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 1649.527ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website