contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9125742 | 9125742 | PRJNA1092581_P_NODE_88448_length_272_cov_3.773869_g87915_i0 | PRJNA1092581 | 88448 | 272 | 3.773869 | 10.26492368 | Zelonia costaricensis | 372075 | Euglenozoa | other_Eukaryota | 368 | 2.18e-97 | NTclustered | gi|1002342154|gb|KT944304.1| | 372075 | g87915 | i0 | 92.941 | 123.213235294118 | 255 | 14 | 92 | 3 | 22 | 272 | 1471 | 1725 | Zelonia costaricensis strain 15EC 28S ribosomal RNA gene, partial sequence | blastn | 33514 | 368 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Zelonia | Zelonia costaricensis | ||
| 16772546 | 16772546 | PRJNA1092581_P_NODE_100634_length_252_cov_1.899441_g100101_i0 | PRJNA1092581 | 100634 | 252 | 1.899441 | 4.78659132 | Trypanosoma melophagium | 715481 | Euglenozoa | other_Eukaryota | 145 | 3.66e-30 | NTclustered | gi|2787706973|ref|XM_067331715.1| | 715481 | g100101 | i0 | 100 | 36.5079365079365 | 78 | 0 | 31 | 0 | 173 | 250 | 119 | 42 | Trypanosoma melophagium uncharacterized protein (LSM04_008922), partial mRNA | blastn | 9200 | 145 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma melophagium | ||
| 16775177 | 16775177 | PRJNA1092581_P_NODE_89234_length_271_cov_1.641414_g88701_i0 | PRJNA1092581 | 89234 | 271 | 1.641414 | 4.44823194 | Leishmania infantum | 5671 | Euglenozoa | other_Eukaryota | 158 | 5.12e-34 | NTclustered | gi|146093607|ref|XM_001466878.1| | 435258 | g88701 | i0 | 88.55 | 23.9963099630996 | 131 | 13 | 48 | 2 | 138 | 267 | 130 | 1 | Leishmania infantum JPCM5 putative 40S ribosomal protein S30 partial mRNA | blastn | 6503 | 158 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania infantum | ||
| 20144144 | 20144144 | PRJNA1092581_P_NODE_106676_length_244_cov_3.596491_g106143_i0 | PRJNA1092581 | 106676 | 244 | 3.596491 | 8.77543804 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 239 | 1.57e-58 | NTclustered | gi|2026667531|dbj|LC618031.1| | 67003 | g106143 | i0 | 98.519 | 70.483606557377 | 135 | 2 | 55 | 0 | 22 | 156 | 5149 | 5283 | Trypanosoma theileri OSK-16 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, partial and complete sequence | blastn | 17198 | 239 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 21419747 | 21419747 | PRJNA1092581_P_NODE_103217_length_248_cov_7.308571_g102684_i0 | PRJNA1092581 | 103217 | 248 | 7.308571 | 18.12525608 | Parabodo | 140243 | Euglenozoa | other_Eukaryota | 394 | 3.24e-105 | NTclustered | gi|45739057|gb|AY490215.1| | 351713 | g102684 | i0 | 100 | 85.8306451612903 | 213 | 0 | 86 | 0 | 22 | 234 | 1524 | 1736 | Bodo caudatus 18S ribosomal RNA gene, partial sequence | blastn | 21286 | 394 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Parabodo | Parabodo caudatus | |||
| 21419901 | 21419901 | PRJNA1092581_P_NODE_120057_length_222_cov_4.228188_g119524_i0 | PRJNA1092581 | 120057 | 222 | 4.228188 | 9.38657736 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 82.4 | 2.51e-11 | NTclustered | gi|2785806723|ref|XM_067204375.1| | 2249476 | g119524 | i0 | 85.057 | 15.3873873873874 | 87 | 5 | 37 | 8 | 120 | 202 | 653 | 571 | Leishmania orientalis uncharacterized protein (LSCM4_02343), partial mRNA | blastn | 3416 | 82.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania orientalis |
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);;