RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA188516", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA188516 · 3 ✖

analysis 1

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
7433079 7433079 PRJNA188516_P_NODE_3526_length_181_cov_0.856061_g3476_i0 PRJNA188516 3526 181 0.856061 1.54947041 Peredibacter 263370 Bacteria Bacteria 231 1.84e-56   NTclustered gi|2631252187|gb|CP139487.1| 28202 g3476 i0 92.121 62.4198895027624 165 12 91 1 1 165 513388 513551 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 11298 231 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
14394920 14394920 PRJNA188516_P_NODE_5192_length_165_cov_0.896552_g5142_i0 PRJNA188516 5192 165 0.896552 1.4793108 Bdellovibrio bacteriovorus 959 Bacteria Bacteria 141 2.86e-29   NTclustered gi|2800920897|gb|CP168968.1| 959 g5142 i0 90 1.33333333333333 110 10 66 1 54 162 1963550 1963659 Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome blastn 220 141 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
25281279 25281279 PRJNA188516_P_NODE_5220_length_165_cov_0.896552_g5170_i0 PRJNA188516 5220 165 0.896552 1.4793108 Pseudobdellovibrio 2862745 Bacteria Bacteria 272 9.73e-69   NTclustered gi|507148233|ref|NR_103040.1| 453816 g5170 i0 96.364 29.0484848484848 165 6 100 0 1 165 1303 1467 Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence blastn 4793 272 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Pseudobdellovibrio Pseudobdellovibrio exovorus

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