RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA414036", tax_clade = "Sar" and tax_phylum = "Endomyxa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA414036 · 4 ✖

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
27896690 27896690 PRJNA414036_P_NODE_15265_length_378_cov_7.941691_g13581_i0 PRJNA414036 15265 378 7.941691 30.01959198 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 93.6 7.6e-20   NR CEP03402.1 37360 g13581 i0 47.7 0.880952380952381 111 58 88.1 0 377 45 158 268 CEP03402.1 hypothetical protein PBRA_003162 [Plasmodiophora brassicae] diamond 333 93.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28054592 28054592 PRJNA414036_P_NODE_82425_length_159_cov_2.459677_g80686_i0 PRJNA414036 82425 159 2.459677 3.91088643 Spongospora subterranea 70186 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.53e-5   NR YP_009350057.1 70186 g80686 i0 43.1 0.962264150943396 51 29 96.2 0 3 155 18 68 YP_009350057.1 hypothetical protein [Spongospora subterranea] diamond 153 48.9 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Spongospora Spongospora subterranea
28323782 28323782 PRJNA414036_P_NODE_2026_length_635_cov_2.498333_g1621_i0 PRJNA414036 2026 635 2.498333 15.86441455 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.36e-7   NR CEO94341.1 37360 g1621 i0 54.7 1.79055118110236 64 29 30.2 0 178 369 26 89 CEO94341.1 hypothetical protein PBRA_000126 [Plasmodiophora brassicae] diamond 1137 62.8 0.993630573248408 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32699120 32699120 PRJNA414036_P_NODE_60460_length_214_cov_41.418994_g58721_i0 PRJNA414036 60460 214 41.418994 88.63664716 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 62 4.16e-9   NR CEO96728.1 37360 g58721 i0 48.6 0.981308411214953 70 36 98.1 0 4 213 145 214 CEO96728.1 hypothetical protein PBRA_005332 [Plasmodiophora brassicae] diamond 210 62 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);;