contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA983838" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8617689 | 8617689 | PRJNA983838_P_NODE_109607_length_249_cov_0.886364_g107240_i0 | PRJNA983838 | 109607 | 249 | 0.886364 | 2.20704636 | Trypanosomatidae | 5654 | Euglenozoa | other_Eukaryota | 101 | 7.469999999999999e-23 | NR | KPI88551.1 | 5684 | g107240 | i0 | 66.7 | 10.6024096385542 | 81 | 24 | 97.6 | 1 | 248 | 6 | 437 | 514 | KPI88551.1 putative ATP-dependent RNA helicase [Leptomonas seymouri] | diamond | 2640 | 101 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas seymouri | ||
| 27784706 | 27784706 | PRJNA983838_P_NODE_101624_length_257_cov_1.690217_g99257_i0 | PRJNA983838 | 101624 | 257 | 1.690217 | 4.34385769 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 69.3 | 1.9e-11 | NR | CUG94218.1 | 75058 | g99257 | i0 | 55 | 0.933852140077821 | 80 | 34 | 91.1 | 1 | 255 | 22 | 329 | 408 | CUG94218.1 unnamed protein product [Bodo saltans] | diamond | 240 | 69.3 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 28573744 | 28573744 | PRJNA983838_P_NODE_51567_length_420_cov_1.319885_g49200_i0 | PRJNA983838 | 51567 | 420 | 1.319885 | 5.543517 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 207 | 1.5899999999999998e-66 | NR | CUG08503.1 | 75058 | g49200 | i0 | 79.4 | 0.935714285714286 | 131 | 27 | 93.6 | 0 | 414 | 22 | 1 | 131 | CUG08503.1 60S ribosomal protein L32, putative [Bodo saltans] | diamond | 393 | 207 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29805158 | 29805158 | PRJNA983838_P_NODE_113251_length_246_cov_0.901734_g110884_i0 | PRJNA983838 | 113251 | 246 | 0.901734 | 2.21826564 | Trypanosoma congolense IL3 | 5692 | Euglenozoa | other_Eukaryota | 75.9 | 3.82e-14 | NR | CCC92990.1 | 1068625 | g110884 | i0 | 53 | 0.804878048780488 | 66 | 31 | 80.5 | 0 | 246 | 49 | 179 | 244 | CCC92990.1 putative amino acid transporter [Trypanosoma congolense IL3000] | diamond | 198 | 75.9 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma congolense | ||
| 30026473 | 30026473 | PRJNA983838_P_NODE_97351_length_264_cov_1.827225_g94984_i0 | PRJNA983838 | 97351 | 264 | 1.827225 | 4.823874 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 108 | 3.48e-25 | NR | CUI14625.1 | 75058 | g94984 | i0 | 94.7 | 0.647727272727273 | 57 | 3 | 64.8 | 0 | 264 | 94 | 525 | 581 | CUI14625.1 mitotic centromere-associated kinesin (MCAK), putative [Bodo saltans] | diamond | 171 | 108 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 30911154 | 30911154 | PRJNA983838_P_NODE_112294_length_247_cov_0.896552_g109927_i0 | PRJNA983838 | 112294 | 247 | 0.896552 | 2.21448344 | Leptomonas seymouri | 5684 | Euglenozoa | other_Eukaryota | 89.4 | 1.57e-18 | NR | KPI87380.1 | 5684 | g109927 | i0 | 52.9 | 0.850202429149798 | 70 | 33 | 85 | 0 | 219 | 10 | 407 | 476 | KPI87380.1 transmembrane amino acid transporter protein- like protein [Leptomonas seymouri] | diamond | 210 | 89.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas seymouri | ||
| 31416781 | 31416781 | PRJNA983838_P_NODE_113696_length_246_cov_0.901734_g111329_i0 | PRJNA983838 | 113696 | 246 | 0.901734 | 2.21826564 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 46.2 | 0.0023 | NR | CUI14895.1 | 75058 | g111329 | i0 | 38.3 | 0.731707317073171 | 60 | 37 | 73.2 | 0 | 245 | 66 | 364 | 423 | CUI14895.1 transmembrane protein, putative [Bodo saltans] | diamond | 180 | 46.2 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 31612564 | 31612564 | PRJNA983838_P_NODE_113176_length_246_cov_0.901734_g110809_i0 | PRJNA983838 | 113176 | 246 | 0.901734 | 2.21826564 | Trypanosoma | 5690 | Euglenozoa | other_Eukaryota | 45.8 | 9.64e-4 | NR | KAG8344673.1 | 5699 | g110809 | i0 | 54.8 | 1.02439024390244 | 42 | 19 | 51.2 | 0 | 42 | 167 | 2 | 43 | KAG8344673.1 hypothetical protein TRVL_04492 [Trypanosoma vivax] | diamond | 252 | 45.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);;