RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA662254" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA662254 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
3179322 3179322 PRJNA662254_P_NODE_65963_length_241_cov_0.875000_g65312_i0 PRJNA662254 65963 241 0.875 2.10875 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 335 1.9199999999999993e-87   NTclustered gi|2874253755|emb|OY969695.1| 412054 g65312 i0 92.017 1.9253112033195 238 19 99 0 2 239 2222200 2221963 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 464 335 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
7006947 7006947 PRJNA662254_P_NODE_48126_length_250_cov_0.870056_g47475_i0 PRJNA662254 48126 250 0.870056 2.17514 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 248 2.69e-61   NTclustered gi|2874253728|emb|OY969570.1| 412054 g47475 i0 84.898 3.82 245 37 98 0 1 245 2187007 2186763 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 955 248 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
8281496 8281496 PRJNA662254_P_NODE_47947_length_250_cov_0.870056_g47296_i0 PRJNA662254 47947 250 0.870056 2.17514 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 195 3.55e-45   NTclustered gi|2874253978|emb|OY970303.1| 412054 g47296 i0 83.654 22.324 208 32 83 2 27 233 8022964 8022758 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 5581 195 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
14657300 14657300 PRJNA662254_P_NODE_54812_length_246_cov_0.890173_g54161_i0 PRJNA662254 54812 246 0.890173 2.18982558 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 113 1e-20   NTclustered gi|2874253978|emb|OY970303.1| 412054 g54161 i0 84.348 13.4227642276423 115 18 47 0 118 232 4874019 4873905 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 3302 113 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
15931214 15931214 PRJNA662254_P_NODE_50053_length_249_cov_0.875000_g49402_i0 PRJNA662254 50053 249 0.875 2.17875 Pseudogemmatithrix spongiicola 3062599 Bacteria Bacteria 220 5.84e-53   NTclustered gi|2557479348|gb|CP130613.1| 3062599 g49402 i0 84.581 87.3975903614458 227 30 90 4 5 228 1812784 1813008 Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome blastn 21762 220 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Pseudogemmatithrix Pseudogemmatithrix spongiicola
18480752 18480752 PRJNA662254_P_NODE_57515_length_245_cov_0.895349_g56864_i0 PRJNA662254 57515 245 0.895349 2.19360505 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 254 5.65e-63   NTclustered gi|2874253938|emb|OY970263.1| 412054 g56864 i0 86.134 88.469387755102 238 30 96 3 2 237 218023 217787 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 21675 254 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
18480761 18480761 PRJNA662254_P_NODE_59015_length_244_cov_0.900585_g58364_i0 PRJNA662254 59015 244 0.900585 2.1974274 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 268 2.01e-67   NTclustered gi|2874253755|emb|OY969695.1| 412054 g58364 i0 86.777 10.9590163934426 242 30 99 2 4 244 3972498 3972258 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 2674 268 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
19755340 19755340 PRJNA662254_P_NODE_62696_length_242_cov_0.911243_g62045_i0 PRJNA662254 62696 242 0.911243 2.20520806 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 220 5.65e-53   NTclustered gi|2874253728|emb|OY969570.1| 412054 g62045 i0 83.913 12.9669421487603 230 37 95 0 12 241 4522045 4522274 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 3138 220 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales 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);;