RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1005695", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 3 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 3 ✖

bioproject 1

  • PRJNA1005695 · 3 ✖

analysis 1

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
1428187 1428187 PRJNA1005695_P_NODE_18082_length_355_cov_2.723404_g17230_i0 PRJNA1005695 18082 355 2.723404 9.6680842 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 575 1.6099999999999995e-159   NTclustered gi|2874253789|emb|OY969773.1| 412054 g17230 i0 96.034 161.769014084507 353 14 99 0 3 355 421669 422021 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 57428 575 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
15456205 15456205 PRJNA1005695_P_NODE_31973_length_264_cov_1.251309_g31121_i0 PRJNA1005695 31973 264 1.251309 3.30345576 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 296 1.01e-75   NTclustered gi|2874253938|emb|OY970263.1| 412054 g31121 i0 90.625 68.3901515151515 224 19 84 2 43 264 801379 801156 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 18055 296 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
24379529 24379529 PRJNA1005695_P_NODE_25260_length_298_cov_3.404444_g24408_i0 PRJNA1005695 25260 298 3.404444 10.14524312 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 298 3.22e-76   NTclustered gi|575456455|gb|CP007128.1| 861299 g24408 i0 84.918 95.1275167785235 305 34 100 11 1 298 3042336 3042635 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 28348 298 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis

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