RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA911178 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
11453785 11453785 PRJNA911178_P_NODE_224789_length_258_cov_2.470270_g222315_i0 PRJNA911178 224789 258 2.47027 6.3732966 Mycoplasmoidales 2790996 Bacteria Bacteria 327 3.48e-85   NTclustered gi|119369652|gb|EF061769.1| 2097 g222315 i0 90.4 118.34496124031 250 23 97 1 1 250 308 60 Mycoplasma genitalium strain ATCC 33530 23S ribosomal RNA gene, partial sequence blastn 30533 329 0.993920972644377 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides genitalium
16196446 16196446 PRJNA911178_P_NODE_88293_length_381_cov_0.987013_g85823_i0 PRJNA911178 88293 381 0.987013 3.76051953 Malacoplasma muris 2119 Bacteria Bacteria 544 4.92e-150   NTclustered gi|299851933|gb|HM135461.1| 2119 g85823 i0 92.612 124.010498687664 379 26 99 2 1 378 883 506 Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence blastn 47248 544 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma muris
22568524 22568524 PRJNA911178_P_NODE_121678_length_333_cov_1.173077_g119206_i0 PRJNA911178 121678 333 1.173077 3.90634641 uncultured Mycoplasma sp. 167967 Bacteria Bacteria 56.5 0.002   NTclustered gi|1775571725|gb|MN692881.1| 167967 g119206 i0 83.333 0.36036036036036 60 10 18 0 67 126 701 642 Uncultured Mycoplasma sp. clone 35a 23S ribosomal RNA gene, partial sequence blastn 120 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma uncultured Mycoplasma sp.
24201021 24201021 PRJNA911178_P_NODE_107199_length_351_cov_1.104317_g104727_i0 PRJNA911178 107199 351 1.104317 3.87615267 Mycoplasmoidales 2790996 Bacteria Bacteria 449 1.0099999999999998e-121   NTclustered gi|1563789200|emb|LR214962.1| 2115 g104727 i0 90.616 116.430199430199 341 29 97 3 13 351 358293 357954 Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 blastn 40867 449 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);;