RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB81327" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81327 · 4 ✖

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
23949403 23949403 PRJEB81327_P_NODE_34819_length_270_cov_1.294416_g34211_i0 PRJEB81327 34819 270 1.294416 3.4949232 Mycoplasmopsis 2767358 Bacteria Bacteria 499 7.349999999999998e-137   NTclustered gi|1874468068|gb|CP058969.1| 28903 g34211 i0 100 100.007407407407 270 0 100 0 1 270 519833 519564 Mycoplasmopsis bovis strain 1982-M6152 chromosome blastn 27002 499 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
24365672 24365672 PRJEB81327_P_NODE_39120_length_262_cov_3.058201_g38512_i0 PRJEB81327 39120 262 3.058201 8.01248662 Mollicutes bacterium 37628 Bacteria Bacteria 173 1.33e-49   NR MCI6793220.1 37628 g38512 i0 98.9 0.99618320610687 87 1 99.6 0 2 262 401 487 MCI6793220.1 NADPH-dependent glutamate synthase [Mollicutes bacterium] diamond 261 173 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
29244852 29244852 PRJEB81327_P_NODE_43289_length_255_cov_2.604396_g42681_i0 PRJEB81327 43289 255 2.604396 6.6412098 Mollicutes bacterium 37628 Bacteria Bacteria 167 2.07e-46   NR MCI7133098.1 37628 g42681 i0 100 0.988235294117647 84 0 98.8 0 3 254 406 489 MCI7133098.1 hypothetical protein [Mollicutes bacterium] diamond 252 167 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium
30255766 30255766 PRJEB81327_P_NODE_28292_length_281_cov_2.192308_g27684_i0 PRJEB81327 28292 281 2.192308 6.16038548 Acholeplasmatales bacterium 2053494 Bacteria Bacteria 132 2.7399999999999996e-35   NR MBR6289321.1 2053494 g27684 i0 65.6 0.99288256227758 93 32 99.3 0 2 280 90 182 MBR6289321.1 hypothetical protein [Acholeplasmatales bacterium] diamond 279 132 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales     Acholeplasmatales 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);;