RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB55250" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB55250 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
28044294 28044294 PRJEB55250_P_NODE_8305_length_274_cov_1.467662_g8181_i0 PRJEB55250 8305 274 1.467662 4.02139388 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 144 3.85e-39   NR MFA5583056.1 2081706 g8181 i0 78.2 2.89051094890511 87 19 95.3 0 272 12 139 225 MFA5583056.1 DUF3458 domain-containing protein [Bacteriovoracaceae bacterium] diamond 792 144 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
31076351 31076351 PRJEB55250_P_NODE_14135_length_246_cov_0.890173_g14011_i0 PRJEB55250 14135 246 0.890173 2.18982558 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 82 2.3e-17   NR HXH76339.1 2081706 g14011 i0 87.2 0.573170731707317 47 6 57.3 0 245 105 128 174 HXH76339.1 NADH-quinone oxidoreductase subunit J [Bacteriovoracaceae bacterium] diamond 141 82 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
31202138 31202138 PRJEB55250_P_NODE_10455_length_258_cov_1.389189_g10331_i0 PRJEB55250 10455 258 1.389189 3.58410762 Bdellovibrio bacteriovorus W 765869 Bacteria Bacteria 51.2 1.04e-5   NR AHI05177.1 765869 g10331 i0 54.3 1.08139534883721 46 21 53.5 0 119 256 4 49 AHI05177.1 transposase [Bdellovibrio bacteriovorus W] diamond 279 51.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
31866674 31866674 PRJEB55250_P_NODE_8537_length_272_cov_1.547739_g8413_i0 PRJEB55250 8537 272 1.547739 4.20985008 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 92 2.52e-20   NR MEK6554738.1 3034175 g8413 i0 52.3 1.95220588235294 86 41 94.9 0 258 1 90 175 MEK6554738.1 hybrid sensor histidine kinase/response regulator [Bdellovibrionota bacterium] diamond 531 92 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
32625801 32625801 PRJEB55250_P_NODE_11800_length_251_cov_0.865169_g11676_i0 PRJEB55250 11800 251 0.865169 2.17157419 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 117 1.33e-28   NR MFA5584434.1 2081706 g11676 i0 72.3 0.99203187250996006 83 23 99.2 0 1 249 171 253 MFA5584434.1 FtsX-like permease family protein [Bacteriovoracaceae bacterium] diamond 249 117 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae 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);;