RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB75017", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ignavibacteriota · 4 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 4 ✖

bioproject 1

  • PRJEB75017 · 4 ✖

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
30192041 30192041 PRJEB75017_P_NODE_13592_length_254_cov_1.508287_g13463_i0 PRJEB75017 13592 254 1.508287 3.83104898 Ignavibacteria bacterium 2053306 Bacteria Bacteria 61.2 1.18e-8   NR MDP3444116.1 2053306 g13463 i0 50 0.850393700787402 72 35 85 1 240 25 190 260 MDP3444116.1 IPT/TIG domain-containing protein [Ignavibacteria bacterium] diamond 216 61.2 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
31677558 31677558 PRJEB75017_P_NODE_15357_length_249_cov_1.250000_g15228_i0 PRJEB75017 15357 249 1.25 3.1125 Ignavibacteria bacterium 2053306 Bacteria Bacteria 73.6 5.29e-13   NR MBD1210710.1 2053306 g15228 i0 44.3 1.90361445783133 79 44 95.2 0 245 9 267 345 MBD1210710.1 hypothetical protein [Ignavibacteria bacterium] diamond 474 73.6 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
31962292 31962292 PRJEB75017_P_NODE_14018_length_253_cov_0.866667_g13889_i0 PRJEB75017 14018 253 0.866667 2.19266751 Ignavibacteria bacterium 2053306 Bacteria Bacteria 46.6 0.00182   NR HMS34262.1 2053306 g13889 i0 47.5 0.699604743083004 59 28 66.4 1 44 211 154 212 HMS34262.1 aldo/keto reductase [Ignavibacteria bacterium] diamond 177 46.6 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
32405406 32405406 PRJEB75017_P_NODE_6379_length_351_cov_1.122302_g6250_i0 PRJEB75017 6379 351 1.122302 3.93928002 Ignavibacterium album 591197 Bacteria Bacteria 133 2.53e-33   NR WP_014562022.1 591197 g6250 i0 59.8 2.87179487179487 112 45 95.7 0 337 2 418 529 WP_014562022.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Ignavibacterium album] diamond 1008 133 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria Ignavibacteriales Ignavibacteriaceae Ignavibacterium Ignavibacterium album

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