contig_metadata
12 rows where bioproject = "PRJNA438111", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2985325 | 2985325 | PRJNA438111_P_NODE_75763_length_161_cov_1.613636_g75138_i0 | PRJNA438111 | 75763 | 161 | 1.613636 | 2.59795396 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 2.5699999999999997e-24 | NR | KAJ4456818.1 | 342808 | g75138 | i0 | 81.1 | 11.8509316770186 | 53 | 10 | 98.8 | 0 | 159 | 1 | 229 | 281 | KAJ4456818.1 putative Cell division control protein 2 [Paratrimastix pyriformis] | diamond | 1908 | 103 | 0.990291262135922 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 17011084 | 17011084 | PRJNA438111_P_NODE_15774_length_265_cov_3.038136_g15149_i0 | PRJNA438111 | 15774 | 265 | 3.038136 | 8.0510604 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 140 | 3.04e-36 | NR | KAJ4458401.1 | 342808 | g15149 | i0 | 82.6 | 1.94716981132075 | 86 | 15 | 97.4 | 0 | 264 | 7 | 796 | 881 | KAJ4458401.1 ion-transporting P-type ATPase [Paratrimastix pyriformis] | diamond | 516 | 140 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 19560258 | 19560258 | PRJNA438111_P_NODE_5556_length_419_cov_5.869231_g4974_i0 | PRJNA438111 | 5556 | 419 | 5.869231 | 24.59207789 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 108 | 9.31e-27 | NR | XP_067724052.1 | 2049356 | g4974 | i0 | 51.1 | 1.3890214797136 | 92 | 44 | 65.2 | 1 | 274 | 2 | 75 | 166 | XP_067724052.1 Thioredoxin [Monocercomonoides exilis] | diamond | 582 | 108 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27992071 | 27992071 | PRJNA438111_P_NODE_72105_length_163_cov_2.119403_g71480_i0 | PRJNA438111 | 72105 | 163 | 2.119403 | 3.45462689 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 98.2 | 7.119999999999999e-24 | NR | XP_067732094.1 | 2049356 | g71480 | i0 | 77.8 | 0.993865030674847 | 54 | 12 | 99.4 | 0 | 1 | 162 | 10 | 63 | XP_067732094.1 Rab1b [Monocercomonoides exilis] | diamond | 162 | 98.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28623607 | 28623607 | PRJNA438111_P_NODE_80987_length_157_cov_2.828125_g80362_i0 | PRJNA438111 | 80987 | 157 | 2.828125 | 4.44015625 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 72.8 | 4.3e-14 | NR | KAA6382551.1 | 222440 | g80362 | i0 | 53.8 | 2.98089171974522 | 52 | 24 | 99.4 | 0 | 1 | 156 | 50 | 101 | KAA6382551.1 MAG: putative Vacuolar protein sorting-associated protein 29 [Streblomastix strix] | diamond | 468 | 72.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28939267 | 28939267 | PRJNA438111_P_NODE_43268_length_189_cov_6.543750_g42643_i0 | PRJNA438111 | 43268 | 189 | 6.54375 | 12.3676875 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 50.8 | 2.49e-5 | NR | XP_067733932.1 | 2049356 | g42643 | i0 | 47.5 | 0.936507936507937 | 59 | 26 | 93.7 | 1 | 3 | 179 | 460 | 513 | XP_067733932.1 putative tRNA (adenine58-N1)-methyltransferase non-catalytic subunit [Monocercomonoides exilis] | diamond | 177 | 50.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29065600 | 29065600 | PRJNA438111_P_NODE_87148_length_152_cov_4.869919_g86523_i0 | PRJNA438111 | 87148 | 152 | 4.869919 | 7.40227688 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 64.7 | 1.63e-10 | NR | KAJ4461121.1 | 342808 | g86523 | i0 | 60 | 1.97368421052632 | 50 | 20 | 98.7 | 0 | 2 | 151 | 271 | 320 | KAJ4461121.1 putative Guanine nucleotide-binding protein alpha-1 subunit [Paratrimastix pyriformis] | diamond | 300 | 64.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30075832 | 30075832 | PRJNA438111_P_NODE_58192_length_173_cov_2.756944_g57567_i0 | PRJNA438111 | 58192 | 173 | 2.756944 | 4.76951312 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 46.6 | 6.42e-4 | NR | KAJ4453647.1 | 342808 | g57567 | i0 | 42.6 | 1.89017341040462 | 54 | 31 | 93.6 | 0 | 8 | 169 | 1574 | 1627 | KAJ4453647.1 phospholipid-transporting P-type ATPase [Paratrimastix pyriformis] | diamond | 327 | 46.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30265779 | 30265779 | PRJNA438111_P_NODE_19552_length_242_cov_3.436620_g18927_i0 | PRJNA438111 | 19552 | 242 | 3.43662 | 8.3166204 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 69.7 | 1.18e-11 | NR | XP_067724454.1 | 2049356 | g18927 | i0 | 43.4 | 2.82644628099174 | 76 | 43 | 94.2 | 0 | 11 | 238 | 1204 | 1279 | XP_067724454.1 putative guanine nucleotide exchange factor [Monocercomonoides exilis] | diamond | 684 | 69.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31655997 | 31655997 | PRJNA438111_P_NODE_43997_length_189_cov_1.637500_g43372_i0 | PRJNA438111 | 43997 | 189 | 1.6375 | 3.094875 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 47 | 5.73e-4 | NR | KAJ4456692.1 | 342808 | g43372 | i0 | 45.5 | 0.698412698412698 | 44 | 22 | 69.8 | 1 | 4 | 135 | 264 | 305 | KAJ4456692.1 putative Protein phosphatase 2A catalytic subunit B [Paratrimastix pyriformis] | diamond | 132 | 47 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31750948 | 31750948 | PRJNA438111_P_NODE_3697_length_510_cov_13.713098_g3182_i0 | PRJNA438111 | 3697 | 510 | 13.713098 | 69.9367998 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 65.1 | 4.21e-9 | NR | KAJ4456176.1 | 342808 | g3182 | i0 | 48.6 | 0.423529411764706 | 72 | 37 | 42.4 | 0 | 476 | 261 | 54 | 125 | KAJ4456176.1 putative histone H1/5 [Paratrimastix pyriformis] | diamond | 216 | 65.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32857027 | 32857027 | PRJNA438111_P_NODE_51060_length_180_cov_4.258278_g50435_i0 | PRJNA438111 | 51060 | 180 | 4.258278 | 7.6649004 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 53.9 | 1.87e-6 | NR | KAK2964708.1 | 2049346 | g50435 | i0 | 41 | 1.01666666666667 | 61 | 35 | 100 | 1 | 180 | 1 | 623 | 683 | KAK2964708.1 putative Gelsolin [Blattamonas nauphoetae] | diamond | 183 | 53.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae |
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);;