RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA815356" 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

  • PRJNA815356 · 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
4647496 4647496 PRJNA815356_P_NODE_4364_length_337_cov_1.640152_g4201_i0 PRJNA815356 4364 337 1.640152 5.52731224 Flavobacterium sp. N1719 2885633 Bacteria Bacteria 158 6.3e-47   NR WP_264512623.1 2885633 g4201 i0 72.8 1.01483679525223 114 28 99.7 2 337 2 43 155 WP_264512623.1 DUF1761 domain-containing protein [Flavobacterium sp. N1719] diamond 342 158 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. N1719
27789782 27789782 PRJNA815356_P_NODE_10304_length_244_cov_0.912281_g10141_i0 PRJNA815356 10304 244 0.912281 2.22596564 Segetibacter 460073 Bacteria Bacteria 54.7 9.17e-7   NR MBC7826707.1 1869212 g10141 i0 69.4 1.47540983606557 36 11 44.3 0 136 243 6 41 MBC7826707.1 thioredoxin domain-containing protein [Chitinophagaceae bacterium] diamond 360 55.1 0.992740471869329 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
31034220 31034220 PRJNA815356_P_NODE_8775_length_253_cov_1.572222_g8612_i0 PRJNA815356 8775 253 1.572222 3.97772166 Bacteroidota bacterium 1898104 Bacteria Bacteria 112 2.67e-28   NR MCA6438114.1 1898104 g8612 i0 66.3 0.984189723320158 83 28 98.4 0 253 5 42 124 MCA6438114.1 F0F1 ATP synthase subunit A [Bacteroidota bacterium] diamond 249 112 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31982541 31982541 PRJNA815356_P_NODE_6278_length_291_cov_1.215596_g6115_i0 PRJNA815356 6278 291 1.215596 3.53738436 Cytophagales bacterium 2053541 Bacteria Bacteria 135 2.43e-35   NR MBD0258650.1 2053541 g6115 i0 69.5 0.979381443298969 95 26 97.9 1 291 7 372 463 MBD0258650.1 DUF2382 domain-containing protein [Cytophagales bacterium] diamond 285 135 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales     Cytophagales 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);;