RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA556992", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA556992 · 18 ✖

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
4952919 4952919 PRJNA556992_P_NODE_1156844_length_200_cov_4.629921_g1154653_i0 PRJNA556992 1156844 200 4.629921 9.259842 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 147 1.19e-41   NR CEP01423.1 37360 g1154653 i0 95.5 24.75 66 3 99 0 199 2 192 257 CEP01423.1 hypothetical protein PBRA_002029 [Plasmodiophora brassicae] diamond 4950 147 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
6900679 6900679 PRJNA556992_P_NODE_1077466_length_218_cov_4.758621_g1075275_i0 PRJNA556992 1077466 218 4.758621 10.37379378 root 1 Root_unresolved Root_unresolved 111 1.97e-26   NR YP_010227886.1 41456 g1075275 i0 67.6 35.5733944954128 71 23 97.7 0 214 2 332 402 YP_010227886.1 NADH dehydrogenase subunit 5 [Polymyxa betae] diamond 7755 111 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Polymyxa Polymyxa betae
10734226 10734226 PRJNA556992_P_NODE_546029_length_263_cov_2.505263_g543840_i0 PRJNA556992 546029 263 2.505263 6.58884169 Bonamia sp. ex Ostrea sandvicensis 1168217 SAR_Eukaryotes SAR_Eukaryotes 121 6.489999999999999e-23   NTclustered gi|382930294|gb|JF831803.1| 1168217 g543840 i0 85 43.1520912547529 120 16 45 2 15 133 1668 1550 Bonamia sp. ex Ostrea sandvicensis small subunit ribosomal RNA gene, partial sequence blastn 11349 121 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia sp. ex Ostrea sandvicensis
26635525 26635525 PRJNA556992_P_NODE_890321_length_241_cov_2.244048_g888131_i0 PRJNA556992 890321 241 2.244048 5.40815568 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 120 1.6799999999999999e-29   NR CEP02451.1 37360 g888131 i0 68.8 0.995850622406639 80 25 99.6 0 240 1 1556 1635 CEP02451.1 hypothetical protein PBRA_009035 [Plasmodiophora brassicae] diamond 240 120 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27584150 27584150 PRJNA556992_P_NODE_724204_length_250_cov_0.870056_g722015_i0 PRJNA556992 724204 250 0.870056 2.17514 Paramarteilia canceri 2844372 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.022   NR MES1902539.1 2844372 g722015 i0 53.3 0.36 30 14 36 0 3 92 102 131 MES1902539.1 hypothetical protein [Paramarteilia canceri] diamond 90 42.4 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Paramarteilia Paramarteilia canceri
29510221 29510221 PRJNA556992_P_NODE_991950_length_231_cov_3.791139_g989760_i0 PRJNA556992 991950 231 3.791139 8.75753109 Marteilia pararefringens 2184066 SAR_Eukaryotes SAR_Eukaryotes 59.7 3.19e-9   NR MEN2500954.1 2184066 g989760 i0 46.5 3.64935064935065 71 38 92.2 0 221 9 27 97 MEN2500954.1 hypothetical protein [Marteilia pararefringens] diamond 843 59.7 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Marteilia Marteilia pararefringens
29681918 29681918 PRJNA556992_P_NODE_280790_length_292_cov_9.858447_g278601_i0 PRJNA556992 280790 292 9.858447 28.78666524 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 160 1.15e-48   NR CEO95284.1 37360 g278601 i0 84.2 21.3595890410959 95 15 97.6 0 6 290 25 119 CEO95284.1 hypothetical protein PBRA_004050 [Plasmodiophora brassicae] diamond 6237 160 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29825746 29825746 PRJNA556992_P_NODE_613751_length_258_cov_1.264865_g611562_i0 PRJNA556992 613751 258 1.264865 3.2633517 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 79 8.6e-15   NR CEO96332.1 37360 g611562 i0 41.4 3 87 49 98.8 1 4 258 1376 1462 CEO96332.1 hypothetical protein PBRA_005003 [Plasmodiophora brassicae] diamond 774 79 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29889302 29889302 PRJNA556992_P_NODE_785771_length_246_cov_10.514451_g783581_i0 PRJNA556992 785771 246 10.514451 25.86554946 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 114 3.47e-27   NR SPR02116.1 37360 g783581 i0 63 0.98780487804878 81 30 98.8 0 244 2 3721 3801 SPR02116.1 unnamed protein product [Plasmodiophora brassicae] diamond 243 114 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29920568 29920568 PRJNA556992_P_NODE_1155091_length_200_cov_6.346457_g1152900_i0 PRJNA556992 1155091 200 6.346457 12.692914 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00836   NR SPR00469.1 37360 g1152900 i0 34.4 3.405 64 34 96 2 5 196 129 184 SPR00469.1 unnamed protein product [Plasmodiophora brassicae] diamond 681 43.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30331746 30331746 PRJNA556992_P_NODE_328012_length_285_cov_1.349057_g325823_i0 PRJNA556992 328012 285 1.349057 3.84481245 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.05e-11   NR SPQ99902.1 37360 g325823 i0 46.6 0.768421052631579 73 37 76.8 1 65 283 84 154 SPQ99902.1 unnamed protein product [Plasmodiophora brassicae] diamond 219 70.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30395093 30395093 PRJNA556992_P_NODE_793753_length_246_cov_2.260116_g791563_i0 PRJNA556992 793753 246 2.260116 5.55988536 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 84 1.24e-16   NR CEO95240.1 37360 g791563 i0 46.3 2 82 44 100 0 1 246 516 597 CEO95240.1 hypothetical protein PBRA_004006 [Plasmodiophora brassicae] diamond 492 84 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30931565 30931565 PRJNA556992_P_NODE_213354_length_320_cov_1.870445_g211166_i0 PRJNA556992 213354 320 1.870445 5.985424 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0329   NR SPQ96330.1 37360 g211166 i0 42.1 0.35625 38 22 35.6 0 1 114 318 355 SPQ96330.1 unnamed protein product [Plasmodiophora brassicae] diamond 114 43.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31230118 31230118 PRJNA556992_P_NODE_1144655_length_202_cov_9.844961_g1142464_i0 PRJNA556992 1144655 202 9.844961 19.88682122 root 1 Root_unresolved Root_unresolved 114 1.3800000000000002e-27   NR CEP03720.1 37360 g1142464 i0 77.6 8.91089108910891 67 15 99.5 0 202 2 1041 1107 CEP03720.1 hypothetical protein PBRA_003327 [Plasmodiophora brassicae] diamond 1800 115 0.991304347826087 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31437481 31437481 PRJNA556992_P_NODE_779116_length_247_cov_1.454023_g776926_i0 PRJNA556992 779116 247 1.454023 3.59143681 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 120 2.45e-29   NR CEO95067.1 37360 g776926 i0 69.2 4.84615384615385 78 24 94.7 0 7 240 642 719 CEO95067.1 hypothetical protein PBRA_009599 [Plasmodiophora brassicae] diamond 1197 120 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31563993 31563993 PRJNA556992_P_NODE_1160696_length_199_cov_5.261905_g1158505_i0 PRJNA556992 1160696 199 5.261905 10.47119095 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87.8 1.74e-18   NR AVG22639.1 37360 g1158505 i0 60 1.89949748743719 65 26 98 0 3 197 306 370 AVG22639.1 MAPK1 [Plasmodiophora brassicae] diamond 378 87.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32070118 32070118 PRJNA556992_P_NODE_617818_length_257_cov_3.255435_g615629_i0 PRJNA556992 617818 257 3.255435 8.36646795 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00935   NR CEO96359.1 37360 g615629 i0 72 0.571984435797665 25 7 29.2 0 243 169 819 843 CEO96359.1 hypothetical protein PBRA_005030 [Plasmodiophora brassicae] diamond 147 44.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32355240 32355240 PRJNA556992_P_NODE_806719_length_245_cov_4.563953_g804529_i0 PRJNA556992 806719 245 4.563953 11.18168485 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.52e-9   NR CEP02606.1 37360 g804529 i0 55.3 2.2530612244898 38 17 46.5 0 2 115 86 123 CEP02606.1 hypothetical protein PBRA_002574 [Plasmodiophora brassicae] diamond 552 58.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);;