RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1028258", tax_phylum = "Mycoplasmatota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_phylum 1

  • Mycoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1028258 · 5 ✖

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
6541872 6541872 PRJNA1028258_P_NODE_147346_length_232_cov_0.871166_g146783_i0 PRJNA1028258 147346 232 0.871166 2.02110512 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 152 1.99e-32   NTclustered gi|2621717558|emb|OY775910.1| 1898209 g146783 i0 85.915 15.75 142 20 61 0 2 143 1083421 1083562 MAG: Acholeplasmataceae bacterium isolate 79d77305-d387-4e48-9b67-53dfc1ec32a7 genome assembly, chromosome: 1 blastn 3654 152 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
11642732 11642732 PRJNA1028258_P_NODE_173830_length_225_cov_2.333333_g173267_i0 PRJNA1028258 173830 225 2.333333 5.24999925 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 416 6.159999999999998e-112   NTclustered gi|1563796921|emb|LR215008.1| 2107 g173267 i0 100 179.862222222222 225 0 100 0 1 225 798389 798165 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 40469 416 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
14193798 14193798 PRJNA1028258_P_NODE_58312_length_333_cov_2.545455_g57749_i0 PRJNA1028258 58312 333 2.545455 8.47636515 Mycoplasmopsis pulmonis 2107 Bacteria Bacteria 599 8.94e-167   NTclustered gi|1563796921|emb|LR215008.1| 2107 g57749 i0 99.099 122.708708708709 333 3 100 0 1 333 800276 799944 Mycoplasma pulmonis strain NCTC10139 genome assembly, chromosome: 1 blastn 40862 599 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis pulmonis
25232369 25232369 PRJNA1028258_P_NODE_74600_length_298_cov_1.475983_g74037_i0 PRJNA1028258 74600 298 1.475983 4.39842934 Mesomycoplasma 2923352 Bacteria Bacteria 551 2.239999999999999e-152   NTclustered gi|1958638472|gb|MW498281.1| 2100 g74037 i0 100 101.184563758389 298 0 100 0 1 298 1950 2247 Mesomycoplasma hyorhinis strain MycSu21 23S ribosomal RNA gene, partial sequence blastn 30153 551 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma hyorhinis
32184869 32184869 PRJNA1028258_P_NODE_91078_length_270_cov_1.412935_g90515_i0 PRJNA1028258 91078 270 1.412935 3.8149245 Mycoplasmopsis bovigenitalium 2112 Bacteria Bacteria 43.5 0.0259   NR WP_004421048.1 2112 g90515 i0 34.8 0.766666666666667 69 37 76.7 2 215 9 145 205 WP_004421048.1 DnaJ C-terminal domain-containing protein [Mycoplasmopsis bovigenitalium] diamond 207 43.5 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovigenitalium

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