RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA685607", 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

  • PRJNA685607 · 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
4494218 4494218 PRJNA685607_P_NODE_36544_length_310_cov_0.822785_g36185_i0 PRJNA685607 36544 310 0.822785 2.5506335 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 176 1.15e-48   NR CEO94640.1 37360 g36185 i0 83.5 1.99354838709677 103 17 99.7 0 309 1 301 403 CEO94640.1 hypothetical protein PBRA_000425 [Plasmodiophora brassicae] diamond 618 176 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4494269 4494269 PRJNA685607_P_NODE_52564_length_273_cov_1.380000_g52205_i0 PRJNA685607 52564 273 1.38 3.7674 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 79 9.72e-15   NR CEP01791.1 37360 g52205 i0 53.8 5.56043956043956 65 29 70.3 1 200 9 293 357 CEP01791.1 hypothetical protein PBRA_008733 [Plasmodiophora brassicae] diamond 1518 79 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27840116 27840116 PRJNA685607_P_NODE_7724_length_554_cov_1.968815_g7370_i0 PRJNA685607 7724 554 1.968815 10.9072351 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 108 2.9300000000000003e-26   NR SPQ93437.1 37360 g7370 i0 55.8 3.46570397111913 104 46 56.3 0 32 343 33 136 SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] diamond 1920 108 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28693007 28693007 PRJNA685607_P_NODE_43947_length_290_cov_1.870968_g43588_i0 PRJNA685607 43947 290 1.870968 5.4258072 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 102 1.9499999999999994e-23   NR CEP03715.1 37360 g43588 i0 50 0.972413793103448 94 46 96.2 1 3 281 113 206 CEP03715.1 hypothetical protein PBRA_003322 [Plasmodiophora brassicae] diamond 282 102 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28818807 28818807 PRJNA685607_P_NODE_80268_length_246_cov_0.890173_g79909_i0 PRJNA685607 80268 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 123 6.879999999999998e-32   NR CEP00753.1 37360 g79909 i0 69.5 1 82 25 100 0 1 246 31 112 CEP00753.1 hypothetical protein PBRA_001807 [Plasmodiophora brassicae] diamond 246 123 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29734454 29734454 PRJNA685607_P_NODE_16530_length_403_cov_1.666667_g16172_i0 PRJNA685607 16530 403 1.666667 6.71666801 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 137 8.46e-37   NR CEO97280.1 37360 g16172 i0 52.3 1.87593052109181 132 63 98.3 0 403 8 113 244 CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] diamond 756 137 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30050475 30050475 PRJNA685607_P_NODE_35891_length_311_cov_1.642857_g35532_i0 PRJNA685607 35891 311 1.642857 5.10928527 Bonamia ostreae 126728 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.59e-7   NR MES1919607.1 126728 g35532 i0 44.1 1.52411575562701 59 32 56.9 1 212 36 296 353 MES1919607.1 Zinc-binding domain present in Lin-11, Isl-1, Mec-3 [Bonamia ostreae] diamond 474 58.9 1 Eukaryota Sar   Endomyxa Ascetosporea Haplosporida   Bonamia Bonamia ostreae
30662509 30662509 PRJNA685607_P_NODE_77093_length_247_cov_0.885057_g76734_i0 PRJNA685607 77093 247 0.885057 2.18609079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 75.5 1.12e-13   NR CEP00069.1 37360 g76734 i0 52.6 4.71255060728745 76 34 92.3 2 242 15 501 574 CEP00069.1 hypothetical protein PBRA_007803 [Plasmodiophora brassicae] diamond 1164 75.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31579304 31579304 PRJNA685607_P_NODE_64156_length_252_cov_1.340782_g63797_i0 PRJNA685607 64156 252 1.340782 3.37877064 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 121 6.63e-30   NR SPQ96154.1 37360 g63797 i0 65.4 2.91666666666667 81 28 96.4 0 3 245 197 277 SPQ96154.1 unnamed protein product [Plasmodiophora brassicae] diamond 735 121 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31725663 31725663 PRJNA685607_P_NODE_71697_length_249_cov_0.875000_g71338_i0 PRJNA685607 71697 249 0.875 2.17875 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 101 9.46e-23   NR CEP03536.1 37360 g71338 i0 59.5 0.951807228915663 79 32 95.2 0 2 238 243 321 CEP03536.1 hypothetical protein PBRA_009421 [Plasmodiophora brassicae] diamond 237 101 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31883812 31883812 PRJNA685607_P_NODE_67397_length_250_cov_1.418079_g67038_i0 PRJNA685607 67397 250 1.418079 3.5451975 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 87.8 4.96e-19   NR CEO99219.1 37360 g67038 i0 54.2 0.996 83 36 99.6 1 249 1 95 175 CEO99219.1 hypothetical protein PBRA_001126 [Plasmodiophora brassicae] diamond 249 87.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32831833 32831833 PRJNA685607_P_NODE_17160_length_398_cov_0.947692_g16802_i0 PRJNA685607 17160 398 0.947692 3.77181416 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 107 4.25e-24   NR CEP03536.1 37360 g16802 i0 55.4 0.761306532663317 101 45 76.1 0 303 1 155 255 CEP03536.1 hypothetical protein PBRA_009421 [Plasmodiophora brassicae] diamond 303 107 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32874823 32874823 PRJNA685607_P_NODE_63700_length_253_cov_1.272222_g63341_i0 PRJNA685607 63700 253 1.272222 3.21872166 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.22e-11   NR CEP03651.1 37360 g63341 i0 37.6 6.66403162055336 85 51 98.4 1 250 2 70 154 CEP03651.1 hypothetical protein PBRA_003258 [Plasmodiophora brassicae] diamond 1686 69.7 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);;