RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA976345 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
7326812 7326812 PRJNA976345_P_NODE_96986_length_192_cov_1.515924_g95378_i0 PRJNA976345 96986 192 1.515924 2.91057408 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 54.7 0.005   NTclustered gi|575456455|gb|CP007128.1| 861299 g95378 i0 100 0.151041666666667 29 0 15 0 59 87 751333 751361 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 29 54.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
9876078 9876078 PRJNA976345_P_NODE_150728_length_166_cov_1.519084_g149120_i0 PRJNA976345 150728 166 1.519084 2.52167944 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 67.6 4.96e-7   NTclustered gi|2874253728|emb|OY969570.1| 412054 g149120 i0 85.714 3.55421686746988 63 9 38 0 3 65 5056304 5056366 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 590 67.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
12428091 12428091 PRJNA976345_P_NODE_79830_length_206_cov_1.730994_g78222_i0 PRJNA976345 79830 206 1.730994 3.56584764 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 165 2.22e-36   NTclustered gi|575462059|gb|CP007130.1| 861299 g78222 i0 81.773 10.9126213592233 203 31 97 6 1 200 760692 760493 Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence blastn 2248 165 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
13701683 13701683 PRJNA976345_P_NODE_164491_length_161_cov_0.976190_g162883_i0 PRJNA976345 164491 161 0.97619 1.5716659 Gemmatimonas groenlandica 2732249 Bacteria Bacteria 150 4.61e-32   NTclustered gi|1839994010|gb|CP053085.1| 2732249 g162883 i0 83.75 43.3354037267081 160 24 99 2 1 159 1337710 1337552 Gemmatimonas groenlandica strain TET16 chromosome, complete genome blastn 6977 150 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas groenlandica

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);;