RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA883229" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA883229 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27308428 27308428 PRJNA883229_P_NODE_14923_length_244_cov_0.912281_g14877_i0 PRJNA883229 14923 244 0.912281 2.22596564 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 106 1.25e-24   NR MBK8246459.1 2026742 g14877 i0 72.9 0.860655737704918 70 17 86.1 1 1 210 454 521 MBK8246459.1 hypothetical protein [Gemmatimonadota bacterium] diamond 210 106 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30245092 30245092 PRJNA883229_P_NODE_10092_length_251_cov_0.876404_g10046_i0 PRJNA883229 10092 251 0.876404 2.19977404 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 59.7 4.29e-8   NR MFN0177703.1 2448054 g10046 i0 79.5 0.525896414342629 44 7 50.2 2 126 251 1 44 MFN0177703.1 S41 family peptidase [Gemmatimonadales bacterium] diamond 132 59.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30340285 30340285 PRJNA883229_P_NODE_9332_length_252_cov_0.871508_g9286_i0 PRJNA883229 9332 252 0.871508 2.19620016 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 47 2.95e-4   NR MBA2685304.1 2026741 g9286 i0 36.4 0.523809523809524 44 28 52.4 0 100 231 4 47 MBA2685304.1 VRR-NUC domain-containing protein [Gemmatimonadaceae bacterium] diamond 132 47 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32647275 32647275 PRJNA883229_P_NODE_10020_length_251_cov_0.876404_g9974_i0 PRJNA883229 10020 251 0.876404 2.19977404 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 133 2.7199999999999998e-34   NR MBP6572397.1 2448054 g9974 i0 75.6 0.9800796812749 82 20 98 0 246 1 410 491 MBP6572397.1 hypothetical protein [Gemmatimonadales bacterium] diamond 246 133 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales 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);;