RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA870096", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA870096 · 3 ✖

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
22526850 22526850 PRJNA870096_S_NODE_41518_length_275_cov_2.275862_g39854_i0 PRJNA870096 41518 275 2.275862 6.2586205 Bdellovibrionales bacterium CG22_combo_CG1 2053517 Bacteria Bacteria 144 3.26e-39   NR PIP90862.1 1973930 g39854 i0 75.8 0.992727272727273 91 22 99.3 0 275 3 289 379 PIP90862.1 MAG: acetyl-CoA C-acyltransferase [Bdellovibrionales bacterium CG22_combo_CG10-13_8_21_14_all_38_13] diamond 273 144 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium CG22_combo_CG10-13_8_21_14_all_38_13
28191966 28191966 PRJNA870096_S_NODE_51406_length_245_cov_3.797030_g49742_i0 PRJNA870096 51406 245 3.79703 9.3027235 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 53.9 5.65e-7   NR MES2769732.1 3034175 g49742 i0 47.8 0.563265306122449 46 24 56.3 0 100 237 49 94 MES2769732.1 hypothetical protein [Bdellovibrionota bacterium] diamond 138 53.9 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
29052915 29052915 PRJNA870096_S_NODE_84548_length_191_cov_1.472973_g82884_i0 PRJNA870096 84548 191 1.472973 2.81337843 root 1 Root_unresolved Root_unresolved 59.7 1.93e-8   NR WP_015468752.1 453816 g82884 i0 47.4 2.76439790575916 57 28 86.4 1 184 20 338 394 WP_015468752.1 thrombospondin type-1 domain-containing protein [Pseudobdellovibrio exovorus] diamond 528 59.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Pseudobdellovibrio Pseudobdellovibrio exovorus

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