RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA998413" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA998413 · 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
11477737 11477737 PRJNA998413_S_NODE_10329_length_220_cov_1.324841_g10298_i0 PRJNA998413 10329 220 1.324841 2.9146502 Microbacterium esteraromaticum 57043 Bacteria Bacteria 144 1.0899999999999998e-41   NR PYC99494.1 57043 g10298 i0 98.6 0.995454545454545 73 1 99.5 0 220 2 82 154 PYC99494.1 hypothetical protein B4U78_016800, partial [Microbacterium esteraromaticum] diamond 219 144 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
30247926 30247926 PRJNA998413_S_NODE_12392_length_212_cov_0.899329_g12361_i0 PRJNA998413 12392 212 0.899329 1.90657748 Microbacterium esteraromaticum 57043 Bacteria Bacteria 92 3.82e-22   NR PYC99673.1 57043 g12361 i0 97.8 0.650943396226415 46 1 65.1 0 138 1 1 46 PYC99673.1 hypothetical protein B4U78_015020 [Microbacterium esteraromaticum] diamond 138 92 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
31575291 31575291 PRJNA998413_S_NODE_7836_length_240_cov_1.135593_g7805_i0 PRJNA998413 7836 240 1.135593 2.7254232 Microbacterium esteraromaticum 57043 Bacteria Bacteria 58.9 1.76e-8   NR PYC99674.1 57043 g7805 i0 39 0.7375 59 36 73.8 0 1 177 61 119 PYC99674.1 hypothetical protein B4U78_015025 [Microbacterium esteraromaticum] diamond 177 58.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
31859650 31859650 PRJNA998413_S_NODE_13657_length_205_cov_3.302817_g13626_i0 PRJNA998413 13657 205 3.302817 6.77077485 Pseudarthrobacter sp. NPDC 1934409 Bacteria Bacteria 55.8 5.23e-7   NR WP_400609128.1 3364415 g13626 i0 69.7 1.50731707317073 33 10 48.3 0 3 101 637 669 WP_400609128.1 HNH endonuclease signature motif containing protein [Pseudarthrobacter sp. NPDC092424] diamond 309 55.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter sp. NPDC092424
32530326 32530326 PRJNA998413_S_NODE_12619_length_211_cov_1.101351_g12588_i0 PRJNA998413 12619 211 1.101351 2.32385061 Bacillati 1783272 Bacteria Bacteria 152 9.58e-44   NR PYC99595.1 57043 g12588 i0 98.6 1.99052132701422 70 1 99.5 0 211 2 44 113 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 420 152 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
32562028 32562028 PRJNA998413_S_NODE_6039_length_259_cov_1.709184_g6008_i0 PRJNA998413 6039 259 1.709184 4.42678656 Bacillati 1783272 Bacteria Bacteria 145 1.6799999999999994e-42   NR PYC99569.1 57043 g6008 i0 98.6 1.69111969111969 73 1 84.6 0 220 2 1 73 PYC99569.1 hypothetical protein B4U78_016165, partial [Microbacterium esteraromaticum] diamond 438 146 0.993150684931507 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum

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