RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1214993 · 18 ✖

analysis 1

  • diamond · 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
330204 330204 PRJNA1214993_P_NODE_11981_length_318_cov_2.224490_g11795_i0 PRJNA1214993 11981 318 2.22449 7.0738782 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 188 5.22e-57   NR CEP01219.1 37360 g11795 i0 83.7 0.981132075471698 104 17 98.1 0 6 317 141 244 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 312 188 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
330347 330347 PRJNA1214993_P_NODE_4401_length_508_cov_1.560920_g4216_i0 PRJNA1214993 4401 508 1.56092 7.9294736 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 160 1.8e-45   NR CEO97184.1 37360 g4216 i0 58.4 2.49212598425197 154 57 89.8 3 53 508 5 153 CEO97184.1 hypothetical protein PBRA_000529 [Plasmodiophora brassicae] diamond 1266 160 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
6708055 6708055 PRJNA1214993_P_NODE_12046_length_317_cov_2.581967_g11860_i0 PRJNA1214993 12046 317 2.581967 8.18483539 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 184 1.5e-57   NR CEP00218.1 37360 g11860 i0 76.9 13.7507886435331 104 24 98.4 0 315 4 45 148 CEP00218.1 hypothetical protein PBRA_007952 [Plasmodiophora brassicae] diamond 4359 184 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
7983653 7983653 PRJNA1214993_P_NODE_10587_length_337_cov_1.477273_g10401_i0 PRJNA1214993 10587 337 1.477273 4.97841001 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 108 6.8e-25   NR CEO94323.1 37360 g10401 i0 61.6 0.765578635014837 86 33 76.6 0 65 322 892 977 CEO94323.1 hypothetical protein PBRA_000108 [Plasmodiophora brassicae] diamond 258 108 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
7983688 7983688 PRJNA1214993_P_NODE_14587_length_290_cov_1.078341_g14401_i0 PRJNA1214993 14587 290 1.078341 3.1271889 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 159 1.13e-47   NR CEO97530.1 37360 g14401 i0 82.8 0.962068965517241 93 16 96.2 0 6 284 59 151 CEO97530.1 hypothetical protein PBRA_000875 [Plasmodiophora brassicae] diamond 279 159 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
8698401 8698401 PRJNA1214993_P_NODE_2667_length_644_cov_2.182137_g2490_i0 PRJNA1214993 2667 644 2.182137 14.05296228 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 228 2.56e-72   NR CEP02281.1 37360 g2490 i0 61.1 4.77950310559006 203 76 94.6 2 1 609 2 201 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3078 228 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
15633131 15633131 PRJNA1214993_P_NODE_1213_length_921_cov_2.251179_g1072_i0 PRJNA1214993 1213 921 2.251179 20.73335859 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 281 7.0099999999999986e-90   NR CEO98669.1 37360 g1072 i0 51.6 7.28338762214984 281 129 90.9 5 85 921 30 305 CEO98669.1 hypothetical protein PBRA_006783 [Plasmodiophora brassicae] diamond 6708 281 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27452084 27452084 PRJNA1214993_P_NODE_15423_length_283_cov_2.166667_g15237_i0 PRJNA1214993 15423 283 2.166667 6.13166761 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 86.7 8.88e-18   NR SPQ94171.1 37360 g15237 i0 48.8 1.78091872791519 84 43 89 0 283 32 153 236 SPQ94171.1 unnamed protein product [Plasmodiophora brassicae] diamond 504 86.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28525592 28525592 PRJNA1214993_P_NODE_7087_length_405_cov_1.716867_g6902_i0 PRJNA1214993 7087 405 1.716867 6.95331135 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 135 1.93e-37   NR CEP02429.1 37360 g6902 i0 47.8 0.992592592592593 134 69 99.3 1 405 4 1 133 CEP02429.1 hypothetical protein PBRA_009013 [Plasmodiophora brassicae] diamond 402 135 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28683469 28683469 PRJNA1214993_P_NODE_9127_length_361_cov_1.895833_g8941_i0 PRJNA1214993 9127 361 1.895833 6.84395713 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 147 5.709999999999999e-42   NR CEP03344.1 37360 g8941 i0 64.2 0.880886426592798 106 38 88.1 0 360 43 87 192 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 318 147 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29270219 29270219 PRJNA1214993_P_NODE_25389_length_243_cov_0.917647_g25203_i0 PRJNA1214993 25389 243 0.917647 2.22988221 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 109 1.54e-26   NR SPQ97444.1 37360 g25203 i0 73.8 13.8271604938272 80 21 98.8 0 242 3 51 130 SPQ97444.1 unnamed protein product [Plasmodiophora brassicae] diamond 3360 110 0.990909090909091 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29914881 29914881 PRJNA1214993_P_NODE_17031_length_271_cov_1.575758_g16845_i0 PRJNA1214993 17031 271 1.575758 4.27030418 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 121 5.26e-32   NR CEP00157.1 37360 g16845 i0 68.6 0.952029520295203 86 27 95.2 0 1 258 13 98 CEP00157.1 hypothetical protein PBRA_007891 [Plasmodiophora brassicae] diamond 258 121 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30186178 30186178 PRJNA1214993_P_NODE_7292_length_400_cov_0.828746_g7106_i0 PRJNA1214993 7292 400 0.828746 3.314984 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.3 3.69e-13   NR CEO97072.1 37360 g7106 i0 36.4 4.6275 121 72 88.5 2 363 10 39 157 CEO97072.1 hypothetical protein PBRA_005676 [Plasmodiophora brassicae] diamond 1851 74.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31178247 31178247 PRJNA1214993_P_NODE_9595_length_353_cov_1.114286_g9409_i0 PRJNA1214993 9595 353 1.114286 3.93342958 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 73.2 3.49e-13   NR CEP03344.1 37360 g9409 i0 71.1 0.382436260623229 45 13 38.2 0 3 137 146 190 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 135 73.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31893114 31893114 PRJNA1214993_P_NODE_25957_length_242_cov_0.923077_g25771_i0 PRJNA1214993 25957 242 0.923077 2.23384634 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.6 4.25e-14   NR CEP02735.1 37360 g25771 i0 56.3 6.94214876033058 80 35 99.2 0 242 3 175 254 CEP02735.1 hypothetical protein PBRA_002702 [Plasmodiophora brassicae] diamond 1680 76.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31969175 31969175 PRJNA1214993_P_NODE_4738_length_490_cov_4.275779_g4553_i0 PRJNA1214993 4738 490 4.275779 20.9513171 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 175 3.56e-51   NR SPQ93792.1 37360 g4553 i0 62 1.73265306122449 142 53 86.9 1 26 451 157 297 SPQ93792.1 unnamed protein product [Plasmodiophora brassicae] diamond 849 175 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32444151 32444151 PRJNA1214993_P_NODE_20519_length_251_cov_0.876404_g20333_i0 PRJNA1214993 20519 251 0.876404 2.19977404 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 88.6 6.81e-20   NR CEO95938.1 37360 g20333 i0 81.8 5.25896414342629 55 10 65.7 0 248 84 119 173 CEO95938.1 hypothetical protein PBRA_004628 [Plasmodiophora brassicae] diamond 1320 88.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32589337 32589337 PRJNA1214993_P_NODE_19019_length_257_cov_0.934783_g18833_i0 PRJNA1214993 19019 257 0.934783 2.40239231 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 134 1.75e-37   NR CEP02281.1 37360 g18833 i0 77.1 1.93774319066148 83 19 96.9 0 250 2 1 83 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 498 135 0.992592592592593 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);;