RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1126661" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1126661 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
1557442 1557442 PRJNA1126661_P_NODE_81902_length_218_cov_4.303448_g81372_i0 PRJNA1126661 81902 218 4.303448 9.38151664 Gimesia chilikensis 2605989 Bacteria Bacteria 54.7 0.005   NTclustered gi|1712542717|gb|CP036342.1| 2605989 g81372 i0 100 0.903669724770642 29 0 13 0 25 53 7149306 7149278 Gimesia chilikensis strain MalM14 chromosome blastn 197 54.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia Gimesia chilikensis
2833172 2833172 PRJNA1126661_P_NODE_4383_length_417_cov_4.648256_g3856_i0 PRJNA1126661 4383 417 4.648256 19.38322752 Gemmataceae bacterium 2052164 Bacteria Bacteria 473 7.219999999999999e-129   NTclustered gi|2063814025|emb|LR586051.1| 2052164 g3856 i0 87.381 101.213429256595 420 44 99 9 2 417 320357 319943 Gemmata bacterium CJuql4 whole genome assembly and annotation blastn 42206 473 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
4109589 4109589 PRJNA1126661_P_NODE_51464_length_294_cov_5.452489_g50935_i0 PRJNA1126661 51464 294 5.452489 16.03031766 uncultured Planctomycetaceae bacterium 100233 Bacteria Bacteria 183 9.27e-42   NTclustered gi|2874254106|emb|OY970189.1| 100233 g50935 i0 88.667 29.5748299319728 150 17 51 0 145 294 145914 145765 MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1 blastn 8695 183 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   uncultured Planctomycetaceae bacterium
4858924 4858924 PRJNA1126661_P_NODE_29064_length_326_cov_2.727273_g28535_i0 PRJNA1126661 29064 326 2.727273 8.89090998 Gemmata 113 Bacteria Bacteria 198 3.72e-46   NTclustered gi|1727537522|gb|CP042911.1| 114 g28535 i0 90.667 31.1564417177914 150 12 46 2 178 326 6451049 6450901 Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome blastn 10157 198 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
6660019 6660019 PRJNA1126661_P_NODE_17326_length_326_cov_4.450593_g16797_i0 PRJNA1126661 17326 326 4.450593 14.50893318 Lignipirellula cremea 2528010 Bacteria Bacteria 147 1.37e-30   NTclustered gi|1712668320|gb|CP036433.1| 2528010 g16797 i0 85.034 1.5 147 18 44 3 176 320 9103595 9103739 Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome blastn 489 147 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Lignipirellula Lignipirellula cremea
6660741 6660741 PRJNA1126661_P_NODE_9366_length_326_cov_7.806324_g8837_i0 PRJNA1126661 9366 326 7.806324 25.44861624 Pirellulimonas nuda 2528009 Bacteria Bacteria 119 2.98e-22   NTclustered gi|1712662089|gb|CP036291.1| 2528009 g8837 i0 81.208 1.84662576687117 149 26 45 2 4 151 363613 363760 Pirellulimonas nuda strain Pla175 chromosome, complete genome blastn 602 119 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Pirellulimonas Pirellulimonas nuda
7935674 7935674 PRJNA1126661_P_NODE_60367_length_277_cov_2.303922_g59837_i0 PRJNA1126661 60367 277 2.303922 6.38186394 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 130 1.14e-25   NTclustered gi|2258877542|gb|CP060234.1| 2026777 g59837 i0 82.119 51.4909747292419 151 27 55 0 24 174 2041224 2041374 MAG: Phycisphaeraceae bacterium isolate HK-STAS-PLAN-6 chromosome blastn 14263 130 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
12509961 12509961 PRJNA1126661_P_NODE_9730_length_326_cov_7.498024_g9201_i0 PRJNA1126661 9730 326 7.498024 24.44355824 Gemmata 113 Bacteria Bacteria 233 1.02e-56   NTclustered gi|1727537522|gb|CP042911.1| 114 g9201 i0 95.238 80.8588957055215 147 7 91 0 178 324 4797965 4797819 Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome blastn 26360 233 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
13036581 13036581 PRJNA1126661_P_NODE_8491_length_326_cov_8.944664_g7962_i0 PRJNA1126661 8491 326 8.944664 29.15960464 Lacipirellula limnantheis 2528024 Bacteria Bacteria 233 1.02e-56   NTclustered gi|1712529062|gb|CP036339.1| 2528024 g7962 i0 94.667 14.5184049079755 150 8 91 0 177 326 271648 271797 Lacipirellula limnantheis strain I41 chromosome blastn 4733 233 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula limnantheis
20684228 20684228 PRJNA1126661_P_NODE_77977_length_231_cov_10.873418_g77447_i0 PRJNA1126661 77977 231 10.873418 25.11759558 uncultured Gemmataceae bacterium 1914239 Bacteria Bacteria 315 2.38e-81   NTclustered gi|2874253853|emb|OY969909.1| 1914239 g77447 i0 92.377 65.2813852813853 223 13 96 4 1 221 2003316 2003096 MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1 blastn 15080 315 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   uncultured Gemmataceae bacterium
21959208 21959208 PRJNA1126661_P_NODE_38578_length_301_cov_3.951754_g38049_i0 PRJNA1126661 38578 301 3.951754 11.89477954 Anatilimnocola aggregata 2528021 Bacteria Bacteria 67.6 1e-6   NTclustered gi|1712591889|gb|CP036274.1| 2528021 g38049 i0 83.333 10.3023255813953 78 8 26 5 223 300 8506911 8506983 Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome blastn 3101 67.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Anatilimnocola Anatilimnocola aggregata

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