contig_metadata
7 rows where bioproject = "PRJNA348537", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2944134 | 2944134 | PRJNA348537_S_NODE_1663_length_227_cov_4.656250_g1617_i0 | PRJNA348537 | 1663 | 227 | 4.65625 | 10.5696875 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 291 | 3.94e-74 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g1617 | i0 | 89.868 | 109.555066079295 | 227 | 22 | 100 | 1 | 1 | 227 | 4233028 | 4232803 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 24869 | 291 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 6771116 | 6771116 | PRJNA348537_S_NODE_1606_length_231_cov_1.862245_g1560_i0 | PRJNA348537 | 1606 | 231 | 1.862245 | 4.30178595 | Thermoanaerobaculaceae bacterium | 2699758 | Bacteria | Bacteria | 215 | 2.49e-51 | NTclustered | gi|2874254005|emb|OY970330.1| | 2699758 | g1560 | i0 | 83.761 | 124.658008658009 | 234 | 31 | 100 | 7 | 1 | 231 | 4574331 | 4574560 | MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1 | blastn | 28796 | 215 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculales | Thermoanaerobaculaceae | Thermoanaerobaculaceae bacterium | |||
| 8722977 | 8722977 | PRJNA348537_S_NODE_2047_length_208_cov_2.427746_g2001_i0 | PRJNA348537 | 2047 | 208 | 2.427746 | 5.04971168 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 195 | 2.86e-45 | NTclustered | gi|2836016426|emb|OZ196157.1| | 1241325 | g2001 | i0 | 86.17 | 91.3221153846154 | 188 | 17 | 87 | 6 | 17 | 197 | 1018090 | 1018275 | MAG: uncultured Granulicella sp. isolate 532c3363-cb9a-4ff4-a964-62ae8f4e4543 genome assembly, chromosome: 1 | blastn | 18995 | 195 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | uncultured Granulicella sp. | ||
| 16970854 | 16970854 | PRJNA348537_S_NODE_2994_length_179_cov_2.069444_g2948_i0 | PRJNA348537 | 2994 | 179 | 2.069444 | 3.70430476 | uncultured Holophaga sp. | 188475 | Bacteria | Bacteria | 152 | 1.45e-32 | NTclustered | gi|2621704223|emb|OY761614.1| | 188475 | g2948 | i0 | 87.407 | 31.6927374301676 | 135 | 13 | 74 | 4 | 38 | 170 | 646325 | 646457 | MAG: uncultured Holophaga sp. isolate c3c763bb-72ba-4188-aae9-c4b83244ba6d genome assembly, chromosome: 1 | blastn | 5673 | 152 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophaga | uncultured Holophaga sp. | ||
| 16970858 | 16970858 | PRJNA348537_S_NODE_3514_length_167_cov_4.265152_g3468_i0 | PRJNA348537 | 3514 | 167 | 4.265152 | 7.12280384 | Holophaga foetida | 35839 | Bacteria | Bacteria | 252 | 1.29e-62 | NTclustered | gi|84452197|emb|AM180895.1| | 903818 | g3468 | i0 | 94.012 | 34.7425149700599 | 167 | 9 | 100 | 1 | 1 | 167 | 1198 | 1363 | Holophaga foetida partial 23S rRNA gene, strain DSM 6591 | blastn | 5802 | 252 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophaga | Holophaga foetida | ||
| 17648065 | 17648065 | PRJNA348537_S_NODE_4514_length_152_cov_4.264957_g4468_i0 | PRJNA348537 | 4514 | 152 | 4.264957 | 6.48273464 | Bacteria | 2 | Bacteria | Bacteria | 231 | 1.49e-56 | NTclustered | gi|1015624362|gb|AH012920.2| | 171953 | g4468 | i0 | 94.156 | 98.4013157894737 | 154 | 5 | 100 | 4 | 1 | 152 | 29622 | 29471 | Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds | blastn | 14957 | 231 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22747357 | 22747357 | PRJNA348537_S_NODE_3278_length_172_cov_4.817518_g3232_i0 | PRJNA348537 | 3278 | 172 | 4.817518 | 8.28613096 | Bacteria | 2 | Bacteria | Bacteria | 207 | 2.91e-49 | NTclustered | gi|2874253677|emb|OY969111.1| | 171953 | g3232 | i0 | 88.439 | 118.738372093023 | 173 | 18 | 100 | 2 | 1 | 172 | 713305 | 713476 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1 | blastn | 20423 | 207 | 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);;