RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1145997 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
2840304 2840304 PRJNA1145997_P_NODE_36823_length_290_cov_8.502304_g34204_i0 PRJNA1145997 36823 290 8.502304 24.6566816 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 146 5.089999999999998e-41   NR MBW3628220.1 2026742 g34204 i0 83.1 0.858620689655172 83 14 85.9 0 254 6 76 158 MBW3628220.1 ester cyclase [Gemmatimonadota bacterium] diamond 249 146 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
4116291 4116291 PRJNA1145997_P_NODE_24424_length_537_cov_14.243534_g21811_i0 PRJNA1145997 24424 537 14.243534 76.48777758 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 318 2.299999999999999e-105   NR MBW3627912.1 2026742 g21811 i0 88.9 0.955307262569832 171 19 95.5 0 515 3 174 344 MBW3627912.1 DUF1343 domain-containing protein [Gemmatimonadota bacterium] diamond 513 318 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
13043393 13043393 PRJNA1145997_P_NODE_51131_length_215_cov_10.577465_g48512_i0 PRJNA1145997 51131 215 10.577465 22.74154975 Longimicrobiales bacterium 2910168 Bacteria Bacteria 65.1 1.04e-10   NR HEX6307689.1 2910168 g48512 i0 62.3 2.70697674418605 53 19 74 1 215 57 158 209 HEX6307689.1 OmpA family protein [Longimicrobiales bacterium] diamond 582 65.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
18141432 18141432 PRJNA1145997_P_NODE_50815_length_224_cov_4.099338_g48196_i0 PRJNA1145997 50815 224 4.099338 9.18251712 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 56.2 1.92e-7   NR MBW3629274.1 2026742 g48196 i0 61.4 0.589285714285714 44 17 58.9 0 82 213 10 53 MBW3629274.1 hypothetical protein [Gemmatimonadota bacterium] diamond 132 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
20691213 20691213 PRJNA1145997_P_NODE_50257_length_231_cov_17.924051_g47638_i0 PRJNA1145997 50257 231 17.924051 41.40455781 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 120 6.7e-30   NR MBW3627845.1 2026742 g47638 i0 84.1 0.896103896103896 69 11 89.6 0 19 225 196 264 MBW3627845.1 FAD-dependent oxidoreductase [Gemmatimonadota bacterium] diamond 207 120 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
26690688 26690688 PRJNA1145997_P_NODE_37041_length_288_cov_15.483721_g34422_i0 PRJNA1145997 37041 288 15.483721 44.59311648 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 144 2.9999999999999998e-40   NR MBW3630389.1 2026742 g34422 i0 81.8 0.916666666666667 88 16 91.7 0 22 285 125 212 MBW3630389.1 N-acetylmuramoyl-L-alanine amidase [Gemmatimonadota bacterium] diamond 264 144 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
26753729 26753729 PRJNA1145997_P_NODE_46541_length_246_cov_0.901734_g43922_i0 PRJNA1145997 46541 246 0.901734 2.21826564 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 119 6.41e-30   NR HRP08097.1 2448054 g43922 i0 75.9 0.963414634146341 79 19 96.3 0 2 238 163 241 HRP08097.1 type II secretion system F family protein [Gemmatimonadales bacterium] diamond 237 119 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27765727 27765727 PRJNA1145997_P_NODE_22544_length_603_cov_4.984906_g19940_i0 PRJNA1145997 22544 603 4.984906 30.05898318 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 47 0.0286   NR HJU89673.1 2026741 g19940 i0 38.5 0.323383084577114 65 39 31.8 1 141 332 522 586 HJU89673.1 glycosyltransferase family 2 protein [Gemmatimonadaceae bacterium] diamond 195 47 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28144639 28144639 PRJNA1145997_P_NODE_38745_length_275_cov_5.985149_g36126_i0 PRJNA1145997 38745 275 5.985149 16.45915975 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 170 2.5e-50   NR MBW3628289.1 2026742 g36126 i0 95.2 0.905454545454545 83 4 90.5 0 21 269 162 244 MBW3628289.1 DUF3810 family protein [Gemmatimonadota bacterium] diamond 249 170 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28618183 28618183 PRJNA1145997_P_NODE_33787_length_323_cov_12.468000_g31168_i0 PRJNA1145997 33787 323 12.468 40.27164 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 166 3.25e-45   NR MBW3627973.1 2026742 g31168 i0 88.9 0.835913312693498 90 10 83.6 0 23 292 615 704 MBW3627973.1 peptidase S9 [Gemmatimonadota bacterium] diamond 270 166 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
29123507 29123507 PRJNA1145997_P_NODE_35049_length_309_cov_0.991525_g32430_i0 PRJNA1145997 35049 309 0.991525 3.06381225 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 89.7 2.31e-18   NR HSR92333.1 2448054 g32430 i0 48 1.72815533980583 102 52 98.1 1 305 3 167 268 HSR92333.1 hypothetical protein [Gemmatimonadales bacterium] diamond 534 89.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29470224 29470224 PRJNA1145997_P_NODE_36650_length_292_cov_1.424658_g34031_i0 PRJNA1145997 36650 292 1.424658 4.16000136 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 144 1.02e-39   NR HRP09060.1 2448054 g34031 i0 74 0.986301369863014 96 25 98.6 0 290 3 78 173 HRP09060.1 cytochrome D1 domain-containing protein [Gemmatimonadales bacterium] diamond 288 144 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29533689 29533689 PRJNA1145997_P_NODE_45870_length_247_cov_0.896552_g43251_i0 PRJNA1145997 45870 247 0.896552 2.21448344 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 122 1.12e-30   NR HRP08200.1 2448054 g43251 i0 77.8 0.983805668016194 81 18 98.4 0 3 245 64 144 HRP08200.1 ATP-binding protein [Gemmatimonadales bacterium] diamond 243 122 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30185772 30185772 PRJNA1145997_P_NODE_42872_length_252_cov_0.871508_g40253_i0 PRJNA1145997 42872 252 0.871508 2.19620016 Bacteria 2 Bacteria Bacteria 137 3.11e-36   NR PKL93963.1 2013806 g40253 i0 78.6 3 84 18 100 0 1 252 233 316 PKL93963.1 MAG: anthranilate synthase component I [Gemmatimonadetes bacterium HGW-Gemmatimonadetes-1] diamond 756 137 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadetes bacterium HGW-Gemmatimonadetes-1
30386927 30386927 PRJNA1145997_P_NODE_47693_length_244_cov_0.912281_g45074_i0 PRJNA1145997 47693 244 0.912281 2.22596564 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 111 4.3e-27   NR HET9064377.1 2448054 g45074 i0 65.8 2.92622950819672 79 26 95.9 1 11 244 64 142 HET9064377.1 hypothetical protein [Gemmatimonadales bacterium] diamond 714 111 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30923888 30923888 PRJNA1145997_P_NODE_48994_length_242_cov_0.923077_g46375_i0 PRJNA1145997 48994 242 0.923077 2.23384634 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 57.8 1.77e-7   NR MDP3909350.1 2448054 g46375 i0 43.6 0.966942148760331 78 40 91.7 1 1 222 129 206 MDP3909350.1 DUF1565 domain-containing protein [Gemmatimonadales bacterium] diamond 234 57.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30986963 30986963 PRJNA1145997_P_NODE_41974_length_254_cov_1.723757_g39355_i0 PRJNA1145997 41974 254 1.723757 4.37834278 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 117 1.2799999999999999e-28   NR HXG70468.1 2026741 g39355 i0 72.5 0.94488188976378 80 22 94.5 0 9 248 206 285 HXG70468.1 DUF3987 domain-containing protein [Gemmatimonadaceae bacterium] diamond 240 117 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31682220 31682220 PRJNA1145997_P_NODE_51517_length_206_cov_11.518797_g48898_i0 PRJNA1145997 51517 206 11.518797 23.72872182 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 53.5 2.2e-6   NR MEO7711665.1 2026741 g48898 i0 50 2.35922330097087 52 26 75.7 0 167 12 81 132 MEO7711665.1 ArsR family transcriptional regulator [Gemmatimonadaceae bacterium] diamond 486 53.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31840418 31840418 PRJNA1145997_P_NODE_28637_length_414_cov_1.894428_g26020_i0 PRJNA1145997 28637 414 1.894428 7.84293192 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 77.8 1.02e-15   NR HXG70037.1 2026741 g26020 i0 49.4 0.557971014492754 77 39 55.8 0 99 329 8 84 HXG70037.1 hypothetical protein [Gemmatimonadaceae bacterium] diamond 231 77.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32125562 32125562 PRJNA1145997_P_NODE_37038_length_288_cov_48.995349_g34419_i0 PRJNA1145997 37038 288 48.995349 141.10660512 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 134 1.7099999999999998e-35   NR HET6341345.1 2026742 g34419 i0 68.1 0.979166666666667 94 27 97.9 1 282 1 74 164 HET6341345.1 multicopper oxidase domain-containing protein [Gemmatimonadota bacterium] diamond 282 134 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);;