RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA674308", 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 · 13 ✖

tax_kingdom 1

  • Bacillati · 13 ✖

bioproject 1

  • PRJNA674308 · 13 ✖

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
3718410 3718410 PRJNA674308_P_NODE_49363_length_163_cov_1.824561_g49128_i0 PRJNA674308 49363 163 1.824561 2.97403443 Mesomycoplasma 2923352 Bacteria Bacteria 300 4.39e-77   NTclustered gi|2713084492|gb|CP150431.1| 2100 g49128 i0 100 42.1104294478528 162 0 99 0 2 163 672401 672240 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 6864 300 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
7023507 7023507 PRJNA674308_P_NODE_42706_length_166_cov_0.888889_g42471_i0 PRJNA674308 42706 166 0.888889 1.47555574 Candidatus Phytoplasma solani 69896 Bacteria Bacteria 52.8 0.014   NTclustered gi|2741905208|gb|CP155828.1| 69896 g42471 i0 100 0.168674698795181 28 0 17 0 89 116 616941 616914 Candidatus Phytoplasma solani strain GOE chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma solani
7544465 7544465 PRJNA674308_P_NODE_31526_length_180_cov_1.587786_g31291_i0 PRJNA674308 31526 180 1.587786 2.8580148 Mesomycoplasma 2923352 Bacteria Bacteria 333 4.87e-87   NTclustered gi|1720621726|gb|CP035041.1| 2100 g31291 i0 100 15 180 0 100 0 1 180 323410 323231 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2700 333 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8819773 8819773 PRJNA674308_P_NODE_50847_length_163_cov_0.912281_g50612_i0 PRJNA674308 50847 163 0.912281 1.48701803 Mesomycoplasma 2923352 Bacteria Bacteria 296 5.68e-76   NTclustered gi|1720621726|gb|CP035041.1| 2100 g50612 i0 99.387 15.9693251533742 163 1 100 0 1 163 840421 840583 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2603 296 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
11370102 11370102 PRJNA674308_P_NODE_27949_length_190_cov_1.475177_g27714_i0 PRJNA674308 27949 190 1.475177 2.8028363 Mesomycoplasma 2923352 Bacteria Bacteria 351 1.4399999999999997e-92   NTclustered gi|1720621726|gb|CP035041.1| 2100 g27714 i0 100 15 190 0 100 0 1 190 323568 323757 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2850 351 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
11370137 11370137 PRJNA674308_P_NODE_32489_length_177_cov_4.015625_g32254_i0 PRJNA674308 32489 177 4.015625 7.10765625 Mollicutes 31969 Bacteria Bacteria 322 1.03e-83   NTclustered gi|1958638472|gb|MW498281.1| 2100 g32254 i0 99.435 100 177 1 100 0 1 177 1959 2135 Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence blastn 17700 322 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
16469385 16469385 PRJNA674308_P_NODE_25433_length_198_cov_3.073826_g25198_i0 PRJNA674308 25433 198 3.073826 6.08617548 Mesomycoplasma 2923352 Bacteria Bacteria 366 5.4e-97   NTclustered gi|1720621726|gb|CP035041.1| 2100 g25198 i0 100 15 198 0 100 0 1 198 788589 788786 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2970 366 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19018103 19018103 PRJNA674308_P_NODE_12475_length_271_cov_2.500000_g12240_i0 PRJNA674308 12475 271 2.5 6.775 Mesomycoplasma 2923352 Bacteria Bacteria 501 2.05e-137   NTclustered gi|2713084492|gb|CP150431.1| 2100 g12240 i0 100 15 271 0 100 0 1 271 671953 672223 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 4065 501 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19018451 19018451 PRJNA674308_P_NODE_9515_length_308_cov_4.054054_g9280_i0 PRJNA674308 9515 308 4.054054 12.48648632 Mesomycoplasma 2923352 Bacteria Bacteria 558 1.39e-154   NTclustered gi|1720621726|gb|CP035041.1| 2100 g9280 i0 99.351 129.503246753247 308 2 100 0 1 308 427853 427546 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 39887 558 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
20293010 20293010 PRJNA674308_P_NODE_3276_length_534_cov_5.981443_g3044_i0 PRJNA674308 3276 534 5.981443 31.94090562 Mesomycoplasma 2923352 Bacteria Bacteria 979 0   NTclustered gi|1563681457|emb|LR214948.1| 2100 g3044 i0 99.813 16.998127340824 534 0 100 1 1 534 3580 3048 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 2 blastn 9077 979 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
22322185 22322185 PRJNA674308_P_NODE_4898_length_430_cov_2.254593_g4663_i0 PRJNA674308 4898 430 2.254593 9.6947499 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 248 4.93e-61   NTclustered gi|2187163482|emb|OV788640.1| 658143 g4663 i0 82.857 300.772093023256 280 45 65 3 151 429 373769 373492 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 129332 248 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
24118557 24118557 PRJNA674308_P_NODE_38439_length_168_cov_0.873950_g38204_i0 PRJNA674308 38439 168 0.87395 1.468236 Mesomycoplasma 2923352 Bacteria Bacteria 311 2.11e-80   NTclustered gi|1720621726|gb|CP035041.1| 2100 g38204 i0 100 15 168 0 100 0 1 168 139256 139423 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 2520 311 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
30239777 30239777 PRJNA674308_P_NODE_19492_length_222_cov_1.653179_g19257_i0 PRJNA674308 19492 222 1.653179 3.67005738 Spiroplasma syrphidicola 216945 Bacteria Bacteria 80.5 1.45e-16   NR WP_016340484.1 216945 g19257 i0 56.5 2.55405405405405 62 27 83.8 0 202 17 1 62 WP_016340484.1 adenylate kinase [Spiroplasma syrphidicola] diamond 567 80.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma syrphidicola

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