contig_metadata
25 rows where bioproject = "PRJNA631119", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1879317 | 1879317 | PRJNA631119_P_NODE_12262_length_355_cov_1.092199_g12144_i0 | PRJNA631119 | 12262 | 355 | 1.092199 | 3.87730645 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2794941434|ref|XM_067876610.1| | 2049356 | g12144 | i0 | 100 | 0.332394366197183 | 30 | 0 | 8 | 0 | 219 | 248 | 368 | 397 | Monocercomonoides exilis uncharacterized protein (MONOS_6381), partial mRNA | blastn | 118 | 56.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 5706766 | 5706766 | PRJNA631119_P_NODE_16705_length_317_cov_1.262295_g16587_i0 | PRJNA631119 | 16705 | 317 | 1.262295 | 4.00147515 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 6.0699999999999986e-24 | NR | KAK2964795.1 | 2049346 | g16587 | i0 | 52.6 | 1.7981072555205 | 95 | 41 | 86.1 | 2 | 286 | 14 | 300 | 394 | KAK2964795.1 putative CCR4-NOT transcription complex subunit 8 [Blattamonas nauphoetae] | diamond | 570 | 105 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 9531733 | 9531733 | PRJNA631119_P_NODE_27428_length_263_cov_1.621053_g27310_i0 | PRJNA631119 | 27428 | 263 | 1.621053 | 4.26336939 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2794960358|ref|XM_067867846.1| | 2049356 | g27310 | i0 | 100 | 4.77946768060836 | 29 | 0 | 11 | 0 | 194 | 222 | 2836 | 2808 | Monocercomonoides exilis uncharacterized protein (MONOS_150), partial mRNA | blastn | 1257 | 54.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 10807359 | 10807359 | PRJNA631119_P_NODE_17029_length_315_cov_1.264463_g16911_i0 | PRJNA631119 | 17029 | 315 | 1.264463 | 3.98305845 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2794960289|ref|XM_067878093.1| | 2049356 | g16911 | i0 | 100 | 0.0888888888888889 | 28 | 0 | 9 | 0 | 132 | 159 | 5001 | 5028 | Monocercomonoides exilis uncharacterized protein (MONOS_7745fu7728), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 13357364 | 13357364 | PRJNA631119_P_NODE_14111_length_337_cov_1.287879_g13993_i0 | PRJNA631119 | 14111 | 337 | 1.287879 | 4.34015223 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|2794956649|ref|XM_067880018.1| | 2049356 | g13993 | i0 | 100 | 0.0830860534124629 | 28 | 0 | 8 | 0 | 15 | 42 | 6936 | 6909 | Monocercomonoides exilis putative ankyrin repeat-rich membrane spanning protein (MONOS_9510), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 21005652 | 21005652 | PRJNA631119_P_NODE_29957_length_254_cov_1.337017_g29839_i0 | PRJNA631119 | 29957 | 254 | 1.337017 | 3.39602318 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 62.1 | 3.83e-5 | NTclustered | gi|2794964705|ref|XM_067866472.1| | 2049356 | g29839 | i0 | 97.297 | 2.3503937007874 | 37 | 0 | 14 | 1 | 62 | 97 | 1376 | 1340 | Monocercomonoides exilis uncharacterized protein (MONOS_13741), partial mRNA | blastn | 597 | 62.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 21005677 | 21005677 | PRJNA631119_P_NODE_36257_length_244_cov_1.801170_g36139_i0 | PRJNA631119 | 36257 | 244 | 1.80117 | 4.3948548 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2794964924|ref|XM_067874062.1| | 2049356 | g36139 | i0 | 100 | 0.229508196721311 | 28 | 0 | 11 | 0 | 50 | 77 | 6540 | 6567 | Monocercomonoides exilis uncharacterized protein (MONOS_4022), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 26700857 | 26700857 | PRJNA631119_P_NODE_11641_length_361_cov_10.135417_g11523_i0 | PRJNA631119 | 11641 | 361 | 10.135417 | 36.58885537 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 111 | 3.5600000000000003e-29 | NR | KAA6379614.1 | 222440 | g11523 | i0 | 58.2 | 2.25207756232687 | 91 | 38 | 75.6 | 0 | 359 | 87 | 3 | 93 | KAA6379614.1 MAG: hypothetical protein EZS28_024857 [Streblomastix strix] | diamond | 813 | 111 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 27946305 | 27946305 | PRJNA631119_P_NODE_39125_length_241_cov_0.916667_g39007_i0 | PRJNA631119 | 39125 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 128 | 1.37e-33 | NR | KAJ4456818.1 | 342808 | g39007 | i0 | 73.4 | 14.0165975103734 | 79 | 21 | 98.3 | 0 | 239 | 3 | 130 | 208 | KAJ4456818.1 putative Cell division control protein 2 [Paratrimastix pyriformis] | diamond | 3378 | 128 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27997002 | 27997002 | PRJNA631119_P_NODE_5865_length_473_cov_2.380000_g5747_i0 | PRJNA631119 | 5865 | 473 | 2.38 | 11.2574 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 50.8 | 5.79e-4 | NR | KAJ4454930.1 | 342808 | g5747 | i0 | 30.4 | 0.875264270613108 | 138 | 82 | 85 | 7 | 56 | 457 | 424 | 551 | KAJ4454930.1 putative Ectonucleoside triphosphate diphosphohydrolase 3 [Paratrimastix pyriformis] | diamond | 414 | 50.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28091555 | 28091555 | PRJNA631119_P_NODE_8705_length_404_cov_1.549849_g8587_i0 | PRJNA631119 | 8705 | 404 | 1.549849 | 6.26138996 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 57 | 2.45e-6 | NR | KAJ4462339.1 | 342808 | g8587 | i0 | 32 | 0.928217821782178 | 125 | 80 | 92.8 | 3 | 402 | 28 | 368 | 487 | KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis] | diamond | 375 | 57 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28388250 | 28388250 | PRJNA631119_P_NODE_15646_length_325_cov_1.202381_g15528_i0 | PRJNA631119 | 15646 | 325 | 1.202381 | 3.90773825 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.5 | 8.39e-4 | NR | KAJ4454426.1 | 342808 | g15528 | i0 | 49.1 | 0.812307692307692 | 53 | 24 | 48 | 3 | 303 | 148 | 267 | 317 | KAJ4454426.1 putative Leucine Rich Repeat protein [Paratrimastix pyriformis] | diamond | 264 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28944418 | 28944418 | PRJNA631119_P_NODE_38548_length_242_cov_0.911243_g38430_i0 | PRJNA631119 | 38548 | 242 | 0.911243 | 2.20520806 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 124 | 7.4299999999999995e-31 | NR | KAJ4460597.1 | 342808 | g38430 | i0 | 69.4 | 0.892561983471074 | 72 | 22 | 89.3 | 0 | 5 | 220 | 812 | 883 | KAJ4460597.1 putative Exo-beta-D-glucosaminidase [Paratrimastix pyriformis] | diamond | 216 | 124 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29070557 | 29070557 | PRJNA631119_P_NODE_19068_length_302_cov_1.344978_g18950_i0 | PRJNA631119 | 19068 | 302 | 1.344978 | 4.06183356 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 53.1 | 1.67e-5 | NR | KAK2959112.1 | 2049346 | g18950 | i0 | 57.1 | 1.25165562913907 | 42 | 18 | 41.7 | 0 | 62 | 187 | 5 | 46 | KAK2959112.1 hypothetical protein BLNAU_5907 [Blattamonas nauphoetae] | diamond | 378 | 53.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29764807 | 29764807 | PRJNA631119_P_NODE_11691_length_361_cov_1.604167_g11573_i0 | PRJNA631119 | 11691 | 361 | 1.604167 | 5.79104287 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 57 | 2.34e-7 | NR | KAJ4457659.1 | 342808 | g11573 | i0 | 40.6 | 0.573407202216066 | 69 | 41 | 57.3 | 0 | 3 | 209 | 78 | 146 | KAJ4457659.1 hypothetical protein PAPYR_6797 [Paratrimastix pyriformis] | diamond | 207 | 57 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29859693 | 29859693 | PRJNA631119_P_NODE_29271_length_256_cov_1.683060_g29153_i0 | PRJNA631119 | 29271 | 256 | 1.68306 | 4.3086336 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 50.1 | 2.55e-5 | NR | KAK2962684.1 | 2049346 | g29153 | i0 | 51.1 | 1.06640625 | 47 | 23 | 55.1 | 0 | 145 | 5 | 20 | 66 | KAK2962684.1 putative 60S ribosomal protein L31 [Blattamonas nauphoetae] | diamond | 273 | 50.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 29923015 | 29923015 | PRJNA631119_P_NODE_13631_length_341_cov_2.231343_g13513_i0 | PRJNA631119 | 13631 | 341 | 2.231343 | 7.60887963 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 71.2 | 4.5e-12 | NR | KAA6361982.1 | 222440 | g13513 | i0 | 43.9 | 1.75953079178886 | 98 | 53 | 86.2 | 1 | 306 | 13 | 68 | 163 | KAA6361982.1 MAG: putative radial spoke head protein 9, partial [Streblomastix strix] | diamond | 600 | 71.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30175610 | 30175610 | PRJNA631119_P_NODE_5552_length_485_cov_1.046117_g5434_i0 | PRJNA631119 | 5552 | 485 | 1.046117 | 5.07366745 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 65.9 | 4.34e-9 | NR | KAJ4457127.1 | 342808 | g5434 | i0 | 33.6 | 0.698969072164948 | 113 | 72 | 69.9 | 2 | 478 | 140 | 593 | 702 | KAJ4457127.1 piwi-like protein [Paratrimastix pyriformis] | diamond | 339 | 65.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30428809 | 30428809 | PRJNA631119_P_NODE_23173_length_281_cov_2.033654_g23055_i0 | PRJNA631119 | 23173 | 281 | 2.033654 | 5.71456774 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 44.7 | 0.0105 | NR | KAJ4459753.1 | 342808 | g23055 | i0 | 37.9 | 0.619217081850534 | 58 | 36 | 61.9 | 0 | 280 | 107 | 129 | 186 | KAJ4459753.1 putative SNF7 family protein [Paratrimastix pyriformis] | diamond | 174 | 44.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31072997 | 31072997 | PRJNA631119_P_NODE_38175_length_242_cov_0.911243_g38057_i0 | PRJNA631119 | 38175 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.5 | 5.63e-6 | NR | KAJ4459115.1 | 342808 | g38057 | i0 | 31.6 | 6.64462809917355 | 57 | 39 | 70.7 | 0 | 182 | 12 | 176 | 232 | KAJ4459115.1 putative V-type proton ATPase subunit H [Paratrimastix pyriformis] | diamond | 1608 | 53.9 | 0.992578849721707 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31787461 | 31787461 | PRJNA631119_P_NODE_13237_length_345_cov_1.959559_g13119_i0 | PRJNA631119 | 13237 | 345 | 1.959559 | 6.76047855 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 169 | 1.07e-47 | NR | KAJ4458739.1 | 342808 | g13119 | i0 | 64.9 | 1.98260869565217 | 114 | 40 | 99.1 | 0 | 345 | 4 | 222 | 335 | KAJ4458739.1 putative 60S ribosomal protein L5 [Paratrimastix pyriformis] | diamond | 684 | 169 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31819204 | 31819204 | PRJNA631119_P_NODE_25677_length_270_cov_2.218274_g25559_i0 | PRJNA631119 | 25677 | 270 | 2.218274 | 5.9893398 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 46.2 | 0.00305 | NR | KAJ4456615.1 | 342808 | g25559 | i0 | 36.7 | 0.666666666666667 | 60 | 32 | 60 | 1 | 11 | 172 | 413 | 472 | KAJ4456615.1 putative C1 family cathepsin B20 [Paratrimastix pyriformis] | diamond | 180 | 46.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31914190 | 31914190 | PRJNA631119_P_NODE_10057_length_382_cov_1.349515_g9939_i0 | PRJNA631119 | 10057 | 382 | 1.349515 | 5.1551473 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.1 | 0.00241 | NR | KAJ4462339.1 | 342808 | g9939 | i0 | 32.6 | 0.675392670157068 | 86 | 48 | 64.4 | 3 | 41 | 286 | 311 | 390 | KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis] | diamond | 258 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32230825 | 32230825 | PRJNA631119_P_NODE_31998_length_250_cov_0.870056_g31880_i0 | PRJNA631119 | 31998 | 250 | 0.870056 | 2.17514 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 58.9 | 8.27e-8 | NR | KAK2962323.1 | 2049346 | g31880 | i0 | 51.6 | 1.572 | 62 | 28 | 74.4 | 1 | 8 | 193 | 606 | 665 | KAK2962323.1 putative TATA-binding protein-associated factor 172 [Blattamonas nauphoetae] | diamond | 393 | 58.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32547239 | 32547239 | PRJNA631119_P_NODE_20879_length_292_cov_1.844749_g20761_i0 | PRJNA631119 | 20879 | 292 | 1.844749 | 5.38666708 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 51.6 | 5.24e-5 | NR | KAJ4462339.1 | 342808 | g20761 | i0 | 30.2 | 0.883561643835616 | 86 | 49 | 82.2 | 3 | 242 | 3 | 2966 | 3046 | KAJ4462339.1 putative tenascin precursor [Paratrimastix pyriformis] | diamond | 258 | 51.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);;