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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
48943 48943 15043 15043 150114 4 0.350440262760282
49185 49185 15116 15116 150114 1 0.104347826086957
49733 49733 15385 15385 150114 3 0.415239576400731
114301 114301 39884 39884 150114 1 0.103896103896104
114309 114309 39887 39887 150114 4 0.350440262760282
160331 160331 57642 57642 150114 1 0.113208611848758
166570 166570 59619 59619 150114 2 0.0606609512601006
166579 166579 59620 59620 150114 4 0.350440262760282
180366 180366 64438 64438 150114 1 0.0448454961251607
214817 214817 74666 74666 150114 1 0.144198257010256
303569 303569 102677 102677 150114 4 0.350440262760282
425584 425584 153585 153585 150114 1 0.144198257010256
463473 463473 166521 166521 150114 4 0.350440262760282
464029 464029 166726 166726 150114 1 0.103896103896104
465352 465352 168004 168004 150114 1 0.144939525733252
527307 527307 209665 209665 150114 2 0.0606609512601006
585469 585469 228664 228664 150114 1 0.144939525733252
586702 586702 229089 229089 150114 3 0.415239576400731
586704 586704 229090 229090 150114 2 0.408628001184222
588891 588891 229928 229928 150114 1 0.103896103896104
591490 591490 230738 230738 150114 4 0.350440262760282
676767 676767 241852 241852 150114 3 0.196603718632154
786772 786772 274834 274834 150114 2 0.339622641509434
805540 805540 280669 280669 150114 1 0.0448609435425325
928652 928652 330342 330342 150114 1 0.103896103896104
946634 946634 339244 339244 150114 1 0.226415094339623
959228 959228 345136 345136 150114 2 0.343849596088132
961957 961957 346290 346290 150114 2 0.408628001184222
961966 961966 346297 346297 150114 2 0.408628001184222
1656417 1656417 501913 501913 150114 3 0.283822040343498
1657106 1657106 502136 502136 150114 1 0.103896103896104
1659289 1659289 502855 502855 150114 4 0.42052772921983
1659291 1659291 502856 502856 150114 4 0.42052772921983
1743609 1743609 534010 534010 150114 3 0.195678967134872
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 862.103ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website