RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB81463", 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

  • PRJEB81463 · 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
1415323 1415323 PRJEB81463_P_NODE_8822_length_338_cov_3.962264_g8550_i0 PRJEB81463 8822 338 3.962264 13.39245232 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 191 4.3300000000000005e-58   NR CEP01219.1 37360 g8550 i0 80.9 9.79881656804734 110 20 97.6 1 3 332 163 271 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 3312 191 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
2690386 2690386 PRJEB81463_P_NODE_11763_length_296_cov_3.394619_g11491_i0 PRJEB81463 11763 296 3.394619 10.04807224 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 164 1.32e-49   NR CEP00218.1 37360 g11491 i0 73.5 17.8682432432432 98 26 99.3 0 296 3 40 137 CEP00218.1 hypothetical protein PBRA_007952 [Plasmodiophora brassicae] diamond 5289 164 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
9067950 9067950 PRJEB81463_P_NODE_3188_length_564_cov_4.319756_g2920_i0 PRJEB81463 3188 564 4.319756 24.36342384 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 252 6.86e-82   NR CEO98386.1 37360 g2920 i0 78.9 8.8563829787234 166 35 88.3 0 558 61 1 166 CEO98386.1 hypothetical protein PBRA_006500 [Plasmodiophora brassicae] diamond 4995 252 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
11618827 11618827 PRJEB81463_P_NODE_1290_length_878_cov_2.730435_g1072_i0 PRJEB81463 1290 878 2.730435 23.9732193 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 286 3.75e-92   NR CEP02379.1 37360 g1072 i0 58.7 0.919134396355353 269 100 91.2 3 876 76 51 310 CEP02379.1 hypothetical protein PBRA_008963 [Plasmodiophora brassicae] diamond 807 286 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
12894026 12894026 PRJEB81463_P_NODE_2351_length_659_cov_2.030717_g2088_i0 PRJEB81463 2351 659 2.030717 13.38242503 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 244 3.05e-77   NR CEO97280.1 37360 g2088 i0 56.6 0.996965098634294 219 95 99.7 0 1 657 47 265 CEO97280.1 hypothetical protein PBRA_000625 [Plasmodiophora brassicae] diamond 657 244 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
20541552 20541552 PRJEB81463_P_NODE_2957_length_586_cov_3.920078_g2689_i0 PRJEB81463 2957 586 3.920078 22.97165708 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 173 1.27e-50   NR CEP00157.1 37360 g2689 i0 66 0.783276450511945 153 51 78.3 1 586 128 82 233 CEP00157.1 hypothetical protein PBRA_007891 [Plasmodiophora brassicae] diamond 459 173 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
24366477 24366477 PRJEB81463_P_NODE_6080_length_406_cov_2.510511_g5808_i0 PRJEB81463 6080 406 2.510511 10.19267466 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 161 6.74e-48   NR SPQ93437.1 37360 g5808 i0 66.7 2.51231527093596 117 39 86.5 0 22 372 32 148 SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] diamond 1020 161 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26590808 26590808 PRJEB81463_P_NODE_13981_length_282_cov_1.933014_g13709_i0 PRJEB81463 13981 282 1.933014 5.45109948 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72 2.9e-12   NR SPQ97717.1 37360 g13709 i0 42.5 0.851063829787234 80 44 83 2 235 2 140 219 SPQ97717.1 unnamed protein product [Plasmodiophora brassicae] diamond 240 72 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27318913 27318913 PRJEB81463_P_NODE_28703_length_239_cov_2.759036_g28431_i0 PRJEB81463 28703 239 2.759036 6.59409604 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 90.5 5.26e-19   NR CEO98853.1 37360 g28431 i0 55 1.00418410041841 80 35 99.2 1 238 2 224 303 CEO98853.1 hypothetical protein PBRA_006967 [Plasmodiophora brassicae] diamond 240 90.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
27508426 27508426 PRJEB81463_P_NODE_10863_length_308_cov_3.246809_g10591_i0 PRJEB81463 10863 308 3.246809 10.00017172 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 115 7.719999999999999e-31   NR CEP02593.1 37360 g10591 i0 64.8 0.886363636363636 91 32 88.6 0 274 2 11 101 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 273 115 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28424045 28424045 PRJEB81463_P_NODE_10926_length_307_cov_3.547009_g10654_i0 PRJEB81463 10926 307 3.547009 10.88931763 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 147 1.1499999999999999e-42   NR CEO99768.1 37360 g10654 i0 68.3 0.986970684039088 101 32 98.7 0 307 5 1 101 CEO99768.1 hypothetical protein PBRA_007502 [Plasmodiophora brassicae] diamond 303 147 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30602879 30602879 PRJEB81463_P_NODE_29793_length_227_cov_3.012987_g29521_i0 PRJEB81463 29793 227 3.012987 6.83948049 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 66.2 1.2e-10   NR CEP01219.1 37360 g29521 i0 55.6 1.36123348017621 54 20 66.1 1 213 64 264 317 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 309 66.2 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30848494 30848494 PRJEB81463_P_NODE_11514_length_299_cov_2.734513_g11242_i0 PRJEB81463 11514 299 2.734513 8.17619387 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.00103   NR CEO97126.1 37360 g11242 i0 47.5 0.862876254180602 40 21 40.1 0 291 172 207 246 CEO97126.1 hypothetical protein PBRA_005730 [Plasmodiophora brassicae] diamond 258 47.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31860057 31860057 PRJEB81463_P_NODE_8037_length_354_cov_2.672598_g7765_i0 PRJEB81463 8037 354 2.672598 9.46099692 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 126 4.6e-31   NR SPR01560.1 37360 g7765 i0 59.1 2.82203389830508 110 43 93.2 2 20 349 394 501 SPR01560.1 unnamed protein product [Plasmodiophora brassicae] diamond 999 126 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32429853 32429853 PRJEB81463_P_NODE_5719_length_418_cov_2.884058_g5447_i0 PRJEB81463 5719 418 2.884058 12.05536244 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 9.55e-23   NR CEO95180.1 37360 g5447 i0 37.7 1.85167464114833 130 79 91.9 1 35 418 64 193 CEO95180.1 hypothetical protein PBRA_003946 [Plasmodiophora brassicae] diamond 774 103 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);;