RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA274362" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA274362 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
6748367 6748367 PRJNA274362_S_NODE_28846_length_177_cov_0.812500_g28726_i0 PRJNA274362 28846 177 0.8125 1.438125 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 228 2.3099999999999997e-55   NTclustered gi|2874253677|emb|OY969111.1| 171953 g28726 i0 89.944 420.050847457627 179 14 100 4 1 177 715842 716018 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 blastn 74349 228 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
6748430 6748430 PRJNA274362_S_NODE_32106_length_169_cov_0.866667_g31986_i0 PRJNA274362 32106 169 0.866667 1.46466723 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 156 1.05e-33   NTclustered gi|2874254027|emb|OY970352.1| 171953 g31986 i0 83.237 229.10650887574 173 25 100 2 1 169 2368258 2368430 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 38719 156 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
8023840 8023840 PRJNA274362_S_NODE_20287_length_205_cov_1.211538_g20167_i0 PRJNA274362 20287 205 1.211538 2.4836529 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 326 9.55e-85   NTclustered gi|112980873|gb|DQ829677.1| 171953 g20167 i0 96.02 310.439024390244 201 6 98 2 6 205 1538 1339 Uncultured Acidobacteria bacterium clone DON3 23S ribosomal RNA gene, partial sequence blastn 63640 326 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
9298877 9298877 PRJNA274362_S_NODE_35748_length_164_cov_1.069565_g35628_i0 PRJNA274362 35748 164 1.069565 1.7540866 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 281 1.6000000000000001e-71   NTclustered gi|31789410|gb|AY281354.1| 171953 g35628 i0 97.561 99.2682926829268 164 4 100 0 1 164 37605 37442 Uncultured Acidobacteria bacterium clone 38c7 genomic sequence blastn 16280 281 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
11849281 11849281 PRJNA274362_S_NODE_28090_length_179_cov_1.076923_g27970_i0 PRJNA274362 28090 179 1.076923 1.92769217 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 287 3.82e-73   NTclustered gi|31789387|gb|AY281353.1| 171953 g27970 i0 96.023 272.094972067039 176 7 98 0 1 176 29593 29418 Uncultured Acidobacteria bacterium clone 32d1 genomic sequence blastn 48705 287 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
11849386 11849386 PRJNA274362_S_NODE_33290_length_167_cov_1.305085_g33170_i0 PRJNA274362 33290 167 1.305085 2.17949195 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 204 3.65e-48   NTclustered gi|31789363|gb|AY281352.1| 171953 g33170 i0 88.824 151.137724550898 170 13 100 6 1 167 4165 3999 Uncultured Acidobacteria bacterium clone 23k22 genomic sequence blastn 25240 204 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
15673040 15673040 PRJNA274362_S_NODE_12753_length_248_cov_3.959799_g12633_i0 PRJNA274362 12753 248 3.959799 9.82030152 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 357 4.24e-94   NTclustered gi|2621707050|emb|OY764903.1| 2212468 g12633 i0 93.061 104.241935483871 245 16 100 1 4 248 3558344 3558101 MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 blastn 25852 357 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
17636171 17636171 PRJNA274362_S_NODE_22254_length_197_cov_1.837838_g22134_i0 PRJNA274362 22254 197 1.837838 3.62054086 Bacteria 2 Bacteria Bacteria 315 1.9699999999999998e-81   NTclustered gi|76574290|gb|DQ139438.1| 171953 g22134 i0 95.431 99.2741116751269 197 9 100 0 1 197 572 768 Uncultured Acidobacteria bacterium clone CAL10 23S ribosomal RNA gene, partial sequence blastn 19557 315 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
22047019 22047019 PRJNA274362_S_NODE_21238_length_201_cov_1.394737_g21118_i0 PRJNA274362 21238 201 1.394737 2.80342137 Paludibaculum fermentans 1473598 Bacteria Bacteria 244 2.69e-60   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g21118 i0 93.333 260.393034825871 165 11 82 0 35 199 4784651 4784815 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 52339 244 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
23322481 23322481 PRJNA274362_S_NODE_19459_length_208_cov_2.000000_g19339_i0 PRJNA274362 19459 208 2 4.16 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 381 2.0499999999999995e-101   NTclustered gi|157142641|gb|EU122912.1| 171953 g19339 i0 100 98.7548076923077 206 0 99 0 1 206 212 7 Uncultured Acidobacteria bacterium clone REF-050 16S ribosomal RNA gene, partial sequence blastn 20541 381 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota 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);;