RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA603943" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA603943 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
4405396 4405396 PRJNA603943_P_NODE_58024_length_248_cov_0.880000_g57832_i0 PRJNA603943 58024 248 0.88 2.1824 Candidatus Faecisoma merdavium 2840801 Bacteria Bacteria 161 1.58e-44   NR HIS90538.1 2840801 g57832 i0 100 0.955645161290323 79 0 95.6 0 1 237 525 603 HIS90538.1 N-6 DNA methylase [Candidatus Faecisoma merdavium] diamond 237 161 1 Bacteria   Bacillati Mycoplasmatota       Candidatus Faecisoma Candidatus Faecisoma merdavium
15879940 15879940 PRJNA603943_P_NODE_3533_length_783_cov_1.335211_g3364_i0 PRJNA603943 3533 783 1.335211 10.45470213 Mycoplasmopsis arginini 2094 Bacteria Bacteria 412 2.06e-133   NR WP_129694533.1 2094 g3364 i0 77.3 1.99233716475096 260 55 99.6 1 3 782 52 307 WP_129694533.1 type I restriction endonuclease subunit R [Mycoplasmopsis arginini] diamond 1560 412 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
18428392 18428392 PRJNA603943_P_NODE_10955_length_487_cov_1.055556_g10764_i0 PRJNA603943 10955 487 1.055556 5.14055772 Bacteria 2 Bacteria Bacteria 312 2.43e-102   NR WP_129721844.1 114883 g10764 i0 87.6 4.95893223819302 161 20 99.2 0 3 485 190 350 WP_129721844.1 type I restriction-modification system subunit M [Mycoplasmopsis equigenitalium] diamond 2415 314 0.993630573248408 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis equigenitalium
26731403 26731403 PRJNA603943_P_NODE_41201_length_287_cov_1.799065_g41009_i0 PRJNA603943 41201 287 1.799065 5.16331655 Mollicutes bacterium 37628 Bacteria Bacteria 134 4.319999999999999e-37   NR MCI7058680.1 37628 g41009 i0 90.7 0.78397212543554 75 7 78.4 0 281 57 147 221 MCI7058680.1 hypothetical protein [Mollicutes bacterium] diamond 225 134 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
26890383 26890383 PRJNA603943_P_NODE_62561_length_245_cov_1.343023_g62369_i0 PRJNA603943 62561 245 1.343023 3.29040635 Acholeplasma sp. OttesenSCG-928-E16 2885269 Bacteria Bacteria 67 5.73e-12   NR MDL2292549.1 2885269 g62369 i0 41.2 0.83265306122449 68 40 83.3 0 41 244 3 70 MDL2292549.1 hypothetical protein [Acholeplasma sp. OttesenSCG-928-E16] diamond 204 67 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp. OttesenSCG-928-E16
27680507 27680507 PRJNA603943_P_NODE_1464_length_1120_cov_1.688634_g1338_i0 PRJNA603943 1464 1120 1.688634 18.9127008 Anaeroplasma bactoclasticum 2088 Bacteria Bacteria 103 1.56e-20   NR MCM1556180.1 2088 g1338 i0 32.1 0.75 280 153 71.8 13 808 5 2 256 MCM1556180.1 hypothetical protein [Anaeroplasma bactoclasticum] diamond 840 103 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Anaeroplasmatales Anaeroplasmataceae Anaeroplasma Anaeroplasma bactoclasticum
27819923 27819923 PRJNA603943_P_NODE_22084_length_369_cov_1.300676_g21892_i0 PRJNA603943 22084 369 1.300676 4.79949444 Bacillati 1783272 Bacteria Bacteria 93.2 3.13e-19   NR MDD6802042.1 37628 g21892 i0 48.4 2.04878048780488 126 59 99.2 3 2 367 37 160 MDD6802042.1 hypothetical protein [Mollicutes bacterium] diamond 756 93.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
27869483 27869483 PRJNA603943_P_NODE_12685_length_458_cov_1.566234_g12493_i0 PRJNA603943 12685 458 1.566234 7.17335172 Mollicutes bacterium 37628 Bacteria Bacteria 241 1.45e-78   NR MDD7037077.1 37628 g12493 i0 80.9 2.98689956331878 152 29 99.6 0 2 457 33 184 MDD7037077.1 hypothetical protein [Mollicutes bacterium] diamond 1368 241 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
27901031 27901031 PRJNA603943_P_NODE_28745_length_334_cov_1.475096_g28553_i0 PRJNA603943 28745 334 1.475096 4.92682064 Mollicutes bacterium 37628 Bacteria Bacteria 182 2.85e-52   NR MCI7788139.1 37628 g28553 i0 84.7 0.997005988023952 111 17 99.7 0 334 2 160 270 MCI7788139.1 hypothetical protein [Mollicutes bacterium] diamond 333 182 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
27932822 27932822 PRJNA603943_P_NODE_9485_length_516_cov_1.785553_g9295_i0 PRJNA603943 9485 516 1.785553 9.21345348 Acholeplasma sp. CAG:878 1262686 Bacteria Bacteria 359 2.7e-123   NR CCY27193.1 1262686 g9295 i0 99.4 0.994186046511628 171 1 99.4 0 2 514 3 173 CCY27193.1 putative transposase [Acholeplasma sp. CAG:878] diamond 513 359 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp. CAG:878
28374754 28374754 PRJNA603943_P_NODE_15006_length_428_cov_2.169014_g14814_i0 PRJNA603943 15006 428 2.169014 9.28337992 Mollicutes bacterium 37628 Bacteria Bacteria 133 4.13e-33   NR MDD7043363.1 37628 g14814 i0 54.4 0.953271028037383 136 56 91.1 2 39 428 187 322 MDD7043363.1 DUF262 domain-containing protein [Mollicutes bacterium] diamond 408 133 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28406501 28406501 PRJNA603943_P_NODE_63926_length_245_cov_0.895349_g63734_i0 PRJNA603943 63926 245 0.895349 2.19360505 Acholeplasma sp. 33015 Bacteria Bacteria 148 1.31e-41   NR MBS5778846.1 33015 g63734 i0 100 0.991836734693878 81 0 99.2 0 244 2 219 299 MBS5778846.1 acyltransferase [Acholeplasma sp.] diamond 243 148 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
28501201 28501201 PRJNA603943_P_NODE_42287_length_284_cov_1.246445_g42095_i0 PRJNA603943 42287 284 1.246445 3.5399038 Mollicutes bacterium 37628 Bacteria Bacteria 127 1.38e-32   NR MCI6216687.1 37628 g42095 i0 61.7 0.992957746478873 94 36 99.3 0 3 284 109 202 MCI6216687.1 putative DNA binding domain-containing protein [Mollicutes bacterium] diamond 282 127 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
28943488 28943488 PRJNA603943_P_NODE_7828_length_559_cov_1.757202_g7641_i0 PRJNA603943 7828 559 1.757202 9.82275918 Mollicutes bacterium 37628 Bacteria Bacteria 213 6.17e-63   NR MDD7043001.1 37628 g7641 i0 55.9 0.998211091234347 186 82 99.8 0 559 2 247 432 MDD7043001.1 DUF2075 domain-containing protein [Mollicutes bacterium] diamond 558 213 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
29303694 29303694 PRJNA603943_P_NODE_29489_length_331_cov_1.193798_g29297_i0 PRJNA603943 29489 331 1.193798 3.95147138 Bacillati 1783272 Bacteria Bacteria 87.8 4.88e-19   NR NLM33696.1 1898209 g29297 i0 80.4 0.833836858006042 46 9 41.7 0 324 187 117 162 NLM33696.1 type II CRISPR RNA-guided endonuclease Cas9 [Acholeplasmataceae bacterium] diamond 276 87.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30427954 30427954 PRJNA603943_P_NODE_33573_length_315_cov_1.268595_g33381_i0 PRJNA603943 33573 315 1.268595 3.99607425 Mollicutes bacterium 37628 Bacteria Bacteria 148 2.09e-40   NR MCI7788140.1 37628 g33381 i0 74.3 1 105 27 100 0 1 315 168 272 MCI7788140.1 hypothetical protein [Mollicutes bacterium] diamond 315 148 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30819973 30819973 PRJNA603943_P_NODE_44894_length_276_cov_1.137931_g44702_i0 PRJNA603943 44894 276 1.137931 3.14068956 Bacillati 1783272 Bacteria Bacteria 73.6 1.91e-13   NR MCI6216683.1 37628 g44702 i0 86.5 0.804347826086957 37 5 40.2 0 275 165 198 234 MCI6216683.1 hypothetical protein [Mollicutes bacterium] diamond 222 73.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30869822 30869822 PRJNA603943_P_NODE_55194_length_250_cov_0.870056_g55002_i0 PRJNA603943 55194 250 0.870056 2.17514 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 132 2.4099999999999993e-34   NR MCI7554039.1 2231116 g55002 i0 75.9 1.992 83 20 99.6 0 2 250 266 348 MCI7554039.1 polysaccharide deacetylase family protein [Mycoplasmatota bacterium] diamond 498 132 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
31262330 31262330 PRJNA603943_P_NODE_29935_length_329_cov_1.503906_g29743_i0 PRJNA603943 29935 329 1.503906 4.94785074 Bacillati 1783272 Bacteria Bacteria 193 1.1e-60   NR MCI7058681.1 37628 g29743 i0 88.1 2.98176291793313 109 13 99.4 0 3 329 21 129 MCI7058681.1 hypothetical protein [Mollicutes bacterium] diamond 981 193 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31691832 31691832 PRJNA603943_P_NODE_2757_length_865_cov_1.415404_g2602_i0 PRJNA603943 2757 865 1.415404 12.2432446 Mollicutes bacterium 37628 Bacteria Bacteria 288 1.5399999999999998e-88   NR MDD7043363.1 37628 g2602 i0 51.3 0.926011560693642 267 130 92.6 0 5 805 440 706 MDD7043363.1 DUF262 domain-containing protein [Mollicutes bacterium] diamond 801 288 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
31818292 31818292 PRJNA603943_P_NODE_1917_length_1000_cov_1.666667_g1780_i0 PRJNA603943 1917 1000 1.666667 16.66667 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 330 4.04e-102   NR MCR5114023.1 2053494 g1780 i0 53.5 1.983 331 151 98.4 3 3 986 406 736 MCR5114023.1 DEAD/DEAH box helicase family protein [Acholeplasmatales bacterium] diamond 1983 330 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
32103083 32103083 PRJNA603943_P_NODE_39578_length_293_cov_1.195455_g39386_i0 PRJNA603943 39578 293 1.195455 3.50268315 Mycoplasmopsis arginini 2094 Bacteria Bacteria 154 6.11e-41   NR WP_129694533.1 2094 g39386 i0 77.1 1.96587030716724 96 22 98.3 0 289 2 704 799 WP_129694533.1 type I restriction endonuclease subunit R [Mycoplasmopsis arginini] diamond 576 154 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32433016 32433016 PRJNA603943_P_NODE_68999_length_241_cov_2.291667_g68807_i0 PRJNA603943 68999 241 2.291667 5.52291747 Bacillati 1783272 Bacteria Bacteria 139 2.95e-36   NR WP_029512570.1 76630 g68807 i0 82.5 7.96680497925311 80 14 99.6 0 241 2 333 412 WP_029512570.1 type I restriction endonuclease subunit R [Mycoplasmopsis iners] diamond 1920 139 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis iners
32482960 32482960 PRJNA603943_P_NODE_42319_length_284_cov_1.094787_g42127_i0 PRJNA603943 42319 284 1.094787 3.10919508 Metamycoplasma hominis 2098 Bacteria Bacteria 75.9 1.37e-14   NR WP_305532010.1 2098 g42127 i0 100 3.12676056338028 37 0 39.1 0 3 113 157 193 WP_305532010.1 tyrosine-type recombinase/integrase [Metamycoplasma hominis] diamond 888 75.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma hominis

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