RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1005695" 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

  • PRJNA1005695 · 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
26963549 26963549 PRJNA1005695_P_NODE_32382_length_262_cov_1.587302_g31530_i0 PRJNA1005695 32382 262 1.587302 4.15873124 FCB group 1783270 Bacteria Bacteria 113 3.2200000000000004e-27   NR MBW2469189.1 2026735 g31530 i0 67.4 20.7137404580153 86 28 98.5 0 260 3 390 475 MBW2469189.1 histidine ammonia-lyase [Deltaproteobacteria bacterium] diamond 5427 113 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
27722462 27722462 PRJNA1005695_P_NODE_33064_length_259_cov_1.677419_g32212_i0 PRJNA1005695 33064 259 1.677419 4.34451521 Pseudomonadati 3379134 Bacteria Bacteria 90.1 1e-18   NR MBN1614873.1 2026735 g32212 i0 58.5 6.03474903474903 65 27 75.3 0 64 258 173 237 MBN1614873.1 insulinase family protein [Deltaproteobacteria bacterium] diamond 1563 90.5 0.995580110497237 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
29308097 29308097 PRJNA1005695_P_NODE_35709_length_251_cov_0.876404_g34857_i0 PRJNA1005695 35709 251 0.876404 2.19977404 Myxococcota bacterium 2818507 Bacteria Bacteria 78.6 9.93e-15   NR MDC1294945.1 2818507 g34857 i0 51.5 3.38247011952191 68 31 81.3 1 48 251 36 101 MDC1294945.1 long-chain-acyl-CoA synthetase [Myxococcota bacterium] diamond 849 78.6 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
30824335 30824335 PRJNA1005695_P_NODE_35554_length_251_cov_0.876404_g34702_i0 PRJNA1005695 35554 251 0.876404 2.19977404 Polyangiaceae bacterium 2268199 Bacteria Bacteria 62.8 2.12e-9   NR HSQ67871.1 2268199 g34702 i0 43.2 0.968127490039841 81 45 96.8 1 243 1 78 157 HSQ67871.1 hypothetical protein [Polyangiaceae bacterium] diamond 243 62.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
32121025 32121025 PRJNA1005695_P_NODE_37018_length_248_cov_0.891429_g36166_i0 PRJNA1005695 37018 248 0.891429 2.21074392 Myxococcota bacterium 2818507 Bacteria Bacteria 44.3 0.0109   NR MEL7369692.1 2818507 g36166 i0 35.4 0.991935483870968 82 52 99.2 1 248 3 269 349 MEL7369692.1 substrate-binding domain-containing protein [Myxococcota bacterium] diamond 246 44.3 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota 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);;