RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 15 ✖

tax_phylum 1

  • Acidobacteriota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA772154 · 15 ✖

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
7584857 7584857 PRJNA772154_P_NODE_18126_length_252_cov_0.871508_g17941_i0 PRJNA772154 18126 252 0.871508 2.19620016 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 71.2 9.91e-13   NR MFN7918501.1 2212468 g17941 i0 68.9 0.535714285714286 45 14 53.6 0 114 248 1 45 MFN7918501.1 ABC transporter ATP-binding protein [Bryobacteraceae bacterium] diamond 135 71.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
14776235 14776235 PRJNA772154_P_NODE_18932_length_250_cov_0.881356_g18747_i0 PRJNA772154 18932 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 107 9.98e-25   NR HKQ77301.1 2052146 g18747 i0 65.8 2.748 76 26 91.2 0 249 22 858 933 HKQ77301.1 hypothetical protein [Blastocatellia bacterium] diamond 687 107 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
22424731 22424731 PRJNA772154_P_NODE_22358_length_243_cov_0.917647_g22173_i0 PRJNA772154 22358 243 0.917647 2.22988221 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 159 2.19e-44   NR HTM33158.1 2910147 g22173 i0 90.1 1 81 8 100 0 1 243 384 464 HTM33158.1 5-carboxymethyl-2-hydroxymuconate semialdehyde dehydrogenase [Vicinamibacterales bacterium] diamond 243 159 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
23700344 23700344 PRJNA772154_P_NODE_19679_length_249_cov_0.886364_g19494_i0 PRJNA772154 19679 249 0.886364 2.20704636 Acidobacteriota bacterium 1978231 Bacteria Bacteria 157 1.4799999999999996e-43   NR MBU6363700.1 1978231 g19494 i0 97.6 1.97590361445783 82 2 98.8 0 3 248 369 450 MBU6363700.1 alpha-keto acid decarboxylase family protein [Acidobacteriota bacterium] diamond 492 157 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27432781 27432781 PRJNA772154_P_NODE_21343_length_245_cov_0.906977_g21158_i0 PRJNA772154 21343 245 0.906977 2.22209365 Acidobacteriota bacterium 1978231 Bacteria Bacteria 94.4 2.68e-20   NR MES1245985.1 1978231 g21158 i0 59.3 2.97551020408163 81 33 99.2 0 243 1 725 805 MES1245985.1 DUF3857 domain-containing protein [Acidobacteriota bacterium] diamond 729 94.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27969257 27969257 PRJNA772154_P_NODE_21185_length_245_cov_0.906977_g21000_i0 PRJNA772154 21185 245 0.906977 2.22209365 Terriglobus tenax 1111115 Bacteria Bacteria 127 1.24e-32   NR WP_263409933.1 1111115 g21000 i0 92.6 0.991836734693878 81 6 99.2 0 1 243 363 443 WP_263409933.1 ABC transporter permease [Terriglobus tenax] diamond 243 127 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus tenax
29169250 29169250 PRJNA772154_P_NODE_22689_length_242_cov_0.923077_g22504_i0 PRJNA772154 22689 242 0.923077 2.23384634 Acidobacteriota bacterium 1978231 Bacteria Bacteria 77 2.32e-15   NR PYR22917.1 1978231 g22504 i0 66.1 2.0702479338843 56 19 69.4 0 170 3 1 56 PYR22917.1 MAG: ATP synthase F1 subunit delta [Acidobacteriota bacterium] diamond 501 77 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29768908 29768908 PRJNA772154_P_NODE_22651_length_242_cov_0.923077_g22466_i0 PRJNA772154 22651 242 0.923077 2.23384634 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 147 2.31e-42   NR HVG71457.1 2910147 g22466 i0 86.3 0.991735537190083 80 11 99.2 0 3 242 76 155 HVG71457.1 tRNA pseudouridine(38-40) synthase TruA [Vicinamibacterales bacterium] diamond 240 147 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
30053160 30053160 PRJNA772154_P_NODE_17711_length_253_cov_0.866667_g17526_i0 PRJNA772154 17711 253 0.866667 2.19266751 Bryobacterales bacterium 2026791 Bacteria Bacteria 107 4.08e-26   NR MBL8177792.1 2026791 g17526 i0 72.9 0.8300395256917 70 19 83 0 237 28 197 266 MBL8177792.1 hypothetical protein [Bryobacterales bacterium] diamond 210 107 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
31127139 31127139 PRJNA772154_P_NODE_20295_length_247_cov_0.896552_g20110_i0 PRJNA772154 20295 247 0.896552 2.21448344 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 87 4.49e-18   NR MEZ5351363.1 2212468 g20110 i0 74.5 1.23886639676113 51 13 61.9 0 245 93 301 351 MEZ5351363.1 2-oxoacid:ferredoxin oxidoreductase subunit beta [Bryobacteraceae bacterium] diamond 306 87 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31475514 31475514 PRJNA772154_P_NODE_22776_length_242_cov_0.923077_g22591_i0 PRJNA772154 22776 242 0.923077 2.23384634 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 107 7.450000000000001e-26   NR HTG35578.1 2651171 g22591 i0 65.4 3.81818181818182 78 27 96.7 0 241 8 63 140 HTG35578.1 glycosyltransferase [Thermoanaerobaculia bacterium] diamond 924 107 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31886506 31886506 PRJNA772154_P_NODE_20777_length_246_cov_0.901734_g20592_i0 PRJNA772154 20777 246 0.901734 2.21826564 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 142 2.09e-37   NR MFN7977642.1 2910147 g20592 i0 91.5 2 82 7 100 0 1 246 196 277 MFN7977642.1 glutamine amidotransferase [Vicinamibacterales bacterium] diamond 492 142 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32487905 32487905 PRJNA772154_P_NODE_19499_length_249_cov_0.886364_g19314_i0 PRJNA772154 19499 249 0.886364 2.20704636 Acidobacteriota bacterium 1978231 Bacteria Bacteria 182 5.449999999999998e-54   NR MBL8171146.1 1978231 g19314 i0 100 1 83 0 100 0 249 1 102 184 MBL8171146.1 HD domain-containing protein [Acidobacteriota bacterium] diamond 249 182 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32645256 32645256 PRJNA772154_P_NODE_19600_length_249_cov_0.886364_g19415_i0 PRJNA772154 19600 249 0.886364 2.20704636 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 124 3.02e-34   NR MEZ5420355.1 2910147 g19415 i0 78.3 2 83 18 100 0 1 249 32 114 MEZ5420355.1 metalloregulator ArsR/SmtB family transcription factor [Vicinamibacterales bacterium] diamond 498 124 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
32645257 32645257 PRJNA772154_P_NODE_21260_length_245_cov_0.906977_g21075_i0 PRJNA772154 21260 245 0.906977 2.22209365 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 128 2.84e-33   NR HEX3646102.1 2910147 g21075 i0 80 4.88571428571429 80 16 98 0 6 245 307 386 HEX3646102.1 diaminopimelate decarboxylase [Vicinamibacterales bacterium] diamond 1197 128 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales 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);;