RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA975724", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 8 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 8 ✖

bioproject 1

  • PRJNA975724 · 8 ✖

analysis 1

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
27878899 27878899 PRJNA975724_S_NODE_75905_length_254_cov_1.701657_g75724_i0 PRJNA975724 75905 254 1.701657 4.32220878 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 62.4 5.06e-9   NR MDE2796830.1 2026742 g75724 i0 47.4 0.921259842519685 78 36 86.2 1 3 221 541 618 MDE2796830.1 ankyrin repeat domain-containing protein [Gemmatimonadota bacterium] diamond 234 62.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28131633 28131633 PRJNA975724_S_NODE_45245_length_307_cov_2.303419_g45064_i0 PRJNA975724 45245 307 2.303419 7.07149633 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 45.8 0.0063   NR HEU4648891.1 2448054 g45064 i0 59.4 0.312703583061889 32 13 31.3 0 6 101 588 619 HEU4648891.1 acyl-CoA dehydrogenase [Gemmatimonadales bacterium] diamond 96 45.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
28225921 28225921 PRJNA975724_S_NODE_24846_length_366_cov_2.641638_g24665_i0 PRJNA975724 24846 366 2.641638 9.66839508 Longimicrobium sp. 2029185 Bacteria Bacteria 73.9 7.19e-13   NR HEU4456682.1 2029185 g24665 i0 54.7 1.74590163934426 53 24 43.4 0 364 206 230 282 HEU4456682.1 M15 family metallopeptidase [Longimicrobium sp.] diamond 639 73.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
29615123 29615123 PRJNA975724_S_NODE_59530_length_279_cov_3.737864_g59349_i0 PRJNA975724 59530 279 3.737864 10.42864056 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 48.9 8.65e-5   NR MBB30321.1 2026742 g59349 i0 38.5 1.65591397849462 52 32 55.9 0 156 1 8 59 MBB30321.1 hypothetical protein [Gemmatimonadota bacterium] diamond 462 48.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30310878 30310878 PRJNA975724_S_NODE_4152_length_546_cov_2.439746_g3974_i0 PRJNA975724 4152 546 2.439746 13.32101316 Longimicrobium sp. 2029185 Bacteria Bacteria 55.5 2.21e-5   NR HVH13328.1 2029185 g3974 i0 60.5 0.236263736263736 43 17 23.6 0 2 130 305 347 HVH13328.1 trypsin-like peptidase domain-containing protein [Longimicrobium sp.] diamond 129 55.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
30600859 30600859 PRJNA975724_S_NODE_25313_length_364_cov_3.450172_g25132_i0 PRJNA975724 25313 364 3.450172 12.55862608 Pseudomonadati 3379134 Bacteria Bacteria 79 2.23e-16   NR HEY7193082.1 2448054 g25132 i0 76.6 4.61538461538461 47 11 38.7 0 363 223 49 95 HEY7193082.1 acetyl-CoA C-acyltransferase [Gemmatimonadales bacterium] diamond 1680 79 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30942441 30942441 PRJNA975724_S_NODE_52254_length_293_cov_1.050000_g52073_i0 PRJNA975724 52254 293 1.05 3.0765 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 108 4.94e-25   NR MDQ3606579.1 2026742 g52073 i0 67.6 6.5938566552901 74 24 75.8 0 272 51 621 694 MDQ3606579.1 S9 family peptidase [Gemmatimonadota bacterium] diamond 1932 108 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32687449 32687449 PRJNA975724_S_NODE_60360_length_278_cov_1.502439_g60179_i0 PRJNA975724 60360 278 1.502439 4.17678042 Bacteria 2 Bacteria Bacteria 104 3.26e-24   NR HZS60021.1 2026741 g60179 i0 50 10.9208633093525 92 46 99.3 0 1 276 163 254 HZS60021.1 FAD-dependent oxidoreductase [Gemmatimonadaceae bacterium] diamond 3036 105 0.990476190476191 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);;