RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA911178" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA911178 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
7270910 7270910 PRJNA911178_P_NODE_275446_length_244_cov_1.356725_g272972_i0 PRJNA911178 275446 244 1.356725 3.310409 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 80.9 2.84e-17   NR CEO95839.1 37360 g272972 i0 86.7 0.55327868852459 45 6 55.3 0 135 1 15 59 CEO95839.1 hypothetical protein PBRA_004552 [Plasmodiophora brassicae] diamond 135 80.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
16194969 16194969 PRJNA911178_P_NODE_202873_length_270_cov_1.532995_g200399_i0 PRJNA911178 202873 270 1.532995 4.1390865 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 145 3.27e-38   NR CEO95605.1 37360 g200399 i0 79.5 12.633333333333301 88 17 96.7 1 261 1 202 289 CEO95605.1 hypothetical protein PBRA_004331 [Plasmodiophora brassicae] diamond 3411 145 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
18744110 18744110 PRJNA911178_P_NODE_255495_length_248_cov_0.880000_g253021_i0 PRJNA911178 255495 248 0.88 2.1824 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 92.8 9.51e-20   NR AVG22654.1 37360 g253021 i0 66.7 0.870967741935484 72 23 87.1 1 217 2 434 504 AVG22654.1 MAPKKK7 [Plasmodiophora brassicae] diamond 216 92.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
20019158 20019158 PRJNA911178_P_NODE_253536_length_248_cov_2.571429_g251062_i0 PRJNA911178 253536 248 2.571429 6.37714392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 124 1.9199999999999999e-34   NR CEO95284.1 37360 g251062 i0 79.7 3.79838709677419 79 15 95.6 1 238 2 24 101 CEO95284.1 hypothetical protein PBRA_004050 [Plasmodiophora brassicae] diamond 942 125 0.992 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
23844856 23844856 PRJNA911178_P_NODE_261079_length_247_cov_0.885057_g258605_i0 PRJNA911178 261079 247 0.885057 2.18609079 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 105 3.3300000000000003e-26   NR CEP01084.1 37360 g258605 i0 65.8 3.8502024291498 79 27 96 0 10 246 85 163 CEP01084.1 hypothetical protein PBRA_008396 [Plasmodiophora brassicae] diamond 951 105 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27972014 27972014 PRJNA911178_P_NODE_112545_length_344_cov_1.136531_g110073_i0 PRJNA911178 112545 344 1.136531 3.90966664 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 178 5.7399999999999984e-55   NR CEO97530.1 37360 g110073 i0 78.6 0.976744186046512 112 24 97.7 0 9 344 7 118 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 336 178 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27972055 27972055 PRJNA911178_P_NODE_278445_length_244_cov_0.900585_g275971_i0 PRJNA911178 278445 244 0.900585 2.1974274 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87 9.34e-18   NR CEO97114.1 37360 g275971 i0 53.5 1.72131147540984 71 33 87.3 0 30 242 215 285 CEO97114.1 hypothetical protein PBRA_005718 [Plasmodiophora brassicae] diamond 420 87 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28295160 28295160 PRJNA911178_P_NODE_206866_length_268_cov_1.400000_g204392_i0 PRJNA911178 206866 268 1.4 3.752 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.01e-5   NR CEO99594.1 37360 g204392 i0 32.4 5.83208955223881 71 47 78.4 1 21 230 44 114 CEO99594.1 hypothetical protein PBRA_007327 [Plasmodiophora brassicae] diamond 1563 53.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28761326 28761326 PRJNA911178_P_NODE_270847_length_245_cov_0.895349_g268373_i0 PRJNA911178 270847 245 0.895349 2.19360505 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.2e-8   NR SPQ94367.1 37360 g268373 i0 47.3 1.81224489795918 74 39 90.6 0 19 240 3505 3578 SPQ94367.1 unnamed protein product [Plasmodiophora brassicae] diamond 444 61.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29968701 29968701 PRJNA911178_P_NODE_147591_length_307_cov_1.299145_g145118_i0 PRJNA911178 147591 307 1.299145 3.98837515 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.5 8.82e-16   NR CEO94977.1 37360 g145118 i0 48.8 2.25732899022801 84 34 82.1 1 13 264 169 243 CEO94977.1 hypothetical protein PBRA_003790 [Plasmodiophora brassicae] diamond 693 81.3 0.990159901599016 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30245864 30245864 PRJNA911178_P_NODE_234352_length_254_cov_1.154696_g231878_i0 PRJNA911178 234352 254 1.154696 2.93292784 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 62.8 3.32e-9   NR CEP02973.1 37360 g231878 i0 40 1.00393700787402 85 49 98 1 251 3 67 151 CEP02973.1 hypothetical protein PBRA_009191 [Plasmodiophora brassicae] diamond 255 62.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30435502 30435502 PRJNA911178_P_NODE_242653_length_251_cov_0.865169_g240179_i0 PRJNA911178 242653 251 0.865169 2.17157419 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 89 2.31e-18   NR SPR02116.1 37360 g240179 i0 47.6 1.00398406374502 84 43 99.2 1 3 251 1422 1505 SPR02116.1 unnamed protein product [Plasmodiophora brassicae] diamond 252 89 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31889291 31889291 PRJNA911178_P_NODE_267297_length_246_cov_0.890173_g264823_i0 PRJNA911178 267297 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 97.4 2.3400000000000003e-21   NR CEO96544.1 37360 g264823 i0 48.8 0.975609756097561 80 41 97.6 0 4 243 3447 3526 CEO96544.1 hypothetical protein PBRA_005153 [Plasmodiophora brassicae] diamond 240 97.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32015880 32015880 PRJNA911178_P_NODE_172478_length_287_cov_2.116822_g170005_i0 PRJNA911178 172478 287 2.116822 6.07527914 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 84.3 7.89e-18   NR CEP03344.1 37360 g170005 i0 57.1 0.804878048780488 77 33 80.5 0 56 286 7 83 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 231 84.3 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);;