RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA615351" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA615351 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
26668671 26668671 PRJNA615351_P_NODE_27321_length_1210_cov_3.395745_g19895_i0 PRJNA615351 27321 1210 3.395745 41.0885145 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 163 2.4899999999999996e-43   NR MBO5711271.1 2053494 g19895 i0 36.8 2.93553719008264 266 140 63.2 9 1133 369 7 255 MBO5711271.1 glycoside hydrolase family 16 protein [Acholeplasmatales bacterium] diamond 3552 163 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
27187978 27187978 PRJNA615351_P_NODE_123862_length_240_cov_1.907317_g109762_i0 PRJNA615351 123862 240 1.907317 4.5775608 PVC group 1783257 Bacteria Bacteria 45.1 0.00556   NR WP_022935968.1 2121 g109762 i0 31.6 3.775 79 53 98.8 1 2 238 240 317 WP_022935968.1 leucine-rich repeat protein [Metamycoplasma orale] diamond 906 45.1 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Metamycoplasma Metamycoplasma orale
27554013 27554013 PRJNA615351_P_NODE_111984_length_273_cov_4.058824_g97885_i0 PRJNA615351 111984 273 4.058824 11.08058952 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 43.1 0.0379   NR MBQ2472582.1 2053494 g97885 i0 32.9 0.802197802197802 73 49 80.2 0 5 223 365 437 MBQ2472582.1 leucine-rich repeat domain-containing protein [Acholeplasmatales bacterium] diamond 219 43.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales bacterium
27820058 27820058 PRJNA615351_P_NODE_77024_length_446_cov_2.226277_g63009_i0 PRJNA615351 77024 446 2.226277 9.92919542 Mollicutes 31969 Bacteria Bacteria 90.1 2.4e-18   NR WP_063626152.1 29557 g63009 i0 46 1.72869955156951 87 40 58.5 1 185 445 21 100 WP_063626152.1 prolyl aminopeptidase [Mycoplasmopsis gallinarum] diamond 771 90.5 0.995580110497237 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis gallinarum
28312324 28312324 PRJNA615351_P_NODE_83426_length_403_cov_4.513587_g69371_i0 PRJNA615351 83426 403 4.513587 18.18975561 Candidatus Moeniiplasma glomeromycotorum 1822367 Bacteria Bacteria 52 4.93e-5   NR MCE8162780.1 1822367 g69371 i0 30.2 0.863523573200993 116 64 86.4 3 17 364 80 178 MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum] diamond 348 52 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Candidatus Moeniiplasma Candidatus Moeniiplasma glomeromycotorum
28924818 28924818 PRJNA615351_P_NODE_23828_length_1320_cov_4.565759_g17347_i0 PRJNA615351 23828 1320 4.565759 60.2680188 Bacillati 1783272 Bacteria Bacteria 50.8 0.00627   NR OHE25112.1 1802344 g17347 i0 27.6 0.629545454545455 145 97 33 3 479 913 46 182 OHE25112.1 MAG: hypothetical protein A2Z84_06490 [Tenericutes bacterium GWA2_35_7] diamond 831 51.2 0.9921875 Bacteria   Bacillati Mycoplasmatota         Tenericutes bacterium GWA2_35_7
29385864 29385864 PRJNA615351_P_NODE_78369_length_436_cov_2.947631_g64344_i0 PRJNA615351 78369 436 2.947631 12.85167116 Malacoplasma sp. 2791014 Bacteria Bacteria 56.2 5.33e-6   NR MCF0227855.1 2791014 g64344 i0 39.3 0.612385321100917 89 50 59.9 2 337 77 195 281 MCF0227855.1 leucine-rich repeat domain-containing protein [Malacoplasma sp.] diamond 267 56.2 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Malacoplasma sp.
32559747 32559747 PRJNA615351_P_NODE_133339_length_219_cov_1.521739_g119239_i0 PRJNA615351 133339 219 1.521739 3.33260841 Bacillati 1783272 Bacteria Bacteria 106 9.999999999999999e-27   NR AFH37498.1 42094 g119239 i0 73.6 66.0547945205479 72 19 98.6 0 217 2 93 164 AFH37498.1 elongation factor Tu, partial [Ureaplasma diversum] diamond 14466 107 0.990654205607477 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma diversum

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