RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA657343" 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 · 2 ✖

bioproject 1

  • PRJNA657343 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
8276722 8276722 PRJNA657343_S_NODE_13467_length_247_cov_3.070707_g13442_i0 PRJNA657343 13467 247 3.070707 7.58464629 Candidatus Nomurabacteria bacterium 2052152 Bacteria Bacteria 342 1.1799999999999997e-89   NTclustered gi|2258875662|gb|CP060232.1| 2052152 g13442 i0 94.57 81.1336032388664 221 12 89 0 24 244 964628 964848 MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome blastn 20040 342 1 Bacteria Bacteria candidate phyla   Candidatus Nomuraibacteriota         Candidatus Nomurabacteria bacterium
22300417 22300417 PRJNA657343_P_NODE_40658_length_165_cov_0.896552_g40634_i0 PRJNA657343 40658 165 0.896552 1.4793108 Candidatus Mycosynbacter amalyticus 2665156 Bacteria Bacteria 291 2.69e-74   NTclustered gi|1799615131|gb|CP045921.1| 2665156 g40634 i0 99.375 133.345454545455 160 1 97 0 3 162 222074 222233 Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome blastn 22002 291 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota       Candidatus Mycosynbacter Candidatus Mycosynbacter amalyticus

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);;