RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1146029 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
290136 290136 PRJNA1146029_P_NODE_21161_length_243_cov_0.905882_g20880_i0 PRJNA1146029 21161 243 0.905882 2.20129326 Paludibaculum fermentans 1473598 Bacteria Bacteria 178 3.4599999999999993e-40   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g20880 i0 84.444 32.2181069958848 180 28 74 0 43 222 9058586 9058765 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 7829 178 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
4117067 4117067 PRJNA1146029_P_NODE_16444_length_250_cov_1.711864_g16163_i0 PRJNA1146029 16444 250 1.711864 4.27966 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 89.8 1.73e-13   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g16163 i0 92.063 0.252 63 5 25 0 188 250 4334184 4334122 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 63 89.8 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
11236872 11236872 PRJNA1146029_P_NODE_11309_length_282_cov_1.851675_g11028_i0 PRJNA1146029 11309 282 1.851675 5.2217235 Pseudomonadati 3379134 Bacteria Bacteria 217 8.72e-52   NTclustered gi|2874253854|emb|OY969910.1| 171953 g11028 i0 81.588 264.716312056738 277 38 96 10 12 282 2637368 2637637 MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1 blastn 74650 217 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
13043933 13043933 PRJNA1146029_P_NODE_8171_length_316_cov_1.901235_g7891_i0 PRJNA1146029 8171 316 1.901235 6.0079026 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 124 6.179999999999999e-24   NTclustered gi|2874253885|emb|OY970060.1| 171953 g7891 i0 86.325 63.7056962025316 117 13 36 3 201 315 4839460 4839575 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 blastn 20131 124 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14319148 14319148 PRJNA1146029_P_NODE_6552_length_346_cov_1.128205_g6274_i0 PRJNA1146029 6552 346 1.128205 3.9035893 Acidisarcina polymorpha 2211140 Bacteria Bacteria 231 3.9199999999999994e-56   NTclustered gi|1431854037|gb|CP030840.1| 2211140 g6274 i0 81.333 18.7514450867052 300 43 85 10 52 346 3764021 3763730 Acidisarcina polymorpha strain SBC82 chromosome, complete genome blastn 6488 231 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Acidisarcina Acidisarcina polymorpha
18885174 18885174 PRJNA1146029_P_NODE_11915_length_279_cov_0.854369_g11634_i0 PRJNA1146029 11915 279 0.854369 2.38368951 Pseudomonadati 3379134 Bacteria Bacteria 69.4 2.55e-7   NTclustered gi|2874254139|emb|OY970224.1| 171953 g11634 i0 81.395 55.5627240143369 86 14 30 2 195 279 1714675 1714759 MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1 blastn 15502 69.4 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
24515990 24515990 PRJNA1146029_P_NODE_17560_length_249_cov_0.875000_g17279_i0 PRJNA1146029 17560 249 0.875 2.17875 Geothrix sp. 21YS21S-4 3068889 Bacteria Bacteria 267 7.39e-67   NTclustered gi|2565867660|gb|CP132719.1| 3068889 g17279 i0 86 4.01204819277108 250 33 100 2 1 249 2991709 2991461 Geothrix sp. 21YS21S-4 chromosome, complete genome blastn 999 267 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp. 21YS21S-4

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