RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA827593 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2096349 2096349 PRJNA827593_P_NODE_17242_length_517_cov_2.103604_g16944_i0 PRJNA827593 17242 517 2.103604 10.87563268 Mycoplasma sp. HU2 2108 Bacteria Bacteria 92 3.62e-19   NR WP_050517519.1 1664275 g16944 i0 91.3 0.266924564796905 46 4 26.7 0 111 248 1 46 WP_050517519.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 138 92 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
13574417 13574417 PRJNA827593_P_NODE_20631_length_467_cov_3.027919_g20333_i0 PRJNA827593 20631 467 3.027919 14.14038173 Bacillati 1783272 Bacteria Bacteria 144 2.05e-41   NR CCY79798.1 1262907 g20333 i0 82.4 4.69593147751606 91 16 58.5 0 25 297 11 101 CCY79798.1 pTS system glucose-specific IIBC component [Mycoplasma sp. CAG:877] diamond 2193 145 0.993103448275862 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. CAG:877
22497786 22497786 PRJNA827593_P_NODE_29338_length_383_cov_1.235484_g29039_i0 PRJNA827593 29338 383 1.235484 4.73190372 Mycoplasma sp. HU2 2108 Bacteria Bacteria 205 1.31e-60   NR WP_050517646.1 1664275 g29039 i0 89.8 0.994778067885117 127 13 99.5 0 381 1 391 517 WP_050517646.1 BMP family ABC transporter substrate-binding protein [Mycoplasma sp. HU2014] diamond 381 205 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
29652174 29652174 PRJNA827593_P_NODE_64510_length_246_cov_0.890173_g64211_i0 PRJNA827593 64510 246 0.890173 2.18982558 Mycoplasmopsis 2767358 Bacteria Bacteria 143 1.44e-39   NR WP_183140848.1 2115 g64211 i0 98.6 1.78048780487805 73 1 89 0 222 4 36 108 WP_183140848.1 hypothetical protein [Mycoplasmopsis fermentans] diamond 438 143 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
30339377 30339377 PRJNA827593_P_NODE_53452_length_272_cov_1.477387_g53153_i0 PRJNA827593 53452 272 1.477387 4.01849264 Malacoplasma sp. 2791014 Bacteria Bacteria 61.2 8.28e-10   NR MCF0227481.1 2791014 g53153 i0 54 1.51102941176471 50 21 55.1 1 259 110 40 87 MCF0227481.1 30S ribosomal protein S19 [Malacoplasma sp.] diamond 411 61.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
30717960 30717960 PRJNA827593_P_NODE_7694_length_805_cov_4.513661_g7420_i0 PRJNA827593 7694 805 4.513661 36.33497105 Mycoplasmopsis fermentans 2115 Bacteria Bacteria 320 2.42e-104   NR WP_122530533.1 2115 g7420 i0 99.4 0.596273291925466 160 1 59.6 0 803 324 188 347 WP_122530533.1 glycosyltransferase family 2 protein [Mycoplasmopsis fermentans] diamond 480 320 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis fermentans
31350178 31350178 PRJNA827593_P_NODE_38396_length_328_cov_2.039216_g38097_i0 PRJNA827593 38396 328 2.039216 6.68862848 Mycoplasma sp. HU2 2108 Bacteria Bacteria 99 9.82e-22   NR WP_050517811.1 1664275 g38097 i0 96.2 0.484756097560976 53 2 48.5 0 54 212 211 263 WP_050517811.1 lipoprotein [Mycoplasma sp. HU2014] diamond 159 99 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31919449 31919449 PRJNA827593_P_NODE_29657_length_380_cov_2.052117_g29358_i0 PRJNA827593 29657 380 2.052117 7.7980446 Mycoplasma sp. HU2 2108 Bacteria Bacteria 136 3.45e-35   NR WP_050517193.1 1664275 g29358 i0 93.4 0.6 76 5 60 0 77 304 237 312 WP_050517193.1 P68 family surface lipoprotein, partial [Mycoplasma sp. HU2014] diamond 228 136 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
31982636 31982636 PRJNA827593_P_NODE_57538_length_260_cov_2.379679_g57239_i0 PRJNA827593 57538 260 2.379679 6.1871654 Mycoplasma sp. HU2 2108 Bacteria Bacteria 139 2.38e-38   NR WP_050517369.1 1664275 g57239 i0 100 0.796153846153846 69 0 79.6 0 223 17 94 162 WP_050517369.1 C5 methylase (MAV1virus-like) protein [Mycoplasma sp. HU2014] diamond 207 139 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32299517 32299517 PRJNA827593_P_NODE_66559_length_243_cov_0.905882_g66260_i0 PRJNA827593 66559 243 0.905882 2.20129326 Mycoplasma sp. HU2 2108 Bacteria Bacteria 84.3 9.48e-19   NR WP_050517656.1 1664275 g66260 i0 80.7 0.703703703703704 57 11 70.4 0 3 173 12 68 WP_050517656.1 lipoprotein [Mycoplasma sp. HU2014] diamond 171 84.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32520914 32520914 PRJNA827593_P_NODE_58439_length_258_cov_1.664865_g58140_i0 PRJNA827593 58439 258 1.664865 4.2953517 Mycoplasma sp. HU2 2108 Bacteria Bacteria 168 7.4e-47   NR WP_050517820.1 1664275 g58140 i0 98.8 0.988372093023256 85 1 98.8 0 257 3 546 630 WP_050517820.1 HsdM family class I SAM-dependent methyltransferase [Mycoplasma sp. HU2014] diamond 255 168 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32583997 32583997 PRJNA827593_P_NODE_53199_length_272_cov_4.557789_g52900_i0 PRJNA827593 53199 272 4.557789 12.397186080000001 Mycoplasma sp. HU2 2108 Bacteria Bacteria 162 2.7999999999999995e-44   NR WP_050517625.1 1664275 g52900 i0 98.8 0.9375 85 1 93.8 0 271 17 203 287 WP_050517625.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 255 162 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. HU2014
32709651 32709651 PRJNA827593_P_NODE_28380_length_390_cov_1.753943_g28081_i0 PRJNA827593 28380 390 1.753943 6.8403777 Mycoplasma sp. HU2 2108 Bacteria Bacteria 132 5.53e-33   NR WP_050517625.1 1664275 g28081 i0 96.6 0.9 117 4 90 0 388 38 35 151 WP_050517625.1 BspA family leucine-rich repeat surface protein [Mycoplasma sp. HU2014] diamond 351 132 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);;