contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1467041 | 1467041 | PRJNA1078753_P_NODE_13642_length_317_cov_3.848361_g13446_i0 | PRJNA1078753 | 13642 | 317 | 3.848361 | 12.19930437 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 8.09e-40 | NR | BAN33737.1 | 931554 | g13446 | i0 | 76.9 | 6.95583596214511 | 91 | 21 | 86.1 | 0 | 274 | 2 | 4 | 94 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 2205 | 147 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 4845100 | 4845100 | PRJNA1078753_P_NODE_544_length_1224_cov_8.031277_g428_i0 | PRJNA1078753 | 544 | 1224 | 8.031277 | 98.30283048 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 627 | 1.2399999999999995e-223 | NR | AAP88974.1 | 5775 | g428 | i0 | 77.7 | 0.958333333333333 | 391 | 85 | 95.8 | 1 | 1218 | 46 | 1 | 389 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1173 | 627 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 6570474 | 6570474 | PRJNA1078753_P_NODE_246_length_1608_cov_25.195440_g187_i0 | PRJNA1078753 | 246 | 1608 | 25.19544 | 405.1426752 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 1.6900000000000002e-276 | NR | BAN33737.1 | 931554 | g187 | i0 | 81.3 | 3.42164179104478 | 464 | 81 | 85.4 | 1 | 44 | 1417 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5502 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 11671213 | 11671213 | PRJNA1078753_P_NODE_250_length_1602_cov_26.559843_g187_i1 | PRJNA1078753 | 250 | 1602 | 26.559843 | 425.48868486 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 1.1e-276 | NR | BAN33737.1 | 931554 | g187 | i1 | 81.3 | 3.43445692883895 | 464 | 81 | 85.8 | 1 | 38 | 1411 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5502 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 11671394 | 11671394 | PRJNA1078753_P_NODE_6330_length_425_cov_2.184659_g6134_i0 | PRJNA1078753 | 6330 | 425 | 2.184659 | 9.28480075 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 179 | 4.79e-49 | NR | AAD33718.1 | 5775 | g6134 | i0 | 65.3 | 1.01647058823529 | 144 | 45 | 98.8 | 3 | 5 | 424 | 59 | 201 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 432 | 179 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 19318207 | 19318207 | PRJNA1078753_P_NODE_19796_length_279_cov_1.495146_g19600_i0 | PRJNA1078753 | 19796 | 279 | 1.495146 | 4.17145734 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 94.7 | 2.01e-20 | NR | AEA30120.1 | 5778 | g19600 | i0 | 51.1 | 0.989247311827957 | 92 | 40 | 98.9 | 2 | 3 | 278 | 150 | 236 | AEA30120.1 glucosamine-6-phosphate isomerase, partial [Vermamoeba vermiformis] | diamond | 276 | 94.7 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20593764 | 20593764 | PRJNA1078753_P_NODE_9197_length_366_cov_3.143345_g9001_i0 | PRJNA1078753 | 9197 | 366 | 3.143345 | 11.5046427 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 218 | 3.84e-69 | NR | ACA04822.1 | 497998 | g9001 | i0 | 85.1 | 0.991803278688525 | 121 | 18 | 99.2 | 0 | 2 | 364 | 70 | 190 | ACA04822.1 alpha-tubulin, partial [Arcella hemisphaerica] | diamond | 363 | 218 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 27121818 | 27121818 | PRJNA1078753_P_NODE_23802_length_263_cov_1.621053_g23606_i0 | PRJNA1078753 | 23802 | 263 | 1.621053 | 4.26336939 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.2 | 1.7e-16 | NR | AAY34140.1 | 5778 | g23606 | i0 | 53.5 | 2.92015209125475 | 86 | 39 | 98.1 | 1 | 260 | 3 | 38 | 122 | AAY34140.1 Nop58p, partial [Vermamoeba vermiformis] | diamond | 768 | 83.6 | 0.995215311004785 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27636260 | 27636260 | PRJNA1078753_P_NODE_10664_length_347_cov_4.014599_g10468_i0 | PRJNA1078753 | 10664 | 347 | 4.014599 | 13.93065853 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 150 | 3.4e-41 | NR | AAD37351.1 | 5775 | g10468 | i0 | 66.1 | 1.02017291066282 | 118 | 36 | 98.6 | 2 | 2 | 343 | 93 | 210 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 354 | 150 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 28962488 | 28962488 | PRJNA1078753_P_NODE_2868_length_591_cov_2.594595_g2676_i0 | PRJNA1078753 | 2868 | 591 | 2.594595 | 15.33405645 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 246 | 2.21e-71 | NR | AAD33718.1 | 5775 | g2676 | i0 | 66.2 | 0.989847715736041 | 195 | 65 | 98.5 | 1 | 587 | 6 | 680 | 874 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 585 | 246 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29751320 | 29751320 | PRJNA1078753_P_NODE_1971_length_697_cov_2.911859_g1791_i0 | PRJNA1078753 | 1971 | 697 | 2.911859 | 20.29565723 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 223 | 5.39e-63 | NR | AAD33718.1 | 5775 | g1791 | i0 | 53.6 | 1.01147776183644 | 235 | 98 | 99.9 | 5 | 2 | 697 | 188 | 414 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 705 | 223 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30035941 | 30035941 | PRJNA1078753_P_NODE_4731_length_480_cov_1.444717_g4535_i0 | PRJNA1078753 | 4731 | 480 | 1.444717 | 6.9346416 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 100 | 4.9900000000000006e-21 | NR | AAD33718.1 | 5775 | g4535 | i0 | 40.9 | 0.9625 | 154 | 67 | 95.6 | 5 | 2 | 460 | 539 | 669 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 462 | 100 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30130300 | 30130300 | PRJNA1078753_P_NODE_22452_length_268_cov_2.333333_g22256_i0 | PRJNA1078753 | 22452 | 268 | 2.333333 | 6.25333244 | Nolandella sp. LAK-2 | 1908693 | Tubulinea | other_Eukaryota | 128 | 2.16e-34 | NR | AFX73095.1 | 1260117 | g22256 | i0 | 71.3 | 4.83582089552239 | 87 | 25 | 97.4 | 0 | 3 | 263 | 20 | 106 | AFX73095.1 elongation factor 2 alpha, partial [Nolandella sp. LAK-2012] | diamond | 1296 | 128 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Nolandella | Nolandella sp. LAK-2012 | ||
| 30762645 | 30762645 | PRJNA1078753_P_NODE_20454_length_276_cov_2.630542_g20258_i0 | PRJNA1078753 | 20454 | 276 | 2.630542 | 7.26029592 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 142 | 3.789999999999999e-37 | NR | ABD16178.1 | 5775 | g20258 | i0 | 77.8 | 0.880434782608696 | 81 | 18 | 88 | 0 | 250 | 8 | 4 | 84 | ABD16178.1 110 kDa actin binding protein interacting with anti-filamin antibody [Amoeba proteus] | diamond | 243 | 142 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30888970 | 30888970 | PRJNA1078753_P_NODE_10854_length_345_cov_1.974265_g10658_i0 | PRJNA1078753 | 10854 | 345 | 1.974265 | 6.81121425 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 177 | 1.2399999999999999e-52 | NR | AFX84537.1 | 5775 | g10658 | i0 | 72.8 | 0.991304347826087 | 114 | 31 | 99.1 | 0 | 2 | 343 | 156 | 269 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 342 | 177 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32249173 | 32249173 | PRJNA1078753_P_NODE_7458_length_397_cov_1.657407_g7262_i0 | PRJNA1078753 | 7458 | 397 | 1.657407 | 6.57990579 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 115 | 1.1599999999999999e-28 | NR | AAY21191.1 | 5778 | g7262 | i0 | 61.6 | 1.49622166246851 | 99 | 38 | 74.8 | 0 | 397 | 101 | 148 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 594 | 115 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32533807 | 32533807 | PRJNA1078753_P_NODE_8919_length_371_cov_1.033557_g8723_i0 | PRJNA1078753 | 8919 | 371 | 1.033557 | 3.83449647 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 108 | 1.2e-27 | NR | ABD72565.1 | 5778 | g8723 | i0 | 64.6 | 0.638814016172507 | 79 | 28 | 63.9 | 0 | 237 | 1 | 1 | 79 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 237 | 108 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;