RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA278119", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 13 ✖

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA278119 · 13 ✖

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
1058977 1058977 PRJNA278119_P_NODE_8421_length_408_cov_1.615599_g8174_i0 PRJNA278119 8421 408 1.615599 6.59164392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 127 4e-31   NR SPQ94571.1 37360 g8174 i0 48.9 4.07352941176471 139 68 100 2 1 408 120 258 SPQ94571.1 unnamed protein product [Plasmodiophora brassicae] diamond 1662 128 0.9921875 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4198381 4198381 PRJNA278119_P_NODE_27864_length_187_cov_1.884058_g27615_i0 PRJNA278119 27864 187 1.884058 3.52318846 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 114 3.49e-28   NR CEP00240.1 37360 g27615 i0 85.2 0.978609625668449 61 9 97.9 0 3 185 206 266 CEP00240.1 hypothetical protein PBRA_007974 [Plasmodiophora brassicae] diamond 183 114 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
5474916 5474916 PRJNA278119_P_NODE_5105_length_529_cov_1.722917_g4861_i0 PRJNA278119 5105 529 1.722917 9.11423093 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 242 6.89e-78   NR CEP01968.1 37360 g4861 i0 70.7 12.0680529300567 164 46 93 1 492 1 1 162 CEP01968.1 hypothetical protein PBRA_002233 [Plasmodiophora brassicae] diamond 6384 244 0.991803278688525 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
15674238 15674238 PRJNA278119_P_NODE_4913_length_541_cov_2.536585_g4669_i0 PRJNA278119 4913 541 2.536585 13.72292485 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 254 1.24e-82   NR CEO98386.1 37360 g4669 i0 81.3 0.920517560073937 166 31 92.1 0 31 528 1 166 CEO98386.1 hypothetical protein PBRA_006500 [Plasmodiophora brassicae] diamond 498 254 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
20773027 20773027 PRJNA278119_P_NODE_6577_length_465_cov_2.088942_g6331_i0 PRJNA278119 6577 465 2.088942 9.7135803 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 228 3.89e-72   NR CEO96095.1 37360 g6331 i0 67.7 1 155 50 100 0 465 1 3 157 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 465 228 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27597443 27597443 PRJNA278119_P_NODE_23784_length_203_cov_0.961039_g23535_i0 PRJNA278119 23784 203 0.961039 1.95090917 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 85.9 7.29e-18   NR CEP00641.1 37360 g23535 i0 65.2 5.42364532019704 66 23 97.5 0 5 202 24 89 CEP00641.1 hypothetical protein PBRA_001695 [Plasmodiophora brassicae] diamond 1101 85.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28260169 28260169 PRJNA278119_P_NODE_48246_length_152_cov_2.592233_g47997_i0 PRJNA278119 48246 152 2.592233 3.94019416 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 81.3 7.93e-18   NR CEO96284.1 37360 g47997 i0 66 49.3421052631579 50 17 98.7 0 1 150 34 83 CEO96284.1 hypothetical protein PBRA_004955 [Plasmodiophora brassicae] diamond 7500 81.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28576036 28576036 PRJNA278119_P_NODE_23907_length_202_cov_1.359477_g23658_i0 PRJNA278119 23907 202 1.359477 2.74614354 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.7 2.24e-14   NR CEO96912.1 37360 g23658 i0 59.7 2.95544554455446 67 25 96.5 1 198 4 131 197 CEO96912.1 hypothetical protein PBRA_005516 [Plasmodiophora brassicae] diamond 597 75.1 0.994673768308922 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29112944 29112944 PRJNA278119_P_NODE_43648_length_164_cov_0.904348_g43399_i0 PRJNA278119 43648 164 0.904348 1.48313072 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 63.9 4.07e-10   NR CEO94563.1 37360 g43399 i0 65.2 4.99390243902439 46 16 84.1 0 162 25 115 160 CEO94563.1 hypothetical protein PBRA_000348 [Plasmodiophora brassicae] diamond 819 63.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29252792 29252792 PRJNA278119_P_NODE_9989_length_370_cov_1.523364_g9742_i0 PRJNA278119 9989 370 1.523364 5.6364468 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 83.2 6.39e-18   NR CEP02593.1 37360 g9742 i0 60 0.527027027027027 65 26 52.7 0 368 174 38 102 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 195 83.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31685835 31685835 PRJNA278119_P_NODE_43557_length_164_cov_0.904348_g43308_i0 PRJNA278119 43557 164 0.904348 1.48313072 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 60.8 5.1e-9   NR CEO98100.1 37360 g43308 i0 51.9 2.01219512195122 54 26 98.8 0 162 1 112 165 CEO98100.1 hypothetical protein PBRA_006214 [Plasmodiophora brassicae] diamond 330 60.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32129054 32129054 PRJNA278119_P_NODE_11758_length_335_cov_1.454545_g11510_i0 PRJNA278119 11758 335 1.454545 4.87272575 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0306   NR MES1918165.1 126728 g11510 i0 31.1 0.949253731343284 106 72 94.9 1 332 15 466 570 MES1918165.1 hypothetical protein [Bonamia ostreae] diamond 318 44.3 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
32273352 32273352 PRJNA278119_P_NODE_37978_length_167_cov_1.161017_g37729_i0 PRJNA278119 37978 167 1.161017 1.93889839 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.51e-6   NR CEO95660.1 37360 g37729 i0 43.4 6.19760479041916 53 30 95.2 0 8 166 89 141 CEO95660.1 hypothetical protein PBRA_004386 [Plasmodiophora brassicae] diamond 1035 54.3 0.992633517495396 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);;