RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB12982" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12982 · 3 ✖

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
11189039 11189039 PRJEB12982_P_NODE_6629_length_284_cov_1.063830_g6466_i0 PRJEB12982 6629 284 1.06383 3.0212772 Bacteriovorax 146784 Bacteria Bacteria 220 6.79e-53   NTclustered gi|1700689994|gb|CP030035.1| 960 g6466 i0 81.206 239.394366197183 282 45 98 8 1 278 1660455 1660732 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 67988 220 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
23938035 23938035 PRJEB12982_P_NODE_15459_length_176_cov_1.039370_g15296_i0 PRJEB12982 15459 176 1.03937 1.8292912 Peredibacter 263370 Bacteria Bacteria 315 1.7199999999999996e-81   NTclustered gi|2631252187|gb|CP139487.1| 28202 g15296 i0 98.864 107.920454545455 176 2 100 0 1 176 511304 511129 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 18994 315 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
28454440 28454440 PRJEB12982_P_NODE_18606_length_165_cov_0.879310_g18443_i0 PRJEB12982 18606 165 0.87931 1.4508615 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 92 5.7e-20   NR MBX2994883.1 2026715 g18443 i0 75.9 0.981818181818182 54 13 98.2 0 4 165 523 576 MBX2994883.1 efflux RND transporter permease subunit [Pseudobdellovibrionaceae bacterium] diamond 162 92 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);;