RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB83101", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJEB83101 · 4 ✖

analysis 1

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
28771217 28771217 PRJEB83101_P_NODE_57387_length_264_cov_1.424084_g57082_i0 PRJEB83101 57387 264 1.424084 3.75958176 Armatimonadota bacterium 2033014 Bacteria Bacteria 122 1.13e-30   NR MBI4279117.1 2033014 g57082 i0 62.5 1 88 33 100 0 1 264 79 166 MBI4279117.1 hypothetical protein [Armatimonadota bacterium] diamond 264 122 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
29686608 29686608 PRJEB83101_P_NODE_57190_length_264_cov_1.722513_g56885_i0 PRJEB83101 57190 264 1.722513 4.54743432 Armatimonadia bacterium 2663015 Bacteria Bacteria 103 2.66e-25   NR MEN6303306.1 2663015 g56885 i0 60.9 0.988636363636364 87 33 98.9 1 262 2 128 213 MEN6303306.1 hypothetical protein [Armatimonadia bacterium] diamond 261 103 1 Bacteria   Bacillati Armatimonadota Armatimonadia       Armatimonadia bacterium
31266665 31266665 PRJEB83101_P_NODE_52155_length_272_cov_2.030151_g51850_i0 PRJEB83101 52155 272 2.030151 5.52201072 Armatimonadaceae bacterium 2933160 Bacteria Bacteria 177 2.27e-50   NR HVK05721.1 2933160 g51850 i0 95.6 0.992647058823529 90 4 99.3 0 271 2 422 511 HVK05721.1 PQQ-binding-like beta-propeller repeat protein [Armatimonadaceae bacterium] diamond 270 177 1 Bacteria   Bacillati Armatimonadota Armatimonadia Armatimonadales Armatimonadaceae   Armatimonadaceae bacterium
31994165 31994165 PRJEB83101_P_NODE_75018_length_248_cov_0.891429_g74713_i0 PRJEB83101 75018 248 0.891429 2.21074392 Capsulimonadales bacterium 2971800 Bacteria Bacteria 65.9 2.82e-10   NR MDX1932272.1 2971800 g74713 i0 70.5 0.532258064516129 44 13 53.2 0 246 115 591 634 MDX1932272.1 ABC transporter ATP-binding protein [Capsulimonadales bacterium] diamond 132 65.9 1 Bacteria   Bacillati Armatimonadota Armatimonadia Capsulimonadales     Capsulimonadales 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);;