RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJDB12578", 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

  • PRJDB12578 · 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
443 443 PRJDB12578_S_NODE_104341_length_278_cov_2.030568_g81283_i0 PRJDB12578 104341 278 2.030568 5.64497904 Mycoplasma sp. OR1901 2742195 Bacteria Bacteria 52.8 0.026   NTclustered gi|1858594482|gb|CP054666.1| 2742195 g81283 i0 100 0.100719424460432 28 0 10 0 37 64 361918 361945 Mycoplasma sp. OR1901 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. OR1901
4131 4131 PRJDB12578_S_NODE_203121_length_165_cov_2.224138_g180063_i0 PRJDB12578 203121 165 2.224138 3.6698277 Candidatus Mycoplasma mahonii 3004105 Bacteria Bacteria 60.2 8.25e-5   NTclustered gi|2554183568|gb|CP114583.1| 3004105 g180063 i0 100 0.193939393939394 32 0 19 0 27 58 637605 637636 Candidatus Mycoplasma mahonii isolate OP267 chromosome, complete genome blastn 32 60.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Candidatus Mycoplasma mahonii
5103647 5103647 PRJDB12578_S_NODE_123745_length_236_cov_2.689840_g100687_i0 PRJDB12578 123745 236 2.68984 6.3480224 Mycoplasma sp. SG1 2810348 Bacteria Bacteria 52.8 0.021   NTclustered gi|2246783662|gb|CP076852.1| 2810348 g100687 i0 100 0.11864406779661 28 0 12 0 92 119 588029 588002 Mycoplasma sp. SG1 chromosome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. SG1
7656736 7656736 PRJDB12578_S_NODE_211567_length_163_cov_0.903509_g188509_i0 PRJDB12578 211567 163 0.903509 1.47271967 Mycoplasma sp. SG1 2810348 Bacteria Bacteria 54.7 0.004   NTclustered gi|2246783662|gb|CP076852.1| 2810348 g188509 i0 100 0.177914110429448 29 0 18 0 62 90 319993 319965 Mycoplasma sp. SG1 chromosome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. SG1
10205129 10205129 PRJDB12578_S_NODE_150409_length_203_cov_1.000000_g127351_i0 PRJDB12578 150409 203 1 2.03 Candidatus Phytoplasma fraxini 35780 Bacteria Bacteria 52.8 0.018   NTclustered gi|2714275034|gb|CP146843.1| 35780 g127351 i0 100 0.137931034482759 28 0 14 0 153 180 475152 475125 Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma fraxini
11481807 11481807 PRJDB12578_S_NODE_194470_length_168_cov_2.596639_g171412_i0 PRJDB12578 194470 168 2.596639 4.36235352 Spiroplasma endosymbiont of Labia minor 3066305 Bacteria Bacteria 54.7 0.004   NTclustered gi|2706542413|emb|OZ026465.1| 3066305 g171412 i0 100 0.172619047619048 29 0 17 0 140 168 402192 402164 Spiroplasma endosymbiont of Labia minor isolate 54776 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Labia minor
14029538 14029538 PRJDB12578_S_NODE_129852_length_227_cov_1.157303_g106794_i0 PRJDB12578 129852 227 1.157303 2.62707781 Haploplasma axanthum 29552 Bacteria Bacteria 54.7 0.006   NTclustered gi|1563809587|emb|LR215048.1| 29552 g106794 i0 100 0.127753303964758 29 0 13 0 75 103 1730064 1730092 Acholeplasma axanthum strain NCTC10138 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Haploplasma Haploplasma axanthum

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