contig_metadata
10 rows where bioproject = "PRJNA980585", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10197937 | 10197937 | PRJNA980585_P_NODE_1668_length_901_cov_16.376812_g1454_i0 | PRJNA980585 | 1668 | 901 | 16.376812 | 147.55507612 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1493 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g1454 | i0 | 96.559 | 79.7169811320755 | 901 | 31 | 100 | 0 | 1 | 901 | 5790 | 4890 | 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 | 71825 | 1498 | 0.996662216288384 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 13708622 | 13708622 | PRJNA980585_P_NODE_4691_length_580_cov_4.895464_g4437_i0 | PRJNA980585 | 4691 | 580 | 4.895464 | 28.3936912 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 1000 | 0 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g4437 | i0 | 97.759 | 19.8137931034483 | 580 | 13 | 100 | 0 | 1 | 580 | 1210 | 1789 | 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 | 11492 | 1000 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14983094 | 14983094 | PRJNA980585_P_NODE_61472_length_237_cov_3.493902_g61218_i0 | PRJNA980585 | 61472 | 237 | 3.493902 | 8.28054774 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 97.1 | 9.69e-16 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g61218 | i0 | 87.356 | 31.3670886075949 | 87 | 7 | 37 | 2 | 1 | 87 | 4449 | 4367 | 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 | 7434 | 97.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 16257245 | 16257245 | PRJNA980585_P_NODE_10433_length_415_cov_14.938596_g10179_i0 | PRJNA980585 | 10433 | 415 | 14.938596 | 61.9951734 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 689 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g10179 | i0 | 96.643 | 36.910843373494 | 417 | 10 | 100 | 4 | 1 | 415 | 7104 | 6690 | 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 | 15318 | 689 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 17532801 | 17532801 | PRJNA980585_P_NODE_37554_length_258_cov_2.745946_g37300_i0 | PRJNA980585 | 37554 | 258 | 2.745946 | 7.08454068 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 361 | 3.44e-95 | NTclustered | gi|909719647|gb|KT185627.1| | 5778 | g37300 | i0 | 91.892 | 61.8527131782946 | 259 | 20 | 100 | 1 | 1 | 258 | 19671 | 19413 | Vermamoeba vermiformis isolate BCP-EM3VF21-2 mitochondrion, complete genome | blastn | 15958 | 361 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20081268 | 20081268 | PRJNA980585_P_NODE_32236_length_273_cov_1.860000_g31982_i0 | PRJNA980585 | 32236 | 273 | 1.86 | 5.0778 | Spumochlamys bryora | 675832 | Tubulinea | other_Eukaryota | 472 | 1.62e-128 | NTclustered | gi|259595677|gb|FJ705341.1| | 675832 | g31982 | i0 | 97.802 | 18.3736263736264 | 273 | 6 | 100 | 0 | 1 | 273 | 1621 | 1893 | Spumochlamys bryora clone 1901 18S ribosomal RNA gene, partial sequence | blastn | 5016 | 472 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys bryora | |||
| 21671718 | 21671718 | PRJNA980585_P_NODE_24137_length_300_cov_1.599119_g23883_i0 | PRJNA980585 | 24137 | 300 | 1.599119 | 4.797357 | Hyalospheniidae | 318530 | Tubulinea | other_Eukaryota | 128 | 4.51e-25 | NTclustered | gi|564112321|gb|KF476103.1| | 318532 | g23883 | i0 | 98.611 | 24.4066666666667 | 72 | 1 | 24 | 0 | 1 | 72 | 367 | 438 | Hyalosphenia papilio isolate HP_TN349_7.6 small subunit ribosomal RNA gene, partial sequence | blastn | 7322 | 128 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Hyalospheniidae | Hyalosphenia | Hyalosphenia papilio | ||
| 25181401 | 25181401 | PRJNA980585_P_NODE_8260_length_457_cov_1.187500_g8006_i0 | PRJNA980585 | 8260 | 457 | 1.1875 | 5.426875 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 211 | 2.2e-63 | NR | BAN33737.1 | 931554 | g8006 | i0 | 71.5 | 13.2800875273523 | 144 | 34 | 89.9 | 1 | 411 | 1 | 4 | 147 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 6069 | 211 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 27405625 | 27405625 | PRJNA980585_P_NODE_41643_length_251_cov_0.865169_g41389_i0 | PRJNA980585 | 41643 | 251 | 0.865169 | 2.17157419 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 95.5 | 6.41e-21 | NR | AAD37351.1 | 5775 | g41389 | i0 | 59.8 | 0.9800796812749 | 82 | 32 | 98 | 1 | 246 | 1 | 50 | 130 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 246 | 95.5 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30152284 | 30152284 | PRJNA980585_P_NODE_22852_length_307_cov_1.264957_g22598_i0 | PRJNA980585 | 22852 | 307 | 1.264957 | 3.88341799 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 123 | 6.609999999999999e-31 | NR | AAD37351.1 | 5775 | g22598 | i0 | 61.8 | 1.84690553745928 | 89 | 34 | 87 | 0 | 36 | 302 | 274 | 362 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 567 | 123 | 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);;