RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA474426" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474426 · 9 ✖

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
6825080 6825080 PRJNA474426_P_NODE_28666_length_180_cov_1.534351_g28461_i0 PRJNA474426 28666 180 1.534351 2.7618318 Mycoplasmopsis arginini 2094 Bacteria Bacteria 327 2.2699999999999996e-85   NTclustered gi|2668342370|gb|CP143577.1| 2094 g28461 i0 99.444 154.033333333333 180 1 100 0 1 180 371197 371018 Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome blastn 27726 327 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
27424142 27424142 PRJNA474426_P_NODE_23583_length_202_cov_2.078431_g23378_i0 PRJNA474426 23583 202 2.078431 4.19843062 Mycoplasmopsis arginini 2094 Bacteria Bacteria 111 3.03e-29   NR WP_282460216.1 2094 g23378 i0 96.9 0.965346534653465 65 2 96.5 0 195 1 33 97 WP_282460216.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 195 111 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28023907 28023907 PRJNA474426_P_NODE_22285_length_210_cov_0.788820_g22080_i0 PRJNA474426 22285 210 0.78882 1.656522 Mycoplasmopsis arginini 2094 Bacteria Bacteria 96.3 2.4199999999999998e-24   NR MDI3349122.1 2094 g22080 i0 90 0.714285714285714 50 5 71.4 0 151 2 3 52 MDI3349122.1 hypothetical protein [Mycoplasmopsis arginini] diamond 150 96.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28276271 28276271 PRJNA474426_P_NODE_4726_length_492_cov_5.984199_g4532_i0 PRJNA474426 4726 492 5.984199 29.44225908 Mycoplasmopsis arginini 2094 Bacteria Bacteria 181 1.3399999999999998e-55   NR WP_282460087.1 2094 g4532 i0 100 0.542682926829268 89 0 54.3 0 477 211 44 132 WP_282460087.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 267 181 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29760234 29760234 PRJNA474426_P_NODE_19331_length_228_cov_1.508380_g19126_i0 PRJNA474426 19331 228 1.50838 3.4391064 Mycoplasmopsis arginini 2094 Bacteria Bacteria 61.6 3.66e-9   NR WP_282460166.1 2094 g19126 i0 96.6 0.381578947368421 29 1 38.2 0 138 224 1 29 WP_282460166.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 87 61.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29823302 29823302 PRJNA474426_P_NODE_13671_length_283_cov_1.867521_g13466_i0 PRJNA474426 13671 283 1.867521 5.28508443 Mycoplasmopsis arginini 2094 Bacteria Bacteria 45.1 0.00149   NR WP_282460039.1 2094 g13466 i0 100 0.212014134275618 20 0 21.2 0 27 86 74 93 WP_282460039.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 60 45.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
30518591 30518591 PRJNA474426_P_NODE_8993_length_360_cov_2.440514_g8788_i0 PRJNA474426 8993 360 2.440514 8.7858504 Mycoplasmopsis arginini 2094 Bacteria Bacteria 102 1.97e-25   NR WP_282459024.1 2094 g8788 i0 96.2 0.441666666666667 53 2 44.2 0 10 168 72 124 WP_282459024.1 YqaJ viral recombinase family protein, partial [Mycoplasmopsis arginini] diamond 159 102 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31087321 31087321 PRJNA474426_P_NODE_30795_length_172_cov_1.609756_g30590_i0 PRJNA474426 30795 172 1.609756 2.76878032 Mycoplasmopsis arginini 2094 Bacteria Bacteria 66.2 8.79e-12   NR WP_282460155.1 2094 g30590 i0 100 0.575581395348837 33 0 57.6 0 74 172 1 33 WP_282460155.1 glycoside hydrolase family 19 protein, partial [Mycoplasmopsis arginini] diamond 99 66.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31466890 31466890 PRJNA474426_P_NODE_18616_length_233_cov_2.538043_g18411_i0 PRJNA474426 18616 233 2.538043 5.91364019 Mycoplasmopsis arginini 2094 Bacteria Bacteria 43.9 0.00398   NR WP_282460054.1 2094 g18411 i0 94.4 0.231759656652361 18 1 23.2 0 159 212 1 18 WP_282460054.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 54 43.9 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);;