contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA666695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4991355 | 4991355 | PRJNA666695_S_NODE_43984_length_308_cov_4.928839_g42890_i0 | PRJNA666695 | 43984 | 308 | 4.928839 | 15.18082412 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 303 | 7.19e-78 | NTclustered | gi|62175522|gb|AC159414.1| | 5691 | g42890 | i0 | 97.207 | 85.5746753246753 | 179 | 5 | 58 | 0 | 1 | 179 | 65026 | 65204 | Trypanosoma brucei chromosome 3 clone RPCI93-25B21, complete sequence | blastn | 26357 | 303 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 8283124 | 8283124 | PRJNA666695_S_NODE_100067_length_219_cov_5.044944_g98973_i0 | PRJNA666695 | 100067 | 219 | 5.044944 | 11.04842736 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1624746461|ref|XM_029024159.1| | 67003 | g98973 | i0 | 100 | 0.26027397260274 | 29 | 0 | 13 | 0 | 189 | 217 | 2073 | 2045 | Trypanosoma theileri uncharacterized protein (TM35_000082940), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 8284174 | 8284174 | PRJNA666695_S_NODE_150907_length_177_cov_1.352941_g149813_i0 | PRJNA666695 | 150907 | 177 | 1.352941 | 2.39470557 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1031970217|gb|CP015651.1| | 5693 | g149813 | i0 | 91.892 | 0.209039548022599 | 37 | 3 | 21 | 0 | 73 | 109 | 1357296 | 1357332 | Trypanosoma cruzi strain Sylvio X10/cl1 chromosome TcI1, partial sequence | blastn | 37 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 11366253 | 11366253 | PRJNA666695_S_NODE_178229_length_160_cov_1.109244_g177135_i0 | PRJNA666695 | 178229 | 160 | 1.109244 | 1.7747904 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.013 | NTclustered | gi|189094749|emb|FM162579.1| | 5702 | g177135 | i0 | 100 | 0.35 | 28 | 0 | 18 | 0 | 116 | 143 | 46447 | 46420 | Trypanosoma brucei Lister 427 surface glycoprotein expression site BES13/TAR56, from bloodstream | blastn | 56 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma brucei | ||
| 13916381 | 13916381 | PRJNA666695_S_NODE_111351_length_208_cov_3.335329_g110257_i0 | PRJNA666695 | 111351 | 208 | 3.335329 | 6.93748432 | Monomorphina | 298266 | Euglenozoa | other_Eukaryota | 76.8 | 1.08e-9 | NTclustered | gi|54634948|gb|AY626054.1| | 158828 | g110257 | i0 | 81.188 | 15.2548076923077 | 101 | 14 | 48 | 4 | 20 | 118 | 634 | 731 | Monomorphina striata strain CCAP 1261/9 16S small subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 3173 | 76.8 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Monomorphina | Monomorphina striata | ||
| 15190965 | 15190965 | PRJNA666695_S_NODE_109212_length_210_cov_4.124260_g108118_i0 | PRJNA666695 | 109212 | 210 | 4.12426 | 8.660946 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 58.4 | 3.96e-4 | NTclustered | gi|293056|gb|L14604.1|LEIHSP70C | 5659 | g108118 | i0 | 94.737 | 6.8 | 38 | 0 | 18 | 2 | 84 | 121 | 2117 | 2082 | Leishmania amazonensis heat shock protein 70 (hsp70) mRNA, complete cds | blastn | 1428 | 58.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania amazonensis | ||
| 15934433 | 15934433 | PRJNA666695_S_NODE_182053_length_157_cov_2.905172_g180959_i0 | PRJNA666695 | 182053 | 157 | 2.905172 | 4.56112004 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 86.1 | 1.28e-12 | NTclustered | gi|2239711900|gb|OM022896.1| | 5693 | g180959 | i0 | 80 | 1.45859872611465 | 125 | 18 | 76 | 7 | 8 | 126 | 385 | 262 | Trypanosoma cruzi strain Sylvio X/10 NADH dehydrogenase subunit 8 mRNA, complete cds; kinetoplast | blastn | 229 | 86.1 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 19014276 | 19014276 | PRJNA666695_S_NODE_165355_length_167_cov_2.920635_g164261_i0 | PRJNA666695 | 165355 | 167 | 2.920635 | 4.87746045 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 213 | 6.07e-51 | NTclustered | gi|596103701|gb|KC907695.1| | 215699 | g164261 | i0 | 89.82 | 92.2634730538922 | 167 | 15 | 99 | 2 | 1 | 166 | 18 | 183 | Eutreptiella pomquetensis strain CCMP 1491 clone 2 beta-tubulin (tubB) gene, partial cds | blastn | 15408 | 213 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Eutreptiales | Eutreptiaceae | Eutreptiella | Eutreptiella pomquetensis | ||
| 22309164 | 22309164 | PRJNA666695_S_NODE_20338_length_412_cov_5.207547_g19246_i0 | PRJNA666695 | 20338 | 412 | 5.207547 | 21.45509364 | Trypanosoma theileri | 67003 | Euglenozoa | other_Eukaryota | 568 | 3.179999999999999e-157 | NTclustered | gi|2026667530|dbj|LC618030.1| | 67003 | g19246 | i0 | 91.429 | 143.211165048544 | 420 | 27 | 100 | 7 | 1 | 412 | 4354 | 4772 | Trypanosoma theileri YMG-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, ITS3, ITS4, ITS5, partial and complete sequence | blastn | 59003 | 568 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma theileri | ||
| 24859551 | 24859551 | PRJNA666695_S_NODE_83520_length_238_cov_3.055838_g82426_i0 | PRJNA666695 | 83520 | 238 | 3.055838 | 7.27289444 | Decastava edaphica | 1732396 | Euglenozoa | other_Eukaryota | 363 | 8.69e-96 | NTclustered | gi|937541987|gb|KP306753.1| | 1732396 | g82426 | i0 | 97.642 | 38.0798319327731 | 212 | 4 | 89 | 1 | 27 | 238 | 219 | 429 | Decastava edaphica strain CCAP 1265/2 18S ribosomal RNA gene, partial sequence | blastn | 9063 | 363 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Decastava | Decastava edaphica |
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);;