RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB20058" and tax_phylum = "Candidatus Omnitrophota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Omnitrophota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB20058 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
25654013 25654013 PRJEB20058_P_NODE_224866_length_238_cov_5.282486_g222041_i0 PRJEB20058 224866 238 5.282486 12.57231668 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 202 2.01e-47   NTclustered gi|2107742610|gb|CP070837.1| 2035772 g222041 i0 86.813 18.7521008403361 182 23 76 1 12 193 127313 127493 MAG: Candidatus Omnitrophota bacterium isolate bin103 chromosome blastn 4463 202 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
25785535 25785535 PRJEB20058_P_NODE_115363_length_373_cov_15.288462_g112548_i0 PRJEB20058 115363 373 15.288462000000001 57.02596326 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 339 2.43e-88   NTclustered gi|2621701202|emb|OY759724.1| 2035772 g112548 i0 84.928 637.554959785523 345 41 90 8 4 337 2373032 2372688 MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1 blastn 237808 339 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
25790740 25790740 PRJEB20058_P_NODE_242539_length_210_cov_4.295302_g239714_i0 PRJEB20058 242539 210 4.295302 9.0201342 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 187 4.8399999999999984e-43   NTclustered gi|2621701202|emb|OY759724.1| 2035772 g239714 i0 83.173 1.6047619047619 208 32 98 3 1 206 2372193 2371987 MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1 blastn 337 187 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota 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);;