RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1066877" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1066877 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
5283205 5283205 PRJNA1066877_S_NODE_4145_length_245_cov_1.301020_g4110_i0 PRJNA1066877 4145 245 1.30102 3.187499 Rufibacter ruber 1783499 Bacteria Bacteria 82.8 2.94e-16   NR WP_066833853.1 1783499 g4110 i0 50.6 4.37142857142857 89 29 90.6 1 3 224 114 202 WP_066833853.1 mercury(II) reductase [Rufibacter ruber] diamond 1071 82.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Rufibacter Rufibacter ruber
28417031 28417031 PRJNA1066877_S_NODE_12666_length_162_cov_0.902655_g12631_i0 PRJNA1066877 12666 162 0.902655 1.4623011 Porphyromonas 836 Bacteria Bacteria 111 1.19e-27   NR MFC2631995.1 1583331 g12631 i0 100 3 54 0 100 0 1 162 95 148 MFC2631995.1 SusF/SusE family outer membrane protein [Porphyromonas pasteri] diamond 486 111 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas pasteri
29972349 29972349 PRJNA1066877_S_NODE_12251_length_163_cov_2.026316_g12216_i0 PRJNA1066877 12251 163 2.026316 3.30289508 Bacteroides uniformis 820 Bacteria Bacteria 51.6 5.14e-7   NR WP_208081217.1 820 g12216 i0 100 0.496932515337423 27 0 49.7 0 2 82 26 52 WP_208081217.1 hypothetical protein, partial [Bacteroides uniformis] diamond 81 51.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides uniformis
30604173 30604173 PRJNA1066877_S_NODE_9033_length_184_cov_1.044444_g8998_i0 PRJNA1066877 9033 184 1.044444 1.92177696 Bergeyella zoohelcum 1015 Bacteria Bacteria 125 1.95e-34   NR WP_260199964.1 1015 g8998 i0 100 0.978260869565217 60 0 97.8 0 182 3 77 136 WP_260199964.1 hypothetical protein [Bergeyella zoohelcum] diamond 180 125 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Bergeyella Bergeyella zoohelcum

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