RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA885753" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA885753 · 3 ✖

analysis 1

  • diamond · 3 ✖

tax_clade 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
28286979 28286979 PRJNA885753_S_NODE_2206_length_306_cov_1.004292_g2188_i0 PRJNA885753 2206 306 1.004292 3.07313352 Candidatus Propionivibrio dominans 2954373 Bacteria Bacteria 157 1.68e-45   NR MBK7424581.1 2954373 g2188 i0 68.3 0.990196078431373 101 32 99 0 305 3 7 107 MBK7424581.1 bifunctional DNA primase/polymerase [Candidatus Propionivibrio dominans] diamond 303 157 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Rhodocyclaceae Propionivibrio Candidatus Propionivibrio dominans
30876920 30876920 PRJNA885753_S_NODE_3634_length_253_cov_0.866667_g3616_i0 PRJNA885753 3634 253 0.866667 2.19266751 [Curtobacterium] plantarum 221276 Bacteria Bacteria 119 1.6799999999999999e-29   NR WP_122890025.1 221276 g3616 i0 70.4 0.960474308300395 81 24 96 0 245 3 109 189 WP_122890025.1 baseplate protein [[Curtobacterium] plantarum] diamond 243 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Pantoea [Curtobacterium] plantarum
31857005 31857005 PRJNA885753_S_NODE_2957_length_273_cov_1.160000_g2939_i0 PRJNA885753 2957 273 1.16 3.1668 Rosenbergiella epipactidis 1544694 Bacteria Bacteria 100 9.08e-25   NR WP_062812236.1 1544694 g2939 i0 98 0.538461538461538 49 1 53.8 0 256 110 84 132 WP_062812236.1 Z-ring associated protein ZapG [Rosenbergiella epipactidis] diamond 147 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Rosenbergiella Rosenbergiella epipactidis

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