RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1120203" 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

bioproject 1

  • PRJNA1120203 · 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
28364785 28364785 PRJNA1120203_P_NODE_99306_length_243_cov_0.905882_g98290_i0 PRJNA1120203 99306 243 0.905882 2.20129326 Ignavibacteria bacterium 2053306 Bacteria Bacteria 142 2.29e-39   NR MBE2225891.1 2053306 g98290 i0 88.6 2.92592592592593 79 9 97.5 0 238 2 16 94 MBE2225891.1 ketoacyl-ACP synthase III [Ignavibacteria bacterium] diamond 711 142 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
28617712 28617712 PRJNA1120203_P_NODE_85407_length_249_cov_0.875000_g84391_i0 PRJNA1120203 85407 249 0.875 2.17875 Ignavibacteria bacterium 2053306 Bacteria Bacteria 117 1.19e-28   NR HEY3249890.1 2053306 g84391 i0 90.2 2.87951807228916 61 6 73.5 0 184 2 1 61 HEY3249890.1 glutamate--tRNA ligase [Ignavibacteria bacterium] diamond 717 117 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
29406849 29406849 PRJNA1120203_P_NODE_94629_length_245_cov_0.895349_g93613_i0 PRJNA1120203 94629 245 0.895349 2.19360505 Ignavibacteria bacterium 2053306 Bacteria Bacteria 120 1.62e-29   NR MDH3253164.1 2053306 g93613 i0 65.4 0.991836734693878 81 28 99.2 0 3 245 483 563 MDH3253164.1 PEP/pyruvate-binding domain-containing protein [Ignavibacteria bacterium] diamond 243 120 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria bacterium
32315057 32315057 PRJNA1120203_P_NODE_95239_length_245_cov_0.895349_g94223_i0 PRJNA1120203 95239 245 0.895349 2.19360505 Ignavibacteria bacterium 2053306 Bacteria Bacteria 53.9 4.11e-6   NR MFI5211492.1 2053306 g94223 i0 53.3 0.551020408163265 45 21 55.1 0 135 1 1 45 MFI5211492.1 efflux RND transporter periplasmic adaptor subunit [Ignavibacteria bacterium] diamond 135 53.9 1 Bacteria FCB group Pseudomonadati Ignavibacteriota Ignavibacteria       Ignavibacteria 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);;