contig_metadata
15 rows where bioproject = "PRJNA613025" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1867771 | 1867771 | PRJNA613025_S_NODE_23882_length_194_cov_2.110345_g23728_i0 | PRJNA613025 | 23882 | 194 | 2.110345 | 4.0940693 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 348 | 1.91e-91 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g23728 | i0 | 98.969 | 82.9690721649485 | 194 | 2 | 100 | 0 | 1 | 194 | 1757 | 1564 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 16096 | 348 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 4976843 | 4976843 | PRJNA613025_S_NODE_11504_length_351_cov_1.821192_g11350_i0 | PRJNA613025 | 11504 | 351 | 1.821192 | 6.39238392 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 632 | 9.309999999999999e-177 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g11350 | i0 | 99.145 | 40.022792022792 | 351 | 3 | 100 | 0 | 1 | 351 | 5472 | 5122 | 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 | 14048 | 632 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 5695449 | 5695449 | PRJNA613025_S_NODE_27645_length_176_cov_1.606299_g27491_i0 | PRJNA613025 | 27645 | 176 | 1.606299 | 2.82708624 | Cryptodifflugia oviformis | 1165352 | Tubulinea | other_Eukaryota | 303 | 3.71e-78 | NTclustered | gi|2517949732|gb|OR125031.1| | 1165352 | g27491 | i0 | 97.74 | 54.0056818181818 | 177 | 2 | 100 | 2 | 1 | 176 | 1467 | 1642 | Cryptodifflugia oviformis isolate strain_6 small subunit ribosomal RNA gene, partial sequence | blastn | 9505 | 303 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia oviformis | ||
| 8244944 | 8244944 | PRJNA613025_S_NODE_26747_length_180_cov_1.526718_g26593_i0 | PRJNA613025 | 26747 | 180 | 1.526718 | 2.7480924 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 326 | 8.15e-85 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g26593 | i0 | 99.441 | 85.7277777777778 | 179 | 1 | 99 | 0 | 1 | 179 | 19995 | 20173 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 15431 | 326 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 10795982 | 10795982 | PRJNA613025_S_NODE_21269_length_210_cov_2.217391_g21115_i0 | PRJNA613025 | 21269 | 210 | 2.217391 | 4.6565211 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 239 | 1.32e-58 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g21115 | i0 | 87.619 | 1 | 210 | 21 | 100 | 5 | 1 | 210 | 3995 | 4199 | 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 | 210 | 239 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 12627751 | 12627751 | PRJNA613025_S_NODE_15570_length_270_cov_2.235294_g15416_i0 | PRJNA613025 | 15570 | 270 | 2.235294 | 6.0352938 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 488 | 1.5899999999999995e-133 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g15416 | i0 | 99.259 | 37.5555555555556 | 270 | 2 | 100 | 0 | 1 | 270 | 3598 | 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 | 10140 | 488 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14620774 | 14620774 | PRJNA613025_S_NODE_24512_length_191_cov_1.394366_g24358_i0 | PRJNA613025 | 24512 | 191 | 1.394366 | 2.66323906 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 134 | 5.7e-27 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g24358 | i0 | 80 | 1.1151832460733 | 185 | 34 | 95 | 1 | 3 | 184 | 2920 | 2736 | 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 | 213 | 134 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 15894515 | 15894515 | PRJNA613025_S_NODE_14393_length_289_cov_2.283333_g14239_i0 | PRJNA613025 | 14393 | 289 | 2.283333 | 6.59883237 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 534 | 2.18e-147 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g14239 | i0 | 100 | 98.2975778546713 | 289 | 0 | 100 | 0 | 1 | 289 | 1259 | 971 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 28408 | 534 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 17169582 | 17169582 | PRJNA613025_S_NODE_19854_length_221_cov_1.633721_g19700_i0 | PRJNA613025 | 19854 | 221 | 1.633721 | 3.61052341 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 265 | 2.3099999999999997e-66 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g19700 | i0 | 90.196 | 57.2171945701357 | 204 | 19 | 92 | 1 | 19 | 221 | 3642 | 3845 | 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 | 12645 | 265 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 17169705 | 17169705 | PRJNA613025_S_NODE_25214_length_187_cov_1.797101_g25060_i0 | PRJNA613025 | 25214 | 187 | 1.797101 | 3.36057887 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 265 | 1.89e-66 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g25060 | i0 | 94.706 | 57.8663101604278 | 170 | 9 | 91 | 0 | 2 | 171 | 4428 | 4259 | 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 | 10821 | 265 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 19718042 | 19718042 | PRJNA613025_S_NODE_11836_length_343_cov_1.986395_g11682_i0 | PRJNA613025 | 11836 | 343 | 1.986395 | 6.81333485 | Tubulinea sp. 4388 | 1216001 | Tubulinea | other_Eukaryota | 628 | 1.1799999999999997e-175 | NTclustered | gi|399764265|gb|JQ271776.1| | 1216001 | g11682 | i0 | 99.708 | 4.99125364431487 | 343 | 1 | 100 | 0 | 1 | 343 | 967 | 625 | Tubulinea sp. 4388 18S ribosomal RNA gene, partial sequence | blastn | 1712 | 628 | 1 | Eukaryota | Amoebozoa | Tubulinea | Tubulinea sp. 4388 | ||||||
| 20993772 | 20993772 | PRJNA613025_S_NODE_11257_length_357_cov_2.201299_g11103_i0 | PRJNA613025 | 11257 | 357 | 2.201299 | 7.85863743 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 632 | 9.489999999999998e-177 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g11103 | i0 | 98.599 | 42.6750700280112 | 357 | 5 | 100 | 0 | 1 | 357 | 6699 | 7055 | 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 | 15235 | 632 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22269044 | 22269044 | PRJNA613025_S_NODE_27678_length_176_cov_1.409449_g27524_i0 | PRJNA613025 | 27678 | 176 | 1.409449 | 2.48063024 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 291 | 2.89e-74 | NTclustered | gi|89243421|gb|DQ407552.1| | 5778 | g27524 | i0 | 96.571 | 99.4318181818182 | 175 | 6 | 99 | 0 | 2 | 176 | 432 | 258 | Hartmannella vermiformis isolate WWS5.5 18S ribosomal RNA gene gene, partial sequence | blastn | 17500 | 291 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24817731 | 24817731 | PRJNA613025_S_NODE_10400_length_382_cov_1.837838_g10247_i0 | PRJNA613025 | 10400 | 382 | 1.837838 | 7.02054116 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 634 | 2.8399999999999995e-177 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g10247 | i0 | 97.074 | 58.2225130890052 | 376 | 11 | 98 | 0 | 1 | 376 | 2314 | 2689 | 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 | 22241 | 634 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25375098 | 25375098 | PRJNA613025_S_NODE_21140_length_211_cov_1.641975_g20986_i0 | PRJNA613025 | 21140 | 211 | 1.641975 | 3.46456725 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 368 | 1.6200000000000002e-97 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g20986 | i0 | 98.104 | 96.8957345971564 | 211 | 4 | 100 | 0 | 1 | 211 | 5111 | 4901 | 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 | 20445 | 368 | 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);;