RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA951810" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA951810 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
936078 936078 PRJNA951810_P_NODE_145941_length_261_cov_3.611702_g145596_i0 PRJNA951810 145941 261 3.611702 9.42654222 endosymbiont DhMRE of Dentiscutata heterogama 1609546 Bacteria Bacteria 86.1 2.35e-12   NTclustered gi|820946451|emb|LN828718.1| 1609546 g145596 i0 85.542 0.318007662835249 83 10 31 2 24 105 343034 342953 endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1 blastn 83 86.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     endosymbiont DhMRE of Dentiscutata heterogama
1262949 1262949 PRJNA951810_P_NODE_122381_length_278_cov_4.824390_g122036_i0 PRJNA951810 122381 278 4.82439 13.4118042 Ureaplasma 2129 Bacteria Bacteria 514 2.7199999999999996e-141   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g122036 i0 100 16.2230215827338 278 0 100 0 1 278 508973 509250 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 4510 514 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
2538784 2538784 PRJNA951810_P_NODE_135102_length_269_cov_4.566327_g134757_i0 PRJNA951810 135102 269 4.566327 12.28341963 Ureaplasma 2129 Bacteria Bacteria 492 1.23e-134   NTclustered gi|620596742|dbj|AP014584.1| 38504 g134757 i0 99.628 45.4163568773234 269 1 100 0 1 269 262703 262435 Ureaplasma parvum serovar 3 DNA, complete genome, strain: SV3F4 blastn 12217 492 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
3815508 3815508 PRJNA951810_P_NODE_187303_length_221_cov_10.094595_g186958_i0 PRJNA951810 187303 221 10.094595 22.30905495 Ureaplasma 2129 Bacteria Bacteria 409 1.0100000000000001e-109   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g186958 i0 100 11 221 0 100 0 1 221 345225 345445 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 2431 409 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
6038981 6038981 PRJNA951810_P_NODE_130185_length_273_cov_2.110000_g129840_i0 PRJNA951810 130185 273 2.11 5.7603 Metamycoplasma faucium 56142 Bacteria Bacteria 451 2.11e-122   NTclustered gi|2708452869|gb|CP088155.1| 56142 g129840 i0 96.364 2 275 8 100 2 1 273 382921 382647 Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome blastn 546 451 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
8915669 8915669 PRJNA951810_P_NODE_104407_length_290_cov_4.322581_g104063_i0 PRJNA951810 104407 290 4.322581 12.5354849 Ureaplasma 2129 Bacteria Bacteria 278 4.07e-70   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g104063 i0 100 11.051724137931 150 0 100 0 141 290 583697 583846 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 3205 279 0.996415770609319 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum
21338484 21338484 PRJNA951810_P_NODE_163277_length_247_cov_5.821839_g162932_i0 PRJNA951810 163277 247 5.821839 14.37994233 Candidatus Xianfuyuplasma coldseepsis 2782163 Bacteria Bacteria 71.3 6.16e-8   NTclustered gi|1883609011|gb|CP048914.1| 2782163 g162932 i0 88.333 0.242914979757085 60 6 24 1 1 59 1410067 1410008 Candidatus Xianfuyuplasma coldseepsis strain zrk13 chromosome, complete genome blastn 60 71.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Xianfuyuplasma Candidatus Xianfuyuplasma coldseepsis
25489894 25489894 PRJNA951810_P_NODE_166740_length_245_cov_1.598837_g166395_i0 PRJNA951810 166740 245 1.598837 3.91715065 Ureaplasma 2129 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1493548740|dbj|AP018561.1| 38504 g166395 i0 100 16 245 0 100 0 1 245 62223 62467 Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome blastn 3920 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma parvum

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