RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA832865", tax_kingdom = "Pseudomonadati" 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

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA832865 · 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
19949453 19949453 PRJNA832865_S_NODE_33616_length_483_cov_3.743902_g28536_i0 PRJNA832865 33616 483 3.743902 18.08304666 Pigmentibacter ruber 2683196 Bacteria Bacteria 52.8 0.047   NTclustered gi|2651759839|dbj|AP029159.1| 2683196 g28536 i0 100 0.0579710144927536 28 0 6 0 94 121 951117 951144 Pigmentibacter ruber GTC16762 DNA, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Silvanigrellales Silvanigrellaceae Pigmentibacter Pigmentibacter ruber
29865030 29865030 PRJNA832865_S_NODE_82511_length_270_cov_1.172589_g77425_i0 PRJNA832865 82511 270 1.172589 3.1659903 Halobacteriovorax sp. HLS 2234000 Bacteria Bacteria 46.2 0.003   NR WP_127716669.1 2234000 g77425 i0 32.5 0.855555555555556 77 52 85.6 0 239 9 83 159 WP_127716669.1 hybrid sensor histidine kinase/response regulator [Halobacteriovorax sp. HLS] diamond 231 46.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae Halobacteriovorax Halobacteriovorax sp. HLS
31191676 31191676 PRJNA832865_S_NODE_104455_length_245_cov_0.895349_g99369_i0 PRJNA832865 104455 245 0.895349 2.19360505 Bacteriovoracaceae bacterium 2081706 Bacteria Bacteria 42.7 0.0371   NR MCF8057779.1 2081706 g99369 i0 34.6 0.636734693877551 52 34 63.7 0 176 21 271 322 MCF8057779.1 hypothetical protein [Bacteriovoracaceae bacterium] diamond 156 42.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae   Bacteriovoracaceae 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);;