RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where bioproject = "PRJNA688931", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 26 ✖

tax_clade 1

  • Sar · 26 ✖

bioproject 1

  • PRJNA688931 · 26 ✖

tax_kingdom 0

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
668417 668417 PRJNA688931_P_NODE_15861_length_258_cov_4.172249_g15648_i0 PRJNA688931 15861 258 4.172249 10.76440242 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.27e-13   NR CEO95757.1 37360 g15648 i0 57.7 0.906976744186046 78 32 89.5 1 235 5 1 78 CEO95757.1 hypothetical protein PBRA_004470 [Plasmodiophora brassicae] diamond 234 70.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
668669 668669 PRJNA688931_P_NODE_6901_length_414_cov_2.536986_g6688_i0 PRJNA688931 6901 414 2.536986 10.50312204 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 192 1.16e-58   NR CEO96095.1 37360 g6688 i0 65 0.992753623188406 137 48 99.3 0 412 2 38 174 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 411 192 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
3219286 3219286 PRJNA688931_P_NODE_20083_length_228_cov_2.005587_g19870_i0 PRJNA688931 20083 228 2.005587 4.57273836 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 110 2.98e-28   NR CEP00705.1 37360 g19870 i0 66.7 7.73684210526316 75 25 98.7 0 2 226 57 131 CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae] diamond 1764 110 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4496656 4496656 PRJNA688931_P_NODE_41584_length_163_cov_1.780702_g41371_i0 PRJNA688931 41584 163 1.780702 2.90254426 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 74.3 4.63e-15   NR CEO97530.1 37360 g41371 i0 79.1 0.791411042944785 43 9 79.1 0 35 163 1 43 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 129 74.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
5772099 5772099 PRJNA688931_P_NODE_28645_length_190_cov_1.418440_g28432_i0 PRJNA688931 28645 190 1.41844 2.695036 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 94 1.7e-20   NR CEO94374.1 37360 g28432 i0 66.1 47.0842105263158 62 21 97.9 0 189 4 465 526 CEO94374.1 hypothetical protein PBRA_000159 [Plasmodiophora brassicae] diamond 8946 94 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
6282055 6282055 PRJNA688931_P_NODE_2745_length_688_cov_82.276995_g2565_i0 PRJNA688931 2745 688 82.276995 566.0657256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 229 1.1e-72   NR CEP02281.1 37360 g2565 i0 61.3 4.50436046511628 204 76 89 2 670 59 1 201 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3099 229 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
8321539 8321539 PRJNA688931_P_NODE_15347_length_263_cov_2.308411_g15134_i0 PRJNA688931 15347 263 2.308411 6.07112093 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 129 6.18e-35   NR CEP01968.1 37360 g15134 i0 69 6.9467680608365 87 27 99.2 0 2 262 11 97 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 1827 130 0.992307692307692 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
9597208 9597208 PRJNA688931_P_NODE_728_length_1237_cov_2.755892_g649_i0 PRJNA688931 728 1237 2.755892 34.090384040000004 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 526 3.4199999999999984e-183   NR CEP02715.1 37360 g649 i0 69 30.911883589329 387 118 93.4 1 82 1236 25 411 CEP02715.1 hypothetical protein PBRA_002682 [Plasmodiophora brassicae] diamond 38238 526 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
10872472 10872472 PRJNA688931_P_NODE_17849_length_243_cov_1.257732_g17636_i0 PRJNA688931 17849 243 1.257732 3.05628876 uncultured Leptophryidae 2603696 SAR_Eukaryotes SAR_Eukaryotes 368 1.91e-97   NTclustered gi|1723854072|gb|MN323080.1| 2603696 g17636 i0 98.558 94.5637860082305 208 3 86 0 23 230 321 114 Uncultured Leptophryidae clone OTU0958 small subunit ribosomal RNA gene, partial sequence blastn 22979 368 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae   uncultured Leptophryidae
22346053 22346053 PRJNA688931_P_NODE_9698_length_340_cov_2.302405_g9485_i0 PRJNA688931 9698 340 2.302405 7.828177 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 144 1.1199999999999999e-40   NR CEP01997.1 37360 g9485 i0 65.1 2.90294117647059 109 38 96.2 0 339 13 21 129 CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] diamond 987 144 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
24894695 24894695 PRJNA688931_P_NODE_28120_length_192_cov_1.132867_g27907_i0 PRJNA688931 28120 192 1.132867 2.17510464 Filoreta japonica 536288 SAR_Eukaryotes SAR_Eukaryotes 161 2.6299999999999997e-35   NTclustered gi|302563028|dbj|AB546337.1| 536288 g27907 i0 81.771 75.9739583333333 192 35 100 0 1 192 302 111 Cercozoa sp. DDB-2008a EF-1a mRNA for elongation factor 1alpha, partial cds blastn 14587 161 1 Eukaryota Sar   Endomyxa       Filoreta Filoreta japonica
28566530 28566530 PRJNA688931_P_NODE_12387_length_296_cov_1.975709_g12174_i0 PRJNA688931 12387 296 1.975709 5.84809864 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 105 2.96e-27   NR CEP02593.1 37360 g12174 i0 63 0.820945945945946 81 30 82.1 0 243 1 11 91 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 243 105 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29702845 29702845 PRJNA688931_P_NODE_10170_length_331_cov_2.375887_g9957_i0 PRJNA688931 10170 331 2.375887 7.86418597 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 119 4.249999999999999e-31   NR CEP03344.1 37360 g9957 i0 69.2 0.706948640483384 78 24 70.7 0 331 98 115 192 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 234 119 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29734530 29734530 PRJNA688931_P_NODE_20070_length_228_cov_2.296089_g19857_i0 PRJNA688931 20070 228 2.296089 5.23508292 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 99.8 1.2999999999999998e-24   NR CEO96284.1 37360 g19857 i0 71.2 2.69736842105263 66 19 86.8 0 28 225 1 66 CEO96284.1 hypothetical protein PBRA_004955 [Plasmodiophora brassicae] diamond 615 99.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30019268 30019268 PRJNA688931_P_NODE_14291_length_274_cov_0.897778_g14078_i0 PRJNA688931 14291 274 0.897778 2.45991172 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.23e-11   NR SPQ96743.1 37360 g14078 i0 41 1.81751824817518 83 45 86.5 1 250 14 45 127 SPQ96743.1 unnamed protein product [Plasmodiophora brassicae] diamond 498 66.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30030735 30030735 PRJNA688931_P_NODE_7091_length_408_cov_2.086351_g6878_i0 PRJNA688931 7091 408 2.086351 8.51231208 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 135 5.519999999999999e-38   NR CEP01632.1 37360 g6878 i0 63.2 12.8897058823529 117 43 86 0 353 3 7 123 CEP01632.1 hypothetical protein PBRA_008575 [Plasmodiophora brassicae] diamond 5259 136 0.992647058823529 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30303926 30303926 PRJNA688931_P_NODE_13192_length_286_cov_1.725738_g12979_i0 PRJNA688931 13192 286 1.725738 4.93561068 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87.8 4.45e-19   NR CEP00705.1 37360 g12979 i0 47.7 2.81118881118881 88 45 92.3 1 284 21 107 193 CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae] diamond 804 87.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30777481 30777481 PRJNA688931_P_NODE_39734_length_165_cov_0.887931_g39521_i0 PRJNA688931 39734 165 0.887931 1.46508615 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 53.5 2.05e-6   NR CEP02402.1 37360 g39521 i0 53.7 0.745454545454545 41 19 74.5 0 162 40 351 391 CEP02402.1 hypothetical protein PBRA_008986 [Plasmodiophora brassicae] diamond 123 53.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30998661 30998661 PRJNA688931_P_NODE_7314_length_402_cov_1.770538_g7101_i0 PRJNA688931 7314 402 1.770538 7.11756276 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.45e-7   NR CEO94569.1 37360 g7101 i0 36.6 0.753731343283582 101 61 75.4 1 401 99 46 143 CEO94569.1 hypothetical protein PBRA_000354 [Plasmodiophora brassicae] diamond 303 57.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31167756 31167756 PRJNA688931_P_NODE_1915_length_818_cov_3.117035_g1759_i0 PRJNA688931 1915 818 3.117035 25.4973463 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 206 3.52e-56   NR SPQ94663.1 37360 g1759 i0 43.5 4.64669926650367 253 131 91 5 2 745 4415 4660 SPQ94663.1 unnamed protein product [Plasmodiophora brassicae] diamond 3801 207 0.995169082125604 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31314615 31314615 PRJNA688931_P_NODE_15955_length_258_cov_0.971292_g15742_i0 PRJNA688931 15955 258 0.971292 2.50593336 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 56.6 5.68e-7   NR CEO95180.1 37360 g15742 i0 36.3 0.930232558139535 80 50 91.9 1 14 250 130 209 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 240 56.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31314638 31314638 PRJNA688931_P_NODE_32615_length_176_cov_2.456693_g32402_i0 PRJNA688931 32615 176 2.456693 4.32377968 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.64e-10   NR CEP03344.1 37360 g32402 i0 56.9 0.869318181818182 51 22 86.9 0 160 8 18 68 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 153 63.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31409583 31409583 PRJNA688931_P_NODE_30896_length_182_cov_1.563910_g30683_i0 PRJNA688931 30896 182 1.56391 2.8463162 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.1 3.7e-9   NR CEP01202.1 37360 g30683 i0 48.3 1.91208791208791 58 30 95.6 0 174 1 104 161 CEP01202.1 hypothetical protein PBRA_008514 [Plasmodiophora brassicae] diamond 348 60.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31630838 31630838 PRJNA688931_P_NODE_10796_length_320_cov_2.280443_g10583_i0 PRJNA688931 10796 320 2.280443 7.2974176 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 105 3.05e-26   NR CEO97530.1 37360 g10583 i0 83.6 1.14375 61 10 57.2 0 320 138 91 151 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 366 105 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31725757 31725757 PRJNA688931_P_NODE_5877_length_453_cov_4.027228_g5665_i0 PRJNA688931 5877 453 4.027228 18.24334284 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 122 1.64e-32   NR CEP02737.1 37360 g5665 i0 65.1 0.56953642384106 86 30 57 0 452 195 64 149 CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] diamond 258 122 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32831901 32831901 PRJNA688931_P_NODE_17500_length_245_cov_2.086735_g17287_i0 PRJNA688931 17500 245 2.086735 5.11250075 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 63.2 2.31e-9   NR MES1920786.1 126728 g17287 i0 47.5 0.746938775510204 61 32 74.7 0 47 229 74 134 MES1920786.1 hypothetical protein [Bonamia ostreae] diamond 183 63.2 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;