RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA631119" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA631119 · 12 ✖

analysis 1

  • diamond · 12 ✖
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
3154150 3154150 PRJNA631119_P_NODE_3703_length_574_cov_2.279441_g3590_i0 PRJNA631119 3703 574 2.279441 13.08399134 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 218 5.149999999999999e-66   NR HEY9229717.1 2026741 g3590 i0 71.5 7.18118466898955 137 39 71.6 0 3 413 82 218 HEY9229717.1 NADP-dependent isocitrate dehydrogenase [Gemmatimonadaceae bacterium] diamond 4122 218 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
4431024 4431024 PRJNA631119_P_NODE_40764_length_227_cov_2.480519_g40646_i0 PRJNA631119 40764 227 2.480519 5.63077813 FCB group 1783270 Bacteria Bacteria 97.1 6.57e-22   NR HEX8432695.1 2029185 g40646 i0 66.7 14.1674008810573 69 22 91.2 1 210 4 148 215 HEX8432695.1 NAD(P)-dependent alcohol dehydrogenase [Longimicrobium sp.] diamond 3216 97.8 0.992842535787321 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
8256350 8256350 PRJNA631119_P_NODE_21107_length_291_cov_1.412844_g20989_i0 PRJNA631119 21107 291 1.412844 4.11137604 FCB group 1783270 Bacteria Bacteria 147 1.78e-40   NR HEY9229717.1 2026741 g20989 i0 66.7 3.98969072164948 96 32 99 0 2 289 110 205 HEY9229717.1 NADP-dependent isocitrate dehydrogenase [Gemmatimonadaceae bacterium] diamond 1161 148 0.993243243243243 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
10807482 10807482 PRJNA631119_P_NODE_37809_length_243_cov_0.905882_g37691_i0 PRJNA631119 37809 243 0.905882 2.20129326 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 139 1.25e-37   NR HSE53741.1 2448054 g37691 i0 77.2 27.0740740740741 79 18 97.5 0 238 2 78 156 HSE53741.1 glycine dehydrogenase (aminomethyl-transferring) [Gemmatimonadales bacterium] diamond 6579 139 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
27378183 27378183 PRJNA631119_P_NODE_37963_length_242_cov_1.822485_g37845_i0 PRJNA631119 37963 242 1.822485 4.4104137 Bacteria 2 Bacteria Bacteria 122 2.4199999999999997e-31   NR HWA56351.1 2448054 g37845 i0 73.1 5.81404958677686 78 21 96.7 0 239 6 48 125 HWA56351.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadales bacterium] diamond 1407 122 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29196811 29196811 PRJNA631119_P_NODE_31029_length_251_cov_0.865169_g30911_i0 PRJNA631119 31029 251 0.865169 2.17157419 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 52 2.09e-5   NR HET7603516.1 2448054 g30911 i0 47.1 1.86454183266932 51 27 61 0 248 96 185 235 HET7603516.1 Ig-like domain-containing protein [Gemmatimonadales bacterium] diamond 468 52 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
31104350 31104350 PRJNA631119_P_NODE_6695_length_448_cov_2.437333_g6577_i0 PRJNA631119 6695 448 2.437333 10.91925184 Pseudomonadati 3379134 Bacteria Bacteria 107 1.1699999999999997e-23   NR WP_409953356.1 1962908 g6577 i0 63.6 15.9709821428571 77 28 51.6 0 444 214 438 514 WP_409953356.1 threonine--tRNA ligase [Gemmatimonas sp.] diamond 7155 108 0.990740740740741 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas sp.
32040787 32040787 PRJNA631119_P_NODE_22458_length_284_cov_2.677725_g22340_i0 PRJNA631119 22458 284 2.677725 7.604739 Longimicrobiaceae bacterium 3047548 Bacteria Bacteria 46.6 0.00267   NR HET6229317.1 3047548 g22340 i0 36.1 0.76056338028169 72 46 76.1 0 63 278 546 617 HET6229317.1 M1 family metallopeptidase [Longimicrobiaceae bacterium] diamond 216 46.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae   Longimicrobiaceae bacterium
32103988 32103988 PRJNA631119_P_NODE_12518_length_352_cov_1.584229_g12400_i0 PRJNA631119 12518 352 1.584229 5.57648608 Longimicrobiales bacterium 2910168 Bacteria Bacteria 72 6.13e-12   NR HET9984094.1 2910168 g12400 i0 32.5 0.971590909090909 114 77 97.2 0 6 347 94 207 HET9984094.1 serpin family protein [Longimicrobiales bacterium] diamond 342 72 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
32483854 32483854 PRJNA631119_P_NODE_25299_length_272_cov_1.527638_g25181_i0 PRJNA631119 25299 272 1.527638 4.15517536 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 53.1 1.14e-5   NR NNE08319.1 2026742 g25181 i0 32.9 1.86397058823529 85 55 92.6 2 18 269 87 170 NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium] diamond 507 53.1 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32610110 32610110 PRJNA631119_P_NODE_30660_length_251_cov_2.084270_g30542_i0 PRJNA631119 30660 251 2.08427 5.2315177 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 47.8 6.97e-4   NR MDX1660653.1 2026742 g30542 i0 40 1.33864541832669 55 33 65.7 0 172 8 441 495 MDX1660653.1 acyl-CoA dehydrogenase family protein [Gemmatimonadota bacterium] diamond 336 47.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32861973 32861973 PRJNA631119_P_NODE_23520_length_280_cov_1.449275_g23402_i0 PRJNA631119 23520 280 1.449275 4.05797 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.1 0.0416   NR MBY0489199.1 2026741 g23402 i0 37.7 0.653571428571429 61 35 62.1 1 176 3 460 520 MBY0489199.1 response regulator [Gemmatimonadaceae bacterium] diamond 183 43.1 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);;