RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA263496 · 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
26884343 26884343 PRJNA263496_P_NODE_2581_length_567_cov_14.542471_g2338_i0 PRJNA263496 2581 567 14.542471 82.45581057 Mycobacterium tuberculosis 1773 Bacteria Bacteria 276 8.42e-93   NR WP_024754307.1 1773 g2338 i0 94.4 0.756613756613757 143 8 75.7 0 533 105 1 143 WP_024754307.1 hemoglobin alpha subunit family protein [Mycobacterium tuberculosis] diamond 429 276 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
27642886 27642886 PRJNA263496_P_NODE_16844_length_190_cov_1.085106_g16591_i0 PRJNA263496 16844 190 1.085106 2.0617014 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 43.5 0.01   NR HTD57679.1 2586742 g16591 i0 59.3 0.963157894736842 27 11 42.6 0 34 114 310 336 HTD57679.1 Mu transposase C-terminal domain-containing protein [Solirubrobacteraceae bacterium] diamond 183 43.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
28621611 28621611 PRJNA263496_P_NODE_23287_length_164_cov_0.886957_g23034_i0 PRJNA263496 23287 164 0.886957 1.45460948 Corynebacterium sp. ACRPE 2918196 Bacteria Bacteria 112 1.16e-27   NR WP_239280860.1 2918196 g23034 i0 92.6 0.98780487804878 54 4 98.8 0 2 163 322 375 WP_239280860.1 RNA-guided endonuclease InsQ/TnpB family protein [Corynebacterium sp. ACRPE] diamond 162 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium sp. ACRPE
29442156 29442156 PRJNA263496_P_NODE_7310_length_299_cov_0.968000_g7057_i0 PRJNA263496 7310 299 0.968 2.89432 Streptacidiphilus 228398 Bacteria Bacteria 42.4 0.00791   NR WP_165845522.1 228398 g7057 i0 36.2 0.581939799331104 58 28 58.2 1 125 298 1 49 WP_165845522.1 MULTISPECIES: hypothetical protein [Streptacidiphilus] diamond 174 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptacidiphilus  
29505443 29505443 PRJNA263496_P_NODE_20490_length_170_cov_1.090909_g20237_i0 PRJNA263496 20490 170 1.090909 1.8545453 Kitasatospora sp. NPDC 1871188 Bacteria Bacteria 43.5 0.00749   NR WP_355669325.1 3154555 g20237 i0 44.2 0.917647058823529 52 23 84.7 2 166 23 98 147 WP_355669325.1 asparagine synthase-related protein [Kitasatospora sp. NPDC004669] diamond 156 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora sp. NPDC004669
31337897 31337897 PRJNA263496_P_NODE_9556_length_256_cov_0.908213_g9303_i0 PRJNA263496 9556 256 0.908213 2.32502528 Streptosporangium sp. NPDC 47486 Bacteria Bacteria 43.1 0.0301   NR WP_366282089.1 3155410 g9303 i0 41.7 0.703125 60 32 69.1 2 57 233 117 174 WP_366282089.1 sensor histidine kinase [Streptosporangium sp. NPDC051023] diamond 180 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Streptosporangium Streptosporangium sp. NPDC051023

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