contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA737474" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25765812 | 25765812 | PRJNA737474f_S_NODE_65730_length_319_cov_1.154472_g65052_i0 | PRJNA737474 | 65730 | 319 | 1.154472 | 3.68276568 | Oxymonadida | 66288 | Preaxostyla | other_Eukaryota | 159 | 1.2499999999999996e-43 | NR | KAA6403974.1 | 222440 | g65052 | i0 | 67.6 | 15.7993730407524 | 105 | 33 | 98.7 | 1 | 318 | 4 | 93 | 196 | KAA6403974.1 MAG: putative 5'-AMP-activated protein kinase catalytic subunit alpha-2 [Streblomastix strix] | diamond | 5040 | 160 | 0.99375 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 25901721 | 25901721 | PRJNA737474f_S_NODE_62083_length_323_cov_1.500000_g61405_i0 | PRJNA737474 | 62083 | 323 | 1.5 | 4.845 | Paratrimastix eleionoma | 1709329 | Preaxostyla | other_Eukaryota | 166 | 4.8999999999999996e-48 | NR | WCZ58421.1 | 1709329 | g61405 | i0 | 73.8 | 3.96594427244582 | 107 | 28 | 99.4 | 0 | 322 | 2 | 171 | 277 | WCZ58421.1 49 kDa TBP-interacting protein [Paratrimastix eleionoma] | diamond | 1281 | 166 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 26386939 | 26386939 | PRJNA737474c_S_NODE_10823_length_343_cov_1.944444_g9992_i0 | PRJNA737474 | 10823 | 343 | 1.944444 | 6.66944292 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 113 | 3.86e-29 | NR | KAJ4457922.1 | 342808 | g9992 | i0 | 55.1 | 0.857142857142857 | 98 | 44 | 85.7 | 0 | 1 | 294 | 71 | 168 | KAJ4457922.1 putative integral membrane protein [Paratrimastix pyriformis] | diamond | 294 | 113 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32921004 | 32921004 | PRJNA737474g_S_NODE_88305_length_339_cov_1.593985_g87011_i0 | PRJNA737474 | 88305 | 339 | 1.593985 | 5.40360915 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 89.7 | 1.78e-18 | NR | XP_067727356.1 | 2049356 | g87011 | i0 | 55.4 | 0.654867256637168 | 74 | 32 | 65.5 | 1 | 330 | 109 | 296 | 368 | XP_067727356.1 Protein disulfide-isomerase [Monocercomonoides exilis] | diamond | 222 | 89.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32936865 | 32936865 | PRJNA737474f_S_NODE_286761_length_241_cov_0.910714_g286083_i0 | PRJNA737474 | 286761 | 241 | 0.910714 | 2.19482074 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 63.2 | 2.32e-9 | NR | KAJ4461522.1 | 342808 | g286083 | i0 | 77.1 | 0.883817427385892 | 35 | 8 | 43.6 | 0 | 3 | 107 | 6176 | 6210 | KAJ4461522.1 putative 6-deoxyerythronolide-B synthase EryA1 [Paratrimastix pyriformis] | diamond | 213 | 63.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32953145 | 32953145 | PRJNA737474d_S_NODE_11034_length_463_cov_4.710256_g10450_i0 | PRJNA737474 | 11034 | 463 | 4.710256 | 21.80848528 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 78.2 | 1.83e-13 | NR | KAJ4461400.1 | 342808 | g10450 | i0 | 35.6 | 1.36717062634989 | 104 | 65 | 67.4 | 2 | 4 | 315 | 831 | 932 | KAJ4461400.1 putative E3 ubiquitin-protein ligase HECTD1 [Paratrimastix pyriformis] | diamond | 633 | 78.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32972156 | 32972156 | PRJNA737474g_S_NODE_344986_length_248_cov_2.142857_g343692_i0 | PRJNA737474 | 344986 | 248 | 2.142857 | 5.31428536 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 57 | 3.75e-7 | NR | KAJ4454777.1 | 342808 | g343692 | i0 | 53.7 | 1.48790322580645 | 54 | 20 | 59.3 | 2 | 9 | 155 | 453 | 506 | KAJ4454777.1 hypothetical protein PAPYR_10425 [Paratrimastix pyriformis] | diamond | 369 | 57 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33021988 | 33021988 | PRJNA737474f_S_NODE_136628_length_272_cov_1.628141_g135950_i0 | PRJNA737474 | 136628 | 272 | 1.628141 | 4.42854352 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 68.6 | 3.72e-11 | NR | XP_067727356.1 | 2049356 | g135950 | i0 | 53.7 | 0.595588235294118 | 54 | 25 | 59.6 | 0 | 259 | 98 | 315 | 368 | XP_067727356.1 Protein disulfide-isomerase [Monocercomonoides exilis] | diamond | 162 | 68.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 33023275 | 33023275 | PRJNA737474g_S_NODE_32444_length_502_cov_8.256410_g31161_i0 | PRJNA737474 | 32444 | 502 | 8.25641 | 41.4471782 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.5 | 0.00425 | NR | KAJ4456317.1 | 342808 | g31161 | i0 | 46.2 | 0.233067729083665 | 39 | 21 | 23.3 | 0 | 64 | 180 | 312 | 350 | KAJ4456317.1 hypothetical protein PAPYR_8497 [Paratrimastix pyriformis] | diamond | 117 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33061073 | 33061073 | PRJNA737474f_S_NODE_20797_length_450_cov_1.954907_g20120_i0 | PRJNA737474 | 20797 | 450 | 1.954907 | 8.7970815000000009 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 5.45e-4 | NR | KAA6388740.1 | 222440 | g20120 | i0 | 34.5 | 1.72666666666667 | 87 | 50 | 53.3 | 3 | 268 | 29 | 137 | 223 | KAA6388740.1 MAG: putative cAMP-dependent protein kinase catalytic subunit [Streblomastix strix] | diamond | 777 | 50.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 33061264 | 33061264 | PRJNA737474g_S_NODE_261501_length_261_cov_1.303191_g260207_i0 | PRJNA737474 | 261501 | 261 | 1.303191 | 3.40132851 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 1.82e-5 | NR | KAA6398580.1 | 222440 | g260207 | i0 | 50 | 1.44827586206897 | 42 | 21 | 48.3 | 0 | 261 | 136 | 315 | 356 | KAA6398580.1 MAG: putative NAD-dependent epimerase/dehydratase family protein [Streblomastix strix] | diamond | 378 | 52.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 33072618 | 33072618 | PRJNA737474d_S_NODE_32637_length_267_cov_2.067010_g32043_i0 | PRJNA737474 | 32637 | 267 | 2.06701 | 5.5189167 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.5 | 4.89e-4 | NR | KAJ4461281.1 | 342808 | g32043 | i0 | 37.1 | 0.696629213483146 | 62 | 37 | 67.4 | 1 | 1 | 180 | 71 | 132 | KAJ4461281.1 hypothetical protein PAPYR_2317 [Paratrimastix pyriformis] | diamond | 186 | 48.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33090947 | 33090947 | PRJNA737474g_S_NODE_12094_length_1013_cov_1.707447_g11083_i0 | PRJNA737474 | 12094 | 1013 | 1.707447 | 17.29643811 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 84 | 1.6e-14 | NR | XP_067732620.1 | 2049356 | g11083 | i0 | 31.5 | 0.544916090819348 | 184 | 107 | 53 | 6 | 460 | 996 | 58 | 227 | XP_067732620.1 putative Glycosyltransferase family 25 (LPS biosynthesis protein) [Monocercomonoides exilis] | diamond | 552 | 84 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 33106736 | 33106736 | PRJNA737474d_S_NODE_20174_length_340_cov_4.535581_g19580_i0 | PRJNA737474 | 20174 | 340 | 4.535581 | 15.4209754 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 140 | 6.16e-36 | NR | KAJ4463052.1 | 342808 | g19580 | i0 | 62.9 | 1.67647058823529 | 97 | 36 | 85.6 | 0 | 334 | 44 | 178 | 274 | KAJ4463052.1 putative Circularly permutated Ras protein 1 [Paratrimastix pyriformis] | diamond | 570 | 140 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33107422 | 33107422 | PRJNA737474f_S_NODE_20398_length_454_cov_1.097113_g19721_i0 | PRJNA737474 | 20398 | 454 | 1.097113 | 4.98089302 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 47 | 0.0103 | NR | KAJ4458842.1 | 342808 | g19721 | i0 | 40.8 | 0.323788546255507 | 49 | 29 | 32.4 | 0 | 446 | 300 | 34 | 82 | KAJ4458842.1 hypothetical protein PAPYR_5369 [Paratrimastix pyriformis] | diamond | 147 | 47 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33108088 | 33108088 | PRJNA737474g_S_NODE_180654_length_284_cov_1.947867_g179360_i0 | PRJNA737474 | 180654 | 284 | 1.947867 | 5.53194228 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 45.4 | 0.00669 | NR | KAJ4457603.1 | 342808 | g179360 | i0 | 35.2 | 0.570422535211268 | 54 | 35 | 57 | 0 | 237 | 76 | 128 | 181 | KAJ4457603.1 putative histone-lysine N-methyltransferase ATXR2 [Paratrimastix pyriformis] | diamond | 162 | 45.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33125888 | 33125888 | PRJNA737474g_S_NODE_75839_length_355_cov_2.141844_g74545_i0 | PRJNA737474 | 75839 | 355 | 2.141844 | 7.6035462 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 68.9 | 8.98e-11 | NR | KAK2949140.1 | 2049346 | g74545 | i0 | 48.8 | 0.676056338028169 | 80 | 40 | 67.6 | 1 | 51 | 290 | 1278 | 1356 | KAK2949140.1 hypothetical protein BLNAU_15866 [Blattamonas nauphoetae] | diamond | 240 | 68.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 33141382 | 33141382 | PRJNA737474f_S_NODE_15791_length_508_cov_6.160920_g15120_i0 | PRJNA737474 | 15791 | 508 | 6.16092 | 31.2974736 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.9 | 0.00327 | NR | KAJ4456317.1 | 342808 | g15120 | i0 | 46.2 | 0.230314960629921 | 39 | 21 | 23 | 0 | 64 | 180 | 312 | 350 | KAJ4456317.1 hypothetical protein PAPYR_8497 [Paratrimastix pyriformis] | diamond | 117 | 48.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33141574 | 33141574 | PRJNA737474f_S_NODE_263847_length_243_cov_1.270588_g263169_i0 | PRJNA737474 | 263847 | 243 | 1.270588 | 3.08752884 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 56.6 | 3.79e-7 | NR | KAJ4459097.1 | 342808 | g263169 | i0 | 37.7 | 1.72839506172839 | 77 | 47 | 95.1 | 1 | 2 | 232 | 89 | 164 | KAJ4459097.1 putative Alpha-soluble NSF attachment protein [Paratrimastix pyriformis] | diamond | 420 | 56.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 33158861 | 33158861 | PRJNA737474f_S_NODE_7744_length_742_cov_1.914798_g7155_i0 | PRJNA737474 | 7744 | 742 | 1.914798 | 14.20780116 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 85.9 | 2.16e-16 | NR | KAK2960402.1 | 2049346 | g7155 | i0 | 38.6 | 3.49730458221024 | 140 | 75 | 56.6 | 1 | 714 | 295 | 42 | 170 | KAK2960402.1 putative Meiotic nuclear division protein 1 like protein [Blattamonas nauphoetae] | diamond | 2595 | 85.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 33159817 | 33159817 | PRJNA737474g_S_NODE_55776_length_394_cov_1.750779_g54483_i0 | PRJNA737474 | 55776 | 394 | 1.750779 | 6.89806926 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 62 | 3.93e-8 | NR | XP_067729600.1 | 2049356 | g54483 | i0 | 50 | 0.845177664974619 | 54 | 27 | 41.1 | 0 | 165 | 4 | 213 | 266 | XP_067729600.1 putative Myotubularin-like phosphatase domain [Monocercomonoides exilis] | diamond | 333 | 62 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 33175298 | 33175298 | PRJNA737474d_S_NODE_4368_length_791_cov_3.715877_g3845_i0 | PRJNA737474 | 4368 | 791 | 3.715877 | 29.39258707 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 62.4 | 1.36e-7 | NR | KAK2953740.1 | 2049346 | g3845 | i0 | 37.4 | 1.25537294563843 | 99 | 62 | 37.5 | 0 | 308 | 12 | 18 | 116 | KAK2953740.1 putative Signal transducing adapter molecule 2 [Blattamonas nauphoetae] | diamond | 993 | 62.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae |
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);;