RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJEB58983 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
124888 124888 PRJEB58983_P_NODE_24941_length_265_cov_2.255208_g24526_i0 PRJEB58983 24941 265 2.255208 5.9763012 Terriglobales bacterium 2282142 Bacteria Bacteria 60.5 1.29e-9   NR HEU5401884.1 2282142 g24526 i0 43.9 1.53962264150943 66 36 73.6 1 15 209 26 91 HEU5401884.1 hypothetical protein [Terriglobales bacterium] diamond 408 60.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
11603199 11603199 PRJEB58983_P_NODE_17870_length_305_cov_1.008621_g17455_i0 PRJEB58983 17870 305 1.008621 3.07629405 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 152 2.52e-41   NR MDR3736461.1 2052142 g17455 i0 72.3 1.98688524590164 101 28 99.3 0 305 3 53 153 MDR3736461.1 chaperonin GroEL [Acidobacteriaceae bacterium] diamond 606 152 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
27096787 27096787 PRJEB58983_P_NODE_8322_length_430_cov_1.994398_g7908_i0 PRJEB58983 8322 430 1.994398 8.5759114 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 49.7 3.88e-5   NR HRH44833.1 2283092 g7908 i0 50 0.362790697674419 52 24 36.3 1 239 84 2 51 HRH44833.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 156 49.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27381432 27381432 PRJEB58983_P_NODE_24583_length_267_cov_1.551546_g24168_i0 PRJEB58983 24583 267 1.551546 4.14262782 Candidatus Polarisedimenticolaceae bacterium 2910585 Bacteria Bacteria 60.8 1.56e-9   NR HEX5042541.1 2910585 g24168 i0 68.4 2.56179775280899 38 12 42.7 0 114 1 1 38 HEX5042541.1 RNA-binding protein [Candidatus Polarisedimenticolaceae bacterium] diamond 684 60.8 1 Bacteria   Pseudomonadati Acidobacteriota Candidatus Polarisedimenticolia Candidatus Polarisedimenticolales Candidatus Polarisedimenticolaceae   Candidatus Polarisedimenticolaceae bacterium
27381448 27381448 PRJEB58983_P_NODE_483_length_1816_cov_5.846816_g344_i0 PRJEB58983 483 1816 5.846816 106.17817856 Acidobacteriota bacterium 1978231 Bacteria Bacteria 185 4.53e-50   NR MDE3186535.1 1978231 g344 i0 61.5 0.650881057268722 143 55 23.6 0 429 1 1 143 MDE3186535.1 hypothetical protein [Acidobacteriota bacterium] diamond 1182 185 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27658872 27658872 PRJEB58983_P_NODE_29904_length_248_cov_0.891429_g29489_i0 PRJEB58983 29904 248 0.891429 2.21074392 Terriglobia 204432 Bacteria Bacteria 87 1.03e-17   NR MDR3738109.1 1964191 g29489 i0 58.3 3.65322580645161 72 30 87.1 0 247 32 238 309 MDR3738109.1 hypothetical protein [Terracidiphilus sp.] diamond 906 87.8 0.990888382687927 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
28928379 28928379 PRJEB58983_P_NODE_11828_length_366_cov_2.566553_g11413_i0 PRJEB58983 11828 366 2.566553 9.39358398 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 143 1.01e-36   NR HEX8029263.1 2910147 g11413 i0 62.2 0.975409836065574 119 44 97.5 1 3 359 3961 4078 HEX8029263.1 LysM peptidoglycan-binding domain-containing protein [Vicinamibacterales bacterium] diamond 357 143 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
29023511 29023511 PRJEB58983_P_NODE_27988_length_253_cov_0.866667_g27573_i0 PRJEB58983 27988 253 0.866667 2.19266751 Acidobacteriota bacterium 1978231 Bacteria Bacteria 114 2.7e-27   NR MCI0388107.1 1978231 g27573 i0 65.1 1.96837944664032 83 29 98.4 0 251 3 516 598 MCI0388107.1 TonB-dependent receptor [Acidobacteriota bacterium] diamond 498 114 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29079595 29079595 PRJEB58983_P_NODE_27788_length_253_cov_1.727778_g27373_i0 PRJEB58983 27788 253 1.727778 4.37127834 Pseudomonadati 3379134 Bacteria Bacteria 42 0.0302   NR MBW4039449.1 1978231 g27373 i0 46.8 2.37154150197628 47 25 55.7 0 187 47 19 65 MBW4039449.1 hypothetical protein [Acidobacteriota bacterium] diamond 600 42.4 0.990566037735849 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29118078 29118078 PRJEB58983_P_NODE_25909_length_261_cov_1.260638_g25494_i0 PRJEB58983 25909 261 1.260638 3.29026518 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 116 1.4e-28   NR MEO6589329.1 2283092 g25494 i0 64 0.988505747126437 86 31 98.9 0 260 3 320 405 MEO6589329.1 alpha-amylase family glycosyl hydrolase [Pyrinomonadaceae bacterium] diamond 258 116 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29244194 29244194 PRJEB58983_P_NODE_15149_length_328_cov_1.784314_g14734_i0 PRJEB58983 15149 328 1.784314 5.85254992 Acidobacteriota bacterium 1978231 Bacteria Bacteria 97.1 6.14e-23   NR MBS1868021.1 1978231 g14734 i0 55.3 1.45426829268293 76 34 69.5 0 101 328 16 91 MBS1868021.1 hypothetical protein [Acidobacteriota bacterium] diamond 477 97.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30065068 30065068 PRJEB58983_P_NODE_17132_length_310_cov_6.033755_g16717_i0 PRJEB58983 17132 310 6.033755 18.7046405 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 80.5 6.92e-17   NR HEY8561019.1 2283092 g16717 i0 57.8 0.803225806451613 83 30 78.4 3 245 3 21 100 HEY8561019.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 249 80.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30318528 30318528 PRJEB58983_P_NODE_23692_length_271_cov_1.742424_g23277_i0 PRJEB58983 23692 271 1.742424 4.72196904 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 124 3.8999999999999997e-31   NR MDR3736461.1 2052142 g23277 i0 64.8 4.87084870848708 88 31 97.4 0 269 6 113 200 MDR3736461.1 chaperonin GroEL [Acidobacteriaceae bacterium] diamond 1320 124 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
30318546 30318546 PRJEB58983_P_NODE_3892_length_618_cov_5.728440_g3487_i0 PRJEB58983 3892 618 5.72844 35.4017592 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 155 2.4399999999999998e-42   NR MDR3737318.1 2052142 g3487 i0 43.3 0.985436893203884 203 109 97.6 4 617 15 113 311 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 609 155 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
31898509 31898509 PRJEB58983_P_NODE_21557_length_281_cov_3.355769_g21142_i0 PRJEB58983 21557 281 3.355769 9.42971089 Acidobacteriota bacterium 1978231 Bacteria Bacteria 144 3.66e-40   NR MBI3658199.1 1978231 g21142 i0 74.2 0.99288256227758 93 24 99.3 0 280 2 82 174 MBI3658199.1 glycosyltransferase family 2 protein [Acidobacteriota bacterium] diamond 279 144 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32373271 32373271 PRJEB58983_P_NODE_23879_length_270_cov_2.045685_g23464_i0 PRJEB58983 23879 270 2.045685 5.5233495 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 62 8.83e-9   NR HEX8029248.1 2910147 g23464 i0 50.6 0.988888888888889 89 34 98.9 2 269 3 4434 4512 HEX8029248.1 LysM peptidoglycan-binding domain-containing protein [Vicinamibacterales bacterium] diamond 267 62 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);;