RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
27295603 27295603 PRJNA315314_S_NODE_29503_length_156_cov_1.944882_g29182_i0 PRJNA315314 29503 156 1.944882 3.03401592 Bryobacterales bacterium 2026791 Bacteria Bacteria 41.6 0.02   NR MBL8235757.1 2026791 g29182 i0 52.2 0.884615384615385 46 22 88.5 0 16 153 91 136 MBL8235757.1 hypothetical protein [Bryobacterales bacterium] diamond 138 41.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales bacterium
27674806 27674806 PRJNA315314_S_NODE_2484_length_502_cov_20.883721_g824_i2 PRJNA315314 2484 502 20.883721 104.83627942 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 66.2 3.68e-9   NR HSS49596.1 2651171 g824 i2 50 0.394422310756972 66 30 37.6 2 499 311 292 357 HSS49596.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 198 66.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28400791 28400791 PRJNA315314_S_NODE_23746_length_171_cov_4.352113_g23425_i0 PRJNA315314 23746 171 4.352113 7.44211323 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 41.6 0.0209   NR HEX9670850.1 2651171 g23425 i0 54.1 0.649122807017544 37 16 64.9 1 59 169 1 36 HEX9670850.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 111 41.6 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28685149 28685149 PRJNA315314_S_NODE_307_length_1327_cov_9.184129_g217_i0 PRJNA315314 307 1327 9.184129 121.87339183 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 72 1.29e-9   NR HET8888826.1 2976921 g217 i0 36.3 0.354935945742276 157 95 35 4 819 1283 218 371 HET8888826.1 ETX/MTX2 family pore-forming toxin [Candidatus Angelobacter sp.] diamond 471 72 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
30028797 30028797 PRJNA315314_S_NODE_16491_length_202_cov_2.901734_g16170_i0 PRJNA315314 16491 202 2.901734 5.86150268 Pseudomonadati 3379134 Bacteria Bacteria 75.1 8.28e-14   NR MBN2321290.1 1978231 g16170 i0 57.8 6.60891089108911 64 27 95 0 195 4 95 158 MBN2321290.1 signal peptide peptidase SppA [Acidobacteriota bacterium] diamond 1335 75.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30345149 30345149 PRJNA315314_S_NODE_15692_length_207_cov_1.820225_g15371_i0 PRJNA315314 15692 207 1.820225 3.76786575 Pseudomonadati 3379134 Bacteria Bacteria 46.6 0.00102   NR HEV2136394.1 1964191 g15371 i0 46.3 1.53623188405797 54 29 78.3 0 3 164 1521 1574 HEV2136394.1 choice-of-anchor D domain-containing protein [Terracidiphilus sp.] diamond 318 46.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
30642900 30642900 PRJNA315314_S_NODE_14593_length_214_cov_2.275676_g14272_i0 PRJNA315314 14593 214 2.275676 4.86994664 Terracidiphilus sp. 1964191 Bacteria Bacteria 42.7 0.0246   NR HMG85787.1 1964191 g14272 i0 34.4 1.79439252336449 64 40 86.9 1 209 24 284 347 HMG85787.1 cytochrome c3 family protein [Terracidiphilus sp.] diamond 384 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
31274998 31274998 PRJNA315314_S_NODE_24495_length_169_cov_2.078571_g24174_i0 PRJNA315314 24495 169 2.078571 3.51278499 Acidobacteriota bacterium 1978231 Bacteria Bacteria 78.6 8.81e-16   NR MBI3661592.1 1978231 g24174 i0 68.5 3.88757396449704 54 17 95.9 0 1 162 208 261 MBI3661592.1 SDR family NAD(P)-dependent oxidoreductase [Acidobacteriota bacterium] diamond 657 78.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31717872 31717872 PRJNA315314_S_NODE_18997_length_189_cov_4.362500_g18676_i0 PRJNA315314 18997 189 4.3625 8.245125 Candidatus Solibacter usitatus 332163 Bacteria Bacteria 84 2.42e-17   NR MBI5282310.1 332163 g18676 i0 62.3 0.968253968253968 61 23 96.8 0 7 189 231 291 MBI5282310.1 UDP-glucose 4-epimerase GalE [Candidatus Solibacter usitatus] diamond 183 84 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Solibacteraceae Candidatus Solibacter Candidatus Solibacter usitatus
31812730 31812730 PRJNA315314_S_NODE_18837_length_190_cov_2.645963_g18516_i0 PRJNA315314 18837 190 2.645963 5.0273297 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 119 4e-31   NR HTM50384.1 2212468 g18516 i0 84.1 0.994736842105263 63 10 99.5 0 1 189 147 209 HTM50384.1 hypothetical protein [Bryobacteraceae bacterium] diamond 189 119 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
32666465 32666465 PRJNA315314_S_NODE_12760_length_228_cov_2.180905_g12439_i0 PRJNA315314 12760 228 2.180905 4.9724634 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 55.5 9.78e-7   NR HEY4380311.1 2052142 g12439 i0 42.6 1.73684210526316 68 38 89.5 1 226 23 92 158 HEY4380311.1 choice-of-anchor D domain-containing protein [Acidobacteriaceae bacterium] diamond 396 55.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
32760979 32760979 PRJNA315314_S_NODE_2740_length_478_cov_20.873051_g824_i3 PRJNA315314 2740 478 20.873051 99.77318378 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 66.2 2.93e-9   NR HSS49596.1 2651171 g824 i3 50 0.414225941422594 66 30 39.5 2 4 192 292 357 HSS49596.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 198 66.2 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia 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);;