RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA752572", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA752572 · 17 ✖

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
2476726 2476726 PRJNA752572_P_NODE_224002_length_177_cov_1.408451_g223495_i0 PRJNA752572 224002 177 1.408451 2.49295827 Marteilia pararefringens 2184066 SAR_Eukaryotes SAR_Eukaryotes 114 2.14e-28   NR MEN2497039.1 2184066 g223495 i0 93.2 35 59 4 100 0 177 1 222 280 MEN2497039.1 26S protease regulatory subunit 10B [Marteilia pararefringens] diamond 6195 114 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Marteilia Marteilia pararefringens
14757562 14757562 PRJNA752572_P_NODE_93932_length_279_cov_2.311475_g93425_i0 PRJNA752572 93932 279 2.311475 6.44901525 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 135 7.61e-38   NR CEO98730.1 37360 g93425 i0 68.5 2.96774193548387 92 29 98.9 0 3 278 84 175 CEO98730.1 hypothetical protein PBRA_006844 [Plasmodiophora brassicae] diamond 828 135 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17779090 17779090 PRJNA752572_P_NODE_16094_length_663_cov_27.197452_g15685_i0 PRJNA752572 16094 663 27.197452 180.31910676 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 229 7.91e-73   NR CEP02281.1 37360 g15685 i0 61.3 4.67420814479638 204 76 92.3 2 650 39 1 201 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3099 229 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27147236 27147236 PRJNA752572_P_NODE_138422_length_228_cov_1.062176_g137915_i0 PRJNA752572 138422 228 1.062176 2.42176128 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.08e-22   NR CEO98592.1 37360 g137915 i0 60 0.986842105263158 75 30 98.7 0 2 226 136 210 CEO98592.1 hypothetical protein PBRA_006706 [Plasmodiophora brassicae] diamond 225 95.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27748071 27748071 PRJNA752572_P_NODE_86144_length_292_cov_2.097276_g85637_i0 PRJNA752572 86144 292 2.097276 6.12404592 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 125 1.35e-33   NR CEP00705.1 37360 g85637 i0 60.4 20.7123287671233 96 38 98.6 0 292 5 61 156 CEP00705.1 hypothetical protein PBRA_001759 [Plasmodiophora brassicae] diamond 6048 125 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29105697 29105697 PRJNA752572_P_NODE_219008_length_179_cov_1.833333_g218501_i0 PRJNA752572 219008 179 1.833333 3.28166607 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.61e-21   NR SPR00538.1 37360 g218501 i0 72.9 5.93296089385475 59 16 98.9 0 177 1 561 619 SPR00538.1 unnamed protein product [Plasmodiophora brassicae] diamond 1062 96.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29673532 29673532 PRJNA752572_P_NODE_134630_length_231_cov_1.602041_g134123_i0 PRJNA752572 134630 231 1.602041 3.70071471 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 124 7.5e-34   NR CEO96142.1 37360 g134123 i0 71.1 0.987012987012987 76 22 98.7 0 230 3 73 148 CEO96142.1 hypothetical protein PBRA_004832 [Plasmodiophora brassicae] diamond 228 124 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30084323 30084323 PRJNA752572_P_NODE_174492_length_202_cov_1.670659_g173985_i0 PRJNA752572 174492 202 1.670659 3.37473118 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87 8.580000000000001e-21   NR CEP03709.1 37360 g173985 i0 73 6.08910891089109 63 15 93.6 1 12 200 5 65 CEP03709.1 hypothetical protein PBRA_003316 [Plasmodiophora brassicae] diamond 1230 87 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30306098 30306098 PRJNA752572_P_NODE_193992_length_191_cov_1.820513_g193485_i0 PRJNA752572 193992 191 1.820513 3.47717983 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.8 3.15e-4   NR CEO98916.1 37360 g193485 i0 41.4 0.910994764397906 58 31 88 2 191 24 384 440 CEO98916.1 hypothetical protein PBRA_007030 [Plasmodiophora brassicae] diamond 174 47.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30337684 30337684 PRJNA752572_P_NODE_20032_length_603_cov_1.691901_g19590_i0 PRJNA752572 20032 603 1.691901 10.20216303 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 150 4.42e-39   NR SPQ93160.1 37360 g19590 i0 43 2.49253731343284 172 90 83.6 3 5 508 9 176 SPQ93160.1 unnamed protein product [Plasmodiophora brassicae] diamond 1503 150 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30663037 30663037 PRJNA752572_P_NODE_121533_length_244_cov_1.282297_g121026_i0 PRJNA752572 121533 244 1.282297 3.12880468 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.36e-5   NR CEP03576.1 37360 g121026 i0 45.3 2.55737704918033 64 34 78.7 1 2 193 231 293 CEP03576.1 hypothetical protein PBRA_009461 [Plasmodiophora brassicae] diamond 624 52.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31073877 31073877 PRJNA752572_P_NODE_93395_length_280_cov_2.175510_g92888_i0 PRJNA752572 93395 280 2.17551 6.091428 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.06e-7   NR CEO99397.1 37360 g92888 i0 43.9 4.725 82 38 79.3 3 279 58 249 330 CEO99397.1 hypothetical protein PBRA_001303 [Plasmodiophora brassicae] diamond 1323 59.3 0.993254637436762 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31199765 31199765 PRJNA752572_P_NODE_204515_length_186_cov_1.324503_g204008_i0 PRJNA752572 204515 186 1.324503 2.46357558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0232   NR SPQ99938.1 37360 g204008 i0 36.2 2.70967741935484 58 24 72.6 1 151 17 155 212 SPQ99938.1 unnamed protein product [Plasmodiophora brassicae] diamond 504 42.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31800944 31800944 PRJNA752572_P_NODE_259097_length_166_cov_1.618321_g258590_i0 PRJNA752572 259097 166 1.618321 2.68641286 Plasmodiophorida 37357 SAR_Eukaryotes SAR_Eukaryotes 80.9 4.79e-16   NR SPQ99651.1 37360 g258590 i0 65.5 6.93975903614458 55 19 99.4 0 165 1 452 506 SPQ99651.1 unnamed protein product [Plasmodiophora brassicae] diamond 1152 81.6 0.991421568627451 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32012732 32012732 PRJNA752572_P_NODE_238318_length_172_cov_1.065693_g237811_i0 PRJNA752572 238318 172 1.065693 1.83299196 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.1 3.27e-9   NR CEP01202.1 37360 g237811 i0 52 1.74418604651163 50 24 87.2 0 10 159 104 153 CEP01202.1 hypothetical protein PBRA_008514 [Plasmodiophora brassicae] diamond 300 60.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32117627 32117627 PRJNA752572_P_NODE_178398_length_200_cov_1.200000_g177891_i0 PRJNA752572 178398 200 1.2 2.4 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 80.9 7.68e-16   NR CEP02383.1 37360 g177891 i0 60.6 4.98 66 25 97.5 1 198 4 567 632 CEP02383.1 hypothetical protein PBRA_008967 [Plasmodiophora brassicae] diamond 996 80.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32708095 32708095 PRJNA752572_P_NODE_70640_length_324_cov_1.567474_g70133_i0 PRJNA752572 70640 324 1.567474 5.07861576 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 76.6 9.47e-15   NR MES1921420.1 126728 g70133 i0 43.5 2.39814814814815 92 52 85.2 0 36 311 16 107 MES1921420.1 hypothetical protein [Bonamia ostreae] diamond 777 76.6 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae

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