RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA559720" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA559720 · 6 ✖

analysis 1

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
4370882 4370882 PRJNA559720_P_NODE_12424_length_267_cov_1.268041_g12285_i0 PRJNA559720 12424 267 1.268041 3.38566947 Edaphobacter sp. 1934404 Bacteria Bacteria 80.1 3.03e-16   NR HEU4635130.1 1934404 g12285 i0 44.3 1.97752808988764 88 48 98.9 1 267 4 71 157 HEU4635130.1 sulfonate ABC transporter permease [Edaphobacter sp.] diamond 528 80.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp.
28387771 28387771 PRJNA559720_P_NODE_12046_length_273_cov_1.225000_g11907_i0 PRJNA559720 12046 273 1.225 3.34425 Bacteria 2 Bacteria Bacteria 173 6.79e-49   NR RMH33000.1 1978231 g11907 i0 90 9.85714285714286 90 9 98.9 0 272 3 157 246 RMH33000.1 MAG: glutamine--fructose-6-phosphate transaminase (isomerizing) [Acidobacteriota bacterium] diamond 2691 174 0.994252873563218 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28405444 28405444 PRJNA559720_P_NODE_13526_length_251_cov_0.865169_g13387_i0 PRJNA559720 13526 251 0.865169 2.17157419 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 134 1.12e-36   NR HZM98759.1 2283092 g13387 i0 83.1 4.9601593625498 83 14 99.2 0 3 251 109 191 HZM98759.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] diamond 1245 134 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30300564 30300564 PRJNA559720_P_NODE_14132_length_249_cov_0.875000_g13993_i0 PRJNA559720 14132 249 0.875 2.17875 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 100 4.92e-24   NR HXJ41436.1 2212468 g13993 i0 87 0.650602409638554 54 7 65.1 0 88 249 1 54 HXJ41436.1 CDP-alcohol phosphatidyltransferase family protein [Bryobacteraceae bacterium] diamond 162 100 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31247998 31247998 PRJNA559720_P_NODE_11975_length_274_cov_1.363184_g11836_i0 PRJNA559720 11975 274 1.363184 3.73512416 Terriglobales bacterium 2282142 Bacteria Bacteria 45.8 0.00436   NR MFL6440264.1 2282142 g11836 i0 45.2 0.45985401459854 42 23 46 0 149 274 4 45 MFL6440264.1 APC family permease [Terriglobales bacterium] diamond 126 45.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
32671018 32671018 PRJNA559720_P_NODE_4600_length_486_cov_1.142857_g4462_i0 PRJNA559720 4600 486 1.142857 5.55428502 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.8 0.023   NR PYX89186.1 1978231 g4462 i0 40 0.432098765432099 70 35 40.7 3 430 233 38 104 PYX89186.1 MAG: hypothetical protein DMG67_15610 [Acidobacteriota bacterium] diamond 210 45.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;