RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA839281", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA839281 · 4 ✖

analysis 1

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
13583501 13583501 PRJNA839281_S_NODE_36611_length_161_cov_1.366071_g36342_i0 PRJNA839281 36611 161 1.366071 2.19937431 Armatimonadota bacterium 2033014 Bacteria Bacteria 68.6 9.48e-12   NR MFN3421686.1 2033014 g36342 i0 61.7 2.62732919254658 47 18 87.6 0 11 151 13 59 MFN3421686.1 cysteine--tRNA ligase [Armatimonadota bacterium] diamond 423 68.6 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
26991159 26991159 PRJNA839281_S_NODE_33182_length_163_cov_0.894737_g32913_i0 PRJNA839281 33182 163 0.894737 1.45842131 Armatimonadota bacterium 2033014 Bacteria Bacteria 87.4 1.27e-18   NR MBN9502614.1 2033014 g32913 i0 66.7 0.993865030674847 54 18 99.4 0 163 2 276 329 MBN9502614.1 enterochelin esterase [Armatimonadota bacterium] diamond 162 87.4 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
30284730 30284730 PRJNA839281_S_NODE_27152_length_167_cov_0.864407_g26883_i0 PRJNA839281 27152 167 0.864407 1.44355969 root 1 Root_unresolved Root_unresolved 70.5 1.03e-12   NR MBI3927467.1 2033014 g26883 i0 59.3 6.8622754491018 54 22 97 0 6 167 167 220 MBI3927467.1 alpha/beta hydrolase [Armatimonadota bacterium] diamond 1146 70.9 0.994358251057828 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31318562 31318562 PRJNA839281_S_NODE_6195_length_333_cov_1.602113_g5926_i0 PRJNA839281 6195 333 1.602113 5.33503629 Armatimonadota bacterium 2033014 Bacteria Bacteria 41.6 0.0295   NR HTE20345.1 2033014 g5926 i0 40.5 0.333333333333333 37 22 33.3 0 211 321 20 56 HTE20345.1 hypothetical protein [Armatimonadota bacterium] diamond 111 41.6 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium

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