RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1103784", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 8 ✖

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1103784 · 8 ✖

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
1486855 1486855 PRJNA1103784_P_NODE_6542_length_247_cov_0.885057_g6487_i0 PRJNA1103784 6542 247 0.885057 2.18609079 Mesomycoplasma hyorhinis 2100 Bacteria Bacteria 457 4.05e-124   NTclustered gi|1052538474|gb|CP016817.1| 2100 g6487 i0 100 15 247 0 100 0 1 247 638652 638406 Mesomycoplasma hyorhinis strain MDBK-IPV, complete genome blastn 3705 457 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
2295630 2295630 PRJNA1103784_P_NODE_5742_length_251_cov_0.865169_g5687_i0 PRJNA1103784 5742 251 0.865169 2.17157419 Mesomycoplasma 2923352 Bacteria Bacteria 464 2.47e-126   NTclustered gi|1563681465|emb|LR214949.1| 2100 g5687 i0 100 16.3027888446215 251 0 100 0 1 251 661431 661181 Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3 blastn 4092 464 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
2762907 2762907 PRJNA1103784_P_NODE_8223_length_199_cov_4.531746_g8168_i0 PRJNA1103784 8223 199 4.531746 9.01817454 Mesomycoplasma hyorhinis 2100 Bacteria Bacteria 368 1.51e-97   NTclustered gi|1932032494|gb|CP064323.1| 2100 g8168 i0 100 57.4371859296482 199 0 100 0 1 199 444314 444116 Mesomycoplasma hyorhinis strain IMT49388 chromosome, complete genome blastn 11430 368 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
8673420 8673420 PRJNA1103784_P_NODE_6947_length_245_cov_0.895349_g6892_i0 PRJNA1103784 6947 245 0.895349 2.19360505 Mesomycoplasma 2923352 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1720621726|gb|CP035041.1| 2100 g6892 i0 100 16.2775510204082 245 0 100 0 1 245 496581 496337 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3988 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
15514820 15514820 PRJNA1103784_P_NODE_7713_length_241_cov_1.500000_g7658_i0 PRJNA1103784 7713 241 1.5 3.615 Mesomycoplasma hyorhinis 2100 Bacteria Bacteria 444 3.06e-120   NTclustered gi|1052538474|gb|CP016817.1| 2100 g7658 i0 100 33.4896265560166 240 0 99 0 1 240 765877 765638 Mesomycoplasma hyorhinis strain MDBK-IPV, complete genome blastn 8071 444 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
17597864 17597864 PRJNA1103784_P_NODE_3494_length_296_cov_1.035874_g3439_i0 PRJNA1103784 3494 296 1.035874 3.06618704 Mesomycoplasma 2923352 Bacteria Bacteria 547 2.8799999999999986e-151   NTclustered gi|1720621726|gb|CP035041.1| 2100 g3439 i0 100 17 296 0 100 0 1 296 651845 651550 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 5032 547 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
18063785 18063785 PRJNA1103784_P_NODE_1555_length_411_cov_2.754438_g1500_i0 PRJNA1103784 1555 411 2.754438 11.32074018 Candidatus Izimoplasma sp. HR1 1541959 Bacteria Bacteria 52.8 0.039   NTclustered gi|685629397|gb|CP009415.1| 1541959 g1500 i0 100 0.0681265206812652 28 0 7 0 214 241 225585 225558 Candidatus Izimaplasma bacterium HR1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR1
21422193 21422193 PRJNA1103784_P_NODE_5017_length_262_cov_2.306878_g4962_i0 PRJNA1103784 5017 262 2.306878 6.04402036 Mesomycoplasma 2923352 Bacteria Bacteria 484 1.99e-132   NTclustered gi|2713084492|gb|CP150431.1| 2100 g4962 i0 100 18.5496183206107 262 0 100 0 1 262 680442 680703 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 4860 484 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis

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