PubChem service doesn’t support looking up compounds given an assay ID?

Mathematica’s PubChem Service Connection has many requests that return the properties of a compound (or substance). It also provides requests that return all the assays for which a given compound (or substance) has been tested.

But the PubChem Service Connection does not appear to include requests that return all the compound IDs (CIDs) associated with a given assay ID (AID). This type of functionality is supported by the PubChem PUG-REST, e.g., :

https://pubchem.ncbi.nlm.nih.gov/rest/pug/assay/aid/1207599/cids/txt

Looks up all compounds (CIDs) that have been measured with assay AID1207599.

The “CompoundAID” request in Mathematica returns a list of AssayIDs given a CompoundID (or other CID-equivalent specifier) as input. Similarly, “CompoundAssaySummary” returns a summary given a CompoundID (or equivalent) specifier. But returning the AIDs for a specified CID is not the same as returning the CIDs for a given AID. Is there an undocumented feature for this?

No: It is not possible to iterate over all CompoundIDs; PubChem contains >96 million compounds.

Yes: I already know I can do it “manually” by

URLExecute[  "https://pubchem.ncbi.nlm.nih.gov/rest/pug/assay/aid/1207599/cids/txt",  {}, "CSV"] 

Rather: This is a question about the limits and current state of the PubChem Service Connection implementation in Mathematica 12.

Does HTTP not support providing a checksum in a form of header for downloaded content?

Is there a way to tell a browser downloading a file or page that the content it is downloaded should match this checksum made with this formula (e.g. sha-1 or md5)?

I think it would be great to verify file integrity without having to manually verify the file’s integrity after download.

If it is possible, how would I implement this in my own server? If not, what is the best alternative?

[Hostpoco.com]*Best SSD Linux Reseller Hosting @ $5/month- 100% Secured -24×7 Support

Hostpoco.com provides you all types of web hosting solutions. We offer everything that you need to build, host and manage your website with 24*7 technical support and 99.99% Uptime Guarantee. There are no hidden fees and a 30-day moneyback guarantee. Select the world’s best web hosting service for your website.

Get High Config & Best Featured SSD Linux Reseller Hosting only @ $5/month With Hostpoco. Just Sign up and be online within 2 minutes with our instant & free setup!

Below is the list of SSD Linux Reseller Hosting plan:

*Startup SSD Reseller: @ Just $5/month
~22GB Web Space
~Unlimited Bandwidth
~Free Let’s Encrypt SSL
~10 CPanel Accounts
~Unlimited FTP Accounts

*Pro SSD Reseller: @ Just $8/month
~55GB Web Space
~Unlimited Bandwidth
~Free Let’s Encrypt SSL
~25 CPanel Accounts
~Unlimited FTP Accounts

*Premium SSD Reseller: @ Just $12/month
~75GB Web Space
~Unlimited Bandwidth
~Free Let’s Encrypt SSL
~40 CPanel Accounts
~Unlimited FTP Accounts

*Elite SSD Reseller: @ Just $14 /month
~120GB Web Space
~Unlimited Bandwidth
~Free Let’s Encrypt SSL
~60 CPanel Accounts
~Unlimited FTP Accounts

#Hostpoco.com : Linux Reseller | SSD Linux Reseller | Windows Reseller | WordPress Hosting | VPS Hosting.

For more Plan details:https://hostpoco.com/best-ssd-linux-reseller-web-hosting.php

Thank you.

Hostpoco.com – Best Cheapest hosting + great support

Hostpoco provide very Simple, Easy, Trusted, Reliable Web Hosting Service and now Hostpoco deals with cheap high resourced and hugely demanded web hosting services starting from $0.5 Per month. All our hosting plans comes with cpanel as control panel included with some smart features like no limit space, unmetered bandwidth, free auto ssl, free site builder, free migration service, free dedicated IP and much more.
Hostpoco.com is a Cheap & BUDGET, yet FAST and RELIABLE web hosting provider. We have staffs available TRUELY 24/7 to provide nearly instant support to all of our customers when they need. You can be certain that your site almost have zero down time as long as you have an active service with us. We own our web server, which is an advantage for our customers since we immediately react if there is anything unusual with the server, or if any customer need to install custom software. 

Our plan start from:

 *Shared Hosting $0.5/month for Beginner
 *Reseller Startup Hosting start from $3/month. 
 *VPS Hosting $14.99/month.
 *Dedicated Servers as low as $80/month.
 *Managed WordPress Hosting from $0.5/month.
 
