RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB6054" 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

  • PRJEB6054 · 4 ✖

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
26067127 26067127 PRJEB6054_S_NODE_10253_length_175_cov_4.385714_g10164_i0 PRJEB6054 10253 175 4.385714 7.6749995 Mesomycoplasma flocculare ATCC 27399 743971 Bacteria Bacteria 54.7 0.004   NTclustered gi|111607539|gb|DQ847423.1| 743971 g10164 i0 100 0.497142857142857 29 0 17 0 1 29 739 711 Mycoplasma flocculare strain Ms42 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 87 54.7 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma flocculare
26067232 26067232 PRJEB6054_S_NODE_1957_length_307_cov_48.735294_g1868_i0 PRJEB6054 1957 307 48.735294 149.61735258 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 243 1.58e-59   NTclustered gi|2187163482|emb|OV788640.1| 658143 g1868 i0 81.849 403.449511400651 292 50 95 3 1 291 373761 373472 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 123859 243 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
26160069 26160069 PRJEB6054_S_NODE_3293_length_257_cov_2.887387_g3204_i0 PRJEB6054 3293 257 2.887387 7.42058459 Bacillati 1783272 Bacteria Bacteria 222 1.68e-53   NTclustered gi|971185387|gb|CP013128.1| 1749074 g3204 i0 88.235 514.848249027237 187 21 73 1 40 226 161422 161237 Mycoplasma sp. (ex Biomphalaria glabrata) isolate Barreiro1 chromosome, complete genome blastn 132316 224 0.991071428571429 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. (ex Biomphalaria glabrata)
26203565 26203565 PRJEB6054_S_NODE_2142_length_298_cov_48394.357414_g2053_i0 PRJEB6054 2142 298 48394.357414 144215.18509372 uncultured Ureaplasma sp. 293430 Bacteria Bacteria 195 4.35e-45   NTclustered gi|1899225129|gb|MT967601.1| 293430 g2053 i0 82.743 58.2818791946309 226 32 74 7 59 280 1967 1745 Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 17368 195 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma uncultured Ureaplasma sp.

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