RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA849822 · 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
19965053 19965053 PRJNA849822_P_NODE_26396_length_283_cov_1.676190_g26222_i0 PRJNA849822 26396 283 1.67619 4.7436177 FCB group 1783270 Bacteria Bacteria 132 5.28e-36   NR KFZ26698.1 1541960 g26222 i0 62 10.5901060070671 92 35 97.5 0 282 7 39 130 KFZ26698.1 MAG: Uracil-DNA glycosylase [Candidatus Izimaplasma bacterium HR2] diamond 2997 132 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR2
29107690 29107690 PRJNA849822_P_NODE_21988_length_309_cov_1.322034_g21814_i0 PRJNA849822 21988 309 1.322034 4.08508506 Spiroplasma ixodetis 2141 Bacteria Bacteria 57.8 4.38e-7   NR MBP1526520.1 2141 g21814 i0 60.9 0.893203883495146 46 18 44.7 0 309 172 303 348 MBP1526520.1 AAA family ATPase [Spiroplasma ixodetis] diamond 276 57.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma ixodetis
29526399 29526399 PRJNA849822_P_NODE_23390_length_299_cov_2.070796_g23216_i0 PRJNA849822 23390 299 2.070796 6.19168004 Bacteria 2 Bacteria Bacteria 43.1 0.00953   NR WP_096862579.1 138853 g23216 i0 45.8 1.05351170568562 59 30 57.2 1 171 1 2 60 WP_096862579.1 HU family DNA-binding protein [Mesoplasma lactucae] diamond 315 43.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma lactucae
30726659 30726659 PRJNA849822_P_NODE_41134_length_244_cov_0.912281_g40960_i0 PRJNA849822 41134 244 0.912281 2.22596564 Bacillati 1783272 Bacteria Bacteria 63.5 1.04e-9   NR MFA6800753.1 1898209 g40960 i0 47.8 3.45491803278689 69 33 84.8 1 243 37 194 259 MFA6800753.1 lysophospholipase [Acholeplasmataceae bacterium] diamond 843 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae 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);;