RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA414225", 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

  • PRJNA414225 · 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
15110932 15110932 PRJNA414225_P_NODE_70752_length_164_cov_0.886957_g70665_i0 PRJNA414225 70752 164 0.886957 1.45460948 Mesomycoplasma 2923352 Bacteria Bacteria 303 3.42e-78   NTclustered gi|1720621726|gb|CP035041.1| 2100 g70665 i0 100 15 164 0 100 0 1 164 313274 313437 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2460 303 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
26617374 26617374 PRJNA414225_P_NODE_83161_length_162_cov_1.805310_g83074_i0 PRJNA414225 83161 162 1.80531 2.9246022 Bacillati 1783272 Bacteria Bacteria 64.3 2.98e-10   NR HHU56643.1 1898209 g83074 i0 57.7 1.94444444444444 52 22 96.3 0 2 157 195 246 HHU56643.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 315 64.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
26712091 26712091 PRJNA414225_P_NODE_71941_length_164_cov_0.886957_g71854_i0 PRJNA414225 71941 164 0.886957 1.45460948 Bacillati 1783272 Bacteria Bacteria 48.1 4.98e-5   NR HHY96860.1 33015 g71854 i0 42.6 1.97560975609756 54 30 97 1 6 164 40 93 HHY96860.1 hypothetical protein [Acholeplasma sp.] diamond 324 48.5 0.991752577319588 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
27043956 27043956 PRJNA414225_P_NODE_79902_length_163_cov_0.894737_g79815_i0 PRJNA414225 79902 163 0.894737 1.45842131 Mycoplasmopsis arginini 2094 Bacteria Bacteria 42 0.00846   NR WP_282459194.1 2094 g79815 i0 72.7 0.404907975460123 22 6 40.5 0 65 130 18 39 WP_282459194.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 66 42 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29191468 29191468 PRJNA414225_P_NODE_83309_length_162_cov_1.805310_g83222_i0 PRJNA414225 83309 162 1.80531 2.9246022 Tenericutes bacterium ADurb.BinA124 1852921 Bacteria Bacteria 81.6 9.25e-18   NR OPZ32375.1 1852921 g83222 i0 82.9 0.759259259259259 41 7 75.9 0 3 125 43 83 OPZ32375.1 MAG: hypothetical protein BWY97_01543 [Tenericutes bacterium ADurb.BinA124] diamond 123 81.6 1 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium ADurb.BinA124

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