RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA600413 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
30377960 30377960 PRJNA600413_P_NODE_21932_length_304_cov_1.792157_g21231_i0 PRJNA600413 21932 304 1.792157 5.44815728 Bacillati 1783272 Bacteria Bacteria 48.9 3.26e-4   NR WP_044635349.1 86660 g21231 i0 37.5 2.52631578947368 64 32 60.2 2 120 302 35 93 WP_044635349.1 adenylate kinase family protein [Mesomycoplasma dispar] diamond 768 48.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma dispar
31407269 31407269 PRJNA600413_P_NODE_41556_length_225_cov_0.869318_g40855_i0 PRJNA600413 41556 225 0.869318 1.9559655 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 106 5.74e-25   NR MCK9234807.1 1898209 g40855 i0 63.5 0.986666666666667 74 27 98.7 0 225 4 220 293 MCK9234807.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 222 106 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
32419534 32419534 PRJNA600413_P_NODE_114279_length_166_cov_0.871795_g113578_i0 PRJNA600413 114279 166 0.871795 1.4471797 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 96.3 1.8300000000000003e-21   NR HXN54441.1 2023991 g113578 i0 76.4 0.993975903614458 55 13 99.4 0 166 2 236 290 HXN54441.1 reverse transcriptase family protein [Mycoplasmatales bacterium] diamond 165 96.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales 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);;