RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA382357 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
13158472 13158472 PRJNA382357_P_NODE_98991_length_243_cov_2.065934_g98252_i0 PRJNA382357 98991 243 2.065934 5.02021962 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 313 9.1e-81   NTclustered gi|2874253978|emb|OY970303.1| 412054 g98252 i0 91.102 155.053497942387 236 13 97 5 12 243 3486087 3485856 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 37678 313 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
15705117 15705117 PRJNA382357_P_NODE_108453_length_233_cov_14.127907_g107714_i0 PRJNA382357 108453 233 14.127907 32.91802331 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 191 4.23e-44   NTclustered gi|2874253978|emb|OY970303.1| 412054 g107714 i0 95.763 11.8969957081545 118 5 52 0 1 118 1903350 1903467 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 2772 191 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
19528890 19528890 PRJNA382357_P_NODE_15136_length_554_cov_3.160243_g14413_i0 PRJNA382357 15136 554 3.160243 17.50774622 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 542 2.65e-149   NTclustered gi|575456455|gb|CP007128.1| 861299 g14413 i0 94.382 109.379061371841 356 14 99 5 202 554 3042749 3043101 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 60596 542 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
21476547 21476547 PRJNA382357_P_NODE_165037_length_185_cov_4.032258_g164298_i0 PRJNA382357 165037 185 4.032258 7.4596773 FCB group 1783270 Bacteria Bacteria 75 3.37e-9   NTclustered gi|2874253755|emb|OY969695.1| 412054 g164298 i0 82.927 3.91891891891892 82 14 44 0 1 82 169529 169610 MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1 blastn 725 75 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
24630960 24630960 PRJNA382357_P_NODE_88700_length_255_cov_1.768041_g87961_i0 PRJNA382357 88700 255 1.768041 4.50850455 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 215 2.79e-51   NTclustered gi|2874253728|emb|OY969570.1| 412054 g87961 i0 93.197 23.7529411764706 147 9 78 1 103 249 2228201 2228346 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 6057 215 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);;