RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA414036" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA414036 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
29128448 29128448 PRJNA414036_P_NODE_67709_length_189_cov_18.272727_g65970_i0 PRJNA414036 67709 189 18.272727 34.53545403 Micavibrio sp. 2024841 Bacteria Bacteria 41.2 0.0133   NR MDB5491878.1 2024841 g65970 i0 67.7 0.492063492063492 31 10 49.2 0 2 94 53 83 MDB5491878.1 uncharacterized protein [Micavibrio sp.] diamond 93 41.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Micavibrio Micavibrio sp.
29191452 29191452 PRJNA414036_P_NODE_47709_length_231_cov_2.653061_g45970_i0 PRJNA414036 47709 231 2.653061 6.12857091 Bacteriovorax antarcticus 3088717 Bacteria Bacteria 50.8 4.22e-5   NR WP_323574562.1 3088717 g45970 i0 95.5 0.285714285714286 22 1 28.6 0 9 74 213 234 WP_323574562.1 homogentisate 1,2-dioxygenase [Bacteriovorax antarcticus] diamond 66 50.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax antarcticus
30580856 30580856 PRJNA414036_P_NODE_45893_length_231_cov_3.061224_g44154_i0 PRJNA414036 45893 231 3.061224 7.07142744 Oligoflexus sp. 1971216 Bacteria Bacteria 43.1 0.0237   NR MBC7659921.1 1971216 g44154 i0 85.7 0.272727272727273 21 3 27.3 0 160 222 38 58 MBC7659921.1 trypsin-like serine protease [Oligoflexus sp.] diamond 63 43.1 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Oligoflexales Oligoflexaceae Oligoflexus Oligoflexus sp.
32305506 32305506 PRJNA414036_P_NODE_42199_length_231_cov_4.418367_g40460_i0 PRJNA414036 42199 231 4.418367 10.20642777 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00182   NR MBC7531827.1 1971216 g40460 i0 86.4 1.14285714285714 22 3 28.6 0 157 222 44 65 MBC7531827.1 hypothetical protein [Oligoflexus sp.] diamond 264 45.1 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Oligoflexales Oligoflexaceae Oligoflexus Oligoflexus sp.

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