RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA630162 · 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
27030126 27030126 PRJNA630162_P_NODE_140882_length_167_cov_0.881356_g139359_i0 PRJNA630162 140882 167 0.881356 1.47186452 Bacillati 1783272 Bacteria Bacteria 41.6 0.0299   NR WP_027048000.1 225999 g139359 i0 58.1 1.16766467065868 31 13 55.7 0 160 68 177 207 WP_027048000.1 ribonuclease HII [Mesoplasma syrphidae] diamond 195 41.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma syrphidae
27270407 27270407 PRJNA630162_P_NODE_80663_length_200_cov_3.450331_g79140_i0 PRJNA630162 80663 200 3.450331 6.900662 Candidatus Phytoplasma australasiaticum 2754999 Bacteria Bacteria 133 5.34e-36   NR MDV3143244.1 101513 g79140 i0 93.8 0.975 65 4 97.5 0 6 200 56 120 MDV3143244.1 major capsid protein [Candidatus Phytoplasma australasiaticum subsp. ipomoeae] diamond 195 133 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Candidatus Phytoplasma australasiaticum
28154716 28154716 PRJNA630162_P_NODE_133565_length_168_cov_2.672269_g132042_i0 PRJNA630162 133565 168 2.672269 4.48941192 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 54.3 1.16e-6   NR MCK9234761.1 1898209 g132042 i0 48.1 1.91071428571429 54 28 96.4 0 7 168 525 578 MCK9234761.1 hypothetical protein [Acholeplasmataceae bacterium] diamond 321 54.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28691590 28691590 PRJNA630162_P_NODE_32287_length_317_cov_1.511194_g30765_i0 PRJNA630162 32287 317 1.511194 4.79048498 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 72.4 3.16e-12   NR HXN54563.1 2023991 g30765 i0 64.7 0.482649842271293 51 18 48.3 0 165 317 276 326 HXN54563.1 NADH-quinone oxidoreductase subunit M [Mycoplasmatales bacterium] diamond 153 72.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
28944182 28944182 PRJNA630162_P_NODE_132748_length_169_cov_0.866667_g131225_i0 PRJNA630162 132748 169 0.866667 1.46466723 Paracholeplasma manati 591373 Bacteria Bacteria 45.8 0.00104   NR WP_277618472.1 591373 g131225 i0 50 1.77514792899408 50 25 88.8 0 152 3 97 146 WP_277618472.1 ankyrin repeat domain-containing protein [Paracholeplasma manati] diamond 300 45.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Paracholeplasma Paracholeplasma manati
29575068 29575068 PRJNA630162_P_NODE_107590_length_181_cov_1.530303_g106067_i0 PRJNA630162 107590 181 1.530303 2.76984843 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 75.1 5.22e-15   NR MDD5293965.1 3018265 g106067 i0 60 0.994475138121547 60 24 99.4 0 181 2 70 129 MDD5293965.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 180 75.1 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
29638087 29638087 PRJNA630162_P_NODE_100870_length_185_cov_1.588235_g99347_i0 PRJNA630162 100870 185 1.588235 2.93823475 Mycoplasma capricolum subsp. capricolum 40479 Bacteria Bacteria 49.3 8.02e-6   NR KKW61742.1 40479 g99347 i0 46.9 0.794594594594595 49 25 77.8 1 175 32 2 50 KKW61742.1 Prolipoprotein [Mycoplasma capricolum subsp. capricolum] diamond 147 49.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma capricolum
30554400 30554400 PRJNA630162_P_NODE_107233_length_181_cov_1.969697_g105710_i0 PRJNA630162 107233 181 1.969697 3.56515157 Candidatus Izemoplasmatales bacterium 3018265 Bacteria Bacteria 46.6 6.39e-4   NR MDD4988376.1 3018265 g105710 i0 48.9 0.74585635359116 45 23 74.6 0 154 20 46 90 MDD4988376.1 hypothetical protein [Candidatus Izemoplasmatales bacterium] diamond 135 46.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales     Candidatus Izemoplasmatales bacterium
31281318 31281318 PRJNA630162_P_NODE_145355_length_165_cov_3.508621_g143832_i0 PRJNA630162 145355 165 3.508621 5.78922465 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 41.6 0.0324   NR HXN54509.1 2023991 g143832 i0 60.6 0.6 33 13 60 0 160 62 85 117 HXN54509.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmatales bacterium] diamond 99 41.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
32609834 32609834 PRJNA630162_P_NODE_105100_length_182_cov_3.105263_g103577_i0 PRJNA630162 105100 182 3.105263 5.65157866 Ureaplasma urealyticum serovar 5 str. ATCC 27817 518603 Bacteria Bacteria 45.4 2.63e-4   NR EDU05938.1 518603 g103577 i0 75 0.461538461538462 28 7 46.2 0 62 145 29 56 EDU05938.1 hypothetical protein UUR5_0008 [Ureaplasma urealyticum serovar 5 str. ATCC 27817] diamond 84 45.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Ureaplasma Ureaplasma urealyticum

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