RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA902848 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
881926 881926 PRJNA902848_P_NODE_13101_length_253_cov_0.866667_g13051_i0 PRJNA902848 13101 253 0.866667 2.19266751 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 228 3.549999999999999e-55   NTclustered gi|2874253959|emb|OY970284.1| 2651171 g13051 i0 83.401 56.4505928853755 247 39 97 2 7 252 2488106 2487861 MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1 blastn 14282 228 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
4710546 4710546 PRJNA902848_P_NODE_17364_length_246_cov_0.901734_g17314_i0 PRJNA902848 17364 246 0.901734 2.21826564 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 52.8 0.022   NTclustered gi|2874253679|emb|OY969113.1| 171953 g17314 i0 100 0.113821138211382 28 0 11 0 48 75 1055614 1055641 MAG: uncultured Acidobacteriota bacterium isolate MFD03399.bin.1.55 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
8534984 8534984 PRJNA902848_P_NODE_20387_length_242_cov_0.923077_g20337_i0 PRJNA902848 20387 242 0.923077 2.23384634 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 294 3.28e-75   NTclustered gi|2874253959|emb|OY970284.1| 2651171 g20337 i0 88.797 415.768595041322 241 25 99 2 1 240 6631385 6631146 MAG: Thermoanaerobaculia bacterium isolate MFD05513.bin.1.42 genome assembly, chromosome: 1 blastn 100616 294 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
9809927 9809927 PRJNA902848_P_NODE_20308_length_242_cov_0.923077_g20258_i0 PRJNA902848 20308 242 0.923077 2.23384634 Thermoanaerobaculaceae bacterium 2699758 Bacteria Bacteria 178 3.45e-40   NTclustered gi|2874254005|emb|OY970330.1| 2699758 g20258 i0 81.776 8.75619834710744 214 37 88 2 26 238 6993542 6993330 MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 blastn 2119 178 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales Thermoanaerobaculaceae   Thermoanaerobaculaceae bacterium
14909709 14909709 PRJNA902848_P_NODE_10052_length_284_cov_1.478673_g10002_i0 PRJNA902848 10052 284 1.478673 4.19943132 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 206 1.8999999999999997e-48   NTclustered gi|2874253709|emb|OY969474.1| 171953 g10002 i0 80 2.52464788732394 285 51 99 5 3 284 1632632 1632913 MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 blastn 717 206 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
16184748 16184748 PRJNA902848_P_NODE_15733_length_249_cov_0.886364_g15683_i0 PRJNA902848 15733 249 0.886364 2.20704636 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 226 1.2499999999999999e-54   NTclustered gi|2874253744|emb|OY969603.1| 171953 g15683 i0 83.682 69.4457831325301 239 39 96 0 8 246 5260471 5260709 MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1 blastn 17292 226 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
20373326 20373326 PRJNA902848_P_NODE_20376_length_242_cov_0.923077_g20326_i0 PRJNA902848 20376 242 0.923077 2.23384634 Luteitalea 2004797 Bacteria Bacteria 265 2.5699999999999997e-66   NTclustered gi|1016914409|gb|CP015136.1| 1855912 g20326 i0 88 23.603305785124 225 25 93 2 19 242 1237901 1238124 Luteitalea pratensis strain DSM 100886 chromosome, complete genome blastn 5712 267 0.99250936329588 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea pratensis
25107862 25107862 PRJNA902848_P_NODE_10480_length_279_cov_1.451456_g10430_i0 PRJNA902848 10480 279 1.451456 4.04956224 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 158 5.29e-34   NTclustered gi|2893358436|emb|OZ220728.1| 2910147 g10430 i0 79.556 4.45519713261649 225 42 80 4 36 258 777128 777350 MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1 blastn 1243 158 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
25107991 25107991 PRJNA902848_P_NODE_16480_length_248_cov_0.891429_g16430_i0 PRJNA902848 16480 248 0.891429 2.21074392 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 111 3.65e-20   NTclustered gi|2814788339|emb|OY761475.2| 2910147 g16430 i0 85.849 0.778225806451613 106 13 42 2 40 144 2740991 2740887 MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1 blastn 193 111 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales 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);;