contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27005678 | 27005678 | PRJNA1120060_P_NODE_2521502_length_253_cov_1.900000_g2503430_i0 | PRJNA1120060 | 2521502 | 253 | 1.9 | 4.807 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 51.6 | 3.22e-5 | NR | KAJ4459179.1 | 342808 | g2503430 | i0 | 78.3 | 0.272727272727273 | 23 | 5 | 27.3 | 0 | 246 | 178 | 781 | 803 | KAJ4459179.1 putative Ctype lysozyme/alpha-lactalbumin superfamily protein [Paratrimastix pyriformis] | diamond | 69 | 51.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 27291225 | 27291225 | PRJNA1120060_P_NODE_70923_length_635_cov_1.766904_g57888_i0 | PRJNA1120060 | 70923 | 635 | 1.766904 | 11.2198404 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 46.6 | 0.0263 | NR | KAA6380226.1 | 222440 | g57888 | i0 | 37.5 | 0.302362204724409 | 64 | 40 | 30.2 | 0 | 316 | 507 | 147 | 210 | KAA6380226.1 MAG: putative Ubc protein [Streblomastix strix] | diamond | 192 | 46.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28584802 | 28584802 | PRJNA1120060_P_NODE_2047427_length_271_cov_1.247475_g2029390_i0 | PRJNA1120060 | 2047427 | 271 | 1.247475 | 3.38065725 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 52 | 2.68e-5 | NR | KAA6374708.1 | 222440 | g2029390 | i0 | 43.9 | 5.41328413284133 | 66 | 37 | 73.1 | 0 | 269 | 72 | 316 | 381 | KAA6374708.1 MAG: putative Polyubiquitin [Streblomastix strix] | diamond | 1467 | 52 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28638525 | 28638525 | PRJNA1120060_P_NODE_3311247_length_226_cov_4.281046_g3293137_i0 | PRJNA1120060 | 3311247 | 226 | 4.281046 | 9.67516396 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.9 | 9.54e-10 | NR | KAA6374708.1 | 222440 | g3293137 | i0 | 53.6 | 9.76991150442478 | 69 | 32 | 91.6 | 0 | 208 | 2 | 309 | 377 | KAA6374708.1 MAG: putative Polyubiquitin [Streblomastix strix] | diamond | 2208 | 64.3 | 0.993779160186625 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 28711895 | 28711895 | PRJNA1120060_P_NODE_3329607_length_224_cov_4.026490_g3311495_i0 | PRJNA1120060 | 3329607 | 224 | 4.02649 | 9.0193376 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 42 | 0.0446 | NR | KAK2940441.1 | 2049346 | g3311495 | i0 | 36.5 | 0.84375 | 63 | 38 | 84.4 | 1 | 217 | 29 | 92 | 152 | KAK2940441.1 hypothetical protein BLNAU_24649 [Blattamonas nauphoetae] | diamond | 189 | 42 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28931996 | 28931996 | PRJNA1120060_P_NODE_1983368_length_273_cov_2.965000_g1965340_i0 | PRJNA1120060 | 1983368 | 273 | 2.965 | 8.09445 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 53.5 | 7.97e-6 | NR | KAA6374708.1 | 222440 | g1965340 | i0 | 50.8 | 0.67032967032967 | 61 | 30 | 67 | 0 | 184 | 2 | 298 | 358 | KAA6374708.1 MAG: putative Polyubiquitin [Streblomastix strix] | diamond | 183 | 53.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29058149 | 29058149 | PRJNA1120060_P_NODE_1712868_length_284_cov_3.265403_g1694862_i0 | PRJNA1120060 | 1712868 | 284 | 3.265403 | 9.27374452 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 45.8 | 0.00471 | NR | KAA6387955.1 | 222440 | g1694862 | i0 | 53.8 | 0.549295774647887 | 52 | 12 | 42.3 | 2 | 122 | 3 | 232 | 283 | KAA6387955.1 MAG: putative Ribosome-binding ATPase YchF [Streblomastix strix] | diamond | 156 | 45.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29089311 | 29089311 | PRJNA1120060_P_NODE_1094428_length_311_cov_3.151261_g1076493_i0 | PRJNA1120060 | 1094428 | 311 | 3.151261 | 9.80042171 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 44.7 | 0.0043 | NR | KAA6321150.1 | 222440 | g1076493 | i0 | 47.2 | 0.67524115755627 | 36 | 19 | 34.7 | 0 | 185 | 292 | 11 | 46 | KAA6321150.1 MAG: hypothetical protein EZS28_054593, partial [Streblomastix strix] | diamond | 210 | 44.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29585064 | 29585064 | PRJNA1120060_P_NODE_1631590_length_288_cov_1.204651_g1613593_i0 | PRJNA1120060 | 1631590 | 288 | 1.204651 | 3.46939488 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 66.2 | 3.49e-11 | NR | KAA6375268.1 | 222440 | g1613593 | i0 | 44.7 | 9.23958333333333 | 76 | 42 | 79.2 | 0 | 267 | 40 | 1 | 76 | KAA6375268.1 MAG: putative Ubiquitin-60S ribosomal protein L40 [Streblomastix strix] | diamond | 2661 | 66.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30258462 | 30258462 | PRJNA1120060_P_NODE_1852892_length_278_cov_5.770732_g1834876_i0 | PRJNA1120060 | 1852892 | 278 | 5.770732 | 16.04263496 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 51.2 | 4.39e-5 | NR | KAA6369634.1 | 222440 | g1834876 | i0 | 40 | 1.81294964028777 | 55 | 33 | 59.4 | 0 | 70 | 234 | 83 | 137 | KAA6369634.1 MAG: putative Polyubiquitin [Streblomastix strix] | diamond | 504 | 51.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 30258669 | 30258669 | PRJNA1120060_P_NODE_2144412_length_267_cov_1.788660_g2126366_i0 | PRJNA1120060 | 2144412 | 267 | 1.78866 | 4.7757222 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 42.7 | 0.0488 | NR | KAK2945797.1 | 2049346 | g2126366 | i0 | 33.9 | 0.696629213483146 | 62 | 41 | 69.7 | 0 | 258 | 73 | 253 | 314 | KAK2945797.1 hypothetical protein BLNAU_19285 [Blattamonas nauphoetae] | diamond | 186 | 42.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 30636945 | 30636945 | PRJNA1120060_P_NODE_1449853_length_295_cov_9.198198_g1431868_i0 | PRJNA1120060 | 1449853 | 295 | 9.198198 | 27.1346841 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 44.7 | 0.00936 | NR | KAK2956616.1 | 2049346 | g1431868 | i0 | 33.3 | 0.823728813559322 | 81 | 52 | 82.4 | 2 | 27 | 269 | 4 | 82 | KAK2956616.1 hypothetical protein BLNAU_8456 [Blattamonas nauphoetae] | diamond | 243 | 44.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 30921916 | 30921916 | PRJNA1120060_P_NODE_187954_length_476_cov_3.868486_g171609_i0 | PRJNA1120060 | 187954 | 476 | 3.868486 | 18.41399336 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 55.5 | 1.67e-5 | NR | XP_067735864.1 | 2049356 | g171609 | i0 | 47.4 | 0.359243697478992 | 57 | 30 | 35.9 | 0 | 314 | 144 | 1643 | 1699 | XP_067735864.1 putative ATP-dependent RNA helicase RhlE [Monocercomonoides exilis] | diamond | 171 | 55.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32557382 | 32557382 | PRJNA1120060_P_NODE_987719_length_312_cov_2.694561_g969790_i0 | PRJNA1120060 | 987719 | 312 | 2.694561 | 8.40703032 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00869 | NR | KAA6374708.1 | 222440 | g969790 | i0 | 42.3 | 3.33653846153846 | 52 | 30 | 50 | 0 | 302 | 147 | 329 | 380 | KAA6374708.1 MAG: putative Polyubiquitin [Streblomastix strix] | diamond | 1041 | 45.8 | 0.991266375545852 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32566983 | 32566983 | PRJNA1120060_P_NODE_2365759_length_258_cov_6.513514_g2347694_i0 | PRJNA1120060 | 2365759 | 258 | 6.513514 | 16.80486612 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 60.1 | 3.57e-8 | NR | XP_067735864.1 | 2049356 | g2347694 | i0 | 49.1 | 1.45348837209302 | 57 | 29 | 66.3 | 0 | 5 | 175 | 1643 | 1699 | XP_067735864.1 putative ATP-dependent RNA helicase RhlE [Monocercomonoides exilis] | diamond | 375 | 60.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32588781 | 32588781 | PRJNA1120060_P_NODE_581559_length_351_cov_5.535971_g563848_i0 | PRJNA1120060 | 581559 | 351 | 5.535971 | 19.43125821 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.00758 | NR | KAA6396350.1 | 222440 | g563848 | i0 | 33.8 | 1.20512820512821 | 80 | 46 | 62.4 | 2 | 102 | 320 | 672 | 751 | KAA6396350.1 MAG: hypothetical protein EZS28_008123 [Streblomastix strix] | diamond | 423 | 46.6 | 0.991416309012876 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32660769 | 32660769 | PRJNA1120060_P_NODE_2085880_length_269_cov_2.617347_g2067840_i0 | PRJNA1120060 | 2085880 | 269 | 2.617347 | 7.04066343 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 46.2 | 0.0032 | NR | XP_067735864.1 | 2049356 | g2067840 | i0 | 51.4 | 0.412639405204461 | 37 | 18 | 41.3 | 0 | 269 | 159 | 1663 | 1699 | XP_067735864.1 putative ATP-dependent RNA helicase RhlE [Monocercomonoides exilis] | diamond | 111 | 46.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32819435 | 32819435 | PRJNA1120060_P_NODE_427340_length_382_cov_2.893204_g409858_i0 | PRJNA1120060 | 427340 | 382 | 2.893204 | 11.05203928 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 46.6 | 0.00741 | NR | KAA6397590.1 | 222440 | g409858 | i0 | 37.9 | 0.455497382198953 | 58 | 30 | 44.8 | 2 | 154 | 324 | 166 | 218 | KAA6397590.1 MAG: hypothetical protein EZS28_006882 [Streblomastix strix] | diamond | 174 | 46.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix |
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);;