RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA556842" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA556842 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
15824546 15824546 PRJNA556842_P_NODE_16153_length_163_cov_1.238095_g15648_i0 PRJNA556842 16153 163 1.238095 2.01809485 Leifsonia sp. EB41 3156260 Bacteria Bacteria 102 1.2199999999999999e-23   NR WP_370054949.1 3156260 g15648 i0 90.7 0.993865030674847 54 5 99.4 0 2 163 621 674 WP_370054949.1 beta-glucosidase [Leifsonia sp. EB41] diamond 162 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. EB41
20923933 20923933 PRJNA556842_P_NODE_16037_length_164_cov_1.212598_g15532_i0 PRJNA556842 16037 164 1.212598 1.98866072 Leifsonia sp. TF 1870902 Bacteria Bacteria 100 1.41e-24   NR WP_208041091.1 2815212 g15532 i0 100 0.98780487804878 54 0 98.8 0 2 163 46 99 WP_208041091.1 LuxR C-terminal-related transcriptional regulator [Leifsonia sp. TF02-11] diamond 162 100 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. TF02-11
26920102 26920102 PRJNA556842_P_NODE_9062_length_263_cov_1.694690_g8557_i0 PRJNA556842 9062 263 1.69469 4.4570347 Actinomycetota bacterium 2900548 Bacteria Bacteria 42.7 0.0486   NR HEX6231432.1 2900548 g8557 i0 44.2 0.490494296577947 43 24 49 0 130 2 426 468 HEX6231432.1 PAS domain S-box protein [Actinomycetota bacterium] diamond 129 42.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27962677 27962677 PRJNA556842_P_NODE_2565_length_623_cov_8.119454_g2134_i0 PRJNA556842 2565 623 8.119454 50.58419842 Mycobacterium xenopi 4 1789 Bacteria Bacteria 45.1 0.0156   NR EUA33501.1 1299334 g2134 i0 38.2 0.428571428571429 89 42 42.4 5 551 288 10 86 EUA33501.1 AMP-binding enzyme family protein [Mycobacterium xenopi 4042] diamond 267 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium xenopi
29288667 29288667 PRJNA556842_P_NODE_15889_length_165_cov_1.210938_g15384_i0 PRJNA556842 15889 165 1.210938 1.9980477 Nocardioides zeae 1457234 Bacteria Bacteria 75.1 4.24e-14   NR WP_309632886.1 1457234 g15384 i0 78.7 0.854545454545454 47 10 85.5 0 23 163 10 56 WP_309632886.1 hypothetical protein [Nocardioides zeae] diamond 141 75.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides zeae
32133177 32133177 PRJNA556842_P_NODE_16518_length_160_cov_1.308943_g16013_i0 PRJNA556842 16518 160 1.308943 2.0943088 Microbacterium sp. SS28 2919948 Bacteria Bacteria 44.3 0.00354   NR WP_243073899.1 2919948 g16013 i0 35.8 1.89375 53 29 90 1 14 157 1091 1143 WP_243073899.1 Pls/PosA family non-ribosomal peptide synthetase [Microbacterium sp. SS28] diamond 303 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. SS28

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