RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA846110 · 3 ✖

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
833164 833164 PRJNA846110_P_NODE_30721_length_233_cov_2.300000_g30476_i0 PRJNA846110 30721 233 2.3 5.359 Bdellovibrio sp. HCB209 3394354 Bacteria Bacteria 340 3.9699999999999986e-89   NTclustered gi|2895998570|gb|CP178618.1| 3394354 g30476 i0 93.133 11.8884120171674 233 15 100 1 1 233 864962 865193 Bdellovibrio sp. HCB209 chromosome, complete genome blastn 2770 340 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. HCB209
27371124 27371124 PRJNA846110_P_NODE_21023_length_258_cov_1.427027_g20778_i0 PRJNA846110 21023 258 1.427027 3.68172966 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 135 7.16e-36   NR MBX3020709.1 2053517 g20778 i0 75 0.976744186046512 84 21 97.7 0 2 253 35 118 MBX3020709.1 trigger factor [Bdellovibrionales bacterium] diamond 252 135 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
30244449 30244449 PRJNA846110_P_NODE_23472_length_250_cov_0.870056_g23227_i0 PRJNA846110 23472 250 0.870056 2.17514 Micavibrio aeruginosavorus 349221 Bacteria Bacteria 134 3.34e-36   NR PZP55631.1 349221 g23227 i0 78.3 0.996 83 18 99.6 0 1 249 115 197 PZP55631.1 MAG: hypothetical protein DI586_06240 [Micavibrio aeruginosavorus] diamond 249 134 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Micavibrio Micavibrio aeruginosavorus

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