RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA1073183" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1073183 · 9 ✖

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
1461687 1461687 PRJNA1073183_P_NODE_18522_length_304_cov_1.000000_g18427_i0 PRJNA1073183 18522 304 1 3.04 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 562 1.06e-155   NTclustered gi|14089695|emb|AL445564.1| 2107 g18427 i0 100 2 304 0 100 0 1 304 273544 273241 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 2/3 blastn 608 562 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
2291436 2291436 PRJNA1073183_P_NODE_23882_length_267_cov_1.190722_g23787_i0 PRJNA1073183 23882 267 1.190722 3.17922774 Mollicutes 31969 Bacteria Bacteria 494 3.38e-135   NTclustered gi|1958638505|gb|MW498314.1| 2100 g23787 i0 100 103.40074906367 267 0 100 0 1 267 1294 1028 Mesomycoplasma hyorhinis strain MycSu128 23S ribosomal RNA gene, partial sequence blastn 27608 494 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
2737752 2737752 PRJNA1073183_P_NODE_21923_length_280_cov_1.115942_g21828_i0 PRJNA1073183 21923 280 1.115942 3.1246376 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 468 2.16e-127   NTclustered gi|14089695|emb|AL445564.1| 2107 g21828 i0 96.786 4.59642857142857 280 9 100 0 1 280 33064 33343 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 2/3 blastn 1287 468 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
2737831 2737831 PRJNA1073183_P_NODE_26023_length_253_cov_1.283333_g25928_i0 PRJNA1073183 26023 253 1.283333 3.24683249 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 468 1.92e-127   NTclustered gi|14089695|emb|AL445564.1| 2107 g25928 i0 100 2.11067193675889 253 0 100 0 1 253 9429 9177 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 2/3 blastn 534 468 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
19312715 19312715 PRJNA1073183_P_NODE_12596_length_364_cov_8.807560_g12501_i0 PRJNA1073183 12596 364 8.80756 32.0595184 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 673 0   NTclustered gi|559132568|tpe|HG521004.1| 2107 g12501 i0 100 8.07417582417582 364 0 100 0 1 364 375 12 TPA: Mycoplasma pulmonis tmRNA gene Mycop_pulmo_UABCTI blastn 2939 673 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
19313210 19313210 PRJNA1073183_P_NODE_8236_length_444_cov_1.660377_g8142_i0 PRJNA1073183 8236 444 1.660377 7.37207388 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 821 0   NTclustered gi|14089695|emb|AL445564.1| 2107 g8142 i0 100 2 444 0 100 0 1 444 245429 244986 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 2/3 blastn 888 821 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
20588466 20588466 PRJNA1073183_P_NODE_34637_length_241_cov_0.898810_g34542_i0 PRJNA1073183 34637 241 0.89881 2.1661321 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|1563796921|emb|LR215008.1| 2107 g34542 i0 100 2 241 0 100 0 1 241 258531 258291 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 482 446 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
20588490 20588490 PRJNA1073183_P_NODE_4777_length_580_cov_1.193294_g4685_i0 PRJNA1073183 4777 580 1.193294 6.9211052 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 1072 0   NTclustered gi|14089695|emb|AL445564.1| 2107 g4685 i0 100 96.5534482758621 580 0 100 0 1 580 90206 89627 Mycoplasma pulmonis (strain UAB CTIP) complete genome; segment 2/3 blastn 56001 1072 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
24413078 24413078 PRJNA1073183_P_NODE_19320_length_297_cov_1.638393_g19225_i0 PRJNA1073183 19320 297 1.638393 4.86602721 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 549 8.029999999999997e-152   NTclustered gi|1563796921|emb|LR215008.1| 2107 g19225 i0 100 2 297 0 100 0 1 297 310500 310204 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 594 549 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis

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