RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB29441 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28770137 28770137 PRJEB29441_P_NODE_40707_length_166_cov_0.871795_g40266_i0 PRJEB29441 40707 166 0.871795 1.4471797 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 90.1 2.58e-19   NR HEY8279311.1 3034175 g40266 i0 80 1.98795180722892 55 11 99.4 0 2 166 217 271 HEY8279311.1 FAD-dependent oxidoreductase [Bdellovibrionota bacterium] diamond 330 90.1 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
30507240 30507240 PRJEB29441_P_NODE_44133_length_163_cov_0.894737_g43692_i0 PRJEB29441 44133 163 0.894737 1.45842131 Halobacteriovoraceae bacterium 2026745 Bacteria Bacteria 43.5 0.00488   NR MBC74374.1 2026745 g43692 i0 58.8 0.625766871165644 34 14 62.6 0 14 115 11 44 MBC74374.1 hypothetical protein [Halobacteriovoraceae bacterium] diamond 102 43.5 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae   Halobacteriovoraceae bacterium
31170471 31170471 PRJEB29441_P_NODE_44175_length_163_cov_0.894737_g43734_i0 PRJEB29441 44175 163 0.894737 1.45842131 Bdellovibrio sp. 28-41-41 1970323 Bacteria Bacteria 103 6.87e-25   NR OYZ23720.1 1970323 g43734 i0 96 0.920245398773006 50 2 92 0 152 3 252 301 OYZ23720.1 MAG: hypothetical protein B7Y39_03800 [Bdellovibrio sp. 28-41-41] diamond 150 103 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. 28-41-41
31581988 31581988 PRJEB29441_P_NODE_39076_length_167_cov_0.864407_g38635_i0 PRJEB29441 39076 167 0.864407 1.44355969 Silvanigrellales bacterium 2767476 Bacteria Bacteria 93.2 4.350000000000001e-21   NR MCA2961930.1 2767476 g38635 i0 83.6 0.988023952095808 55 9 98.8 0 3 167 28 82 MCA2961930.1 RNase adapter RapZ [Silvanigrellales bacterium] diamond 165 93.2 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Silvanigrellales     Silvanigrellales bacterium
31929737 31929737 PRJEB29441_P_NODE_38277_length_168_cov_1.344538_g37836_i0 PRJEB29441 38277 168 1.344538 2.25882384 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 90.1 1.67e-20   NR MBL7557679.1 2026715 g37836 i0 89.3 1 56 6 100 0 168 1 43 98 MBL7557679.1 tetratricopeptide repeat protein [Pseudobdellovibrionaceae bacterium] diamond 168 90.1 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae bacterium
31993066 31993066 PRJEB29441_P_NODE_44238_length_163_cov_0.894737_g43797_i0 PRJEB29441 44238 163 0.894737 1.45842131 Bdellovibrio sp. HCB337 3394358 Bacteria Bacteria 46.6 5.04e-4   NR WP_413290538.1 3394358 g43797 i0 36.4 1.01226993865031 55 32 95.7 1 8 163 18 72 WP_413290538.1 biotin--[acetyl-CoA-carboxylase] ligase [Bdellovibrio sp. HCB337] diamond 165 46.6 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. HCB337
32720103 32720103 PRJEB29441_P_NODE_34020_length_179_cov_1.569231_g33579_i0 PRJEB29441 34020 179 1.569231 2.80892349 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 52 8.52e-6   NR MCC6137470.1 2026715 g33579 i0 50 0.804469273743017 48 24 80.4 0 36 179 240 287 MCC6137470.1 PAS domain-containing protein [Pseudobdellovibrionaceae bacterium] diamond 144 52 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae 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);;