RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA884104" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA884104 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
5964440 5964440 PRJNA884104_S_NODE_61225_length_267_cov_1.190722_g60482_i0 PRJNA884104 61225 267 1.190722 3.17922774 Bacteria 2 Bacteria Bacteria 138 1.09e-36   NR MCD4826324.1 1898209 g60482 i0 79.8 6.68539325842697 84 17 94.4 0 264 13 108 191 MCD4826324.1 xylose isomerase [Acholeplasmataceae bacterium] diamond 1785 138 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
26928904 26928904 PRJNA884104_S_NODE_75882_length_247_cov_0.885057_g75139_i0 PRJNA884104 75882 247 0.885057 2.18609079 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 62.4 4.38e-9   NR MCR5112743.1 2053494 g75139 i0 41.9 0.753036437246964 62 36 75.3 0 245 60 329 390 MCR5112743.1 hypothetical protein [Acholeplasmatales bacterium] diamond 186 62.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
28697804 28697804 PRJNA884104_S_NODE_59987_length_270_cov_1.147208_g59244_i0 PRJNA884104 59987 270 1.147208 3.0974616 Mycoplasma buteonis 171280 Bacteria Bacteria 43.1 0.0399   NR WP_036453040.1 171280 g59244 i0 31.3 0.922222222222222 83 53 88.9 2 270 31 1086 1167 WP_036453040.1 FtsX-like permease family protein, partial [Mycoplasma buteonis] diamond 249 43.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma buteonis
30055293 30055293 PRJNA884104_S_NODE_72411_length_249_cov_0.875000_g71668_i0 PRJNA884104 72411 249 0.875 2.17875 Spiroplasma chrysopicola 216933 Bacteria Bacteria 78.6 9.7e-15   NR WP_016339049.1 216933 g71668 i0 51.9 5.80722891566265 81 33 97.6 1 247 5 610 684 WP_016339049.1 isoleucine--tRNA ligase [Spiroplasma chrysopicola] diamond 1446 78.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma chrysopicola
30497853 30497853 PRJNA884104_S_NODE_78953_length_245_cov_0.895349_g78210_i0 PRJNA884104 78953 245 0.895349 2.19360505 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 60.1 2.9e-8   NR MBR4495755.1 2053494 g78210 i0 54.8 1.3469387755102 62 27 74.7 1 56 238 12 73 MBR4495755.1 hypothetical protein [Acholeplasmatales bacterium] diamond 330 60.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
31287600 31287600 PRJNA884104_S_NODE_51995_length_290_cov_1.419355_g51252_i0 PRJNA884104 51995 290 1.419355 4.1161295 Spiroplasma ixodetis 2141 Bacteria Bacteria 76.6 1.2e-15   NR WP_281748395.1 2141 g51252 i0 37.3 1.81034482758621 83 50 85.9 1 290 42 8 88 WP_281748395.1 thioredoxin [Spiroplasma ixodetis] diamond 525 76.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma ixodetis
32300419 32300419 PRJNA884104_S_NODE_61679_length_266_cov_1.160622_g60936_i0 PRJNA884104 61679 266 1.160622 3.08725452 Mollicutes bacterium PWAP 2885760 Bacteria Bacteria 53.1 4.27e-6   NR MBX4209690.1 2885760 g60936 i0 72.7 2.23308270676692 33 9 37.2 0 142 44 2 34 MBX4209690.1 adenylate kinase [Mollicutes bacterium PWAP] diamond 594 53.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium PWAP

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