RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_phylum = "Ignavibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ignavibacteriota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA788929 · 2 ✖

analysis 1

  • diamond · 2 ✖
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
27884182 27884182 PRJNA788929_P_NODE_5965_length_792_cov_66.481224_g5359_i0 PRJNA788929 5965 792 66.481224 526.53129408 Ignavibacterium 795750 Bacteria Bacteria 265 2.1800000000000002e-86   NR WP_290664902.1 795750 g5359 i0 71.8 15.0984848484848 170 48 64.4 0 704 195 7 176 WP_290664902.1 MULTISPECIES: inorganic diphosphatase [Ignavibacterium] diamond 11958 265 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae Ignavibacterium  
28064376 28064376 PRJNA788929_P_NODE_29885_length_289_cov_1.212963_g29224_i0 PRJNA788929 29885 289 1.212963 3.50546307 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 112 2.59e-26   NR MCB0714194.1 2026749 g29224 i0 66.3 1.79584775086505 86 24 84.1 3 244 2 210 295 MCB0714194.1 T9SS type A sorting domain-containing protein [Ignavibacteriota bacterium] diamond 519 112 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium

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