RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA289590", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 5 ✖

tax_kingdom 1

  • Bacillati · 5 ✖

bioproject 1

  • PRJNA289590 · 5 ✖

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
8025552 8025552 PRJNA289590_P_NODE_10607_length_283_cov_1.333333_g10383_i0 PRJNA289590 10607 283 1.333333 3.77333239 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 518 2.14e-142   NTclustered gi|307624329|gb|CP001995.1| 637387 g10383 i0 99.647 8.00706713780919 283 1 100 0 1 283 181267 181549 Mycoplasma fermentans JER, complete genome blastn 2266 518 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
9987562 9987562 PRJNA289590_P_NODE_27488_length_167_cov_0.881356_g27264_i0 PRJNA289590 27488 167 0.881356 1.47186452 Metamycoplasmataceae 2895623 Bacteria Bacteria 305 9.74e-79   NTclustered gi|1563788636|emb|LR214955.1| 2115 g27264 i0 100 4.94011976047904 165 0 99 0 3 167 470164 470000 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 1 blastn 825 305 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
15087067 15087067 PRJNA289590_P_NODE_7132_length_357_cov_1.915584_g6908_i0 PRJNA289590 7132 357 1.915584 6.83863488 Metamycoplasmataceae 2895623 Bacteria Bacteria 649 0   NTclustered gi|507148354|ref|NR_103157.1| 2115 g6908 i0 99.44 177.955182072829 357 2 100 0 1 357 896 1252 Mycoplasma fermentans strain JER 23S ribosomal RNA gene, complete sequence blastn 63530 649 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
20185395 20185395 PRJNA289590_P_NODE_10636_length_282_cov_2.815451_g10412_i0 PRJNA289590 10636 282 2.815451 7.93957182 Metamycoplasmataceae 2895623 Bacteria Bacteria 521 1.6499999999999996e-143   NTclustered gi|23451293|gb|AF422142.1| 2115 g10412 i0 100 173.45390070922 282 0 100 0 1 282 697 416 Mycoplasma fermentans 23S ribosomal RNA gene, domains IV and V, partial sequence blastn 48914 521 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
22736256 22736256 PRJNA289590_P_NODE_24158_length_177_cov_2.171875_g23934_i0 PRJNA289590 24158 177 2.171875 3.84421875 Metamycoplasmataceae 2895623 Bacteria Bacteria 322 1.03e-83   NTclustered gi|209552648|gb|FJ226561.1| 2115 g23934 i0 99.435 158.101694915254 177 1 100 0 1 177 1161 1337 Mycoplasma fermentans strain PG-18 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence blastn 27984 322 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans

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