RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA915212", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 25 ✖

tax_clade 1

  • Sar · 25 ✖

bioproject 1

  • PRJNA915212 · 25 ✖

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
2170513 2170513 PRJNA915212_P_NODE_1622_length_522_cov_2.021142_g1587_i0 PRJNA915212 1622 522 2.021142 10.55036124 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 219 1.2e-68   NR CEO96095.1 37360 g1587 i0 61.3 2.81034482758621 163 63 93.7 0 32 520 1 163 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 1467 219 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4723640 4723640 PRJNA915212_P_NODE_1164_length_621_cov_6.739510_g1132_i0 PRJNA915212 1164 621 6.73951 41.8523571 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 223 1.79e-70   NR CEP02281.1 37360 g1132 i0 59.6 5.94202898550725 203 79 98.1 2 611 3 1 200 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3690 223 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4723712 4723712 PRJNA915212_P_NODE_7224_length_217_cov_1.821429_g7186_i0 PRJNA915212 7224 217 1.821429 3.95250093 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 99.4 6.62e-24   NR CEP01997.1 37360 g7186 i0 73.4 2.68202764976959 64 17 88.5 0 25 216 1 64 CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] diamond 582 99.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
5998342 5998342 PRJNA915212_P_NODE_10945_length_173_cov_1.645161_g10907_i0 PRJNA915212 10945 173 1.645161 2.84612853 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.86e-20   NR CEO97184.1 37360 g10907 i0 77.2 5.93063583815029 57 13 98.8 0 3 173 182 238 CEO97184.1 hypothetical protein PBRA_000529 [Plasmodiophora brassicae] diamond 1026 90.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
7629128 7629128 PRJNA915212_P_NODE_3506_length_334_cov_2.136842_g3469_i0 PRJNA915212 3506 334 2.136842 7.13705228 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 211 8.239999999999999e-66   NR CEP01219.1 37360 g3469 i0 85.6 0.997005988023952 111 16 99.7 0 2 334 137 247 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 333 211 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
8903874 8903874 PRJNA915212_P_NODE_2647_length_397_cov_2.189655_g2611_i0 PRJNA915212 2647 397 2.189655 8.69293035 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 148 5.9699999999999985e-43   NR SPQ93437.1 37360 g2611 i0 66.7 2.55415617128463 111 35 83.9 1 362 30 33 141 SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] diamond 1014 148 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
20021869 20021869 PRJNA915212_P_NODE_9836_length_185_cov_1.125000_g9798_i0 PRJNA915212 9836 185 1.125 2.08125 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 107 2.7699999999999993e-28   NR CEP02373.1 37360 g9798 i0 82 2.96756756756757 61 10 98.9 1 183 1 15 74 CEP02373.1 hypothetical protein PBRA_008957 [Plasmodiophora brassicae] diamond 549 107 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
25121189 25121189 PRJNA915212_P_NODE_10940_length_173_cov_1.830645_g10902_i0 PRJNA915212 10940 173 1.830645 3.16701585 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87 5.6e-21   NR CEO99669.1 37360 g10902 i0 84.3 0.884393063583815 51 8 88.4 0 20 172 1 51 CEO99669.1 hypothetical protein PBRA_007402 [Plasmodiophora brassicae] diamond 153 87 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26898108 26898108 PRJNA915212_P_NODE_14461_length_162_cov_0.902655_g14423_i0 PRJNA915212 14461 162 0.902655 1.4623011 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 75.5 9.81e-15   NR CEP01968.1 37360 g14423 i0 70.6 0.944444444444444 51 15 94.4 0 2 154 42 92 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 153 75.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27372574 27372574 PRJNA915212_P_NODE_14023_length_163_cov_0.894737_g13985_i0 PRJNA915212 14023 163 0.894737 1.45842131 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 81.6 1.85e-18   NR SPQ96840.1 37360 g13985 i0 82.4 2.74233128834356 51 7 90.2 1 16 162 1 51 SPQ96840.1 unnamed protein product [Plasmodiophora brassicae] diamond 447 81.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27372580 27372580 PRJNA915212_P_NODE_5123_length_264_cov_1.186047_g5085_i0 PRJNA915212 5123 264 1.186047 3.13116408 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00667   NR CEP02334.1 37360 g5085 i0 32.1 0.954545454545455 84 54 95.5 1 3 254 144 224 CEP02334.1 hypothetical protein PBRA_008918 [Plasmodiophora brassicae] diamond 252 45.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28256194 28256194 PRJNA915212_P_NODE_6546_length_229_cov_1.133333_g6508_i0 PRJNA915212 6546 229 1.133333 2.59533257 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 112 1.62e-29   NR CEP02737.1 37360 g6508 i0 66.7 0.982532751091703 75 25 98.3 0 3 227 52 126 CEP02737.1 hypothetical protein PBRA_002705 [Plasmodiophora brassicae] diamond 225 112 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28572025 28572025 PRJNA915212_P_NODE_11667_length_167_cov_1.296610_g11629_i0 PRJNA915212 11667 167 1.29661 2.1653387 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 59.7 8.58e-9   NR CEO99991.1 37360 g11629 i0 50.9 0.988023952095808 55 26 98.8 1 166 2 85 138 CEO99991.1 hypothetical protein PBRA_007725 [Plasmodiophora brassicae] diamond 165 59.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28603715 28603715 PRJNA915212_P_NODE_4207_length_297_cov_1.233871_g4169_i0 PRJNA915212 4207 297 1.233871 3.66459687 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 85.5 5.55e-18   NR CEO98592.1 37360 g4169 i0 52 0.757575757575758 75 36 75.8 0 297 73 139 213 CEO98592.1 hypothetical protein PBRA_006706 [Plasmodiophora brassicae] diamond 225 85.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28603725 28603725 PRJNA915212_P_NODE_9727_length_186_cov_1.116788_g9689_i0 PRJNA915212 9727 186 1.116788 2.07722568 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 65.1 2.24e-10   NR CEP02383.1 37360 g9689 i0 57.4 0.983870967741935 61 25 96.8 1 182 3 56 116 CEP02383.1 hypothetical protein PBRA_008967 [Plasmodiophora brassicae] diamond 183 65.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28635470 28635470 PRJNA915212_P_NODE_10007_length_183_cov_1.141791_g9969_i0 PRJNA915212 10007 183 1.141791 2.08947753 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 114 1.46e-27   NR CEO98004.1 37360 g9969 i0 80.3 1 61 12 100 0 1 183 2589 2649 CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] diamond 183 114 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28730010 28730010 PRJNA915212_P_NODE_9607_length_187_cov_1.485507_g9569_i0 PRJNA915212 9607 187 1.485507 2.77789809 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 57 2.87e-8   NR CEP01085.1 37360 g9569 i0 43.9 1.9572192513369 66 28 91.4 2 2 172 69 134 CEP01085.1 hypothetical protein PBRA_008397, partial [Plasmodiophora brassicae] diamond 366 57 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29014444 29014444 PRJNA915212_P_NODE_3848_length_314_cov_1.143396_g3810_i0 PRJNA915212 3848 314 1.143396 3.59026344 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 117 3.56e-28   NR SPQ93389.1 37360 g3810 i0 54.3 2.76114649681529 105 40 99.4 2 2 313 191 288 SPQ93389.1 unnamed protein product [Plasmodiophora brassicae] diamond 867 117 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29455800 29455800 PRJNA915212_P_NODE_9070_length_193_cov_1.395833_g9032_i0 PRJNA915212 9070 193 1.395833 2.69395769 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.9 6.19e-10   NR CEO98408.1 37360 g9032 i0 58.1 0.66839378238342 43 18 66.8 0 15 143 265 307 CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae] diamond 129 63.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31098680 31098680 PRJNA915212_P_NODE_13155_length_164_cov_1.330435_g13117_i0 PRJNA915212 13155 164 1.330435 2.1819134 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 67.4 1.45e-11   NR CEO96095.1 37360 g13117 i0 57.4 0.98780487804878 54 23 98.8 0 2 163 99 152 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 162 67.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31675277 31675277 PRJNA915212_P_NODE_8637_length_198_cov_1.429530_g8599_i0 PRJNA915212 8637 198 1.42953 2.8304694 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.18e-6   NR SPQ97132.1 37360 g8599 i0 38.7 3.75757575757576 62 36 93.9 1 8 193 588 647 SPQ97132.1 unnamed protein product [Plasmodiophora brassicae] diamond 744 53.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32427422 32427422 PRJNA915212_P_NODE_11039_length_172_cov_2.430894_g11001_i0 PRJNA915212 11039 172 2.430894 4.18113768 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.2 9.02e-10   NR SPQ94571.1 37360 g11001 i0 53.7 0.941860465116279 54 25 94.2 0 163 2 181 234 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 162 63.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32427434 32427434 PRJNA915212_P_NODE_6259_length_234_cov_2.221622_g6221_i0 PRJNA915212 6259 234 2.221622 5.19859548 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 84.3 3.93e-18   NR CEP03344.1 37360 g6221 i0 58.8 0.871794871794872 68 28 87.2 0 218 15 1 68 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 204 84.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32868820 32868820 PRJNA915212_P_NODE_6320_length_233_cov_1.760870_g6282_i0 PRJNA915212 6320 233 1.76087 4.1028271 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 116 1.6e-30   NR CEP02281.1 37360 g6282 i0 82.1 1.72532188841202 67 12 86.3 0 202 2 1 67 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 402 116 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32868826 32868826 PRJNA915212_P_NODE_9480_length_189_cov_1.000000_g9442_i0 PRJNA915212 9480 189 1 1.89 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.5 8.68e-9   NR SPQ98741.1 37360 g9442 i0 43.3 1.9047619047619 60 34 95.2 0 180 1 150 209 SPQ98741.1 unnamed protein product [Plasmodiophora brassicae] diamond 360 60.5 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);;