contig_metadata
11 rows where bioproject = "PRJNA453567" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27802798 | 27802798 | PRJNA453567_P_NODE_16624_length_220_cov_1.174863_g16387_i0 | PRJNA453567 | 16624 | 220 | 1.174863 | 2.5846986 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 84.7 | 3.67e-17 | NR | XP_067725722.1 | 2049356 | g16387 | i0 | 69.6 | 0.763636363636364 | 56 | 17 | 76.4 | 0 | 168 | 1 | 96 | 151 | XP_067725722.1 Vacuolar protein sorting 4C (Vps4C) [Monocercomonoides exilis] | diamond | 168 | 84.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29318125 | 29318125 | PRJNA453567_P_NODE_23789_length_180_cov_1.363636_g23552_i0 | PRJNA453567 | 23789 | 180 | 1.363636 | 2.4545448 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 63.2 | 6.1e-10 | NR | KAA6375409.1 | 222440 | g23552 | i0 | 54 | 2.63333333333333 | 50 | 23 | 83.3 | 0 | 22 | 171 | 3 | 52 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 474 | 63.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29444278 | 29444278 | PRJNA453567_P_NODE_5590_length_429_cov_2.045918_g5354_i0 | PRJNA453567 | 5590 | 429 | 2.045918 | 8.77698822 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 46.2 | 0.0151 | NR | KAJ4462074.1 | 342808 | g5354 | i0 | 71 | 0.216783216783217 | 31 | 9 | 21.7 | 0 | 406 | 314 | 490 | 520 | KAJ4462074.1 putative tRNA methyltransferase [Paratrimastix pyriformis] | diamond | 93 | 46.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29539118 | 29539118 | PRJNA453567_P_NODE_26230_length_171_cov_1.455224_g25993_i0 | PRJNA453567 | 26230 | 171 | 1.455224 | 2.48843304 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 45.1 | 0.00213 | NR | KAJ4455857.1 | 342808 | g25993 | i0 | 42.1 | 1 | 57 | 33 | 100 | 0 | 171 | 1 | 191 | 247 | KAJ4455857.1 hypothetical protein PAPYR_9063 [Paratrimastix pyriformis] | diamond | 171 | 45.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29696693 | 29696693 | PRJNA453567_P_NODE_16770_length_219_cov_1.071429_g16533_i0 | PRJNA453567 | 16770 | 219 | 1.071429 | 2.34642951 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 52.8 | 4.95e-6 | NR | KAK2956229.1 | 2049346 | g16533 | i0 | 35.2 | 0.972602739726027 | 71 | 46 | 97.3 | 0 | 3 | 215 | 33 | 103 | KAK2956229.1 hypothetical protein BLNAU_8793 [Blattamonas nauphoetae] | diamond | 213 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31024043 | 31024043 | PRJNA453567_P_NODE_515_length_1535_cov_6.419226_g472_i0 | PRJNA453567 | 515 | 1535 | 6.419226 | 98.5351191 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 309 | 9.31e-97 | NR | KAJ4461836.1 | 342808 | g472 | i0 | 49.1 | 12.9244299674267 | 326 | 149 | 63.5 | 6 | 1525 | 551 | 3 | 312 | KAJ4461836.1 putative Mitotic checkpoint protein BUB3.1 [Paratrimastix pyriformis] | diamond | 19839 | 309 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31561679 | 31561679 | PRJNA453567_P_NODE_27756_length_166_cov_1.511628_g27519_i0 | PRJNA453567 | 27756 | 166 | 1.511628 | 2.50930248 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 61.6 | 2.9e-9 | NR | KAJ4462359.1 | 342808 | g27519 | i0 | 52.9 | 1.89759036144578 | 51 | 24 | 92.2 | 0 | 159 | 7 | 34 | 84 | KAJ4462359.1 putative DNA cross-link repair protein SNM1 [Paratrimastix pyriformis] | diamond | 315 | 61.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32194264 | 32194264 | PRJNA453567_P_NODE_15338_length_230_cov_2.927461_g15101_i0 | PRJNA453567 | 15338 | 230 | 2.927461 | 6.7331603 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 73.9 | 1.17e-13 | NR | XP_067734454.1 | 2049356 | g15101 | i0 | 57.7 | 1.31739130434783 | 52 | 21 | 67.8 | 1 | 9 | 164 | 67 | 117 | XP_067734454.1 putative density-regulated protein [Monocercomonoides exilis] | diamond | 303 | 73.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32527147 | 32527147 | PRJNA453567_P_NODE_20939_length_193_cov_1.250000_g20702_i0 | PRJNA453567 | 20939 | 193 | 1.25 | 2.4125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 4.21e-5 | NR | KAA6356825.1 | 222440 | g20702 | i0 | 59.5 | 4.24352331606218 | 37 | 15 | 57.5 | 0 | 81 | 191 | 16 | 52 | KAA6356825.1 MAG: hypothetical protein EZS28_047649, partial [Streblomastix strix] | diamond | 819 | 48.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32574140 | 32574140 | PRJNA453567_P_NODE_319_length_1785_cov_4.540618_g290_i0 | PRJNA453567 | 319 | 1785 | 4.540618 | 81.0500313 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 270 | 4.7e-81 | NR | KAA6385715.1 | 222440 | g290 | i0 | 42 | 1.23865546218487 | 371 | 168 | 60.7 | 8 | 297 | 1379 | 47 | 380 | KAA6385715.1 MAG: hypothetical protein EZS28_018757 [Streblomastix strix] | diamond | 2211 | 270 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32888553 | 32888553 | PRJNA453567_P_NODE_14800_length_235_cov_1.772727_g14563_i0 | PRJNA453567 | 14800 | 235 | 1.772727 | 4.16590845 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 90.1 | 3.44e-20 | NR | KAJ4462638.1 | 342808 | g14563 | i0 | 52 | 1.94042553191489 | 75 | 36 | 95.7 | 0 | 9 | 233 | 5 | 79 | KAJ4462638.1 putative lightoid family protein [Paratrimastix pyriformis] | diamond | 456 | 90.1 | 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);;