RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA971676", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA971676 · 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
18796395 18796395 PRJNA971676_P_NODE_17675_length_247_cov_0.885057_g17586_i0 PRJNA971676 17675 247 0.885057 2.18609079 Mycoplasmopsis felis 33923 Bacteria Bacteria 52.8 0.022   NTclustered gi|2695677594|gb|CP141029.2| 33923 g17586 i0 100 1.36032388663968 28 0 11 0 39 66 369999 370026 Mycoplasmopsis felis strain 11534 chromosome blastn 336 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis felis
21668768 21668768 PRJNA971676_P_NODE_20757_length_244_cov_0.900585_g20668_i0 PRJNA971676 20757 244 0.900585 2.1974274 root 1 Root_unresolved Root_unresolved 54.7 0.006   NTclustered gi|2860288300|gb|CP174167.1| 2125 g20668 i0 100 0.713114754098361 29 0 12 0 2 30 802718 802746 Metamycoplasma sualvi strain Mayfield chromosome, complete genome blastn 174 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma sualvi
27721433 27721433 PRJNA971676_P_NODE_12244_length_265_cov_1.333333_g12155_i0 PRJNA971676 12244 265 1.333333 3.53333245 Mycoplasma sp. SG1 2810348 Bacteria Bacteria 57.4 3.04e-7   NR WP_250328550.1 2810348 g12155 i0 44.4 2.71698113207547 72 35 81.5 3 260 45 132 198 WP_250328550.1 serine/threonine-protein kinase [Mycoplasma sp. SG1] diamond 720 57.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. SG1
31928720 31928720 PRJNA971676_P_NODE_12317_length_264_cov_1.612565_g12228_i0 PRJNA971676 12317 264 1.612565 4.2571716 Bacillati 1783272 Bacteria Bacteria 54.3 4.06e-6   NR MDD6403428.1 37628 g12228 i0 45.8 7.01136363636364 59 32 67 0 263 87 408 466 MDD6403428.1 ATP-binding protein [Mollicutes bacterium] diamond 1851 54.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium

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