contig_metadata
18 rows where bioproject = "PRJNA1028258", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164477 | 164477 | PRJNA1028258_P_NODE_27661_length_483_cov_1.874396_g27101_i0 | PRJNA1028258 | 27661 | 483 | 1.874396 | 9.05333268 | Arcella discoides | 1078856 | Tubulinea | other_Eukaryota | 477 | 6.549999999999998e-130 | NTclustered | gi|345452546|gb|JF694291.1| | 1078856 | g27101 | i0 | 84.536 | 98.4120082815735 | 485 | 71 | 100 | 4 | 1 | 483 | 735 | 253 | Arcella discoides isolate DL3_98 clone 5 actin gene, partial cds | blastn | 47533 | 477 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella discoides | ||
| 1437858 | 1437858 | PRJNA1028258_P_NODE_110882_length_252_cov_0.928962_g110319_i0 | PRJNA1028258 | 110882 | 252 | 0.928962 | 2.34098424 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 322 | 1.58e-83 | NTclustered | gi|259595682|gb|FJ705345.1| | 675832 | g110319 | i0 | 92.444 | 96.484126984127 | 225 | 17 | 89 | 0 | 28 | 252 | 392 | 168 | Spumochlamys bryora actin gene, partial cds | blastn | 24314 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 1439639 | 1439639 | PRJNA1028258_P_NODE_44562_length_379_cov_1.970968_g43999_i0 | PRJNA1028258 | 44562 | 379 | 1.970968 | 7.46996872 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 468 | 3.03e-127 | NTclustered | gi|421976286|gb|JQ519399.1| | 1078836 | g43999 | i0 | 89.153 | 12.8970976253298 | 378 | 37 | 99 | 4 | 4 | 379 | 36 | 411 | Cryptodifflugia operculata clone JG11.5_7 14-3-3 protein gene, partial cds | blastn | 4888 | 468 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 1439900 | 1439900 | PRJNA1028258_P_NODE_57862_length_335_cov_0.917293_g57299_i0 | PRJNA1028258 | 57862 | 335 | 0.917293 | 3.07293155 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 577 | 4.2199999999999986e-160 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g57299 | i0 | 97.904 | 96.8507462686567 | 334 | 6 | 99 | 1 | 2 | 335 | 305 | 637 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 32445 | 577 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 1439908 | 1439908 | PRJNA1028258_P_NODE_58602_length_333_cov_1.015152_g58039_i0 | PRJNA1028258 | 58602 | 333 | 1.015152 | 3.38045616 | Nebela penardiana | 499102 | Tubulinea | other_Eukaryota | 359 | 1.6499999999999998e-94 | NTclustered | gi|423292008|gb|JQ519449.1| | 499102 | g58039 | i0 | 86.728 | 95.5285285285285 | 324 | 41 | 97 | 2 | 6 | 328 | 382 | 704 | Nebela penardiana clone JG11.33_c1 actin pseudogene, partial sequence | blastn | 31811 | 359 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Hyalospheniidae | Nebela | Nebela penardiana | ||
| 6541970 | 6541970 | PRJNA1028258_P_NODE_153186_length_230_cov_1.322981_g152623_i0 | PRJNA1028258 | 153186 | 230 | 1.322981 | 3.0428563 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 139 | 1.53e-28 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g152623 | i0 | 78.182 | 0.956521739130435 | 220 | 46 | 95 | 2 | 1 | 219 | 1317 | 1099 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 220 | 139 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 7818475 | 7818475 | PRJNA1028258_P_NODE_93167_length_268_cov_1.165829_g92604_i0 | PRJNA1028258 | 93167 | 268 | 1.165829 | 3.12442172 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 313 | 1.02e-80 | NTclustered | gi|423291982|gb|JQ519436.1| | 5778 | g92604 | i0 | 87.687 | 99.8283582089552 | 268 | 33 | 100 | 0 | 1 | 268 | 526 | 259 | Vermamoeba vermiformis clone JG10.95_g4 actin gene, partial cds | blastn | 26754 | 313 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9932971 | 9932971 | PRJNA1028258_P_NODE_168988_length_227_cov_0.898734_g168425_i0 | PRJNA1028258 | 168988 | 227 | 0.898734 | 2.04012618 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 298 | 2.35e-76 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g168425 | i0 | 90.308 | 95.1497797356828 | 227 | 22 | 100 | 0 | 1 | 227 | 931 | 705 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 21599 | 300 | 0.993333333333333 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 11207889 | 11207889 | PRJNA1028258_P_NODE_13189_length_699_cov_1.812698_g12694_i0 | PRJNA1028258 | 13189 | 699 | 1.812698 | 12.67075902 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 774 | 0 | NTclustered | gi|33946352|gb|AY294155.1| | 242547 | g12694 | i0 | 87.045 | 93.0057224606581 | 687 | 87 | 98 | 2 | 1 | 686 | 724 | 39 | Glaeseria mira actin mRNA, partial cds | blastn | 65011 | 776 | 0.997422680412371 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Glaeseria | Glaeseria mira | ||
| 15467825 | 15467825 | PRJNA1028258_P_NODE_53413_length_348_cov_0.896057_g52850_i0 | PRJNA1028258 | 53413 | 348 | 0.896057 | 3.11827836 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 425 | 1.69e-114 | NTclustered | gi|259595682|gb|FJ705345.1| | 675832 | g52850 | i0 | 89.181 | 95.8563218390805 | 342 | 36 | 98 | 1 | 2 | 343 | 461 | 121 | Spumochlamys bryora actin gene, partial cds | blastn | 33358 | 425 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 18017202 | 18017202 | PRJNA1028258_P_NODE_69515_length_308_cov_1.104603_g68952_i0 | PRJNA1028258 | 69515 | 308 | 1.104603 | 3.40217724 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 368 | 2.51e-97 | NTclustered | gi|345452564|gb|JF694300.1| | 1078836 | g68952 | i0 | 97.235 | 94.5324675324675 | 217 | 6 | 70 | 0 | 92 | 308 | 795 | 579 | Cryptodifflugia operculata clone 4 actin gene, partial cds | blastn | 29116 | 368 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 20131636 | 20131636 | PRJNA1028258_P_NODE_27056_length_489_cov_1.150000_g26496_i0 | PRJNA1028258 | 27056 | 489 | 1.15 | 5.6235 | Flabellulidae | 136457 | Tubulinea | other_Eukaryota | 488 | 3.0699999999999993e-133 | NTclustered | gi|167859754|gb|EU273459.1| | 497999 | g26496 | i0 | 84.787 | 99.6053169734151 | 493 | 67 | 100 | 8 | 1 | 489 | 785 | 297 | Rhizamoeba sp. ATCC 50933 actin gene, partial cds | blastn | 48707 | 490 | 0.995918367346939 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba sp. ATCC 50933 | ||
| 21840942 | 21840942 | PRJNA1028258_P_NODE_166518_length_227_cov_0.898734_g165955_i0 | PRJNA1028258 | 166518 | 227 | 0.898734 | 2.04012618 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 130 | 5.339999999999998e-35 | NR | AFX84537.1 | 5775 | g165955 | i0 | 82.7 | 0.991189427312775 | 75 | 13 | 99.1 | 0 | 227 | 3 | 128 | 202 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 225 | 130 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 24389387 | 24389387 | PRJNA1028258_P_NODE_12380_length_720_cov_2.294931_g11892_i0 | PRJNA1028258 | 12380 | 720 | 2.294931 | 16.5235032 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 516 | 2.12e-141 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g11892 | i0 | 80.506 | 13.3708333333333 | 672 | 131 | 93 | 0 | 30 | 701 | 672 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 9627 | 516 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 26591594 | 26591594 | PRJNA1028258_P_NODE_170621_length_226_cov_0.904459_g170058_i0 | PRJNA1028258 | 170621 | 226 | 0.904459 | 2.04407734 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 45.1 | 0.00412 | NR | AAY87037.1 | 5778 | g170058 | i0 | 53.1 | 0.424778761061947 | 32 | 15 | 42.5 | 0 | 131 | 226 | 123 | 154 | AAY87037.1 CmfA-like protein, partial [Vermamoeba vermiformis] | diamond | 96 | 45.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29403547 | 29403547 | PRJNA1028258_P_NODE_78949_length_290_cov_1.606335_g78386_i0 | PRJNA1028258 | 78949 | 290 | 1.606335 | 4.6583715 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 61.6 | 1.45e-8 | NR | BAN33737.1 | 931554 | g78386 | i0 | 100 | 0.310344827586207 | 30 | 0 | 31 | 0 | 289 | 200 | 435 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 90 | 61.6 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 29490145 | 29490145 | PRJNA1028258_P_NODE_137330_length_234_cov_0.860606_g136767_i0 | PRJNA1028258 | 137330 | 234 | 0.860606 | 2.01381804 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 121 | 2.4e-30 | NR | BAN33737.1 | 931554 | g136767 | i0 | 70.1 | 2.96153846153846 | 77 | 23 | 98.7 | 0 | 3 | 233 | 300 | 376 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 693 | 122 | 0.991803278688525 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 31646727 | 31646727 | PRJNA1028258_P_NODE_160397_length_229_cov_0.887500_g159834_i0 | PRJNA1028258 | 160397 | 229 | 0.8875 | 2.032375 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 143 | 1.9199999999999998e-40 | NR | AFX73090.1 | 160823 | g159834 | i0 | 90.7 | 0.982532751091703 | 75 | 7 | 98.3 | 0 | 227 | 3 | 54 | 128 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 225 | 143 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense |
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);;