RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA283169", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA283169 · 4 ✖

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
28102348 28102348 PRJNA283169_S_NODE_3345_length_163_cov_0.157895_g3331_i0 PRJNA283169 3345 163 0.157895 0.25736885 Bacteria 2 Bacteria Bacteria 97.4 2.82e-23   NR ARU39840.1 2004467 g3331 i0 90.6 1.95092024539877 53 5 97.5 0 161 3 59 111 ARU39840.1 ribonuclease III [Armatimonadetes bacterium Uphvl-Ar1] diamond 318 97.4 1 Bacteria   Bacillati Armatimonadota         Armatimonadetes bacterium Uphvl-Ar1
30611108 30611108 PRJNA283169_P_NODE_6513_length_169_cov_0.866667_g6450_i0 PRJNA283169 6513 169 0.866667 1.46466723 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 96.7 6.17e-24   NR MFM9872155.1 2682144 g6450 i0 92.3 0.923076923076923 52 4 92.3 0 157 2 54 105 MFM9872155.1 single-stranded DNA-binding protein [Fimbriimonadaceae bacterium] diamond 156 96.7 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
30863922 30863922 PRJNA283169_S_NODE_1174_length_249_cov_0.110000_g1160_i0 PRJNA283169 1174 249 0.11 0.2739 Armatimonadetes bacterium CG_4_1 2033014 Bacteria Bacteria 169 7.259999999999999e-48   NR PIY44557.1 1973909 g1160 i0 100 0.987951807228916 82 0 98.8 0 247 2 60 141 PIY44557.1 MAG: hypothetical protein COZ05_07900 [Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10] diamond 246 169 1 Bacteria   Bacillati Armatimonadota         Armatimonadetes bacterium CG_4_10_14_3_um_filter_59_10
32477136 32477136 PRJNA283169_P_NODE_5919_length_176_cov_1.204724_g5856_i0 PRJNA283169 5919 176 1.204724 2.12031424 Armatimonadota bacterium 2033014 Bacteria Bacteria 53.1 3.27e-7   NR MES2461911.1 2033014 g5856 i0 50 0.75 44 22 75 0 132 1 30 73 MES2461911.1 hypothetical protein [Armatimonadota bacterium] diamond 132 53.1 1 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);;