RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA498309" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA498309 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
1756218 1756218 PRJNA498309_P_NODE_67642_length_295_cov_2.104651_g65493_i0 PRJNA498309 67642 295 2.104651 6.20872045 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 318 2.439999999999999e-82   NTclustered gi|2874253938|emb|OY970263.1| 412054 g65493 i0 90.079 71.8745762711864 252 16 85 6 23 273 802189 802432 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 21203 318 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
4308376 4308376 PRJNA498309_P_NODE_90944_length_217_cov_1.905556_g88795_i0 PRJNA498309 90944 217 1.905556 4.13505652 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 119 1.86e-22   NTclustered gi|2874253978|emb|OY970303.1| 412054 g88795 i0 78.771 2.50230414746544 179 36 82 2 17 193 6091244 6091066 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 543 119 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
10685893 10685893 PRJNA498309_S_NODE_28709_length_316_cov_37.494662_g26541_i0 PRJNA498309 28709 316 37.494662 118.48313192 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 342 1.5699999999999999e-89   NTclustered gi|575456455|gb|CP007128.1| 861299 g26541 i0 93.534 245.354430379747 232 11 73 4 68 297 3043199 3042970 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 77532 342 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
10686495 10686495 PRJNA498309_S_NODE_9829_length_813_cov_8.407455_g8085_i0 PRJNA498309 9829 813 8.407455 68.35260915 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 1105 0   NTclustered gi|575456455|gb|CP007128.1| 861299 g8085 i0 91.929 203.671586715867 793 58 97 6 4 794 3043758 3042970 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 165585 1105 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
15783541 15783541 PRJNA498309_P_NODE_49113_length_381_cov_4.436047_g46975_i0 PRJNA498309 49113 381 4.436047 16.90133907 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 588 2.2399999999999998e-163   NTclustered gi|2874253978|emb|OY970303.1| 412054 g46975 i0 95.722 145.826771653543 374 0 94 2 1 358 1903676 1904049 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 55560 588 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);;