home / zeropm-v0-0-4

consensus_index

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

26 rows where inchi_id = 3797

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
50543 50543 15692 15692 3797 2 0.268287113814815
123398 123398 42859 42859 3797 1 0.267474429844619
185133 185133 66022 66022 3797 3 0.215876885887556
185143 185143 66023 66023 3797 1 0.245346108648865
309608 309608 104582 104582 3797 1 0.267474429844619
463602 463602 166558 166558 3797 4 0.302425013144762
466550 466550 168500 168500 3797 2 0.268287113814815
527737 527737 209760 209760 3797 3 0.210520968514402
582372 582372 227723 227723 3797 1 0.267474429844619
681804 681804 243504 243504 3797 3 0.27027027027027
748064 748064 263033 263033 3797 2 0.111695184183908
748075 748075 263034 263034 3797 4 0.302425013144762
762170 762170 267320 267320 3797 3 0.210520968514402
762179 762179 267321 267321 3797 1 0.26551766439171
946215 946215 339011 339011 3797 2 0.204201890187135
959817 959817 345387 345387 3797 1 0.26551766439171
1027277 1027277 365006 365006 3797 2 0.268287113814815
1027284 1027284 365007 365007 3797 2 0.268287113814815
1245183 1245183 411095 411095 3797 2 0.268287113814815
1245190 1245190 411096 411096 3797 2 0.268287113814815
1474807 1474807 456715 456715 3797 2 0.268287113814815
1474814 1474814 456716 456716 3797 2 0.268287113814815
1594051 1594051 481145 481145 3797 2 0.268287113814815
1656480 1656480 501927 501927 3797 4 0.302425013144762
1660731 1660731 503364 503364 3797 2 0.268287113814815
1745306 1745306 534580 534580 3797 1 0.267474429844619
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 2429.838ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website