RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA814235 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
27433898 27433898 PRJNA814235_P_NODE_53443_length_260_cov_6.560538_g52049_i0 PRJNA814235 53443 260 6.560538 17.0573988 Mycoplasmopsis arginini 2094 Bacteria Bacteria 47.4 5.5e-4   NR MDI3352151.1 2094 g52049 i0 95 0.230769230769231 20 1 23.1 0 18 77 8 27 MDI3352151.1 hypothetical protein [Mycoplasmopsis arginini] diamond 60 47.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27623293 27623293 PRJNA814235_P_NODE_197924_length_150_cov_3.690265_g196529_i0 PRJNA814235 197924 150 3.690265 5.5353975 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 55.1 4.53e-7   NR MCF7930077.1 1898209 g196529 i0 56.3 1.92 48 15 96 1 149 6 799 840 MCF7930077.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 288 55.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30465473 30465473 PRJNA814235_P_NODE_199573_length_150_cov_3.106195_g198178_i0 PRJNA814235 199573 150 3.106195 4.6592925 Acholeplasma sp. 33015 Bacteria Bacteria 50.8 1.17e-5   NR MFA7417534.1 33015 g198178 i0 71.4 1.38 42 1 62 1 4 96 87 128 MFA7417534.1 F0F1 ATP synthase subunit A [Acholeplasma sp.] diamond 207 50.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
31413190 31413190 PRJNA814235_P_NODE_105916_length_203_cov_2.192771_g104521_i0 PRJNA814235 105916 203 2.192771 4.45132513 Tenericutes bacterium HGW-Tenericutes-6 2013849 Bacteria Bacteria 72.4 4.94e-13   NR PKK93942.1 2013849 g104521 i0 56.6 1.12315270935961 76 22 96.1 1 8 202 109 184 PKK93942.1 MAG: hypothetical protein CVV61_01990 [Tenericutes bacterium HGW-Tenericutes-6] diamond 228 72.4 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium HGW-Tenericutes-6
31453713 31453713 PRJNA814235_P_NODE_88056_length_203_cov_4.156627_g86661_i0 PRJNA814235 88056 203 4.156627 8.43795281 Acholeplasma 2147 Bacteria Bacteria 54.3 1.49e-6   NR WIF88958.1 2148 g86661 i0 100 1.10837438423645 25 0 36.9 0 76 2 56 80 WIF88958.1 beta-ketoacyl-ACP synthase II [Acholeplasma laidlawii] diamond 225 54.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
31982494 31982494 PRJNA814235_P_NODE_190798_length_151_cov_2.956140_g189403_i0 PRJNA814235 190798 151 2.95614 4.4637714 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 88.6 4.93e-19   NR HHX75928.1 1898209 g189403 i0 88.2 1.01324503311258 51 5 99.3 1 151 2 338 388 HHX75928.1 ABC transporter ATP-binding protein [Acholeplasmataceae bacterium] diamond 153 88.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32835449 32835449 PRJNA814235_P_NODE_103660_length_203_cov_2.283133_g102265_i0 PRJNA814235 103660 203 2.283133 4.63475999 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 47 3.84e-4   NR MFA5470705.1 1898209 g102265 i0 100 0.369458128078818 25 0 36.9 0 129 203 62 86 MFA5470705.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 75 47 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32898408 32898408 PRJNA814235_P_NODE_180120_length_152_cov_4.669565_g178725_i0 PRJNA814235 180120 152 4.669565 7.0977388 Mycoplasmopsis arginini 2094 Bacteria Bacteria 47.4 8.36e-5   NR WP_282459165.1 2094 g178725 i0 68 0.986842105263158 25 8 49.3 0 141 67 1 25 WP_282459165.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 150 47.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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