RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA453567" 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

  • PRJNA453567 · 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
1716816 1716816 PRJNA453567_P_NODE_9862_length_301_cov_3.234848_g9625_i0 PRJNA453567 9862 301 3.234848 9.73689248 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 134 6.6499999999999996e-34   NR CEP02690.1 37360 g9625 i0 62.2 0.976744186046512 98 35 97.7 2 7 300 597 692 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 294 134 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
3644424 3644424 PRJNA453567_P_NODE_29523_length_161_cov_1.564516_g29286_i0 PRJNA453567 29523 161 1.564516 2.51887076 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 99 1.24e-22   NR ADK90073.1 862247 g29286 i0 84.9 1.97515527950311 53 8 98.8 0 2 160 198 250 ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12] diamond 318 99 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
5545514 5545514 PRJNA453567_P_NODE_17845_length_211_cov_1.563218_g17608_i0 PRJNA453567 17845 211 1.563218 3.29838998 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 108 2.39e-26   NR CEO95355.1 37360 g17608 i0 65.2 3.95260663507109 69 24 98.1 0 210 4 66 134 CEO95355.1 hypothetical protein PBRA_004121 [Plasmodiophora brassicae] diamond 834 108 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
5545558 5545558 PRJNA453567_P_NODE_245_length_1925_cov_2.887182_g225_i0 PRJNA453567 245 1925 2.887182 55.5782535 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 598 7.79e-203   NR CEP02690.1 37360 g225 i0 52.1 1.84363636363636 599 271 92.9 5 1809 22 6 591 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 3549 598 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
13195365 13195365 PRJNA453567_P_NODE_12111_length_266_cov_1.532751_g11874_i0 PRJNA453567 12111 266 1.532751 4.07711766 root 1 Root_unresolved Root_unresolved 120 3.73e-30   NR CEP01299.1 37360 g11874 i0 67.9 8.95488721804511 81 26 91.4 0 2 244 309 389 CEP01299.1 hypothetical protein PBRA_001905 [Plasmodiophora brassicae] diamond 2382 121 0.991735537190083 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
17019075 17019075 PRJNA453567_P_NODE_1154_length_1097_cov_2.586792_g1058_i0 PRJNA453567 1154 1097 2.586792 28.37710824 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 268 1.0399999999999999e-82   NR CEP00240.1 37360 g1058 i0 48.4 18.0082041932543 287 138 78.5 2 229 1089 38 314 CEP00240.1 hypothetical protein PBRA_007974 [Plasmodiophora brassicae] diamond 19755 268 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28450547 28450547 PRJNA453567_P_NODE_28446_length_164_cov_1.535433_g28209_i0 PRJNA453567 28446 164 1.535433 2.51811012 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.4 2.98e-4   NR CEO95656.1 37360 g28209 i0 54.3 1.82926829268293 46 21 84.1 0 3 140 311 356 CEO95656.1 hypothetical protein PBRA_004382 [Plasmodiophora brassicae] diamond 300 47.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29602046 29602046 PRJNA453567_P_NODE_7430_length_360_cov_2.000000_g7193_i0 PRJNA453567 7430 360 2 7.2 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00283   NR CEP03439.1 37360 g7193 i0 38.1 0.7 84 37 63.3 3 248 21 38 114 CEP03439.1 hypothetical protein PBRA_003199 [Plasmodiophora brassicae] diamond 252 45.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29871230 29871230 PRJNA453567_P_NODE_23091_length_183_cov_1.328767_g22854_i0 PRJNA453567 23091 183 1.328767 2.43164361 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 77.4 8.99e-15   NR CEP00240.1 37360 g22854 i0 57.4 6.98360655737705 61 26 100 0 183 1 119 179 CEP00240.1 hypothetical protein PBRA_007974 [Plasmodiophora brassicae] diamond 1278 77.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30455622 30455622 PRJNA453567_P_NODE_32573_length_154_cov_0.948718_g32336_i0 PRJNA453567 32573 154 0.948718 1.46102572 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.4 2.5e-4   NR SPQ97943.1 37360 g32336 i0 44 0.974025974025974 50 25 97.4 1 3 152 464 510 SPQ97943.1 unnamed protein product [Plasmodiophora brassicae] diamond 150 47.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31719670 31719670 PRJNA453567_P_NODE_6997_length_373_cov_1.440476_g6760_i0 PRJNA453567 6997 373 1.440476 5.37297548 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 99 3.0900000000000003e-21   NR CEO95180.1 37360 g6760 i0 45.5 1.86595174262735 121 61 97.3 2 9 371 304 419 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 696 99 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32479169 32479169 PRJNA453567_P_NODE_10359_length_293_cov_1.058594_g10122_i0 PRJNA453567 10359 293 1.058594 3.10168042 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 131 1.04e-35   NR MES1918584.1 126728 g10122 i0 62.9 0.993174061433447 97 36 99.3 0 1 291 12 108 MES1918584.1 hypothetical protein [Bonamia ostreae] diamond 291 131 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
32574144 32574144 PRJNA453567_P_NODE_4279_length_511_cov_2.086498_g4046_i0 PRJNA453567 4279 511 2.086498 10.66200478 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.00664   NR CEP01705.1 37360 g4046 i0 50 1.41487279843444 60 29 35.2 1 493 314 617 675 CEP01705.1 hypothetical protein PBRA_008647 [Plasmodiophora brassicae] diamond 723 48.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32731370 32731370 PRJNA453567_P_NODE_1660_length_904_cov_2.262976_g1526_i0 PRJNA453567 1660 904 2.262976 20.45730304 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 224 8.58e-67   NR CEO99846.1 37360 g1526 i0 47.9 0.79646017699115 240 113 75.7 2 888 205 144 383 CEO99846.1 hypothetical protein PBRA_007580 [Plasmodiophora brassicae] diamond 720 224 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);;