RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1041773" 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

  • PRJNA1041773 · 4 ✖

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
7823222 7823222 PRJNA1041773_P_NODE_61387_length_277_cov_1.509804_g61054_i0 PRJNA1041773 61387 277 1.509804 4.18215708 Gemmatirosa 1706036 Bacteria Bacteria 169 9.22e-49   NR WP_025412746.1 861299 g61054 i0 84.6 3.97472924187726 91 14 98.6 0 277 5 231 321 WP_025412746.1 trans-sulfuration enzyme family protein [Gemmatirosa kalamazoonensis] diamond 1101 169 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
27951287 27951287 PRJNA1041773_P_NODE_56425_length_287_cov_1.200935_g56092_i0 PRJNA1041773 56425 287 1.200935 3.44668345 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 165 3.41e-46   NR MDP1860844.1 2026741 g56092 i0 81.1 0.993031358885017 95 17 98.3 1 284 3 228 322 MDP1860844.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 285 165 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
29498320 29498320 PRJNA1041773_P_NODE_96390_length_243_cov_0.905882_g96057_i0 PRJNA1041773 96390 243 0.905882 2.20129326 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 143 6.35e-39   NR MEP7384223.1 2026742 g96057 i0 94.4 0.888888888888889 72 4 88.9 0 1 216 359 430 MEP7384223.1 phenylacetic acid degradation bifunctional protein PaaZ [Gemmatimonadota bacterium] diamond 216 143 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30098301 30098301 PRJNA1041773_P_NODE_96272_length_243_cov_0.905882_g95939_i0 PRJNA1041773 96272 243 0.905882 2.20129326 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 87.4 7.44e-19   NR UCC25767.1 2448054 g95939 i0 67.2 2.30864197530864 61 20 75.3 0 242 60 180 240 UCC25767.1 MAG: hypothetical protein JSU98_01470 [Gemmatimonadales bacterium] diamond 561 87.4 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);;