RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1000943" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1000943 · 6 ✖

analysis 1

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
28606060 28606060 PRJNA1000943_P_NODE_8827_length_279_cov_2.533981_g8689_i0 PRJNA1000943 8827 279 2.533981 7.06980699 Bacteria 2 Bacteria Bacteria 94.7 2.5e-20   NR MEO7502219.1 2026741 g8689 i0 64 2.7741935483871 86 27 88.2 1 279 34 305 390 MEO7502219.1 S8 family serine peptidase [Gemmatimonadaceae bacterium] diamond 774 94.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29654980 29654980 PRJNA1000943_P_NODE_8250_length_288_cov_1.088372_g8112_i0 PRJNA1000943 8250 288 1.088372 3.13451136 uncultured Gemmatimonadota bacterium 203437 Bacteria Bacteria 82.8 5.11e-16   NR CAA9345511.1 203437 g8112 i0 47.9 1.8125 94 48 97.9 1 5 286 341 433 CAA9345511.1 MAG: hypothetical protein AVDCRST_MAG68-3301 [uncultured Gemmatimonadota bacterium] diamond 522 82.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         uncultured Gemmatimonadota bacterium
29844802 29844802 PRJNA1000943_P_NODE_12171_length_250_cov_0.881356_g12033_i0 PRJNA1000943 12171 250 0.881356 2.20339 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 53.1 8.46e-6   NR MDH3205933.1 2026742 g12033 i0 56.3 1.176 48 21 57.6 0 145 2 6 53 MDH3205933.1 acyl-CoA dehydrogenase [Gemmatimonadota bacterium] diamond 294 53.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29971172 29971172 PRJNA1000943_P_NODE_9871_length_266_cov_1.357513_g9733_i0 PRJNA1000943 9871 266 1.357513 3.6109845800000002 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 69.3 1.63e-12   NR MDH4043562.1 2026742 g9733 i0 46.5 2.65037593984962 71 35 76.7 1 205 2 17 87 MDH4043562.1 Hsp20/alpha crystallin family protein [Gemmatimonadota bacterium] diamond 705 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
31234867 31234867 PRJNA1000943_P_NODE_7455_length_301_cov_1.355263_g7317_i0 PRJNA1000943 7455 301 1.355263 4.07934163 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 89 4.87e-20   NR MFI5208860.1 2448054 g7317 i0 44 3.92691029900332 100 54 99.7 1 1 300 42 139 MFI5208860.1 Hsp20/alpha crystallin family protein [Gemmatimonadales bacterium] diamond 1182 89 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32184127 32184127 PRJNA1000943_P_NODE_10898_length_254_cov_1.558011_g10760_i0 PRJNA1000943 10898 254 1.558011 3.95734794 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 139 3.47e-36   NR NJD11242.1 2026742 g10760 i0 71.4 1.98425196850394 84 24 99.2 0 254 3 397 480 NJD11242.1 DUF5110 domain-containing protein [Gemmatimonadota bacterium] diamond 504 139 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota 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);;