contig_metadata
13 rows where bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 549057 | 549057 | PRJNA564013_P_NODE_215081_length_292_cov_2.722944_g212230_i0 | PRJNA564013 | 215081 | 292 | 2.722944 | 7.95099648 | Leishmania sp. JPC-2012 | 1217723 | Euglenozoa | other_Eukaryota | 62.1 | 4.5e-5 | NTclustered | gi|399152125|gb|JQ315218.1| | 1217723 | g212230 | i0 | 91.304 | 0.315068493150685 | 46 | 3 | 16 | 1 | 60 | 105 | 181 | 137 | Leishmania sp. JPC-2012 isolate Canine_62 7SL RNA gene, complete sequence | blastn | 92 | 62.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania sp. JPC-2012 | ||
| 1822452 | 1822452 | PRJNA564013_P_NODE_120322_length_382_cov_8.205607_g117478_i0 | PRJNA564013 | 120322 | 382 | 8.205607 | 31.34541874 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 54.7 | 0.01 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g117478 | i0 | 100 | 0.0759162303664921 | 29 | 0 | 8 | 0 | 1 | 29 | 8 | 36 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 3101477 | 3101477 | PRJNA564013_P_NODE_296983_length_227_cov_3.837349_g294131_i0 | PRJNA564013 | 296983 | 227 | 3.837349 | 8.71078223 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g294131 | i0 | 100 | 0.123348017621145 | 28 | 0 | 12 | 0 | 1 | 28 | 9 | 36 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 3103640 | 3103640 | PRJNA564013_P_NODE_72843_length_473_cov_29.837379_g70029_i0 | PRJNA564013 | 72843 | 473 | 29.837379 | 141.13080267 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.046 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g70029 | i0 | 100 | 0.0591966173361522 | 28 | 0 | 6 | 0 | 446 | 473 | 35 | 8 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 4377232 | 4377232 | PRJNA564013_P_NODE_253164_length_258_cov_53.644670_g250312_i0 | PRJNA564013 | 253164 | 258 | 53.64467 | 138.4032486 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g250312 | i0 | 100 | 0.108527131782946 | 28 | 0 | 11 | 0 | 1 | 28 | 8 | 35 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 4380259 | 4380259 | PRJNA564013_P_NODE_76904_length_461_cov_18.292500_g74083_i0 | PRJNA564013 | 76904 | 461 | 18.2925 | 84.328425 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.045 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g74083 | i0 | 96.875 | 0.06941431670282 | 32 | 0 | 7 | 1 | 431 | 461 | 39 | 8 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 32 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 5651037 | 5651037 | PRJNA564013_P_NODE_136185_length_365_cov_2.217105_g133337_i0 | PRJNA564013 | 136185 | 365 | 2.217105 | 8.09243325 | Leptomonas pyrrhocoris | 157538 | Euglenozoa | other_Eukaryota | 250 | 1.14e-61 | NTclustered | gi|1002433688|ref|XR_001548756.1| | 157538 | g133337 | i0 | 80.168 | 83.6082191780822 | 358 | 51 | 94 | 15 | 1 | 343 | 385 | 33 | Leptomonas pyrrhocoris 28S ribosomal RNA (LSU-beta) rRNA | blastn | 30517 | 250 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 6925950 | 6925950 | PRJNA564013_P_NODE_162226_length_340_cov_13.616487_g159376_i0 | PRJNA564013 | 162226 | 340 | 13.616487 | 46.2960558 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g159376 | i0 | 100 | 0.0823529411764706 | 28 | 0 | 8 | 0 | 1 | 28 | 8 | 35 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 15851462 | 15851462 | PRJNA564013_P_NODE_193613_length_312_cov_4.374502_g190762_i0 | PRJNA564013 | 193613 | 312 | 4.374502 | 13.64844624 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g190762 | i0 | 100 | 0.0897435897435897 | 28 | 0 | 9 | 0 | 285 | 312 | 32 | 5 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 17124140 | 17124140 | PRJNA564013_P_NODE_102414_length_406_cov_6.185507_g99579_i0 | PRJNA564013 | 102414 | 406 | 6.185507 | 25.11315842 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g99579 | i0 | 100 | 0.0738916256157636 | 30 | 0 | 7 | 0 | 377 | 406 | 33 | 4 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 30 | 56.5 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 20951844 | 20951844 | PRJNA564013_P_NODE_250817_length_260_cov_15.366834_g247965_i0 | PRJNA564013 | 250817 | 260 | 15.366834 | 39.9537684 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g247965 | i0 | 100 | 0.107692307692308 | 28 | 0 | 11 | 0 | 233 | 260 | 35 | 8 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 24776471 | 24776471 | PRJNA564013_P_NODE_279580_length_239_cov_2.005618_g276728_i0 | PRJNA564013 | 279580 | 239 | 2.005618 | 4.79342702 | Dinema validum | 2704078 | Euglenozoa | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1803019085|gb|MT007857.1| | 2704078 | g276728 | i0 | 100 | 0.121338912133891 | 29 | 0 | 12 | 0 | 209 | 237 | 36 | 8 | Dinema validum isolate AB2_2 small subunit ribosomal RNA gene, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Heteronematales | Peranemataceae | Dinema | Dinema validum | ||
| 32324259 | 32324259 | PRJNA564013_P_NODE_356439_length_194_cov_2.932331_g353587_i0 | PRJNA564013 | 356439 | 194 | 2.932331 | 5.68872214 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 43.1 | 0.0146 | NR | XP_028878919.1 | 67003 | g353587 | i0 | 44.2 | 0.664948453608247 | 43 | 24 | 66.5 | 0 | 64 | 192 | 1229 | 1271 | XP_028878919.1 SLACS reverse transcriptase, putative [Trypanosoma theileri] | diamond | 129 | 43.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri |
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);;