RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB3181 · 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
29559464 29559464 PRJEB3181_P_NODE_28330_length_150_cov_1.075630_g28065_i0 PRJEB3181 28330 150 1.07563 1.613445 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 53.1 1.83e-6   NR MBI4516666.1 2026735 g28065 i0 56.6 1.06 53 17 96 3 149 6 103 154 MBI4516666.1 hypothetical protein [Deltaproteobacteria bacterium] diamond 159 53.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30064786 30064786 PRJEB3181_S_NODE_13972_length_173_cov_1.731884_g13679_i0 PRJEB3181 13972 173 1.731884 2.99615932 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 92.8 2.09e-21   NR TNF00051.1 2026735 g13679 i0 88.5 1.80346820809249 52 6 90.2 0 1 156 73 124 TNF00051.1 MAG: UMP kinase [Deltaproteobacteria bacterium] diamond 312 92.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
32303291 32303291 PRJEB3181_P_NODE_23239_length_168_cov_3.277372_g22974_i0 PRJEB3181 23239 168 3.277372 5.50598496 Myxococcia 32015 Bacteria Bacteria 59.3 4.82e-9   NR MBL92291.1 2026763 g22974 i0 65 3.60714285714286 40 14 71.4 0 1 120 129 168 MBL92291.1 peptidylprolyl isomerase [Myxococcales bacterium] diamond 606 59.7 0.993299832495812 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales 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);;