contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA280983" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18223334 | 18223334 | PRJNA280983_P_NODE_6075_length_247_cov_1.545455_g5960_i0 | PRJNA280983 | 6075 | 247 | 1.545455 | 3.81727385 | Euglenozoa | 33682 | Euglenozoa | other_Eukaryota | 68.2 | 5.92e-13 | NR | QLA09593.1 | 3039 | g5960 | i0 | 68.6 | 1.26315789473684 | 51 | 15 | 61.9 | 1 | 153 | 1 | 11 | 60 | QLA09593.1 40S small subunit ribosomal protein eS28 [Euglena gracilis] | diamond | 312 | 68.2 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 19497571 | 19497571 | PRJNA280983_P_NODE_11116_length_162_cov_0.902655_g11001_i0 | PRJNA280983 | 11116 | 162 | 0.902655 | 1.4623011 | Perkinsela sp. CCAP 156 | 1935466 | Euglenozoa | other_Eukaryota | 92.4 | 3.82e-20 | NR | KNH06231.1 | 1314962 | g11001 | i0 | 90.4 | 0.962962962962963 | 52 | 5 | 96.3 | 0 | 2 | 157 | 2 | 53 | KNH06231.1 elongation factor 2 [Perkinsela sp. CCAP 1560/4] | diamond | 156 | 92.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Ichthyobodonidae | Perkinsela | Perkinsela sp. CCAP 1560/4 | |||
| 23323708 | 23323708 | PRJNA280983_P_NODE_5519_length_265_cov_3.171296_g5404_i0 | PRJNA280983 | 5519 | 265 | 3.171296 | 8.4039344 | Stygiella incarcerata | 1712417 | Root_unresolved | Root_unresolved | 102 | 1.92e-26 | NR | ANM86223.1 | 1712417 | g5404 | i0 | 70.1 | 1.44905660377358 | 67 | 20 | 75.8 | 0 | 202 | 2 | 1 | 67 | ANM86223.1 40S ribosomal protein S27-1 [Stygiella incarcerata] | diamond | 384 | 102 | 1 | Eukaryota | Discoba | Jakobida | Stygiellidae | Stygiella | Stygiella incarcerata | ||||
| 24597774 | 24597774 | PRJNA280983_P_NODE_5920_length_252_cov_1.083744_g5805_i0 | PRJNA280983 | 5920 | 252 | 1.083744 | 2.73103488 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 76.6 | 6.97e-16 | NR | KAJ9467903.1 | 91374 | g5805 | i0 | 55.1 | 0.821428571428571 | 69 | 31 | 82.1 | 0 | 248 | 42 | 37 | 105 | KAJ9467903.1 60S ribosomal protein L34 [Diplonema papillatum] | diamond | 207 | 76.6 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 30200265 | 30200265 | PRJNA280983_P_NODE_10712_length_164_cov_0.886957_g10597_i0 | PRJNA280983 | 10712 | 164 | 0.886957 | 1.45460948 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 55.8 | 3e-7 | NR | KAJ9462802.1 | 91374 | g10597 | i0 | 47.1 | 0.932926829268293 | 51 | 27 | 93.3 | 0 | 154 | 2 | 322 | 372 | KAJ9462802.1 V-type proton ATPase subunit H [Diplonema papillatum] | diamond | 153 | 55.8 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 32540480 | 32540480 | PRJNA280983_P_NODE_9839_length_167_cov_0.864407_g9724_i0 | PRJNA280983 | 9839 | 167 | 0.864407 | 1.44355969 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 45.8 | 0.0011 | NR | CUG93253.1 | 75058 | g9724 | i0 | 44.2 | 0.934131736526946 | 52 | 29 | 93.4 | 0 | 162 | 7 | 668 | 719 | CUG93253.1 Hypothetical protein, putative [Bodo saltans] | diamond | 156 | 45.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 32855141 | 32855141 | PRJNA280983_P_NODE_7860_length_201_cov_0.953947_g7745_i0 | PRJNA280983 | 7860 | 201 | 0.953947 | 1.91743347 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 108 | 3.15e-28 | NR | KAJ9468330.1 | 91374 | g7745 | i0 | 74.6 | 1 | 67 | 17 | 100 | 0 | 1 | 201 | 2 | 68 | KAJ9468330.1 40S ribosomal protein S23 [Diplonema papillatum] | diamond | 201 | 108 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum |
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);;