contig_metadata
8 rows where bioproject = "PRJNA1174234", tax_clade = "Metamonada" and tax_phylum = "Preaxostyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17618730 | 17618730 | PRJNA1174234_P_NODE_19634_length_311_cov_1.890756_g19438_i0 | PRJNA1174234 | 19634 | 311 | 1.890756 | 5.88025116 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 106 | 5.56e-27 | NR | KAJ4458621.1 | 342808 | g19438 | i0 | 67.1 | 2.85530546623794 | 76 | 25 | 73.3 | 0 | 2 | 229 | 2 | 77 | KAJ4458621.1 putative 40S ribosomal protein S16-1 [Paratrimastix pyriformis] | diamond | 888 | 106 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 18167750 | 18167750 | PRJNA1174234_P_NODE_27955_length_257_cov_1.255435_g27759_i0 | PRJNA1174234 | 27955 | 257 | 1.255435 | 3.22646795 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 60.2 | 1.4e-4 | NTclustered | gi|2794970009|ref|XM_067877330.1| | 2049356 | g27759 | i0 | 88.235 | 0.634241245136187 | 51 | 4 | 19 | 2 | 207 | 255 | 3203 | 3253 | Monocercomonoides exilis DNA repair endonuclease XPF (MONOS_7037), partial mRNA | blastn | 163 | 60.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 24542029 | 24542029 | PRJNA1174234_P_NODE_14140_length_366_cov_1.433447_g13944_i0 | PRJNA1174234 | 14140 | 366 | 1.433447 | 5.24641602 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 190 | 7.35e-60 | NR | KAJ4457095.1 | 342808 | g13944 | i0 | 68.6 | 9.91803278688525 | 121 | 38 | 99.2 | 0 | 3 | 365 | 3 | 123 | KAJ4457095.1 putative 40S ribosomal protein S15a [Paratrimastix pyriformis] | diamond | 3630 | 191 | 0.994764397905759 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27565071 | 27565071 | PRJNA1174234_P_NODE_17924_length_325_cov_1.833333_g17728_i0 | PRJNA1174234 | 17924 | 325 | 1.833333 | 5.95833225 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 106 | 2.65e-26 | NR | KAJ4455598.1 | 342808 | g17728 | i0 | 50 | 2.54769230769231 | 98 | 49 | 90.5 | 0 | 2 | 295 | 33 | 130 | KAJ4455598.1 putative 40S ribosomal protein S19-1 [Paratrimastix pyriformis] | diamond | 828 | 106 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29503581 | 29503581 | PRJNA1174234_P_NODE_32950_length_245_cov_0.895349_g32754_i0 | PRJNA1174234 | 32950 | 245 | 0.895349 | 2.19360505 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 97.4 | 2.09e-21 | NR | KAJ4462630.1 | 342808 | g32754 | i0 | 51.4 | 0.906122448979592 | 74 | 33 | 90.6 | 1 | 245 | 24 | 316 | 386 | KAJ4462630.1 putative E3 ubiquitin-protein ligase arih1 [Paratrimastix pyriformis] | diamond | 222 | 97.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30925432 | 30925432 | PRJNA1174234_P_NODE_12734_length_386_cov_0.977636_g12538_i0 | PRJNA1174234 | 12734 | 386 | 0.977636 | 3.77367496 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 80.9 | 1.77e-15 | NR | KAA6375409.1 | 222440 | g12538 | i0 | 40.4 | 0.886010362694301 | 114 | 65 | 87 | 3 | 370 | 35 | 5 | 117 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 342 | 80.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32336232 | 32336232 | PRJNA1174234_P_NODE_18159_length_323_cov_1.732000_g17963_i0 | PRJNA1174234 | 18159 | 323 | 1.732 | 5.59436 | root | 1 | Root_unresolved | Root_unresolved | 111 | 2.26e-29 | NR | KAA6379614.1 | 222440 | g17963 | i0 | 58.2 | 2.51702786377709 | 91 | 38 | 84.5 | 0 | 2 | 274 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 813 | 111 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32620460 | 32620460 | PRJNA1174234_P_NODE_34000_length_243_cov_1.358824_g33804_i0 | PRJNA1174234 | 34000 | 243 | 1.358824 | 3.30194232 | root | 1 | Root_unresolved | Root_unresolved | 97.4 | 1.9e-21 | NR | KAJ4457301.1 | 342808 | g33804 | i0 | 60.3 | 1.66666666666667 | 68 | 27 | 84 | 0 | 205 | 2 | 429 | 496 | KAJ4457301.1 putative Delta-1-pyrroline-5-carboxylate dehydrogenase 12A1 [Paratrimastix pyriformis] | diamond | 405 | 97.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis |
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);;