contig_metadata
14 rows where bioproject = "PRJNA760904" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27558433 | 27558433 | PRJNA760904_P_NODE_13884_length_256_cov_1.683060_g13827_i0 | PRJNA760904 | 13884 | 256 | 1.68306 | 4.3086336 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 74.3 | 2.98e-13 | NR | KAJ4456666.1 | 342808 | g13827 | i0 | 44 | 0.984375 | 84 | 46 | 98.4 | 1 | 255 | 4 | 137 | 219 | KAJ4456666.1 hypothetical protein PAPYR_8067 [Paratrimastix pyriformis] | diamond | 252 | 74.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27905681 | 27905681 | PRJNA760904_P_NODE_18585_length_244_cov_2.239766_g18528_i0 | PRJNA760904 | 18585 | 244 | 2.239766 | 5.46502904 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 43.9 | 0.015 | NR | KAK2954915.1 | 2049346 | g18528 | i0 | 30 | 0.983606557377049 | 80 | 54 | 98.4 | 2 | 241 | 2 | 292 | 369 | KAK2954915.1 hypothetical protein BLNAU_10054 [Blattamonas nauphoetae] | diamond | 240 | 43.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28063775 | 28063775 | PRJNA760904_P_NODE_4005_length_417_cov_1.985465_g3948_i0 | PRJNA760904 | 4005 | 417 | 1.985465 | 8.27938905 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 45.1 | 0.0323 | NR | KAK2964181.1 | 2049346 | g3948 | i0 | 30.4 | 0.661870503597122 | 92 | 58 | 63.3 | 3 | 329 | 66 | 204 | 293 | KAK2964181.1 putative Polyadenylate-binding protein [Blattamonas nauphoetae] | diamond | 276 | 45.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28537637 | 28537637 | PRJNA760904_P_NODE_10207_length_286_cov_0.816901_g10150_i0 | PRJNA760904 | 10207 | 286 | 0.816901 | 2.33633686 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 73.9 | 3.95e-13 | NR | KAJ4455748.1 | 342808 | g10150 | i0 | 50.7 | 0.744755244755245 | 71 | 35 | 74.5 | 0 | 59 | 271 | 207 | 277 | KAJ4455748.1 putative dual adapter for phosphotyrosine and 3-phosphotyrosine and 3-phosphoinositide [Paratrimastix pyriformis] | diamond | 213 | 73.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28758410 | 28758410 | PRJNA760904_P_NODE_2787_length_488_cov_2.045783_g2730_i0 | PRJNA760904 | 2787 | 488 | 2.045783 | 9.98342104 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 57.4 | 2.36e-6 | NR | KAJ4462876.1 | 342808 | g2730 | i0 | 26.2 | 0.891393442622951 | 145 | 99 | 89.1 | 3 | 54 | 488 | 12 | 148 | KAJ4462876.1 hypothetical protein PAPYR_83 [Paratrimastix pyriformis] | diamond | 435 | 57.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29673792 | 29673792 | PRJNA760904_P_NODE_3990_length_418_cov_1.579710_g3933_i0 | PRJNA760904 | 3990 | 418 | 1.57971 | 6.6031878 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 84.3 | 2.44e-17 | NR | KAJ4457922.1 | 342808 | g3933 | i0 | 40.8 | 1.47846889952153 | 103 | 60 | 73.9 | 1 | 313 | 5 | 7 | 108 | KAJ4457922.1 putative integral membrane protein [Paratrimastix pyriformis] | diamond | 618 | 84.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30906380 | 30906380 | PRJNA760904_P_NODE_15454_length_250_cov_0.870056_g15397_i0 | PRJNA760904 | 15454 | 250 | 0.870056 | 2.17514 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 48.9 | 2.27e-4 | NR | KAK2962347.1 | 2049346 | g15397 | i0 | 32.4 | 0.852 | 71 | 48 | 85.2 | 0 | 30 | 242 | 166 | 236 | KAK2962347.1 putative TKL protein kinase [Blattamonas nauphoetae] | diamond | 213 | 48.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31126996 | 31126996 | PRJNA760904_P_NODE_9695_length_290_cov_1.064516_g9638_i0 | PRJNA760904 | 9695 | 290 | 1.064516 | 3.0870964 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 68.6 | 5.39e-11 | NR | KAJ4459806.1 | 342808 | g9638 | i0 | 43.5 | 0.713793103448276 | 69 | 39 | 71.4 | 0 | 212 | 6 | 55 | 123 | KAJ4459806.1 putative activating signal cointegrator 1 complex subunit 1 [Paratrimastix pyriformis] | diamond | 207 | 68.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31475315 | 31475315 | PRJNA760904_P_NODE_3656_length_433_cov_1.825000_g3599_i0 | PRJNA760904 | 3656 | 433 | 1.825 | 7.90225 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 131 | 1.3199999999999998e-32 | NR | KAJ4462630.1 | 342808 | g3599 | i0 | 54.1 | 0.678983833718245 | 98 | 45 | 67.9 | 0 | 433 | 140 | 271 | 368 | KAJ4462630.1 putative E3 ubiquitin-protein ligase arih1 [Paratrimastix pyriformis] | diamond | 294 | 131 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31601870 | 31601870 | PRJNA760904_P_NODE_16236_length_248_cov_1.748571_g16179_i0 | PRJNA760904 | 16236 | 248 | 1.748571 | 4.33645608 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 102 | 2.919999999999999e-23 | NR | KAJ4455061.1 | 342808 | g16179 | i0 | 57.5 | 2.80645161290323 | 80 | 34 | 96.8 | 0 | 246 | 7 | 579 | 658 | KAJ4455061.1 putative Multidrug resistance-associated protein 9 [Paratrimastix pyriformis] | diamond | 696 | 102 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31759826 | 31759826 | PRJNA760904_P_NODE_2537_length_509_cov_1.587156_g2480_i0 | PRJNA760904 | 2537 | 509 | 1.587156 | 8.07862404 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 163 | 6.77e-48 | NR | KAJ4460451.1 | 342808 | g2480 | i0 | 48.2 | 2.63457760314342 | 164 | 63 | 83.7 | 2 | 473 | 48 | 2 | 165 | KAJ4460451.1 hypothetical protein PAPYR_3495 [Paratrimastix pyriformis] | diamond | 1341 | 163 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31791290 | 31791290 | PRJNA760904_P_NODE_11657_length_274_cov_0.950249_g11600_i0 | PRJNA760904 | 11657 | 274 | 0.950249 | 2.60368226 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 101 | 1.45e-22 | NR | KAJ4461802.1 | 342808 | g11600 | i0 | 50.6 | 0.974452554744526 | 89 | 44 | 97.4 | 0 | 269 | 3 | 2210 | 2298 | KAJ4461802.1 putative histone demethylase JARID1 [Paratrimastix pyriformis] | diamond | 267 | 101 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32266350 | 32266350 | PRJNA760904_P_NODE_5918_length_355_cov_4.453901_g5861_i0 | PRJNA760904 | 5918 | 355 | 4.453901 | 15.81134855 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 43.9 | 0.0195 | NR | XP_067733154.1 | 2049356 | g5861 | i0 | 38.7 | 0.633802816901408 | 75 | 39 | 63.4 | 2 | 326 | 102 | 14 | 81 | XP_067733154.1 uncharacterized protein MONOS_15893 [Monocercomonoides exilis] | diamond | 225 | 43.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32456124 | 32456124 | PRJNA760904_P_NODE_10899_length_280_cov_1.275362_g10842_i0 | PRJNA760904 | 10899 | 280 | 1.275362 | 3.5710136 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 43.1 | 0.0442 | NR | XP_067729033.1 | 2049356 | g10842 | i0 | 40.4 | 0.503571428571429 | 47 | 28 | 50.4 | 0 | 139 | 279 | 678 | 724 | XP_067729033.1 putative ABC transporter C family member 10 [Monocercomonoides exilis] | diamond | 141 | 43.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis |
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);;