RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA994052 · 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
12456043 12456043 PRJNA994052_P_NODE_81170_length_199_cov_58.777778_g79913_i0 PRJNA994052 81170 199 58.777778 116.96777822 Acholeplasma laidlawii 2148 Bacteria Bacteria 344 2.5399999999999993e-90   NTclustered gi|2513807229|gb|CP126461.1| 2148 g79913 i0 99.471 144.934673366834 189 1 95 0 11 199 1154933 1155121 Acholeplasma laidlawii strain 8195 chromosome, complete genome blastn 28842 344 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma laidlawii
28447882 28447882 PRJNA994052_P_NODE_77946_length_203_cov_14.030769_g76689_i0 PRJNA994052 77946 203 14.030769 28.48246107 Mycoplasmopsis arginini 2094 Bacteria Bacteria 45.4 0.00145   NR MDI3349153.1 2094 g76689 i0 70 0.827586206896552 30 9 44.3 0 92 3 1 30 MDI3349153.1 hypothetical protein [Mycoplasmopsis arginini] diamond 168 45.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28921141 28921141 PRJNA994052_P_NODE_37908_length_263_cov_12.063158_g36662_i0 PRJNA994052 37908 263 12.063158 31.72610554 Mycoplasmopsis arginini 2094 Bacteria Bacteria 43.9 0.00702   NR WP_282459165.1 2094 g36662 i0 89.5 0.216730038022814 19 2 21.7 0 102 158 5 23 WP_282459165.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 57 43.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31796273 31796273 PRJNA994052_P_NODE_64977_length_219_cov_13.116438_g63721_i0 PRJNA994052 64977 219 13.116438 28.72499922 Mycoplasmopsis arginini 2094 Bacteria Bacteria 45.1 0.00194   NR MDI3352183.1 2094 g63721 i0 73.1 0.356164383561644 26 7 35.6 0 172 95 14 39 MDI3352183.1 hypothetical protein [Mycoplasmopsis arginini] diamond 78 45.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32524516 32524516 PRJNA994052_P_NODE_73499_length_208_cov_28.977778_g72243_i0 PRJNA994052 73499 208 28.977778 60.27377824 Mycoplasmopsis arginini 2094 Bacteria Bacteria 42 0.0109   NR MDI3350086.1 2094 g72243 i0 77.3 0.317307692307692 22 5 31.7 0 7 72 74 95 MDI3350086.1 hypothetical protein [Mycoplasmopsis arginini] diamond 66 42 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

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