RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA306153" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA306153 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28165723 28165723 PRJNA306153_S_NODE_2685_length_153_cov_5.516129_g2672_i0 PRJNA306153 2685 153 5.516129 8.43967737 Acinetobacter 469 Bacteria Bacteria 108 9.019999999999999e-28   NR PPC05428.1 470 g2672 i0 100 4 51 0 100 0 1 153 16 66 PPC05428.1 hypothetical protein AbaMCR10126_18805, partial [Acinetobacter baumannii] diamond 612 108 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
28369025 28369025 PRJNA306153_S_NODE_1786_length_185_cov_3.160256_g1773_i0 PRJNA306153 1786 185 3.160256 5.8464736 Legionella erythra 448 Bacteria Bacteria 44.3 0.00216   NR KTC97694.1 448 g1773 i0 48.1 0.875675675675676 54 26 84.3 1 24 179 53 106 KTC97694.1 hypothetical protein Lery_1533 [Legionella erythra] diamond 162 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Legionellaceae Legionella Legionella erythra
28527192 28527192 PRJNA306153_S_NODE_1827_length_183_cov_3.006494_g1814_i0 PRJNA306153 1827 183 3.006494 5.50188402 Acinetobacter baumannii 470 Bacteria Bacteria 56.2 1.09e-8   NR OLU92949.1 470 g1814 i0 57.4 0.770491803278688 47 20 77 0 153 13 2 48 OLU92949.1 hypothetical protein AWU46_0217185 [Acinetobacter baumannii] diamond 141 56.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
28796928 28796928 PRJNA306153_S_NODE_947_length_246_cov_4.649770_g934_i0 PRJNA306153 947 246 4.64977 11.4384342 Burkholderia 32008 Bacteria Bacteria 79.7 3.9e-17   NR KOT11876.1 13373 g934 i0 56.7 2.90243902439024 60 26 73.2 0 183 4 1 60 KOT11876.1 putative serine acetyltransferase [Burkholderia mallei] diamond 714 80.1 0.995006242197254 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia mallei
28937526 28937526 PRJNA306153_S_NODE_2188_length_169_cov_1.871429_g2175_i0 PRJNA306153 2188 169 1.871429 3.16271501 Pseudomonadota bacterium 1977087 Bacteria Bacteria 62.4 2.81e-10   NR MEM8936747.1 1977087 g2175 i0 64.1 0.692307692307692 39 14 69.2 0 3 119 127 165 MEM8936747.1 hypothetical protein [Pseudomonadota bacterium] diamond 117 62.4 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29365545 29365545 PRJNA306153_S_NODE_1569_length_195_cov_6.981928_g1556_i0 PRJNA306153 1569 195 6.981928 13.6147596 root 1 Root_unresolved Root_unresolved 115 1.3e-28   NR MDP7962615.1 470 g1556 i0 89.1 3.93846153846154 64 7 98.5 0 194 3 138 201 MDP7962615.1 MobV family relaxase [Acinetobacter baumannii] diamond 768 115 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
31274904 31274904 PRJNA306153_S_NODE_1895_length_180_cov_1.966887_g1882_i0 PRJNA306153 1895 180 1.966887 3.5403966 Novosphingobium sp. 1874826 Bacteria Bacteria 43.1 0.0114   NR MFM5917133.1 1874826 g1882 i0 43.2 0.733333333333333 44 25 73.3 0 5 136 12 55 MFM5917133.1 DNA topoisomerase IB [Novosphingobium sp.] diamond 132 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium sp.

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