contig_metadata
11 rows where bioproject = "PRJNA1249042", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5457781 | 5457781 | PRJNA1249042_S_NODE_2905_length_531_cov_5.008197_g2706_i0 | PRJNA1249042 | 2905 | 531 | 5.008197 | 26.59352607 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 575 | 2.499999999999999e-159 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g2706 | i0 | 87.205 | 294.905838041431 | 508 | 61 | 95 | 4 | 26 | 531 | 3298163 | 3298668 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 156595 | 575 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 6732172 | 6732172 | PRJNA1249042_S_NODE_34166_length_233_cov_4.094737_g33952_i0 | PRJNA1249042 | 34166 | 233 | 4.094737 | 9.54073721 | Chloracidobacterium validum | 2821543 | Bacteria | Bacteria | 100 | 7.34e-17 | NTclustered | gi|2033659757|gb|CP072648.1| | 2821543 | g33952 | i0 | 93.939 | 1.27896995708155 | 66 | 4 | 28 | 0 | 168 | 233 | 105590 | 105655 | Chloracidobacterium validum strain BV2-C chromosome 1, complete sequence | blastn | 298 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium validum | ||
| 8007565 | 8007565 | PRJNA1249042_S_NODE_110027_length_154_cov_2.207207_g109813_i0 | PRJNA1249042 | 110027 | 154 | 2.207207 | 3.39909878 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 122 | 9.499999999999999e-24 | NTclustered | gi|217038899|gb|EU810989.1| | 171953 | g109813 | i0 | 98.551 | 55.9545454545455 | 69 | 1 | 45 | 0 | 86 | 154 | 428 | 360 | Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence | blastn | 8617 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 10558406 | 10558406 | PRJNA1249042_S_NODE_18669_length_268_cov_3.035556_g18455_i0 | PRJNA1249042 | 18669 | 268 | 3.035556 | 8.13529008 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 339 | 1.6799999999999998e-88 | NTclustered | gi|2874254027|emb|OY970352.1| | 171953 | g18455 | i0 | 89.811 | 107.55223880597 | 265 | 25 | 99 | 2 | 5 | 268 | 2366969 | 2367232 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 | blastn | 28824 | 339 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 14383346 | 14383346 | PRJNA1249042_S_NODE_11852_length_296_cov_4.747036_g11638_i0 | PRJNA1249042 | 11852 | 296 | 4.747036 | 14.05122656 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 372 | 1.86e-98 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g11638 | i0 | 90.426 | 111.148648648649 | 282 | 27 | 95 | 0 | 1 | 282 | 3298617 | 3298336 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 32900 | 372 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 14383597 | 14383597 | PRJNA1249042_S_NODE_42952_length_219_cov_4.301136_g42738_i0 | PRJNA1249042 | 42952 | 219 | 4.301136 | 9.41948784 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 233 | 6.45e-57 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g42738 | i0 | 86.239 | 131.570776255708 | 218 | 26 | 99 | 4 | 1 | 216 | 293 | 78 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 28814 | 233 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22031145 | 22031145 | PRJNA1249042_S_NODE_32278_length_237_cov_1.814433_g32064_i0 | PRJNA1249042 | 32278 | 237 | 1.814433 | 4.30020621 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 261 | 3.25e-65 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g32064 | i0 | 86.667 | 306.029535864979 | 240 | 27 | 100 | 4 | 1 | 237 | 29 | 266 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 72529 | 261 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 29094855 | 29094855 | PRJNA1249042_S_NODE_69528_length_188_cov_1.620690_g69314_i0 | PRJNA1249042 | 69528 | 188 | 1.62069 | 3.0468972 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 99.4 | 1.12e-25 | NR | MFM9904966.1 | 2283092 | g69314 | i0 | 86.9 | 1.96276595744681 | 61 | 8 | 97.3 | 0 | 1 | 183 | 5 | 65 | MFM9904966.1 50S ribosomal protein L29 [Pyrinomonadaceae bacterium] | diamond | 369 | 99.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31116052 | 31116052 | PRJNA1249042_S_NODE_115775_length_151_cov_1.305556_g115561_i0 | PRJNA1249042 | 115775 | 151 | 1.305556 | 1.97138956 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 41.2 | 0.0363 | NR | MBZ5624850.1 | 2081523 | g115561 | i0 | 39.5 | 0.754966887417219 | 38 | 23 | 75.5 | 0 | 33 | 146 | 232 | 269 | MBZ5624850.1 oligogalacturonate lyase family protein [Terriglobia bacterium] | diamond | 114 | 41.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 31906944 | 31906944 | PRJNA1249042_S_NODE_14157_length_285_cov_2.396694_g13943_i0 | PRJNA1249042 | 14157 | 285 | 2.396694 | 6.8305779 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 45.1 | 0.00548 | NR | HEV2861574.1 | 2283092 | g13943 | i0 | 41.5 | 0.557894736842105 | 53 | 31 | 55.8 | 0 | 59 | 217 | 84 | 136 | HEV2861574.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 159 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32065097 | 32065097 | PRJNA1249042_S_NODE_110078_length_154_cov_2.135135_g109864_i0 | PRJNA1249042 | 110078 | 154 | 2.135135 | 3.2881079 | Vicinamibacteria bacterium | 2793154 | Bacteria | Bacteria | 42.4 | 0.0156 | NR | HXK11802.1 | 2793154 | g109864 | i0 | 71.4 | 0.818181818181818 | 21 | 6 | 40.9 | 0 | 29 | 91 | 409 | 429 | HXK11802.1 isoleucine--tRNA ligase [Vicinamibacteria bacterium] | diamond | 126 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacteria 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);;