contig_metadata
24 rows where bioproject = "PRJNA690592", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1947886 | 1947886 | PRJNA690592_S_NODE_6002_length_1117_cov_2.328544_g5442_i0 | PRJNA690592 | 6002 | 1117 | 2.328544 | 26.00983648 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 513 | 1.66e-179 | NR | AAP88974.1 | 5775 | g5442 | i0 | 74.9 | 5.23992837958818 | 323 | 81 | 86.8 | 0 | 1 | 969 | 66 | 388 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 5853 | 516 | 0.994186046511628 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 1948154 | 1948154 | PRJNA690592_S_NODE_9762_length_918_cov_8.375148_g9029_i0 | PRJNA690592 | 9762 | 918 | 8.375148 | 76.88385864 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 280 | 1.4799999999999999e-90 | NR | AAY21191.1 | 5778 | g9029 | i0 | 61.8 | 0.777777777777778 | 238 | 88 | 77.8 | 2 | 796 | 83 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 714 | 280 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7049627 | 7049627 | PRJNA690592_S_NODE_144866_length_281_cov_1.480769_g143852_i0 | PRJNA690592 | 144866 | 281 | 1.480769 | 4.16096089 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 106 | 1.96e-18 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g143852 | i0 | 87.912 | 0.647686832740214 | 91 | 10 | 32 | 1 | 1 | 91 | 19957 | 19868 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 182 | 106 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 7557007 | 7557007 | PRJNA690592_S_NODE_76346_length_366_cov_1.979522_g75332_i0 | PRJNA690592 | 76346 | 366 | 1.979522 | 7.24505052 | Echinamoeba | 136449 | Tubulinea | other_Eukaryota | 586 | 7.699999999999998e-163 | NTclustered | gi|165968562|gb|EU377602.1| | 136450 | g75332 | i0 | 95.628 | 70.8032786885246 | 366 | 15 | 100 | 1 | 1 | 366 | 388 | 24 | Echinamoeba exundans strain CRIB40 18S ribosomal RNA gene, partial sequence | blastn | 25914 | 586 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 8325215 | 8325215 | PRJNA690592_S_NODE_9167_length_942_cov_5.329114_g8454_i0 | PRJNA690592 | 9167 | 942 | 5.329114 | 50.20025388 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 283 | 1.25e-91 | NR | AAY21191.1 | 5778 | g8454 | i0 | 63.1 | 0.751592356687898 | 236 | 86 | 75.2 | 1 | 121 | 828 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 708 | 283 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9600416 | 9600416 | PRJNA690592_S_NODE_72788_length_374_cov_1.279070_g71774_i0 | PRJNA690592 | 72788 | 374 | 1.27907 | 4.7837218 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 198 | 1.1199999999999999e-60 | NR | AFX84545.1 | 5778 | g71774 | i0 | 75 | 10.9171122994652 | 124 | 31 | 99.5 | 0 | 372 | 1 | 22 | 145 | AFX84545.1 alpha tubulin, partial [Vermamoeba vermiformis] | diamond | 4083 | 199 | 0.994974874371859 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10876133 | 10876133 | PRJNA690592_S_NODE_88249_length_344_cov_4.904059_g87235_i0 | PRJNA690592 | 88249 | 344 | 4.904059 | 16.86996296 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 636 | 7.059999999999998e-178 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g87235 | i0 | 100 | 81.2761627906977 | 344 | 0 | 100 | 0 | 1 | 344 | 380 | 37 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 27959 | 636 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 13425318 | 13425318 | PRJNA690592_S_NODE_210751_length_242_cov_2.485207_g209737_i0 | PRJNA690592 | 210751 | 242 | 2.485207 | 6.01420094 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 219 | 2.0299999999999993e-52 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g209737 | i0 | 83.133 | 37.9214876033058 | 249 | 33 | 100 | 9 | 1 | 242 | 1363 | 1609 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 9177 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 13425563 | 13425563 | PRJNA690592_S_NODE_40351_length_482_cov_33.630807_g39337_i0 | PRJNA690592 | 40351 | 482 | 33.630807 | 162.10048974 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 154 | 1.2499999999999998e-32 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g39337 | i0 | 82.011 | 42.2406639004149 | 189 | 27 | 38 | 7 | 298 | 482 | 4309 | 4124 | 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 | 20360 | 154 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 18523633 | 18523633 | PRJNA690592_S_NODE_29155_length_559_cov_2.314815_g28156_i0 | PRJNA690592 | 29155 | 559 | 2.314815 | 12.93981585 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 621 | 3.3499999999999986e-173 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g28156 | i0 | 87.64 | 40.0232558139535 | 534 | 66 | 96 | 0 | 24 | 557 | 576 | 43 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 22373 | 621 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 21073976 | 21073976 | PRJNA690592_S_NODE_2117_length_1606_cov_8.810176_g1821_i0 | PRJNA690592 | 2117 | 1606 | 8.810176 | 141.49142656 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 769 | 2.4e-276 | NR | BAN33737.1 | 931554 | g1821 | i0 | 81.2 | 2.57036114570361 | 463 | 81 | 85.4 | 1 | 1572 | 202 | 1 | 463 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 4128 | 769 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 21074036 | 21074036 | PRJNA690592_S_NODE_220757_length_217_cov_5.875000_g219743_i0 | PRJNA690592 | 220757 | 217 | 5.875 | 12.74875 | Nolandella sp. ATCC PRA-27 | 498006 | Tubulinea | other_Eukaryota | 318 | 1.71e-82 | NTclustered | gi|167859744|gb|EU273453.1| | 498006 | g219743 | i0 | 93.119 | 105.751152073733 | 218 | 13 | 100 | 2 | 1 | 217 | 352 | 136 | Nolandella sp. ATCC PRA-27 clone 2 actin gene, partial cds | blastn | 22948 | 318 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Nolandella | Nolandella sp. ATCC PRA-27 | ||
| 21581160 | 21581160 | PRJNA690592_S_NODE_145617_length_280_cov_2.594203_g144603_i0 | PRJNA690592 | 145617 | 280 | 2.594203 | 7.2637684 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 291 | 5.02e-74 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g144603 | i0 | 98.193 | 34.0107142857143 | 166 | 3 | 59 | 0 | 115 | 280 | 1808 | 1643 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 9523 | 291 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 22348143 | 22348143 | PRJNA690592_S_NODE_11898_length_843_cov_3.467532_g11095_i0 | PRJNA690592 | 11898 | 843 | 3.467532 | 29.23129476 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 423 | 2.439999999999999e-145 | NR | AAP88974.1 | 5775 | g11095 | i0 | 78.2 | 0.9644128113879 | 271 | 56 | 96.1 | 2 | 841 | 32 | 122 | 390 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 813 | 423 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 22349342 | 22349342 | PRJNA690592_S_NODE_79698_length_359_cov_3.290210_g78684_i0 | PRJNA690592 | 79698 | 359 | 3.29021 | 11.8118539 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 658 | 0 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g78684 | i0 | 99.721 | 73.3983286908078 | 359 | 1 | 100 | 0 | 1 | 359 | 949 | 591 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 26350 | 658 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 24130964 | 24130964 | PRJNA690592_S_NODE_47459_length_449_cov_4.095745_g46445_i0 | PRJNA690592 | 47459 | 449 | 4.095745 | 18.38989505 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 821 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g46445 | i0 | 99.776 | 96.0178173719376 | 447 | 1 | 99 | 0 | 3 | 449 | 1201 | 1647 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 43112 | 821 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 24897867 | 24897867 | PRJNA690592_S_NODE_26220_length_588_cov_3.308738_g25228_i0 | PRJNA690592 | 26220 | 588 | 3.308738 | 19.45537944 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 555 | 3.6299999999999997e-153 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g25228 | i0 | 83.871 | 4.14625850340136 | 589 | 87 | 99 | 7 | 4 | 588 | 753 | 1337 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2438 | 555 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28345716 | 28345716 | PRJNA690592_S_NODE_173866_length_259_cov_1.241935_g172852_i0 | PRJNA690592 | 173866 | 259 | 1.241935 | 3.21661165 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 117 | 1.61e-30 | NR | ABD46545.1 | 5778 | g172852 | i0 | 72.7 | 0.891891891891892 | 77 | 21 | 89.2 | 0 | 28 | 258 | 116 | 192 | ABD46545.1 aldehyde dehydrogenase, partial [Vermamoeba vermiformis] | diamond | 231 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28377163 | 28377163 | PRJNA690592_S_NODE_11066_length_869_cov_4.407035_g10282_i0 | PRJNA690592 | 11066 | 869 | 4.407035 | 38.29713415 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 191 | 2.03e-57 | NR | ABD72565.1 | 5778 | g10282 | i0 | 65 | 0.472957422324511 | 137 | 48 | 47.3 | 0 | 729 | 319 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 411 | 191 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 28472218 | 28472218 | PRJNA690592_S_NODE_23806_length_615_cov_2.872694_g22818_i0 | PRJNA690592 | 23806 | 615 | 2.872694 | 17.6670681 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 163 | 6.789999999999998e-48 | NR | ABD72565.1 | 5778 | g22818 | i0 | 56.1 | 0.678048780487805 | 139 | 59 | 67.8 | 1 | 139 | 555 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 417 | 163 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29103707 | 29103707 | PRJNA690592_S_NODE_214788_length_241_cov_1.226190_g213774_i0 | PRJNA690592 | 214788 | 241 | 1.22619 | 2.9551179 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 47.8 | 5.48e-4 | NR | AKN09692.1 | 5775 | g213774 | i0 | 32.9 | 0.983402489626556 | 79 | 51 | 95.9 | 1 | 6 | 236 | 149 | 227 | AKN09692.1 Tom40 [Amoeba proteus] | diamond | 237 | 47.8 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 29135362 | 29135362 | PRJNA690592_S_NODE_194849_length_248_cov_0.880000_g193835_i0 | PRJNA690592 | 194849 | 248 | 0.88 | 2.1824 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 120 | 1.71e-31 | NR | ADM22175.1 | 497998 | g193835 | i0 | 74.6 | 0.858870967741935 | 71 | 18 | 85.9 | 0 | 35 | 247 | 154 | 224 | ADM22175.1 actin, partial [Arcella hemisphaerica] | diamond | 213 | 120 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 29956043 | 29956043 | PRJNA690592_S_NODE_105811_length_320_cov_1.870445_g104797_i0 | PRJNA690592 | 105811 | 320 | 1.870445 | 5.985424 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 117 | 1.48e-28 | NR | BAN33737.1 | 931554 | g104797 | i0 | 89.1 | 1.2375 | 64 | 7 | 60 | 0 | 5 | 196 | 401 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 396 | 117 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 32169150 | 32169150 | PRJNA690592_S_NODE_194338_length_248_cov_1.320000_g193324_i0 | PRJNA690592 | 194338 | 248 | 1.32 | 3.2736 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 114 | 2.6e-27 | NR | AKN09691.1 | 5775 | g193324 | i0 | 59.3 | 1.97177419354839 | 81 | 32 | 98 | 1 | 5 | 247 | 594 | 673 | AKN09691.1 Tom70 [Amoeba proteus] | diamond | 489 | 114 | 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);;