RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA576995", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 9 ✖

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA576995 · 9 ✖

analysis 1

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
4965049 4965049 PRJNA576995_P_NODE_29184_length_282_cov_1.842105_g28592_i0 PRJNA576995 29184 282 1.842105 5.1947361 Mesomycoplasma 2923352 Bacteria Bacteria 521 1.6499999999999996e-143   NTclustered gi|1720621726|gb|CP035041.1| 2100 g28592 i0 100 16 282 0 100 0 1 282 799896 799615 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4512 521 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8213995 8213995 PRJNA576995_P_NODE_42387_length_242_cov_0.911243_g41795_i0 PRJNA576995 42387 242 0.911243 2.20520806 Mycoplasmopsis felis 33923 Bacteria Bacteria 52.8 0.022   NTclustered gi|2695677594|gb|CP141029.2| 33923 g41795 i0 100 1.85123966942149 28 0 12 0 213 240 103138 103111 Mycoplasmopsis felis strain 11534 chromosome blastn 448 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis felis
15165105 15165105 PRJNA576995_P_NODE_40952_length_244_cov_0.900585_g40360_i0 PRJNA576995 40952 244 0.900585 2.1974274 Mycoplasma 2093 Bacteria Bacteria 446 8.639999999999999e-121   NTclustered gi|54609775|gb|AY765214.1| 51364 g40360 i0 99.59 187 244 1 100 0 1 244 633 390 Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 45628 446 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
16439646 16439646 PRJNA576995_P_NODE_39753_length_246_cov_0.878613_g39161_i0 PRJNA576995 39753 246 0.878613 2.16138798 Mesomycoplasma 2923352 Bacteria Bacteria 444 3.14e-120   NTclustered gi|1720621726|gb|CP035041.1| 2100 g39161 i0 99.187 15.9878048780488 246 2 100 0 1 246 759264 759509 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3933 444 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19687292 19687292 PRJNA576995_P_NODE_35796_length_250_cov_0.870056_g35204_i0 PRJNA576995 35796 250 0.870056 2.17514 Mycoplasmopsis arginini 2094 Bacteria Bacteria 446 8.89e-121   NTclustered gi|2668342370|gb|CP143577.1| 2094 g35204 i0 98.8 4 250 3 100 0 1 250 366239 366488 Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome blastn 1000 446 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
20263494 20263494 PRJNA576995_P_NODE_43216_length_241_cov_0.916667_g42624_i0 PRJNA576995 43216 241 0.916667 2.20916747 Mollicutes 31969 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|281186773|gb|GU227378.1| 2100 g42624 i0 100 100.995850622407 241 0 100 0 1 241 1184 944 Mycoplasma hyorhinis strain USP36P 16S ribosomal RNA gene, partial sequence blastn 24340 446 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
21538939 21538939 PRJNA576995_P_NODE_40777_length_244_cov_0.900585_g40185_i0 PRJNA576995 40777 244 0.900585 2.1974274 Mesomycoplasma 2923352 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1720621726|gb|CP035041.1| 2100 g40185 i0 100 15 244 0 100 0 1 244 680065 679822 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3660 451 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
22814194 22814194 PRJNA576995_P_NODE_42498_length_242_cov_0.911243_g41906_i0 PRJNA576995 42498 242 0.911243 2.20520806 Mesomycoplasma 2923352 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|1720621726|gb|CP035041.1| 2100 g41906 i0 100 15.9834710743802 242 0 100 0 1 242 444720 444961 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3868 448 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
24088847 24088847 PRJNA576995_P_NODE_1039_length_1456_cov_1.916847_g847_i0 PRJNA576995 1039 1456 1.916847 27.90929232 Mesomycoplasma 2923352 Bacteria Bacteria 2687 0   NTclustered gi|1563681465|emb|LR214949.1| 2100 g847 i0 100 16.0762362637363 1455 0 99 0 1 1455 648074 646620 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 23407 2687 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis

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