contig_metadata
11 rows where bioproject = "PRJNA255848", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1056840 | 1056840 | PRJNA255848_P_NODE_12881_length_282_cov_1.626609_g12563_i0 | PRJNA255848 | 12881 | 282 | 1.626609 | 4.58703738 | Terriglobus | 392733 | Bacteria | Bacteria | 457 | 4.72e-124 | NTclustered | gi|1085637902|emb|LT629690.1| | 392734 | g12563 | i0 | 97.048 | 98.2340425531915 | 271 | 8 | 96 | 0 | 12 | 282 | 4807907 | 4807637 | Terriglobus roseus strain GAS232 genome assembly, chromosome: I | blastn | 27702 | 457 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus roseus | ||
| 5472113 | 5472113 | PRJNA255848_P_NODE_44745_length_162_cov_1.053097_g44427_i0 | PRJNA255848 | 44745 | 162 | 1.053097 | 1.70601714 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 248 | 1.6e-61 | NTclustered | gi|2874253796|emb|OY969780.1| | 194844 | g44427 | i0 | 94.41 | 31.8518518518519 | 161 | 9 | 99 | 0 | 1 | 161 | 285177 | 285017 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1 | blastn | 5160 | 248 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 9296787 | 9296787 | PRJNA255848_P_NODE_45588_length_162_cov_0.902655_g45270_i0 | PRJNA255848 | 45588 | 162 | 0.902655 | 1.4623011 | Pyrinomonas methylaliphatogenes | 454194 | Bacteria | Bacteria | 88.2 | 1.23e-18 | NR | WP_041975381.1 | 454194 | g45270 | i0 | 95 | 0.740740740740741 | 40 | 2 | 74.1 | 0 | 1 | 120 | 2458 | 2497 | WP_041975381.1 PKD domain-containing protein [Pyrinomonas methylaliphatogenes] | diamond | 120 | 88.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonas | Pyrinomonas methylaliphatogenes | ||
| 16359298 | 16359298 | PRJNA255848_P_NODE_16533_length_245_cov_2.051020_g16215_i0 | PRJNA255848 | 16533 | 245 | 2.05102 | 5.024999 | Terriglobus | 392733 | Bacteria | Bacteria | 436 | 5.229999999999999e-118 | NTclustered | gi|319923767|gb|CP002467.1| | 401053 | g16215 | i0 | 98.776 | 120.534693877551 | 245 | 3 | 100 | 0 | 1 | 245 | 3869452 | 3869696 | Terriglobus saanensis SP1PR4, complete genome | blastn | 29531 | 436 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus saanensis | ||
| 27344840 | 27344840 | PRJNA255848_P_NODE_42103_length_164_cov_0.886957_g41785_i0 | PRJNA255848 | 42103 | 164 | 0.886957 | 1.45460948 | Bacteria | 2 | Bacteria | Bacteria | 75.9 | 2.65e-14 | NR | MDQ6785454.1 | 1978231 | g41785 | i0 | 72.3 | 4.33536585365854 | 47 | 13 | 86 | 0 | 142 | 2 | 136 | 182 | MDQ6785454.1 DUF4450 domain-containing protein [Acidobacteriota bacterium] | diamond | 711 | 76.6 | 0.990861618798956 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27484834 | 27484834 | PRJNA255848_P_NODE_43863_length_163_cov_0.894737_g43545_i0 | PRJNA255848 | 43863 | 163 | 0.894737 | 1.45842131 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 42.4 | 0.0173 | NR | HSK70695.1 | 2283092 | g43545 | i0 | 46.3 | 0.993865030674847 | 54 | 18 | 79.1 | 2 | 144 | 16 | 247 | 300 | HSK70695.1 4-(cytidine 5'-diphospho)-2-C-methyl-D-erythritol kinase [Pyrinomonadaceae bacterium] | diamond | 162 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28053057 | 28053057 | PRJNA255848_P_NODE_46025_length_162_cov_0.902655_g45707_i0 | PRJNA255848 | 46025 | 162 | 0.902655 | 1.4623011 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 90.5 | 1.81e-19 | NR | HVJ26377.1 | 2910147 | g45707 | i0 | 90.6 | 0.981481481481482 | 53 | 5 | 98.1 | 0 | 160 | 2 | 191 | 243 | HVJ26377.1 ABC transporter permease [Vicinamibacterales bacterium] | diamond | 159 | 90.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 28134171 | 28134171 | PRJNA255848_P_NODE_42365_length_164_cov_0.886957_g42047_i0 | PRJNA255848 | 42365 | 164 | 0.886957 | 1.45460948 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 46.2 | 7.6e-4 | NR | MEP6782237.1 | 1978231 | g42047 | i0 | 100 | 1.09756097560976 | 20 | 0 | 36.6 | 0 | 1 | 60 | 453 | 472 | MEP6782237.1 amidohydrolase family protein [Acidobacteriota bacterium] | diamond | 180 | 46.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28260144 | 28260144 | PRJNA255848_P_NODE_29546_length_183_cov_1.141791_g29228_i0 | PRJNA255848 | 29546 | 183 | 1.141791 | 2.08947753 | Bryobacterales | 332160 | Bacteria | Bacteria | 41.6 | 0.0429 | NR | MEO8592242.1 | 2068625 | g29228 | i0 | 42.1 | 1.26229508196721 | 38 | 22 | 62.3 | 0 | 166 | 53 | 638 | 675 | MEO8592242.1 hypothetical protein [Candidatus Solibacter sp.] | diamond | 231 | 42 | 0.990476190476191 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Solibacter | Candidatus Solibacter sp. | ||
| 30218074 | 30218074 | PRJNA255848_P_NODE_36172_length_167_cov_0.864407_g35854_i0 | PRJNA255848 | 36172 | 167 | 0.864407 | 1.44355969 | Bacteria | 2 | Bacteria | Bacteria | 97.1 | 9.13e-22 | NR | OJV44669.1 | 1895690 | g35854 | i0 | 81.8 | 1.97604790419162 | 55 | 10 | 98.8 | 0 | 2 | 166 | 354 | 408 | OJV44669.1 MAG: hypothetical protein BGO25_04685 [Acidobacteriales bacterium 59-55] | diamond | 330 | 97.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriales bacterium 59-55 | ||||
| 31843925 | 31843925 | PRJNA255848_P_NODE_41557_length_164_cov_0.886957_g41239_i0 | PRJNA255848 | 41557 | 164 | 0.886957 | 1.45460948 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 106 | 1.14e-25 | NR | HET9704812.1 | 2910147 | g41239 | i0 | 92.6 | 1.97560975609756 | 54 | 4 | 98.8 | 0 | 3 | 164 | 129 | 182 | HET9704812.1 amidohydrolase family protein [Vicinamibacterales bacterium] | diamond | 324 | 106 | 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);;