RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA890871" 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

  • PRJNA890871 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
4693390 4693390 PRJNA890871_P_NODE_65484_length_250_cov_0.870056_g65349_i0 PRJNA890871 65484 250 0.870056 2.17514 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 173 2.04e-48   NR MBL8961854.1 2026742 g65349 i0 91.6 0.996 83 7 99.6 0 250 2 501 583 MBL8961854.1 ABC-2 transporter permease [Gemmatimonadota bacterium] diamond 249 173 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
11067665 11067665 PRJNA890871_P_NODE_29349_length_313_cov_2.483333_g29214_i0 PRJNA890871 29349 313 2.483333 7.77283229 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 110 9.96e-28   NR MBA3672972.1 2026741 g29214 i0 55.6 1.03514376996805 108 43 99.7 3 2 313 57 163 MBA3672972.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 324 110 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27087239 27087239 PRJNA890871_P_NODE_62922_length_251_cov_0.865169_g62787_i0 PRJNA890871 62922 251 0.865169 2.17157419 Longimicrobium sp. 2029185 Bacteria Bacteria 72.8 3.31e-13   NR HEX9940226.1 2029185 g62787 i0 64.4 0.537848605577689 45 16 53.8 0 141 7 4 48 HEX9940226.1 isochorismatase family cysteine hydrolase [Longimicrobium sp.] diamond 135 72.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
27149920 27149920 PRJNA890871_P_NODE_29202_length_314_cov_1.597510_g29067_i0 PRJNA890871 29202 314 1.59751 5.0161814 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 44.3 0.0204   NR HEU4700501.1 2448054 g29067 i0 32.4 0.64968152866242 68 46 65 0 111 314 180 247 HEU4700501.1 SAM-dependent chlorinase/fluorinase [Gemmatimonadales bacterium] diamond 204 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27687775 27687775 PRJNA890871_P_NODE_66184_length_250_cov_0.870056_g66049_i0 PRJNA890871 66184 250 0.870056 2.17514 Longimicrobium sp. 2029185 Bacteria Bacteria 115 1.18e-28   NR HEX8430915.1 2029185 g66049 i0 98.4 0.768 64 1 76.8 0 58 249 1 64 HEX8430915.1 hypothetical protein [Longimicrobium sp.] diamond 192 115 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
29613053 29613053 PRJNA890871_P_NODE_52950_length_262_cov_3.010582_g52815_i0 PRJNA890871 52950 262 3.010582 7.88772484 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 104 2.41e-25   NR MBK8249898.1 2026742 g52815 i0 75.7 0.801526717557252 70 17 80.2 0 210 1 1 70 MBK8249898.1 hypothetical protein [Gemmatimonadota bacterium] diamond 210 104 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30718949 30718949 PRJNA890871_P_NODE_27934_length_319_cov_2.764228_g27799_i0 PRJNA890871 27934 319 2.764228 8.81788732 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 114 6.12e-29   NR TVP57081.1 2448054 g27799 i0 52.4 4.81504702194357 105 49 97.8 1 8 319 30 134 TVP57081.1 MAG: pyridoxamine 5'-phosphate oxidase [Gemmatimonadales bacterium] diamond 1536 114 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);;