RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1098727" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1098727 · 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
28046758 28046758 PRJNA1098727_P_NODE_12765_length_169_cov_0.866667_g12524_i0 PRJNA1098727 12765 169 0.866667 1.46466723 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 96.3 1.59e-21   NR MCL4817668.1 2793154 g12524 i0 85.5 0.976331360946746 55 8 97.6 0 167 3 106 160 MCL4817668.1 AMP-binding protein [Vicinamibacteria bacterium] diamond 165 96.3 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria bacterium
28299306 28299306 PRJNA1098727_P_NODE_3506_length_357_cov_2.840909_g3265_i0 PRJNA1098727 3506 357 2.840909 10.14204513 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 44.3 0.0357   NR HWW88845.1 2910147 g3265 i0 31.2 1.05042016806723 125 58 82.4 5 5 298 27 150 HWW88845.1 isoprenylcysteine carboxylmethyltransferase family protein [Vicinamibacterales bacterium] diamond 375 44.3 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
28899096 28899096 PRJNA1098727_P_NODE_15928_length_162_cov_0.876106_g15687_i0 PRJNA1098727 15928 162 0.876106 1.41929172 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 84.7 1.93e-17   NR HEY6547531.1 2793154 g15687 i0 67.9 1.96296296296296 53 17 98.1 0 3 161 363 415 HEY6547531.1 TonB-dependent siderophore receptor [Vicinamibacteria bacterium] diamond 318 84.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria 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);;