RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA981359 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
27816243 27816243 PRJNA981359_S_NODE_74424_length_238_cov_2.036364_g74324_i0 PRJNA981359 74424 238 2.036364 4.84654632 Corynebacterium pyruviciproducens 598660 Bacteria Bacteria 41.6 0.014   NR WP_284842837.1 598660 g74324 i0 62.5 0.403361344537815 32 11 39.1 1 28 120 26 57 WP_284842837.1 hypothetical protein, partial [Corynebacterium pyruviciproducens] diamond 96 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium pyruviciproducens
27910504 27910504 PRJNA981359_S_NODE_37805_length_307_cov_3.452991_g37705_i0 PRJNA981359 37805 307 3.452991 10.60068237 Microbacterium esteraromaticum 57043 Bacteria Bacteria 151 3.56e-45   NR PYC99673.1 57043 g37705 i0 100 0.801302931596091 82 0 80.1 0 307 62 33 114 PYC99673.1 hypothetical protein B4U78_015020 [Microbacterium esteraromaticum] diamond 246 151 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
28011690 28011690 PRJNA981359_S_NODE_50725_length_279_cov_1.893204_g50625_i0 PRJNA981359 50725 279 1.893204 5.28203916 root 1 Root_unresolved Root_unresolved 64.7 8.36e-10   NR MES6376112.1 1747 g50625 i0 54.5 17.7849462365591 66 28 71 1 244 47 41 104 MES6376112.1 reverse transcriptase family protein [Cutibacterium acnes] diamond 4962 64.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
28068590 28068590 PRJNA981359_S_NODE_61025_length_259_cov_1.913978_g60925_i0 PRJNA981359 61025 259 1.913978 4.95720302 Gaiellaceae bacterium 2838783 Bacteria Bacteria 45.1 0.00623   NR HEY8103918.1 2838783 g60925 i0 39.7 0.72972972972973 63 34 70.7 2 2 184 155 215 HEY8103918.1 phosphatidate cytidylyltransferase [Gaiellaceae bacterium] diamond 189 45.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
28100066 28100066 PRJNA981359_S_NODE_65705_length_251_cov_2.191011_g65605_i0 PRJNA981359 65705 251 2.191011 5.49943761 Cutibacterium acnes 1747 Bacteria Bacteria 56.2 5.61e-8   NR MES7991023.1 1747 g65605 i0 66.7 2.64143426294821 42 13 49 1 156 34 33 74 MES7991023.1 hypothetical protein [Cutibacterium acnes] diamond 663 56.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
28643146 28643146 PRJNA981359_S_NODE_20407_length_359_cov_1.419580_g20307_i0 PRJNA981359 20407 359 1.41958 5.0962922 root 1 Root_unresolved Root_unresolved 61.2 5.79e-9   NR WP_258225418.1 43765 g20307 i0 61.7 3.49303621169916 47 18 39.3 0 309 169 37 83 WP_258225418.1 hypothetical protein [Corynebacterium amycolatum] diamond 1254 61.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium amycolatum
31796100 31796100 PRJNA981359_S_NODE_53917_length_273_cov_1.170000_g53817_i0 PRJNA981359 53917 273 1.17 3.1941 Cutibacterium acnes 1747 Bacteria Bacteria 57 1.52e-8   NR MES6869092.1 1747 g53817 i0 58.5 0.582417582417582 53 20 56 1 2 154 12 64 MES6869092.1 hypothetical protein [Cutibacterium acnes] diamond 159 57 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32302852 32302852 PRJNA981359_S_NODE_47379_length_286_cov_2.197183_g47279_i0 PRJNA981359 47379 286 2.197183 6.28394338 Leucobacter tenebrionis 2873270 Bacteria Bacteria 43.9 0.025   NR WP_223043024.1 2873270 g47279 i0 42.9 0.513986013986014 49 28 51.4 0 86 232 707 755 WP_223043024.1 hypothetical protein [Leucobacter tenebrionis] diamond 147 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leucobacter Leucobacter tenebrionis
32713065 32713065 PRJNA981359_S_NODE_66160_length_251_cov_0.876404_g66060_i0 PRJNA981359 66160 251 0.876404 2.19977404 Streptomyces capillispiralis 68182 Bacteria Bacteria 43.5 0.0222   NR WP_145870881.1 68182 g66060 i0 38.2 0.812749003984064 68 37 75.3 2 43 231 203 270 WP_145870881.1 enoyl-CoA hydratase/isomerase [Streptomyces capillispiralis] diamond 204 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces capillispiralis

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