home / zeropm-v0-0-4

consensus_index

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

29 rows where inventory_id = 54003

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
150626 150626 54003 54003 3515 12 0.24628247207616
150627 150627 54003 54003 17497 1 0.12314123603808
150628 150628 54003 54003 33583 1 0.03078530900952
150629 150629 54003 54003 35243 1 0.0351832102965943
150630 150630 54003 54003 51185 1 0.016418831471744
150631 150631 54003 54003 55862 2 0.100544398196306
150632 150632 54003 54003 63839 1 0.012314123603808
150633 150633 54003 54003 68015 1 0.0117277367655314
150634 150634 54003 54003 81686 1 0.01026176966984
150635 150635 54003 54003 89238 1 0.00912157303985778
150636 150636 54003 54003 123672 1 0.06157061801904
150637 150637 54003 54003 138713 1 0.0273647191195733
150638 150638 54003 54003 139788 1 0.0223893156432873
150639 150639 54003 54003 139807 1 0.0175916051482971
150640 150640 54003 54003 149107 1 0.024628247207616
150641 150641 54003 54003 167393 1 0.01894480554432
150642 150642 54003 54003 167437 1 0.02052353933968
150643 150643 54003 54003 167549 1 0.0111946578216436
150644 150644 54003 54003 171165 1 0.0129622353724295
150645 150645 54003 54003 171594 1 0.0107079335685287
150646 150646 54003 54003 171796 1 0.0144872042397741
150647 150647 54003 54003 171797 1 0.01539265450476
150648 150648 54003 54003 171936 1 0.0136823595597867
150649 150649 54003 54003 172056 1 0.049256494415232
150650 150650 54003 54003 178265 1 0.04104707867936
150651 150651 54003 54003 191532 1 0.00947240277216
150652 150652 54003 54003 231459 1 0.0098512988830464
150653 150653 54003 54003 340654 1 0.00879580257414857
150654 150654 54003 54003 340655 1 0.00849249903710897
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 1526.861ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website