RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Endomyxa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA681822 · 4 ✖

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
2445138 2445138 PRJNA681822_P_NODE_107802_length_382_cov_0.996764_g106316_i0 PRJNA681822 107802 382 0.996764 3.80763848 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 141 3.78e-40   NR SPQ93437.1 37360 g106316 i0 63.2 1.66492146596859 106 39 83.2 0 380 63 39 144 SPQ93437.1 unnamed protein product [Plasmodiophora brassicae] diamond 636 141 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
23606391 23606391 PRJNA681822_P_NODE_253959_length_285_cov_2.179245_g252470_i0 PRJNA681822 253959 285 2.179245 6.21084825 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 300 8.52e-77   NTclustered gi|302026178|gb|GQ377695.1| 862247 g252470 i0 85.614 97.7157894736842 285 41 100 0 1 285 396 112 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 27849 300 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
30398431 30398431 PRJNA681822_P_NODE_252973_length_286_cov_1.103286_g251484_i0 PRJNA681822 252973 286 1.103286 3.15539796 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.6e-6   NR CEP02182.1 37360 g251484 i0 35.7 1.02797202797203 98 58 99.7 2 286 2 387 482 CEP02182.1 hypothetical protein PBRA_002447 [Plasmodiophora brassicae] diamond 294 55.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
31484480 31484480 PRJNA681822_P_NODE_326216_length_267_cov_1.567010_g324727_i0 PRJNA681822 326216 267 1.56701 4.1839167 root 1 Root_unresolved Root_unresolved 137 3.89e-36   NR CEO99947.1 37360 g324727 i0 76.4 9 89 21 100 0 1 267 19 107 CEO99947.1 hypothetical protein PBRA_007681 [Plasmodiophora brassicae] diamond 2403 138 0.992753623188406 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);;