RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1111146 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
2766656 2766656 PRJNA1111146_P_NODE_229903_length_200_cov_1.551020_g228765_i0 PRJNA1111146 229903 200 1.55102 3.10204 Gaopeijia maritima 3119007 Bacteria Bacteria 111 2.83e-20   NTclustered gi|2716997671|gb|CP144380.1| 3119007 g228765 i0 92.308 1.825 78 6 39 0 123 200 492315 492238 Gaopeijia maritima strain DH-78 chromosome, complete genome blastn 365 111 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Gaopeijiales Gaopeijiaceae Gaopeijia Gaopeijia maritima
7868479 7868479 PRJNA1111146_P_NODE_154047_length_219_cov_1.608434_g152909_i0 PRJNA1111146 154047 219 1.608434 3.52247046 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 259 1.06e-64   NTclustered gi|575456455|gb|CP007128.1| 861299 g152909 i0 88.073 88.812785388127807 218 26 99 0 1 218 3045048 3045265 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 19450 259 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
9143601 9143601 PRJNA1111146_P_NODE_220088_length_202_cov_1.530201_g218950_i0 PRJNA1111146 220088 202 1.530201 3.09100602 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 137 4.72e-28   NTclustered gi|2874253978|emb|OY970303.1| 412054 g218950 i0 81.143 1.39108910891089 175 30 86 3 5 177 1897341 1897514 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 281 137 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
11695857 11695857 PRJNA1111146_P_NODE_7950_length_555_cov_16.754980_g6840_i0 PRJNA1111146 7950 555 16.75498 92.990139 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 632 1.5299999999999996e-176   NTclustered gi|575456455|gb|CP007128.1| 861299 g6840 i0 87.321 138.913513513514 560 62 100 9 1 555 3042866 3042311 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 77097 632 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
15519502 15519502 PRJNA1111146_P_NODE_417193_length_178_cov_0.912000_g416055_i0 PRJNA1111146 417193 178 0.912 1.62336 uncultured Gemmatimonadaceae bacterium 246130 Bacteria Bacteria 211 2.35e-50   NTclustered gi|2874253995|emb|OY970320.1| 246130 g416055 i0 88.136 46.6179775280899 177 21 99 0 1 177 676573 676749 MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 blastn 8298 211 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae bacterium
18068127 18068127 PRJNA1111146_P_NODE_343635_length_183_cov_0.861538_g342497_i0 PRJNA1111146 343635 183 0.861538 1.57661454 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 217 5.219999999999999e-52   NTclustered gi|2874253728|emb|OY969570.1| 412054 g342497 i0 88.043 2.01092896174863 184 20 100 2 1 183 725132 725314 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 368 217 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
24442181 24442181 PRJNA1111146_P_NODE_285560_length_189_cov_2.220588_g284422_i0 PRJNA1111146 285560 189 2.220588 4.19691132 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 322 1.12e-83   NTclustered gi|2874253789|emb|OY969773.1| 412054 g284422 i0 97.354 132.21164021164 189 5 100 0 1 189 421797 421609 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 24988 322 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);;