RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1034994" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1034994 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
28140869 28140869 PRJNA1034994_P_NODE_5765_length_260_cov_1.647059_g5681_i0 PRJNA1034994 5765 260 1.647059 4.2823534 Myxococcota bacterium 2818507 Bacteria Bacteria 84.7 1.3e-18   NR MEZ0310588.1 2818507 g5681 i0 91.1 1.03846153846154 45 4 51.9 0 124 258 1 45 MEZ0310588.1 PilZ domain-containing protein [Myxococcota bacterium] diamond 270 84.7 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
29877331 29877331 PRJNA1034994_P_NODE_5691_length_261_cov_1.393617_g5607_i0 PRJNA1034994 5691 261 1.393617 3.63734037 Myxococcus sp. 1929279 Bacteria Bacteria 40.4 0.0418   NR MBE2251368.1 1929279 g5607 i0 33.9 0.64367816091954 56 36 64.4 1 215 48 1 55 MBE2251368.1 hypothetical protein [Myxococcus sp.] diamond 168 40.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus sp.
30224663 30224663 PRJNA1034994_P_NODE_5832_length_259_cov_2.252688_g5748_i0 PRJNA1034994 5832 259 2.252688 5.83446192 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 43.9 0.0147   NR MBN1662851.1 2026735 g5748 i0 32.9 0.94980694980695 82 49 92.7 3 257 18 3 80 MBN1662851.1 class I SAM-dependent methyltransferase [Deltaproteobacteria bacterium] diamond 246 43.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
30730227 30730227 PRJNA1034994_P_NODE_9394_length_243_cov_0.905882_g9310_i0 PRJNA1034994 9394 243 0.905882 2.20129326 Myxococcales bacterium 2026763 Bacteria Bacteria 50.4 7.19e-5   NR MCA9518135.1 2026763 g9310 i0 44.6 0.691358024691358 56 31 69.1 0 202 35 512 567 MCA9518135.1 cation:proton antiporter [Myxococcales bacterium] diamond 168 50.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31267467 31267467 PRJNA1034994_P_NODE_8855_length_245_cov_0.895349_g8771_i0 PRJNA1034994 8855 245 0.895349 2.19360505 Myxococcales bacterium 2026763 Bacteria Bacteria 53.5 5.91e-6   NR MBK7395401.1 2026763 g8771 i0 41.6 0.942857142857143 77 45 94.3 0 4 234 325 401 MBK7395401.1 hypothetical protein [Myxococcales bacterium] diamond 231 53.5 1 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);;