contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA358009" and tax_phylum = "Acidobacteriota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 398335 | 398335 | PRJNA358009_P_NODE_301_length_576_cov_3.341556_g261_i0 | PRJNA358009 | 301 | 576 | 3.341556 | 19.24736256 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 243 | 3.1400000000000008e-59 | NTclustered | gi|1958093598|gb|CP065003.1| | 1978231 | g261 | i0 | 97.857 | 72.9583333333333 | 140 | 3 | 60 | 0 | 437 | 576 | 320160 | 320021 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome | blastn | 42024 | 243 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 2348348 | 2348348 | PRJNA358009_P_NODE_1742_length_338_cov_2.435986_g1680_i0 | PRJNA358009 | 1742 | 338 | 2.435986 | 8.23363268 | Bacteria | 2 | Bacteria | Bacteria | 219 | 2.9699999999999993e-52 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g1680 | i0 | 93.793 | 69.7573964497041 | 145 | 9 | 72 | 0 | 4 | 148 | 4231923 | 4231779 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 23578 | 219 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6775748 | 6775748 | PRJNA358009_P_NODE_10526_length_179_cov_3.476923_g10457_i0 | PRJNA358009 | 10526 | 179 | 3.476923 | 6.22369217 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 257 | 2.99e-64 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g10457 | i0 | 94.083 | 67.1508379888268 | 169 | 10 | 94 | 0 | 8 | 176 | 4651382 | 4651550 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 12020 | 257 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 8051414 | 8051414 | PRJNA358009_P_NODE_12047_length_171_cov_2.442623_g11978_i0 | PRJNA358009 | 12047 | 171 | 2.442623 | 4.17688533 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 158 | 2.9499999999999992e-34 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g11978 | i0 | 85.811 | 37.3157894736842 | 148 | 21 | 87 | 0 | 21 | 168 | 634087 | 633940 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 6381 | 158 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 8051557 | 8051557 | PRJNA358009_P_NODE_3267_length_327_cov_2.766187_g3204_i0 | PRJNA358009 | 3267 | 327 | 2.766187 | 9.04543149 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 76.8 | 1.82e-9 | NTclustered | gi|2874253786|emb|OY969770.1| | 2952895 | g3204 | i0 | 91.071 | 0.171253822629969 | 56 | 5 | 17 | 0 | 228 | 283 | 2643409 | 2643354 | MAG: Candidatus Acidoferrales bacterium isolate MFD09222.bin.1.52 genome assembly, chromosome: 1 | blastn | 56 | 76.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 10001092 | 10001092 | PRJNA358009_P_NODE_10768_length_178_cov_1.581395_g10699_i0 | PRJNA358009 | 10768 | 178 | 1.581395 | 2.8148831 | Candidatus Solibacter | 332162 | Bacteria | Bacteria | 226 | 8.379999999999998e-55 | NTclustered | gi|470468228|ref|NR_076103.1| | 332163 | g10699 | i0 | 90.173 | 47.6516853932584 | 173 | 17 | 97 | 0 | 3 | 175 | 1280 | 1452 | Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence | blastn | 8482 | 226 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter usitatus | ||
| 10601884 | 10601884 | PRJNA358009_P_NODE_10349_length_180_cov_4.305344_g10280_i0 | PRJNA358009 | 10349 | 180 | 4.305344 | 7.7496192 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 300 | 4.94e-77 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g10280 | i0 | 98.246 | 175.044444444444 | 171 | 3 | 95 | 0 | 1 | 171 | 299 | 129 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 31508 | 300 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 11877027 | 11877027 | PRJNA358009_P_NODE_9370_length_186_cov_5.452555_g9301_i0 | PRJNA358009 | 9370 | 186 | 5.452555 | 10.1417523 | Edaphobacter flagellatus | 1933044 | Bacteria | Bacteria | 268 | 1.45e-67 | NTclustered | gi|2304905232|gb|CP073697.1| | 1933044 | g9301 | i0 | 97.468 | 60.7795698924731 | 158 | 2 | 85 | 2 | 23 | 180 | 3268011 | 3267856 | Edaphobacter flagellatus strain HZ411 chromosome, complete genome | blastn | 11305 | 268 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter flagellatus | ||
| 13151839 | 13151839 | PRJNA358009_P_NODE_10411_length_180_cov_1.992366_g10342_i0 | PRJNA358009 | 10411 | 180 | 1.992366 | 3.5862588 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 235 | 1.4099999999999998e-57 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g10342 | i0 | 90.503 | 83.9222222222222 | 179 | 16 | 99 | 1 | 1 | 179 | 2366978 | 2367155 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 15106 | 235 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13151846 | 13151846 | PRJNA358009_P_NODE_10871_length_177_cov_3.367188_g10802_i0 | PRJNA358009 | 10871 | 177 | 3.367188 | 5.95992276 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 211 | 2.33e-50 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g10802 | i0 | 88.889 | 89.4802259887006 | 171 | 19 | 97 | 0 | 6 | 176 | 3144394 | 3144564 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 15838 | 211 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 19524134 | 19524134 | PRJNA358009_P_NODE_3796_length_327_cov_2.431655_g3733_i0 | PRJNA358009 | 3796 | 327 | 2.431655 | 7.95151185 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 117 | 1.08e-21 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g3733 | i0 | 90.805 | 7.40061162079511 | 87 | 8 | 27 | 0 | 7 | 93 | 3229430 | 3229516 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 2420 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22074843 | 22074843 | PRJNA358009_P_NODE_2378_length_327_cov_4.176259_g2315_i0 | PRJNA358009 | 2378 | 327 | 4.176259 | 13.65636693 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 200 | 1.0399999999999999e-46 | NTclustered | gi|76574288|gb|DQ139436.1| | 171953 | g2315 | i0 | 95.238 | 5.14984709480122 | 126 | 6 | 69 | 0 | 202 | 327 | 68 | 193 | Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence | blastn | 1684 | 200 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;