contig_metadata
22 rows where bioproject = "PRJNA1028258", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2714271 | 2714271 | PRJNA1028258_P_NODE_151763_length_231_cov_0.876543_g151200_i0 | PRJNA1028258 | 151763 | 231 | 0.876543 | 2.02481433 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 7.05e-40 | NR | KAJ4456700.1 | 342808 | g151200 | i0 | 91.7 | 6.75324675324675 | 72 | 6 | 93.5 | 0 | 218 | 3 | 170 | 241 | KAJ4456700.1 putative Extracellular signal-regulated kinase 2 [Paratrimastix pyriformis] | diamond | 1560 | 148 | 0.993243243243243 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 6542958 | 6542958 | PRJNA1028258_P_NODE_44266_length_380_cov_2.659164_g43703_i0 | PRJNA1028258 | 44266 | 380 | 2.659164 | 10.1048232 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 164 | 3.36e-47 | NR | KAJ4457831.1 | 342808 | g43703 | i0 | 66.1 | 1.90263157894737 | 121 | 41 | 95.5 | 0 | 364 | 2 | 78 | 198 | KAJ4457831.1 putative 60S ribosomal protein L18-2 [Paratrimastix pyriformis] | diamond | 723 | 164 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 7815938 | 7815938 | PRJNA1028258_P_NODE_125287_length_240_cov_1.292398_g124724_i0 | PRJNA1028258 | 125287 | 240 | 1.292398 | 3.1017552 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2794964238|ref|XM_067865056.1| | 2049356 | g124724 | i0 | 100 | 0.116666666666667 | 28 | 0 | 12 | 0 | 10 | 37 | 1331 | 1358 | Monocercomonoides exilis uncharacterized protein (MONOS_12437fu12438), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 11643237 | 11643237 | PRJNA1028258_P_NODE_34610_length_431_cov_0.994475_g34047_i0 | PRJNA1028258 | 34610 | 431 | 0.994475 | 4.28618725 | Trimastix marina | 137419 | Preaxostyla | other_Eukaryota | 470 | 9.69e-128 | NTclustered | gi|84105378|gb|DQ295217.1| | 137419 | g34047 | i0 | 87.05 | 92.046403712297 | 417 | 52 | 97 | 2 | 16 | 431 | 5 | 420 | Trimastix marina alpha tubulin 1 gene, partial cds | blastn | 39672 | 470 | 1 | Eukaryota | Metamonada | Preaxostyla | Trimastigidae | Trimastix | Trimastix marina | ||||
| 14193532 | 14193532 | PRJNA1028258_P_NODE_45052_length_377_cov_1.821429_g44489_i0 | PRJNA1028258 | 45052 | 377 | 1.821429 | 6.86678733 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 84.3 | 3.26e-18 | NR | KAJ4453711.1 | 342808 | g44489 | i0 | 56.8 | 2.08488063660477 | 81 | 29 | 62.1 | 2 | 362 | 129 | 2 | 79 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 786 | 84.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 24391491 | 24391491 | PRJNA1028258_P_NODE_71320_length_304_cov_1.714894_g70757_i0 | PRJNA1028258 | 71320 | 304 | 1.714894 | 5.21327776 | Paratrimastix eleionoma | 1709329 | Preaxostyla | other_Eukaryota | 167 | 1.47e-49 | NR | WCZ58380.1 | 1709329 | g70757 | i0 | 73.3 | 9.9671052631579 | 101 | 27 | 99.7 | 0 | 304 | 2 | 5 | 105 | WCZ58380.1 60S ribosomal protein L8 [Paratrimastix eleionoma] | diamond | 3030 | 167 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 27982644 | 27982644 | PRJNA1028258_P_NODE_133265_length_235_cov_0.855422_g132702_i0 | PRJNA1028258 | 133265 | 235 | 0.855422 | 2.0102417 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 48.1 | 2.51e-4 | NR | KAK2962473.1 | 2049346 | g132702 | i0 | 40 | 1.53191489361702 | 65 | 36 | 83 | 1 | 195 | 1 | 2 | 63 | KAK2962473.1 putative Golgi apparatus membrane protein TVP23 [Blattamonas nauphoetae] | diamond | 360 | 48.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 28266635 | 28266635 | PRJNA1028258_P_NODE_82246_length_284_cov_1.609302_g81683_i0 | PRJNA1028258 | 82246 | 284 | 1.609302 | 4.57041768 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 69.7 | 1.97e-12 | NR | XP_067730312.1 | 2049356 | g81683 | i0 | 40.9 | 0.982394366197183 | 93 | 53 | 98.2 | 2 | 6 | 284 | 1 | 91 | XP_067730312.1 putative translationally controlled tumor protein [Monocercomonoides exilis] | diamond | 279 | 69.7 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28993356 | 28993356 | PRJNA1028258_P_NODE_32688_length_444_cov_1.056000_g32126_i0 | PRJNA1028258 | 32688 | 444 | 1.056 | 4.68864 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 50.4 | 6.62e-4 | NR | XP_067732265.1 | 2049356 | g32126 | i0 | 59.5 | 1.18243243243243 | 42 | 17 | 28.4 | 0 | 265 | 390 | 256 | 297 | XP_067732265.1 kinesin 3 [Monocercomonoides exilis] | diamond | 525 | 50.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 29024938 | 29024938 | PRJNA1028258_P_NODE_159528_length_229_cov_0.887500_g158965_i0 | PRJNA1028258 | 159528 | 229 | 0.8875 | 2.032375 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 124 | 2.19e-31 | NR | KAA6383970.1 | 222440 | g158965 | i0 | 71.1 | 2.98689956331878 | 76 | 22 | 99.6 | 0 | 2 | 229 | 378 | 453 | KAA6383970.1 MAG: putative Ubiquitin-conjugating BIR-domain enzyme [Streblomastix strix] | diamond | 684 | 124 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29174714 | 29174714 | PRJNA1028258_P_NODE_109929_length_252_cov_1.918033_g109366_i0 | PRJNA1028258 | 109929 | 252 | 1.918033 | 4.83344316 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.3 | 1.83e-11 | NR | KAJ4454829.1 | 342808 | g109366 | i0 | 54.5 | 1.30952380952381 | 55 | 25 | 65.5 | 0 | 27 | 191 | 441 | 495 | KAJ4454829.1 putative ankyrin repeat protein [Paratrimastix pyriformis] | diamond | 330 | 69.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29624034 | 29624034 | PRJNA1028258_P_NODE_52030_length_352_cov_1.491166_g51467_i0 | PRJNA1028258 | 52030 | 352 | 1.491166 | 5.24890432 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 92.4 | 1.59e-21 | NR | KAJ4453711.1 | 342808 | g51467 | i0 | 58 | 2.36079545454545 | 69 | 29 | 58.8 | 0 | 323 | 117 | 2 | 70 | KAJ4453711.1 putative 60S acidic ribosomal protein P1 [Paratrimastix pyriformis] | diamond | 831 | 92.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30066625 | 30066625 | PRJNA1028258_P_NODE_94432_length_266_cov_2.162437_g93869_i0 | PRJNA1028258 | 94432 | 266 | 2.162437 | 5.75208242 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 84 | 1.59e-16 | NR | KAJ4454715.1 | 342808 | g93869 | i0 | 47.7 | 0.992481203007519 | 88 | 46 | 99.2 | 0 | 265 | 2 | 152 | 239 | KAJ4454715.1 putative protein kinase [Paratrimastix pyriformis] | diamond | 264 | 84 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 30919950 | 30919950 | PRJNA1028258_P_NODE_48774_length_363_cov_1.574830_g48211_i0 | PRJNA1028258 | 48774 | 363 | 1.57483 | 5.7166329 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 50.4 | 2.84e-4 | NR | KAK2958223.1 | 2049346 | g48211 | i0 | 33.7 | 0.735537190082645 | 89 | 58 | 72.7 | 1 | 2 | 265 | 580 | 668 | KAK2958223.1 hypothetical protein BLNAU_6710 [Blattamonas nauphoetae] | diamond | 267 | 50.4 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31014540 | 31014540 | PRJNA1028258_P_NODE_82315_length_284_cov_1.320930_g81752_i0 | PRJNA1028258 | 82315 | 284 | 1.32093 | 3.7514412 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 108 | 2.5500000000000003e-27 | NR | KAK2949112.1 | 2049346 | g81752 | i0 | 45.7 | 4.95422535211268 | 94 | 51 | 99.3 | 0 | 2 | 283 | 9 | 102 | KAK2949112.1 putative GTP-binding protein YPTM1 [Blattamonas nauphoetae] | diamond | 1407 | 108 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 31046450 | 31046450 | PRJNA1028258_P_NODE_92375_length_269_cov_1.065000_g91812_i0 | PRJNA1028258 | 92375 | 269 | 1.065 | 2.86485 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 70.9 | 1.5e-12 | NR | XP_067735787.1 | 2049356 | g91812 | i0 | 63.3 | 1.33828996282528 | 60 | 21 | 66.9 | 1 | 77 | 256 | 60 | 118 | XP_067735787.1 putative Signal transducing adapter molecule 2 [Monocercomonoides exilis] | diamond | 360 | 70.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31101258 | 31101258 | PRJNA1028258_P_NODE_96855_length_264_cov_1.333333_g96292_i0 | PRJNA1028258 | 96855 | 264 | 1.333333 | 3.51999912 | Streblomastigidae | 222438 | Preaxostyla | other_Eukaryota | 90.1 | 8.68e-19 | NR | KAA6402358.1 | 222440 | g96292 | i0 | 66.1 | 3.54545454545455 | 62 | 21 | 70.5 | 0 | 9 | 194 | 410 | 471 | KAA6402358.1 MAG: V-type H+-transporting ATPase subunit B [Streblomastix strix] | diamond | 936 | 90.9 | 0.991199119911991 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 31449316 | 31449316 | PRJNA1028258_P_NODE_173356_length_226_cov_0.904459_g172793_i0 | PRJNA1028258 | 173356 | 226 | 0.904459 | 2.04407734 | root | 1 | Root_unresolved | Root_unresolved | 78.2 | 1.02e-14 | NR | XP_067734055.1 | 2049356 | g172793 | i0 | 49.3 | 1.99115044247788 | 75 | 37 | 99.6 | 1 | 1 | 225 | 1799 | 1872 | XP_067734055.1 dynein haevy chain 9, inner dynein arm 5 [Monocercomonoides exilis] | diamond | 450 | 78.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 32216426 | 32216426 | PRJNA1028258_P_NODE_117778_length_246_cov_1.406780_g117215_i0 | PRJNA1028258 | 117778 | 246 | 1.40678 | 3.4606788 | Streblomastix strix | 222440 | Preaxostyla | other_Eukaryota | 116 | 1.8099999999999999e-28 | NR | KAA6383801.1 | 222440 | g117215 | i0 | 67.9 | 0.98780487804878 | 81 | 26 | 98.8 | 0 | 3 | 245 | 68 | 148 | KAA6383801.1 MAG: adenylate kinase [Streblomastix strix] | diamond | 243 | 116 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 32374734 | 32374734 | PRJNA1028258_P_NODE_62199_length_324_cov_1.113725_g61636_i0 | PRJNA1028258 | 62199 | 324 | 1.113725 | 3.608469 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 74.3 | 7.84e-13 | NR | KAK2953536.1 | 2049346 | g61636 | i0 | 49.1 | 0.527777777777778 | 57 | 29 | 52.8 | 0 | 154 | 324 | 103 | 159 | KAK2953536.1 putative Glycogen synthase kinase-3 beta [Blattamonas nauphoetae] | diamond | 171 | 74.3 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32469735 | 32469735 | PRJNA1028258_P_NODE_37379_length_414_cov_1.646377_g36816_i0 | PRJNA1028258 | 37379 | 414 | 1.646377 | 6.81600078 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 48.9 | 0.00159 | NR | KAJ4454930.1 | 342808 | g36816 | i0 | 33.8 | 0.536231884057971 | 74 | 48 | 52.9 | 1 | 174 | 392 | 474 | 547 | KAJ4454930.1 putative Ectonucleoside triphosphate diphosphohydrolase 3 [Paratrimastix pyriformis] | diamond | 222 | 48.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32784704 | 32784704 | PRJNA1028258_P_NODE_133360_length_235_cov_0.855422_g132797_i0 | PRJNA1028258 | 133360 | 235 | 0.855422 | 2.0102417 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 108 | 5.6e-27 | NR | KAK2950411.1 | 2049346 | g132797 | i0 | 61 | 5.93617021276596 | 77 | 30 | 98.3 | 0 | 231 | 1 | 39 | 115 | KAK2950411.1 putative Guanylate kinase 1 [Blattamonas nauphoetae] | diamond | 1395 | 108 | 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);;