RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA888104" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA888104 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
28697844 28697844 PRJNA888104_P_NODE_18187_length_241_cov_1.226744_g18118_i0 PRJNA888104 18187 241 1.226744 2.95645304 Mycobacteriaceae 1762 Bacteria Bacteria 43.5 0.0187   NR WP_133427604.1 1762 g18118 i0 47.5 0.995850622406639 40 21 49.8 0 21 140 176 215 WP_133427604.1 MULTISPECIES: phage baseplate assembly protein V [Mycobacteriaceae] diamond 240 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae    
29305366 29305366 PRJNA888104_P_NODE_23389_length_224_cov_2.677419_g23320_i0 PRJNA888104 23389 224 2.677419 5.99741856 Actinomycetes 1760 Bacteria Bacteria 69.7 5.63e-12   NR WP_263797007.1 344163 g23320 i0 60 4.09821428571429 60 24 80.4 0 209 30 30 89 WP_263797007.1 phosphotransferase [Microbacterium terricola] diamond 918 70.1 0.994293865905849 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium terricola
31224356 31224356 PRJNA888104_P_NODE_10215_length_315_cov_0.865854_g10146_i0 PRJNA888104 10215 315 0.865854 2.7274401 Mycobacterium sp. GA-1841 1834154 Bacteria Bacteria 44.3 0.0193   NR WP_076195493.1 1834154 g10146 i0 40.7 0.561904761904762 59 34 55.2 1 176 3 154 212 WP_076195493.1 TetR/AcrR family transcriptional regulator [Mycobacterium sp. GA-1841] diamond 177 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. GA-1841

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