RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA859990" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA859990 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27149495 27149495 PRJNA859990_S_NODE_18242_length_250_cov_0.870056_g17981_i0 PRJNA859990 18242 250 0.870056 2.17514 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 145 4.55e-39   NR MCM2350652.1 2081706 g17981 i0 79.5 0.996 83 17 99.6 0 2 250 457 539 MCM2350652.1 hypothetical protein [Bacteriovoracaceae bacterium] diamond 249 145 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
27907656 27907656 PRJNA859990_S_NODE_19525_length_247_cov_0.879310_g19264_i0 PRJNA859990 19525 247 0.87931 2.1718957 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 62 6.18e-9   NR MBY0515591.1 2081706 g19264 i0 37.3 1.0080971659919 83 50 98.4 2 3 245 546 628 MBY0515591.1 hypothetical protein [Bacteriovoracaceae bacterium] diamond 249 62 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
28034387 28034387 PRJNA859990_S_NODE_20525_length_244_cov_1.543860_g20264_i0 PRJNA859990 20525 244 1.54386 3.7670184 Bdellovibrio sp. KM 28201 Bacteria Bacteria 74.7 2.11e-13   NR WP_181604689.1 2748865 g20264 i0 97.1 0.418032786885246 34 1 41.8 0 244 143 950 983 WP_181604689.1 L-glutamate gamma-semialdehyde dehydrogenase [Bdellovibrio sp. KM01] diamond 102 74.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. KM01
30244819 30244819 PRJNA859990_S_NODE_21692_length_242_cov_0.911243_g21431_i0 PRJNA859990 21692 242 0.911243 2.20520806 Pseudobdellovibrio sp. 2862747 Bacteria Bacteria 62.8 3.15e-9   NR MFN3453399.1 2862747 g21431 i0 42.3 0.966942148760331 78 45 96.7 0 242 9 444 521 MFN3453399.1 aromatic amino acid hydroxylase [Pseudobdellovibrio sp.] diamond 234 62.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Pseudobdellovibrio Pseudobdellovibrio sp.
30434590 30434590 PRJNA859990_S_NODE_18213_length_250_cov_0.915254_g17952_i0 PRJNA859990 18213 250 0.915254 2.288135 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 87 3e-18   NR HVK60334.1 2053517 g17952 i0 64.2 0.804 67 24 80.4 0 1 201 56 122 HVK60334.1 hypothetical protein [Bdellovibrionales bacterium] diamond 201 87 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
31445566 31445566 PRJNA859990_S_NODE_18276_length_250_cov_0.870056_g18015_i0 PRJNA859990 18276 250 0.870056 2.17514 Silvanigrellaceae bacterium 2654442 Bacteria Bacteria 64.7 7.05e-10   NR MBX9837929.1 2654442 g18015 i0 50.8 0.732 61 29 73.2 1 248 66 96 155 MBX9837929.1 hypothetical protein [Silvanigrellaceae bacterium] diamond 183 64.7 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Silvanigrellales Silvanigrellaceae   Silvanigrellaceae 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);;