RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA879067" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879067 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
11057393 11057393 PRJNA879067_P_NODE_100289_length_261_cov_1.648936_g96803_i0 PRJNA879067 100289 261 1.648936 4.30372296 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 103 2.5699999999999997e-24   NR MCI6107433.1 2231116 g96803 i0 98.3 0.67816091954023 59 1 67.8 0 177 1 1 59 MCI6107433.1 hypothetical protein [Mycoplasmatota bacterium] diamond 177 103 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
18707440 18707440 PRJNA879067_P_NODE_76955_length_352_cov_5.046595_g73469_i0 PRJNA879067 76955 352 5.046595 17.7640144 Areca yellow leaf disease phytoplasma 927614 Bacteria Bacteria 145 1.87e-41   NR WP_374695591.1 927614 g73469 i0 67 0.903409090909091 106 35 90.3 0 29 346 72 177 WP_374695591.1 hypothetical protein [Areca yellow leaf disease phytoplasma] diamond 318 145 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Candidatus Phytoplasma Areca yellow leaf disease phytoplasma
27276651 27276651 PRJNA879067_P_NODE_81883_length_331_cov_1.492248_g78397_i0 PRJNA879067 81883 331 1.492248 4.93934088 Mycoplasmatota bacterium 2231116 Bacteria Bacteria 64.7 4.86e-10   NR MCI6627448.1 2231116 g78397 i0 46.3 0.725075528700906 80 38 70.7 2 262 29 94 170 MCI6627448.1 zinc dependent phospholipase C family protein [Mycoplasmatota bacterium] diamond 240 64.7 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium
27442812 27442812 PRJNA879067_P_NODE_111183_length_241_cov_0.916667_g107697_i0 PRJNA879067 111183 241 0.916667 2.20916747 Acholeplasma 2147 Bacteria Bacteria 104 1.86e-24   NR MFA7417061.1 33015 g107697 i0 65.2 4.28215767634855 69 24 85.9 0 208 2 1 69 MFA7417061.1 cysteine desulfurase [Acholeplasma sp.] diamond 1032 104 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae Acholeplasma Acholeplasma sp.
28318544 28318544 PRJNA879067_P_NODE_91726_length_292_cov_1.374429_g88240_i0 PRJNA879067 91726 292 1.374429 4.01333268 Mollicutes bacterium 37628 Bacteria Bacteria 167 1.5199999999999999e-46   NR MCI6788985.1 37628 g88240 i0 96.7 0.934931506849315 91 3 93.5 0 291 19 290 380 MCI6788985.1 ABC transporter ATP-binding protein/permease [Mollicutes bacterium] diamond 273 167 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30908489 30908489 PRJNA879067_P_NODE_26734_length_829_cov_4.728836_g23507_i0 PRJNA879067 26734 829 4.728836 39.20205044 Mollicutes bacterium 37628 Bacteria Bacteria 503 5.049999999999998e-170   NR MCI6788722.1 37628 g23507 i0 99.2 0.915560916767189 253 2 91.6 0 807 49 1 253 MCI6788722.1 Ig-like domain-containing protein [Mollicutes bacterium] diamond 759 503 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium

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