RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA588137", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 7 ✖

tax_kingdom 1

  • Bacillati · 7 ✖

bioproject 1

  • PRJNA588137 · 7 ✖

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
3689975 3689975 PRJNA588137_S_NODE_9523_length_244_cov_0.900585_g9490_i0 PRJNA588137 9523 244 0.900585 2.1974274 Mesomycoplasma 2923352 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1450419971|emb|LS991950.1| 2100 g9490 i0 100 101.204918032787 244 0 100 0 1 244 524874 524631 Mycoplasma hyorhinis strain NCTC10130 genome assembly, chromosome: 1 blastn 24694 451 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
4966563 4966563 PRJNA588137_S_NODE_11344_length_241_cov_0.916667_g11311_i0 PRJNA588137 11344 241 0.916667 2.20916747 Mesomycoplasma 2923352 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|1720621726|gb|CP035041.1| 2100 g11311 i0 100 16.5435684647303 241 0 100 0 1 241 568258 568498 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3987 446 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
11341857 11341857 PRJNA588137_S_NODE_8309_length_247_cov_0.885057_g8276_i0 PRJNA588137 8309 247 0.885057 2.18609079 Mesomycoplasma 2923352 Bacteria Bacteria 457 4.05e-124   NTclustered gi|1720621726|gb|CP035041.1| 2100 g8276 i0 100 15.1174089068826 247 0 100 0 1 247 324811 324565 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3734 457 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15166575 15166575 PRJNA588137_S_NODE_4952_length_275_cov_0.930693_g4919_i0 PRJNA588137 4952 275 0.930693 2.55940575 Mesomycoplasma 2923352 Bacteria Bacteria 508 1.2499999999999999e-139   NTclustered gi|2713084492|gb|CP150431.1| 2100 g4919 i0 100 416.407272727273 275 0 100 0 1 275 304489 304215 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 114512 508 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
16441163 16441163 PRJNA588137_S_NODE_2493_length_340_cov_1.153558_g2460_i0 PRJNA588137 2493 340 1.153558 3.9220972 Mesomycoplasma 2923352 Bacteria Bacteria 628 1.1699999999999999e-175   NTclustered gi|1720621726|gb|CP035041.1| 2100 g2460 i0 100 15.9970588235294 340 0 100 0 1 340 496219 495880 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 5439 628 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18989840 18989840 PRJNA588137_S_NODE_3155_length_316_cov_0.950617_g3122_i0 PRJNA588137 3155 316 0.950617 3.00394972 Mesomycoplasma 2923352 Bacteria Bacteria 584 2.359999999999999e-162   NTclustered gi|1563681465|emb|LR214949.1| 2100 g3122 i0 100 18.9208860759494 316 0 100 0 1 316 69065 68750 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 5979 584 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
20264967 20264967 PRJNA588137_S_NODE_2836_length_327_cov_0.909449_g2803_i0 PRJNA588137 2836 327 0.909449 2.97389823 Mesomycoplasma 2923352 Bacteria Bacteria 604 1.8799999999999993e-168   NTclustered gi|1720621726|gb|CP035041.1| 2100 g2803 i0 100 16.0152905198777 327 0 100 0 1 327 504960 504634 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 5237 604 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);;