RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA685607", 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 · 8 ✖

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA685607 · 8 ✖

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
5770091 5770091 PRJNA685607_P_NODE_88985_length_243_cov_0.905882_g88626_i0 PRJNA685607 88985 243 0.905882 2.20129326 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 377 3.18e-100   NTclustered gi|2874253750|emb|OY969625.1| 194844 g88626 i0 94.65 120.530864197531 243 13 100 0 1 243 2375 2617 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1 blastn 29289 377 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
26765746 26765746 PRJNA685607_P_NODE_22661_length_361_cov_0.944444_g22302_i0 PRJNA685607 22661 361 0.944444 3.40944284 Blastocatellia bacterium 2052146 Bacteria Bacteria 44.7 0.0267   NR HMY74158.1 2052146 g22302 i0 29.5 1.57894736842105 95 62 77.3 3 32 310 17 108 HMY74158.1 SpoIIE family protein phosphatase [Blastocatellia bacterium] diamond 570 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
27651017 27651017 PRJNA685607_P_NODE_60924_length_258_cov_0.972973_g60565_i0 PRJNA685607 60924 258 0.972973 2.51027034 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42.7 0.0431   NR MDE3064752.1 1978231 g60565 i0 34.7 0.569767441860465 49 32 57 0 94 240 195 243 MDE3064752.1 hypothetical protein [Acidobacteriota bacterium] diamond 147 42.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28345483 28345483 PRJNA685607_P_NODE_72506_length_249_cov_0.875000_g72147_i0 PRJNA685607 72506 249 0.875 2.17875 Acidobacteriota bacterium 1978231 Bacteria Bacteria 134 8.22e-35   NR MDQ6787050.1 1978231 g72147 i0 80.5 4.95180722891566 82 16 98.8 0 248 3 442 523 MDQ6787050.1 glycosyltransferase [Acidobacteriota bacterium] diamond 1233 134 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30367003 30367003 PRJNA685607_P_NODE_14612_length_423_cov_0.854286_g14254_i0 PRJNA685607 14612 423 0.854286 3.61362978 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 43.5 0.0354   NR HSS43739.1 2651171 g14254 i0 38.9 0.51063829787234 72 39 51.1 2 49 264 30 96 HSS43739.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 216 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32148678 32148678 PRJNA685607_P_NODE_19418_length_380_cov_1.723127_g19060_i0 PRJNA685607 19418 380 1.723127 6.5478826 Bacteria 2 Bacteria Bacteria 199 3.09e-61   NR WP_031498959.1 360054 g19060 i0 76.2 3.97894736842105 126 30 99.5 0 2 379 127 252 WP_031498959.1 HpcH/HpaI aldolase family protein [Bryobacter aggregatus] diamond 1512 201 0.990049751243781 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Bryobacter Bryobacter aggregatus
32327273 32327273 PRJNA685607_P_NODE_66399_length_251_cov_0.865169_g66040_i0 PRJNA685607 66399 251 0.865169 2.17157419 Acidobacteriota bacterium 1978231 Bacteria Bacteria 43.1 0.0204   NR PYU88304.1 1978231 g66040 i0 42.3 1.24302788844622 52 27 58.6 1 246 100 42 93 PYU88304.1 MAG: prolipoprotein diacylglyceryl transferase, partial [Acidobacteriota bacterium] diamond 312 43.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32421818 32421818 PRJNA685607_P_NODE_20979_length_370_cov_2.070707_g20621_i0 PRJNA685607 20979 370 2.070707 7.6616159 Blastocatellia bacterium 2052146 Bacteria Bacteria 51.2 1.62e-4   NR HKY05324.1 2052146 g20621 i0 31.6 1.45945945945946 98 57 79.5 1 309 16 21 108 HKY05324.1 FAD-dependent oxidoreductase [Blastocatellia bacterium] diamond 540 51.2 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia 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);;