RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA716463", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA716463 · 5 ✖

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
708319 708319 PRJNA716463_P_NODE_68241_length_277_cov_3.906863_g67824_i0 PRJNA716463 68241 277 3.906863 10.82201051 Bacillati 1783272 Bacteria Bacteria 120 2.7099999999999995e-31   NR WP_004429330.1 51365 g67824 i0 66.7 4.76534296028881 87 29 94.2 0 6 266 134 220 WP_004429330.1 triose-phosphate isomerase [Mycoplasma yeatsii] diamond 1320 120 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
14736238 14736238 PRJNA716463_P_NODE_112292_length_241_cov_0.916667_g111874_i0 PRJNA716463 112292 241 0.916667 2.20916747 Acholeplasma palmae 38986 Bacteria Bacteria 189 1.58e-43   NTclustered gi|549140838|emb|FO681347.1| 1318466 g111874 i0 88.462 505.219917012448 156 18 65 0 86 241 299219 299374 complete chromosome Acholeplasma palmae blastn 121758 189 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma palmae
19834884 19834884 PRJNA716463_P_NODE_44136_length_295_cov_4.734234_g43719_i0 PRJNA716463 44136 295 4.734234 13.9659903 uncultured Anaeroplasmataceae bacterium 658266 Bacteria Bacteria 501 2.259999999999999e-137   NTclustered gi|254211954|gb|GQ358430.1| 658266 g43719 i0 97.288 100.664406779661 295 8 100 0 1 295 10 304 Uncultured Anaeroplasmataceae bacterium clone SHTP408 16S ribosomal RNA gene, partial sequence blastn 29696 501 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae   uncultured Anaeroplasmataceae bacterium
21111123 21111123 PRJNA716463_P_NODE_78777_length_269_cov_3.362245_g78360_i0 PRJNA716463 78777 269 3.362245 9.04443905 Metamycoplasma orale 2121 Bacteria Bacteria 470 5.74e-128   NTclustered gi|1563679895|emb|LR214940.1| 2121 g78360 i0 98.141 1 269 5 100 0 1 269 242518 242786 Mycoplasma orale strain NCTC10112 genome assembly, chromosome: 1 blastn 269 470 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma orale
31284209 31284209 PRJNA716463_P_NODE_1935_length_660_cov_6.090290_g1570_i0 PRJNA716463 1935 660 6.09029 40.195914 Mycoplasmopsis arginini 2094 Bacteria Bacteria 298 5.179999999999999e-95   NR WP_206602619.1 2094 g1570 i0 90.1 13.1636363636364 161 16 73.2 0 11 493 321 481 WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] diamond 8688 298 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);;