RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB6584", 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 · 5 ✖

tax_clade 1

bioproject 1

  • PRJEB6584 · 5 ✖

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
25661428 25661428 PRJEB6584o_S_NODE_8522_length_295_cov_2.715385_g8414_i0 PRJEB6584 8522 295 2.715385 8.01038575 Endomyxa 2604748 SAR_Eukaryotes SAR_Eukaryotes 119 9.55e-33   NR CEO94293.1 37360 g8414 i0 72.5 5.69491525423729 80 22 81.4 0 291 52 22 101 CEO94293.1 hypothetical protein PBRA_000078 [Plasmodiophora brassicae] diamond 1680 119 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
25931966 25931966 PRJEB6584d_S_NODE_6588_length_230_cov_2.307692_g6520_i0 PRJEB6584 6588 230 2.307692 5.3076916 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 126 1.19e-24   NTclustered gi|302026178|gb|GQ377695.1| 862247 g6520 i0 87.273 16.9782608695652 110 14 48 0 33 142 1289 1180 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 3905 126 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
26477104 26477104 PRJEB6584o_S_NODE_16080_length_221_cov_4.258065_g15972_i0 PRJEB6584 16080 221 4.258065 9.41032365 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 126 1.1399999999999999e-24   NTclustered gi|302026178|gb|GQ377695.1| 862247 g15972 i0 87.273 13.6470588235294 110 14 50 0 48 157 1289 1180 Arachnula sp. CL12 elongation factor 1 alpha mRNA, partial cds blastn 3016 126 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
32946234 32946234 PRJEB6584e_S_NODE_1770_length_211_cov_4.965909_g1755_i0 PRJEB6584 1770 211 4.965909 10.47806799 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.15e-4   NR SPQ96715.1 37360 g1755 i0 80 0.853080568720379 30 6 42.7 0 201 112 290 319 SPQ96715.1 unnamed protein product [Plasmodiophora brassicae] diamond 180 49.3 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
33100349 33100349 PRJEB6584o_S_NODE_7510_length_310_cov_10.890909_g7402_i0 PRJEB6584 7510 310 10.890909 33.7618179 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 63.2 7.49e-11   NR CEO98595.1 37360 g7402 i0 63.5 0.503225806451613 52 19 50.3 0 299 144 1 52 CEO98595.1 hypothetical protein PBRA_006708 [Plasmodiophora brassicae] diamond 156 63.2 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);;