RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJEB64798" 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

  • PRJEB64798 · 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
12883237 12883237 PRJEB64798_P_NODE_79351_length_216_cov_1.616766_g77585_i0 PRJEB64798 79351 216 1.616766 3.49221456 FCB group 1783270 Bacteria Bacteria 134 4.42e-37   NR NLD79504.1 37628 g77585 i0 87 1.91666666666667 69 9 95.8 0 5 211 20 88 NLD79504.1 site-specific DNA-methyltransferase [Mollicutes bacterium] diamond 414 135 0.992592592592593 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
12883459 12883459 PRJEB64798_P_NODE_93831_length_212_cov_4.748466_g92065_i0 PRJEB64798 93831 212 4.748466 10.06674792 Bacteria 2 Bacteria Bacteria 99 1.9099999999999998e-23   NR WP_035375658.1 29552 g92065 i0 72.2 7.07547169811321 72 17 97.6 1 208 2 124 195 WP_035375658.1 metal ABC transporter ATP-binding protein [Haploplasma axanthum] diamond 1500 100 0.99 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Haploplasma Haploplasma axanthum
26653532 26653532 PRJEB64798_P_NODE_135501_length_195_cov_16.150685_g133735_i0 PRJEB64798 135501 195 16.150685 31.49383575 Candidatus Izimaplasma bacterium HR2 1541960 Bacteria Bacteria 56.6 2.49e-7   NR KFZ26326.1 1541960 g133735 i0 70.3 0.569230769230769 37 11 56.9 0 2 112 819 855 KFZ26326.1 MAG: anaerobic ribonucleoside triphosphate reductase [Candidatus Izimaplasma bacterium HR2] diamond 111 56.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR2
27096888 27096888 PRJEB64798_P_NODE_168782_length_179_cov_4.500000_g167016_i0 PRJEB64798 168782 179 4.5 8.055 Mycoplasmopsis arginini 2094 Bacteria Bacteria 94.4 3.13e-22   NR WP_282460127.1 2094 g167016 i0 100 0.770949720670391 46 0 77.1 0 7 144 162 207 WP_282460127.1 DUF1071 domain-containing protein [Mycoplasmopsis arginini] diamond 138 94.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28107527 28107527 PRJEB64798_P_NODE_238885_length_155_cov_8.556604_g237119_i0 PRJEB64798 238885 155 8.556604 13.2627362 Mycoplasmopsis arginini 2094 Bacteria Bacteria 57.8 1.3e-8   NR WP_282460024.1 2094 g237119 i0 68.3 0.793548387096774 41 13 79.4 0 3 125 37 77 WP_282460024.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 123 57.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28170831 28170831 PRJEB64798_P_NODE_227686_length_159_cov_11.272727_g225920_i0 PRJEB64798 227686 159 11.272727 17.92363593 Mycoplasmopsis arginini 2094 Bacteria Bacteria 97.4 2.73e-24   NR WP_282459170.1 2094 g225920 i0 97.9 0.905660377358491 48 1 90.6 0 14 157 1 48 WP_282459170.1 hypothetical protein [Mycoplasmopsis arginini] diamond 144 97.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28612918 28612918 PRJEB64798_P_NODE_253307_length_150_cov_6.356436_g251541_i0 PRJEB64798 253307 150 6.356436 9.534654 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 86.7 6.52e-19   NR MFO7969629.1 3018265 g251541 i0 81.6 1.96 49 9 98 0 149 3 77 125 MFO7969629.1 site-specific DNA-methyltransferase [Candidatus Izemoplasmatales bacterium] diamond 294 86.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
28897015 28897015 PRJEB64798_P_NODE_78628_length_217_cov_1.851190_g76862_i0 PRJEB64798 78628 217 1.85119 4.0170823 Mycoplasmopsis arginini 2094 Bacteria Bacteria 104 2.3300000000000004e-27   NR WP_282459943.1 2094 g76862 i0 86.8 0.732718894009217 53 7 73.3 0 217 59 31 83 WP_282459943.1 Ty3/Gypsy family RNase HI domain-containing protein, partial [Mycoplasmopsis arginini] diamond 159 104 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
28928496 28928496 PRJEB64798_P_NODE_149568_length_188_cov_16.978417_g147802_i0 PRJEB64798 149568 188 16.978417 31.91942396 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 98.2 1.15e-22   NR HXN54616.1 2023991 g147802 i0 80.3 0.973404255319149 61 12 97.3 0 4 186 191 251 HXN54616.1 F0F1 ATP synthase subunit alpha [Mycoplasmatales bacterium] diamond 183 98.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
29212937 29212937 PRJEB64798_P_NODE_192009_length_169_cov_10.608333_g190243_i0 PRJEB64798 192009 169 10.608333 17.92808277 Mycoplasmopsis arginini 2094 Bacteria Bacteria 100 2.07e-25   NR WP_282457347.1 2094 g190243 i0 81.8 0.976331360946746 55 10 97.6 0 165 1 56 110 WP_282457347.1 hypothetical protein [Mycoplasmopsis arginini] diamond 165 100 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29402302 29402302 PRJEB64798_P_NODE_77109_length_219_cov_5.441176_g75343_i0 PRJEB64798 77109 219 5.441176 11.91617544 Candidatus Izimaplasma bacterium HR1 1541959 Bacteria Bacteria 73.2 3.78e-13   NR AIO18144.1 1541959 g75343 i0 52.2 1.9041095890411 69 29 89 1 199 5 71 139 AIO18144.1 hypothetical protein KQ51_00241 [Candidatus Izimaplasma bacterium HR1] diamond 417 73.2 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR1
29464948 29464948 PRJEB64798_P_NODE_210530_length_164_cov_11.878261_g208764_i0 PRJEB64798 210530 164 11.878261 19.48034804 Spiroplasma eriocheiris CCTCC M 2 315358 Bacteria Bacteria 39.7 0.0392   NR AHF57818.1 743698 g208764 i0 80 0.365853658536585 20 4 36.6 0 63 4 18 37 AHF57818.1 hypothetical protein SPE_0693 [Spiroplasma eriocheiris CCTCC M 207170] diamond 60 39.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma eriocheiris
29812679 29812679 PRJEB64798_P_NODE_98931_length_212_cov_3.319018_g97165_i0 PRJEB64798 98931 212 3.319018 7.03631816 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 72.8 6.23e-13   NR NLH45752.1 1898209 g97165 i0 48.4 3.89150943396226 91 24 96.2 1 6 209 353 443 NLH45752.1 4Fe-4S binding protein [Acholeplasmataceae bacterium] diamond 825 72.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
30255291 30255291 PRJEB64798_P_NODE_239352_length_155_cov_5.783019_g237586_i0 PRJEB64798 239352 155 5.783019 8.96367945 Mollicutes bacterium 37628 Bacteria Bacteria 45.4 0.00123   NR NLA32546.1 37628 g237586 i0 47.6 1.6258064516129 42 22 81.3 0 27 152 257 298 NLA32546.1 hypothetical protein [Mollicutes bacterium] diamond 252 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30728988 30728988 PRJEB64798_P_NODE_90214_length_212_cov_6.773006_g88448_i0 PRJEB64798 90214 212 6.773006 14.35877272 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 48.9 1.55e-4   NR MBR6071484.1 2053494 g88448 i0 44.6 0.792452830188679 56 24 69.3 2 148 2 1 56 MBR6071484.1 ACP S-malonyltransferase [Acholeplasmatales bacterium] diamond 168 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
30918540 30918540 PRJEB64798_P_NODE_148294_length_189_cov_4.921429_g146528_i0 PRJEB64798 148294 189 4.921429 9.30150081 Mesomycoplasma ovipneumoniae 29562 Bacteria Bacteria 99.8 6.55e-25   NR WP_337904022.1 29562 g146528 i0 65.2 1.41269841269841 89 4 98.4 1 188 3 40 128 WP_337904022.1 hypothetical protein, partial [Mesomycoplasma ovipneumoniae] diamond 267 99.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mesomycoplasma Mesomycoplasma ovipneumoniae
30950211 30950211 PRJEB64798_P_NODE_212294_length_164_cov_2.486957_g210528_i0 PRJEB64798 212294 164 2.486957 4.07860948 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 50.1 2.94e-5   NR MBQ3253698.1 2053494 g210528 i0 48.8 0.786585365853659 43 22 78.7 0 27 155 130 172 MBQ3253698.1 tyrosine-protein phosphatase [Acholeplasmatales bacterium] diamond 129 50.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
31361011 31361011 PRJEB64798_P_NODE_139436_length_193_cov_24.611111_g137670_i0 PRJEB64798 139436 193 24.611111 47.49944423 Mycoplasmopsis arginini 2094 Bacteria Bacteria 71.6 1.22e-14   NR WP_282459920.1 2094 g137670 i0 96.9 0.49740932642487 32 1 49.7 0 2 97 27 58 WP_282459920.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 96 71.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31424078 31424078 PRJEB64798_P_NODE_130316_length_198_cov_4.214765_g128550_i0 PRJEB64798 130316 198 4.214765 8.3452347 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 48.5 1.55e-4   NR QVK21142.1 2231116 g128550 i0 50 0.727272727272727 48 21 72.7 1 53 196 181 225 QVK21142.1 3-oxoacyl-[acyl-carrier-protein] reductase [Mycoplasmatota bacterium] diamond 144 48.5 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
31519213 31519213 PRJEB64798_P_NODE_187876_length_171_cov_3.549180_g186110_i0 PRJEB64798 187876 171 3.54918 6.0690978 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 82.4 1.88e-17   NR HHX81287.1 1898209 g186110 i0 74.1 0.947368421052632 54 14 94.7 0 164 3 131 184 HHX81287.1 site-specific DNA-methyltransferase [Acholeplasmataceae bacterium] diamond 162 82.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31803700 31803700 PRJEB64798_P_NODE_51097_length_274_cov_3.080000_g49332_i0 PRJEB64798 51097 274 3.08 8.4392 Mycoplasmopsis arginini 2094 Bacteria Bacteria 107 3.5700000000000005e-27   NR WP_282460024.1 2094 g49332 i0 71.2 0.722627737226277 66 19 72.3 0 272 75 10 75 WP_282460024.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 198 107 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31835181 31835181 PRJEB64798_P_NODE_169517_length_179_cov_2.123077_g167751_i0 PRJEB64798 169517 179 2.123077 3.80030783 Mycoplasmopsis arginini 2094 Bacteria Bacteria 51.6 1.11e-5   NR WP_282460165.1 2094 g167751 i0 42.1 0.955307262569832 57 33 95.5 0 171 1 164 220 WP_282460165.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 171 51.6 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32120289 32120289 PRJEB64798_P_NODE_203278_length_166_cov_7.820513_g201512_i0 PRJEB64798 203278 166 7.820513 12.98205158 Acholeplasma sp. 33015 Bacteria Bacteria 50.4 2.4e-5   NR HHT55629.1 33015 g201512 i0 42.3 0.939759036144578 52 30 94 0 156 1 123 174 HHT55629.1 hypothetical protein [Acholeplasma sp.] diamond 156 50.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
32783534 32783534 PRJEB64798_P_NODE_88780_length_212_cov_8.337423_g87014_i0 PRJEB64798 88780 212 8.337423 17.67533676 Acholeplasma sp. 33015 Bacteria Bacteria 40.8 0.0312   NR MBS5778527.1 33015 g87014 i0 63 0.382075471698113 27 10 38.2 0 196 116 3 29 MBS5778527.1 ribosomal-processing cysteine protease Prp [Acholeplasma sp.] diamond 81 40.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.

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