Hostpoco.com : Budget Hosting Provider | Cheap Hosting Provider | Cheap cPanel Hosting | $1 Unlimited hosting | Fast SSD Hosting | Money back Hosting | Best Seller hosting | ideal free hosting | free web hosting 

https://hostpoco.com/

Thank you.

Support for signed SSH certificates – Windows 10 OpenSSH to Linux

“OpenSSH for Windows” version OpenSSH_for_Windows_8.0p1, LibreSSL 2.6.5 Client OperatingSystem Windows 10 Enterprise

Does OpenSSH for Windows support signed certs?

I feel like it does, as ssh-keygen picks up the certificate no problem. However, it doesn’t want to connect. The same steps seem to work fine from linux.

 Directory of C:\hi 11/04/2019  01:18 PM             2,013 GregDFO-cert.pub 04/16/2019  09:07 AM             1,854 GregDFO-private.key 04/16/2019  09:31 AM               389 GregDFO-public.key  C:\hi>ssh-keygen -Lf GregDFO-cert.pub GregDFO-cert.pub:         Type: ssh-rsa-cert-v01@openssh.com user certificate         Public key: RSA-CERT SHA256:Ccox9NCf/HBjzFxRE76XsnTT9k0vbmRB4/j5qX95WkQ         Signing CA: RSA SHA256:3axo+wPqiszHOTKy94Tk2gj4S6Rb6uGWKcB4s059bvg (using ssh-rsa)         Key ID: "root"         Serial: 17890926214909873034         Valid: from 2019-11-01T08:52:18 to 2019-11-13T19:52:48         Principals:                 cormierg         Critical Options: (none)         Extensions:                 permit-pty 

However, when trying to use it, ssh spits out invalid format

C:\hi>ssh -i GregDFO-private.key -i GregDFO-cert.pub cormiergr@1.2.3.4  Enter passphrase for key 'GregDFO-private.key': ***** Load key "GregDFO-cert.pub": invalid format 

A few extra verbose tidbits:

Enter passphrase for key 'GregDFO-private.key': debug2: we sent a publickey packet, wait for reply debug1: Authentications that can continue: publickey,keyboard-interactive debug1: Offering public key: GregDFO-cert.pub RSA-CERT  SHA256:Ccox9NCf/HBjzFxRE76XsnTT9k0vbmRB4/j5qX95WkQ explicit debug2: we sent a publickey packet, wait for reply debug1: Server accepts key: GregDFO-cert.pub RSA-CERT  SHA256:Ccox9NCf/HBjzFxRE76XsnTT9k0vbmRB4/j5qX95WkQ explicit debug1: sign_and_send_pubkey: no separate private key for certificate "GregDFO-cert.pub" Load key "GregDFO-cert.pub": invalid format debug2: we did not send a packet, disable method debug1: Next authentication method: keyboard-interactive 

Does Apple still monitor or track after having a customer support screen sharing service with ara.apple.com?

Is having screen sharing service with ara.apple.com safe?

I had screensharing service with ara.apple.com(https://ara-prn.apple.com/) which is official apple website for apple products support. And they wanted me to install an app after entering session key and they said the app will self-destruct once support session ended.

Would there be a possibility that Apple can still track and monitor that computer even after the support session ended and even if they claim that installment of the app for screen sharing self-destruct?

Computer does not support booting to a NVMe SSD

I have a Dell Optiplex 3040 with a HDD running Ubuntu 19.4. I installed a NVMe SSD and Ubuntu sees it and I can use it. I would like to use the SSD as my main drive, but the computer does not support booting to a NVMe SSD. On a Raspberry Pi there is a process to boot from one drive but run the OS from another drive.

https://www.tomshardware.com/news/boot-raspberry-pi-from-usb,39782.html

I tried that with Ubuntu, but it is still running from the HDD. How do I get Ubuntu to boot from the HDD and run from the NVMe SSD?

Thanks in advance, Kevin

Microsoft Surface Laptop – will keyboard support be added to Ubuntu?

My apologies for my lack of knowledge on how hardware support gets added to distros and the kernal.

I have a first gen MS Surface laptop (actual ‘Laptop’ not pro or go, etc.). When I run the Ubuntu live everything works, as far as I can tell, except the built in keyboard. Since this laptop is several years old I was wondering if this will ever work? I’ve installed various linux systems on laptops and have had things like cameras not work but I’ve never had something as basic as the keyboard not work.

I’ve seen the jakeday kernal work but because I lack this level of system build knowledge I’m worried about things like security and also what that means for future upgrades. Again… this is more on me than jakeday’s work.

So long question shortened… for my Surface Laptop keyboard to work.. Be Patient or stay with windows/buy new laptop?

Thank you