RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA575566 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27585027 27585027 PRJNA575566_P_NODE_28404_length_203_cov_0.901408_g28207_i0 PRJNA575566 28404 203 0.901408 1.82985824 Cellulomonas sp. PSBB 40001 Bacteria Bacteria 102 8.89e-27   NR ASR55687.1 2003551 g28207 i0 62.7 0.990147783251232 67 25 99 0 3 203 22 88 ASR55687.1 hypothetical protein CBP52_11970 [Cellulomonas sp. PSBB021] diamond 201 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas sp. PSBB021
28027180 28027180 PRJNA575566_P_NODE_3305_length_571_cov_0.821569_g3110_i0 PRJNA575566 3305 571 0.821569 4.69115899 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 46.6 0.0341   NR HEX4539557.1 2201156 g3110 i0 32.9 0.893169877408056 170 71 74.1 8 517 95 79 234 HEX4539557.1 hypothetical protein [Acidimicrobiales bacterium] diamond 510 46.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
30630089 30630089 PRJNA575566_P_NODE_29053_length_202_cov_0.907801_g28856_i0 PRJNA575566 29053 202 0.907801 1.83375802 Micrococcales 85006 Bacteria Bacteria 68.2 2.34e-11   NR MDO5698836.1 1863 g28856 i0 44.1 9.34158415841584 68 35 96.5 1 199 5 122 189 MDO5698836.1 peptidoglycan-binding domain-containing protein [Dermatophilus congolensis] diamond 1887 68.6 0.994169096209913 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae Dermatophilus Dermatophilus congolensis
30647987 30647987 PRJNA575566_P_NODE_13853_length_283_cov_0.792793_g13656_i0 PRJNA575566 13853 283 0.792793 2.24360419 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 43.9 0.0104   NR HXA74293.1 2201156 g13656 i0 38.8 1.15547703180212 67 34 63.6 2 84 263 72 138 HXA74293.1 DUF501 domain-containing protein [Acidimicrobiales bacterium] diamond 327 43.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
30995884 30995884 PRJNA575566_P_NODE_27034_length_205_cov_0.888889_g26837_i0 PRJNA575566 27034 205 0.888889 1.82222245 Mycobacteriales bacterium 1957017 Bacteria Bacteria 47 6.9e-4   NR HEX3811592.1 1957017 g26837 i0 41.4 0.848780487804878 58 32 84.9 2 203 30 80 135 HEX3811592.1 acetoin utilization protein AcuC [Mycobacteriales bacterium] diamond 174 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales     Mycobacteriales bacterium
31786116 31786116 PRJNA575566_P_NODE_16777_length_257_cov_4.244898_g16580_i0 PRJNA575566 16777 257 4.244898 10.90938786 Parafrankia sp. EUN1f 102897 Bacteria Bacteria 44.7 0.00851   NR EFC82233.1 102897 g16580 i0 41.4 0.67704280155642 58 33 67.7 1 25 198 29 85 EFC82233.1 conserved hypothetical protein [Parafrankia sp. EUN1f] diamond 174 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae Parafrankia Parafrankia sp. EUN1f
31976047 31976047 PRJNA575566_P_NODE_24318_length_209_cov_0.864865_g24121_i0 PRJNA575566 24318 209 0.864865 1.80756785 Actinomycetota bacterium 2900548 Bacteria Bacteria 45.1 0.00336   NR MEM9522269.1 2900548 g24121 i0 43.9 0.588516746411483 41 22 57.4 1 184 65 122 162 MEM9522269.1 mechanosensitive ion channel family protein [Actinomycetota bacterium] diamond 123 45.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota 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);;