RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA546018 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
15813436 15813436 PRJNA546018_S_NODE_14973_length_429_cov_6.244565_g14648_i0 PRJNA546018 14973 429 6.244565 26.78918385 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 79.7 3.7e-15   NR HJU55860.1 2283092 g14648 i0 37.6 0.818181818181818 117 67 77.6 1 405 73 77 193 HJU55860.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 351 79.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
18362392 18362392 PRJNA546018_S_NODE_24735_length_321_cov_1.261538_g24410_i0 PRJNA546018 24735 321 1.261538 4.04953698 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 150 1.33e-40   NR HXT72181.1 2910147 g24410 i0 78.2 0.94392523364486 101 22 94.4 0 12 314 55 155 HXT72181.1 ATP-binding protein [Vicinamibacterales bacterium] diamond 303 150 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
22187511 22187511 PRJNA546018_S_NODE_1698_length_1420_cov_2.263429_g1559_i0 PRJNA546018 1698 1420 2.263429 32.1406918 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 471 1.6099999999999996e-153   NR HEX2460229.1 2910147 g1559 i0 80.3 0.665492957746479 315 61 66.3 1 1195 254 1 315 HEX2460229.1 protein kinase [Vicinamibacterales bacterium] diamond 945 471 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
27140764 27140764 PRJNA546018_S_NODE_40522_length_242_cov_2.480663_g40197_i0 PRJNA546018 40522 242 2.480663 6.00320446 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 73.2 1.62e-13   NR HVH29626.1 2910147 g40197 i0 51.4 7.22727272727273 70 34 86.8 0 213 4 31 100 HVH29626.1 response regulator [Vicinamibacterales bacterium] diamond 1749 73.2 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
27520266 27520266 PRJNA546018_S_NODE_55223_length_205_cov_1.805556_g54898_i0 PRJNA546018 55223 205 1.805556 3.7013898 Terriglobales bacterium 2282142 Bacteria Bacteria 120 2.24e-30   NR HZS98367.1 2282142 g54898 i0 87.9 1.93170731707317 66 8 96.6 0 8 205 217 282 HZS98367.1 metallophosphoesterase [Terriglobales bacterium] diamond 396 120 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
27551630 27551630 PRJNA546018_S_NODE_19364_length_369_cov_2.081169_g19039_i0 PRJNA546018 19364 369 2.081169 7.67951361 Acidobacteriota bacterium 1978231 Bacteria Bacteria 81.3 4.19e-15   NR MBS1877142.1 1978231 g19039 i0 78.7 1.91056910569106 47 10 38.2 0 357 217 383 429 MBS1877142.1 ribosome biogenesis GTPase Der [Acidobacteriota bacterium] diamond 705 81.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27835892 27835892 PRJNA546018_S_NODE_36824_length_255_cov_2.293814_g36499_i0 PRJNA546018 36824 255 2.293814 5.8492257 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 103 1.6099999999999997e-24   NR MCD9185946.1 2283092 g36499 i0 79.1 0.788235294117647 67 14 78.8 0 246 46 236 302 MCD9185946.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 201 103 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29540903 29540903 PRJNA546018_S_NODE_47430_length_221_cov_1.525000_g47105_i0 PRJNA546018 47430 221 1.525 3.37025 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 129 1.3199999999999998e-32   NR MCD9185977.1 2283092 g47105 i0 98.4 0.828054298642534 61 1 82.8 0 11 193 708 768 MCD9185977.1 BamA/TamA family outer membrane protein [Pyrinomonadaceae bacterium] diamond 183 129 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29776753 29776753 PRJNA546018_S_NODE_21271_length_349_cov_9.270833_g20946_i0 PRJNA546018 21271 349 9.270833 32.35520717 Bacteria 2 Bacteria Bacteria 108 4.03e-27   NR MCU1288629.1 1978231 g20946 i0 71 2.69054441260745 62 18 53.3 0 327 142 115 176 MCU1288629.1 spermine/spermidine N-acetyltransferase [Acidobacteriota bacterium] diamond 939 109 0.990825688073395 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31388503 31388503 PRJNA546018_S_NODE_52636_length_209_cov_1.506757_g52311_i0 PRJNA546018 52636 209 1.506757 3.14912213 Bacteria 2 Bacteria Bacteria 81.3 2.58e-18   NR MBZ5678364.1 2081523 g52311 i0 86.7 3.22966507177033 45 6 64.6 0 73 207 1 45 MBZ5678364.1 DUF378 domain-containing protein [Terriglobia bacterium] diamond 675 81.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
32480934 32480934 PRJNA546018_S_NODE_29179_length_291_cov_3.886957_g28854_i0 PRJNA546018 29179 291 3.886957 11.31104487 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 83.2 7.47e-18   NR HEY3738940.1 2212468 g28854 i0 73.5 0.505154639175258 49 13 50.5 0 128 274 1 49 HEY3738940.1 NUDIX hydrolase [Bryobacteraceae bacterium] diamond 147 83.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32701463 32701463 PRJNA546018_S_NODE_29360_length_290_cov_3.886463_g29035_i0 PRJNA546018 29360 290 3.886463 11.2707427 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 42.7 0.0449   NR MFL6197426.1 2651171 g29035 i0 32.8 0.693103448275862 67 43 67.2 1 257 63 52 118 MFL6197426.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 201 42.7 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);;