RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA900999", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Spirochaetota · 2 ✖

tax_kingdom 1

  • Pseudomonadati · 2 ✖

bioproject 1

  • PRJNA900999 · 2 ✖

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
4706715 4706715 PRJNA900999_S_NODE_3684_length_220_cov_11.685864_g3628_i0 PRJNA900999 3684 220 11.685864 25.7089008 uncultured Leptonema sp. 385247 Bacteria Bacteria 195 3.06e-45   NTclustered gi|1899225135|gb|MT967607.1| 385247 g3628 i0 82.883 600.822727272727 222 32 100 6 1 220 2076 1859 Uncultured Leptonema sp. clone asv_106_2346 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 132181 195 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Leptospirales Leptospiraceae Leptonema uncultured Leptonema sp.
27908375 27908375 PRJNA900999_S_NODE_2285_length_262_cov_7.806867_g2229_i0 PRJNA900999 2285 262 7.806867 20.45399154 Treponemataceae bacterium 2854022 Bacteria Bacteria 50.1 5.21e-5   NR GMO19290.1 2854022 g2229 i0 56.3 0.549618320610687 48 21 55 0 83 226 51 98 GMO19290.1 MAG: hypothetical protein Ta2A_26900 [Treponemataceae bacterium] diamond 144 50.1 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Treponemataceae   Treponemataceae 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);;