contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA986547" and tax_phylum = "Discosea"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7352050 | 7352050 | PRJNA986547_P_NODE_9466_length_248_cov_2.091429_g9384_i0 | PRJNA986547 | 9466 | 248 | 2.091429 | 5.18674392 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 150 | 4.999999999999998e-44 | NR | XP_004349728.1 | 1257118 | g9384 | i0 | 90.8 | 0.919354838709677 | 76 | 7 | 91.9 | 0 | 21 | 248 | 1 | 76 | XP_004349728.1 Rho family, small GTP binding protein Rac3, putative [Acanthamoeba castellanii str. Neff] | diamond | 228 | 150 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27469002 | 27469002 | PRJNA986547_P_NODE_2763_length_310_cov_4.459916_g2681_i0 | PRJNA986547 | 2763 | 310 | 4.459916 | 13.8257396 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 48.1 | 9.87e-4 | NR | XP_004340151.1 | 1257118 | g2681 | i0 | 42.1 | 0.551612903225806 | 57 | 33 | 55.2 | 0 | 171 | 1 | 269 | 325 | XP_004340151.1 metal cation transporter, ZIP subfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 171 | 48.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29552511 | 29552511 | PRJNA986547_P_NODE_6010_length_269_cov_4.056122_g5928_i0 | PRJNA986547 | 6010 | 269 | 4.056122 | 10.91096818 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 149 | 2.8699999999999998e-43 | NR | XP_004344656.1 | 1257118 | g5928 | i0 | 82 | 2.98884758364312 | 89 | 16 | 99.3 | 0 | 2 | 268 | 69 | 157 | XP_004344656.1 Rasrelated protein Rap-1, putative [Acanthamoeba castellanii str. Neff] | diamond | 804 | 149 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29678684 | 29678684 | PRJNA986547_P_NODE_15850_length_210_cov_6.518248_g15768_i0 | PRJNA986547 | 15850 | 210 | 6.518248 | 13.6883208 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 75.9 | 1.15e-15 | NR | 1F2K_A | 5755 | g15768 | i0 | 73.5 | 1.4 | 49 | 13 | 70 | 0 | 3 | 149 | 77 | 125 | 1F2K_A Chain A, PROFILIN II [Acanthamoeba castellanii] | diamond | 294 | 75.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31226960 | 31226960 | PRJNA986547_P_NODE_14675_length_222_cov_8.214765_g14593_i0 | PRJNA986547 | 14675 | 222 | 8.214765 | 18.2367783 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87.8 | 1.24e-18 | NR | XP_004342575.1 | 1257118 | g14593 | i0 | 56 | 1.01351351351351 | 75 | 32 | 100 | 1 | 1 | 222 | 109 | 183 | XP_004342575.1 Synapsin, ATP binding domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 225 | 87.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31796218 | 31796218 | PRJNA986547_P_NODE_15837_length_210_cov_7.350365_g15755_i0 | PRJNA986547 | 15837 | 210 | 7.350365 | 15.4357665 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 60.5 | 1.32e-8 | NR | XP_004335273.1 | 1257118 | g15755 | i0 | 49.2 | 0.842857142857143 | 59 | 29 | 84.3 | 1 | 200 | 24 | 367 | 424 | XP_004335273.1 uncharacterized protein ACA1_147690 [Acanthamoeba castellanii str. Neff] | diamond | 177 | 60.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31891313 | 31891313 | PRJNA986547_P_NODE_5157_length_277_cov_8.328431_g5075_i0 | PRJNA986547 | 5157 | 277 | 8.328431 | 23.06975387 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 115 | 4.14e-28 | NR | XP_004341586.1 | 1257118 | g5075 | i0 | 56 | 1.97111913357401 | 91 | 40 | 98.6 | 0 | 3 | 275 | 288 | 378 | XP_004341586.1 elongation factor 1-gamma family protein [Acanthamoeba castellanii str. Neff] | diamond | 546 | 115 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31891314 | 31891314 | PRJNA986547_P_NODE_5737_length_272_cov_1.316583_g5655_i0 | PRJNA986547 | 5737 | 272 | 1.316583 | 3.58110576 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 80.9 | 1.87e-15 | NR | XP_004367884.1 | 1257118 | g5655 | i0 | 50 | 0.970588235294118 | 88 | 41 | 97.1 | 2 | 5 | 268 | 252 | 336 | XP_004367884.1 PCI domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 264 | 80.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;