RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1008049 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27160636 27160636 PRJNA1008049_S_NODE_4422_length_155_cov_6.095238_g4404_i0 PRJNA1008049 4422 155 6.095238 9.4476189 Pseudoclavibacter sp. 1915061 Bacteria Bacteria 53.5 1.72e-6   NR HHW49953.1 1915061 g4404 i0 100 2.41935483870968 25 0 48.4 0 154 80 397 421 HHW49953.1 aspartate kinase [Pseudoclavibacter sp.] diamond 375 53.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Pseudoclavibacter Pseudoclavibacter sp.
29655103 29655103 PRJNA1008049_S_NODE_4310_length_156_cov_4.866142_g4292_i0 PRJNA1008049 4310 156 4.866142 7.59118152 Rothia sp. HSID18 2419515 Bacteria Bacteria 100 2.1599999999999998e-23   NR WP_238693533.1 2419515 g4292 i0 98 0.980769230769231 51 1 98.1 0 154 2 28 78 WP_238693533.1 type IV secretory system conjugative DNA transfer family protein, partial [Rothia sp. HSID18069] diamond 153 100 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia Rothia sp. HSID18069
29932465 29932465 PRJNA1008049_S_NODE_3391_length_164_cov_10.511111_g3373_i0 PRJNA1008049 3391 164 10.511111 17.23822204 Rothia 32207 Bacteria Bacteria 107 1.6e-26   NR WP_168744050.1 2047 g3373 i0 98.1 2.96341463414634 54 1 98.8 0 164 3 159 212 WP_168744050.1 RNA polymerase sigma factor [Rothia dentocariosa] diamond 486 107 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia Rothia dentocariosa
32461559 32461559 PRJNA1008049_S_NODE_2579_length_174_cov_8.179310_g2561_i0 PRJNA1008049 2579 174 8.17931 14.2319994 Actinomycetes 1760 Bacteria Bacteria 87 4.29e-19   NR MES6370626.1 1747 g2561 i0 73.7 10.8103448275862 57 15 98.3 0 172 2 72 128 MES6370626.1 glucosidase [Cutibacterium acnes] diamond 1881 87.4 0.995423340961098 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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