RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA493828" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493828 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
4301917 4301917 PRJNA493828_P_NODE_7884_length_400_cov_1.574924_g7469_i0 PRJNA493828 7884 400 1.574924 6.299696 Mycoplasma sp. HU2 2108 Bacteria Bacteria 199 1.92e-58   NR WP_050517646.1 1664275 g7469 i0 100 0.7575 101 0 75.8 0 11 313 94 194 WP_050517646.1 BMP family ABC transporter substrate-binding protein [Mycoplasma sp. HU2014] diamond 303 199 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
7484691 7484691 PRJNA493828_P_NODE_39186_length_241_cov_3.821429_g38767_i0 PRJNA493828 39186 241 3.821429 9.20964389 Mycoplasma sp. HU2 2108 Bacteria Bacteria 130 2.24e-33   NR WP_050517646.1 1664275 g38767 i0 100 0.846473029045643 68 0 84.6 0 3 206 383 450 WP_050517646.1 BMP family ABC transporter substrate-binding protein [Mycoplasma sp. HU2014] diamond 204 130 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
11953367 11953367 PRJNA493828_P_NODE_25050_length_270_cov_2.893401_g24631_i0 PRJNA493828 25050 270 2.893401 7.8121827 Metamycoplasma faucium 56142 Bacteria Bacteria 110 6.1e-26   NR WP_405312175.1 56142 g24631 i0 58.9 1 90 37 100 0 1 270 84 173 WP_405312175.1 site-specific DNA-methyltransferase [Metamycoplasma faucium] diamond 270 110 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma faucium
27361599 27361599 PRJNA493828_P_NODE_39123_length_241_cov_6.113095_g38704_i0 PRJNA493828 39123 241 6.113095 14.73255895 Mycoplasma sp. HU2 2108 Bacteria Bacteria 79 6.3e-15   NR WP_050517218.1 1664275 g38704 i0 97.4 0.485477178423237 39 1 48.5 0 63 179 889 927 WP_050517218.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 117 79 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
27709151 27709151 PRJNA493828_P_NODE_43864_length_227_cov_2.474026_g43445_i0 PRJNA493828 43864 227 2.474026 5.61603902 Mycoplasma sp. HU2 2108 Bacteria Bacteria 136 6.079999999999999e-37   NR WP_050517664.1 1664275 g43445 i0 98.7 0.991189427312775 75 1 99.1 0 1 225 58 132 WP_050517664.1 aromatic motif membrane protein [Mycoplasma sp. HU2014] diamond 225 136 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
28055902 28055902 PRJNA493828_P_NODE_17845_length_297_cov_4.285714_g17426_i0 PRJNA493828 17845 297 4.285714 12.72857058 Mycoplasma sp. HU2 2108 Bacteria Bacteria 179 1.3999999999999997e-56   NR KNG79339.1 1664275 g17426 i0 98.9 2.66666666666667 88 1 88.9 0 32 295 1 88 KNG79339.1 ISMbov5-related transposase, partial [Mycoplasma sp. HU2014] diamond 792 179 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
29287281 29287281 PRJNA493828_P_NODE_21709_length_281_cov_2.850962_g21290_i0 PRJNA493828 21709 281 2.850962 8.01120322 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 139 4.7099999999999997e-39   NR MCI7555070.1 2231116 g21290 i0 68.8 0.99288256227758 93 28 99.3 1 279 1 87 178 MCI7555070.1 site-specific DNA-methyltransferase [Mycoplasmatota bacterium] diamond 279 139 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
29950559 29950559 PRJNA493828_P_NODE_9691_length_365_cov_5.863014_g9273_i0 PRJNA493828 9691 365 5.863014 21.4000011 Mycoplasma sp. HU2 2108 Bacteria Bacteria 63.2 1.06e-8   NR WP_050517339.1 1664275 g9273 i0 100 1.25753424657534 32 0 26.3 0 98 3 117 148 WP_050517339.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 459 63.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
30456393 30456393 PRJNA493828_P_NODE_29153_length_258_cov_2.432432_g28734_i0 PRJNA493828 29153 258 2.432432 6.27567456 Candidatus Phytoplasma solani 69896 Bacteria Bacteria 62.8 1.6e-10   NR CCP88063.1 69896 g28734 i0 46.2 1.81395348837209 78 42 90.7 0 247 14 19 96 CCP88063.1 conserved hypothetical protein, partial CDS, partial [Candidatus Phytoplasma solani] diamond 468 62.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma solani
31056666 31056666 PRJNA493828_P_NODE_33875_length_248_cov_3.451429_g33456_i0 PRJNA493828 33875 248 3.451429 8.55954392 Mycoplasma sp. HU2 2108 Bacteria Bacteria 127 6.78e-34   NR WP_050517358.1 1664275 g33456 i0 98.5 0.810483870967742 67 1 81 0 47 247 66 132 WP_050517358.1 MSC_0882 family membrane protein [Mycoplasma sp. HU2014] diamond 201 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32606102 32606102 PRJNA493828_P_NODE_17380_length_301_cov_1.364035_g16961_i0 PRJNA493828 17380 301 1.364035 4.10574535 Mycoplasma sp. HU2 2108 Bacteria Bacteria 150 3.58e-41   NR WP_050517193.1 1664275 g16961 i0 100 0.777408637873754 78 0 77.7 0 2 235 235 312 WP_050517193.1 P68 family surface lipoprotein, partial [Mycoplasma sp. HU2014] diamond 234 150 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014

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