RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA431371" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA431371 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
19554105 19554105 PRJNA431371_P_NODE_236_length_1456_cov_9.483008_g198_i0 PRJNA431371 236 1456 9.483008 138.07259648 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 211 8.89e-60   NR HXN54584.1 2023991 g198 i0 38.4 0.725274725274725 352 217 72.5 0 63 1118 8 359 HXN54584.1 cytochrome b N-terminal domain-containing protein [Mycoplasmatales bacterium] diamond 1056 211 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
19554235 19554235 PRJNA431371_P_NODE_2996_length_646_cov_1.516579_g2923_i0 PRJNA431371 2996 646 1.516579 9.79710034 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 145 4.75e-39   NR HXN54415.1 2023991 g2923 i0 45.8 0.882352941176471 190 101 88.2 2 8 577 50 237 HXN54415.1 50S ribosomal protein L2 [Mycoplasmatales bacterium] diamond 570 145 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales bacterium
27107175 27107175 PRJNA431371_P_NODE_20502_length_282_cov_1.473684_g20429_i0 PRJNA431371 20502 282 1.473684 4.15578888 Mycoplasmatales bacterium 2023991 Bacteria Bacteria 84 3.09e-18   NR HXN54412.1 2023991 g20429 i0 54.1 0.787234042553192 74 34 78.7 0 5 226 21 94 HXN54412.1 50S ribosomal protein L16 [Mycoplasmatales bacterium] diamond 222 84 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales     Mycoplasmatales 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);;