RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA773625", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773625 · 4 ✖

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
5852929 5852929 PRJNA773625_P_NODE_8345_length_167_cov_0.881356_g8330_i0 PRJNA773625 8345 167 0.881356 1.47186452 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 303 3.5e-78   NTclustered gi|49311|emb|Z16416.1| 2107 g8330 i0 99.401 24.1976047904192 167 1 100 0 1 167 1270 1104 M.pulmonis DNA for insertion sequence IS1138 encoding putative transposase blastn 4041 303 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
12228926 12228926 PRJNA773625_P_NODE_1970_length_285_cov_4.775424_g1955_i0 PRJNA773625 1970 285 4.775424 13.6099584 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 525 1.2899999999999994e-144   NTclustered gi|1563796921|emb|LR215008.1| 2107 g1955 i0 100 139.270175438596 284 0 99 0 1 284 799425 799142 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 39692 525 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
13961098 13961098 PRJNA773625_P_NODE_2911_length_243_cov_1.072165_g2896_i0 PRJNA773625 2911 243 1.072165 2.60536095 Mycoplasma 2093 Bacteria Bacteria 444 3.09e-120   NTclustered gi|54609775|gb|AY765214.1| 51364 g2896 i0 99.588 187 243 1 100 0 1 243 637 395 Mycoplasma cottewii strain ATCC 43093 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 45441 444 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
23702249 23702249 PRJNA773625_P_NODE_6519_length_176_cov_1.228346_g6504_i0 PRJNA773625 6519 176 1.228346 2.16188896 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 320 3.69e-83   NTclustered gi|1563796921|emb|LR215008.1| 2107 g6504 i0 99.432 2 176 1 100 0 1 176 30811 30986 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 352 320 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);;