contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25670611 | 25670611 | PRJNA1233465a_S_NODE_40770_length_316_cov_138.112360_g39496_i0 | PRJNA1233465 | 40770 | 316 | 138.11236 | 436.4350576 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|1624757467|ref|XM_029029662.1| | 67003 | g39496 | i0 | 96.97 | 0.395569620253165 | 33 | 0 | 10 | 1 | 44 | 75 | 1404 | 1372 | Trypanosoma theileri uncharacterized protein (TM35_000391460), partial mRNA | blastn | 125 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 25829088 | 25829088 | PRJNA1233465f_S_NODE_232323_length_167_cov_1.296610_g230043_i0 | PRJNA1233465 | 232323 | 167 | 1.29661 | 2.1653387 | Trypanosoma vivax | 5699 | Euglenozoa | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|1918093778|gb|MT090068.1| | 5699 | g230043 | i0 | 96.97 | 0.197604790419162 | 33 | 1 | 20 | 0 | 101 | 133 | 19816 | 19848 | Trypanosoma vivax strain Y486 maxicircle kinetoplast, complete genome | blastn | 33 | 56.5 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 25966346 | 25966346 | PRJNA1233465f_S_NODE_256292_length_163_cov_0.894737_g254012_i0 | PRJNA1233465 | 256292 | 163 | 0.894737 | 1.45842131 | Strombomonas costata | 161230 | Euglenozoa | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2452630341|ref|NC_071865.1| | 161230 | g254012 | i0 | 94.595 | 0.226993865030675 | 37 | 0 | 23 | 2 | 45 | 81 | 137433 | 137467 | Strombomonas costata chloroplast, complete genome | blastn | 37 | 56.5 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Strombomonas | Strombomonas costata | ||
| 26086342 | 26086342 | PRJNA1233465d_S_NODE_134989_length_164_cov_0.886957_g133878_i0 | PRJNA1233465 | 134989 | 164 | 0.886957 | 1.45460948 | Leishmania sp. Namibia | 2802991 | Euglenozoa | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|2794980737|ref|XM_067856291.1| | 2802991 | g133878 | i0 | 100 | 0.341463414634146 | 28 | 0 | 17 | 0 | 72 | 99 | 298 | 325 | Leishmania sp. Namibia uncharacterized protein (JIQ42_08242), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania sp. Namibia | ||
| 26089976 | 26089976 | PRJNA1233465e_S_NODE_103341_length_190_cov_1.553191_g102031_i0 | PRJNA1233465 | 103341 | 190 | 1.553191 | 2.9510629 | Trypanosoma vivax Y486 | 1055687 | Euglenozoa | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|340056612|emb|HE573026.1| | 1055687 | g102031 | i0 | 100 | 0.147368421052632 | 28 | 0 | 15 | 0 | 144 | 171 | 1239559 | 1239532 | Trypanosoma vivax Y486 annotated genomic contig, chromosome 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 26099097 | 26099097 | PRJNA1233465f_S_NODE_178941_length_186_cov_1.700730_g176661_i0 | PRJNA1233465 | 178941 | 186 | 1.70073 | 3.1633578 | Trypanosoma vivax Y486 | 1055687 | Euglenozoa | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|340056612|emb|HE573026.1| | 1055687 | g176661 | i0 | 100 | 0.150537634408602 | 28 | 0 | 15 | 0 | 131 | 158 | 1239559 | 1239532 | Trypanosoma vivax Y486 annotated genomic contig, chromosome 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax | ||
| 26298796 | 26298796 | PRJNA1233465a_S_NODE_206734_length_171_cov_1.188525_g205460_i0 | PRJNA1233465 | 206734 | 171 | 1.188525 | 2.03237775 | root | 1 | Root_unresolved | Root_unresolved | 195 | 2.25e-45 | NTclustered | gi|24462339|gb|AC090053.5| | 5664 | g205460 | i0 | 87.5 | 15.3391812865497 | 168 | 21 | 98 | 0 | 3 | 170 | 21317 | 21150 | Leishmania major strain Friedlin chromosome Unknown clone P323, complete sequence | blastn | 2623 | 195 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania major | ||
| 26357090 | 26357090 | PRJNA1233465b_S_NODE_91511_length_284_cov_3.097872_g89826_i0 | PRJNA1233465 | 91511 | 284 | 3.097872 | 8.79795648 | Trypanosoma vivax Y486 | 1055687 | Euglenozoa | other_Eukaryota | 65.8 | 3.37e-6 | NTclustered | gi|340056612|emb|HE573026.1| | 1055687 | g89826 | i0 | 95.122 | 9.88380281690141 | 41 | 2 | 14 | 0 | 244 | 284 | 1035888 | 1035928 | Trypanosoma vivax Y486 annotated genomic contig, chromosome 10 | blastn | 2807 | 65.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma vivax |
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);;