RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1013345" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1013345 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
12481362 12481362 PRJNA1013345_P_NODE_28410_length_160_cov_1.522124_g28280_i0 PRJNA1013345 28410 160 1.522124 2.4353984 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 69.7 1.99e-12   NR HEY7170104.1 2910147 g28280 i0 84.6 3.01875 39 6 73.1 0 36 152 1 39 HEY7170104.1 UbiA-like polyprenyltransferase [Vicinamibacterales bacterium] diamond 483 69.7 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
26717920 26717920 PRJNA1013345_P_NODE_23701_length_165_cov_0.864407_g23571_i0 PRJNA1013345 23701 165 0.864407 1.42627155 Acidobacteriota bacterium 1978231 Bacteria Bacteria 90.1 2.7e-19   NR RPI51883.1 1978231 g23571 i0 78.2 1 55 12 100 0 1 165 582 636 RPI51883.1 MAG: TonB-dependent receptor [Acidobacteriota bacterium] diamond 165 90.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27509024 27509024 PRJNA1013345_P_NODE_17263_length_177_cov_2.746154_g17133_i0 PRJNA1013345 17263 177 2.746154 4.86069258 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 42.4 0.0215   NR HLJ29653.1 2976921 g17133 i0 44.4 0.610169491525424 36 20 61 0 31 138 313 348 HLJ29653.1 inorganic phosphate transporter [Candidatus Angelobacter sp.] diamond 108 42.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
28014224 28014224 PRJNA1013345_P_NODE_30245_length_158_cov_4.027027_g30115_i0 PRJNA1013345 30245 158 4.027027 6.36270266 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 110 1.62e-26   NR HWI20346.1 2910147 g30115 i0 96.2 1.9746835443038 52 2 98.7 0 2 157 522 573 HWI20346.1 hypothetical protein [Vicinamibacterales bacterium] diamond 312 110 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
28424619 28424619 PRJNA1013345_P_NODE_26066_length_162_cov_1.773913_g25936_i0 PRJNA1013345 26066 162 1.773913 2.87373906 Acidobacteriota bacterium 1978231 Bacteria Bacteria 99 5.969999999999999e-23   NR MEP7076785.1 1978231 g25936 i0 88.9 1 54 6 100 0 1 162 144 197 MEP7076785.1 glutamine-hydrolyzing carbamoyl-phosphate synthase small subunit [Acidobacteriota bacterium] diamond 162 99 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28456205 28456205 PRJNA1013345_P_NODE_16366_length_179_cov_2.090909_g16236_i0 PRJNA1013345 16366 179 2.090909 3.74272711 Acidobacteriota bacterium 1978231 Bacteria Bacteria 86.3 7.26e-18   NR MDP9324294.1 1978231 g16236 i0 69.5 0.988826815642458 59 18 98.9 0 177 1 297 355 MDP9324294.1 translocation/assembly module TamB domain-containing protein [Acidobacteriota bacterium] diamond 177 86.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28740258 28740258 PRJNA1013345_P_NODE_21687_length_168_cov_1.338843_g21557_i0 PRJNA1013345 21687 168 1.338843 2.24925624 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 73.9 1.32e-13   NR HEX5216657.1 2910147 g21557 i0 63 1.92857142857143 54 20 96.4 0 6 167 780 833 HEX5216657.1 ABC transporter permease [Vicinamibacterales bacterium] diamond 324 73.9 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
28834945 28834945 PRJNA1013345_P_NODE_23228_length_165_cov_1.381356_g23098_i0 PRJNA1013345 23228 165 1.381356 2.2792374 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 72 6.03e-13   NR HSY49453.1 2651171 g23098 i0 78.2 3 55 11 98.2 1 164 3 2244 2298 HSY49453.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 495 72 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28929696 28929696 PRJNA1013345_P_NODE_33428_length_153_cov_2.688679_g33298_i0 PRJNA1013345 33428 153 2.688679 4.11367887 Bryobacter sp. 1962911 Bacteria Bacteria 82 1.48e-16   NR MCU0245855.1 1962911 g33298 i0 79.6 12.4901960784314 49 10 96.1 0 152 6 410 458 MCU0245855.1 ribulokinase [Bryobacter sp.] diamond 1911 82 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae Bryobacter Bryobacter sp.
29655474 29655474 PRJNA1013345_P_NODE_16650_length_179_cov_1.196970_g16520_i0 PRJNA1013345 16650 179 1.19697 2.1425763 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 40.4 0.022   NR HYT75481.1 2910147 g16520 i0 46.9 0.536312849162011 32 17 53.6 0 116 21 9 40 HYT75481.1 hypothetical protein [Vicinamibacterales bacterium] diamond 96 40.4 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
30343593 30343593 PRJNA1013345_P_NODE_27372_length_161_cov_1.333333_g27242_i0 PRJNA1013345 27372 161 1.333333 2.14666613 Bacteria 2 Bacteria Bacteria 95.9 2.32e-21   NR MCC7308335.1 1978231 g27242 i0 94.1 8.53416149068323 51 3 95 0 3 155 560 610 MCC7308335.1 AMP-binding protein [Acidobacteriota bacterium] diamond 1374 96.7 0.991726990692865 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30508805 30508805 PRJNA1013345_P_NODE_13573_length_186_cov_1.115108_g13443_i0 PRJNA1013345 13573 186 1.115108 2.07410088 Acidobacteriota bacterium 1978231 Bacteria Bacteria 118 1.02e-31   NR MDQ3420917.1 1978231 g13443 i0 94.9 1.90322580645161 59 3 95.2 0 178 2 98 156 MDQ3420917.1 helix-hairpin-helix domain-containing protein [Acidobacteriota bacterium] diamond 354 118 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30690536 30690536 PRJNA1013345_P_NODE_28333_length_160_cov_1.787611_g28203_i0 PRJNA1013345 28333 160 1.787611 2.8601776 Bacteria 2 Bacteria Bacteria 76.6 2.29e-15   NR PYR41134.1 1978231 g28203 i0 63.3 4.6125 49 18 91.9 0 160 14 159 207 PYR41134.1 MAG: hypothetical protein DMF93_09260 [Acidobacteriota bacterium] diamond 738 76.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30722087 30722087 PRJNA1013345_P_NODE_24654_length_164_cov_0.871795_g24524_i0 PRJNA1013345 24654 164 0.871795 1.4297438 Bacteria 2 Bacteria Bacteria 97.1 9.24e-22   NR MDQ3063370.1 1978231 g24524 i0 95.3 1.57317073170732 43 2 78.7 0 2 130 553 595 MDQ3063370.1 FAD-dependent oxidoreductase [Acidobacteriota bacterium] diamond 258 97.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31077664 31077664 PRJNA1013345_P_NODE_13835_length_185_cov_1.630435_g13705_i0 PRJNA1013345 13835 185 1.630435 3.01630475 Terriglobia bacterium 2081523 Bacteria Bacteria 81.3 4.51e-16   NR HMF02682.1 2081523 g13705 i0 56.3 2.59459459459459 80 16 98.9 1 2 184 138 217 HMF02682.1 HAD-IIB family hydrolase [Terriglobia bacterium] diamond 480 81.3 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
31607322 31607322 PRJNA1013345_P_NODE_13556_length_186_cov_1.165468_g13426_i0 PRJNA1013345 13556 186 1.165468 2.16777048 Bacteria 2 Bacteria Bacteria 86.7 3.73e-20   NR OLC50519.1 1803459 g13426 i0 62.9 5.88709677419355 62 22 98.4 1 184 2 7 68 OLC50519.1 MAG: hypothetical protein AUH43_04775 [Acidobacteria bacterium 13_1_40CM_65_14] diamond 1095 87.4 0.991990846681922 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium 13_1_40CM_65_14
31836302 31836302 PRJNA1013345_P_NODE_20017_length_171_cov_2.169355_g19887_i0 PRJNA1013345 20017 171 2.169355 3.70959705 Thermoanaerobaculales bacterium 2873827 Bacteria Bacteria 50.8 2.18e-6   NR MFI5167418.1 2873827 g19887 i0 55.1 0.859649122807018 49 22 86 0 169 23 29 77 MFI5167418.1 transcriptional coactivator p15/PC4 family protein [Thermoanaerobaculales bacterium] diamond 147 50.8 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia Thermoanaerobaculales     Thermoanaerobaculales bacterium
32311415 32311415 PRJNA1013345_P_NODE_19179_length_173_cov_1.619048_g19049_i0 PRJNA1013345 19179 173 1.619048 2.80095304 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 99 2.25e-22   NR MEQ1607283.1 2283092 g19049 i0 80.7 2.96531791907514 57 11 98.8 0 2 172 134 190 MEQ1607283.1 endonuclease/exonuclease/phosphatase family protein [Pyrinomonadaceae bacterium] diamond 513 99 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32406110 32406110 PRJNA1013345_P_NODE_30839_length_158_cov_0.918919_g30709_i0 PRJNA1013345 30839 158 0.918919 1.45189202 Acidobacteriota bacterium 1978231 Bacteria Bacteria 108 7.25e-26   NR MBS1806455.1 1978231 g30709 i0 98.1 4.91772151898734 52 1 98.7 0 158 3 251 302 MBS1806455.1 M2 family metallopeptidase [Acidobacteriota bacterium] diamond 777 108 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32501172 32501172 PRJNA1013345_P_NODE_16979_length_178_cov_1.557252_g16849_i0 PRJNA1013345 16979 178 1.557252 2.77190856 Acidobacteriota bacterium 1978231 Bacteria Bacteria 115 2.75e-28   NR MDA1314826.1 1978231 g16849 i0 93.2 0.99438202247191 59 4 99.4 0 1 177 281 339 MDA1314826.1 DPP IV N-terminal domain-containing protein [Acidobacteriota bacterium] diamond 177 115 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32564497 32564497 PRJNA1013345_P_NODE_21099_length_169_cov_1.672131_g20969_i0 PRJNA1013345 21099 169 1.672131 2.82590139 Acidobacteriota bacterium 1978231 Bacteria Bacteria 66.2 6.24e-11   NR MBS1872006.1 1978231 g20969 i0 100 4.22485207100592 34 0 60.4 0 104 3 1 34 MBS1872006.1 DNA polymerase III subunit beta [Acidobacteriota bacterium] diamond 714 66.2 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);;