RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1197996", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA1197996 · 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
16901210 16901210 PRJNA1197996_S_NODE_22914_length_253_cov_1.650000_g22860_i0 PRJNA1197996 22914 253 1.65 4.1745 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 307 4.44e-79   NTclustered gi|2621707050|emb|OY764903.1| 2212468 g22860 i0 92.558 101.95256916996 215 14 85 2 40 253 3558042 3558255 MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 blastn 25794 307 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
23276433 23276433 PRJNA1197996_S_NODE_3479_length_465_cov_13.625000_g3425_i0 PRJNA1197996 3479 465 13.625 63.35625 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 230 1.9399999999999995e-55   NTclustered gi|2874254027|emb|OY970352.1| 171953 g3425 i0 80.38 2.62365591397849 316 50 67 11 129 440 3020146 3019839 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 1220 230 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
29314631 29314631 PRJNA1197996_S_NODE_1609_length_603_cov_26.969811_g1561_i0 PRJNA1197996 1609 603 26.969811 162.62796033 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 48.1 0.0119   NR HEX2251791.1 2651171 g1561 i0 43.1 0.253731343283582 51 24 25.4 1 490 338 671 716 HEX2251791.1 Kazal-type serine protease inhibitor family protein [Thermoanaerobaculia bacterium] diamond 153 48.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;