RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1025141" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1025141 · 12 ✖

analysis 1

  • diamond · 12 ✖

tax_clade 0

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
5265558 5265558 PRJNA1025141_P_NODE_10685_length_248_cov_0.880000_g10624_i0 PRJNA1025141 10685 248 0.88 2.1824 uncultured Amnibacterium sp. 1631851 Bacteria Bacteria 110 2.26e-26   NR WP_375386902.1 1631851 g10624 i0 79.3 0.991935483870968 82 17 99.2 0 248 3 161 242 WP_375386902.1 YibE/F family protein [uncultured Amnibacterium sp.] diamond 246 110 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Amnibacterium uncultured Amnibacterium sp.
26654871 26654871 PRJNA1025141_P_NODE_4981_length_363_cov_1.003448_g4920_i0 PRJNA1025141 4981 363 1.003448 3.64251624 uncultured Quadrisphaera sp. 904978 Bacteria Bacteria 43.9 0.0497   NR CAA9387403.1 904978 g4920 i0 41.5 0.537190082644628 65 37 52.9 1 193 2 305 369 CAA9387403.1 MAG: Linoleoyl-CoA desaturase, partial [uncultured Quadrisphaera sp.] diamond 195 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kineosporiales Kineosporiaceae Quadrisphaera uncultured Quadrisphaera sp.
26781918 26781918 PRJNA1025141_P_NODE_11861_length_244_cov_0.900585_g11800_i0 PRJNA1025141 11861 244 0.900585 2.1974274 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 43.1 0.0267   NR HEY7144386.1 2339230 g11800 i0 70 0.245901639344262 20 6 24.6 0 120 61 115 134 HEY7144386.1 N-acetyl-gamma-glutamyl-phosphate reductase [Streptosporangiaceae bacterium] diamond 60 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
27224470 27224470 PRJNA1025141_P_NODE_12483_length_243_cov_0.905882_g12422_i0 PRJNA1025141 12483 243 0.905882 2.20129326 Gaiellaceae bacterium 2838783 Bacteria Bacteria 60.8 1.57e-8   NR HEX7527200.1 2838783 g12422 i0 50.7 0.925925925925926 75 34 88.9 2 243 28 91 165 HEX7527200.1 hypothetical protein [Gaiellaceae bacterium] diamond 225 60.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
27540650 27540650 PRJNA1025141_P_NODE_10924_length_247_cov_0.885057_g10863_i0 PRJNA1025141 10924 247 0.885057 2.18609079 Actinomycetota bacterium 2900548 Bacteria Bacteria 45.4 0.0041   NR HEX9312405.1 2900548 g10863 i0 35.3 0.825910931174089 68 35 71.7 1 24 200 146 213 HEX9312405.1 hypothetical protein [Actinomycetota bacterium] diamond 204 45.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27635438 27635438 PRJNA1025141_P_NODE_6244_length_320_cov_1.246964_g6183_i0 PRJNA1025141 6244 320 1.246964 3.9902848 Actinomycetota bacterium 2900548 Bacteria Bacteria 179 2.9199999999999995e-55   NR MEC8391661.1 2900548 g6183 i0 77.9 1.95 104 23 97.5 0 313 2 54 157 MEC8391661.1 hypothetical protein [Actinomycetota bacterium] diamond 624 179 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28835103 28835103 PRJNA1025141_P_NODE_7788_length_282_cov_1.392344_g7727_i0 PRJNA1025141 7788 282 1.392344 3.92641008 Streptomyces luteogriseus 68233 Bacteria Bacteria 44.7 0.0113   NR MDQ0711999.1 68233 g7727 i0 42.9 0.819148936170213 77 39 79.8 2 11 235 179 252 MDQ0711999.1 hypothetical protein [Streptomyces luteogriseus] diamond 231 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces luteogriseus
29498115 29498115 PRJNA1025141_P_NODE_6510_length_313_cov_1.604167_g6449_i0 PRJNA1025141 6510 313 1.604167 5.02104271 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 92.4 6.89e-20   NR MCC6271726.1 1873462 g6449 i0 43.3 0.929712460063898 97 55 93 0 294 4 12 108 MCC6271726.1 hypothetical protein [Microbacteriaceae bacterium] diamond 291 92.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
31077812 31077812 PRJNA1025141_P_NODE_10795_length_247_cov_0.942529_g10734_i0 PRJNA1025141 10795 247 0.942529 2.32804663 Actinoallomurus sp. 1872127 Bacteria Bacteria 42.7 0.0351   NR HEY0542847.1 1872127 g10734 i0 60.6 0.40080971659919 33 13 40.1 0 139 41 75 107 HEY0542847.1 histidine kinase [Actinoallomurus sp.] diamond 99 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinoallomurus Actinoallomurus sp.
31172175 31172175 PRJNA1025141_P_NODE_10855_length_247_cov_0.885057_g10794_i0 PRJNA1025141 10855 247 0.885057 2.18609079 Actinomycetota bacterium 2900548 Bacteria Bacteria 63.9 1.85e-10   NR MCA1799737.1 2900548 g10794 i0 39 0.935222672064777 77 47 93.5 0 246 16 19 95 MCA1799737.1 HNH endonuclease [Actinomycetota bacterium] diamond 231 63.9 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31488943 31488943 PRJNA1025141_P_NODE_10956_length_247_cov_0.885057_g10895_i0 PRJNA1025141 10956 247 0.885057 2.18609079 Cutibacterium acnes 1747 Bacteria Bacteria 44.3 0.00292   NR MES7586305.1 1747 g10895 i0 81 0.255060728744939 21 4 25.5 0 113 175 33 53 MES7586305.1 hypothetical protein [Cutibacterium acnes] diamond 63 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
31836431 31836431 PRJNA1025141_P_NODE_2777_length_491_cov_2.181818_g2716_i0 PRJNA1025141 2777 491 2.181818 10.71272638 Mycobacteriaceae 1762 Bacteria Bacteria 48.9 0.00283   NR WP_207067860.1 1762 g2716 i0 34.7 0.739307535641548 121 71 72.7 5 44 400 123 237 WP_207067860.1 MULTISPECIES: FAD-dependent oxidoreductase [Mycobacteriaceae] diamond 363 48.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae    

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);;