RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA773247" 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

  • PRJNA773247 · 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
17327050 17327050 PRJNA773247_P_NODE_13294_length_414_cov_8.096774_g13210_i0 PRJNA773247 13294 414 8.096774 33.52064436 unclassified Spiroplasma 2637901 Bacteria Bacteria 117 1.33e-28   NR WP_249728355.1 2637901 g13210 i0 47.8 5 138 53 99.3 6 2 412 56 175 WP_249728355.1 MULTISPECIES: GMP reductase [unclassified Spiroplasma] diamond 2070 117 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma  
28001096 28001096 PRJNA773247_P_NODE_28565_length_259_cov_4.145161_g28481_i0 PRJNA773247 28565 259 4.145161 10.73596699 Tenericutes bacterium ADurb.BinA155 1852922 Bacteria Bacteria 48.1 5.43e-4   NR OPZ32272.1 1852922 g28481 i0 47.2 2.38610038610039 53 28 61.4 0 49 207 293 345 OPZ32272.1 MAG: hypothetical protein BWY98_01358 [Tenericutes bacterium ADurb.BinA155] diamond 618 48.1 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.BinA155
28010650 28010650 PRJNA773247_P_NODE_20145_length_319_cov_3.126016_g20061_i0 PRJNA773247 20145 319 3.126016 9.97199104 Bacillati 1783272 Bacteria Bacteria 146 5.31e-40   NR HHT82535.1 1898209 g20061 i0 66.7 9.59247648902821 102 34 95.9 0 5 310 30 131 HHT82535.1 ribonucleotide-diphosphate reductase subunit alpha [Acholeplasmataceae bacterium] diamond 3060 147 0.993197278911565 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28357568 28357568 PRJNA773247_P_NODE_13286_length_414_cov_9.850440_g13202_i0 PRJNA773247 13286 414 9.85044 40.7808216 PVC group 1783257 Bacteria Bacteria 211 2.96e-63   NR HHX81268.1 1898209 g13202 i0 74.8 1.78260869565217 123 31 89.1 0 377 9 142 264 HHX81268.1 ParB N-terminal domain-containing protein [Acholeplasmataceae bacterium] diamond 738 213 0.990610328638498 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29778483 29778483 PRJNA773247_P_NODE_36991_length_213_cov_5.864286_g36907_i0 PRJNA773247 36991 213 5.864286 12.49092918 PVC group 1783257 Bacteria Bacteria 141 5.89e-38   NR HHX81268.1 1898209 g36907 i0 82.9 2.94366197183099 70 12 98.6 0 213 4 192 261 HHX81268.1 ParB N-terminal domain-containing protein [Acholeplasmataceae bacterium] diamond 627 142 0.992957746478873 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31760008 31760008 PRJNA773247_P_NODE_10077_length_495_cov_10.457346_g9994_i0 PRJNA773247 10077 495 10.457346 51.7638627 Mesomycoplasma ovipneumoniae 29562 Bacteria Bacteria 191 2.59e-59   NR WP_337892750.1 29562 g9994 i0 82.6 0.660606060606061 109 19 66.1 0 169 495 1 109 WP_337892750.1 phage portal protein, partial [Mesomycoplasma ovipneumoniae] diamond 327 191 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma ovipneumoniae
32487919 32487919 PRJNA773247_P_NODE_13919_length_402_cov_5.902736_g13835_i0 PRJNA773247 13919 402 5.902736 23.72899872 Mycoplasmopsis arginini 2094 Bacteria Bacteria 124 8.99e-34   NR MDI3348893.1 2094 g13835 i0 64.4 0.753731343283582 101 31 72.4 4 355 65 1 100 MDI3348893.1 hypothetical protein [Mycoplasmopsis arginini] diamond 303 124 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);;