RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA951810 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27436861 27436861 PRJNA951810_P_NODE_96443_length_294_cov_8.651584_g96099_i0 PRJNA951810 96443 294 8.651584 25.43565696 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 116 2.4699999999999997e-30   NR NLB84923.1 1898209 g96099 i0 73.3 0.76530612244898 75 20 76.5 0 68 292 3 77 NLB84923.1 polyribonucleotide nucleotidyltransferase [Acholeplasmataceae bacterium] diamond 225 116 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
28573189 28573189 PRJNA951810_P_NODE_66907_length_310_cov_2.510549_g66564_i0 PRJNA951810 66907 310 2.510549 7.7827019 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 54.3 6.88e-6   NR NLH46424.1 1898209 g66564 i0 40.9 1.71290322580645 88 42 75.5 3 308 75 207 294 NLH46424.1 TonB-dependent receptor [Acholeplasmataceae bacterium] diamond 531 54.3 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae bacterium
29173303 29173303 PRJNA951810_P_NODE_32609_length_349_cov_4.369565_g32267_i0 PRJNA951810 32609 349 4.369565 15.24978185 Mycoplasma sp. CAG:472 1262904 Bacteria Bacteria 63.5 1.85e-9   NR CDE37919.1 1262904 g32267 i0 42.3 0.833810888252149 97 44 73.9 4 11 268 108 203 CDE37919.1 ribulose-phosphate 3-epimerase [Mycoplasma sp. CAG:472] diamond 291 63.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. CAG:472
29994230 29994230 PRJNA951810_P_NODE_16131_length_485_cov_2.883495_g15798_i0 PRJNA951810 16131 485 2.883495 13.98495075 Spiroplasma floricola 216937 Bacteria Bacteria 45.4 0.0321   NR WP_100916407.1 216937 g15798 i0 28 0.995876288659794 161 93 85.4 4 29 442 26 186 WP_100916407.1 hypothetical protein [Spiroplasma floricola] diamond 483 45.4 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma floricola
30720762 30720762 PRJNA951810_P_NODE_64034_length_310_cov_2.970464_g63691_i0 PRJNA951810 64034 310 2.970464 9.2084384 Mycoplasmataceae bacterium 2685873 Bacteria Bacteria 65.5 6.94e-11   NR WNE40183.1 2685873 g63691 i0 62.5 0.464516129032258 48 18 46.5 0 3 146 27 74 WNE40183.1 MAG: hypothetical protein GBAus27B_000250 [Mycoplasmataceae bacterium] diamond 144 65.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae   Mycoplasmataceae bacterium
32530153 32530153 PRJNA951810_P_NODE_62479_length_310_cov_3.198312_g62136_i0 PRJNA951810 62479 310 3.198312 9.9147672 FCB group 1783270 Bacteria Bacteria 97.8 8.01e-22   NR WP_129725445.1 171281 g62136 i0 50.9 6.48387096774194 112 44 98.7 3 308 3 103 213 WP_129725445.1 DNA adenine methylase [Mycoplasmopsis citelli] diamond 2010 98.2 0.995926680244399 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis citelli
32624393 32624393 PRJNA951810_P_NODE_166100_length_245_cov_4.854651_g165755_i0 PRJNA951810 166100 245 4.854651 11.89389495 FCB group 1783270 Bacteria Bacteria 62.4 4.43e-9   NR WP_262095948.1 69473 g165755 i0 45.3 5.36326530612245 64 30 75.9 2 243 58 270 330 WP_262095948.1 glycoside hydrolase family 30 protein [Paracholeplasma vituli] diamond 1314 62.8 0.993630573248408 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Paracholeplasma Paracholeplasma vituli

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