contig_metadata
9 rows where bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2125410 | 2125410 | PRJNA870096_S_NODE_39042_length_284_cov_3.697095_g37378_i0 | PRJNA870096 | 39042 | 284 | 3.697095 | 10.4997498 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 68.6 | 7.58e-13 | NR | KAJ4459185.1 | 342808 | g37378 | i0 | 45.2 | 1.56338028169014 | 73 | 40 | 77.1 | 0 | 50 | 268 | 1 | 73 | KAJ4459185.1 hypothetical protein PAPYR_4991 [Paratrimastix pyriformis] | diamond | 444 | 68.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 13603674 | 13603674 | PRJNA870096_S_NODE_31331_length_320_cov_2.231047_g29667_i0 | PRJNA870096 | 31331 | 320 | 2.231047 | 7.1393504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 4.43e-36 | NR | KAJ4460008.1 | 342808 | g29667 | i0 | 64.4 | 31.265625 | 104 | 35 | 97.5 | 1 | 4 | 315 | 51 | 152 | KAJ4460008.1 putative Ras-related protein Rab-1A [Paratrimastix pyriformis] | diamond | 10005 | 131 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 16152759 | 16152759 | PRJNA870096_S_NODE_42913_length_270_cov_2.740088_g41249_i0 | PRJNA870096 | 42913 | 270 | 2.740088 | 7.3982376 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 63.9 | 1.14e-5 | NTclustered | gi|2794969981|ref|XM_067877343.1| | 2049356 | g41249 | i0 | 95 | 14.2777777777778 | 40 | 2 | 15 | 0 | 159 | 198 | 4633 | 4672 | Monocercomonoides exilis uncharacterized protein (MONOS_7049), partial mRNA | blastn | 3855 | 63.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 26928651 | 26928651 | PRJNA870096_S_NODE_120302_length_162_cov_1.613445_g118638_i0 | PRJNA870096 | 120302 | 162 | 1.613445 | 2.6137809 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 41.6 | 0.0332 | NR | KAA6394449.1 | 222440 | g118638 | i0 | 45.5 | 0.814814814814815 | 44 | 23 | 79.6 | 1 | 25 | 153 | 575 | 618 | KAA6394449.1 MAG: putative Serine/threonine-protein phosphatase 2A 65 kDa regulatory subunit A alpha [Streblomastix strix] | diamond | 132 | 41.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29273635 | 29273635 | PRJNA870096_S_NODE_85329_length_190_cov_1.632653_g83665_i0 | PRJNA870096 | 85329 | 190 | 1.632653 | 3.1020407 | root | 1 | Root_unresolved | Root_unresolved | 52.4 | 7.3e-6 | NR | KAJ4459703.1 | 342808 | g83665 | i0 | 39.7 | 2.05263157894737 | 63 | 35 | 99.5 | 1 | 2 | 190 | 122 | 181 | KAJ4459703.1 putative charged multivesicular body protein 6 [Paratrimastix pyriformis] | diamond | 390 | 52.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29968512 | 29968512 | PRJNA870096_S_NODE_35171_length_301_cov_1.503876_g33507_i0 | PRJNA870096 | 35171 | 301 | 1.503876 | 4.52666676 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.3 | 3.23e-6 | NR | KAJ4457143.1 | 342808 | g33507 | i0 | 37.3 | 1.54485049833887 | 83 | 52 | 82.7 | 0 | 24 | 272 | 111 | 193 | KAJ4457143.1 putative Charged multivesicular body protein 1 [Paratrimastix pyriformis] | diamond | 465 | 54.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31192259 | 31192259 | PRJNA870096_S_NODE_96575_length_179_cov_2.977941_g94911_i0 | PRJNA870096 | 96575 | 179 | 2.977941 | 5.33051439 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 60.5 | 8.54e-9 | NR | KAJ4456767.1 | 342808 | g94911 | i0 | 56.6 | 0.888268156424581 | 53 | 22 | 88.8 | 1 | 3 | 161 | 306 | 357 | KAJ4456767.1 putative Translation initiation factor eIF-2B subunit beta [Paratrimastix pyriformis] | diamond | 159 | 60.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31358980 | 31358980 | PRJNA870096_S_NODE_28636_length_335_cov_2.544521_g26972_i0 | PRJNA870096 | 28636 | 335 | 2.544521 | 8.52414535 | Oxymonadida | 66288 | Preaxostyla | other_Eukaryota | 122 | 2.65e-30 | NR | KAA6402358.1 | 222440 | g26972 | i0 | 64.6 | 2.52537313432836 | 96 | 34 | 86 | 0 | 332 | 45 | 381 | 476 | KAA6402358.1 MAG: V-type H+-transporting ATPase subunit B [Streblomastix strix] | diamond | 846 | 122 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32844374 | 32844374 | PRJNA870096_S_NODE_70580_length_208_cov_2.618182_g68916_i0 | PRJNA870096 | 70580 | 208 | 2.618182 | 5.44581856 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94.4 | 2.72e-23 | NR | KAA6393250.1 | 222440 | g68916 | i0 | 58.2 | 10.5432692307692 | 67 | 28 | 96.6 | 0 | 1 | 201 | 30 | 96 | KAA6393250.1 MAG: putative U6 snRNA-associated protein [Streblomastix strix] | diamond | 2193 | 94.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix |
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);;