RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA393181" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA393181 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
410961 410961 PRJNA393181_S_NODE_6001_length_477_cov_2.086364_g5895_i0 PRJNA393181 6001 477 2.086364 9.95195628 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 122 3.49e-23   NTclustered gi|575456455|gb|CP007128.1| 861299 g5895 i0 76.543 0.509433962264151 243 45 50 12 215 451 1851826 1852062 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 243 122 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
411042 411042 PRJNA393181_S_NODE_9641_length_388_cov_3.076923_g9535_i0 PRJNA393181 9641 388 3.076923 11.93846124 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 148 4.6e-31   NTclustered gi|2874254163|emb|OY970395.1| 412054 g9535 i0 78.788 1.93814432989691 231 41 59 8 151 377 3244796 3245022 MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1 blastn 752 148 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
1685672 1685672 PRJNA393181_S_NODE_43202_length_160_cov_2.788618_g43096_i0 PRJNA393181 43202 160 2.788618 4.4617888 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 76.8 7.87e-10   NTclustered gi|575456455|gb|CP007128.1| 861299 g43096 i0 79.825 0.7125 114 15 69 7 44 153 1881141 1881032 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 114 76.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
6787806 6787806 PRJNA393181_S_NODE_1346_length_786_cov_2.962617_g1277_i0 PRJNA393181 1346 786 2.962617 23.28616962 uncultured Gemmatimonadaceae bacterium 246130 Bacteria Bacteria 337 1.9399999999999993e-87   NTclustered gi|2874253995|emb|OY970320.1| 246130 g1277 i0 75.126 32.5267175572519 792 159 98 36 16 786 2187124 2187898 MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 blastn 25566 337 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae bacterium
8063337 8063337 PRJNA393181_S_NODE_12167_length_346_cov_2.443366_g12061_i0 PRJNA393181 12167 346 2.443366 8.45404636 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 180 1.44e-40   NTclustered gi|2874253755|emb|OY969695.1| 412054 g12061 i0 77.612 2.33815028901734 335 49 97 15 10 344 4268535 4268843 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 809 180 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
8063416 8063416 PRJNA393181_S_NODE_15447_length_305_cov_3.067164_g15341_i0 PRJNA393181 15447 305 3.067164 9.3548502 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 165 3.5e-36   NTclustered gi|575456455|gb|CP007128.1| 861299 g15341 i0 79.668 9.09508196721312 241 39 77 9 3 238 1880322 1880087 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 2774 165 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
10614588 10614588 PRJNA393181_S_NODE_39629_length_170_cov_2.015038_g39523_i0 PRJNA393181 39629 170 2.015038 3.4255646 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 215 1.71e-51   NTclustered gi|2874254107|emb|OY970192.1| 412054 g39523 i0 89.881 99.3470588235294 168 15 98 2 1 167 2957342 2957176 MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 blastn 16889 215 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
11889758 11889758 PRJNA393181_S_NODE_46750_length_152_cov_2.147826_g46644_i0 PRJNA393181 46750 152 2.147826 3.26469552 uncultured Gemmatimonadaceae bacterium 246130 Bacteria Bacteria 209 6.97e-50   NTclustered gi|2874253995|emb|OY970320.1| 246130 g46644 i0 91.447 90.5328947368421 152 13 100 0 1 152 2186607 2186758 MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 blastn 13761 209 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae bacterium
13164774 13164774 PRJNA393181_S_NODE_711_length_938_cov_2.247503_g657_i0 PRJNA393181 711 938 2.247503 21.08157814 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 514 1.01e-140   NTclustered gi|575456455|gb|CP007128.1| 861299 g657 i0 78.066 88.9669509594883 848 162 89 16 103 936 705526 704689 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 83451 514 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
14439252 14439252 PRJNA393181_S_NODE_25732_length_225_cov_3.234043_g25626_i0 PRJNA393181 25732 225 3.234043 7.27659675 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 56.5 0.002   NTclustered gi|575461033|gb|CP007129.1| 861299 g25626 i0 100 0.391111111111111 30 0 13 0 33 62 1078859 1078830 Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence blastn 88 56.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
16381145 16381145 PRJNA393181_S_NODE_8053_length_421_cov_2.656250_g7947_i0 PRJNA393181 8053 421 2.65625 11.1828125 Pseudomonadati 3379134 Bacteria Bacteria 233 1.35e-56   NTclustered gi|2893358440|emb|OZ220732.1| 2910168 g7947 i0 83.936 53.6627078384798 249 34 58 6 8 252 3038159 3037913 MAG: Longimicrobiales bacterium isolate 1657d605-667c-4cd4-94fa-5f7303d281ff genome assembly, chromosome: 1 blastn 22592 233 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
23362218 23362218 PRJNA393181_S_NODE_14399_length_318_cov_2.032028_g14293_i0 PRJNA393181 14399 318 2.032028 6.46184904 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 58.4 6.41e-4   NTclustered gi|2874253728|emb|OY969570.1| 412054 g14293 i0 100 0.276729559748428 31 0 10 0 288 318 5651556 5651526 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 88 58.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
24030422 24030422 PRJNA393181_S_NODE_5679_length_487_cov_3.013333_g5573_i0 PRJNA393181 5679 487 3.013333 14.67493171 Pseudomonadati 3379134 Bacteria Bacteria 58.4 0.001   NTclustered gi|2874253728|emb|OY969570.1| 412054 g5573 i0 97.059 0.669404517453799 34 1 7 0 217 250 87462 87495 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 326 58.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium

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