RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJDB14275", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 2 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 2 ✖

bioproject 1

  • PRJDB14275 · 2 ✖

analysis 1

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
15310721 15310721 PRJDB14275_P_NODE_7053_length_169_cov_1.261538_g6994_i0 PRJDB14275 7053 169 1.261538 2.13199922 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 110 3.28e-27   NR MFO1006063.1 2026779 g6994 i0 87.3 0.976331360946746 55 7 97.6 0 1 165 205 259 MFO1006063.1 formylglycine-generating enzyme family protein [Planctomycetaceae bacterium] diamond 165 110 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31675782 31675782 PRJDB14275_P_NODE_6677_length_176_cov_1.189781_g6618_i0 PRJDB14275 6677 176 1.189781 2.09401456 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 99.4 2.6599999999999998e-24   NR MBT6048643.1 2268189 g6618 i0 73.7 0.971590909090909 57 14 95.5 1 170 3 11 67 MBT6048643.1 DNA cytosine methyltransferase [Candidatus Scalindua sp.] diamond 171 99.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.

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