RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 18 ✖

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJEB14664 · 18 ✖

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
2571153 2571153 PRJEB14664_P_NODE_6483_length_323_cov_1.774306_g6353_i0 PRJEB14664 6483 323 1.774306 5.73100838 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 152 1.6099999999999998e-45   NR CEP03007.1 37360 g6353 i0 82.2 14.4984520123839 90 16 83.6 0 274 5 1 90 CEP03007.1 hypothetical protein PBRA_009225 [Plasmodiophora brassicae] diamond 4683 153 0.993464052287582 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
7673344 7673344 PRJEB14664_P_NODE_11867_length_214_cov_2.005587_g11737_i0 PRJEB14664 11867 214 2.005587 4.29195618 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 87 6.47e-18   NR SPQ94571.1 37360 g11737 i0 66.7 1.93457943925234 66 22 92.5 0 13 210 381 446 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 414 87 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
10224045 10224045 PRJEB14664_P_NODE_909_length_959_cov_2.989177_g837_i0 PRJEB14664 909 959 2.989177 28.66620743 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 335 1.2999999999999995e-111   NR CEO96095.1 37360 g837 i0 58.4 13.5860271115746 267 109 82.9 1 32 826 1 267 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 13029 335 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
12464898 12464898 PRJEB14664_P_NODE_18350_length_159_cov_1.822581_g18220_i0 PRJEB14664 18350 159 1.822581 2.89790379 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 98.2 2.5300000000000003e-22   NR CEO96295.1 37360 g18220 i0 84.6 6.86792452830189 52 8 98.1 0 157 2 332 383 CEO96295.1 hypothetical protein PBRA_004966 [Plasmodiophora brassicae] diamond 1092 98.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
16598110 16598110 PRJEB14664_P_NODE_6094_length_335_cov_2.133333_g5964_i0 PRJEB14664 6094 335 2.133333 7.14666555 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 172 1.3899999999999997e-52   NR CEO97530.1 37360 g5964 i0 79.2 1.83582089552239 101 21 90.4 0 32 334 1 101 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 615 172 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17872780 17872780 PRJEB14664_P_NODE_1455_length_766_cov_2.857729_g1358_i0 PRJEB14664 1455 766 2.857729 21.89020414 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 323 1.22e-108   NR CEP01968.1 37360 g1358 i0 66.9 20.4125326370757 245 74 96 2 9 743 7 244 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 15636 323 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
22973201 22973201 PRJEB14664_P_NODE_2179_length_623_cov_2.763605_g2068_i0 PRJEB14664 2179 623 2.763605 17.21725915 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 217 2.43e-68   NR CEO95143.1 37360 g2068 i0 60.1 6.77046548956661 183 71 88.1 2 29 577 1 181 CEO95143.1 hypothetical protein PBRA_003909 [Plasmodiophora brassicae] diamond 4218 218 0.995412844036697 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
22973251 22973251 PRJEB14664_P_NODE_6379_length_326_cov_3.161512_g6249_i0 PRJEB14664 6379 326 3.161512 10.30652912 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 144 9.909999999999998e-42   NR CEO94766.1 37360 g6249 i0 83.5 5.89877300613497 91 14 83.7 1 42 314 1 90 CEO94766.1 hypothetical protein PBRA_003579 [Plasmodiophora brassicae] diamond 1923 144 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
25211834 25211834 PRJEB14664_P_NODE_2640_length_560_cov_2.815238_g2525_i0 PRJEB14664 2640 560 2.815238 15.7653328 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 216 9.94e-69   NR CEO99151.1 37360 g2525 i0 76.6 9.825 141 32 75.5 1 28 450 7 146 CEO99151.1 hypothetical protein PBRA_001056 [Plasmodiophora brassicae] diamond 5502 216 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26931794 26931794 PRJEB14664_P_NODE_16322_length_173_cov_1.152174_g16192_i0 PRJEB14664 16322 173 1.152174 1.99326102 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 81.3 3.82e-16   NR CEO95180.1 37360 g16192 i0 68 1.66473988439306 50 16 86.7 0 21 170 548 597 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 288 81.6 0.996323529411765 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27475454 27475454 PRJEB14664_P_NODE_9663_length_247_cov_3.014151_g9533_i0 PRJEB14664 9663 247 3.014151 7.44495297 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 114 1.9699999999999999e-28   NR CEP02379.1 37360 g9533 i0 78.3 11.1497975708502 69 15 83.8 0 209 3 1 69 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 2754 114 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27595566 27595566 PRJEB14664_P_NODE_11364_length_221_cov_2.795699_g11234_i0 PRJEB14664 11364 221 2.795699 6.17849479 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.61e-11   NR CEO98408.1 37360 g11234 i0 40.3 1.95475113122172 72 43 97.7 0 2 217 332 403 CEO98408.1 hypothetical protein PBRA_006522 [Plasmodiophora brassicae] diamond 432 68.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28321555 28321555 PRJEB14664_P_NODE_11266_length_223_cov_1.351064_g11136_i0 PRJEB14664 11266 223 1.351064 3.01287272 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.8 2.29e-9   NR CEP03396.1 37360 g11136 i0 51.9 2.75784753363229 54 22 72.6 1 218 57 328 377 CEP03396.1 hypothetical protein PBRA_003156 [Plasmodiophora brassicae] diamond 615 63.2 0.993670886075949 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29552759 29552759 PRJEB14664_P_NODE_14570_length_187_cov_1.052632_g14440_i0 PRJEB14664 14570 187 1.052632 1.96842184 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00109   NR CEO99535.1 37360 g14440 i0 41.1 1.87700534759358 56 32 89.8 1 2 169 778 832 CEO99535.1 hypothetical protein PBRA_007268 [Plasmodiophora brassicae] diamond 351 46.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29552766 29552766 PRJEB14664_P_NODE_2890_length_534_cov_2.264529_g2771_i0 PRJEB14664 2890 534 2.264529 12.09258486 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 209 3.67e-64   NR CEO97280.1 37360 g2771 i0 56.3 24.5337078651685 174 76 97.8 0 7 528 16 189 CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] diamond 13101 210 0.995238095238095 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30152848 30152848 PRJEB14664_P_NODE_6092_length_335_cov_2.240000_g5962_i0 PRJEB14664 6092 335 2.24 7.504 root 1 Root_unresolved Root_unresolved 52.8 3.29e-5   NR CEP03244.1 37360 g5962 i0 51.1 0.895522388059702 47 23 42.1 0 228 88 235 281 CEP03244.1 hypothetical protein PBRA_003004 [Plasmodiophora brassicae] diamond 300 53.1 0.994350282485876 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31290515 31290515 PRJEB14664_P_NODE_9095_length_258_cov_3.044843_g8965_i0 PRJEB14664 9095 258 3.044843 7.85569494 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 1.57e-24   NR CEP01219.1 37360 g8965 i0 71.9 5.31395348837209 64 18 74.4 0 65 256 2 65 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 1371 103 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32594039 32594039 PRJEB14664_P_NODE_2200_length_619_cov_3.630137_g2088_i0 PRJEB14664 2200 619 3.630137 22.47054803 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 207 1.63e-64   NR CEP03344.1 37360 g2088 i0 61.7 0.78513731825525 162 62 78.5 0 1 486 29 190 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 486 207 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);;