contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193683 | 193683 | PRJNA1086823_P_NODE_13381_length_251_cov_0.876404_g13264_i0 | PRJNA1086823 | 13381 | 251 | 0.876404 | 2.19977404 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 265 | 2.68e-66 | NTclustered | gi|2893358450|emb|OZ220742.1| | 2651171 | g13264 | i0 | 86.179 | 83.3227091633466 | 246 | 32 | 98 | 2 | 1 | 245 | 249943 | 250187 | MAG: Thermoanaerobaculia bacterium isolate 0db66e92-d31a-4200-8262-fff8455c21c0 genome assembly, chromosome: 1 | blastn | 20914 | 265 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 1017342 | 1017342 | PRJNA1086823_P_NODE_8321_length_289_cov_1.592593_g8204_i0 | PRJNA1086823 | 8321 | 289 | 1.592593 | 4.60259377 | Acidobacterium | 33973 | Bacteria | Bacteria | 507 | 4.75e-139 | NTclustered | gi|470484216|ref|NR_076636.1| | 33075 | g8204 | i0 | 98.27 | 102.643598615917 | 289 | 5 | 100 | 0 | 1 | 289 | 976 | 1264 | Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence | blastn | 29664 | 512 | 0.990234375 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacterium | Acidobacterium capsulatum | ||
| 2744489 | 2744489 | PRJNA1086823_P_NODE_18303_length_243_cov_0.917647_g18186_i0 | PRJNA1086823 | 18303 | 243 | 0.917647 | 2.22988221 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 124 | 4.579999999999999e-24 | NTclustered | gi|310755849|gb|HQ213739.1| | 194844 | g18186 | i0 | 98.571 | 30.8559670781893 | 70 | 1 | 29 | 0 | 1 | 70 | 433 | 502 | Uncultured Acidobacteriaceae bacterium clone 4_O02 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 7498 | 124 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 6571568 | 6571568 | PRJNA1086823_P_NODE_13126_length_252_cov_0.871508_g13009_i0 | PRJNA1086823 | 13126 | 252 | 0.871508 | 2.19620016 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 126 | 1.3299999999999999e-24 | NTclustered | gi|2874254167|emb|OY970399.1| | 171953 | g13009 | i0 | 96.154 | 11.0555555555556 | 78 | 2 | 31 | 1 | 1 | 77 | 669246 | 669169 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1 | blastn | 2786 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 10397279 | 10397279 | PRJNA1086823_P_NODE_8729_length_285_cov_1.452830_g8612_i0 | PRJNA1086823 | 8729 | 285 | 1.45283 | 4.1405655 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 488 | 1.6899999999999999e-133 | NTclustered | gi|2874254108|emb|OY970193.1| | 171953 | g8612 | i0 | 97.552 | 316.298245614035 | 286 | 5 | 99 | 2 | 2 | 285 | 1690519 | 1690804 | MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1 | blastn | 90145 | 488 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22694271 | 22694271 | PRJNA1086823_P_NODE_16398_length_246_cov_0.901734_g16281_i0 | PRJNA1086823 | 16398 | 246 | 0.901734 | 2.21826564 | Bacteria | 2 | Bacteria | Bacteria | 193 | 1.25e-44 | NTclustered | gi|2874254049|emb|OY970373.1| | 171953 | g16281 | i0 | 81.048 | 25.8252032520325 | 248 | 41 | 99 | 6 | 1 | 245 | 5979321 | 5979565 | MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 | blastn | 6353 | 193 | 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);;