RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA594101" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA594101 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
26966556 26966556 PRJNA594101_S_NODE_1162_length_1340_cov_7.714286_g1038_i0 PRJNA594101 1162 1340 7.714286 103.3714324 Bacteria 2 Bacteria Bacteria 320 1.1799999999999996e-101   NR NNE07608.1 2026742 g1038 i0 42.5 4.69477611940299 421 236 92.9 2 60 1304 26 446 NNE07608.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadota bacterium] diamond 6291 322 0.993788819875776 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27553445 27553445 PRJNA594101_S_NODE_38244_length_281_cov_1.110577_g37942_i0 PRJNA594101 38244 281 1.110577 3.12072137 Longimicrobiales bacterium 2910168 Bacteria Bacteria 43.5 0.0318   NR MFP3948164.1 2910168 g37942 i0 32.9 0.811387900355872 76 51 81.1 0 16 243 291 366 MFP3948164.1 ATP-binding protein [Longimicrobiales bacterium] diamond 228 43.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
27553449 27553449 PRJNA594101_S_NODE_4024_length_800_cov_4.535076_g3760_i0 PRJNA594101 4024 800 4.535076 36.280608 Longimicrobiales bacterium 2910168 Bacteria Bacteria 91.7 4.89e-18   NR HEX7118166.1 2910168 g3760 i0 33.8 3.2025 204 110 73.9 6 663 73 52 237 HEX7118166.1 aquaporin [Longimicrobiales bacterium] diamond 2562 91.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
27712016 27712016 PRJNA594101_S_NODE_36624_length_286_cov_1.802817_g36322_i0 PRJNA594101 36624 286 1.802817 5.15605662 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 46.2 0.00386   NR HEV7991165.1 2026741 g36322 i0 30.8 1.45804195804196 91 59 91.3 1 264 4 819 909 HEV7991165.1 serine/threonine-protein kinase [Gemmatimonadaceae bacterium] diamond 417 46.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27900817 27900817 PRJNA594101_S_NODE_29605_length_314_cov_1.643154_g29303_i0 PRJNA594101 29605 314 1.643154 5.15950356 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.9 0.0103   NR HMA01469.1 2026741 g29303 i0 33.3 0.802547770700637 84 50 80.3 1 15 266 45 122 HMA01469.1 response regulator [Gemmatimonadaceae bacterium] diamond 252 43.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28027394 28027394 PRJNA594101_S_NODE_20245_length_373_cov_1.026667_g19943_i0 PRJNA594101 20245 373 1.026667 3.82946791 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 73.6 1.91e-12   NR HEY2855622.1 2026741 g19943 i0 50 1.64075067024129 68 34 54.7 0 11 214 74 141 HEY2855622.1 alkene reductase [Gemmatimonadaceae bacterium] diamond 612 73.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
28343059 28343059 PRJNA594101_S_NODE_41206_length_271_cov_1.767677_g40904_i0 PRJNA594101 41206 271 1.767677 4.79040467 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 45.1 0.00799   NR MEA2713157.1 2448054 g40904 i0 37.7 1.35055350553506 61 32 67.5 2 78 260 645 699 MEA2713157.1 isoleucyl-tRNA synthetase [Gemmatimonadales bacterium] diamond 366 45.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28672342 28672342 PRJNA594101_S_NODE_51247_length_248_cov_1.005714_g50945_i0 PRJNA594101 51247 248 1.005714 2.49417072 root 1 Root_unresolved Root_unresolved 50.8 4.98e-5   NR HET9133661.1 2448054 g50945 i0 36.9 2.52822580645161 65 39 76.2 2 189 1 117 181 HET9133661.1 serine/threonine-protein kinase [Gemmatimonadales bacterium] diamond 627 51.2 0.9921875 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30301401 30301401 PRJNA594101_S_NODE_41892_length_269_cov_1.571429_g41590_i0 PRJNA594101 41892 269 1.571429 4.22714401 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 105 5.749999999999999e-24   NR NNE08319.1 2026742 g41590 i0 58.1 0.825278810408922 74 29 82.5 1 247 26 255 326 NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] diamond 222 105 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30459314 30459314 PRJNA594101_S_NODE_36173_length_288_cov_1.381395_g35871_i0 PRJNA594101 36173 288 1.381395 3.9784176 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 46.6 0.00273   NR HET8655101.1 3047548 g35871 i0 49.2 0.614583333333333 59 27 59.4 2 93 263 189 246 HET8655101.1 ATP-binding cassette domain-containing protein [Longimicrobiaceae bacterium] diamond 177 46.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
30806505 30806505 PRJNA594101_S_NODE_4594_length_753_cov_4.730882_g4321_i0 PRJNA594101 4594 753 4.730882 35.62354146 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 49.7 7.47e-4   NR HEU5358694.1 2448054 g4321 i0 57.1 0.195219123505976 49 17 19.1 2 565 708 65 110 HEU5358694.1 nucleotide exchange factor GrpE [Gemmatimonadales bacterium] diamond 147 49.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31090850 31090850 PRJNA594101_S_NODE_8015_length_577_cov_3.938492_g7715_i0 PRJNA594101 8015 577 3.938492 22.72509884 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 46.2 0.0431   NR HWH51054.1 2026741 g7715 i0 30.7 0.660311958405546 127 76 64 3 120 488 168 286 HWH51054.1 ATP-binding protein [Gemmatimonadaceae bacterium] diamond 381 46.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
31407105 31407105 PRJNA594101_S_NODE_35956_length_289_cov_1.069444_g35654_i0 PRJNA594101 35956 289 1.069444 3.09069316 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 70.5 1.15e-11   NR NNE08319.1 2026742 g35654 i0 40 0.934256055363322 90 51 92.4 2 274 8 63 150 NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] diamond 270 70.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32148056 32148056 PRJNA594101_S_NODE_45878_length_258_cov_1.600000_g45576_i0 PRJNA594101 45878 258 1.6 4.128 Pseudomonadati 3379134 Bacteria Bacteria 44.7 0.00928   NR MFL5576683.1 2026741 g45576 i0 38 4.3953488372093 79 43 87.2 3 243 19 274 350 MFL5576683.1 PQQ-binding-like beta-propeller repeat protein [Gemmatimonadaceae bacterium] diamond 1134 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32577631 32577631 PRJNA594101_S_NODE_42619_length_267_cov_1.494845_g42317_i0 PRJNA594101 42619 267 1.494845 3.99123615 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 44.7 0.0104   NR NNM33393.1 2026742 g42317 i0 35.3 1.14606741573034 51 33 57.3 0 86 238 413 463 NNM33393.1 aconitate hydratase AcnA [Gemmatimonadota bacterium] diamond 306 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32608964 32608964 PRJNA594101_S_NODE_18580_length_387_cov_1.407643_g18278_i0 PRJNA594101 18580 387 1.407643 5.44757841 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 84.7 4.68e-17   NR MBX6331613.1 2026741 g18278 i0 39 1.91472868217054 118 69 91.5 1 360 7 99 213 MBX6331613.1 ABC transporter ATP-binding protein [Gemmatimonadaceae bacterium] diamond 741 84.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae 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);;