RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA450343" 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

  • PRJNA450343 · 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
26696102 26696102 PRJNA450343_P_NODE_11081_length_166_cov_1.735043_g11013_i0 PRJNA450343 11081 166 1.735043 2.88017138 unclassified Actinoplanes 2626549 Bacteria Bacteria 40.8 0.0375   NR WP_364659926.1 2626549 g11013 i0 48.7 0.704819277108434 39 15 70.5 1 11 127 57 90 WP_364659926.1 MULTISPECIES: hypothetical protein [unclassified Actinoplanes] diamond 117 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes  
27549906 27549906 PRJNA450343_P_NODE_11024_length_167_cov_0.864407_g10956_i0 PRJNA450343 11024 167 0.864407 1.44355969 Cellulomonas sp. 40001 Bacteria Bacteria 40 0.0282   NR MCG2801832.1 40001 g10956 i0 45.5 0.592814371257485 33 18 59.3 0 40 138 45 77 MCG2801832.1 hypothetical protein [Cellulomonas sp.] diamond 99 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas sp.
28844372 28844372 PRJNA450343_P_NODE_6248_length_214_cov_0.927273_g6180_i0 PRJNA450343 6248 214 0.927273 1.98436422 Gaiellaceae bacterium 2838783 Bacteria Bacteria 43.1 0.0142   NR HET7567241.1 2838783 g6180 i0 36.9 0.911214953271028 65 41 91.1 0 200 6 107 171 HET7567241.1 guanylate kinase [Gaiellaceae bacterium] diamond 195 43.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
29160560 29160560 PRJNA450343_P_NODE_12629_length_163_cov_1.438596_g12561_i0 PRJNA450343 12629 163 1.438596 2.34491148 Catenulispora sp. 13_1_2 1962977 Bacteria Bacteria 42.7 0.00672   NR OLE22768.1 1805055 g12561 i0 42.6 2.61349693251534 47 25 82.8 1 1 135 11 57 OLE22768.1 MAG: hypothetical protein AUG49_18025 [Catenulispora sp. 13_1_20CM_3_70_7] diamond 426 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora sp. 13_1_20CM_3_70_7
32793964 32793964 PRJNA450343_P_NODE_8720_length_184_cov_1.503704_g8652_i0 PRJNA450343 8720 184 1.503704 2.76681536 Kocuria palustris 71999 Bacteria Bacteria 116 5.57e-29   NR WP_314302375.1 71999 g8652 i0 100 1.98913043478261 61 0 99.5 0 183 1 31 91 WP_314302375.1 hypothetical protein [Kocuria palustris] diamond 366 116 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria palustris
32904777 32904777 PRJNA450343_P_NODE_11200_length_166_cov_0.871795_g11132_i0 PRJNA450343 11200 166 0.871795 1.4471797 Actinomyces 1654 Bacteria Bacteria 42 0.014   NR MBF0944221.1 29317 g11132 i0 41.9 1.55421686746988 43 25 77.7 0 133 5 42 84 MBF0944221.1 MFS transporter [Actinomyces sp.] diamond 258 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces sp.

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