RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA541476" 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

  • PRJNA541476 · 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
27440684 27440684 PRJNA541476_P_NODE_23983_length_266_cov_2.507772_g23777_i0 PRJNA541476 23983 266 2.507772 6.67067352 Bacteria 2 Bacteria Bacteria 56.2 7.79e-7   NR HEY6829770.1 2026741 g23777 i0 50 4.81578947368421 48 24 54.1 0 263 120 275 322 HEY6829770.1 quinone oxidoreductase [Gemmatimonadaceae bacterium] diamond 1281 56.6 0.992932862190813 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28355923 28355923 PRJNA541476_P_NODE_7966_length_400_cov_4.018349_g7762_i0 PRJNA541476 7966 400 4.018349 16.073396 FCB group 1783270 Bacteria Bacteria 78.6 8.41e-15   NR HEX2080112.1 2029185 g7762 i0 41.6 2.1525 101 57 74.3 1 30 326 108 208 HEX2080112.1 hypothetical protein [Longimicrobium sp.] diamond 861 79.3 0.991172761664565 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
29446095 29446095 PRJNA541476_P_NODE_39790_length_242_cov_0.923077_g39584_i0 PRJNA541476 39790 242 0.923077 2.23384634 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 65.9 1.1e-10   NR MDB4892210.1 2026742 g39584 i0 51.6 0.768595041322314 62 29 75.6 1 203 21 80 141 MDB4892210.1 cysteine hydrolase [Gemmatimonadota bacterium] diamond 186 65.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30331121 30331121 PRJNA541476_P_NODE_13972_length_317_cov_2.024590_g13766_i0 PRJNA541476 13972 317 2.02459 6.4179503 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 45.1 0.0135   NR UCF20688.1 2026742 g13766 i0 41.7 2.4794952681388 48 25 45.4 1 281 138 444 488 UCF20688.1 MAG: metallophosphoesterase [Gemmatimonadota bacterium] diamond 786 45.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30535028 30535028 PRJNA541476_P_NODE_12233_length_333_cov_3.869231_g12027_i0 PRJNA541476 12233 333 3.869231 12.88453923 Bacteria 2 Bacteria Bacteria 97.1 7.21e-21   NR MFN2398572.1 2026741 g12027 i0 85.2 9.72972972972973 54 8 48.6 0 1 162 426 479 MFN2398572.1 adenosylhomocysteinase [Gemmatimonadaceae bacterium] diamond 3240 97.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32480898 32480898 PRJNA541476_P_NODE_3819_length_591_cov_3.015444_g3625_i0 PRJNA541476 3819 591 3.015444 17.82127404 Longimicrobiales bacterium 2910168 Bacteria Bacteria 51.2 8.65e-4   NR MFO8175481.1 2910168 g3625 i0 35.8 0.624365482233503 123 72 61.9 3 577 212 197 313 MFO8175481.1 filamin/ABP280 repeat domain-containing protein [Longimicrobiales bacterium] diamond 369 51.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales 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);;