RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA798905" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA798905 · 3 ✖

analysis 1

  • diamond · 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
26864421 26864421 PRJNA798905_S_NODE_24501_length_304_cov_5.199134_g24052_i0 PRJNA798905 24501 304 5.199134 15.80536736 Aliarcobacter butzleri 28197 Bacteria Bacteria 201 2.46e-64   NR WP_152632827.1 28197 g24052 i0 100 1.99342105263158 101 0 99.7 0 304 2 17 117 WP_152632827.1 hypothetical protein [Aliarcobacter butzleri] diamond 606 201 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
29264300 29264300 PRJNA798905_S_NODE_19749_length_334_cov_3.409962_g19300_i0 PRJNA798905 19749 334 3.409962 11.38927308 Aliarcobacter butzleri 28197 Bacteria Bacteria 142 2.5999999999999996e-38   NR WP_301346224.1 28197 g19300 i0 94.5 0.817365269461078 91 5 81.7 0 274 2 106 196 WP_301346224.1 hypothetical protein [Aliarcobacter butzleri] diamond 273 142 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
31033751 31033751 PRJNA798905_S_NODE_44615_length_204_cov_4.503817_g44166_i0 PRJNA798905 44615 204 4.503817 9.18778668 Arcobacter suis 1278212 Bacteria Bacteria 86.7 7.72e-18   NR WP_192894501.1 1278212 g44166 i0 68.9 0.897058823529412 61 19 89.7 0 7 189 177 237 WP_192894501.1 sensor histidine kinase [Arcobacter suis] diamond 183 86.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis

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