RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA270367", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA270367 · 17 ✖

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
4197209 4197209 PRJNA270367_P_NODE_35464_length_182_cov_1.330827_g35259_i0 PRJNA270367 35464 182 1.330827 2.42210514 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 237 3.98e-58   NTclustered gi|302026178|gb|GQ377695.1| 862247 g35259 i0 90.503 96.8296703296703 179 17 98 0 3 181 448 270 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 17623 237 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
5473302 5473302 PRJNA270367_P_NODE_19165_length_278_cov_0.908297_g18960_i0 PRJNA270367 19165 278 0.908297 2.52506566 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 94.4 9.13e-21   NR CEP01219.1 37360 g18960 i0 68.7 1.35971223021583 67 15 65.8 2 2 184 253 319 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 378 94.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
6747718 6747718 PRJNA270367_P_NODE_27226_length_217_cov_1.976190_g27021_i0 PRJNA270367 27226 217 1.97619 4.2883323 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 97.4 2.4599999999999994e-23   NR CEP03344.1 37360 g27021 i0 67.2 0.926267281105991 67 22 92.6 0 3 203 96 162 CEP03344.1 hypothetical protein PBRA_003104 [Plasmodiophora brassicae] diamond 201 97.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
9986463 9986463 PRJNA270367_P_NODE_4508_length_644_cov_2.672269_g4319_i0 PRJNA270367 4508 644 2.672269 17.20941236 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 228 2.56e-72   NR CEP02281.1 37360 g4319 i0 61.1 4.77950310559006 203 76 94.6 2 2 610 2 201 CEP02281.1 hypothetical protein PBRA_008865 [Plasmodiophora brassicae] diamond 3078 228 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
18221849 18221849 PRJNA270367_P_NODE_42695_length_166_cov_0.888889_g42490_i0 PRJNA270367 42695 166 0.888889 1.47555574 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 94.4 7.9e-21   NR CEO97304.1 37360 g42490 i0 85.2 8.78313253012048 54 8 97.6 0 3 164 391 444 CEO97304.1 hypothetical protein PBRA_000649 [Plasmodiophora brassicae] diamond 1458 95.1 0.992639327024185 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27249801 27249801 PRJNA270367_P_NODE_4443_length_648_cov_2.459098_g4254_i0 PRJNA270367 4443 648 2.459098 15.93495504 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.2 4.69e-11   NR CEP03425.1 37360 g4254 i0 44 5.35185185185185 91 51 42.1 0 276 548 466 556 CEP03425.1 hypothetical protein PBRA_003185 [Plasmodiophora brassicae] diamond 3468 73.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27326973 27326973 PRJNA270367_P_NODE_43223_length_165_cov_1.344828_g43018_i0 PRJNA270367 43223 165 1.344828 2.2189662 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.04e-11   NR CEP00440.1 37360 g43018 i0 56.4 1 55 23 100 1 1 165 189 242 CEP00440.1 hypothetical protein PBRA_001494 [Plasmodiophora brassicae] diamond 165 68.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27926872 27926872 PRJNA270367_P_NODE_13185_length_360_cov_1.163987_g12981_i0 PRJNA270367 13185 360 1.163987 4.1903532 Marteilia pararefringens 2184066 SAR_Eukaryotes SAR_Eukaryotes 51.2 1.36e-4   NR MEN2500583.1 2184066 g12981 i0 25 0.733333333333333 88 63 70.8 1 272 18 227 314 MEN2500583.1 protein phosphatase 2, regulatory subunit A [Marteilia pararefringens] diamond 264 51.2 1 Eukaryota Sar   Endomyxa Ascetosporea Paramyxida Marteiliidae Marteilia Marteilia pararefringens
28148044 28148044 PRJNA270367_P_NODE_33365_length_190_cov_1.106383_g33160_i0 PRJNA270367 33365 190 1.106383 2.1021277 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 115 2.44e-29   NR CEP01219.1 37360 g33160 i0 74.6 0.994736842105263 63 16 99.5 0 189 1 142 204 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 189 115 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28495368 28495368 PRJNA270367_P_NODE_6007_length_557_cov_1.478346_g5814_i0 PRJNA270367 6007 557 1.478346 8.23438722 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 51.2 8.81e-4   NR CEP02182.1 37360 g5814 i0 31.9 0.980251346499102 182 100 89.9 7 22 522 430 602 CEP02182.1 hypothetical protein PBRA_002447 [Plasmodiophora brassicae] diamond 546 51.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28684867 28684867 PRJNA270367_P_NODE_7687_length_487_cov_1.470320_g7489_i0 PRJNA270367 7687 487 1.47032 7.1604584 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 118 1.61e-28   NR CEP00080.1 37360 g7489 i0 50.5 0.646817248459959 105 51 64.1 1 487 176 243 347 CEP00080.1 hypothetical protein PBRA_007814 [Plasmodiophora brassicae] diamond 315 118 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29158460 29158460 PRJNA270367_P_NODE_32849_length_192_cov_0.874126_g32644_i0 PRJNA270367 32849 192 0.874126 1.67832192 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 85.5 1.64e-17   NR SPQ96061.1 37360 g32644 i0 67.2 3.984375 64 21 100 0 1 192 161 224 SPQ96061.1 unnamed protein product [Plasmodiophora brassicae] diamond 765 85.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29316111 29316111 PRJNA270367_P_NODE_20189_length_268_cov_0.949772_g19984_i0 PRJNA270367 20189 268 0.949772 2.54538896 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 42 0.0203   NR CEO99145.1 37360 g19984 i0 34.8 0.772388059701492 69 42 73.9 1 266 69 11 79 CEO99145.1 hypothetical protein PBRA_001050 [Plasmodiophora brassicae] diamond 207 42 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29568655 29568655 PRJNA270367_P_NODE_37790_length_174_cov_1.248000_g37585_i0 PRJNA270367 37790 174 1.248 2.17152 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 74.7 8.03e-14   NR CEP02690.1 37360 g37585 i0 60.4 0.913793103448276 53 20 91.4 1 159 1 594 645 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 159 74.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30218077 30218077 PRJNA270367_P_NODE_22072_length_251_cov_1.237624_g21867_i0 PRJNA270367 22072 251 1.237624 3.10643624 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.1 5.04e-17   NR CEO95456.1 37360 g21867 i0 51.4 4.37450199203187 72 35 86.1 0 251 36 508 579 CEO95456.1 hypothetical protein PBRA_004182 [Plasmodiophora brassicae] diamond 1098 85.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30660477 30660477 PRJNA270367_P_NODE_6473_length_533_cov_2.047521_g6277_i0 PRJNA270367 6473 533 2.047521 10.91328693 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 247 4.8200000000000006e-79   NR CEO94341.1 37360 g6277 i0 65.5 41.0825515947467 171 57 96.2 1 533 21 137 305 CEO94341.1 hypothetical protein PBRA_000126 [Plasmodiophora brassicae] diamond 21897 248 0.995967741935484 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30990468 30990468 PRJNA270367_P_NODE_36094_length_180_cov_1.190840_g35889_i0 PRJNA270367 36094 180 1.19084 2.143512 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.3e-18   NR CEP02402.1 37360 g35889 i0 65.5 0.966666666666667 58 20 96.7 0 178 5 325 382 CEP02402.1 hypothetical protein PBRA_008986 [Plasmodiophora brassicae] diamond 174 87.4 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);;