contig_metadata
16 rows where bioproject = "PRJNA827593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4649604 | 4649604 | PRJNA827593_P_NODE_3904_length_1167_cov_2.050274_g3689_i0 | PRJNA827593 | 3904 | 1167 | 2.050274 | 23.92669758 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 269 | 1.45e-76 | NR | XP_002672840.1 | 5762 | g3689 | i0 | 57.6 | 1.22622107969152 | 238 | 83 | 56.6 | 3 | 662 | 3 | 164 | 401 | XP_002672840.1 uncharacterized protein NAEGRDRAFT_59151 [Naegleria gruberi] | diamond | 1431 | 269 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 8474665 | 8474665 | PRJNA827593_P_NODE_7947_length_792_cov_3.977747_g7670_i0 | PRJNA827593 | 7947 | 792 | 3.977747 | 31.50375624 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 54.7 | 0.022 | NTclustered | gi|1624757291|ref|XM_029029574.1| | 67003 | g7670 | i0 | 92.105 | 0.047979797979798 | 38 | 3 | 5 | 0 | 706 | 743 | 1146 | 1183 | Trypanosoma theileri glutaminyl cyclase (TM35_000381600), partial mRNA | blastn | 38 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 9748991 | 9748991 | PRJNA827593_P_NODE_24508_length_424_cov_2.552707_g24209_i0 | PRJNA827593 | 24508 | 424 | 2.552707 | 10.82347768 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 119 | 5.58e-28 | NR | NP_066511.1 | 5762 | g24209 | i0 | 44.4 | 1.0188679245283 | 144 | 54 | 99.1 | 2 | 1 | 420 | 132 | 253 | NP_066511.1 NADH dehydrogenase subunit 5 [Naegleria gruberi] | diamond | 432 | 119 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 12707825 | 12707825 | PRJNA827593_P_NODE_17330_length_515_cov_4.049774_g17032_i0 | PRJNA827593 | 17330 | 515 | 4.049774 | 20.8563361 | Moramonas marocensis | 1805496 | Root_unresolved | Root_unresolved | 80.9 | 8.81e-15 | NR | AML60594.1 | 1805496 | g17032 | i0 | 47.6 | 2.38834951456311 | 82 | 43 | 47.8 | 0 | 482 | 237 | 134 | 215 | AML60594.1 ribosomal protein L2 [Moramonas marocensis] | diamond | 1230 | 80.9 | 1 | Eukaryota | Discoba | Jakobida | Moramonas | Moramonas marocensis | |||||
| 14849096 | 14849096 | PRJNA827593_P_NODE_31072_length_370_cov_4.895623_g30773_i0 | PRJNA827593 | 31072 | 370 | 4.895623 | 18.1138051 | Stachyamoeba lipophora | 463046 | Heterolobosea | other_Eukaryota | 140 | 8.58e-36 | NR | YP_009118152.1 | 463046 | g30773 | i0 | 55.7 | 0.989189189189189 | 122 | 54 | 98.9 | 0 | 4 | 369 | 23 | 144 | YP_009118152.1 NADH dehydrogenase subunit 5 [Stachyamoeba lipophora] | diamond | 366 | 140 | 1 | Eukaryota | Discoba | Heterolobosea | Gruberellidae | Stachyamoeba | Stachyamoeba lipophora | ||||
| 22498358 | 22498358 | PRJNA827593_P_NODE_61178_length_251_cov_0.865169_g60879_i0 | PRJNA827593 | 61178 | 251 | 0.865169 | 2.17157419 | Stachyamoeba lipophora | 463046 | Heterolobosea | other_Eukaryota | 124 | 1.02e-31 | NR | YP_009118164.1 | 463046 | g60879 | i0 | 66.3 | 1.94820717131474 | 83 | 28 | 99.2 | 0 | 3 | 251 | 177 | 259 | YP_009118164.1 apocytochrome b [Stachyamoeba lipophora] | diamond | 489 | 124 | 1 | Eukaryota | Discoba | Heterolobosea | Gruberellidae | Stachyamoeba | Stachyamoeba lipophora | ||||
| 28539096 | 28539096 | PRJNA827593_P_NODE_66787_length_243_cov_0.905882_g66488_i0 | PRJNA827593 | 66787 | 243 | 0.905882 | 2.20129326 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 60.5 | 2.09e-8 | NR | CUG55385.1 | 75058 | g66488 | i0 | 41.6 | 0.950617283950617 | 77 | 40 | 88.9 | 2 | 241 | 26 | 617 | 693 | CUG55385.1 ion transporter, putative [Bodo saltans] | diamond | 231 | 60.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29012743 | 29012743 | PRJNA827593_P_NODE_17568_length_512_cov_1.920273_g17270_i0 | PRJNA827593 | 17568 | 512 | 1.920273 | 9.83179776 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 84.3 | 6.42e-16 | NR | KAL0491076.1 | 1008807 | g17270 | i0 | 71.4 | 0.287109375 | 49 | 14 | 28.7 | 0 | 198 | 52 | 262 | 310 | KAL0491076.1 ubiquitin-like 1-activating enzyme E1 [Acrasis kona] | diamond | 147 | 84.3 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29264885 | 29264885 | PRJNA827593_P_NODE_48709_length_287_cov_1.757009_g48410_i0 | PRJNA827593 | 48709 | 287 | 1.757009 | 5.04261583 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 56.2 | 1.18e-6 | NR | XP_002679547.1 | 5762 | g48410 | i0 | 61.1 | 1.31707317073171 | 36 | 14 | 37.6 | 0 | 283 | 176 | 203 | 238 | XP_002679547.1 uncharacterized protein NAEGRDRAFT_57455 [Naegleria gruberi] | diamond | 378 | 56.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30528421 | 30528421 | PRJNA827593_P_NODE_66913_length_242_cov_2.047337_g66614_i0 | PRJNA827593 | 66913 | 242 | 2.047337 | 4.95455554 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 76.3 | 5.45e-14 | NR | YP_007890052.1 | 5763 | g66614 | i0 | 57 | 0.979338842975207 | 79 | 33 | 97.9 | 1 | 3 | 239 | 336 | 413 | YP_007890052.1 NADH dehydrogenase subunit 4 [Naegleria fowleri] | diamond | 237 | 76.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31159960 | 31159960 | PRJNA827593_P_NODE_39155_length_325_cov_1.126984_g38856_i0 | PRJNA827593 | 39155 | 325 | 1.126984 | 3.662698 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 77 | 8.82e-14 | NR | CUE71938.1 | 75058 | g38856 | i0 | 42.7 | 0.886153846153846 | 96 | 52 | 88.6 | 3 | 313 | 26 | 440 | 532 | CUE71938.1 cysteine peptidase, putative [Bodo saltans] | diamond | 288 | 77 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31476764 | 31476764 | PRJNA827593_P_NODE_46176_length_296_cov_1.986547_g45877_i0 | PRJNA827593 | 46176 | 296 | 1.986547 | 5.88017912 | Trypanosoma equiperdum | 5694 | Euglenozoa | other_Eukaryota | 48.1 | 8.97e-4 | NR | XP_067081428.1 | 5694 | g45877 | i0 | 37 | 0.932432432432432 | 92 | 54 | 91.2 | 2 | 5 | 274 | 554 | 643 | XP_067081428.1 translation elongation factor EF-2, putative [Trypanosoma equiperdum] | diamond | 276 | 48.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma equiperdum | ||
| 31729619 | 31729619 | PRJNA827593_P_NODE_7637_length_808_cov_2.778231_g7364_i0 | PRJNA827593 | 7637 | 808 | 2.778231 | 22.44810648 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 82.8 | 9.93e-14 | NR | CAG4708788.1 | 5763 | g7364 | i0 | 23.8 | 0.998762376237624 | 269 | 187 | 98.8 | 5 | 3 | 800 | 1097 | 1350 | CAG4708788.1 unnamed protein product [Naegleria fowleri] | diamond | 807 | 82.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31824361 | 31824361 | PRJNA827593_P_NODE_3937_length_1160_cov_2.683533_g3722_i0 | PRJNA827593 | 3937 | 1160 | 2.683533 | 31.1289828 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 207 | 5.0299999999999993e-57 | NR | KAL0491389.1 | 1008807 | g3722 | i0 | 39.9 | 1.60086206896552 | 308 | 173 | 78.1 | 5 | 12 | 917 | 28 | 329 | KAL0491389.1 NHL repeat-containing protein, partial [Acrasis kona] | diamond | 1857 | 207 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32552591 | 32552591 | PRJNA827593_P_NODE_61659_length_250_cov_1.610169_g61360_i0 | PRJNA827593 | 61659 | 250 | 1.610169 | 4.0254225 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 102 | 5.47e-23 | NR | KAJ9456071.1 | 91374 | g61360 | i0 | 71.2 | 2.124 | 59 | 17 | 70.8 | 0 | 54 | 230 | 394 | 452 | KAJ9456071.1 Beta-mannosidase A [Diplonema papillatum] | diamond | 531 | 102 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 32804109 | 32804109 | PRJNA827593_P_NODE_30460_length_375_cov_1.288079_g30161_i0 | PRJNA827593 | 30460 | 375 | 1.288079 | 4.83029625 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 90.1 | 4.26e-18 | NR | CUG92032.1 | 75058 | g30161 | i0 | 49.5 | 0.792 | 99 | 48 | 79.2 | 2 | 75 | 371 | 206 | 302 | CUG92032.1 Hypothetical protein, putative [Bodo saltans] | diamond | 297 | 90.1 | 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);;