RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA285816", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA285816 · 15 ✖

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
18223744 18223744 PRJNA285816_S_NODE_2875_length_395_cov_2.147399_g2773_i0 PRJNA285816 2875 395 2.147399 8.48222605 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 199 3.87e-57   NR CEP02690.1 37360 g2773 i0 73.3 1.98987341772152 131 35 99.5 0 393 1 228 358 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 786 199 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
24011088 24011088 PRJNA285816_S_NODE_539_length_833_cov_31.061224_g483_i0 PRJNA285816 539 833 31.061224 258.73999592 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 298 1.61e-98   NR CEP02495.1 37360 g483 i0 64.3 2.5390156062425 235 84 84.6 0 15 719 8 242 CEP02495.1 hypothetical protein PBRA_009079 [Plasmodiophora brassicae] diamond 2115 301 0.990033222591362 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26870624 26870624 PRJNA285816_S_NODE_14201_length_204_cov_0.980645_g14099_i0 PRJNA285816 14201 204 0.980645 2.0005158 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00857   NR CEP03357.1 37360 g14099 i0 64.5 4.27941176470588 31 11 45.6 0 95 3 212 242 CEP03357.1 hypothetical protein PBRA_003117 [Plasmodiophora brassicae] diamond 873 44.3 0.99097065462754 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26979178 26979178 PRJNA285816_S_NODE_2062_length_461_cov_2.497573_g1960_i0 PRJNA285816 2062 461 2.497573 11.51381153 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 181 4.1e-50   NR CEP02690.1 37360 g1960 i0 58.2 0.995661605206074 153 61 99.6 3 460 2 564 713 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 459 181 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27408095 27408095 PRJNA285816_S_NODE_19543_length_182_cov_1.172932_g19441_i0 PRJNA285816 19543 182 1.172932 2.13473624 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 77.4 9.92e-15   NR SPQ96305.1 37360 g19441 i0 61.8 16.7967032967033 55 21 90.7 0 4 168 587 641 SPQ96305.1 unnamed protein product [Plasmodiophora brassicae] diamond 3057 77.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28590212 28590212 PRJNA285816_S_NODE_27507_length_164_cov_1.356522_g27405_i0 PRJNA285816 27507 164 1.356522 2.22469608 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 64.7 2.28e-10   NR CEO95116.1 37360 g27405 i0 64.3 1.02439024390244 56 18 98.8 1 162 1 715 770 CEO95116.1 hypothetical protein PBRA_003882 [Plasmodiophora brassicae] diamond 168 64.7 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29379368 29379368 PRJNA285816_S_NODE_22409_length_173_cov_1.258065_g22307_i0 PRJNA285816 22409 173 1.258065 2.17645245 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.9e-10   NR CEO95236.1 37360 g22307 i0 58.5 0.919075144508671 53 22 91.9 0 172 14 779 831 CEO95236.1 hypothetical protein PBRA_004002 [Plasmodiophora brassicae] diamond 159 65.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
29744074 29744074 PRJNA285816_S_NODE_1730_length_501_cov_3.340708_g1628_i0 PRJNA285816 1730 501 3.340708 16.73694708 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 131 4.54e-33   NR CEP03213.1 37360 g1628 i0 56.2 9.35928143712575 105 46 62.9 0 501 187 310 414 CEP03213.1 hypothetical protein PBRA_002973 [Plasmodiophora brassicae] diamond 4689 132 0.992424242424242 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30168733 30168733 PRJNA285816_S_NODE_28412_length_163_cov_1.324561_g28310_i0 PRJNA285816 28412 163 1.324561 2.15903443 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72.4 3.53e-13   NR CEO96803.1 37360 g28310 i0 75 10.0674846625767 48 12 88.3 0 149 6 32 79 CEO96803.1 hypothetical protein PBRA_005407 [Plasmodiophora brassicae] diamond 1641 72.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30281784 30281784 PRJNA285816_S_NODE_27252_length_165_cov_0.879310_g27150_i0 PRJNA285816 27252 165 0.87931 1.4508615 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 89 6.89e-19   NR CEP02514.1 37360 g27150 i0 84.6 11.4909090909091 52 8 94.5 0 165 10 445 496 CEP02514.1 hypothetical protein PBRA_009098 [Plasmodiophora brassicae] diamond 1896 89.7 0.992196209587514 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30565385 30565385 PRJNA285816_S_NODE_27393_length_164_cov_1.808696_g27291_i0 PRJNA285816 27393 164 1.808696 2.96626144 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.7 7.78e-7   NR CEO96820.1 37360 g27291 i0 49 5.26829268292683 51 26 93.3 0 164 12 1750 1800 CEO96820.1 hypothetical protein PBRA_005424 [Plasmodiophora brassicae] diamond 864 55.1 0.992740471869329 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30850034 30850034 PRJNA285816_S_NODE_1794_length_493_cov_2.540541_g1692_i0 PRJNA285816 1794 493 2.540541 12.52486713 root 1 Root_unresolved Root_unresolved 221 1.88e-66   NR SPQ96061.1 37360 g1692 i0 66 10.8377281947262 162 55 98.6 0 3 488 44 205 SPQ96061.1 unnamed protein product [Plasmodiophora brassicae] diamond 5343 221 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31022044 31022044 PRJNA285816_S_NODE_4895_length_310_cov_2.490421_g4793_i0 PRJNA285816 4895 310 2.490421 7.7203051 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 155 5.16e-44   NR CEP03995.1 37360 g4793 i0 65 0.996774193548387 103 36 99.7 0 2 310 66 168 CEP03995.1 hypothetical protein PBRA_009575 [Plasmodiophora brassicae] diamond 309 155 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31147967 31147967 PRJNA285816_S_NODE_2195_length_448_cov_2.320802_g2093_i0 PRJNA285816 2195 448 2.320802 10.39719296 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 52 4.22e-5   NR CEO94772.1 37360 g2093 i0 45.6 0.381696428571429 57 26 38.2 1 444 274 93 144 CEO94772.1 hypothetical protein PBRA_003585 [Plasmodiophora brassicae] diamond 171 52 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32729352 32729352 PRJNA285816_S_NODE_25080_length_167_cov_3.838983_g24978_i0 PRJNA285816 25080 167 3.838983 6.41110161 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.83e-6   NR CEP02690.1 37360 g24978 i0 48.1 0.934131736526946 52 27 93.4 0 164 9 71 122 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 156 53.1 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);;