contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA849646" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5941465 | 5941465 | PRJNA849646_P_NODE_29085_length_251_cov_1.730337_g28967_i0 | PRJNA849646 | 29085 | 251 | 1.730337 | 4.34314587 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 231 | 2.7199999999999997e-56 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g28967 | i0 | 84.783 | 1.58964143426295 | 230 | 35 | 92 | 0 | 17 | 246 | 588703 | 588932 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 399 | 231 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 12317431 | 12317431 | PRJNA849646_P_NODE_31930_length_248_cov_1.748571_g31812_i0 | PRJNA849646 | 31930 | 248 | 1.748571 | 4.33645608 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 231 | 2.68e-56 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g31812 | i0 | 84.783 | 1.74596774193548 | 230 | 35 | 93 | 0 | 18 | 247 | 4809735 | 4809964 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 433 | 231 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 13592085 | 13592085 | PRJNA849646_P_NODE_42571_length_219_cov_4.520548_g42453_i0 | PRJNA849646 | 42571 | 219 | 4.520548 | 9.90000012 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 351 | 1.7099999999999995e-92 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g42453 | i0 | 95.853 | 182.493150684931 | 217 | 9 | 99 | 0 | 1 | 217 | 4358265 | 4358481 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 39966 | 351 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 16141159 | 16141159 | PRJNA849646_P_NODE_4733_length_310_cov_3.451477_g4615_i0 | PRJNA849646 | 4733 | 310 | 3.451477 | 10.6995787 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 62.1 | 4.81e-5 | NTclustered | gi|2874253700|emb|OY969426.1| | 2651171 | g4615 | i0 | 88.679 | 1.40967741935484 | 53 | 2 | 16 | 4 | 206 | 256 | 284757 | 284807 | MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1 | blastn | 437 | 62.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 18689363 | 18689363 | PRJNA849646_P_NODE_14315_length_279_cov_2.048544_g14197_i0 | PRJNA849646 | 14315 | 279 | 2.048544 | 5.71543776 | Chloracidobacterium validum | 2821543 | Bacteria | Bacteria | 250 | 8.49e-62 | NTclustered | gi|2033661925|gb|CP072649.1| | 2821543 | g14197 | i0 | 83.395 | 11.8243727598566 | 271 | 43 | 97 | 2 | 1 | 270 | 662450 | 662181 | Chloracidobacterium validum strain BV2-C chromosome 2, complete sequence | blastn | 3299 | 250 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium validum | ||
| 23790285 | 23790285 | PRJNA849646_P_NODE_10159_length_287_cov_2.640187_g10041_i0 | PRJNA849646 | 10159 | 287 | 2.640187 | 7.57733669 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2814788339|emb|OY761475.2| | 2910147 | g10041 | i0 | 94.118 | 0.355400696864112 | 34 | 2 | 12 | 0 | 204 | 237 | 4674293 | 4674260 | MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1 | blastn | 102 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales 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);;