RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA642647 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
6996577 6996577 PRJNA642647_P_NODE_6586_length_151_cov_1.070175_g6536_i0 PRJNA642647 6586 151 1.070175 1.61596425 Acidobacteriota bacterium 1978231 Bacteria Bacteria 85.9 5.24e-18   NR MBK8810769.1 1978231 g6536 i0 79.6 1.96688741721854 49 10 97.4 0 4 150 286 334 MBK8810769.1 PBSX family phage terminase large subunit [Acidobacteriota bacterium] diamond 297 85.9 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
8271297 8271297 PRJNA642647_P_NODE_5207_length_166_cov_2.441860_g5157_i0 PRJNA642647 5207 166 2.44186 4.0534876 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 71.6 8.48e-13   NR MEN6533728.1 2212468 g5157 i0 54.2 1.30120481927711 72 14 95.8 1 5 163 181 252 MEN6533728.1 terminase family protein [Bryobacteraceae bacterium] diamond 216 71.6 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
26732707 26732707 PRJNA642647_P_NODE_4281_length_175_cov_1.333333_g4231_i0 PRJNA642647 4281 175 1.333333 2.33333275 Chloracidobacterium sp. 2099375 Bacteria Bacteria 43.1 0.00146   NR MBK7804312.1 2099375 g4231 i0 36.7 0.84 49 31 84 0 171 25 10 58 MBK7804312.1 hypothetical protein [Chloracidobacterium sp.] diamond 147 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Chloracidobacterium Chloracidobacterium sp.
27492124 27492124 PRJNA642647_P_NODE_5283_length_165_cov_2.851562_g5233_i0 PRJNA642647 5283 165 2.851562 4.7050773 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 60.5 1.06e-10   NR HOQ62224.1 2910147 g5233 i0 66.7 0.709090909090909 39 13 70.9 0 35 151 4 42 HOQ62224.1 hypothetical protein [Vicinamibacterales bacterium] diamond 117 60.5 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
27523613 27523613 PRJNA642647_P_NODE_6683_length_150_cov_2.283186_g6633_i0 PRJNA642647 6683 150 2.283186 3.424779 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 73.9 2.59e-15   NR HEY0658743.1 2283092 g6633 i0 63.3 0.98 49 18 98 0 149 3 47 95 HEY0658743.1 hypothetical protein [Pyrinomonadaceae bacterium] diamond 147 73.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27965605 27965605 PRJNA642647_P_NODE_6685_length_150_cov_2.141593_g6635_i0 PRJNA642647 6685 150 2.141593 3.2123895 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 50.1 2.74e-5   NR HUR97952.1 2283092 g6635 i0 54.2 0.96 48 22 96 0 147 4 170 217 HUR97952.1 PD-(D/E)XK nuclease family protein [Pyrinomonadaceae bacterium] diamond 144 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29796839 29796839 PRJNA642647_P_NODE_4471_length_172_cov_0.859259_g4421_i0 PRJNA642647 4471 172 0.859259 1.47792548 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 111 1.13e-30   NR HOK48165.1 2212468 g4421 i0 100 0.959302325581395 55 0 95.9 0 5 169 1 55 HOK48165.1 hypothetical protein [Bryobacteraceae bacterium] diamond 165 111 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
30492065 30492065 PRJNA642647_P_NODE_5033_length_166_cov_2.937984_g4983_i0 PRJNA642647 5033 166 2.937984 4.87705344 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 45.8 0.00105   NR HXO21049.1 2651171 g4983 i0 95.8 1.73493975903614 24 1 43.4 0 3 74 729 752 HXO21049.1 endopeptidase La [Thermoanaerobaculia bacterium] diamond 288 45.8 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
30504358 30504358 PRJNA642647_P_NODE_6493_length_151_cov_3.087719_g6443_i0 PRJNA642647 6493 151 3.087719 4.66245569 Bacteria 2 Bacteria Bacteria 57.4 5.57e-8   NR KXK01571.1 1617423 g6443 i0 96.2 1.54966887417219 26 1 51.7 0 2 79 183 208 KXK01571.1 MAG: DNA protecting protein DprA [Acidobacteria bacterium OLB17] diamond 234 57.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteria bacterium OLB17

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);;