RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB66218 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28486896 28486896 PRJEB66218_P_NODE_241167_length_202_cov_0.921986_g238736_i0 PRJEB66218 241167 202 0.921986 1.86241172 Acholeplasma granularum 264635 Bacteria Bacteria 54.7 1.19e-6   NR WP_025725131.1 264635 g238736 i0 51.1 0.698019801980198 47 23 69.8 0 143 3 233 279 WP_025725131.1 ribosome small subunit-dependent GTPase A [Acholeplasma granularum] diamond 141 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma granularum
30287133 30287133 PRJEB66218_P_NODE_116092_length_280_cov_1.794521_g113663_i0 PRJEB66218 116092 280 1.794521 5.0246588 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 84.7 4.47e-17   NR MBR4496985.1 2053494 g113663 i0 46.6 3.71785714285714 88 45 92.1 1 258 1 139 226 MBR4496985.1 annexin [Acholeplasmatales bacterium] diamond 1041 84.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
31993783 31993783 PRJEB66218_P_NODE_133218_length_258_cov_1.700508_g130789_i0 PRJEB66218 133218 258 1.700508 4.38731064 Mollicutes bacterium 37628 Bacteria Bacteria 46.6 0.00105   NR NLL44599.1 37628 g130789 i0 42.1 1.55813953488372 76 43 87.2 1 29 253 2 77 NLL44599.1 translation initiation factor IF-3 [Mollicutes bacterium] diamond 402 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
32500326 32500326 PRJEB66218_P_NODE_213059_length_208_cov_0.884354_g210629_i0 PRJEB66218 213059 208 0.884354 1.83945632 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 42 0.0464   NR QWB99420.1 2231116 g210629 i0 35.2 1.02403846153846 71 42 98.1 2 207 4 122 191 QWB99420.1 DUF5011 domain-containing protein [Mycoplasmatota bacterium] diamond 213 42 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota 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);;