RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA670521" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA670521 · 7 ✖

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
1914438 1914438 PRJNA670521_P_NODE_57302_length_279_cov_1.189320_g56557_i0 PRJNA670521 57302 279 1.18932 3.3182028 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 92 6.17e-20   NR MBA2671011.1 2026742 g56557 i0 56.1 2.67741935483871 82 36 88.2 0 14 259 205 286 MBA2671011.1 carbamate kinase [Gemmatimonadota bacterium] diamond 747 92 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
14667456 14667456 PRJNA670521_P_NODE_88312_length_243_cov_0.905882_g87567_i0 PRJNA670521 88312 243 0.905882 2.20129326 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 157 6.29e-45   NR MEO6527918.1 2026741 g87567 i0 97.5 1 81 2 100 0 1 243 26 106 MEO6527918.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] diamond 243 157 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27524081 27524081 PRJNA670521_P_NODE_83423_length_245_cov_0.895349_g82678_i0 PRJNA670521 83423 245 0.895349 2.19360505 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 58.5 1.03e-7   NR MDP3910560.1 2448054 g82678 i0 42 1.8734693877551 81 47 99.2 0 243 1 282 362 MDP3910560.1 oligopeptide transporter, OPT family [Gemmatimonadales bacterium] diamond 459 58.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27776842 27776842 PRJNA670521_P_NODE_86484_length_244_cov_0.900585_g85739_i0 PRJNA670521 86484 244 0.900585 2.1974274 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 51.2 3.94e-5   NR HSJ64809.1 2026741 g85739 i0 42.3 1.85655737704918 71 41 87.3 0 240 28 543 613 HSJ64809.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] diamond 453 51.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30271572 30271572 PRJNA670521_P_NODE_84792_length_245_cov_0.866279_g84047_i0 PRJNA670521 84792 245 0.866279 2.12238355 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 86.3 9.6e-20   NR HEU4829520.1 2448054 g84047 i0 95.2 1.02857142857143 42 2 51.4 0 128 3 1 42 HEU4829520.1 hypothetical protein [Gemmatimonadales bacterium] diamond 252 86.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30303343 30303343 PRJNA670521_P_NODE_57292_length_279_cov_1.242718_g56547_i0 PRJNA670521 57292 279 1.242718 3.46718322 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 108 6.2e-26   NR HEX5387054.1 2448054 g56547 i0 60 0.860215053763441 80 32 86 0 279 40 268 347 HEX5387054.1 ferrochelatase [Gemmatimonadales bacterium] diamond 240 108 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32610910 32610910 PRJNA670521_P_NODE_60540_length_272_cov_0.743719_g59795_i0 PRJNA670521 60540 272 0.743719 2.02291568 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 43.1 0.0392   NR UCC84250.1 2026742 g59795 i0 38.6 0.628676470588235 57 34 62.9 1 98 268 270 325 UCC84250.1 MAG: protein kinase [Gemmatimonadota bacterium] diamond 171 43.1 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);;