RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA976345" 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

  • PRJNA976345 · 12 ✖

analysis 1

  • blastn · 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
2223346 2223346 PRJNA976345_P_NODE_164162_length_161_cov_1.253968_g162554_i0 PRJNA976345 164162 161 1.253968 2.01888848 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 54.7 0.004   NTclustered gi|2874253796|emb|OY969780.1| 194844 g162554 i0 96.875 1.54658385093168 32 1 20 0 50 81 509863 509894 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 blastn 249 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
2223793 2223793 PRJNA976345_P_NODE_37482_length_279_cov_30.233607_g35875_i0 PRJNA976345 37482 279 30.233607 84.35176353 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 427 3.65e-115   NTclustered gi|2621707050|emb|OY764903.1| 2212468 g35875 i0 94.265 103.598566308244 279 16 100 0 1 279 3558122 3558400 MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 blastn 28904 427 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
4775912 4775912 PRJNA976345_P_NODE_104444_length_187_cov_1.335526_g102836_i0 PRJNA976345 104444 187 1.335526 2.49743362 Bryobacterales bacterium 2026791 Bacteria Bacteria 204 4.18e-48   NTclustered gi|2874254061|emb|OY970385.1| 2026791 g102836 i0 90.789 1.9572192513369 152 14 81 0 3 154 3189790 3189639 MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 blastn 366 204 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
4777120 4777120 PRJNA976345_P_NODE_83084_length_203_cov_1.696429_g81476_i0 PRJNA976345 83084 203 1.696429 3.44375087 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 75 3.78e-9   NTclustered gi|2621701250|emb|OY759970.1| 2910147 g81476 i0 80.198 1.49261083743842 101 19 49 1 104 203 466561 466461 MAG: Vicinamibacterales bacterium isolate d8048395-9ec3-4be5-9403-ce9d0d334964 genome assembly, chromosome: 1 blastn 303 75 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
14976013 14976013 PRJNA976345_P_NODE_182872_length_155_cov_0.941667_g181264_i0 PRJNA976345 182872 155 0.941667 1.45958385 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 76.8 7.56e-10   NTclustered gi|2874254049|emb|OY970373.1| 171953 g181264 i0 95.833 0.309677419354839 48 1 30 1 75 121 2157185 2157138 MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 blastn 48 76.8 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
14976517 14976517 PRJNA976345_P_NODE_54012_length_240_cov_1.151220_g52404_i0 PRJNA976345 54012 240 1.15122 2.762928 Paludibaculum fermentans 1473598 Bacteria Bacteria 239 1.54e-58   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g52404 i0 84.711 2.7125 242 33 100 4 1 240 6384411 6384650 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 651 239 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
14976668 14976668 PRJNA976345_P_NODE_70732_length_215_cov_3.561111_g69124_i0 PRJNA976345 70732 215 3.561111 7.65638865 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 65.8 2.43e-6   NTclustered gi|2874253710|emb|OY969475.1| 2283092 g69124 i0 97.368 1.6093023255814 38 1 18 0 1 38 1678957 1678994 MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 blastn 346 65.8 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
20074670 20074670 PRJNA976345_P_NODE_178056_length_156_cov_1.710744_g176448_i0 PRJNA976345 178056 156 1.710744 2.66876064 Acidobacteriota bacterium 1978231 Bacteria Bacteria 75 2.74e-9   NTclustered gi|1958093598|gb|CP065003.1| 1978231 g176448 i0 95.652 0.294871794871795 46 2 29 0 33 78 442323 442368 Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome blastn 46 75 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
20075059 20075059 PRJNA976345_P_NODE_38256_length_277_cov_2.185950_g36649_i0 PRJNA976345 38256 277 2.18595 6.0550815 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 226 1.42e-54   NTclustered gi|2893358444|emb|OZ220736.1| 2910147 g36649 i0 82.079 77.8808664259928 279 37 99 11 1 273 5795736 5795465 MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1 blastn 21573 226 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
20075567 20075567 PRJNA976345_P_NODE_97156_length_192_cov_1.343949_g95548_i0 PRJNA976345 97156 192 1.343949 2.58038208 uncultured Acidobacteriaceae bacterium 194844 Bacteria Bacteria 233 5.5e-57   NTclustered gi|2874253852|emb|OY969908.1| 194844 g95548 i0 89.305 0.973958333333333 187 18 97 2 3 188 2644831 2644646 MAG: uncultured Acidobacteriaceae bacterium isolate MFD09286.bin.1.44 genome assembly, chromosome: 1 blastn 187 233 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
23900270 23900270 PRJNA976345_P_NODE_127239_length_177_cov_1.288732_g125631_i0 PRJNA976345 127239 177 1.288732 2.28105564 Bryobacterales bacterium 2026791 Bacteria Bacteria 250 4.94e-62   NTclustered gi|2874253826|emb|OY969810.1| 2026791 g125631 i0 93.452 0.949152542372881 168 11 95 0 10 177 7989658 7989825 MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1 blastn 168 250 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
25174677 25174677 PRJNA976345_P_NODE_53380_length_241_cov_1.378641_g51772_i0 PRJNA976345 53380 241 1.378641 3.32252481 Bryobacterales bacterium 2026791 Bacteria Bacteria 58.4 4.66e-4   NTclustered gi|2874254061|emb|OY970385.1| 2026791 g51772 i0 100 0.128630705394191 31 0 13 0 184 214 3675858 3675888 MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 blastn 31 58.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales 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);;