RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA529241" 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

bioproject 1

  • PRJNA529241 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
4943249 4943249 PRJNA529241_P_NODE_192224_length_173_cov_6.808824_g189902_i0 PRJNA529241 192224 173 6.808824 11.77926552 Spiroplasmataceae 2131 Bacteria Bacteria 73.1 1.12e-8   NTclustered gi|28565759|gb|AY196995.1| 214888 g189902 i0 97.619 1.80924855491329 42 1 24 0 35 76 261 302 Entomoplasma luminosum DNA gyrase subunit B (gyrB) gene, partial cds blastn 313 73.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales   Williamsoniiplasma Williamsoniiplasma luminosum
9429653 9429653 PRJNA529241_P_NODE_474788_length_151_cov_8.052632_g472466_i0 PRJNA529241 474788 151 8.052632 12.15947432 Williamsoniiplasma luminosum 214888 Bacteria Bacteria 115 1.55e-21   NTclustered gi|1285333622|gb|CP024963.1| 214888 g472466 i0 94.595 41.4105960264901 74 4 49 0 78 151 210894 210967 Williamsoniiplasma luminosum strain PIMN-1 chromosome, complete genome blastn 6253 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales   Williamsoniiplasma Williamsoniiplasma luminosum
11979950 11979950 PRJNA529241_P_NODE_454950_length_155_cov_1.110169_g452628_i0 PRJNA529241 454950 155 1.110169 1.72076195 Spiroplasma cantharicola 362837 Bacteria Bacteria 54.7 0.004   NTclustered gi|927034336|gb|CP012622.1| 362837 g452628 i0 100 0.187096774193548 29 0 19 0 97 125 703421 703393 Spiroplasma cantharicola strain CC-1, complete genome blastn 29 54.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma cantharicola
18967491 18967491 PRJNA529241_P_NODE_420155_length_168_cov_1.190840_g417833_i0 PRJNA529241 420155 168 1.19084 2.0006112 Mycoplasmoides 2995234 Bacteria Bacteria 300 4.56e-77   NTclustered gi|1409670345|gb|MH540253.1| 2096 g417833 i0 98.81 115.529761904762 168 2 100 0 1 168 1350 1183 Mycoplasmoides gallisepticum strain B943-06-2 23S ribosomal RNA gene, partial sequence blastn 19409 300 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides gallisepticum
20902585 20902585 PRJNA529241_P_NODE_371917_length_173_cov_2.654412_g369595_i0 PRJNA529241 371917 173 2.654412 4.59213276 Candidatus Izimoplasma sp. HR1 1541959 Bacteria Bacteria 62.1 2.41e-5   NTclustered gi|685629397|gb|CP009415.1| 1541959 g369595 i0 94.872 0.225433526011561 39 2 23 0 133 171 1194075 1194113 Candidatus Izimaplasma bacterium HR1 chromosome, complete genome blastn 39 62.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR1

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