contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26928635 | 26928635 | PRJNA867519_P_NODE_9802_length_361_cov_1.069444_g9648_i0 | PRJNA867519 | 9802 | 361 | 1.069444 | 3.86069284 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 55.8 | 3.51e-6 | NR | XP_067721943.1 | 2049356 | g9648 | i0 | 37.3 | 0.847645429362881 | 102 | 49 | 74 | 4 | 360 | 94 | 191 | 290 | XP_067721943.1 putative Leucine Rich Repeat containing protein [Monocercomonoides exilis] | diamond | 306 | 55.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27718960 | 27718960 | PRJNA867519_P_NODE_12584_length_327_cov_2.606299_g12430_i0 | PRJNA867519 | 12584 | 327 | 2.606299 | 8.52259773 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 45.8 | 0.00795 | NR | XP_067729903.1 | 2049356 | g12430 | i0 | 41.2 | 0.623853211009174 | 68 | 39 | 62.4 | 1 | 325 | 122 | 358 | 424 | XP_067729903.1 putative oxysterol binding protein [Monocercomonoides exilis] | diamond | 204 | 45.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27852885 | 27852885 | PRJNA867519_P_NODE_9024_length_373_cov_56.470000_g8870_i0 | PRJNA867519 | 9024 | 373 | 56.47 | 210.6331 | root | 1 | Root_unresolved | Root_unresolved | 113 | 5.06e-30 | NR | KAA6379614.1 | 222440 | g8870 | i0 | 58.1 | 2.94369973190349 | 93 | 39 | 74.8 | 0 | 371 | 93 | 1 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 1098 | 113 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 27947727 | 27947727 | PRJNA867519_P_NODE_29545_length_246_cov_0.890173_g29391_i0 | PRJNA867519 | 29545 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 5.69e-29 | NR | KAJ4459298.1 | 342808 | g29391 | i0 | 69.4 | 3.40243902439024 | 72 | 22 | 87.8 | 0 | 218 | 3 | 209 | 280 | KAJ4459298.1 putative Cathepsin B [Paratrimastix pyriformis] | diamond | 837 | 115 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28665912 | 28665912 | PRJNA867519_P_NODE_5827_length_449_cov_1.861702_g5673_i0 | PRJNA867519 | 5827 | 449 | 1.861702 | 8.35904198 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 73.6 | 5.81e-12 | NR | KAJ4457546.1 | 342808 | g5673 | i0 | 37.3 | 0.841870824053452 | 126 | 76 | 84.2 | 2 | 385 | 8 | 259 | 381 | KAJ4457546.1 putative Tryptophan synthase alpha chain [Paratrimastix pyriformis] | diamond | 378 | 73.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29707271 | 29707271 | PRJNA867519_P_NODE_3230_length_577_cov_2.196429_g3079_i0 | PRJNA867519 | 3230 | 577 | 2.196429 | 12.67339533 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 97.1 | 3.48e-20 | NR | XP_067720783.1 | 2049356 | g3079 | i0 | 41.4 | 0.665511265164645 | 128 | 68 | 65 | 2 | 158 | 532 | 215 | 338 | XP_067720783.1 putative ancient ubiquitous protein 1 [Monocercomonoides exilis] | diamond | 384 | 97.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 30181473 | 30181473 | PRJNA867519_P_NODE_3352_length_568_cov_1.670707_g3201_i0 | PRJNA867519 | 3352 | 568 | 1.670707 | 9.48961576 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 114 | 1.27e-25 | NR | KAK2956005.1 | 2049346 | g3201 | i0 | 38.2 | 0.940140845070423 | 178 | 88 | 91.9 | 7 | 17 | 538 | 503 | 662 | KAK2956005.1 putative serine/threonine protein kinase [Blattamonas nauphoetae] | diamond | 534 | 114 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 30623666 | 30623666 | PRJNA867519_P_NODE_16353_length_293_cov_0.927273_g16199_i0 | PRJNA867519 | 16353 | 293 | 0.927273 | 2.71690989 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 130 | 3.9e-33 | NR | XP_067726679.1 | 2049356 | g16199 | i0 | 65.3 | 0.972696245733788 | 95 | 33 | 97.3 | 0 | 288 | 4 | 69 | 163 | XP_067726679.1 Nucleoside-triphosphate--adenylate kinase [Monocercomonoides exilis] | diamond | 285 | 130 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31192192 | 31192192 | PRJNA867519_P_NODE_17055_length_289_cov_1.009259_g16901_i0 | PRJNA867519 | 17055 | 289 | 1.009259 | 2.91675851 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 77 | 2e-14 | NR | KAJ4462876.1 | 342808 | g16901 | i0 | 45.3 | 0.892733564013841 | 86 | 46 | 88.2 | 1 | 255 | 1 | 4 | 89 | KAJ4462876.1 hypothetical protein PAPYR_83 [Paratrimastix pyriformis] | diamond | 258 | 77 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31192203 | 31192203 | PRJNA867519_P_NODE_23995_length_258_cov_0.870270_g23841_i0 | PRJNA867519 | 23995 | 258 | 0.87027 | 2.2452966 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 65.1 | 6.05e-10 | NR | KAJ4457120.1 | 342808 | g23841 | i0 | 68.3 | 0.965116279069767 | 41 | 13 | 47.7 | 0 | 5 | 127 | 1003 | 1043 | KAJ4457120.1 putative Dynein-1-beta heavy chain; flagellar inner arm I1 complex [Paratrimastix pyriformis] | diamond | 249 | 65.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31350792 | 31350792 | PRJNA867519_P_NODE_1256_length_851_cov_4.248072_g1120_i0 | PRJNA867519 | 1256 | 851 | 4.248072 | 36.15109272 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 177 | 1.47e-50 | NR | KAA6375409.1 | 222440 | g1120 | i0 | 39.1 | 2.98237367802585 | 266 | 149 | 92.7 | 7 | 26 | 814 | 5 | 260 | KAA6375409.1 MAG: putative autophagy protein 3 [Streblomastix strix] | diamond | 2538 | 177 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31445602 | 31445602 | PRJNA867519_P_NODE_22256_length_265_cov_2.406250_g22102_i0 | PRJNA867519 | 22256 | 265 | 2.40625 | 6.3765625 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 66.6 | 1.32e-11 | NR | XP_067728150.1 | 2049356 | g22102 | i0 | 38 | 0.894339622641509 | 79 | 47 | 87.2 | 1 | 262 | 32 | 41 | 119 | XP_067728150.1 uncharacterized protein MONOS_215 [Monocercomonoides exilis] | diamond | 237 | 66.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31603820 | 31603820 | PRJNA867519_P_NODE_21516_length_269_cov_1.290816_g21362_i0 | PRJNA867519 | 21516 | 269 | 1.290816 | 3.47229504 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 62 | 8.93e-10 | NR | KAJ4457567.1 | 342808 | g21362 | i0 | 50 | 0.713754646840149 | 64 | 31 | 70.3 | 1 | 262 | 74 | 71 | 134 | KAJ4457567.1 hypothetical protein PAPYR_6925 [Paratrimastix pyriformis] | diamond | 192 | 62 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32521553 | 32521553 | PRJNA867519_P_NODE_20679_length_273_cov_1.215000_g20525_i0 | PRJNA867519 | 20679 | 273 | 1.215 | 3.31695 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 79.3 | 6.85e-15 | NR | KAJ4463106.1 | 342808 | g20525 | i0 | 47.1 | 3.73626373626374 | 85 | 39 | 93.4 | 1 | 3 | 257 | 372 | 450 | KAJ4463106.1 putative peptidase C69 [Paratrimastix pyriformis] | diamond | 1020 | 79.3 | 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);;