RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB12366", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12366 · 4 ✖

tax_clade 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
11188993 11188993 PRJEB12366_S_NODE_509_length_240_cov_4.931707_g501_i0 PRJEB12366 509 240 4.931707 11.8360968 Chthonomonas 1077265 Bacteria Bacteria 207 4.35e-49   NTclustered gi|526641997|ref|NR_103994.1| 454171 g501 i0 85.096 218.045833333333 208 25 85 6 13 216 1753 1548 Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence blastn 52331 207 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae Chthonomonas Chthonomonas calidirosea
23938013 23938013 PRJEB12366_S_NODE_879_length_216_cov_1.895028_g871_i0 PRJEB12366 879 216 1.895028 4.09326048 Chthonomonas 1077265 Bacteria Bacteria 274 3.74e-69   NTclustered gi|526641997|ref|NR_103994.1| 454171 g871 i0 93.478 227.282407407407 184 12 85 0 33 216 2121 1938 Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence blastn 49093 274 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae Chthonomonas Chthonomonas calidirosea
25211734 25211734 PRJEB12366_S_NODE_4340_length_150_cov_1.165217_g4332_i0 PRJEB12366 4340 150 1.165217 1.7478255 Chthonomonas 1077265 Bacteria Bacteria 171 3.23e-38   NTclustered gi|526641997|ref|NR_103994.1| 454171 g4332 i0 88.194 9.66 144 16 95 1 8 150 2802 2659 Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence blastn 1449 171 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae Chthonomonas Chthonomonas calidirosea
31100792 31100792 PRJEB12366_P_NODE_12975_length_202_cov_1.437126_g12785_i0 PRJEB12366 12975 202 1.437126 2.90299452 Bacteria 2 Bacteria Bacteria 126 6.03e-32   NR MDQ3815802.1 2033014 g12785 i0 83.6 1.99009900990099 67 11 99.5 0 201 1 187 253 MDQ3815802.1 alginate lyase family protein [Armatimonadota bacterium] diamond 402 127 0.992125984251969 Bacteria   Bacillati Armatimonadota         Armatimonadota 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);;