RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1188114", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA1188114 · 5 ✖

analysis 1

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
18171660 18171660 PRJNA1188114_P_NODE_8575_length_181_cov_1.734848_g8523_i0 PRJNA1188114 8575 181 1.734848 3.14007488 Chthonomonadaceae bacterium 2739509 Bacteria Bacteria 71.2 1.39e-12   NR MBC7529807.1 2739509 g8523 i0 63.3 0.812154696132597 49 18 81.2 0 153 7 81 129 MBC7529807.1 esterase-like activity of phytase family protein [Chthonomonadaceae bacterium] diamond 147 71.2 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae   Chthonomonadaceae bacterium
21996762 21996762 PRJNA1188114_P_NODE_7218_length_187_cov_0.898551_g7166_i0 PRJNA1188114 7218 187 0.898551 1.68029037 Chthonomonadales bacterium 2282151 Bacteria Bacteria 97.4 2.75e-22   NR MEP6755171.1 2282151 g7166 i0 75.4 1.9572192513369 61 15 97.9 0 187 5 268 328 MEP6755171.1 D-2-hydroxyacid dehydrogenase [Chthonomonadales bacterium] diamond 366 97.4 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales     Chthonomonadales bacterium
27944278 27944278 PRJNA1188114_P_NODE_16685_length_163_cov_0.894737_g16633_i0 PRJNA1188114 16685 163 0.894737 1.45842131 Bacteria 2 Bacteria Bacteria 86.7 3.94e-18   NR MBC8138307.1 2033014 g16633 i0 77.4 1.95092024539877 53 12 97.5 0 3 161 343 395 MBC8138307.1 hypothetical protein [Armatimonadota bacterium] diamond 318 86.7 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
28272316 28272316 PRJNA1188114_P_NODE_19286_length_161_cov_0.910714_g19234_i0 PRJNA1188114 19286 161 0.910714 1.46624954 Chthonomonadaceae bacterium 2739509 Bacteria Bacteria 65.5 7.71e-11   NR HZP80689.1 2739509 g19234 i0 60 0.93167701863354 50 20 93.2 0 151 2 118 167 HZP80689.1 radical SAM protein [Chthonomonadaceae bacterium] diamond 150 65.5 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae   Chthonomonadaceae bacterium
31905597 31905597 PRJNA1188114_P_NODE_15057_length_165_cov_0.879310_g15005_i0 PRJNA1188114 15057 165 0.87931 1.4508615 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 77.8 5.37e-15   NR HTQ11776.1 2682144 g15005 i0 65.4 1.92727272727273 52 18 94.5 0 157 2 17 68 HTQ11776.1 FHA domain-containing protein [Fimbriimonadaceae bacterium] diamond 318 77.8 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae 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);;