RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1113956 · 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
26783320 26783320 PRJNA1113956_P_NODE_20401_length_249_cov_0.875000_g20061_i0 PRJNA1113956 20401 249 0.875 2.17875 Streptomyces barkulensis 1257026 Bacteria Bacteria 65.5 3.88e-10   NR WP_143688485.1 1257026 g20061 i0 40.7 0.975903614457831 81 48 97.6 0 5 247 459 539 WP_143688485.1 BTAD domain-containing putative transcriptional regulator [Streptomyces barkulensis] diamond 243 65.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces barkulensis
29941754 29941754 PRJNA1113956_P_NODE_20371_length_249_cov_0.875000_g20031_i0 PRJNA1113956 20371 249 0.875 2.17875 Leifsonia sp. Leaf336 1736341 Bacteria Bacteria 82.8 7.52e-18   NR WP_055914287.1 1736341 g20031 i0 82.2 0.542168674698795 45 8 54.2 0 239 105 109 153 WP_055914287.1 hypothetical protein [Leifsonia sp. Leaf336] diamond 135 82.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. Leaf336
30415859 30415859 PRJNA1113956_P_NODE_22773_length_241_cov_0.916667_g22433_i0 PRJNA1113956 22773 241 0.916667 2.20916747 Micrococcus endophyticus 455343 Bacteria Bacteria 151 6.87e-42   NR WP_184171610.1 455343 g22433 i0 98.8 0.995850622406639 80 1 99.6 0 1 240 289 368 WP_184171610.1 N-acetylglucosamine-6-phosphate deacetylase [Micrococcus endophyticus] diamond 240 151 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus endophyticus
30636529 30636529 PRJNA1113956_P_NODE_20133_length_250_cov_0.870056_g19793_i0 PRJNA1113956 20133 250 0.870056 2.17514 Lawsonella 1847725 Bacteria Bacteria 175 5.58e-54   NR WP_290599045.1 1847725 g19793 i0 100 0.984 82 0 98.4 0 3 248 80 161 WP_290599045.1 MULTISPECIES: low molecular weight protein-tyrosine-phosphatase [Lawsonella] diamond 246 175 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
32312911 32312911 PRJNA1113956_P_NODE_20359_length_249_cov_0.875000_g20019_i0 PRJNA1113956 20359 249 0.875 2.17875 Dietzia psychralcaliphila 139021 Bacteria Bacteria 57.8 1.56e-7   NR WP_107745459.1 139021 g20019 i0 45.9 1.02409638554217 85 40 100 4 1 249 147 227 WP_107745459.1 hypothetical protein [Dietzia psychralcaliphila] diamond 255 57.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Dietziaceae Dietzia Dietzia psychralcaliphila
32407602 32407602 PRJNA1113956_P_NODE_19519_length_252_cov_2.027933_g19179_i0 PRJNA1113956 19519 252 2.027933 5.11039116 Atopobium sp. ICM42b 1190620 Bacteria Bacteria 85.5 1.66e-19   NR WP_035427395.1 1190620 g19179 i0 95.3 0.511904761904762 43 2 51.2 0 252 124 56 98 WP_035427395.1 type II toxin-antitoxin system RelB/DinJ family antitoxin [Atopobium sp. ICM42b] diamond 129 85.5 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales Atopobiaceae Atopobium Atopobium sp. ICM42b

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