RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA939369" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939369 · 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
3465253 3465253 PRJNA939369_S_NODE_5383_length_528_cov_4.575824_g4967_i0 PRJNA939369 5383 528 4.575824 24.16035072 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 795 0   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g4967 i0 93.785 77.907196969697 531 30 100 3 1 528 2002824 2003354 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 41135 795 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
8908881 8908881 PRJNA939369_S_NODE_22207_length_327_cov_2.791339_g21790_i0 PRJNA939369 22207 327 2.791339 9.12767853 Gemmataceae 1914233 Bacteria Bacteria 453 7.210000000000001e-123   NTclustered gi|1727537522|gb|CP042911.1| 114 g21790 i0 91.743 130.834862385321 327 25 100 2 1 327 1034777 1035101 Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome blastn 42783 455 0.995604395604396 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
16217244 16217244 PRJNA939369_S_NODE_2833_length_674_cov_5.935108_g2437_i0 PRJNA939369 2833 674 5.935108 40.00262792 Frigoriglobus tundricola 2774151 Bacteria Bacteria 1201 0   NTclustered gi|1870286614|gb|CP053452.2| 2774151 g2437 i0 98.813 119.197329376855 674 8 100 0 1 674 1092265 1092938 Frigoriglobus tundricola strain PL17 chromosome, complete genome blastn 80339 1201 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola
18766313 18766313 PRJNA939369_S_NODE_68755_length_244_cov_1.426901_g68338_i0 PRJNA939369 68755 244 1.426901 3.48163844 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 200 7.4299999999999985e-47   NTclustered gi|1927958621|gb|CP054186.1| 2026777 g68338 i0 81.855 89.0081967213115 248 36 100 6 1 244 1866433 1866675 MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome blastn 21718 200 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
21316265 21316265 PRJNA939369_S_NODE_16157_length_361_cov_1.479167_g15740_i0 PRJNA939369 16157 361 1.479167 5.33979287 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 623 5.779999999999999e-174   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g15740 i0 97.784 137.02216066482 361 8 100 0 1 361 2003835 2003475 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 49465 623 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
21658318 21658318 PRJNA939369_S_NODE_2057_length_769_cov_4.298851_g1685_i0 PRJNA939369 2057 769 4.298851 33.05816419 Gemmataceae 1914233 Bacteria Bacteria 1254 0   NTclustered gi|1804905141|emb|LR593886.1| 1210884 g1685 i0 96.224 174.561768530559 768 25 99 3 1 766 3634444 3633679 Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1 blastn 134238 1260 0.995238095238095 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana

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