RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA551951" 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

  • PRJNA551951 · 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
22197401 22197401 PRJNA551951_S_NODE_13978_length_180_cov_1.931034_g13860_i0 PRJNA551951 13978 180 1.931034 3.4758612 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 81.6 1.73e-16   NR HEY8279669.1 3034175 g13860 i0 75.9 0.966666666666667 58 14 96.7 0 3 176 222 279 HEY8279669.1 ABC transporter permease [Bdellovibrionota bacterium] diamond 174 81.6 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
26951508 26951508 PRJNA551951_S_NODE_14922_length_171_cov_1.463235_g14804_i0 PRJNA551951 14922 171 1.463235 2.50213185 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 66.2 7.07e-11   NR HEY8280583.1 3034175 g14804 i0 88.6 0.614035087719298 35 4 61.4 0 2 106 540 574 HEY8280583.1 hypothetical protein [Bdellovibrionota bacterium] diamond 105 66.2 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
27994294 27994294 PRJNA551951_S_NODE_10805_length_222_cov_1.235294_g10687_i0 PRJNA551951 10805 222 1.235294 2.74235268 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 44.3 0.00308   NR HEY8279261.1 3034175 g10687 i0 56.3 0.648648648648649 48 13 54.1 1 1 120 84 131 HEY8279261.1 S8 family serine peptidase [Bdellovibrionota bacterium] diamond 144 44.3 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
28909566 28909566 PRJNA551951_S_NODE_15728_length_164_cov_1.550388_g15610_i0 PRJNA551951 15728 164 1.550388 2.54263632 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 57.4 8.36e-8   NR HEY8280101.1 3034175 g15610 i0 62.2 0.676829268292683 37 14 67.7 0 116 6 1 37 HEY8280101.1 hypothetical protein [Bdellovibrionota bacterium] diamond 111 57.4 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
30394622 30394622 PRJNA551951_S_NODE_16593_length_158_cov_1.300813_g16475_i0 PRJNA551951 16593 158 1.300813 2.05528454 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 97.1 3.98e-24   NR MBX3032941.1 2026715 g16475 i0 86.3 1.93670886075949 51 7 96.8 0 154 2 58 108 MBX3032941.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] diamond 306 97.1 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);;