contig_metadata
12 rows where bioproject = "PRJNA835051", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3377133 | 3377133 | PRJNA835051_S_NODE_63923_length_200_cov_1.662420_g63627_i0 | PRJNA835051 | 63923 | 200 | 1.66242 | 3.32484 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2575803349|emb|OY729422.1| | 2026791 | g63627 | i0 | 100 | 0.15 | 30 | 0 | 15 | 0 | 10 | 39 | 3409521 | 3409492 | MAG: Bryobacterales bacterium isolate d47adfd7-a82f-4c56-911c-b237267f53ff genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 5928662 | 5928662 | PRJNA835051_S_NODE_123465_length_154_cov_2.576577_g123169_i0 | PRJNA835051 | 123465 | 154 | 2.576577 | 3.96792858 | uncultured Acidobacteriaceae bacterium | 194844 | Bacteria | Bacteria | 180 | 5.56e-41 | NTclustered | gi|2874253889|emb|OY970064.1| | 194844 | g123169 | i0 | 87.742 | 6.61688311688312 | 155 | 17 | 100 | 2 | 1 | 154 | 1411698 | 1411851 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD06092.bin.c.1 genome assembly, chromosome: 1 | blastn | 1019 | 180 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 8882486 | 8882486 | PRJNA835051_S_NODE_130147_length_151_cov_1.768519_g129851_i0 | PRJNA835051 | 130147 | 151 | 1.768519 | 2.67046369 | Granulicella | 940557 | Bacteria | Bacteria | 279 | 5.19e-71 | NTclustered | gi|2874253750|emb|OY969625.1| | 194844 | g129851 | i0 | 100 | 106.205298013245 | 151 | 0 | 100 | 0 | 1 | 151 | 1802 | 1652 | MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1 | blastn | 16037 | 279 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | uncultured Acidobacteriaceae bacterium | |||
| 26928081 | 26928081 | PRJNA835051_S_NODE_53562_length_212_cov_1.686391_g53266_i0 | PRJNA835051 | 53562 | 212 | 1.686391 | 3.57514892 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 42 | 0.0457 | NR | HEX6715910.1 | 2283092 | g53266 | i0 | 36.9 | 0.919811320754717 | 65 | 29 | 75 | 1 | 9 | 167 | 20 | 84 | HEX6715910.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 195 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27339222 | 27339222 | PRJNA835051_S_NODE_110763_length_162_cov_1.588235_g110467_i0 | PRJNA835051 | 110763 | 162 | 1.588235 | 2.5729407 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 42.7 | 0.00935 | NR | HVG25966.1 | 2052142 | g110467 | i0 | 42.3 | 0.962962962962963 | 52 | 20 | 96.3 | 2 | 7 | 162 | 101 | 142 | HVG25966.1 cupin domain-containing protein [Acidobacteriaceae bacterium] | diamond | 156 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 28033926 | 28033926 | PRJNA835051_S_NODE_45825_length_222_cov_3.178771_g45529_i0 | PRJNA835051 | 45825 | 222 | 3.178771 | 7.05687162 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 56.2 | 4.99e-7 | NR | HEY7161227.1 | 1978231 | g45529 | i0 | 50 | 3.5 | 62 | 30 | 82.4 | 1 | 192 | 10 | 265 | 326 | HEY7161227.1 PAS domain S-box protein [Acidobacteriota bacterium] | diamond | 777 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28444396 | 28444396 | PRJNA835051_S_NODE_86886_length_179_cov_1.404412_g86590_i0 | PRJNA835051 | 86886 | 179 | 1.404412 | 2.51389748 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 41.6 | 0.0405 | NR | MBZ5624850.1 | 2081523 | g86590 | i0 | 39.5 | 0.636871508379888 | 38 | 23 | 63.7 | 0 | 125 | 12 | 232 | 269 | MBZ5624850.1 oligogalacturonate lyase family protein [Terriglobia bacterium] | diamond | 114 | 41.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 28475839 | 28475839 | PRJNA835051_S_NODE_109506_length_163_cov_1.191667_g109210_i0 | PRJNA835051 | 109506 | 163 | 1.191667 | 1.94241721 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 41.2 | 0.0394 | NR | HYR75838.1 | 2283092 | g109210 | i0 | 47.4 | 0.699386503067485 | 38 | 20 | 69.9 | 0 | 9 | 122 | 163 | 200 | HYR75838.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 114 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29202144 | 29202144 | PRJNA835051_S_NODE_122149_length_155_cov_1.705357_g121853_i0 | PRJNA835051 | 122149 | 155 | 1.705357 | 2.64330335 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.1 | 0.00535 | NR | HEX6896637.1 | 2212468 | g121853 | i0 | 46.9 | 1.56774193548387 | 49 | 24 | 94.8 | 1 | 155 | 9 | 62 | 108 | HEX6896637.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 243 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30749750 | 30749750 | PRJNA835051_S_NODE_41574_length_229_cov_1.763441_g41278_i0 | PRJNA835051 | 41574 | 229 | 1.763441 | 4.03827989 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 40.8 | 0.0452 | NR | PYX25340.1 | 1978231 | g41278 | i0 | 44.2 | 0.563318777292576 | 43 | 24 | 56.3 | 0 | 20 | 148 | 48 | 90 | PYX25340.1 MAG: hypothetical protein DMG82_05435 [Acidobacteriota bacterium] | diamond | 129 | 40.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31350333 | 31350333 | PRJNA835051_S_NODE_97416_length_171_cov_1.515625_g97120_i0 | PRJNA835051 | 97416 | 171 | 1.515625 | 2.59171875 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 42 | 0.0248 | NR | HWC77487.1 | 2052146 | g97120 | i0 | 36.5 | 0.912280701754386 | 52 | 33 | 91.2 | 0 | 8 | 163 | 67 | 118 | HWC77487.1 DUF1080 domain-containing protein [Blastocatellia bacterium] | diamond | 156 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 31508505 | 31508505 | PRJNA835051_S_NODE_21476_length_272_cov_1.048035_g21180_i0 | PRJNA835051 | 21476 | 272 | 1.048035 | 2.8506552 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 47 | 0.00174 | NR | HVN06836.1 | 2212468 | g21180 | i0 | 33.3 | 0.860294117647059 | 78 | 51 | 86 | 1 | 19 | 252 | 708 | 784 | HVN06836.1 TonB-dependent receptor [Bryobacteraceae bacterium] | diamond | 234 | 47 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;