RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA798905", 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

  • PRJNA798905 · 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
26619803 26619803 PRJNA798905_S_NODE_23741_length_308_cov_12.089362_g23292_i0 PRJNA798905 23741 308 12.089362 37.23523496 Bacteria 2 Bacteria Bacteria 135 1.61e-35   NR MCM2348595.1 2081706 g23292 i0 79.7 1.53896103896104 79 16 76.9 0 270 34 368 446 MCM2348595.1 tRNA lysidine(34) synthetase TilS [Bacteriovoracaceae bacterium] diamond 474 135 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae bacterium
31665742 31665742 PRJNA798905_S_NODE_34597_length_255_cov_3.653846_g34148_i0 PRJNA798905 34597 255 3.653846 9.3173073 Halobacteriovoraceae bacterium 2026745 Bacteria Bacteria 72.4 1.56e-12   NR MAX65325.1 2026745 g34148 i0 45.7 0.952941176470588 81 39 95.3 2 244 2 749 824 MAX65325.1 hypothetical protein [Halobacteriovoraceae bacterium] diamond 243 72.4 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae   Halobacteriovoraceae bacterium
32108739 32108739 PRJNA798905_S_NODE_24338_length_305_cov_3.577586_g23889_i0 PRJNA798905 24338 305 3.577586 10.9116373 Halobacteriovoraceae bacterium 2026745 Bacteria Bacteria 109 3.26e-25   NR MAX65325.1 2026745 g23889 i0 49.5 0.99344262295082 101 51 99.3 0 303 1 851 951 MAX65325.1 hypothetical protein [Halobacteriovoraceae bacterium] diamond 303 109 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae   Halobacteriovoraceae 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);;