RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1073712" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA1073712 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
187555 187555 PRJNA1073712_P_NODE_13781_length_246_cov_1.184971_g13698_i0 PRJNA1073712 13781 246 1.184971 2.91502866 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 135 4.87e-35   NR CEO96729.1 37360 g13698 i0 82.9 9.0609756097561 76 13 92.7 0 228 1 1 76 CEO96729.1 hypothetical protein PBRA_005333 [Plasmodiophora brassicae] diamond 2229 135 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
4014050 4014050 PRJNA1073712_P_NODE_2284_length_432_cov_1.384401_g2201_i0 PRJNA1073712 2284 432 1.384401 5.98061232 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 229 1.11e-68   NR CEO96729.1 37360 g2201 i0 79.7 11.8888888888889 143 29 99.3 0 430 2 288 430 CEO96729.1 hypothetical protein PBRA_005333 [Plasmodiophora brassicae] diamond 5136 229 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
21864353 21864353 PRJNA1073712_P_NODE_11698_length_250_cov_0.870056_g11615_i0 PRJNA1073712 11698 250 0.870056 2.17514 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 65.5 4e-10   NR CEP00876.1 37360 g11615 i0 40.2 0.984 82 45 98.4 2 1 246 42 119 CEP00876.1 hypothetical protein PBRA_008188 [Plasmodiophora brassicae] diamond 246 65.5 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28141492 28141492 PRJNA1073712_P_NODE_5165_length_328_cov_2.705882_g5082_i0 PRJNA1073712 5165 328 2.705882 8.87529296 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00233   NR CEP01701.1 37360 g5082 i0 32.5 1.07012195121951 117 64 97 2 326 9 359 471 CEP01701.1 hypothetical protein PBRA_008643, partial [Plasmodiophora brassicae] diamond 351 47.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28353760 28353760 PRJNA1073712_P_NODE_16946_length_241_cov_0.916667_g16863_i0 PRJNA1073712 16946 241 0.916667 2.20916747 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.2 7.05e-13   NR SPQ99963.1 37360 g16863 i0 42.3 1.74273858921162 78 45 97.1 0 241 8 677 754 SPQ99963.1 unnamed protein product [Plasmodiophora brassicae] diamond 420 73.9 0.990527740189445 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28362182 28362182 PRJNA1073712_P_NODE_15146_length_244_cov_0.900585_g15063_i0 PRJNA1073712 15146 244 0.900585 2.1974274 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 89.4 9.14e-19   NR AVG22639.1 37360 g15063 i0 59.4 0.848360655737705 69 28 84.8 0 243 37 325 393 AVG22639.1 MAPK1 [Plasmodiophora brassicae] diamond 207 89.4 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30888904 30888904 PRJNA1073712_P_NODE_8854_length_273_cov_1.305000_g8771_i0 PRJNA1073712 8854 273 1.305 3.56265 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 88.6 1.5e-20   NR CEP02593.1 37360 g8771 i0 57 0.868131868131868 79 34 86.8 0 272 36 24 102 CEP02593.1 hypothetical protein PBRA_002561 [Plasmodiophora brassicae] diamond 237 88.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31774074 31774074 PRJNA1073712_P_NODE_4677_length_339_cov_1.962406_g4594_i0 PRJNA1073712 4677 339 1.962406 6.65255634 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 139 4.05e-38   NR CEO96095.1 37360 g4594 i0 55.8 1 113 50 100 0 1 339 107 219 CEO96095.1 hypothetical protein PBRA_004785 [Plasmodiophora brassicae] diamond 339 139 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32090569 32090569 PRJNA1073712_P_NODE_3818_length_364_cov_1.323024_g3735_i0 PRJNA1073712 3818 364 1.323024 4.81580736 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00648   NR CEO99091.1 37360 g3735 i0 30.4 0.758241758241758 92 57 74.2 2 3 272 1100 1186 CEO99091.1 hypothetical protein PBRA_007205 [Plasmodiophora brassicae] diamond 276 46.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32122376 32122376 PRJNA1073712_P_NODE_10878_length_253_cov_1.405556_g10795_i0 PRJNA1073712 10878 253 1.405556 3.55605668 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 142 4.769999999999999e-37   NR CEP02690.1 37360 g10795 i0 75 1.99209486166008 84 21 99.6 0 1 252 233 316 CEP02690.1 hypothetical protein PBRA_002657 [Plasmodiophora brassicae] diamond 504 142 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32879998 32879998 PRJNA1073712_P_NODE_13840_length_246_cov_0.890173_g13757_i0 PRJNA1073712 13840 246 0.890173 2.18982558 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 80.5 2.01e-15   NR CEO97727.1 37360 g13757 i0 58.1 2.71951219512195 74 31 90.2 0 243 22 519 592 CEO97727.1 hypothetical protein PBRA_005841 [Plasmodiophora brassicae] diamond 669 80.5 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);;