RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA168635 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
4191719 4191719 PRJNA168635_P_NODE_31884_length_162_cov_0.920354_g31468_i0 PRJNA168635 31884 162 0.920354 1.49097348 Pseudomonadati 3379134 Bacteria Bacteria 96.7 1.24e-21   NR WP_337172479.1 173480 g31468 i0 81.1 4.90740740740741 53 10 98.1 0 3 161 721 773 WP_337172479.1 formate dehydrogenase subunit alpha [Gemmatimonas aurantiaca] diamond 795 97.1 0.995880535530381 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas aurantiaca
22041205 22041205 PRJNA168635_P_NODE_30078_length_164_cov_0.904348_g29662_i0 PRJNA168635 30078 164 0.904348 1.48313072 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 63.2 6.43e-10   NR HEV8453759.1 2448054 g29662 i0 70 0.914634146341463 50 15 91.5 0 162 13 107 156 HEV8453759.1 hypothetical protein [Gemmatimonadales bacterium] diamond 150 63.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28305629 28305629 PRJNA168635_P_NODE_8646_length_286_cov_2.244726_g8231_i0 PRJNA168635 8646 286 2.244726 6.41991636 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 43.1 0.0331   NR HSE53947.1 2448054 g8231 i0 33.7 1.02797202797203 98 45 87.1 3 7 255 100 192 HSE53947.1 helix-turn-helix domain-containing protein [Gemmatimonadales bacterium] diamond 294 43.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28652973 28652973 PRJNA168635_P_NODE_19227_length_185_cov_1.507353_g18811_i0 PRJNA168635 19227 185 1.507353 2.78860305 Gemmatimonas sp. 1962908 Bacteria Bacteria 61.2 4.95e-9   NR MEQ1693660.1 1962908 g18811 i0 68.2 2.18918918918919 44 14 71.4 0 185 54 346 389 MEQ1693660.1 potassium channel family protein [Gemmatimonas sp.] diamond 405 61.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
28905267 28905267 PRJNA168635_P_NODE_16168_length_199_cov_2.046667_g15752_i0 PRJNA168635 16168 199 2.046667 4.07286733 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 72.4 4.74e-13   NR MBP6571614.1 2448054 g15752 i0 68.6 0.768844221105528 51 16 76.9 0 46 198 42 92 MBP6571614.1 recombinase RecT [Gemmatimonadales bacterium] diamond 153 72.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29126817 29126817 PRJNA168635_P_NODE_29249_length_165_cov_0.896552_g28833_i0 PRJNA168635 29249 165 0.896552 1.4793108 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 69.3 5.25e-12   NR GMV07395.1 2026742 g28833 i0 60.4 1.94545454545455 53 21 96.4 0 2 160 241 293 GMV07395.1 MAG: hypothetical protein AMXMBFR53_36700 [Gemmatimonadota bacterium] diamond 321 69.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29884530 29884530 PRJNA168635_P_NODE_32591_length_161_cov_2.625000_g32175_i0 PRJNA168635 32591 161 2.625 4.22625 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 44.3 0.0014   NR MBU6364809.1 2026742 g32175 i0 48 0.93167701863354 50 21 93.2 1 160 11 10 54 MBU6364809.1 hypothetical protein [Gemmatimonadota bacterium] diamond 150 44.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30073778 30073778 PRJNA168635_P_NODE_29972_length_164_cov_0.904348_g29556_i0 PRJNA168635 29972 164 0.904348 1.48313072 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 75.9 1.93e-16   NR HET7321161.1 3047548 g29556 i0 65.9 0.804878048780488 44 15 80.5 0 137 6 1 44 HET7321161.1 hypothetical protein [Longimicrobiaceae bacterium] diamond 132 75.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
30516218 30516218 PRJNA168635_P_NODE_25913_length_168_cov_1.747899_g25497_i0 PRJNA168635 25913 168 1.747899 2.93647032 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 102 1.2999999999999998e-24   NR MCC7132674.1 2448054 g25497 i0 90.9 0.982142857142857 55 5 98.2 0 2 166 135 189 MCC7132674.1 hypothetical protein [Gemmatimonadales bacterium] diamond 165 102 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30737282 30737282 PRJNA168635_P_NODE_24654_length_170_cov_1.685950_g24238_i0 PRJNA168635 24654 170 1.68595 2.866115 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 44.7 0.00283   NR MCR4341171.1 2026741 g24238 i0 42.6 0.952941176470588 54 31 95.3 0 170 9 59 112 MCR4341171.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 162 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
30737286 30737286 PRJNA168635_P_NODE_29994_length_164_cov_0.904348_g29578_i0 PRJNA168635 29994 164 0.904348 1.48313072 Gaopeijia maritima 3119007 Bacteria Bacteria 53.5 1.97e-6   NR WP_405288063.1 3119007 g29578 i0 42.3 1.92073170731707 52 30 95.1 0 2 157 343 394 WP_405288063.1 phage portal protein [Gaopeijia maritima] diamond 315 53.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Gaopeijiales Gaopeijiaceae Gaopeijia Gaopeijia maritima
31306163 31306163 PRJNA168635_P_NODE_25195_length_169_cov_1.108333_g24779_i0 PRJNA168635 25195 169 1.108333 1.87308277 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 56.2 2.39e-7   NR MBK6423885.1 2026742 g24779 i0 71.1 0.674556213017751 38 11 67.5 0 166 53 114 151 MBK6423885.1 hypothetical protein [Gemmatimonadota bacterium] diamond 114 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32336572 32336572 PRJNA168635_P_NODE_31019_length_163_cov_0.912281_g30603_i0 PRJNA168635 31019 163 0.912281 1.48701803 FCB group 1783270 Bacteria Bacteria 43.9 0.00487   NR HEX6992386.1 2448054 g30603 i0 48.1 1.89570552147239 52 27 95.7 0 158 3 1819 1870 HEX6992386.1 hypothetical protein [Gemmatimonadales bacterium] diamond 309 43.9 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);;