RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA917598", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 22 ✖

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA917598 · 22 ✖

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
2527081 2527081 PRJNA917598_P_NODE_51742_length_318_cov_1.257143_g50798_i0 PRJNA917598 51742 318 1.257143 3.99771474 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 143 6.839999999999999e-40   NR CEO96095.1 37360 g50798 i0 60.4 1 106 42 100 0 318 1 128 233 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 318 143 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
11098784 11098784 PRJNA917598_P_NODE_12589_length_668_cov_1.515966_g11666_i0 PRJNA917598 12589 668 1.515966 10.12665288 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 210 2.53e-65   NR CEP03344.1 37360 g11666 i0 60 1.63023952095808 185 73 83.1 1 15 569 7 190 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 1089 210 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
13649261 13649261 PRJNA917598_P_NODE_27551_length_440_cov_1.258856_g26607_i0 PRJNA917598 27551 440 1.258856 5.5389664 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 157 1.6199999999999999e-46   NR CEO96069.1 37360 g26607 i0 67.9 8.20227272727273 112 36 76.4 0 430 95 5 116 CEO96069.1 hypothetical protein PBRA_004759 [Plasmodiophora brassicae] diamond 3609 158 0.993670886075949 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
21297573 21297573 PRJNA917598_P_NODE_24857_length_464_cov_1.181586_g23914_i0 PRJNA917598 24857 464 1.181586 5.48255904 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 152 3.34e-42   NR CEP01219.1 37360 g23914 i0 77 1.26077586206897 100 17 60.8 2 2 283 220 319 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 585 153 0.993464052287582 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
25122838 25122838 PRJNA917598_P_NODE_72820_length_266_cov_1.414508_g71876_i0 PRJNA917598 72820 266 1.414508 3.76259128 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 139 3.2400000000000004e-36   NR CEP00048.1 37360 g71876 i0 72.7 0.992481203007519 88 24 99.2 0 2 265 54 141 CEP00048.1 hypothetical protein PBRA_007782 [Plasmodiophora brassicae] diamond 264 139 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26992742 26992742 PRJNA917598_P_NODE_56002_length_304_cov_1.329004_g55058_i0 PRJNA917598 56002 304 1.329004 4.04017216 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 129 6.64e-33   NR CEP00050.1 37360 g55058 i0 70.5 0.9375 95 25 93.8 2 287 3 138 229 CEP00050.1 hypothetical protein PBRA_007784 [Plasmodiophora brassicae] diamond 285 129 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27087963 27087963 PRJNA917598_P_NODE_8062_length_845_cov_2.205959_g7232_i0 PRJNA917598 8062 845 2.205959 18.64035355 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 276 1.18e-88   NR CEO97280.1 37360 g7232 i0 53.6 2.87218934911243 267 117 94.4 3 798 1 10 270 CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] diamond 2427 276 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27435676 27435676 PRJNA917598_P_NODE_23223_length_481_cov_0.965686_g22281_i0 PRJNA917598 23223 481 0.965686 4.64494966 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 111 1.49e-28   NR CEP02593.1 37360 g22281 i0 59.8 0.573804573804574 92 37 57.4 0 22 297 11 102 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 276 111 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27782923 27782923 PRJNA917598_P_NODE_24804_length_464_cov_1.936061_g23861_i0 PRJNA917598 24804 464 1.936061 8.98332304 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.24e-15   NR SPQ94571.1 37360 g23861 i0 35.5 2.80603448275862 166 85 95 5 462 22 563 725 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 1302 84.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28319474 28319474 PRJNA917598_P_NODE_41366_length_357_cov_1.348592_g40422_i0 PRJNA917598 41366 357 1.348592 4.81447344 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 135 6.04e-36   NR CEP02379.1 37360 g40422 i0 62.5 1.98319327731092 120 42 98.3 3 352 2 116 235 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 708 135 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28477430 28477430 PRJNA917598_P_NODE_51986_length_317_cov_1.504098_g51042_i0 PRJNA917598 51986 317 1.504098 4.76799066 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 156 1.8899999999999998e-46   NR CEO97530.1 37360 g51042 i0 82.4 0.861198738170347 91 16 86.1 0 1 273 61 151 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 273 156 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28863501 28863501 PRJNA917598_P_NODE_61668_length_288_cov_1.232558_g60724_i0 PRJNA917598 61668 288 1.232558 3.54976704 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.7 3.66e-13   NR CEO98020.1 37360 g60724 i0 40.7 2.13541666666667 91 54 94.8 0 11 283 630 720 CEO98020.1 hypothetical protein PBRA_006134 [Plasmodiophora brassicae] diamond 615 74.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29014533 29014533 PRJNA917598_P_NODE_90348_length_244_cov_1.614035_g89404_i0 PRJNA917598 90348 244 1.614035 3.9382454 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.51e-9   NR SPR02116.1 37360 g89404 i0 43.4 0.934426229508197 76 40 93.4 2 3 230 113 185 SPR02116.1 unnamed protein product [Plasmodiophora brassicae] diamond 228 62.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29519348 29519348 PRJNA917598_P_NODE_83050_length_249_cov_0.875000_g82106_i0 PRJNA917598 83050 249 0.875 2.17875 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.63e-13   NR CEO98323.1 37360 g82106 i0 49.4 0.951807228915663 79 40 95.2 0 245 9 1898 1976 CEO98323.1 hypothetical protein PBRA_006437 [Plasmodiophora brassicae] diamond 237 75.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29519349 29519349 PRJNA917598_P_NODE_83350_length_249_cov_0.875000_g82406_i0 PRJNA917598 83350 249 0.875 2.17875 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.2 1.78e-9   NR CEP00713.1 37360 g82406 i0 45.7 0.843373493975904 70 37 83.1 1 229 23 4 73 CEP00713.1 hypothetical protein PBRA_001767 [Plasmodiophora brassicae] diamond 210 63.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29589465 29589465 PRJNA917598_P_NODE_84250_length_248_cov_0.880000_g83306_i0 PRJNA917598 84250 248 0.88 2.1824 root 1 Root_unresolved Root_unresolved 101 7.489999999999999e-23   NR SPQ95814.1 37360 g83306 i0 62.5 9.82258064516129 80 30 96.8 0 241 2 724 803 SPQ95814.1 unnamed protein product [Plasmodiophora brassicae] diamond 2436 102 0.990196078431373 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29930101 29930101 PRJNA917598_P_NODE_95751_length_241_cov_0.916667_g94807_i0 PRJNA917598 95751 241 0.916667 2.20916747 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.6 1.39e-10   NR SPR02116.1 37360 g94807 i0 42.5 0.908713692946058 73 39 90.9 1 233 15 222 291 SPR02116.1 unnamed protein product [Plasmodiophora brassicae] diamond 219 66.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29961452 29961452 PRJNA917598_P_NODE_74971_length_261_cov_1.638298_g74027_i0 PRJNA917598 74971 261 1.638298 4.27595778 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 85.5 2.18e-17   NR CEO97972.1 37360 g74027 i0 66.1 0.67816091954023 59 20 67.8 0 6 182 302 360 CEO97972.1 hypothetical protein PBRA_006086 [Plasmodiophora brassicae] diamond 177 85.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30032025 30032025 PRJNA917598_P_NODE_94031_length_242_cov_0.911243_g93087_i0 PRJNA917598 94031 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 106 7.9599999999999995e-25   NR CEO98916.1 37360 g93087 i0 68.1 11.7396694214876 69 21 84.3 1 1 204 148 216 CEO98916.1 hypothetical protein PBRA_007030 [Plasmodiophora brassicae] diamond 2841 106 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30341151 30341151 PRJNA917598_P_NODE_84892_length_248_cov_0.880000_g83948_i0 PRJNA917598 84892 248 0.88 2.1824 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 95.5 1.08e-20   NR CEO96359.1 37360 g83948 i0 57.1 2.74596774193548 77 33 93.1 0 13 243 263 339 CEO96359.1 hypothetical protein PBRA_005030 [Plasmodiophora brassicae] diamond 681 95.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31383573 31383573 PRJNA917598_P_NODE_74756_length_262_cov_1.216931_g73812_i0 PRJNA917598 74756 262 1.216931 3.18835922 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 119 5.7e-29   NR CEP00954.1 37360 g73812 i0 59.8 0.99618320610687 87 35 99.6 0 261 1 692 778 CEP00954.1 hypothetical protein PBRA_008266 [Plasmodiophora brassicae] diamond 261 119 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31415105 31415105 PRJNA917598_P_NODE_81576_length_250_cov_0.870056_g80632_i0 PRJNA917598 81576 250 0.870056 2.17514 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0156   NR CEO98348.1 37360 g80632 i0 36.4 1.584 66 42 79.2 0 249 52 352 417 CEO98348.1 hypothetical protein PBRA_006462 [Plasmodiophora brassicae] diamond 396 43.9 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);;