contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27509984 | 27509984 | PRJNA1082072_P_NODE_1763_length_271_cov_1.813131_g1756_i0 | PRJNA1082072 | 1763 | 271 | 1.813131 | 4.91358501 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 154 | 1.48e-46 | NR | KAJ9464944.1 | 91374 | g1756 | i0 | 83.3 | 0.863468634686347 | 78 | 13 | 86.3 | 0 | 37 | 270 | 1 | 78 | KAJ9464944.1 hypothetical protein DIPPA_18299 [Diplonema papillatum] | diamond | 234 | 154 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 27731188 | 27731188 | PRJNA1082072_P_NODE_1724_length_274_cov_1.323383_g1717_i0 | PRJNA1082072 | 1724 | 274 | 1.323383 | 3.62606942 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 156 | 8.969999999999999e-43 | NR | KAJ9446580.1 | 91374 | g1717 | i0 | 82.4 | 0.996350364963504 | 91 | 16 | 99.6 | 0 | 273 | 1 | 369 | 459 | KAJ9446580.1 DEAD-box ATP-dependent RNA helicase 5 [Diplonema papillatum] | diamond | 273 | 156 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 29048576 | 29048576 | PRJNA1082072_P_NODE_1768_length_271_cov_1.550505_g1761_i0 | PRJNA1082072 | 1768 | 271 | 1.550505 | 4.20186855 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 3.01e-6 | NR | XP_015654222.1 | 157538 | g1761 | i0 | 37 | 1.4169741697417 | 73 | 46 | 80.8 | 0 | 6 | 224 | 240 | 312 | XP_015654222.1 putative 3'-nucleotidase/nuclease [Leptomonas pyrrhocoris] | diamond | 384 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 29624853 | 29624853 | PRJNA1082072_P_NODE_1650_length_278_cov_1.126829_g1643_i0 | PRJNA1082072 | 1650 | 278 | 1.126829 | 3.13258462 | Trypanosoma cruzi Dm28c | 1416333 | Euglenozoa | other_Eukaryota | 42.4 | 0.0415 | NR | ESS64046.1 | 1416333 | g1643 | i0 | 46.2 | 0.561151079136691 | 52 | 24 | 56.1 | 2 | 110 | 265 | 96 | 143 | ESS64046.1 hypothetical protein TCDM_13764 [Trypanosoma cruzi Dm28c] | diamond | 156 | 42.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 30058780 | 30058780 | PRJNA1082072_P_NODE_2331_length_248_cov_0.880000_g2324_i0 | PRJNA1082072 | 2331 | 248 | 0.88 | 2.1824 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 100 | 1.89e-22 | NR | AAK95376.1 | 5691 | g2324 | i0 | 59.7 | 7.39112903225806 | 77 | 31 | 93.1 | 0 | 16 | 246 | 629 | 705 | AAK95376.1 vacuolar-type proton translocating pyrophosphatase 1 [Trypanosoma brucei] | diamond | 1833 | 100 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 32565548 | 32565548 | PRJNA1082072_P_NODE_2719_length_244_cov_0.900585_g2712_i0 | PRJNA1082072 | 2719 | 244 | 0.900585 | 2.1974274 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 47.8 | 6.67e-4 | NR | KAJ9456274.1 | 91374 | g2712 | i0 | 50 | 0.590163934426229 | 48 | 20 | 54.1 | 2 | 2 | 133 | 369 | 416 | KAJ9456274.1 hypothetical protein DIPPA_12637 [Diplonema papillatum] | diamond | 144 | 47.8 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 32754176 | 32754176 | PRJNA1082072_P_NODE_1960_length_257_cov_1.673913_g1953_i0 | PRJNA1082072 | 1960 | 257 | 1.673913 | 4.30195641 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 145 | 5e-42 | NR | CUG72467.1 | 75058 | g1953 | i0 | 76.5 | 0.992217898832685 | 85 | 20 | 99.2 | 0 | 256 | 2 | 90 | 174 | CUG72467.1 ADP-ribosylation factor, putative [Bodo saltans] | diamond | 255 | 145 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans |
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);;