RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA495917" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA495917 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
28151038 28151038 PRJNA495917_S_NODE_12265_length_164_cov_1.240310_g12071_i0 PRJNA495917 12265 164 1.24031 2.0341084 Terriglobales bacterium 2282142 Bacteria Bacteria 78.6 1.9e-15   NR HMB82632.1 2282142 g12071 i0 79.6 0.98780487804878 54 10 98.8 1 163 2 280 332 HMB82632.1 IS110 family transposase [Terriglobales bacterium] diamond 162 78.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
28403457 28403457 PRJNA495917_S_NODE_5926_length_210_cov_1.828571_g5732_i0 PRJNA495917 5926 210 1.828571 3.8399991 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 77.4 2.25e-16   NR MEJ7849682.1 2283092 g5732 i0 58 1.94285714285714 69 29 98.6 0 207 1 29 97 MEJ7849682.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 408 77.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29287402 29287402 PRJNA495917_S_NODE_12469_length_163_cov_1.343750_g12275_i0 PRJNA495917 12469 163 1.34375 2.1903125 Geothrix sp. 1962974 Bacteria Bacteria 43.1 0.00226   NR WP_291272256.1 1962974 g12275 i0 46.7 1.67484662576687 45 24 82.8 0 161 27 55 99 WP_291272256.1 hypothetical protein [Geothrix sp.] diamond 273 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.
29602904 29602904 PRJNA495917_S_NODE_11510_length_167_cov_1.765152_g11316_i0 PRJNA495917 11510 167 1.765152 2.94780384 Bryobacterales bacterium 2026791 Bacteria Bacteria 105 2.29e-26   NR MCU1262999.1 2026791 g11316 i0 94.5 0.988023952095808 55 3 98.8 0 1 165 164 218 MCU1262999.1 hypothetical protein [Bryobacterales bacterium] diamond 165 105 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
31404350 31404350 PRJNA495917_S_NODE_9436_length_178_cov_1.398601_g9242_i0 PRJNA495917 9436 178 1.398601 2.48950978 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 47.4 3.35e-4   NR HVQ12125.1 2910147 g9242 i0 56.8 0.623595505617977 37 16 62.4 0 112 2 2 38 HVQ12125.1 helix-turn-helix transcriptional regulator [Vicinamibacterales bacterium] diamond 111 47.4 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales 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);;