contig_metadata
20 rows where bioproject = "PRJNA285816", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 372023 | 372023 | PRJNA285816_S_NODE_23661_length_169_cov_2.166667_g23559_i0 | PRJNA285816 | 23661 | 169 | 2.166667 | 3.66166723 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 62.1 | 2.34e-5 | NTclustered | gi|2794961090|ref|XM_067872496.1| | 2049356 | g23559 | i0 | 100 | 0.195266272189349 | 33 | 0 | 20 | 0 | 37 | 69 | 832 | 864 | Monocercomonoides exilis putative Protein kinase domain (MONOS_2570), partial mRNA | blastn | 33 | 62.1 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 6749559 | 6749559 | PRJNA285816_S_NODE_10806_length_224_cov_2.931429_g10704_i0 | PRJNA285816 | 10806 | 224 | 2.931429 | 6.56640096 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 130 | 3.98e-33 | NR | KAJ4458401.1 | 342808 | g10704 | i0 | 85.1 | 8.91964285714286 | 74 | 11 | 99.1 | 0 | 3 | 224 | 795 | 868 | KAJ4458401.1 ion-transporting P-type ATPase [Paratrimastix pyriformis] | diamond | 1998 | 130 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 10575823 | 10575823 | PRJNA285816_S_NODE_12069_length_216_cov_0.928144_g11967_i0 | PRJNA285816 | 12069 | 216 | 0.928144 | 2.00479104 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 60.2 | 1.14e-4 | NTclustered | gi|2794968903|ref|XM_067864552.1| | 2049356 | g11967 | i0 | 92.857 | 0.333333333333333 | 42 | 2 | 19 | 1 | 39 | 80 | 1037 | 997 | Monocercomonoides exilis uncharacterized protein (MONOS_11975), partial mRNA | blastn | 72 | 60.2 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 14400940 | 14400940 | PRJNA285816_S_NODE_1892_length_483_cov_1.239631_g1790_i0 | PRJNA285816 | 1892 | 483 | 1.239631 | 5.98741773 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 281 | 1.61e-84 | NR | KAJ4463032.1 | 342808 | g1790 | i0 | 82.6 | 4 | 161 | 27 | 99.4 | 1 | 481 | 2 | 1449 | 1609 | KAJ4463032.1 putative Pre-mRNA-splicing factor ATP-dependent RNA helicase DHX15 [Paratrimastix pyriformis] | diamond | 1932 | 281 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 16949227 | 16949227 | PRJNA285816_S_NODE_11014_length_223_cov_1.241379_g10912_i0 | PRJNA285816 | 11014 | 223 | 1.241379 | 2.76827517 | Paratrimastix eleionoma | 1709329 | Preaxostyla | other_Eukaryota | 75 | 4.23e-9 | NTclustered | gi|2443275956|gb|OP718926.1| | 1709329 | g10912 | i0 | 91.071 | 1.1838565022421501 | 56 | 4 | 25 | 1 | 28 | 82 | 490 | 545 | Paratrimastix eleionoma 60S ribosomal protein L9 mRNA, complete cds | blastn | 264 | 75 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix eleionoma | ||||
| 23324055 | 23324055 | PRJNA285816_S_NODE_23439_length_170_cov_1.322314_g23337_i0 | PRJNA285816 | 23439 | 170 | 1.322314 | 2.2479338 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 1.12e-25 | NR | XP_067727142.1 | 2049356 | g23337 | i0 | 83.6 | 4.85294117647059 | 55 | 9 | 97.1 | 0 | 169 | 5 | 64 | 118 | XP_067727142.1 putative 60S ribosomal protein L40, ubiquitin fusion protein [Monocercomonoides exilis] | diamond | 825 | 101 | 0.99009900990099 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 27895288 | 27895288 | PRJNA285816_S_NODE_20925_length_177_cov_2.007812_g20823_i0 | PRJNA285816 | 20925 | 177 | 2.007812 | 3.55382724 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 58.5 | 3.87e-8 | NR | XP_067725621.1 | 2049356 | g20823 | i0 | 49.1 | 0.966101694915254 | 57 | 27 | 96.6 | 1 | 174 | 4 | 26 | 80 | XP_067725621.1 putative methionyl-tRNA synthetase [Monocercomonoides exilis] | diamond | 171 | 58.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 28116312 | 28116312 | PRJNA285816_S_NODE_1365_length_561_cov_8.859375_g1271_i0 | PRJNA285816 | 1365 | 561 | 8.859375 | 49.70109375 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 92.8 | 3.49e-18 | NR | KAJ4455863.1 | 342808 | g1271 | i0 | 53.1 | 0.513368983957219 | 96 | 40 | 50.8 | 2 | 19 | 303 | 440 | 531 | KAJ4455863.1 putative glycine-rich RNA binding protein [Paratrimastix pyriformis] | diamond | 288 | 92.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28242550 | 28242550 | PRJNA285816_S_NODE_7306_length_261_cov_2.900943_g7204_i0 | PRJNA285816 | 7306 | 261 | 2.900943 | 7.57146123 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 75.9 | 4.9e-14 | NR | KAJ4461183.1 | 342808 | g7204 | i0 | 50 | 0.988505747126437 | 86 | 39 | 97.7 | 2 | 3 | 257 | 95 | 177 | KAJ4461183.1 putative WD repeat protein 61 [Paratrimastix pyriformis] | diamond | 258 | 75.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 28590215 | 28590215 | PRJNA285816_S_NODE_4587_length_319_cov_2.103704_g4485_i0 | PRJNA285816 | 4587 | 319 | 2.103704 | 6.71081576 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 73.9 | 9.78e-13 | NR | KAJ4458280.1 | 342808 | g4485 | i0 | 38.2 | 0.959247648902821 | 102 | 61 | 95.9 | 1 | 5 | 310 | 32 | 131 | KAJ4458280.1 hypothetical protein PAPYR_5955 [Paratrimastix pyriformis] | diamond | 306 | 73.9 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29032310 | 29032310 | PRJNA285816_S_NODE_27788_length_164_cov_0.904348_g27686_i0 | PRJNA285816 | 27788 | 164 | 0.904348 | 1.48313072 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 66.6 | 4.76e-11 | NR | KAJ4462146.1 | 342808 | g27686 | i0 | 61.2 | 0.896341463414634 | 49 | 19 | 89.6 | 0 | 17 | 163 | 597 | 645 | KAJ4462146.1 putative Protein arginine N-methyltransferase 6 [Paratrimastix pyriformis] | diamond | 147 | 66.6 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 29586166 | 29586166 | PRJNA285816_S_NODE_2910_length_393_cov_1.590116_g2808_i0 | PRJNA285816 | 2910 | 393 | 1.590116 | 6.24915588 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 0.00308 | NR | KAA6395931.1 | 222440 | g2808 | i0 | 48.1 | 1.38167938931298 | 54 | 25 | 38.9 | 1 | 391 | 239 | 381 | 434 | KAA6395931.1 MAG: putative Eukaryotic translation initiation factor 1A [Streblomastix strix] | diamond | 543 | 47.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Streblomastigidae | Streblomastix | Streblomastix strix | |||
| 29663185 | 29663185 | PRJNA285816_S_NODE_2990_length_387_cov_7.775148_g2888_i0 | PRJNA285816 | 2990 | 387 | 7.775148 | 30.08982276 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 124 | 7.03e-34 | NR | XP_067728480.1 | 2049356 | g2888 | i0 | 51.9 | 3.27131782945736 | 106 | 51 | 82.2 | 0 | 3 | 320 | 1 | 106 | XP_067728480.1 Thioredoxin [Monocercomonoides exilis] | diamond | 1266 | 124 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Polymastigidae | Monocercomonoides | Monocercomonoides exilis | |||
| 31211097 | 31211097 | PRJNA285816_S_NODE_24375_length_168_cov_2.403361_g24273_i0 | PRJNA285816 | 24375 | 168 | 2.403361 | 4.03764648 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 92.8 | 5.77e-22 | NR | KAJ4460458.1 | 342808 | g24273 | i0 | 78.8 | 2.85714285714286 | 52 | 11 | 92.9 | 0 | 157 | 2 | 36 | 87 | KAJ4460458.1 putative Protein mago nashi [Paratrimastix pyriformis] | diamond | 480 | 92.8 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31577285 | 31577285 | PRJNA285816_S_NODE_4636_length_318_cov_1.594796_g4534_i0 | PRJNA285816 | 4636 | 318 | 1.594796 | 5.07145128 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 1.67e-11 | NR | KAJ4460347.1 | 342808 | g4534 | i0 | 58.3 | 1.30188679245283 | 60 | 24 | 55.7 | 1 | 215 | 39 | 1269 | 1328 | KAJ4460347.1 putative Protein kinase domain superfamily protein [Paratrimastix pyriformis] | diamond | 414 | 71.2 | 0.990168539325843 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31622701 | 31622701 | PRJNA285816_S_NODE_11236_length_221_cov_1.651163_g11134_i0 | PRJNA285816 | 11236 | 221 | 1.651163 | 3.64907023 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 63.5 | 1.07e-9 | NR | KAJ4459671.1 | 342808 | g11134 | i0 | 48.6 | 0.97737556561086 | 72 | 28 | 85.5 | 1 | 219 | 31 | 34 | 105 | KAJ4459671.1 putative Cysteine proteinase 3 [Paratrimastix pyriformis] | diamond | 216 | 63.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 31749155 | 31749155 | PRJNA285816_S_NODE_77_length_1868_cov_7.918637_g68_i0 | PRJNA285816 | 77 | 1868 | 7.918637 | 147.92013916 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 295 | 1.01e-84 | NR | KAJ4456955.1 | 342808 | g68 | i0 | 36 | 0.873661670235546 | 544 | 273 | 84.3 | 20 | 143 | 1717 | 103 | 590 | KAJ4456955.1 putative pregnancy-associated plasma protein A; pappalysin 1 [Paratrimastix pyriformis] | diamond | 1632 | 295 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32445588 | 32445588 | PRJNA285816_S_NODE_28159_length_163_cov_3.350877_g28057_i0 | PRJNA285816 | 28159 | 163 | 3.350877 | 5.46192951 | Blattamonas nauphoetae | 2049346 | Preaxostyla | other_Eukaryota | 85.5 | 6.18e-18 | NR | KAK2956218.1 | 2049346 | g28057 | i0 | 73.6 | 0.975460122699387 | 53 | 14 | 97.5 | 0 | 160 | 2 | 198 | 250 | KAK2956218.1 putative GTP-binding protein [Blattamonas nauphoetae] | diamond | 159 | 85.5 | 1 | Eukaryota | Metamonada | Preaxostyla | Oxymonadida | Blattamonas | Blattamonas nauphoetae | ||||
| 32603393 | 32603393 | PRJNA285816_S_NODE_2060_length_461_cov_3.138350_g1958_i0 | PRJNA285816 | 2060 | 461 | 3.13835 | 14.4677935 | Paratrimastix pyriformis | 342808 | Preaxostyla | other_Eukaryota | 107 | 1.1099999999999999e-23 | NR | KAJ4454393.1 | 342808 | g1958 | i0 | 42.8 | 0.898047722342733 | 138 | 78 | 89.8 | 1 | 46 | 459 | 1361 | 1497 | KAJ4454393.1 putative Alpha-actinin A [Paratrimastix pyriformis] | diamond | 414 | 107 | 1 | Eukaryota | Metamonada | Preaxostyla | Paratrimastigidae | Paratrimastix | Paratrimastix pyriformis | ||||
| 32697680 | 32697680 | PRJNA285816_S_NODE_10060_length_230_cov_1.762431_g9958_i0 | PRJNA285816 | 10060 | 230 | 1.762431 | 4.0535913 | Monocercomonoides exilis | 2049356 | Preaxostyla | other_Eukaryota | 110 | 6.250000000000001e-26 | NR | XP_067734145.1 | 2049356 | g9958 | i0 | 60 | 1.95652173913043 | 75 | 30 | 97.8 | 0 | 6 | 230 | 21 | 95 | XP_067734145.1 putative SRSF protein kinase 1 [Monocercomonoides exilis] | diamond | 450 | 110 | 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);;