RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJDB9741", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 19 ✖

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJDB9741 · 19 ✖

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
7663233 7663233 PRJDB9741_P_NODE_2587_length_454_cov_2.007407_g2273_i0 PRJDB9741 2587 454 2.007407 9.11362778 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 119 3.43e-29   NR CEP02379.1 37360 g2273 i0 48.2 0.905286343612335 137 68 88.5 2 454 53 174 310 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 411 119 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
16587877 16587877 PRJDB9741_P_NODE_37394_length_162_cov_1.353982_g37077_i0 PRJDB9741 37394 162 1.353982 2.19345084 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 88.2 1.6e-20   NR CEP02737.1 37360 g37077 i0 73.5 0.907407407407407 49 13 90.7 0 158 12 46 94 CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] diamond 147 88.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
25207985 25207985 PRJDB9741_P_NODE_3920_length_334_cov_1.863158_g3604_i0 PRJDB9741 3920 334 1.863158 6.22294772 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 152 7.909999999999999e-45   NR SPQ93437.1 37360 g3604 i0 67 2.91916167664671 109 36 97.9 0 3 329 34 142 SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] diamond 975 152 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26900094 26900094 PRJDB9741_P_NODE_5141_length_280_cov_2.194805_g4825_i0 PRJDB9741 5141 280 2.194805 6.145454 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 106 3.82e-26   NR CEO96912.1 37360 g4825 i0 57.8 2.80714285714286 90 36 94.3 1 278 15 133 222 CEO96912.1 hypothetical protein PBRA_005516 [Plasmodiophora brassicae] diamond 786 106 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26900095 26900095 PRJDB9741_P_NODE_6261_length_251_cov_2.316832_g5944_i0 PRJDB9741 6261 251 2.316832 5.81524832 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84 1.27e-16   NR CEP03404.1 37360 g5944 i0 48.8 2.85657370517928 82 40 95.6 1 12 251 328 409 CEP03404.1 hypothetical protein PBRA_003164 [Plasmodiophora brassicae] diamond 717 84 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26905970 26905970 PRJDB9741_P_NODE_33942_length_164_cov_0.886957_g33625_i0 PRJDB9741 33942 164 0.886957 1.45460948 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 45.1 4.86e-4   NR CEO95757.1 37360 g33625 i0 52.8 3.65853658536585 53 25 97 0 162 4 13 65 CEO95757.1 hypothetical protein PBRA_004470 [Plasmodiophora brassicae] diamond 600 45.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27032424 27032424 PRJDB9741_P_NODE_8442_length_217_cov_1.505952_g8125_i0 PRJDB9741 8442 217 1.505952 3.26791584 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 73.2 6.7e-14   NR CEP03344.1 37360 g8125 i0 69.4 0.67741935483871 49 15 67.7 0 216 70 142 190 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 147 73.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27190433 27190433 PRJDB9741_P_NODE_6542_length_245_cov_2.163265_g6225_i0 PRJDB9741 6542 245 2.163265 5.29999925 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 97.1 4.77e-24   NR CEP02593.1 37360 g6225 i0 63.2 0.930612244897959 76 28 93.1 0 230 3 11 86 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 228 97.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27474900 27474900 PRJDB9741_P_NODE_35303_length_163_cov_1.456140_g34986_i0 PRJDB9741 35303 163 1.45614 2.3735082 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 62 1.9e-9   NR CEP02392.1 37360 g34986 i0 50.9 0.975460122699387 53 26 97.5 0 3 161 218 270 CEP02392.1 hypothetical protein PBRA_008976 [Plasmodiophora brassicae] diamond 159 62 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27500710 27500710 PRJDB9741_P_NODE_28623_length_167_cov_0.864407_g28306_i0 PRJDB9741 28623 167 0.864407 1.44355969 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.73e-14   NR SPR00134.1 37360 g28306 i0 66.7 5.80239520958084 54 18 97 0 167 6 423 476 SPR00134.1 unnamed protein product [Plasmodiophora brassicae] diamond 969 75.9 0.994729907773386 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27853791 27853791 PRJDB9741_P_NODE_2305_length_489_cov_1.915909_g1991_i0 PRJDB9741 2305 489 1.915909 9.36879501 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 183 1.91e-54   NR CEO96095.1 37360 g1991 i0 52.9 0.950920245398773 155 73 95.1 0 489 25 113 267 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 465 183 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29211681 29211681 PRJDB9741_P_NODE_2329_length_486_cov_2.917620_g2015_i0 PRJDB9741 2329 486 2.91762 14.1796332 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 132 5.1999999999999994e-36   NR CEP02236.1 37360 g2015 i0 55.5 2.2037037037037 119 53 73.5 0 461 105 1 119 CEP02236.1 hypothetical protein PBRA_002501 [Plasmodiophora brassicae] diamond 1071 132 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29495664 29495664 PRJDB9741_P_NODE_2830_length_423_cov_2.927807_g2515_i0 PRJDB9741 2830 423 2.927807 12.38462361 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 65.5 2.43e-10   NR CEO99081.1 37360 g2515 i0 64.3 0.297872340425532 42 15 29.8 0 423 298 101 142 CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] diamond 126 65.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29811279 29811279 PRJDB9741_P_NODE_15271_length_186_cov_1.489051_g14954_i0 PRJDB9741 15271 186 1.489051 2.76963486 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.8 6.94e-9   NR CEO98408.1 37360 g14954 i0 60 0.645161290322581 40 16 64.5 0 137 18 263 302 CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae] diamond 120 60.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30184478 30184478 PRJDB9741_P_NODE_15312_length_186_cov_1.474453_g14995_i0 PRJDB9741 15312 186 1.474453 2.74248258 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.2 3.17e-13   NR CEP02402.1 37360 g14995 i0 55.9 2.83870967741935 59 26 95.2 0 4 180 73 131 CEP02402.1 hypothetical protein PBRA_008986 [Plasmodiophora brassicae] diamond 528 73.6 0.994565217391304 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31581263 31581263 PRJDB9741_P_NODE_15576_length_185_cov_3.926471_g15259_i0 PRJDB9741 15576 185 3.926471 7.26397135 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 84.3 2.2e-19   NR CEP02593.1 37360 g15259 i0 65.6 0.989189189189189 61 21 98.9 0 185 3 38 98 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 183 84.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31707587 31707587 PRJDB9741_P_NODE_19597_length_178_cov_2.666667_g19280_i0 PRJDB9741 19597 178 2.666667 4.74666726 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.5 8.72e-9   NR SPR02053.1 37360 g19280 i0 52.9 2.57865168539326 51 24 86 0 177 25 242 292 SPR02053.1 unnamed protein product [Plasmodiophora brassicae] diamond 459 60.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31891446 31891446 PRJDB9741_P_NODE_27457_length_167_cov_1.296610_g27140_i0 PRJDB9741 27457 167 1.29661 2.1653387 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 75.1 2.15e-15   NR CEO99151.1 37360 g27140 i0 74.5 8.44311377245509 47 12 84.4 0 142 2 7 53 CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae] diamond 1410 75.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32435626 32435626 PRJDB9741_P_NODE_13319_length_190_cov_1.085106_g13002_i0 PRJDB9741 13319 190 1.085106 2.0617014 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.4 4.38e-4   NR SPQ94571.1 37360 g13002 i0 53.5 0.678947368421053 43 20 67.9 0 130 2 174 216 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 129 47.4 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);;