contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10633309 | 10633309 | PRJNA432257_S_NODE_24989_length_298_cov_3.524904_g24608_i0 | PRJNA432257 | 24989 | 298 | 3.524904 | 10.50421392 | root | 1 | Root_unresolved | Root_unresolved | 180 | 7.169999999999998e-56 | NR | KAF0852624.1 | 505711 | g24608 | i0 | 81.6 | 8.87919463087248 | 98 | 18 | 98.7 | 0 | 4 | 297 | 47 | 144 | KAF0852624.1 cyclophilin (peptidylprolyl isomerase) [Andalucia godoyi] | diamond | 2646 | 180 | 1 | Eukaryota | Discoba | Jakobida | Andaluciidae | Andalucia | Andalucia godoyi | ||||
| 26949186 | 26949186 | PRJNA432257_S_NODE_98922_length_177_cov_2.878571_g98541_i0 | PRJNA432257 | 98922 | 177 | 2.878571 | 5.09507067 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 100 | 9.429999999999999e-25 | NR | KAL0488347.1 | 1008807 | g98541 | i0 | 94.4 | 0.915254237288136 | 54 | 3 | 91.5 | 0 | 176 | 15 | 130 | 183 | KAL0488347.1 irditoxin subunit A [Acrasis kona] | diamond | 162 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27518205 | 27518205 | PRJNA432257_S_NODE_78803_length_194_cov_2.617834_g78422_i0 | PRJNA432257 | 78803 | 194 | 2.617834 | 5.07859796 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 119 | 3.3699999999999997e-32 | NR | KAL0488347.1 | 1008807 | g78422 | i0 | 84.4 | 0.989690721649485 | 64 | 10 | 99 | 0 | 192 | 1 | 82 | 145 | KAL0488347.1 irditoxin subunit A [Acrasis kona] | diamond | 192 | 119 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27581235 | 27581235 | PRJNA432257_S_NODE_110944_length_165_cov_2.539062_g110563_i0 | PRJNA432257 | 110944 | 165 | 2.539062 | 4.1894523 | Strigomonas culicis | 28005 | Euglenozoa | other_Eukaryota | 52.4 | 5.25e-6 | NR | EPY35056.1 | 28005 | g110563 | i0 | 45.8 | 0.872727272727273 | 48 | 26 | 87.3 | 0 | 16 | 159 | 105 | 152 | EPY35056.1 hypothetical protein STCU_01272 [Strigomonas culicis] | diamond | 144 | 52.4 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Strigomonas | Strigomonas culicis | ||
| 28054847 | 28054847 | PRJNA432257_S_NODE_58165_length_218_cov_25.685083_g57784_i0 | PRJNA432257 | 58165 | 218 | 25.685083 | 55.99348094 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 88.6 | 4.81e-19 | NR | KAL0480143.1 | 1008807 | g57784 | i0 | 65.5 | 0.798165137614679 | 58 | 20 | 79.8 | 0 | 4 | 177 | 241 | 298 | KAL0480143.1 cathepsin [Acrasis kona] | diamond | 174 | 88.6 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28686704 | 28686704 | PRJNA432257_S_NODE_91067_length_183_cov_8.712329_g90686_i0 | PRJNA432257 | 91067 | 183 | 8.712329 | 15.94356207 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 70.1 | 3.68e-12 | NR | KAL0477662.1 | 1008807 | g90686 | i0 | 86.1 | 0.590163934426229 | 36 | 5 | 59 | 0 | 172 | 65 | 462 | 497 | KAL0477662.1 equilibrative nucleotide transporter [Acrasis kona] | diamond | 108 | 70.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29412478 | 29412478 | PRJNA432257_S_NODE_24169_length_302_cov_1.471698_g23788_i0 | PRJNA432257 | 24169 | 302 | 1.471698 | 4.44452796 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 78.2 | 6.16e-16 | NR | KAL0487907.1 | 1008807 | g23788 | i0 | 76 | 1.49006622516556 | 75 | 18 | 74.5 | 0 | 225 | 1 | 3 | 77 | KAL0487907.1 hypothetical protein AKO1_008896 [Acrasis kona] | diamond | 450 | 78.2 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30518151 | 30518151 | PRJNA432257_S_NODE_91753_length_182_cov_448.937931_g91372_i0 | PRJNA432257 | 91753 | 182 | 448.937931 | 817.06703442 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 72 | 4.06e-14 | NR | KAL0480702.1 | 1008807 | g91372 | i0 | 66 | 2.32417582417582 | 47 | 16 | 77.5 | 0 | 143 | 3 | 78 | 124 | KAL0480702.1 plsX [Acrasis kona] | diamond | 423 | 72 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31229498 | 31229498 | PRJNA432257_S_NODE_43715_length_243_cov_2.412621_g43334_i0 | PRJNA432257 | 43715 | 243 | 2.412621 | 5.86266903 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 92 | 1.56e-19 | NR | KAL0486837.1 | 1008807 | g43334 | i0 | 65.6 | 13.1111111111111 | 64 | 22 | 79 | 0 | 223 | 32 | 480 | 543 | KAL0486837.1 proline dehydrogenase [Acrasis kona] | diamond | 3186 | 92 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31940572 | 31940572 | PRJNA432257_S_NODE_124877_length_153_cov_0.982759_g124496_i0 | PRJNA432257 | 124877 | 153 | 0.982759 | 1.50362127 | Diplonema ambulator | 182243 | Euglenozoa | other_Eukaryota | 43.1 | 0.00783 | NR | ACO50118.1 | 182243 | g124496 | i0 | 70.6 | 3.41176470588235 | 34 | 7 | 66.7 | 1 | 152 | 51 | 307 | 337 | ACO50118.1 elongation factor 1 alpha-like protein, partial [Diplonema ambulator] | diamond | 522 | 43.1 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema ambulator | |||
| 32035677 | 32035677 | PRJNA432257_S_NODE_51318_length_229_cov_1.421875_g50937_i0 | PRJNA432257 | 51318 | 229 | 1.421875 | 3.25609375 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 84 | 1.49e-17 | NR | NP_066534.1 | 5762 | g50937 | i0 | 55.8 | 2.8296943231441 | 77 | 32 | 98.3 | 1 | 4 | 228 | 91 | 167 | NP_066534.1 ATP synthase F0 subunit 6 [Naegleria gruberi] | diamond | 648 | 84 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32098885 | 32098885 | PRJNA432257_S_NODE_110198_length_166_cov_1.813953_g109817_i0 | PRJNA432257 | 110198 | 166 | 1.813953 | 3.01116198 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 99.8 | 3.32e-23 | NR | KAL0485441.1 | 1008807 | g109817 | i0 | 94.1 | 0.921686746987952 | 51 | 3 | 92.2 | 0 | 1 | 153 | 316 | 366 | KAL0485441.1 cell cycle control protein 50A [Acrasis kona] | diamond | 153 | 99.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32225619 | 32225619 | PRJNA432257_S_NODE_100298_length_176_cov_2.179856_g99917_i0 | PRJNA432257 | 100298 | 176 | 2.179856 | 3.83654656 | Jakoba bahamiensis | 221721 | Root_unresolved | Root_unresolved | 59.3 | 9.43e-9 | NR | YP_007890634.1 | 221721 | g99917 | i0 | 61.5 | 0.664772727272727 | 39 | 15 | 66.5 | 0 | 21 | 137 | 53 | 91 | YP_007890634.1 NADH dehydrogenase subunit 9 [Jakoba bahamiensis] | diamond | 117 | 59.3 | 1 | Eukaryota | Discoba | Jakobida | Jakobidae | Jakoba | Jakoba bahamiensis |
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);;