RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA274362" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA274362 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27136837 27136837 PRJNA274362_S_NODE_36762_length_163_cov_0.912281_g36642_i0 PRJNA274362 36762 163 0.912281 1.48701803 Candidatus Angelobacter sp. 2976921 Bacteria Bacteria 91.7 6.37e-20   NR HEY2495666.1 2976921 g36642 i0 80.8 0.957055214723926 52 10 95.7 0 3 158 271 322 HEY2495666.1 glycerol kinase GlpK [Candidatus Angelobacter sp.] diamond 156 91.7 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
27547953 27547953 PRJNA274362_S_NODE_17984_length_215_cov_1.500000_g17864_i0 PRJNA274362 17984 215 1.5 3.225 Candidatus Korobacter sp. 2510641 Bacteria Bacteria 43.5 0.014   NR HEY3926946.1 2510641 g17864 i0 35.6 1.01860465116279 73 43 96.3 1 214 8 326 398 HEY3926946.1 SLBB domain-containing protein [Candidatus Korobacter sp.] diamond 219 43.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Korobacter Candidatus Korobacter sp.
28148058 28148058 PRJNA274362_S_NODE_30785_length_172_cov_0.813008_g30665_i0 PRJNA274362 30785 172 0.813008 1.39837376 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 39.7 0.0313   NR HJW95184.1 2651171 g30665 i0 54.3 0.61046511627907 35 16 61 0 3 107 2 36 HJW95184.1 2-oxoisovalerate dehydrogenase [Thermoanaerobaculia bacterium] diamond 105 39.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
28905448 28905448 PRJNA274362_S_NODE_28268_length_178_cov_1.573643_g28148_i0 PRJNA274362 28268 178 1.573643 2.80108454 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.4 4.52e-4   NR MDQ7008653.1 1978231 g28148 i0 65.9 0.691011235955056 41 14 69.1 0 55 177 8 48 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 123 45.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31545671 31545671 PRJNA274362_S_NODE_25976_length_185_cov_1.411765_g25856_i0 PRJNA274362 25976 185 1.411765 2.61176525 Pseudomonadati 3379134 Bacteria Bacteria 115 1.98e-29   NR HEX8472789.1 2283092 g25856 i0 91.8 10.7837837837838 61 5 98.9 0 183 1 39 99 HEX8472789.1 glycoside hydrolase family 19 protein [Pyrinomonadaceae bacterium] diamond 1995 116 0.991379310344828 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
32413727 32413727 PRJNA274362_S_NODE_27479_length_180_cov_2.198473_g27359_i0 PRJNA274362 27479 180 2.198473 3.9572514 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 67.4 3.1e-11   NR MDR3736699.1 2052142 g27359 i0 52.5 0.983333333333333 59 28 98.3 0 179 3 337 395 MDR3736699.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 177 67.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
32697621 32697621 PRJNA274362_S_NODE_36060_length_164_cov_0.895652_g35940_i0 PRJNA274362 36060 164 0.895652 1.46886928 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 47.4 2.99e-4   NR HKR11015.1 2283092 g35940 i0 60.6 0.603658536585366 33 13 60.4 0 36 134 138 170 HKR11015.1 hemopexin repeat-containing protein [Pyrinomonadaceae bacterium] diamond 99 47.4 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;