RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA206070", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA206070 · 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
4883641 4883641 PRJNA206070_S_NODE_25384_length_171_cov_3.223881_g23508_i0 PRJNA206070 25384 171 3.223881 5.51283651 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 305 9.96e-79   NTclustered gi|662012956|ref|NC_024084.1| 163516 g23508 i0 98.83 198.976608187135 171 2 100 0 1 171 71839 72009 Leptocylindrus danicus chloroplast, complete genome blastn 34025 305 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Leptocylindrus Leptocylindrus danicus
17633312 17633312 PRJNA206070_S_NODE_26554_length_166_cov_1.984496_g24678_i0 PRJNA206070 26554 166 1.984496 3.29426336 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 285 1.26e-72   NTclustered gi|2778381911|gb|PQ010276.1| 189737 g24678 i0 97.59 198.006024096386 166 4 100 0 1 166 12608 12443 Pseudo-nitzschia galaxiae isolate CNS01103 chloroplast, complete genome blastn 32869 285 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae

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