contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11755982 | 11755982 | PRJNA1122875_P_NODE_17030_length_405_cov_1.385542_g16806_i0 | PRJNA1122875 | 17030 | 405 | 1.385542 | 5.6114451 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 147 | 2.61e-42 | NR | XP_067726123.1 | 2049356 | g16806 | i0 | 67 | 7.82962962962963 | 109 | 35 | 80.7 | 1 | 327 | 1 | 13 | 120 | XP_067726123.1 putative 40S ribosomal protein S14-1 [Monocercomonoides exilis] | diamond | 3171 | 147 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 13782149 | 13782149 | PRJNA1122875_P_NODE_9071_length_547_cov_2.518987_g8852_i0 | PRJNA1122875 | 9071 | 547 | 2.518987 | 13.77885889 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 70.9 | 1.43e-10 | NR | KAJ4463137.1 | 342808 | g8852 | i0 | 33.8 | 0.712979890310786 | 130 | 80 | 70.2 | 3 | 513 | 130 | 804 | 929 | KAJ4463137.1 putative Calnexin [Paratrimastix pyriformis] | diamond | 390 | 70.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27418070 | 27418070 | PRJNA1122875_P_NODE_39723_length_263_cov_1.468421_g39499_i0 | PRJNA1122875 | 39723 | 263 | 1.468421 | 3.86194723 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 73.2 | 6.91e-14 | NR | KAA6388004.1 | 222440 | g39499 | i0 | 57.4 | 0.615969581749049 | 54 | 22 | 61.6 | 1 | 3 | 164 | 114 | 166 | KAA6388004.1 MAG: putative Translationally-controlled tumor protein [Streblomastix strix] | diamond | 162 | 73.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 27986100 | 27986100 | PRJNA1122875_P_NODE_24545_length_335_cov_2.335878_g24321_i0 | PRJNA1122875 | 24545 | 335 | 2.335878 | 7.8251913 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 103 | 4.52e-23 | NR | KAJ4462825.1 | 342808 | g24321 | i0 | 56.4 | 0.841791044776119 | 94 | 37 | 81.5 | 2 | 3 | 275 | 396 | 488 | KAJ4462825.1 putative Xaa-Pro dipeptidase [Paratrimastix pyriformis] | diamond | 282 | 103 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28491422 | 28491422 | PRJNA1122875_P_NODE_6787_length_616_cov_5.055249_g6571_i0 | PRJNA1122875 | 6787 | 616 | 5.055249 | 31.14033384 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 129 | 9.98e-34 | NR | KAK2956265.1 | 2049346 | g6571 | i0 | 47.8 | 3.98376623376623 | 159 | 78 | 77.4 | 4 | 570 | 94 | 1 | 154 | KAK2956265.1 putative 60S ribosomal protein L18-3 [Blattamonas nauphoetae] | diamond | 2454 | 129 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28586265 | 28586265 | PRJNA1122875_P_NODE_8887_length_552_cov_1.626305_g8668_i0 | PRJNA1122875 | 8887 | 552 | 1.626305 | 8.9772036 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 107 | 2.4e-23 | NR | KAJ4460751.1 | 342808 | g8668 | i0 | 58.2 | 2.45108695652174 | 91 | 37 | 49.5 | 1 | 231 | 503 | 177 | 266 | KAJ4460751.1 putative OV-16 antigen precursor [Paratrimastix pyriformis] | diamond | 1353 | 107 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29406898 | 29406898 | PRJNA1122875_P_NODE_30789_length_294_cov_1.461538_g30565_i0 | PRJNA1122875 | 30789 | 294 | 1.461538 | 4.29692172 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 97.1 | 3.12e-23 | NR | KAK2944236.1 | 2049346 | g30565 | i0 | 53.3 | 1.85714285714286 | 92 | 41 | 93.9 | 2 | 294 | 19 | 57 | 146 | KAK2944236.1 hypothetical protein BLNAU_20846 [Blattamonas nauphoetae] | diamond | 546 | 97.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29533279 | 29533279 | PRJNA1122875_P_NODE_40430_length_260_cov_1.866310_g40206_i0 | PRJNA1122875 | 40430 | 260 | 1.86631 | 4.852406 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 41.6 | 0.0491 | NR | XP_067728242.1 | 2049356 | g40206 | i0 | 32.9 | 0.807692307692308 | 70 | 43 | 77.3 | 3 | 55 | 255 | 7 | 75 | XP_067728242.1 centrin [Monocercomonoides exilis] | diamond | 210 | 41.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29659169 | 29659169 | PRJNA1122875_P_NODE_48790_length_246_cov_0.890173_g48566_i0 | PRJNA1122875 | 48790 | 246 | 0.890173 | 2.18982558 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.5 | 1.25e-4 | NR | KAJ4459457.1 | 342808 | g48566 | i0 | 56.8 | 0.451219512195122 | 37 | 16 | 45.1 | 0 | 133 | 243 | 86 | 122 | KAJ4459457.1 hypothetical protein PAPYR_4504 [Paratrimastix pyriformis] | diamond | 111 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30122453 | 30122453 | PRJNA1122875_P_NODE_54592_length_229_cov_2.076923_g54368_i0 | PRJNA1122875 | 54592 | 229 | 2.076923 | 4.75615367 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 95.5 | 6.09e-21 | NR | KAJ4455108.1 | 342808 | g54368 | i0 | 65.7 | 3.52401746724891 | 67 | 23 | 87.8 | 0 | 227 | 27 | 399 | 465 | KAJ4455108.1 putative V-type proton ATPase subunit B2 [Paratrimastix pyriformis] | diamond | 807 | 95.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30291721 | 30291721 | PRJNA1122875_P_NODE_2952_length_855_cov_2.796675_g2779_i0 | PRJNA1122875 | 2952 | 855 | 2.796675 | 23.91157125 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.1 | 0.0374 | NR | KAJ4462115.1 | 342808 | g2779 | i0 | 26.3 | 0.480701754385965 | 137 | 99 | 48.1 | 1 | 229 | 639 | 705 | 839 | KAJ4462115.1 hypothetical protein PAPYR_1294 [Paratrimastix pyriformis] | diamond | 411 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30512443 | 30512443 | PRJNA1122875_P_NODE_37733_length_270_cov_1.563452_g37509_i0 | PRJNA1122875 | 37733 | 270 | 1.563452 | 4.2213204 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 65.5 | 7.35e-11 | NR | KAA6388004.1 | 222440 | g37509 | i0 | 61.7 | 0.522222222222222 | 47 | 18 | 52.2 | 0 | 270 | 130 | 120 | 166 | KAA6388004.1 MAG: putative Translationally-controlled tumor protein [Streblomastix strix] | diamond | 141 | 65.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31365890 | 31365890 | PRJNA1122875_P_NODE_14656_length_436_cov_1.322314_g14432_i0 | PRJNA1122875 | 14656 | 436 | 1.322314 | 5.76528904 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 68.2 | 1.25e-11 | NR | KAJ4453711.1 | 342808 | g14432 | i0 | 56.6 | 0.681192660550459 | 99 | 36 | 64.7 | 3 | 2 | 283 | 17 | 113 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 297 | 68.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31555770 | 31555770 | PRJNA1122875_P_NODE_39696_length_263_cov_1.621053_g39472_i0 | PRJNA1122875 | 39696 | 263 | 1.621053 | 4.26336939 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 56.2 | 8.47e-7 | NR | XP_067721356.1 | 2049356 | g39472 | i0 | 45.8 | 2.48669201520913 | 59 | 29 | 67.3 | 1 | 257 | 81 | 240 | 295 | XP_067721356.1 putative long flagella protein LF4 [Monocercomonoides exilis] | diamond | 654 | 56.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32188321 | 32188321 | PRJNA1122875_P_NODE_5838_length_656_cov_2.051458_g5626_i0 | PRJNA1122875 | 5838 | 656 | 2.051458 | 13.45756448 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 81.6 | 6.11e-15 | NR | KAJ4461368.1 | 342808 | g5626 | i0 | 44.2 | 0.434451219512195 | 95 | 49 | 43 | 3 | 23 | 304 | 131 | 222 | KAJ4461368.1 putative glycosyl hydrolase family 25 protein [Paratrimastix pyriformis] | diamond | 285 | 81.6 | 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);;