consensus_index

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

19 rows where inventory_id = 399523

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1199250 1199250 399523 399523 3191 2 0.0475925356504377
1199251 1199251 399523 399523 3193 9 0.241352440109915
1199252 1199252 399523 399523 8236 1 0.130337526723068
1199253 1199253 399523 399523 9870 1 0.0236977321314669
1199254 1199254 399523 399523 19291 1 0.018619646674724
1199255 1199255 399523 399523 42021 1 0.0217229211205113
1199256 1199256 399523 399523 43845 1 0.0651687633615339
1199257 1199257 399523 399523 83480 1 0.017378336896409
1199258 1199258 399523 399523 90718 1 0.0144819474136742
1199259 1199259 399523 399523 133647 1 0.0521350106892271
1199260 1199260 399523 399523 147812 1 0.0200519271881643
1199261 1199261 399523 399523 157575 2 0.0291443569771975
1199262 1199262 399523 399523 168038 1 0.0434458422410226
1199263 1199263 399523 399523 169925 1 0.0651687633615339
1199264 1199264 399523 399523 170848 1 0.0868916844820452
1199265 1199265 399523 399523 173008 1 0.0153338266733021
1199266 1199266 399523 399523 204213 1 0.0289638948273484
1199267 1199267 399523 399523 204830 1 0.0372392933494479
1199268 1199268 399523 399523 205252 1 0.0325843816807669 
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)
);