RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA431371" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA431371 · 12 ✖

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
1088083 1088083 PRJNA431371_P_NODE_4481_length_557_cov_1.878099_g4408_i0 PRJNA431371 4481 557 1.878099 10.46101143 Mesomycoplasma 2923352 Bacteria Bacteria 1029 0   NTclustered gi|1720621726|gb|CP035041.1| 2100 g4408 i0 100 15.9982046678636 557 0 100 0 1 557 326511 325955 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 8911 1029 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
3639032 3639032 PRJNA431371_P_NODE_19263_length_291_cov_1.412844_g19190_i0 PRJNA431371 19263 291 1.412844 4.11137604 Mesomycoplasma 2923352 Bacteria Bacteria 538 1.6999999999999994e-148   NTclustered gi|2713084492|gb|CP150431.1| 2100 g19190 i0 100 25.8041237113402 291 0 100 0 1 291 730674 730384 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 7509 538 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
6191048 6191048 PRJNA431371_P_NODE_18105_length_301_cov_1.350877_g18032_i0 PRJNA431371 18105 301 1.350877 4.06613977 Mesomycoplasma 2923352 Bacteria Bacteria 556 4.87e-154   NTclustered gi|1720621726|gb|CP035041.1| 2100 g18032 i0 100 15 301 0 100 0 1 301 325635 325935 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 4515 556 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
7466174 7466174 PRJNA431371_P_NODE_6526_length_477_cov_1.715347_g6453_i0 PRJNA431371 6526 477 1.715347 8.18220519 Mesomycoplasma 2923352 Bacteria Bacteria 881 0   NTclustered gi|2713084492|gb|CP150431.1| 2100 g6453 i0 100 16.8511530398323 477 0 100 0 1 477 372673 373149 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 8038 881 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
12566754 12566754 PRJNA431371_P_NODE_15550_length_325_cov_0.916667_g15477_i0 PRJNA431371 15550 325 0.916667 2.97916775 Mesomycoplasma 2923352 Bacteria Bacteria 595 1.1299999999999995e-165   NTclustered gi|2713084492|gb|CP150431.1| 2100 g15477 i0 99.692 16.8307692307692 325 1 100 0 1 325 541702 541378 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 5470 595 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
13841469 13841469 PRJNA431371_P_NODE_23431_length_260_cov_1.647059_g23358_i0 PRJNA431371 23431 260 1.647059 4.2823534 Mesomycoplasma 2923352 Bacteria Bacteria 481 2.55e-131   NTclustered gi|2713084492|gb|CP150431.1| 2100 g23358 i0 100 15 260 0 100 0 1 260 270500 270759 Mesomycoplasma hyorhinis strain Nahrain chromosome blastn 3900 481 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
19554105 19554105 PRJNA431371_P_NODE_236_length_1456_cov_9.483008_g198_i0 PRJNA431371 236 1456 9.483008 138.07259648 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 211 8.89e-60   NR HXN54584.1 2023991 g198 i0 38.4 0.725274725274725 352 217 72.5 0 63 1118 8 359 HXN54584.1 cytochrome b N-terminal domain-containing protein [Mycoplasmatales bacterium] diamond 1056 211 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
19554235 19554235 PRJNA431371_P_NODE_2996_length_646_cov_1.516579_g2923_i0 PRJNA431371 2996 646 1.516579 9.79710034 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 145 4.75e-39   NR HXN54415.1 2023991 g2923 i0 45.8 0.882352941176471 190 101 88.2 2 8 577 50 237 HXN54415.1 50S ribosomal protein L2 [Mycoplasmatales bacterium] diamond 570 145 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
21489795 21489795 PRJNA431371_P_NODE_16857_length_313_cov_0.958333_g16784_i0 PRJNA431371 16857 313 0.958333 2.99958229 Mesomycoplasma 2923352 Bacteria Bacteria 573 5.049999999999998e-159   NTclustered gi|1720621726|gb|CP035041.1| 2100 g16784 i0 99.681 38.2108626198083 313 1 100 0 1 313 325562 325250 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 11960 573 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
24039814 24039814 PRJNA431371_P_NODE_29239_length_247_cov_0.885057_g29166_i0 PRJNA431371 29239 247 0.885057 2.18609079 Mesomycoplasma 2923352 Bacteria Bacteria 457 4.05e-124   NTclustered gi|1720621726|gb|CP035041.1| 2100 g29166 i0 100 15 247 0 100 0 1 247 109837 110083 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3705 457 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
24039830 24039830 PRJNA431371_P_NODE_31299_length_245_cov_1.343023_g31226_i0 PRJNA431371 31299 245 1.343023 3.29040635 Mesomycoplasma 2923352 Bacteria Bacteria 453 5.1900000000000006e-123   NTclustered gi|1720621726|gb|CP035041.1| 2100 g31226 i0 100 15 245 0 100 0 1 245 326684 326928 Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome blastn 3675 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
27107175 27107175 PRJNA431371_P_NODE_20502_length_282_cov_1.473684_g20429_i0 PRJNA431371 20502 282 1.473684 4.15578888 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 84 3.09e-18   NR HXN54412.1 2023991 g20429 i0 54.1 0.787234042553192 74 34 78.7 0 5 226 21 94 HXN54412.1 50S ribosomal protein L16 [Mycoplasmatales bacterium] diamond 222 84 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium

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