RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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

  • PRJNA1249042 · 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
354576 354576 PRJNA1249042_S_NODE_67321_length_190_cov_2.238095_g67107_i0 PRJNA1249042 67321 190 2.238095 4.2523805 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 279 6.88e-71   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g67107 i0 93.194 238.415789473684 191 11 100 2 1 190 2002496 2002685 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 45299 279 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
11255500 11255500 PRJNA1249042_S_NODE_15389_length_280_cov_1.987342_g15175_i0 PRJNA1249042 15389 280 1.987342 5.5645576 Botrimarina 2795782 Bacteria Bacteria 484 2.15e-132   NTclustered gi|1712768844|gb|CP036350.1| 2527962 g15175 i0 97.857 310.957142857143 280 6 100 0 1 280 4247467 4247188 Planctomycetes bacterium K2D chromosome, complete genome blastn 87068 484 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium K2D
13108334 13108334 PRJNA1249042_S_NODE_37731_length_227_cov_3.994565_g37517_i0 PRJNA1249042 37731 227 3.994565 9.06766255 Humisphaera borealis 2807512 Bacteria Bacteria 231 2.4199999999999997e-56   NTclustered gi|1927742986|gb|CP063458.1| 2807512 g37517 i0 85.526 50.4229074889868 228 26 99 7 4 227 5063116 5062892 Humisphaera borealis strain M1803 chromosome, complete genome blastn 11446 231 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera borealis
13108786 13108786 PRJNA1249042_S_NODE_96251_length_164_cov_1.942149_g96037_i0 PRJNA1249042 96251 164 1.942149 3.18512436 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 191 2.78e-44   NTclustered gi|2874254106|emb|OY970189.1| 100233 g96037 i0 88.535 10.4146341463415 157 18 96 0 8 164 7956693 7956849 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 1708 191 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
18206014 18206014 PRJNA1249042_S_NODE_18515_length_269_cov_1.840708_g18301_i0 PRJNA1249042 18515 269 1.840708 4.95150452 Lacipirellula limnantheis 2528024 Bacteria Bacteria 481 2.65e-131   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g18301 i0 98.885 146.226765799256 269 3 100 0 1 269 5171549 5171817 Lacipirellula limnantheis strain I41 chromosome blastn 39335 481 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
24580832 24580832 PRJNA1249042_S_NODE_39180_length_225_cov_2.582418_g38966_i0 PRJNA1249042 39180 225 2.582418 5.8104405 Limnoglobus roseus 2598579 Bacteria Bacteria 372 1.35e-98   NTclustered gi|1733446852|gb|CP042425.1| 2598579 g38966 i0 96.444 41.1822222222222 225 8 100 0 1 225 2956669 2956893 Limnoglobus roseus strain PX52 chromosome, complete genome blastn 9266 372 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Limnoglobus Limnoglobus roseus

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