RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA799842 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
793914 793914 PRJNA799842_P_NODE_165201_length_245_cov_1.343023_g163628_i0 PRJNA799842 165201 245 1.343023 3.29040635 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 316 7.099999999999998e-82   NTclustered gi|2874253728|emb|OY969570.1| 412054 g163628 i0 90.574 175.485714285714 244 15 98 7 1 240 173246 173007 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 42994 316 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
2071565 2071565 PRJNA799842_P_NODE_84402_length_314_cov_1.829876_g82829_i0 PRJNA799842 84402 314 1.829876 5.74581064 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 414 3.25e-111   NTclustered gi|2874253789|emb|OY969773.1| 412054 g82829 i0 90.476 70.2834394904459 315 29 100 1 1 314 421314 421628 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 22069 414 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
7171897 7171897 PRJNA799842_P_NODE_14786_length_807_cov_2.801090_g13430_i0 PRJNA799842 14786 807 2.80109 22.6047963 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 887 0   NTclustered gi|575456455|gb|CP007128.1| 861299 g13430 i0 86.642 165.291201982652 816 91 100 17 1 807 3044148 3043342 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 133390 887 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
9722554 9722554 PRJNA799842_P_NODE_2208_length_1818_cov_3.763897_g573_i3 PRJNA799842 2208 1818 3.763897 68.42764746 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 2503 0   NTclustered gi|575456455|gb|CP007128.1| 861299 g573 i3 92.421 138.977447744774 1768 112 97 21 58 1818 3044066 3042314 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 252661 2503 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
14823497 14823497 PRJNA799842_P_NODE_54092_length_386_cov_1.373802_g52519_i0 PRJNA799842 54092 386 1.373802 5.30287572 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 372 2.4899999999999995e-98   NTclustered gi|575456455|gb|CP007128.1| 861299 g52519 i0 84.439 63.8523316062176 392 46 99 13 2 386 3042404 3042787 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 24647 372 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
25022537 25022537 PRJNA799842_P_NODE_90640_length_305_cov_0.840517_g89067_i0 PRJNA799842 90640 305 0.840517 2.56357685 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 318 2.5399999999999995e-82   NTclustered gi|2874253789|emb|OY969773.1| 412054 g89067 i0 88.433 9.07540983606557 268 26 87 5 1 266 421972 422236 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 2768 318 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);;