RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1087264", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA1087264 · 21 ✖

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
194127 194127 PRJNA1087264_P_NODE_6941_length_240_cov_1.335079_g6859_i0 PRJNA1087264 6941 240 1.335079 3.2041896 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 146 4.04e-39   NR CEO97727.1 37360 g6859 i0 75.9 10.8625 79 19 98.8 0 239 3 148 226 CEO97727.1 hypothetical protein PBRA_005841 [Plasmodiophora brassicae] diamond 2607 146 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
1017357 1017357 PRJNA1087264_P_NODE_5881_length_263_cov_1.663551_g5799_i0 PRJNA1087264 5881 263 1.663551 4.37513913 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 81.3 2.93e-16   NR CEO97184.1 37360 g5799 i0 51.1 3.9467680608365 88 41 98.1 1 2 259 78 165 CEO97184.1 hypothetical protein PBRA_000529 [Plasmodiophora brassicae] diamond 1038 81.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4845530 4845530 PRJNA1087264_P_NODE_6664_length_245_cov_1.515306_g6582_i0 PRJNA1087264 6664 245 1.515306 3.7124997 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 7.56e-31   NR CEP01632.1 37360 g6582 i0 69.2 7.53061224489796 78 24 95.5 0 12 245 6 83 CEP01632.1 hypothetical protein PBRA_008575 [Plasmodiophora brassicae] diamond 1845 115 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
9121646 9121646 PRJNA1087264_P_NODE_1668_length_521_cov_2.531780_g1588_i0 PRJNA1087264 1668 521 2.53178 13.1905738 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 230 6.860000000000001e-73   NR CEO96095.1 37360 g1588 i0 63.8 3.7658349328215 163 59 93.9 0 31 519 1 163 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 1962 230 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
21870918 21870918 PRJNA1087264_P_NODE_738_length_776_cov_2.097662_g669_i0 PRJNA1087264 738 776 2.097662 16.27785712 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 291 8.369999999999999e-95   NR CEP01219.1 37360 g669 i0 80.1 1.29510309278351 171 28 63.8 1 1 495 149 319 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 1005 291 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26718949 26718949 PRJNA1087264_P_NODE_20121_length_162_cov_0.902655_g20039_i0 PRJNA1087264 20121 162 0.902655 1.4623011 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 58.9 8.44e-9   NR CEO98457.1 37360 g20039 i0 76.3 0.703703703703704 38 9 70.4 0 161 48 154 191 CEO98457.1 hypothetical protein PBRA_006571 [Plasmodiophora brassicae] diamond 114 58.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26877932 26877932 PRJNA1087264_P_NODE_13121_length_174_cov_1.224000_g13039_i0 PRJNA1087264 13121 174 1.224 2.12976 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0109   NR SPQ94190.1 37360 g13039 i0 42.3 1.81034482758621 52 29 87.9 1 9 161 1098 1149 SPQ94190.1 unnamed protein product [Plasmodiophora brassicae] diamond 315 43.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27447007 27447007 PRJNA1087264_P_NODE_5463_length_273_cov_2.049107_g5381_i0 PRJNA1087264 5463 273 2.049107 5.59406211 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 132 1.5300000000000002e-36   NR CEP01997.1 37360 g5381 i0 71.9 0.978021978021978 89 25 97.8 0 268 2 2 90 CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] diamond 267 132 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27573038 27573038 PRJNA1087264_P_NODE_1124_length_623_cov_2.771777_g1051_i0 PRJNA1087264 1124 623 2.771777 17.26817071 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 90.1 8.72e-20   NR CEP00957.1 37360 g1051 i0 82.6 1.3194221508828201 46 8 22.2 0 591 454 36 81 CEP00957.1 hypothetical protein PBRA_008269 [Plasmodiophora brassicae] diamond 822 90.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27659394 27659394 PRJNA1087264_P_NODE_9304_length_206_cov_2.923567_g9222_i0 PRJNA1087264 9304 206 2.923567 6.02254802 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 98.6 8.589999999999999e-23   NR CEP02379.1 37360 g9222 i0 84.5 46.1650485436893 58 9 84.5 0 32 205 1 58 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 9510 99.4 0.991951710261569 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28101100 28101100 PRJNA1087264_P_NODE_5685_length_267_cov_2.646789_g5603_i0 PRJNA1087264 5685 267 2.646789 7.06692663 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 117 2.2299999999999996e-31   NR CEO99768.1 37360 g5603 i0 65.8 1.70786516853933 76 26 85.4 0 39 266 1 76 CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] diamond 456 117 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28858895 28858895 PRJNA1087264_P_NODE_2248_length_448_cov_1.964912_g2167_i0 PRJNA1087264 2248 448 1.964912 8.80280576 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 55.1 2.79e-6   NR CEO94569.1 37360 g2167 i0 44.3 1.81473214285714 88 48 58.9 1 441 178 41 127 CEO94569.1 hypothetical protein PBRA_000354 [Plasmodiophora brassicae] diamond 813 55.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28930793 28930793 PRJNA1087264_P_NODE_288_length_1151_cov_2.195100_g245_i0 PRJNA1087264 288 1151 2.1951 25.265601 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 122 1.15e-26   NR CEO97105.1 37360 g245 i0 33.8 0.578627280625543 222 116 57.9 5 801 136 281 471 CEO97105.1 hypothetical protein PBRA_005710 [Plasmodiophora brassicae] diamond 666 122 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29215129 29215129 PRJNA1087264_P_NODE_4249_length_316_cov_1.337079_g4167_i0 PRJNA1087264 4249 316 1.337079 4.22516964 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 127 7.12e-35   NR CEO99768.1 37360 g4167 i0 61.4 1.67088607594937 88 34 83.5 0 264 1 1 88 CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] diamond 528 127 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29837705 29837705 PRJNA1087264_P_NODE_22031_length_156_cov_2.383178_g21949_i0 PRJNA1087264 22031 156 2.383178 3.71775768 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.9 2.59e-18   NR CEP01219.1 37360 g21949 i0 74 3.84615384615385 50 13 96.2 0 154 5 4 53 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 600 85.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30604563 30604563 PRJNA1087264_P_NODE_1553_length_538_cov_2.034765_g1475_i0 PRJNA1087264 1553 538 2.034765 10.9470357 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 215 9.87e-68   NR CEO96142.1 37360 g1475 i0 59.6 2.86059479553903 178 70 98.1 2 9 536 23 200 CEO96142.1 hypothetical protein PBRA_004832 [Plasmodiophora brassicae] diamond 1539 215 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31711053 31711053 PRJNA1087264_P_NODE_3817_length_334_cov_2.578947_g3735_i0 PRJNA1087264 3817 334 2.578947 8.61368298 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 153 2.79e-45   NR CEO97530.1 37360 g3735 i0 82 6.39520958083832 89 16 79.9 0 334 68 63 151 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 2136 153 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31797112 31797112 PRJNA1087264_P_NODE_3077_length_376_cov_2.244648_g2996_i0 PRJNA1087264 3077 376 2.244648 8.43987648 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 164 2.81e-47   NR CEO97280.1 37360 g2996 i0 61.6 2.96010638297872 125 48 99.7 0 2 376 121 245 CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] diamond 1113 164 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31932363 31932363 PRJNA1087264_P_NODE_1637_length_525_cov_2.941176_g1557_i0 PRJNA1087264 1637 525 2.941176 15.441174 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 186 1.09e-56   NR CEP03344.1 37360 g1557 i0 57.1 1.82285714285714 163 70 93.1 0 30 518 1 163 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 957 186 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32018792 32018792 PRJNA1087264_P_NODE_3398_length_356_cov_1.902280_g3317_i0 PRJNA1087264 3398 356 1.90228 6.7721168 Plasmodiophorida 37357 SAR_Eukaryotes SAR_Eukaryotes 122 6.55e-33   NR CEP02236.1 37360 g3317 i0 58.3 1.75280898876405 103 43 86.8 0 319 11 1 103 CEP02236.1 hypothetical protein PBRA_002501 [Plasmodiophora brassicae] diamond 624 123 0.991869918699187 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32375557 32375557 PRJNA1087264_P_NODE_2679_length_407_cov_1.483240_g2598_i0 PRJNA1087264 2679 407 1.48324 6.0367868 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 125 1.38e-32   NR CAL69925.1 37360 g2598 i0 61.8 2.10810810810811 102 39 75.2 0 99 404 20 121 CAL69925.1 hypothetical protein [Plasmodiophora brassicae] diamond 858 125 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);;