contig_metadata
19 rows where bioproject = "PRJNA662254", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1904407 | 1904407 | PRJNA662254_P_NODE_38902_length_269_cov_1.311224_g38251_i0 | PRJNA662254 | 38902 | 269 | 1.311224 | 3.52719256 | Arcella discoides | 1078856 | Tubulinea | other_Eukaryota | 287 | 6.21e-73 | NTclustered | gi|345452540|gb|JF694288.1| | 1078856 | g38251 | i0 | 86.364 | 81.2973977695167 | 264 | 34 | 98 | 2 | 3 | 265 | 437 | 699 | Arcella discoides isolate DL3_98 clone 2 actin gene, partial cds | blastn | 21869 | 287 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella discoides | ||
| 1904472 | 1904472 | PRJNA662254_P_NODE_53642_length_247_cov_0.885057_g52991_i0 | PRJNA662254 | 53642 | 247 | 0.885057 | 2.18609079 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 302 | 2.01e-77 | NTclustered | gi|167859728|gb|EU273444.1| | 497998 | g52991 | i0 | 90.789 | 60.1578947368421 | 228 | 17 | 91 | 3 | 22 | 247 | 1000 | 775 | Arcella hemisphaerica alpha-tubulin gene, partial cds | blastn | 14859 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 3179334 | 3179334 | PRJNA662254_P_NODE_9903_length_529_cov_1.432018_g9255_i0 | PRJNA662254 | 9903 | 529 | 1.432018 | 7.57537522 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 194 | 4.33e-57 | NR | AAD37351.1 | 5775 | g9255 | i0 | 76.4 | 0.720226843100189 | 127 | 28 | 72 | 2 | 436 | 56 | 86 | 210 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 381 | 194 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 4456109 | 4456109 | PRJNA662254_P_NODE_1204_length_1592_cov_7.714944_g939_i2 | PRJNA662254 | 1204 | 1592 | 7.714944 | 122.82190848 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 780 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g939 | i2 | 77.19 | 7.01570351758794 | 1381 | 287 | 85 | 21 | 26 | 1383 | 1 | 1376 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 11169 | 780 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 4990243 | 4990243 | PRJNA662254_P_NODE_53324_length_247_cov_0.885057_g52673_i0 | PRJNA662254 | 53324 | 247 | 0.885057 | 2.18609079 | Leptomyxida | 66524 | Tubulinea | other_Eukaryota | 455 | 1.4600000000000002e-123 | NTclustered | gi|11527305|gb|AF293898.1|AF293898 | 136456 | g52673 | i0 | 100 | 83.7085020242915 | 246 | 0 | 99 | 0 | 2 | 247 | 1335 | 1580 | Leptomyxa reticulata small subunit ribosomal RNA gene, complete sequence | blastn | 20676 | 455 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Leptomyxidae | Leptomyxa | Leptomyxa reticulata | ||
| 7539873 | 7539873 | PRJNA662254_P_NODE_7706_length_609_cov_10.294776_g7078_i0 | PRJNA662254 | 7706 | 609 | 10.294776 | 62.69518584 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 1092 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g7078 | i0 | 99.015 | 83.2692939244663 | 609 | 6 | 100 | 0 | 1 | 609 | 1784 | 1176 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 50711 | 1092 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 8281390 | 8281390 | PRJNA662254_P_NODE_1187_length_1605_cov_7.834204_g939_i0 | PRJNA662254 | 1187 | 1605 | 7.834204 | 125.7389742 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 1.6300000000000002e-276 | NR | BAN33737.1 | 931554 | g939 | i0 | 81.3 | 3.42803738317757 | 464 | 81 | 85.6 | 1 | 39 | 1412 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5502 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 9556798 | 9556798 | PRJNA662254_P_NODE_42128_length_258_cov_3.583784_g41477_i0 | PRJNA662254 | 42128 | 258 | 3.583784 | 9.24616272 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 200 | 7.93e-47 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g41477 | i0 | 80.899 | 4.35271317829457 | 267 | 40 | 100 | 9 | 1 | 258 | 2540 | 2804 | Rhizamoeba saxonica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1123 | 200 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 9556827 | 9556827 | PRJNA662254_P_NODE_4768_length_800_cov_1.415406_g4208_i0 | PRJNA662254 | 4768 | 800 | 1.415406 | 11.323248 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 404 | 4.09e-137 | NR | BAN33737.1 | 931554 | g4208 | i0 | 72 | 2.01375 | 271 | 71 | 99.8 | 1 | 2 | 799 | 173 | 443 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1611 | 404 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 12641189 | 12641189 | PRJNA662254_P_NODE_6490_length_670_cov_4.966499_g5877_i0 | PRJNA662254 | 6490 | 670 | 4.966499 | 33.2755433 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 562 | 2.49e-155 | NTclustered | gi|33946352|gb|AY294155.1| | 242547 | g5877 | i0 | 83.811 | 88.6402985074627 | 593 | 92 | 88 | 4 | 80 | 670 | 1124 | 534 | Glaeseria mira actin mRNA, partial cds | blastn | 59389 | 566 | 0.992932862190813 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Glaeseria | Glaeseria mira | ||
| 13382313 | 13382313 | PRJNA662254_P_NODE_2691_length_1087_cov_3.196252_g2274_i0 | PRJNA662254 | 2691 | 1087 | 3.196252 | 34.74325924 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 555 | 2.949999999999999e-196 | NR | AAP88974.1 | 5775 | g2274 | i0 | 76.7 | 0.97148114075437 | 352 | 80 | 97.1 | 1 | 1087 | 32 | 40 | 389 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1056 | 555 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 13382443 | 13382443 | PRJNA662254_P_NODE_56571_length_245_cov_1.360465_g55920_i0 | PRJNA662254 | 56571 | 245 | 1.360465 | 3.33313925 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 119 | 2.15e-22 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g55920 | i0 | 76.21 | 1.01224489795918 | 248 | 45 | 100 | 13 | 1 | 245 | 3708 | 3944 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 248 | 119 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 16464804 | 16464804 | PRJNA662254_P_NODE_8793_length_566_cov_11.989858_g8153_i0 | PRJNA662254 | 8793 | 566 | 11.989858 | 67.86259628 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 990 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g8153 | i0 | 98.233 | 64.2932862190813 | 566 | 10 | 100 | 0 | 1 | 566 | 1132 | 567 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 36390 | 996 | 0.993975903614458 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 18480736 | 18480736 | PRJNA662254_P_NODE_54535_length_246_cov_1.780347_g53884_i0 | PRJNA662254 | 54535 | 246 | 1.780347 | 4.37965362 | Euamoebida | 180229 | Tubulinea | other_Eukaryota | 121 | 1.22e-31 | NR | AFX73090.1 | 160823 | g53884 | i0 | 70 | 2.9390243902439 | 80 | 24 | 97.6 | 0 | 245 | 6 | 170 | 249 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 723 | 121 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 19755155 | 19755155 | PRJNA662254_P_NODE_1196_length_1601_cov_8.021597_g939_i1 | PRJNA662254 | 1196 | 1601 | 8.021597 | 128.42576797 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 1.1e-276 | NR | BAN33737.1 | 931554 | g939 | i1 | 81.3 | 3.4366021236727 | 464 | 81 | 85.8 | 1 | 35 | 1408 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 5502 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 22305525 | 22305525 | PRJNA662254_P_NODE_26978_length_318_cov_1.885714_g26327_i0 | PRJNA662254 | 26978 | 318 | 1.885714 | 5.99657052 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 199 | 7.97e-62 | NR | ACA04822.1 | 497998 | g26327 | i0 | 90.6 | 1 | 106 | 10 | 100 | 0 | 1 | 318 | 96 | 201 | ACA04822.1 alpha-tubulin, partial [Arcella hemisphaerica] | diamond | 318 | 199 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 22305722 | 22305722 | PRJNA662254_P_NODE_8378_length_582_cov_0.886051_g7744_i0 | PRJNA662254 | 8378 | 582 | 0.886051 | 5.15681682 | Ptolemeba bulliensis | 1525729 | Tubulinea | other_Eukaryota | 952 | 0 | NTclustered | gi|1255287465|dbj|LC272073.1| | 1525729 | g7744 | i0 | 96.392 | 75.0567010309278 | 582 | 14 | 100 | 7 | 1 | 582 | 604 | 1178 | Ptolemeba bulliensis gene for 18S ribosomal RNA, partial sequence, strain: BA02 | blastn | 43683 | 952 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba bulliensis | ||
| 27334454 | 27334454 | PRJNA662254_P_NODE_25183_length_329_cov_1.296875_g24532_i0 | PRJNA662254 | 25183 | 329 | 1.296875 | 4.26671875 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 135 | 2.7899999999999997e-35 | NR | AAD37351.1 | 5775 | g24532 | i0 | 82.3 | 0.720364741641337 | 79 | 14 | 72 | 0 | 4 | 240 | 132 | 210 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 237 | 135 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32906041 | 32906041 | PRJNA662254_P_NODE_25540_length_327_cov_1.161417_g24889_i0 | PRJNA662254 | 25540 | 327 | 1.161417 | 3.79783359 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 112 | 1.37e-26 | NR | AAD37351.1 | 5775 | g24889 | i0 | 74.3 | 2.6697247706422 | 74 | 19 | 67.9 | 0 | 222 | 1 | 275 | 348 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 873 | 112 | 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);;