RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA529224", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJNA529224 · 4 ✖

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
3048986 3048986 PRJNA529224_S_NODE_1943_length_150_cov_11.818182_g1936_i0 PRJNA529224 1943 150 11.818182 17.727273 Paludibaculum fermentans 1473598 Bacteria Bacteria 158 2.5199999999999998e-34   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g1936 i0 86.486 10.78 148 15 97 5 2 146 4786235 4786090 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 1617 158 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
13251860 13251860 PRJNA529224_S_NODE_511_length_271_cov_86.384298_g504_i0 PRJNA529224 511 271 86.384298 234.10144758 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 292 1.3499999999999999e-74   NTclustered gi|76574293|gb|DQ139441.1| 171953 g504 i0 86.891 350.763837638376 267 27 99 4 5 271 656 914 Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence blastn 95057 292 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
24066408 24066408 PRJNA529224_S_NODE_1799_length_156_cov_6.763780_g1792_i0 PRJNA529224 1799 156 6.76378 10.5514968 Bacteria 2 Bacteria Bacteria 196 5.61e-46   NTclustered gi|76574293|gb|DQ139441.1| 171953 g1792 i0 91.034 436.217948717949 145 13 93 0 12 156 146 2 Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence blastn 68050 196 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
24724009 24724009 PRJNA529224_S_NODE_400_length_300_cov_9.833948_g393_i0 PRJNA529224 400 300 9.833948 29.501844 Bryobacterales bacterium F-183 2802972 Bacteria Bacteria 281 3.27e-71   NTclustered gi|2131941663|dbj|AP025252.1| 2802972 g393 i0 84.642 90.5066666666667 293 33 96 11 4 290 634863 634577 Bryobacterales bacterium F-183 DNA, nearly complete genome blastn 27152 281 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium F-183

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