RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1067370" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1067370 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
5283746 5283746 PRJNA1067370_P_NODE_53785_length_289_cov_1.425926_g53236_i0 PRJNA1067370 53785 289 1.425926 4.12092614 Candidatus Phytoplasma citri 180978 Bacteria Bacteria 173 3.6e-52   NR MDO8079108.1 180978 g53236 i0 83 2.94809688581315 94 16 97.6 0 282 1 1 94 MDO8079108.1 hypothetical protein [Candidatus Phytoplasma citri] diamond 852 173 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma citri
27509698 27509698 PRJNA1067370_P_NODE_36323_length_331_cov_1.174419_g35775_i0 PRJNA1067370 36323 331 1.174419 3.88732689 Spiroplasma floricola 216937 Bacteria Bacteria 92.8 1.85e-20   NR WP_100916376.1 216937 g35775 i0 55.6 3.5166163141994 99 40 89.7 3 298 2 2 96 WP_100916376.1 SDR family oxidoreductase [Spiroplasma floricola] diamond 1164 92.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma floricola
27572788 27572788 PRJNA1067370_P_NODE_92544_length_247_cov_1.327586_g91995_i0 PRJNA1067370 92544 247 1.327586 3.27913742 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 45.8 0.00322   NR MFV0288246.1 2023991 g91995 i0 43.1 0.704453441295547 58 30 70.4 2 196 23 215 269 MFV0288246.1 hypothetical protein [Mycoplasmatales bacterium] diamond 174 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
27793871 27793871 PRJNA1067370_P_NODE_39804_length_320_cov_0.935223_g39256_i0 PRJNA1067370 39804 320 0.935223 2.9927136 Spiroplasma cantharicola 362837 Bacteria Bacteria 49.7 3.33e-4   NR ALD66451.1 362837 g39256 i0 30 0.9375 100 64 93.8 2 13 312 260 353 ALD66451.1 DNA uptake protein [Spiroplasma cantharicola] diamond 300 49.7 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma cantharicola
28046348 28046348 PRJNA1067370_P_NODE_7945_length_638_cov_1.794690_g7419_i0 PRJNA1067370 7945 638 1.79469 11.4501222 Mycoplasma feriruminatoris 1179777 Bacteria Bacteria 48.9 0.00759   NR WP_239759469.1 1179777 g7419 i0 27.4 1.06269592476489 226 115 90.8 11 40 618 200 409 WP_239759469.1 DUF2326 domain-containing protein [Mycoplasma feriruminatoris] diamond 678 48.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma feriruminatoris
28772465 28772465 PRJNA1067370_P_NODE_33307_length_342_cov_1.144981_g32759_i0 PRJNA1067370 33307 342 1.144981 3.91583502 Haloplasma contractile 471825 Bacteria Bacteria 79 9.27e-15   NR WP_008824560.1 471825 g32759 i0 36 2.87719298245614 111 70 97.4 1 1 333 165 274 WP_008824560.1 alpha/beta fold hydrolase [Haloplasma contractile] diamond 984 79 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Haloplasmatales Haloplasmataceae Haloplasma Haloplasma contractile
29435232 29435232 PRJNA1067370_P_NODE_108710_length_243_cov_0.905882_g108161_i0 PRJNA1067370 108710 243 0.905882 2.20129326 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 111 2.9500000000000003e-27   NR MCK9234933.1 1898209 g108161 i0 64.6 0.975308641975309 79 28 97.5 0 239 3 264 342 MCK9234933.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 237 111 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
31710711 31710711 PRJNA1067370_P_NODE_34537_length_337_cov_1.473485_g33989_i0 PRJNA1067370 34537 337 1.473485 4.96564445 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 101 4.7e-23   NR MDR1234481.1 2685873 g33989 i0 45.3 1.83382789317507 106 58 94.4 0 3 320 165 270 MDR1234481.1 NAD(P)-dependent alcohol dehydrogenase [Mycoplasmataceae bacterium] diamond 618 101 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
31868754 31868754 PRJNA1067370_P_NODE_43057_length_311_cov_0.987395_g42509_i0 PRJNA1067370 43057 311 0.987395 3.07079845 Candidatus Phytoplasma citri 180978 Bacteria Bacteria 100 2.58e-22   NR MDO8079048.1 180978 g42509 i0 50.9 1.04180064308682 108 46 97.4 2 306 4 254 361 MDO8079048.1 hypothetical protein [Candidatus Phytoplasma citri] diamond 324 100 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma citri
32216933 32216933 PRJNA1067370_P_NODE_113638_length_241_cov_0.916667_g113089_i0 PRJNA1067370 113638 241 0.916667 2.20916747 Candidatus Phytoplasma citri 180978 Bacteria Bacteria 73.9 3.55e-13   NR MDO8079048.1 180978 g113089 i0 48.1 1.00829875518672 81 40 98.3 1 241 5 254 334 MDO8079048.1 hypothetical protein [Candidatus Phytoplasma citri] diamond 243 73.9 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma citri

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