RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 3 ✖

bioproject 1

  • PRJNA690592 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 0

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
671242 671242 PRJNA690592_S_NODE_179401_length_255_cov_1.527473_g178387_i0 PRJNA690592 179401 255 1.527473 3.89505615 uncultured Candidatus Binatia bacterium 3036252 Bacteria Bacteria 65.8 2.98e-6   NTclustered gi|2546137839|emb|OY282432.1| 3036252 g178387 i0 100 0.137254901960784 35 0 14 0 25 59 2719579 2719545 MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1 blastn 35 65.8 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       uncultured Candidatus Binatia bacterium
9600417 9600417 PRJNA690592_S_NODE_72828_length_374_cov_1.172757_g71814_i0 PRJNA690592 72828 374 1.172757 4.38611118 candidate division WOR-3 bacterium 2052148 Bacteria Bacteria 60.2 2.13e-4   NTclustered gi|2108202650|gb|CP070705.1| 2052148 g71814 i0 100 8.29144385026738 32 0 9 0 238 269 1742701 1742670 MAG: candidate division WOR-3 bacterium isolate bin53 chromosome blastn 3101 60.2 1 Bacteria Bacteria candidate phyla   candidate division WOR-3         candidate division WOR-3 bacterium
9600601 9600601 PRJNA690592_S_NODE_99928_length_328_cov_0.905882_g98914_i0 PRJNA690592 99928 328 0.905882 2.97129296 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 52.8 0.031   NTclustered gi|2874253743|emb|OY969586.1| 2052149 g98914 i0 100 0.0853658536585366 28 0 9 0 73 100 506955 506982 MAG: Candidatus Aminicenantes bacterium isolate MFD10007.bin.c.2 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes 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);;