RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA358009", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA358009 · 2 ✖

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
4900950 4900950 PRJNA358009_P_NODE_4124_length_327_cov_2.258993_g4061_i0 PRJNA358009 4124 327 2.258993 7.38690711 Cercozoa 136419 SAR_Eukaryotes SAR_Eukaryotes 172 2.26e-38   NTclustered gi|1695781|gb|U42449.1|CAU42449 45111 g4061 i0 98.958 51.3853211009174 96 1 60 0 5 100 914 1009 Cercomonas ATCC50317 18S ribosomal RNA gene, complete sequence blastn 16803 172 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50317
5501747 5501747 PRJNA358009_P_NODE_10305_length_180_cov_6.549618_g10236_i0 PRJNA358009 10305 180 6.549618 11.7893124 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 307 2.9500000000000003e-79   NTclustered gi|238617602|gb|FJ973377.1| 188950 g10236 i0 98.837 22.8666666666667 172 2 96 0 6 177 1909 2080 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 4116 307 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima

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);;