RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB81171", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 15 ✖

tax_phylum 1

  • Acidobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81171 · 15 ✖

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
3965544 3965544 PRJEB81171_P_NODE_4724_length_306_cov_1.463519_g4597_i0 PRJEB81171 4724 306 1.463519 4.47836814 Paludibaculum fermentans 1473598 Bacteria Bacteria 429 1.13e-115   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g4597 i0 92.881 73.0424836601307 295 21 96 0 12 306 4786133 4785839 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 22351 429 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
5241933 5241933 PRJEB81171_P_NODE_10245_length_228_cov_2.554839_g10118_i0 PRJEB81171 10245 228 2.554839 5.82503292 Bacteria 2 Bacteria Bacteria 112 4.01e-29   NR MCC7240623.1 1978231 g10118 i0 76 1.97368421052632 75 18 98.7 0 3 227 54 128 MCC7240623.1 SDR family oxidoreductase [Acidobacteriota bacterium] diamond 450 112 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
11617984 11617984 PRJEB81171_P_NODE_6190_length_276_cov_1.320197_g6063_i0 PRJEB81171 6190 276 1.320197 3.64374372 Paludibaculum fermentans 1473598 Bacteria Bacteria 350 8.04e-92   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g6063 i0 89.781 239.952898550725 274 27 99 1 3 276 4787199 4787471 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 66227 350 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
16716067 16716067 PRJEB81171_P_NODE_10134_length_237_cov_2.109756_g10007_i0 PRJEB81171 10134 237 2.109756 5.00012172 Paludibaculum fermentans 1473598 Bacteria Bacteria 322 1.47e-83   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g10007 i0 91.139 383.46835443038 237 21 100 0 1 237 4784808 4784572 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 90882 322 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
23091347 23091347 PRJEB81171_P_NODE_3679_length_345_cov_1.143382_g3552_i0 PRJEB81171 3679 345 1.143382 3.9446679 Paludibaculum fermentans 1473598 Bacteria Bacteria 560 4.39e-155   NTclustered gi|1929489624|gb|CP063849.1| 1473598 g3552 i0 95.942 103.776811594203 345 14 100 0 1 345 4786572 4786228 Paludibaculum fermentans strain P105 chromosome, complete genome blastn 35803 560 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Paludibaculum Paludibaculum fermentans
26654111 26654111 PRJEB81171_P_NODE_961_length_668_cov_0.979832_g842_i0 PRJEB81171 961 668 0.979832 6.54527776 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 105 4.01e-23   NR HYY56856.1 2283092 g842 i0 39.7 1.57185628742515 174 91 78.1 4 141 662 2 161 HYY56856.1 SDR family oxidoreductase [Pyrinomonadaceae bacterium] diamond 1050 105 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27128646 27128646 PRJEB81171_P_NODE_5322_length_290_cov_1.317972_g5195_i0 PRJEB81171 5322 290 1.317972 3.8221188 Acidobacteriota bacterium 1978231 Bacteria Bacteria 67.8 9.82e-11   NR MEE8462667.1 1978231 g5195 i0 47.4 0.806896551724138 78 40 79.7 1 283 53 2 79 MEE8462667.1 ankyrin repeat domain-containing protein [Acidobacteriota bacterium] diamond 234 67.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27192157 27192157 PRJEB81171_P_NODE_6722_length_267_cov_2.211340_g6595_i0 PRJEB81171 6722 267 2.21134 5.9042778 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 143 3.97e-40   NR MBC7898975.1 2283092 g6595 i0 77.3 6.65168539325843 88 20 98.9 0 4 267 63 150 MBC7898975.1 J domain-containing protein [Pyrinomonadaceae bacterium] diamond 1776 143 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27974558 27974558 PRJEB81171_P_NODE_9825_length_243_cov_0.917647_g9698_i0 PRJEB81171 9825 243 0.917647 2.22988221 Bacteria 2 Bacteria Bacteria 84.7 1.09e-17   NR MEP7147369.1 1978231 g9698 i0 56.1 4.81481481481481 82 28 91.4 2 20 241 96 177 MEP7147369.1 LecA/PA-IL family lectin [Acidobacteriota bacterium] diamond 1170 85.1 0.995299647473561 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28297511 28297511 PRJEB81171_P_NODE_6166_length_276_cov_1.536946_g6039_i0 PRJEB81171 6166 276 1.536946 4.24197096 Acidobacteriota bacterium 1978231 Bacteria Bacteria 72.4 2.08e-12   NR MEP7213630.1 1978231 g6039 i0 46.9 1.85869565217391 81 43 88 0 28 270 27 107 MEP7213630.1 EAL domain-containing protein [Acidobacteriota bacterium] diamond 513 72.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29654865 29654865 PRJEB81171_P_NODE_4070_length_328_cov_1.564706_g3943_i0 PRJEB81171 4070 328 1.564706 5.13223568 Blastocatellia bacterium 2052146 Bacteria Bacteria 72.4 3.94e-12   NR MEA2203973.1 2052146 g3943 i0 48.6 0.960365853658537 105 47 93.3 3 326 21 919 1019 MEA2203973.1 hypothetical protein [Blastocatellia bacterium] diamond 315 72.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30445176 30445176 PRJEB81171_P_NODE_8053_length_251_cov_0.876404_g7926_i0 PRJEB81171 8053 251 0.876404 2.19977404 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 43.5 0.022   NR HTP32768.1 2952895 g7926 i0 45.5 0.657370517928287 55 28 65.7 2 175 11 22 74 HTP32768.1 hypothetical protein [Candidatus Acidiferrales bacterium] diamond 165 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
31551477 31551477 PRJEB81171_P_NODE_9156_length_246_cov_0.901734_g9029_i0 PRJEB81171 9156 246 0.901734 2.21826564 Edaphobacter sp. 1934404 Bacteria Bacteria 100 2.47e-22   NR HEX2918398.1 1934404 g9029 i0 55.6 0.98780487804878 81 36 98.8 0 244 2 368 448 HEX2918398.1 PAS domain S-box protein [Edaphobacter sp.] diamond 243 100 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp.
31677650 31677650 PRJEB81171_P_NODE_7157_length_260_cov_1.983957_g7030_i0 PRJEB81171 7157 260 1.983957 5.1582882 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 117 1.2e-29   NR HTA67929.1 2212468 g7030 i0 67.4 0.992307692307692 86 28 99.2 0 259 2 144 229 HTA67929.1 cupin domain-containing protein [Bryobacteraceae bacterium] diamond 258 117 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32878461 32878461 PRJEB81171_P_NODE_7040_length_262_cov_1.650794_g6913_i0 PRJEB81171 7040 262 1.650794 4.32508028 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 159 1.08e-43   NR HEX8249858.1 2283092 g6913 i0 91.9 1.96946564885496 86 7 98.5 0 260 3 425 510 HEX8249858.1 glycoside hydrolase family 15 protein [Pyrinomonadaceae bacterium] diamond 516 159 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;