RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA312107 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
377581 377581 PRJNA312107_P_NODE_22001_length_166_cov_0.888889_g21835_i0 PRJNA312107 22001 166 0.888889 1.47555574 Gemmatimonas groenlandica 2732249 Bacteria Bacteria 122 1.0399999999999997e-23   NTclustered gi|1839994010|gb|CP053085.1| 2732249 g21835 i0 80.723 3.00602409638554 166 24 98 7 2 163 4991492 4991653 Gemmatimonas groenlandica strain TET16 chromosome, complete genome blastn 499 122 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas groenlandica
11856206 11856206 PRJNA312107_P_NODE_17930_length_172_cov_1.325203_g17764_i0 PRJNA312107 17930 172 1.325203 2.27934916 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 119 1.4000000000000002e-22   NTclustered gi|575456455|gb|CP007128.1| 861299 g17764 i0 79.775 2.44767441860465 178 24 100 7 1 172 3055506 3055335 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 421 119 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
16954911 16954911 PRJNA312107_P_NODE_17214_length_176_cov_1.307087_g17048_i0 PRJNA312107 17214 176 1.307087 2.30047312 uncultured Gemmatimonadaceae bacterium 246130 Bacteria Bacteria 211 2.31e-50   NTclustered gi|2874253995|emb|OY970320.1| 246130 g17048 i0 89.759 105.198863636364 166 16 94 1 12 176 232902 233067 MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 blastn 18515 211 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae bacterium
24603642 24603642 PRJNA312107_P_NODE_20600_length_167_cov_0.881356_g20434_i0 PRJNA312107 20600 167 0.881356 1.47186452 uncultured Gemmatimonadaceae bacterium 246130 Bacteria Bacteria 117 4.900000000000001e-22   NTclustered gi|2874253995|emb|OY970320.1| 246130 g20434 i0 80.769 15.8562874251497 156 24 92 5 12 164 714017 714169 MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 blastn 2648 117 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae 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);;