contig_metadata
12 rows where bioproject = "PRJNA744060", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2473891 | 2473891 | PRJNA744060_P_NODE_39102_length_265_cov_9.307292_g38773_i0 | PRJNA744060 | 39102 | 265 | 9.307292 | 24.6643238 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 479 | 9.38e-131 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g38773 | i0 | 99.245 | 38.1509433962264 | 265 | 2 | 100 | 0 | 1 | 265 | 3603 | 3867 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 10110 | 479 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 9651795 | 9651795 | PRJNA744060_P_NODE_33688_length_284_cov_1.236967_g33359_i0 | PRJNA744060 | 33688 | 284 | 1.236967 | 3.51298628 | Ptolemeba noxubium | 1525730 | Tubulinea | other_Eukaryota | 503 | 6.02e-138 | NTclustered | gi|667752761|gb|KJ542110.1| | 1525730 | g33359 | i0 | 98.592 | 89.3098591549296 | 284 | 4 | 100 | 0 | 1 | 284 | 1417 | 1134 | Ptolemeba noxubium isolate Nx13-1c 18S ribosomal RNA gene, partial sequence | blastn | 25364 | 503 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba noxubium | ||
| 10127170 | 10127170 | PRJNA744060_P_NODE_28528_length_305_cov_4.827586_g28199_i0 | PRJNA744060 | 28528 | 305 | 4.827586 | 14.7241373 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 564 | 2.95e-156 | NTclustered | gi|418968559|gb|KC164244.1| | 5778 | g28199 | i0 | 100 | 100 | 305 | 0 | 100 | 0 | 1 | 305 | 68 | 372 | Vermamoeba vermiformis clone CF3-181 18S ribosomal RNA gene, partial sequence | blastn | 30500 | 564 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 11402273 | 11402273 | PRJNA744060_P_NODE_6229_length_634_cov_10.857398_g5909_i0 | PRJNA744060 | 6229 | 634 | 10.857398 | 68.83590332 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1133 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g5909 | i0 | 98.896 | 77.981072555205 | 634 | 7 | 100 | 0 | 1 | 634 | 5550 | 4917 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 49440 | 1133 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13477575 | 13477575 | PRJNA744060_P_NODE_9391_length_522_cov_2.681514_g9065_i0 | PRJNA744060 | 9391 | 522 | 2.681514 | 13.99750308 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 258 | 3.9099999999999996e-82 | NR | AAP88974.1 | 5775 | g9065 | i0 | 71.9 | 1.97126436781609 | 171 | 46 | 98.3 | 1 | 9 | 521 | 71 | 239 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1029 | 258 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 14752461 | 14752461 | PRJNA744060_P_NODE_47312_length_247_cov_9.126437_g46983_i0 | PRJNA744060 | 47312 | 247 | 9.126437 | 22.54229939 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 446 | 8.759999999999998e-121 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g46983 | i0 | 99.19 | 3.06882591093117 | 247 | 2 | 100 | 0 | 1 | 247 | 3671 | 3425 | Hartmannella vermiformis 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 | 758 | 446 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16025583 | 16025583 | PRJNA744060_P_NODE_16093_length_401_cov_1.929878_g15764_i0 | PRJNA744060 | 16093 | 401 | 1.929878 | 7.73881078 | Ptolemeba noxubium | 1525730 | Tubulinea | other_Eukaryota | 621 | 2.3399999999999996e-173 | NTclustered | gi|667752760|gb|KJ542109.1| | 1525730 | g15764 | i0 | 98.854 | 76.2468827930175 | 349 | 3 | 87 | 1 | 1 | 348 | 1380 | 1728 | Ptolemeba noxubium isolate Nx13-1a 18S ribosomal RNA gene, partial sequence | blastn | 30575 | 621 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Ptolemeba | Ptolemeba noxubium | ||
| 17301103 | 17301103 | PRJNA744060_P_NODE_16414_length_397_cov_3.388889_g16085_i0 | PRJNA744060 | 16414 | 397 | 3.388889 | 13.45388933 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 189 | 2.7799999999999992e-43 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g16085 | i0 | 85.405 | 44.1511335012594 | 185 | 23 | 46 | 4 | 1 | 183 | 4128 | 4310 | 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 | 17528 | 189 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 21126196 | 21126196 | PRJNA744060_P_NODE_53397_length_231_cov_8.531646_g53068_i0 | PRJNA744060 | 53397 | 231 | 8.531646 | 19.70810226 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 427 | 2.9399999999999998e-115 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g53068 | i0 | 100 | 100.47619047619 | 231 | 0 | 100 | 0 | 1 | 231 | 4892 | 4662 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 23210 | 427 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24949498 | 24949498 | PRJNA744060_P_NODE_1640_length_1149_cov_4.878253_g1456_i0 | PRJNA744060 | 1640 | 1149 | 4.878253 | 56.05112697 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 530 | 1.77e-184 | NR | BAN33737.1 | 931554 | g1456 | i0 | 77.1 | 3.45169712793734 | 336 | 71 | 86.2 | 1 | 1148 | 159 | 129 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 3966 | 530 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 29336437 | 29336437 | PRJNA744060_P_NODE_5829_length_655_cov_2.761168_g5512_i0 | PRJNA744060 | 5829 | 655 | 2.761168 | 18.0856504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 206 | 4.8399999999999994e-61 | NR | AAD37351.1 | 5775 | g5512 | i0 | 58 | 2.01068702290076 | 219 | 89 | 99.8 | 3 | 2 | 655 | 150 | 366 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 1317 | 206 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32085774 | 32085774 | PRJNA744060_P_NODE_23798_length_333_cov_1.038462_g23469_i0 | PRJNA744060 | 23798 | 333 | 1.038462 | 3.45807846 | Euamoebida | 180229 | Tubulinea | other_Eukaryota | 145 | 2.0099999999999998e-40 | NR | AFX73090.1 | 160823 | g23469 | i0 | 62.7 | 1.98198198198198 | 110 | 36 | 99.1 | 2 | 2 | 331 | 62 | 166 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 660 | 145 | 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);;