RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA908278", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 25 ✖

tax_clade 1

  • Sar · 25 ✖

bioproject 1

  • PRJNA908278 · 25 ✖

analysis 1

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
2165545 2165545 PRJNA908278_P_NODE_17562_length_304_cov_1.826840_g17459_i0 PRJNA908278 17562 304 1.82684 5.5535936 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 130 8.35e-36   NR CEO95143.1 37360 g17459 i0 66.3 8.9703947368421 101 34 99.7 0 303 1 27 127 CEO95143.1 hypothetical protein PBRA_003909 [Plasmodiophora brassicae] diamond 2727 130 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
2165817 2165817 PRJNA908278_P_NODE_8762_length_404_cov_2.030211_g8659_i0 PRJNA908278 8762 404 2.030211 8.20205244 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 152 1.6499999999999998e-42   NR CEO94341.1 37360 g8659 i0 64.5 4.52227722772277 121 41 89.1 2 43 402 18 137 CEO94341.1 hypothetical protein PBRA_000126 [Plasmodiophora brassicae] diamond 1827 152 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
3441055 3441055 PRJNA908278_P_NODE_24223_length_263_cov_1.621053_g24120_i0 PRJNA908278 24223 263 1.621053 4.26336939 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 144 6.689999999999998e-42   NR CEO97530.1 37360 g24120 i0 77.9 1.96197718631179 86 19 98.1 0 258 1 8 93 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 516 144 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
8543112 8543112 PRJNA908278_P_NODE_1567_length_871_cov_1.776942_g1485_i0 PRJNA908278 1567 871 1.776942 15.47716482 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 216 6.98e-62   NR SPQ98373.1 37360 g1485 i0 54 1.73249138920781 215 97 73.4 1 32 670 321 535 SPQ98373.1 unnamed protein product [Plasmodiophora brassicae] diamond 1509 216 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17468391 17468391 PRJNA908278_P_NODE_12374_length_351_cov_1.241007_g12271_i0 PRJNA908278 12374 351 1.241007 4.35593457 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 160 5.77e-45   NR CEO98766.1 37360 g12271 i0 62.6 28.4957264957265 115 43 98.3 0 348 4 297 411 CEO98766.1 hypothetical protein PBRA_006880 [Plasmodiophora brassicae] diamond 10002 161 0.993788819875776 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
25116197 25116197 PRJNA908278_P_NODE_14140_length_333_cov_1.184615_g14037_i0 PRJNA908278 14140 333 1.184615 3.94476795 Marteilia pararefringens 2184066 SAR_Eukaryotes SAR_Eukaryotes 122 4.679999999999999e-31   NR MEN2496193.1 2184066 g14037 i0 60.4 4.34234234234234 96 37 85.6 1 4 288 235 330 MEN2496193.1 recombinase rad51 [Marteilia pararefringens] diamond 1446 122 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Marteilia Marteilia pararefringens
26644325 26644325 PRJNA908278_P_NODE_31941_length_245_cov_0.895349_g31838_i0 PRJNA908278 31941 245 0.895349 2.19360505 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 112 1.57e-29   NR CEO99768.1 37360 g31838 i0 68.1 0.844897959183673 69 22 84.5 0 210 4 1 69 CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] diamond 207 112 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26929495 26929495 PRJNA908278_P_NODE_26682_length_251_cov_0.865169_g26579_i0 PRJNA908278 26682 251 0.865169 2.17157419 Marteilia pararefringens 2184066 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.09e-7   NR MEN2500347.1 2184066 g26579 i0 35 5.18725099601594 80 51 95.6 1 246 7 6 84 MEN2500347.1 Mismatch repair endonuclease pms2 [Marteilia pararefringens] diamond 1302 58.5 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Marteilia Marteilia pararefringens
27056090 27056090 PRJNA908278_P_NODE_23622_length_267_cov_1.190722_g23519_i0 PRJNA908278 23622 267 1.190722 3.17922774 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 119 3.6e-29   NR CEO97171.1 37360 g23519 i0 59.8 2.91011235955056 87 35 97.8 0 7 267 222 308 CEO97171.1 hypothetical protein PBRA_005775 [Plasmodiophora brassicae] diamond 777 119 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27403830 27403830 PRJNA908278_P_NODE_9143_length_397_cov_1.185185_g9040_i0 PRJNA908278 9143 397 1.185185 4.70518445 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 74.7 1.34e-12   NR CEO95180.1 37360 g9040 i0 38.7 0.937027707808564 124 72 92.2 3 397 32 103 224 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 372 74.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27474310 27474310 PRJNA908278_P_NODE_903_length_1074_cov_2.053946_g845_i0 PRJNA908278 903 1074 2.053946 22.05938004 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 101 3.44e-19   NR CEP02182.1 37360 g845 i0 32.5 2.11731843575419 379 213 99.4 14 4 1071 458 816 CEP02182.1 hypothetical protein PBRA_002447 [Plasmodiophora brassicae] diamond 2274 102 0.990196078431373 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27971974 27971974 PRJNA908278_P_NODE_29785_length_247_cov_1.327586_g29682_i0 PRJNA908278 29785 247 1.327586 3.27913742 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72 9.98e-13   NR CEP00552.1 37360 g29682 i0 43.6 0.947368421052632 78 42 94.7 1 1 234 165 240 CEP00552.1 hypothetical protein PBRA_001606 [Plasmodiophora brassicae] diamond 234 72 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28129966 28129966 PRJNA908278_P_NODE_1645_length_853_cov_1.856410_g1562_i0 PRJNA908278 1645 853 1.85641 15.8351773 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 138 5.96e-35   NR CEO99427.1 37360 g1562 i0 31.4 0.963657678780774 274 158 92.8 7 820 29 12 265 CEO99427.1 hypothetical protein PBRA_001333 [Plasmodiophora brassicae] diamond 822 138 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28161628 28161628 PRJNA908278_P_NODE_34745_length_242_cov_0.911243_g34642_i0 PRJNA908278 34745 242 0.911243 2.20520806 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 121 1.59e-32   NR CEP03344.1 37360 g34642 i0 72.2 1.99586776859504 79 22 97.9 0 242 6 84 162 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 483 121 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28287545 28287545 PRJNA908278_P_NODE_19386_length_291_cov_1.316514_g19283_i0 PRJNA908278 19386 291 1.316514 3.83105574 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 68.9 6.12e-12   NR MES1921420.1 126728 g19283 i0 55.7 1.43298969072165 61 27 62.9 0 106 288 21 81 MES1921420.1 hypothetical protein [Bonamia ostreae] diamond 417 68.9 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
28761254 28761254 PRJNA908278_P_NODE_3487_length_608_cov_6.704673_g3384_i0 PRJNA908278 3487 608 6.704673 40.76441184 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 219 5.08e-69   NR CEP02281.1 37360 g3384 i0 57.8 5.09210526315789 206 76 99.7 3 608 3 1 199 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3096 219 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28855900 28855900 PRJNA908278_P_NODE_19228_length_292_cov_1.406393_g19125_i0 PRJNA908278 19228 292 1.406393 4.10666756 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 129 4.7e-36   NR CEP03461.1 37360 g19125 i0 68.5 2.80479452054795 92 29 94.5 0 279 4 9 100 CEP03461.1 hypothetical protein PBRA_003222 [Plasmodiophora brassicae] diamond 819 129 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29810639 29810639 PRJNA908278_P_NODE_18411_length_298_cov_1.026667_g18308_i0 PRJNA908278 18411 298 1.026667 3.05946766 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.02e-19   NR CEO99241.1 37360 g18308 i0 46.1 14.1442953020134 102 52 99.7 1 297 1 937 1038 CEO99241.1 hypothetical protein PBRA_001147 [Plasmodiophora brassicae] diamond 4215 93.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29961169 29961169 PRJNA908278_P_NODE_10791_length_371_cov_1.291946_g10688_i0 PRJNA908278 10791 371 1.291946 4.79311966 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 110 2.46e-25   NR CEP02772.1 37360 g10688 i0 52.4 3.05660377358491 124 50 99.5 3 2 370 425 540 CEP02772.1 hypothetical protein PBRA_002739 [Plasmodiophora brassicae] diamond 1134 110 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30024602 30024602 PRJNA908278_P_NODE_33711_length_243_cov_0.905882_g33608_i0 PRJNA908278 33711 243 0.905882 2.20129326 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.48e-10   NR CEP00547.1 37360 g33608 i0 43.6 0.962962962962963 78 43 95.1 1 13 243 22 99 CEP00547.1 hypothetical protein PBRA_001601 [Plasmodiophora brassicae] diamond 234 66.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30372332 30372332 PRJNA908278_P_NODE_16152_length_315_cov_1.272727_g16049_i0 PRJNA908278 16152 315 1.272727 4.00909005 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 78.6 2.19e-14   NR SPQ97717.1 37360 g16049 i0 41.9 1.78095238095238 86 48 80 2 63 314 137 222 SPQ97717.1 unnamed protein product [Plasmodiophora brassicae] diamond 561 78.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31327364 31327364 PRJNA908278_P_NODE_35735_length_240_cov_2.005988_g35632_i0 PRJNA908278 35735 240 2.005988 4.8143712 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 113 2.799999999999999e-29   NR CEP02281.1 37360 g35632 i0 76.3 4.8 76 18 95 0 230 3 1 76 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 1152 113 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31414856 31414856 PRJNA908278_P_NODE_2776_length_676_cov_1.973466_g2674_i0 PRJNA908278 2776 676 1.973466 13.34063016 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 112 1.64e-24   NR CEO94594.1 37360 g2674 i0 31.8 0.989644970414201 223 141 99 4 670 2 382 593 CEO94594.1 hypothetical protein PBRA_000379 [Plasmodiophora brassicae] diamond 669 112 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31636179 31636179 PRJNA908278_P_NODE_24956_length_259_cov_1.295699_g24853_i0 PRJNA908278 24956 259 1.295699 3.35586041 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 54.3 3.59e-6   NR CEO99397.1 37360 g24853 i0 47.5 1.36679536679537 59 30 68.3 1 82 258 11 68 CEO99397.1 hypothetical protein PBRA_001303 [Plasmodiophora brassicae] diamond 354 54.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32900030 32900030 PRJNA908278_P_NODE_32160_length_245_cov_0.895349_g32057_i0 PRJNA908278 32160 245 0.895349 2.19360505 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 56.2 6.85e-7   NR SPQ98635.1 37360 g32057 i0 39.4 0.808163265306122 66 36 80.8 1 18 215 334 395 SPQ98635.1 unnamed protein product [Plasmodiophora brassicae] diamond 198 56.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae

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