RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA682774", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA682774 · 16 ✖

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
15203379 15203379 PRJNA682774_P_NODE_1752_length_337_cov_1.181818_g1723_i0 PRJNA682774 1752 337 1.181818 3.98272666 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 148 1.9e-42   NR CEO96142.1 37360 g1723 i0 62.2 0.98813056379822 111 39 98.8 2 333 1 26 133 CEO96142.1 hypothetical protein PBRA_004832 [Plasmodiophora brassicae] diamond 333 148 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17242556 17242556 PRJNA682774_P_NODE_1334_length_377_cov_1.276316_g1305_i0 PRJNA682774 1334 377 1.276316 4.81171132 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 142 1.74e-37   NR CEP02402.1 37360 g1305 i0 51.6 16.893899204244 126 60 99.5 1 1 375 200 325 CEP02402.1 hypothetical protein PBRA_008986 [Plasmodiophora brassicae] diamond 6369 142 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
19791581 19791581 PRJNA682774_P_NODE_3136_length_262_cov_1.650794_g3107_i0 PRJNA682774 3136 262 1.650794 4.32508028 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 169 5.94e-50   NR CEP01219.1 37360 g3107 i0 89.7 0.99618320610687 87 9 99.6 0 261 1 166 252 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 261 169 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
21067103 21067103 PRJNA682774_P_NODE_2997_length_268_cov_1.600000_g2968_i0 PRJNA682774 2997 268 1.6 4.288 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 141 3.31e-38   NR CEP01299.1 37360 g2968 i0 74.2 1.99253731343284 89 23 99.6 0 267 1 70 158 CEP01299.1 hypothetical protein PBRA_001905 [Plasmodiophora brassicae] diamond 534 141 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27366878 27366878 PRJNA682774_P_NODE_3543_length_252_cov_1.553073_g3514_i0 PRJNA682774 3543 252 1.553073 3.91374396 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.5 1.45e-8   NR CEO98920.1 37360 g3514 i0 61.2 1.70238095238095 49 19 58.3 0 249 103 202 250 CEO98920.1 hypothetical protein PBRA_007034 [Plasmodiophora brassicae] diamond 429 60.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27587754 27587754 PRJNA682774_P_NODE_5004_length_244_cov_0.912281_g4975_i0 PRJNA682774 5004 244 0.912281 2.22596564 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 119 2.44e-30   NR CEO99397.1 37360 g4975 i0 73.4 0.971311475409836 79 21 97.1 0 243 7 73 151 CEO99397.1 hypothetical protein PBRA_001303 [Plasmodiophora brassicae] diamond 237 119 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27966471 27966471 PRJNA682774_P_NODE_5145_length_243_cov_1.370588_g5116_i0 PRJNA682774 5145 243 1.370588 3.33052884 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 70.5 6.22e-12   NR CEP02690.1 37360 g5116 i0 47.4 0.938271604938272 76 37 93.8 1 242 15 108 180 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 228 70.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28029781 28029781 PRJNA682774_P_NODE_2065_length_314_cov_0.908714_g2036_i0 PRJNA682774 2065 314 0.908714 2.85336196 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 125 3.8800000000000005e-33   NR CEP01968.1 37360 g2036 i0 68.1 0.869426751592357 91 27 86.9 1 274 2 1 89 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 273 125 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28724352 28724352 PRJNA682774_P_NODE_3487_length_253_cov_0.866667_g3458_i0 PRJNA682774 3487 253 0.866667 2.19266751 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72.4 1.55e-12   NR CEO94323.1 37360 g3458 i0 40.2 1.1501976284585 97 39 92.5 1 19 252 731 827 CEO94323.1 hypothetical protein PBRA_000108 [Plasmodiophora brassicae] diamond 291 72.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29639659 29639659 PRJNA682774_P_NODE_1270_length_385_cov_1.557692_g1241_i0 PRJNA682774 1270 385 1.557692 5.9971142 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 102 2.07e-22   NR CEO98853.1 37360 g1241 i0 45.5 0.857142857142857 110 60 85.7 0 366 37 208 317 CEO98853.1 hypothetical protein PBRA_006967 [Plasmodiophora brassicae] diamond 330 102 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29860974 29860974 PRJNA682774_P_NODE_3591_length_252_cov_0.871508_g3562_i0 PRJNA682774 3591 252 0.871508 2.19620016 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 129 1.48e-35   NR CEO97156.1 37360 g3562 i0 69.9 2.96428571428571 83 25 98.8 0 2 250 69 151 CEO97156.1 hypothetical protein PBRA_005760 [Plasmodiophora brassicae] diamond 747 129 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30366901 30366901 PRJNA682774_P_NODE_3732_length_251_cov_1.314607_g3703_i0 PRJNA682774 3732 251 1.314607 3.29966357 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 112 2.45e-29   NR CEO96284.1 37360 g3703 i0 72 0.896414342629482 75 21 89.6 0 225 1 1 75 CEO96284.1 hypothetical protein PBRA_004955 [Plasmodiophora brassicae] diamond 225 112 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31199173 31199173 PRJNA682774_P_NODE_5035_length_244_cov_0.912281_g5006_i0 PRJNA682774 5035 244 0.912281 2.22596564 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 133 2.61e-35   NR CEP01756.1 37360 g5006 i0 76.9 26.2991803278689 78 18 95.9 0 1 234 303 380 CEP01756.1 hypothetical protein PBRA_008698 [Plasmodiophora brassicae] diamond 6417 133 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31883710 31883710 PRJNA682774_P_NODE_2317_length_299_cov_1.035398_g2288_i0 PRJNA682774 2317 299 1.035398 3.09584002 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 114 3.95e-27   NR CEO98004.1 37360 g2288 i0 54.6 1.92642140468227 97 41 97.3 1 299 9 4474 4567 CEO98004.1 hypothetical protein PBRA_006118 [Plasmodiophora brassicae] diamond 576 114 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31946900 31946900 PRJNA682774_P_NODE_2977_length_269_cov_1.510204_g2948_i0 PRJNA682774 2977 269 1.510204 4.06244876 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 53.5 6.4e-6   NR CEP02444.1 37360 g2948 i0 69.4 0.401486988847584 36 11 40.1 0 254 147 232 267 CEP02444.1 hypothetical protein PBRA_009028 [Plasmodiophora brassicae] diamond 108 53.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32358699 32358699 PRJNA682774_P_NODE_1839_length_330_cov_3.739300_g1810_i0 PRJNA682774 1839 330 3.7393 12.33969 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 115 1.01e-30   NR CEP02593.1 37360 g1810 i0 63 0.836363636363636 92 34 83.6 0 54 329 11 102 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 276 115 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);;