contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 647729 | 647729 | PRJNA675331_P_NODE_941_length_915_cov_1.501188_g807_i0 | PRJNA675331 | 941 | 915 | 1.501188 | 13.7358702 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 144 | 2.8099999999999998e-34 | NR | AAD33718.1 | 5775 | g807 | i0 | 46 | 3.04918032786885 | 198 | 81 | 63 | 5 | 904 | 329 | 411 | 588 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 2790 | 144 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 3198716 | 3198716 | PRJNA675331_P_NODE_8103_length_344_cov_1.103321_g7931_i0 | PRJNA675331 | 8103 | 344 | 1.103321 | 3.79542424 | Euamoebida | 180229 | Tubulinea | other_Eukaryota | 170 | 1.2e-51 | NR | AFX73058.1 | 160823 | g7931 | i0 | 80 | 1.83139534883721 | 105 | 21 | 91.6 | 0 | 344 | 30 | 56 | 160 | AFX73058.1 14-3-3 protein, partial [Chaos carolinense] | diamond | 630 | 170 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 7026392 | 7026392 | PRJNA675331_P_NODE_17986_length_251_cov_1.297753_g17814_i0 | PRJNA675331 | 17986 | 251 | 1.297753 | 3.25736003 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 132 | 1.33e-35 | NR | AFX84537.1 | 5775 | g17814 | i0 | 74.4 | 0.9800796812749 | 82 | 21 | 98 | 0 | 251 | 6 | 188 | 269 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 246 | 132 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 13401839 | 13401839 | PRJNA675331_P_NODE_19071_length_249_cov_1.392045_g18899_i0 | PRJNA675331 | 19071 | 249 | 1.392045 | 3.46619205 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 144 | 1.1e-41 | NR | AAW58116.1 | 5775 | g18899 | i0 | 84.4 | 0.927710843373494 | 77 | 12 | 92.8 | 0 | 231 | 1 | 4 | 80 | AAW58116.1 peroxiredoxin, partial [Amoeba proteus] | diamond | 231 | 144 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 18500015 | 18500015 | PRJNA675331_P_NODE_1595_length_721_cov_1.203704_g1435_i0 | PRJNA675331 | 1595 | 721 | 1.203704 | 8.67870584 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 384 | 4.789999999999998e-119 | NR | AAD33718.1 | 5775 | g1435 | i0 | 81 | 0.986130374479889 | 237 | 44 | 98.6 | 1 | 715 | 5 | 616 | 851 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 711 | 384 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 22325174 | 22325174 | PRJNA675331_P_NODE_3038_length_534_cov_2.555315_g2870_i0 | PRJNA675331 | 3038 | 534 | 2.555315 | 13.6453821 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 306 | 3.28e-100 | NR | BAN33737.1 | 931554 | g2870 | i0 | 82.4 | 1.98314606741573 | 176 | 31 | 98.9 | 0 | 5 | 532 | 274 | 449 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1059 | 306 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 26797104 | 26797104 | PRJNA675331_P_NODE_14701_length_273_cov_1.155000_g14529_i0 | PRJNA675331 | 14701 | 273 | 1.155 | 3.15315 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 87.8 | 6.7e-18 | NR | BAN33737.1 | 931554 | g14529 | i0 | 89.4 | 0.516483516483517 | 47 | 5 | 51.6 | 0 | 1 | 141 | 418 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 141 | 87.8 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 27156589 | 27156589 | PRJNA675331_P_NODE_9682_length_319_cov_1.060976_g9510_i0 | PRJNA675331 | 9682 | 319 | 1.060976 | 3.38451344 | Euamoebida | 180229 | Tubulinea | other_Eukaryota | 191 | 9.03e-59 | NR | AFX73090.1 | 160823 | g9510 | i0 | 90.4 | 2.84952978056426 | 104 | 10 | 97.8 | 0 | 317 | 6 | 11 | 114 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 909 | 191 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 27587542 | 27587542 | PRJNA675331_P_NODE_1744_length_689_cov_1.905844_g1583_i0 | PRJNA675331 | 1744 | 689 | 1.905844 | 13.13126516 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 159 | 1.2399999999999997e-42 | NR | AAD37351.1 | 5775 | g1583 | i0 | 66.4 | 0.518142235123367 | 119 | 39 | 51.8 | 1 | 333 | 689 | 6 | 123 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 357 | 159 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28641362 | 28641362 | PRJNA675331_P_NODE_24027_length_241_cov_0.916667_g23855_i0 | PRJNA675331 | 24027 | 241 | 0.916667 | 2.20916747 | Arcella | 318540 | Tubulinea | other_Eukaryota | 136 | 7.56e-38 | NR | ADM22175.1 | 497998 | g23855 | i0 | 73.8 | 3.98340248962656 | 80 | 21 | 99.6 | 0 | 2 | 241 | 136 | 215 | ADM22175.1 actin, partial [Arcella hemisphaerica] | diamond | 960 | 136 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 29146733 | 29146733 | PRJNA675331_P_NODE_21109_length_246_cov_0.890173_g20937_i0 | PRJNA675331 | 21109 | 246 | 0.890173 | 2.18982558 | Hartmannellidae | 5776 | Tubulinea | other_Eukaryota | 113 | 4.49e-29 | NR | BAV21602.1 | 239731 | g20937 | i0 | 68.3 | 3 | 82 | 26 | 100 | 0 | 1 | 246 | 129 | 210 | BAV21602.1 elongation factor 2 alpha, partial [Hartmannella cantabrigiensis] | diamond | 738 | 113 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 29323912 | 29323912 | PRJNA675331_P_NODE_16969_length_258_cov_1.248649_g16797_i0 | PRJNA675331 | 16969 | 258 | 1.248649 | 3.22151442 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 50.8 | 6.68e-5 | NR | AAD33718.1 | 5775 | g16797 | i0 | 62.5 | 0.465116279069767 | 40 | 15 | 46.5 | 0 | 1 | 120 | 1550 | 1589 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 120 | 50.8 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29367469 | 29367469 | PRJNA675331_P_NODE_2949_length_542_cov_1.115139_g2781_i0 | PRJNA675331 | 2949 | 542 | 1.115139 | 6.04405338 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 177 | 1.03e-49 | NR | BAN33737.1 | 931554 | g2781 | i0 | 81.6 | 5.70110701107011 | 103 | 19 | 57 | 0 | 541 | 233 | 265 | 367 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 3090 | 177 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 29670982 | 29670982 | PRJNA675331_P_NODE_4830_length_434_cov_1.279778_g4658_i0 | PRJNA675331 | 4830 | 434 | 1.279778 | 5.55423652 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 271 | 1.1399999999999999e-89 | NR | AFX73097.1 | 704142 | g4658 | i0 | 86.8 | 1.99078341013825 | 144 | 19 | 99.5 | 0 | 434 | 3 | 118 | 261 | AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] | diamond | 864 | 271 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 31345978 | 31345978 | PRJNA675331_P_NODE_3736_length_486_cov_1.677966_g3564_i0 | PRJNA675331 | 3736 | 486 | 1.677966 | 8.15491476 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 73.9 | 7.28e-12 | NR | AAD33718.1 | 5775 | g3564 | i0 | 52.1 | 0.864197530864197 | 140 | 67 | 86.4 | 0 | 486 | 67 | 846 | 985 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 420 | 73.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31757064 | 31757064 | PRJNA675331_P_NODE_4877_length_432_cov_1.284123_g4705_i0 | PRJNA675331 | 4877 | 432 | 1.284123 | 5.54741136 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 95.9 | 8.56e-20 | NR | AAD33718.1 | 5775 | g4705 | i0 | 44.4 | 1.71527777777778 | 124 | 67 | 85.4 | 2 | 427 | 59 | 510 | 632 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 741 | 95.9 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32389851 | 32389851 | PRJNA675331_P_NODE_21279_length_246_cov_0.884393_g21107_i0 | PRJNA675331 | 21279 | 246 | 0.884393 | 2.17560678 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 79.7 | 3.88e-15 | NR | AAD33718.1 | 5775 | g21107 | i0 | 51.2 | 1.02439024390244 | 84 | 34 | 93.9 | 1 | 246 | 16 | 371 | 454 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 252 | 79.7 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32465104 | 32465104 | PRJNA675331_P_NODE_2259_length_612_cov_1.428571_g2093_i0 | PRJNA675331 | 2259 | 612 | 1.428571 | 8.74285452 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 194 | 2.35e-56 | NR | AAD37351.1 | 5775 | g2093 | i0 | 53.9 | 1.99509803921569 | 206 | 89 | 99.5 | 3 | 3 | 611 | 124 | 326 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 1221 | 194 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;