RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA384462", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 12 ✖

tax_phylum 1

  • Acidobacteriota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA384462 · 12 ✖

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
27233235 27233235 PRJNA384462_S_NODE_4423_length_253_cov_0.808824_g4307_i0 PRJNA384462 4423 253 0.808824 2.04632472 Acidobacteriota bacterium 1978231 Bacteria Bacteria 60.8 1.66e-8   NR RPJ64679.1 1978231 g4307 i0 51.9 0.616600790513834 52 25 61.7 0 242 87 390 441 RPJ64679.1 MAG: hypothetical protein EHM23_00020 [Acidobacteriota bacterium] diamond 156 60.8 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27391416 27391416 PRJNA384462_S_NODE_3383_length_284_cov_2.370213_g3267_i0 PRJNA384462 3383 284 2.370213 6.73140492 Terriglobales bacterium 2282142 Bacteria Bacteria 64.7 1.14e-9   NR HMH02381.1 2282142 g3267 i0 73 1.21478873239437 37 10 39.1 0 45 155 384 420 HMH02381.1 thrombospondin type 3 repeat-containing protein [Terriglobales bacterium] diamond 345 64.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
27408375 27408375 PRJNA384462_S_NODE_1983_length_370_cov_1.669782_g1867_i0 PRJNA384462 1983 370 1.669782 6.1781934 root 1 Root_unresolved Root_unresolved 106 9.069999999999999e-24   NR HUL15627.1 2282142 g1867 i0 46.8 6.01621621621622 124 46 99.7 4 369 1 891 995 HUL15627.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Terriglobales bacterium] diamond 2226 107 0.990654205607477 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
27959529 27959529 PRJNA384462_S_NODE_16045_length_154_cov_4.247619_g15929_i0 PRJNA384462 16045 154 4.247619 6.54133326 Acidobacteriota bacterium 1978231 Bacteria Bacteria 42.7 0.0113   NR MCZ6779069.1 1978231 g15929 i0 51.4 0.720779220779221 37 18 72.1 0 126 16 96 132 MCZ6779069.1 ATP-dependent zinc metalloprotease FtsH [Acidobacteriota bacterium] diamond 111 42.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28686011 28686011 PRJNA384462_S_NODE_14507_length_163_cov_0.894737_g14391_i0 PRJNA384462 14507 163 0.894737 1.45842131 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 45.1 6.78e-4   NR HVF86393.1 2283092 g14391 i0 52 1.80368098159509 50 24 92 0 161 12 76 125 HVF86393.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] diamond 294 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
30137996 30137996 PRJNA384462_S_NODE_14852_length_162_cov_1.309735_g14736_i0 PRJNA384462 14852 162 1.309735 2.1217707 Blastocatellia bacterium 2052146 Bacteria Bacteria 57 1.11e-7   NR HYE75320.1 2052146 g14736 i0 61.1 0.666666666666667 36 14 66.7 0 2 109 355 390 HYE75320.1 nicotinate phosphoribosyltransferase [Blastocatellia bacterium] diamond 108 57 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
30770418 30770418 PRJNA384462_S_NODE_14794_length_162_cov_1.353982_g14678_i0 PRJNA384462 14794 162 1.353982 2.19345084 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 70.5 1.59e-12   NR HLF55384.1 2651171 g14678 i0 67.3 0.962962962962963 52 15 96.3 1 3 158 283 332 HLF55384.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 156 70.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31054935 31054935 PRJNA384462_S_NODE_3315_length_287_cov_0.848739_g3199_i0 PRJNA384462 3315 287 0.848739 2.43588093 Acidobacteriota bacterium 1978231 Bacteria Bacteria 60.5 3.45e-8   NR MEM8930914.1 1978231 g3199 i0 36.3 3.9198606271777 91 53 95.1 3 13 285 100 185 MEM8930914.1 alpha/beta hydrolase [Acidobacteriota bacterium] diamond 1125 60.5 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31750163 31750163 PRJNA384462_S_NODE_15377_length_161_cov_0.910714_g15261_i0 PRJNA384462 15377 161 0.910714 1.46624954 Acidobacteriota bacterium 1978231 Bacteria Bacteria 81.6 1.8e-16   NR MBI4752233.1 1978231 g15261 i0 66 1.97515527950311 53 18 98.8 0 160 2 313 365 MBI4752233.1 argininosuccinate synthase [Acidobacteriota bacterium] diamond 318 81.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31798639 31798639 PRJNA384462_S_NODE_6277_length_219_cov_1.200000_g6161_i0 PRJNA384462 6277 219 1.2 2.628 Terriglobia 204432 Bacteria Bacteria 48.9 6.73e-5   NR HUB52817.1 1964191 g6161 i0 46.5 2.86301369863014 71 29 97.3 3 219 7 73 134 HUB52817.1 CBS domain-containing protein [Terracidiphilus sp.] diamond 627 48.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
32066590 32066590 PRJNA384462_S_NODE_7018_length_210_cov_1.583851_g6902_i0 PRJNA384462 7018 210 1.583851 3.3260871 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 68.9 1.44e-11   NR HEX9732696.1 2651171 g6902 i0 51.7 7.12857142857143 60 27 82.9 1 204 31 242 301 HEX9732696.1 choice-of-anchor B family protein [Thermoanaerobaculia bacterium] diamond 1497 68.9 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
32305383 32305383 PRJNA384462_S_NODE_6939_length_211_cov_1.259259_g6823_i0 PRJNA384462 6939 211 1.259259 2.65703649 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 46.6 0.0011   NR MBS1797786.1 1978231 g6823 i0 37.9 1.67772511848341 58 36 82.5 0 204 31 805 862 MBS1797786.1 tetratricopeptide repeat protein [Acidobacteriota bacterium] diamond 354 46.6 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);;