RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA577580", 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 · 25 ✖

tax_clade 1

  • Sar · 25 ✖

bioproject 1

  • PRJNA577580 · 25 ✖

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
5667769 5667769 PRJNA577580_P_NODE_5005_length_401_cov_1.417683_g4927_i0 PRJNA577580 5005 401 1.417683 5.68490883 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 442 1.9499999999999988e-119   NTclustered gi|302026178|gb|GQ377695.1| 862247 g4927 i0 86.567 77.0299251870324 402 52 100 2 1 401 237 637 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 30889 442 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
12043070 12043070 PRJNA577580_P_NODE_1070_length_858_cov_2.453503_g1004_i0 PRJNA577580 1070 858 2.453503 21.05105574 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 483 2.59e-131   NTclustered gi|302026178|gb|GQ377695.1| 862247 g1004 i0 78.457 65.2657342657343 752 152 87 10 93 839 1283 537 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 55998 483 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
12617176 12617176 PRJNA577580_P_NODE_730_length_1014_cov_5.618491_g676_i0 PRJNA577580 730 1014 5.618491 56.97149874 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 316 5.73e-103   NR CEO99397.1 37360 g676 i0 52.4 3.35798816568047 294 136 85.8 3 2 871 8 301 CEO99397.1 hypothetical protein PBRA_001303 [Plasmodiophora brassicae] diamond 3405 316 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
15866677 15866677 PRJNA577580_P_NODE_14893_length_247_cov_2.637931_g14815_i0 PRJNA577580 14893 247 2.637931 6.51568957 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 113 4.86e-27   NR AVG22652.1 37360 g14815 i0 63.9 2.00404858299595 83 29 99.6 1 247 2 139 221 AVG22652.1 MAPKKK5 [Plasmodiophora brassicae] diamond 495 113 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
18415930 18415930 PRJNA577580_P_NODE_195_length_1574_cov_394.352432_g172_i0 PRJNA577580 195 1574 394.352432 6207.10727968 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 817 0   NTclustered gi|302026178|gb|GQ377695.1| 862247 g172 i0 78.264 67.3951715374841 1302 261 82 21 197 1487 1298 8 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 106080 817 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
19690413 19690413 PRJNA577580_P_NODE_10496_length_283_cov_1.976190_g10418_i0 PRJNA577580 10496 283 1.97619 5.5926177 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 129 1.05e-35   NR CEO98730.1 37360 g10418 i0 65.6 4.92932862190813 93 32 98.6 0 281 3 86 178 CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae] diamond 1395 129 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
22815302 22815302 PRJNA577580_P_NODE_2838_length_534_cov_1.462039_g2760_i0 PRJNA577580 2838 534 1.462039 7.80728826 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 256 3.03e-82   NR CEO95355.1 37360 g2760 i0 73.7 4.71910112359551 167 44 93.8 0 3 503 164 330 CEO95355.1 hypothetical protein PBRA_004121 [Plasmodiophora brassicae] diamond 2520 256 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26952934 26952934 PRJNA577580_P_NODE_15282_length_246_cov_0.901734_g15204_i0 PRJNA577580 15282 246 0.901734 2.21826564 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 88.2 3.99e-18   NR SPQ95577.1 37360 g15204 i0 54.8 1.02439024390244 84 36 100 1 246 1 616 699 SPQ95577.1 unnamed protein product [Plasmodiophora brassicae] diamond 252 88.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27490519 27490519 PRJNA577580_P_NODE_11203_length_275_cov_1.485149_g11125_i0 PRJNA577580 11203 275 1.485149 4.08415975 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 105 3.34e-24   NR CEO99922.1 37360 g11125 i0 51.5 2.00727272727273 99 38 97.1 2 272 6 89 187 CEO99922.1 hypothetical protein PBRA_007656 [Plasmodiophora brassicae] diamond 552 105 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27535574 27535574 PRJNA577580_P_NODE_3383_length_489_cov_4.788462_g3305_i0 PRJNA577580 3383 489 4.788462 23.41557918 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 114 5.670000000000001e-29   NR CEO98883.1 37360 g3305 i0 41.3 2.73006134969325 150 87 91.4 1 473 27 16 165 CEO98883.1 hypothetical protein PBRA_006997 [Plasmodiophora brassicae] diamond 1335 114 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29051230 29051230 PRJNA577580_P_NODE_14948_length_247_cov_1.689655_g14870_i0 PRJNA577580 14948 247 1.689655 4.17344785 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 125 4.7199999999999994e-35   NR CEO95284.1 37360 g14870 i0 77.6 15.17004048583 76 17 92.3 0 20 247 25 100 CEO95284.1 hypothetical protein PBRA_004050 [Plasmodiophora brassicae] diamond 3747 126 0.992063492063492 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29808706 29808706 PRJNA577580_P_NODE_12651_length_261_cov_1.372340_g12573_i0 PRJNA577580 12651 261 1.37234 3.5818074 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 102 4.159999999999999e-23   NR SPR00809.1 37360 g12573 i0 48.8 9.39080459770115 86 44 98.9 0 2 259 341 426 SPR00809.1 unnamed protein product [Plasmodiophora brassicae] diamond 2451 103 0.990291262135922 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29953317 29953317 PRJNA577580_P_NODE_9171_length_301_cov_0.846491_g9093_i0 PRJNA577580 9171 301 0.846491 2.54793791 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 94.7 3.86e-20   NR CEO94986.1 37360 g9093 i0 51.5 1.9734219269103 99 48 98.7 0 301 5 316 414 CEO94986.1 hypothetical protein PBRA_003799 [Plasmodiophora brassicae] diamond 594 94.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30566777 30566777 PRJNA577580_P_NODE_8693_length_308_cov_2.085106_g8615_i0 PRJNA577580 8693 308 2.085106 6.42212648 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 126 2.83e-32   NR CEO98710.1 37360 g8615 i0 71.1 1.65584415584416 83 21 80.8 1 58 306 4 83 CEO98710.1 hypothetical protein PBRA_006824 [Plasmodiophora brassicae] diamond 510 126 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30869491 30869491 PRJNA577580_P_NODE_2854_length_532_cov_3.152505_g2776_i0 PRJNA577580 2854 532 3.152505 16.7713266 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 276 2.4199999999999997e-85   NR CEP02690.1 37360 g2776 i0 72.7 0.992481203007519 176 48 99.2 0 531 4 145 320 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 528 276 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31090708 31090708 PRJNA577580_P_NODE_14335_length_250_cov_0.881356_g14257_i0 PRJNA577580 14335 250 0.881356 2.20339 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.57e-10   NR CEO95180.1 37360 g14257 i0 39.5 0.972 81 48 97.2 1 247 5 112 191 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 243 66.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31121952 31121952 PRJNA577580_P_NODE_815_length_968_cov_3.626816_g757_i0 PRJNA577580 815 968 3.626816 35.10757888 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 365 5.28e-117   NR CEP02690.1 37360 g757 i0 57.6 0.973140495867769 314 129 97.3 4 967 26 467 776 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 942 365 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31135458 31135458 PRJNA577580_P_NODE_17075_length_228_cov_2.361290_g16997_i0 PRJNA577580 17075 228 2.36129 5.3837412 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62 2.66e-9   NR CEO99991.1 37360 g16997 i0 55.8 1.46052631578947 52 23 68.4 0 164 9 34 85 CEO99991.1 hypothetical protein PBRA_007725 [Plasmodiophora brassicae] diamond 333 62 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31659746 31659746 PRJNA577580_P_NODE_5417_length_384_cov_1.993569_g5339_i0 PRJNA577580 5417 384 1.993569 7.65530496 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 140 1.21e-38   NR CEO99991.1 37360 g5339 i0 59.1 0.859375 110 45 85.9 0 334 5 40 149 CEO99991.1 hypothetical protein PBRA_007725 [Plasmodiophora brassicae] diamond 330 140 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31912967 31912967 PRJNA577580_P_NODE_12137_length_266_cov_1.067358_g12059_i0 PRJNA577580 12137 266 1.067358 2.83917228 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 128 1.25e-33   NR SPQ99343.1 37360 g12059 i0 71.6 0.913533834586466 81 23 91.4 0 24 266 183 263 SPQ99343.1 unnamed protein product [Plasmodiophora brassicae] diamond 243 128 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32071179 32071179 PRJNA577580_P_NODE_7898_length_321_cov_1.532258_g7820_i0 PRJNA577580 7898 321 1.532258 4.91854818 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 130 1.9299999999999998e-32   NR SPQ94571.1 37360 g7820 i0 59.4 0.990654205607477 106 43 99.1 0 2 319 268 373 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 318 130 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32084659 32084659 PRJNA577580_P_NODE_3418_length_487_cov_2.657005_g3340_i0 PRJNA577580 3418 487 2.657005 12.93961435 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 127 1.83e-34   NR CEO94564.1 37360 g3340 i0 59.8 1.25051334702259 102 40 62.2 1 468 166 24 125 CEO94564.1 hypothetical protein PBRA_000349 [Plasmodiophora brassicae] diamond 609 127 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32324625 32324625 PRJNA577580_P_NODE_16739_length_236_cov_2.380368_g16661_i0 PRJNA577580 16739 236 2.380368 5.61766848 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 101 2.1399999999999994e-23   NR CEO97972.1 37360 g16661 i0 57.3 0.953389830508475 75 32 95.3 0 12 236 286 360 CEO97972.1 hypothetical protein PBRA_006086 [Plasmodiophora brassicae] diamond 225 101 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32527896 32527896 PRJNA577580_P_NODE_13339_length_254_cov_1.723757_g13261_i0 PRJNA577580 13339 254 1.723757 4.37834278 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.9 2.94e-4   NR CEP00087.1 37360 g13261 i0 46 1.24015748031496 50 26 59.1 1 238 89 1280 1328 CEP00087.1 hypothetical protein PBRA_007821 [Plasmodiophora brassicae] diamond 315 49.3 0.991886409736308 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32892132 32892132 PRJNA577580_P_NODE_5960_length_367_cov_3.506803_g5882_i0 PRJNA577580 5960 367 3.506803 12.86996701 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 139 2.61e-35   NR CEP02690.1 37360 g5882 i0 53.7 0.989100817438692 121 56 98.9 0 3 365 305 425 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 363 139 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);;