contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 981160 | 981160 | PRJDB3785_S_NODE_21421_length_172_cov_3.723577_g21268_i0 | PRJDB3785 | 21421 | 172 | 3.723577 | 6.40455244 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 189 | 1.0499999999999996e-43 | NTclustered | gi|8039172|emb|AL356456.1| | 5664 | g21268 | i0 | 88.462 | 317.162790697674 | 156 | 18 | 91 | 0 | 17 | 172 | 85284 | 85129 | Leishmania major Friedlin cosmid clones L9127,L3286,L3175,L8286,L7480, incomplete shotgun, assembled reads, with VERY preliminary annotation, complete sequence | blastn | 54552 | 189 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania major | ||
| 4809101 | 4809101 | PRJDB3785_S_NODE_21264_length_173_cov_1.233871_g21111_i0 | PRJDB3785 | 21264 | 173 | 1.233871 | 2.13459683 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 137 | 3.8999999999999995e-28 | NTclustered | gi|2593252916|emb|OY748428.1| | 5660 | g21111 | i0 | 85.496 | 27.3526011560694 | 131 | 19 | 76 | 0 | 3 | 133 | 1514952 | 1515082 | Leishmania braziliensis isolate MHOM/BR/75/M2904 genome assembly, chromosome: 34 | blastn | 4732 | 137 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania braziliensis | ||
| 11486690 | 11486690 | PRJDB3785_S_NODE_16890_length_191_cov_1.211268_g16737_i0 | PRJDB3785 | 16890 | 191 | 1.211268 | 2.31352188 | Rhynchomonas nasuta | 127150 | Euglenozoa | other_Eukaryota | 211 | 2.56e-50 | NTclustered | gi|226347420|gb|FJ807250.1| | 127150 | g16737 | i0 | 87.432 | 91.9162303664921 | 183 | 23 | 96 | 0 | 5 | 187 | 1167 | 985 | Rhynchomonas nasuta strain ATCC 50292 elongation factor 1 alpha mRNA, partial cds | blastn | 17556 | 211 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Neobodonida | Rhynchomonadidae | Rhynchomonas | Rhynchomonas nasuta | ||
| 15311044 | 15311044 | PRJDB3785_S_NODE_5913_length_310_cov_2.157088_g5760_i0 | PRJDB3785 | 5913 | 310 | 2.157088 | 6.6869728 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 398 | 3.2299999999999996e-106 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g5760 | i0 | 89.873 | 134.654838709677 | 316 | 23 | 99 | 7 | 1 | 308 | 4802 | 4488 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 41743 | 398 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 17860605 | 17860605 | PRJDB3785_S_NODE_17275_length_189_cov_1.428571_g17122_i0 | PRJDB3785 | 17275 | 189 | 1.428571 | 2.69999919 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|1624749507|ref|XM_029025682.1| | 67003 | g17122 | i0 | 92.105 | 0.201058201058201 | 38 | 2 | 20 | 1 | 1 | 37 | 2568 | 2605 | Trypanosoma theileri uncharacterized protein (TM35_000142370), partial mRNA | blastn | 38 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 19134384 | 19134384 | PRJDB3785_S_NODE_24496_length_165_cov_0.879310_g24343_i0 | PRJDB3785 | 24496 | 165 | 0.87931 | 1.4508615 | Trypanosoma conorhini | 83891 | Euglenozoa | other_Eukaryota | 267 | 4.53e-67 | NTclustered | gi|1673141461|ref|XR_003828664.1| | 83891 | g24343 | i0 | 95.758 | 109.860606060606 | 165 | 7 | 100 | 0 | 1 | 165 | 5215 | 5051 | Trypanosoma conorhini 28S ribosomal RNA (Tco025E_06705), rRNA | blastn | 18127 | 267 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma conorhini | ||
| 23933617 | 23933617 | PRJDB3785_S_NODE_26359_length_162_cov_1.159292_g26206_i0 | PRJDB3785 | 26359 | 162 | 1.159292 | 1.87805304 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 158 | 2.78e-34 | NTclustered | gi|2414483|emb|Y00055.1| | 5656 | g26206 | i0 | 96.809 | 83.9938271604938 | 94 | 3 | 58 | 0 | 1 | 94 | 8156 | 8063 | Crithidia fasciculata ribosomal DNA repeat (complete) | blastn | 13607 | 158 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Crithidia | Crithidia fasciculata | ||
| 25207264 | 25207264 | PRJDB3785_S_NODE_24400_length_165_cov_1.206897_g24247_i0 | PRJDB3785 | 24400 | 165 | 1.206897 | 1.99138005 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 204 | 3.5999999999999995e-48 | NTclustered | gi|440222381|gb|JX030049.1| | 5659 | g24247 | i0 | 89.157 | 95.5818181818182 | 166 | 15 | 100 | 3 | 1 | 165 | 20 | 183 | Leishmania amazonensis isolate LaPH8.rRNA.25 28S ribosomal RNA (LSU-beta), partial sequence | blastn | 15771 | 206 | 0.990291262135922 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania amazonensis |
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);;