RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA914897 · 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
4723414 4723414 PRJNA914897_P_NODE_27284_length_308_cov_1.310638_g26860_i0 PRJNA914897 27284 308 1.310638 4.03676504 Bacillati 1783272 Bacteria Bacteria 84 1.81e-16   NR OHE35454.1 1802350 g26860 i0 55.9 9.92532467532468 59 26 57.5 0 188 12 57 115 OHE35454.1 MAG: malate dehydrogenase [Tenericutes bacterium GWE2_38_8] diamond 3057 84.7 0.991735537190083 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium GWE2_38_8
27821832 27821832 PRJNA914897_P_NODE_34884_length_260_cov_1.235294_g34460_i0 PRJNA914897 34884 260 1.235294 3.2117644 Bacillati 1783272 Bacteria Bacteria 44.3 0.0121   NR OHE24823.1 1802344 g34460 i0 36.1 1.66153846153846 72 43 80.8 3 220 11 108 178 OHE24823.1 MAG: hypothetical protein A2Z84_04860 [Tenericutes bacterium GWA2_35_7] diamond 432 44.3 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium GWA2_35_7
30341006 30341006 PRJNA914897_P_NODE_10252_length_587_cov_2.107004_g9835_i0 PRJNA914897 10252 587 2.107004 12.36811348 Acholeplasma oculi 35623 Bacteria Bacteria 298 3.05e-100   NR WP_045749762.1 35623 g9835 i0 78.8 0.965928449744463 189 40 96.6 0 20 586 14 202 WP_045749762.1 uracil phosphoribosyltransferase [Acholeplasma oculi] diamond 567 298 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma oculi

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