RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA738523", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 9 ✖

tax_phylum 1

  • Acidobacteriota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA738523 · 9 ✖

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
22397009 22397009 PRJNA738523_P_NODE_4878_length_322_cov_1.216867_g4807_i0 PRJNA738523 4878 322 1.216867 3.91831174 Bacteria 2 Bacteria Bacteria 139 1.66e-35   NR MEA2601550.1 1978231 g4807 i0 64.2 10.695652173913 106 38 98.8 0 320 3 3046 3151 MEA2601550.1 hypothetical protein [Acidobacteriota bacterium] diamond 3444 139 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26831027 26831027 PRJNA738523_P_NODE_10961_length_250_cov_1.734463_g10890_i0 PRJNA738523 10961 250 1.734463 4.3361575 Luteitalea sp. 2004800 Bacteria Bacteria 44.7 0.00799   NR MPY89698.1 2004800 g10890 i0 34.6 0.936 78 36 81.6 3 206 3 32 104 MPY89698.1 hypothetical protein [Luteitalea sp.] diamond 234 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales Vicinamibacteraceae Luteitalea Luteitalea sp.
27621302 27621302 PRJNA738523_P_NODE_5844_length_300_cov_1.356828_g5773_i0 PRJNA738523 5844 300 1.356828 4.070484 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 42.4 0.0448   NR HEV8074794.1 3069120 g5773 i0 32.4 0.74 74 45 74 1 66 287 2 70 HEV8074794.1 ester cyclase [Candidatus Acidiferrum sp.] diamond 222 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
27684666 27684666 PRJNA738523_P_NODE_6404_length_290_cov_1.336406_g6333_i0 PRJNA738523 6404 290 1.336406 3.8755774 Acidobacteriota bacterium 1978231 Bacteria Bacteria 55.1 2.71e-6   NR MBM3728759.1 1978231 g6333 i0 33 2.64827586206897 88 56 91 1 286 23 62 146 MBM3728759.1 hypothetical protein [Acidobacteriota bacterium] diamond 768 55.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28063115 28063115 PRJNA738523_P_NODE_12165_length_248_cov_0.880000_g12094_i0 PRJNA738523 12165 248 0.88 2.1824 Acidobacteriota bacterium 1978231 Bacteria Bacteria 97.8 5.09e-24   NR MEM8961170.1 1978231 g12094 i0 72.9 3.04838709677419 59 16 71.4 0 67 243 10 68 MEM8961170.1 DUF2237 domain-containing protein [Acidobacteriota bacterium] diamond 756 97.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28294284 28294284 PRJNA738523_P_NODE_9766_length_257_cov_1.673913_g9695_i0 PRJNA738523 9766 257 1.673913 4.30195641 Bacteria 2 Bacteria Bacteria 62.4 5.24e-9   NR MBM3785624.1 1978231 g9695 i0 41 4.79766536964981 78 39 85.2 2 13 231 166 241 MBM3785624.1 M2 family metallopeptidase [Acidobacteriota bacterium] diamond 1233 62.8 0.993630573248408 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28442238 28442238 PRJNA738523_P_NODE_10506_length_251_cov_0.865169_g10435_i0 PRJNA738523 10506 251 0.865169 2.17157419 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 44.3 0.0114   NR HEV2199939.1 2212468 g10435 i0 34.7 0.860557768924303 72 44 83.7 2 28 237 39 109 HEV2199939.1 alanine--glyoxylate aminotransferase family protein [Bryobacteraceae bacterium] diamond 216 44.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
28947539 28947539 PRJNA738523_P_NODE_14728_length_243_cov_1.758824_g14657_i0 PRJNA738523 14728 243 1.758824 4.27394232 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42.7 0.0324   NR MBS1785911.1 1978231 g14657 i0 31.8 0.814814814814815 66 43 79 1 5 196 85 150 MBS1785911.1 polynucleotide adenylyltransferase [Acidobacteriota bacterium] diamond 198 42.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30021073 30021073 PRJNA738523_P_NODE_15571_length_242_cov_0.911243_g15500_i0 PRJNA738523 15571 242 0.911243 2.20520806 Blastocatellia bacterium 2052146 Bacteria Bacteria 42.4 0.039   NR MEO6725793.1 2052146 g15500 i0 40.4 0.644628099173554 52 22 58.3 3 6 146 128 175 MEO6725793.1 DUF1361 domain-containing protein [Blastocatellia bacterium] diamond 156 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia 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);;