contig_metadata
15 rows where bioproject = "PRJNA753704", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3282520 | 3282520 | PRJNA753704_P_NODE_7803_length_416_cov_6.212828_g7442_i0 | PRJNA753704 | 7803 | 416 | 6.212828 | 25.84536448 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 625 | 1.8799999999999998e-174 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g7442 | i0 | 93.75 | 1 | 416 | 26 | 100 | 0 | 1 | 416 | 199 | 614 | 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 | 416 | 625 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5834615 | 5834615 | PRJNA753704_P_NODE_20005_length_271_cov_81.196970_g19644_i0 | PRJNA753704 | 20005 | 271 | 81.19697 | 220.0437887 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 307 | 4.8e-79 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g19644 | i0 | 94.472 | 46.1143911439114 | 199 | 11 | 73 | 0 | 1 | 199 | 27236 | 27038 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 12497 | 307 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10130635 | 10130635 | PRJNA753704_P_NODE_11308_length_352_cov_1.677419_g10947_i0 | PRJNA753704 | 11308 | 352 | 1.677419 | 5.90451488 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 176 | 3.56e-49 | NR | YP_003540848.1 | 5778 | g10947 | i0 | 93.7 | 1.61931818181818 | 95 | 6 | 81 | 0 | 68 | 352 | 385 | 479 | YP_003540848.1 NADH dehydrogenase subunit 5 [Vermamoeba vermiformis] | diamond | 570 | 176 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13484819 | 13484819 | PRJNA753704_P_NODE_19611_length_274_cov_1.995025_g19250_i0 | PRJNA753704 | 19611 | 274 | 1.995025 | 5.4663685 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 204 | 6.569999999999999e-48 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g19250 | i0 | 80.292 | 1 | 274 | 51 | 99 | 3 | 2 | 274 | 24880 | 25151 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 274 | 204 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16033737 | 16033737 | PRJNA753704_P_NODE_26773_length_245_cov_1.813953_g26412_i0 | PRJNA753704 | 26773 | 245 | 1.813953 | 4.44418485 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 137 | 7.29e-39 | NR | YP_003540833.1 | 5778 | g26412 | i0 | 77.2 | 1.93469387755102 | 79 | 18 | 96.7 | 0 | 237 | 1 | 47 | 125 | YP_003540833.1 NADH dehydrogenase subunit 9 [Vermamoeba vermiformis] | diamond | 474 | 137 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 16033835 | 16033835 | PRJNA753704_P_NODE_7113_length_435_cov_1.781768_g6752_i0 | PRJNA753704 | 7113 | 435 | 1.781768 | 7.7506908 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 599 | 1.1999999999999995e-166 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g6752 | i0 | 96.919 | 65.216091954023 | 357 | 11 | 82 | 0 | 1 | 357 | 20630 | 20274 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 28369 | 599 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17309096 | 17309096 | PRJNA753704_P_NODE_14654_length_312_cov_6.979079_g14293_i0 | PRJNA753704 | 14654 | 312 | 6.979079 | 21.774726480000002 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 549 | 8.489999999999997e-152 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g14293 | i0 | 98.397 | 26.5865384615385 | 312 | 5 | 100 | 0 | 1 | 312 | 6746 | 7057 | 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 | 8295 | 549 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17309106 | 17309106 | PRJNA753704_P_NODE_15314_length_306_cov_4.330472_g14953_i0 | PRJNA753704 | 15314 | 306 | 4.330472 | 13.25124432 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 429 | 1.13e-115 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g14953 | i0 | 91.883 | 1.00653594771242 | 308 | 23 | 100 | 2 | 1 | 306 | 935 | 628 | 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 | 308 | 429 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17309158 | 17309158 | PRJNA753704_P_NODE_20534_length_268_cov_7.579487_g20173_i0 | PRJNA753704 | 20534 | 268 | 7.579487 | 20.31302516 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 457 | 4.45e-124 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g20173 | i0 | 97.388 | 167.481343283582 | 268 | 7 | 100 | 0 | 1 | 268 | 28352 | 28085 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 44885 | 457 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18582915 | 18582915 | PRJNA753704_P_NODE_21255_length_264_cov_3.204188_g20894_i0 | PRJNA753704 | 21255 | 264 | 3.204188 | 8.45905632 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 174 | 4.44e-51 | NR | YP_003540834.1 | 5778 | g20894 | i0 | 96.6 | 0.988636363636364 | 87 | 3 | 98.9 | 0 | 263 | 3 | 56 | 142 | YP_003540834.1 NADH dehydrogenase subunit 7 [Vermamoeba vermiformis] | diamond | 261 | 174 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 18583048 | 18583048 | PRJNA753704_P_NODE_6655_length_448_cov_1.288000_g6294_i0 | PRJNA753704 | 6655 | 448 | 1.288 | 5.77024 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 390 | 8.089999999999999e-104 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g6294 | i0 | 82.405 | 9.48883928571429 | 449 | 77 | 100 | 2 | 1 | 448 | 1184 | 1631 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 4251 | 390 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21604197 | 21604197 | PRJNA753704_P_NODE_2077_length_754_cov_12.362702_g1745_i0 | PRJNA753704 | 2077 | 754 | 12.362702 | 93.21477308 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1343 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g1745 | i0 | 98.806 | 98.0477453580902 | 754 | 9 | 100 | 0 | 1 | 754 | 4885 | 5638 | 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 | 73928 | 1343 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26926355 | 26926355 | PRJNA753704_P_NODE_27202_length_244_cov_2.701754_g26841_i0 | PRJNA753704 | 27202 | 244 | 2.701754 | 6.59227976 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 146 | 2.63e-39 | NR | YP_003540812.1 | 5778 | g26841 | i0 | 96.3 | 0.983606557377049 | 80 | 3 | 98.4 | 0 | 3 | 242 | 65 | 144 | YP_003540812.1 ATP synthase F1 subunit alpha [Vermamoeba vermiformis] | diamond | 240 | 146 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30906157 | 30906157 | PRJNA753704_P_NODE_27174_length_244_cov_3.777778_g26813_i0 | PRJNA753704 | 27174 | 244 | 3.777778 | 9.21777832 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 78.6 | 2.23e-16 | NR | YP_003540821.1 | 5778 | g26813 | i0 | 86 | 1.05737704918033 | 43 | 6 | 52.9 | 0 | 244 | 116 | 96 | 138 | YP_003540821.1 ribosomal protein L16 [Vermamoeba vermiformis] | diamond | 258 | 78.6 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32487548 | 32487548 | PRJNA753704_P_NODE_27759_length_243_cov_1.541176_g27398_i0 | PRJNA753704 | 27759 | 243 | 1.541176 | 3.74505768 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 119 | 5.459999999999999e-31 | NR | YP_003540842.1 | 5778 | g27398 | i0 | 96.9 | 0.790123456790123 | 64 | 2 | 79 | 0 | 192 | 1 | 117 | 180 | YP_003540842.1 cytochrome c oxidase subunit 3 [Vermamoeba vermiformis] | diamond | 192 | 119 | 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);;