RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1215813", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Acidobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1215813 · 16 ✖

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
20733248 20733248 PRJNA1215813_P_NODE_7297_length_290_cov_1.078341_g7217_i0 PRJNA1215813 7297 290 1.078341 3.1271889 Bacteria 2 Bacteria Bacteria 174 2.32e-52   NR MCC7154693.1 2026791 g7217 i0 91.7 26.8137931034483 96 8 99.3 0 289 2 151 246 MCC7154693.1 glucose 1-dehydrogenase [Bryobacterales bacterium] diamond 7776 175 0.994285714285714 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
26787995 26787995 PRJNA1215813_P_NODE_8481_length_268_cov_1.589744_g8401_i0 PRJNA1215813 8481 268 1.589744 4.26051392 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 43.1 0.035   NR HEY8848165.1 2651171 g8401 i0 33.3 0.805970149253731 72 42 80.6 2 256 41 115 180 HEY8848165.1 DUF5666 domain-containing protein [Thermoanaerobaculia bacterium] diamond 216 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
26914428 26914428 PRJNA1215813_P_NODE_6622_length_304_cov_1.632035_g6542_i0 PRJNA1215813 6622 304 1.632035 4.9613864 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 137 1.0299999999999999e-38   NR HTW64909.1 2212468 g6542 i0 65.3 1.99342105263158 101 34 98.7 1 3 302 74 174 HTW64909.1 peptidylprolyl isomerase [Bryobacteraceae bacterium] diamond 606 137 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
27312976 27312976 PRJNA1215813_P_NODE_10803_length_248_cov_0.891429_g10723_i0 PRJNA1215813 10803 248 0.891429 2.21074392 Pseudomonadati 3379134 Bacteria Bacteria 73.9 6.12e-15   NR HYX23706.1 2651171 g10723 i0 54.1 4.59677419354839 61 27 72.6 1 1 180 31 91 HYX23706.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 1140 73.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27420596 27420596 PRJNA1215813_P_NODE_5323_length_335_cov_2.381679_g5243_i0 PRJNA1215813 5323 335 2.381679 7.97862465 Terriglobales bacterium 2282142 Bacteria Bacteria 58.9 6.27e-8   NR HST12145.1 2282142 g5243 i0 40.4 10.155223880597 99 52 84.2 5 42 323 3 99 HST12145.1 serine/threonine-protein kinase [Terriglobales bacterium] diamond 3402 58.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
28083302 28083302 PRJNA1215813_P_NODE_10285_length_250_cov_0.881356_g10205_i0 PRJNA1215813 10285 250 0.881356 2.20339 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 44.7 0.00839   NR HEX6100664.1 2651171 g10205 i0 60.5 0.456 38 15 45.6 0 224 111 61 98 HEX6100664.1 VWA domain-containing protein [Thermoanaerobaculia bacterium] diamond 114 44.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28146730 28146730 PRJNA1215813_P_NODE_2405_length_480_cov_1.914005_g2325_i0 PRJNA1215813 2405 480 1.914005 9.187224 Acidobacteriota bacterium 1978231 Bacteria Bacteria 48.9 0.00305   NR MBL8144093.1 1978231 g2325 i0 28.3 0.90625 145 93 90 5 44 475 1027 1161 MBL8144093.1 carboxypeptidase regulatory-like domain-containing protein [Acidobacteriota bacterium] diamond 435 48.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28418162 28418162 PRJNA1215813_P_NODE_2726_length_457_cov_1.015625_g2646_i0 PRJNA1215813 2726 457 1.015625 4.64140625 Bacteria 2 Bacteria Bacteria 51.2 3.71e-4   NR PYS44694.1 1978231 g2646 i0 36.8 1.39824945295405 76 48 49.9 0 235 8 506 581 PYS44694.1 MAG: hypothetical protein DMG13_33495 [Acidobacteriota bacterium] diamond 639 51.6 0.992248062015504 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29188698 29188698 PRJNA1215813_P_NODE_3349_length_415_cov_1.368421_g3269_i0 PRJNA1215813 3349 415 1.368421 5.67894715 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 125 1.57e-30   NR MEP6923977.1 2283092 g3269 i0 58.8 5.60240963855422 102 42 73.7 0 109 414 6 107 MEP6923977.1 phosphoenolpyruvate carboxykinase (GTP) [Pyrinomonadaceae bacterium] diamond 2325 125 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29377953 29377953 PRJNA1215813_P_NODE_5489_length_331_cov_1.186047_g5409_i0 PRJNA1215813 5489 331 1.186047 3.92581557 Acidobacteriota bacterium 1978231 Bacteria Bacteria 116 4.519999999999999e-31   NR MDQ7008653.1 1978231 g5409 i0 80.3 0.688821752265861 76 15 68.9 0 330 103 35 110 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 228 116 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30104179 30104179 PRJNA1215813_P_NODE_12652_length_235_cov_2.351852_g12572_i0 PRJNA1215813 12652 235 2.351852 5.5268522 Acidobacteriota bacterium 1978231 Bacteria Bacteria 57 1.3e-7   NR MEA2692907.1 1978231 g12572 i0 44.1 0.753191489361702 59 31 75.3 1 21 197 42 98 MEA2692907.1 hypothetical protein [Acidobacteriota bacterium] diamond 177 57 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30546632 30546632 PRJNA1215813_P_NODE_6633_length_304_cov_1.350649_g6553_i0 PRJNA1215813 6633 304 1.350649 4.10597296 Acidobacteriota bacterium 1978231 Bacteria Bacteria 56.2 1.45e-6   NR MES1240441.1 1978231 g6553 i0 52.4 0.868421052631579 42 20 41.4 0 7 132 396 437 MES1240441.1 hypothetical protein [Acidobacteriota bacterium] diamond 264 56.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30894335 30894335 PRJNA1215813_P_NODE_10394_length_249_cov_0.886364_g10314_i0 PRJNA1215813 10394 249 0.886364 2.20704636 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 43.1 0.0244   NR HET9193946.1 2910147 g10314 i0 31.6 0.91566265060241 76 51 90.4 1 20 244 110 185 HET9193946.1 hypothetical protein [Vicinamibacterales bacterium] diamond 228 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
30925995 30925995 PRJNA1215813_P_NODE_10014_length_251_cov_0.876404_g9934_i0 PRJNA1215813 10014 251 0.876404 2.19977404 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 72.4 1.5e-12   NR HVF42064.1 2283092 g9934 i0 50 0.932270916334661 78 37 92 2 232 2 64 140 HVF42064.1 alpha-2-macroglobulin family protein [Pyrinomonadaceae bacterium] diamond 234 72.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
31209634 31209634 PRJNA1215813_P_NODE_6495_length_307_cov_1.333333_g6415_i0 PRJNA1215813 6495 307 1.333333 4.09333231 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 81.6 2.91e-16   NR HEX3280956.1 2283092 g6415 i0 45.7 1.79804560260586 94 51 91.9 0 290 9 85 178 HEX3280956.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] diamond 552 81.6 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32696284 32696284 PRJNA1215813_P_NODE_8400_length_270_cov_1.187817_g8320_i0 PRJNA1215813 8400 270 1.187817 3.2071059 Acidobacteriota bacterium 1978231 Bacteria Bacteria 82.4 2.53e-16   NR PYS69186.1 1978231 g8320 i0 52.2 2 90 38 98.9 4 269 3 47 132 PYS69186.1 MAG: NADP-dependent oxidoreductase [Acidobacteriota bacterium] diamond 540 82.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota 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);;