contig_metadata
7 rows where bioproject = "PRJNA811725" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5913473 | 5913473 | PRJNA811725_P_NODE_40505_length_243_cov_1.358824_g40259_i0 | PRJNA811725 | 40505 | 243 | 1.358824 | 3.30194232 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 76.8 | 1.3e-9 | NTclustered | gi|2893358436|emb|OZ220728.1| | 2910147 | g40259 | i0 | 94.118 | 8.85185185185185 | 51 | 2 | 21 | 1 | 97 | 146 | 5472665 | 5472615 | MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1 | blastn | 2151 | 76.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 26610896 | 26610896 | PRJNA811725_P_NODE_8461_length_507_cov_2.324885_g8218_i0 | PRJNA811725 | 8461 | 507 | 2.324885 | 11.78716695 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 137 | 3.57e-38 | NR | HZE26521.1 | 2282142 | g8218 | i0 | 86.1 | 0.93491124260355 | 79 | 11 | 46.7 | 0 | 505 | 269 | 69 | 147 | HZE26521.1 23S rRNA (pseudouridine(1915)-N(3))-methyltransferase RlmH [Terriglobales bacterium] | diamond | 474 | 137 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27370668 | 27370668 | PRJNA811725_P_NODE_9903_length_472_cov_6.210526_g9659_i0 | PRJNA811725 | 9903 | 472 | 6.210526 | 29.31368272 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 153 | 1.1199999999999996e-43 | NR | PYX82246.1 | 1978231 | g9659 | i0 | 68.6 | 4.03601694915254 | 105 | 33 | 66.7 | 0 | 471 | 157 | 96 | 200 | PYX82246.1 MAG: DNA-3-methyladenine glycosylase [Acidobacteriota bacterium] | diamond | 1905 | 153 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28159903 | 28159903 | PRJNA811725_P_NODE_30505_length_282_cov_1.473684_g30259_i0 | PRJNA811725 | 30505 | 282 | 1.473684 | 4.15578888 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 90.9 | 5.66e-19 | NR | HEY6972037.1 | 2976921 | g30259 | i0 | 54.3 | 8.85106382978723 | 92 | 41 | 97.9 | 1 | 280 | 5 | 38 | 128 | HEY6972037.1 hypothetical protein [Candidatus Angelobacter sp.] | diamond | 2496 | 90.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 29864692 | 29864692 | PRJNA811725_P_NODE_26431_length_299_cov_2.659292_g26185_i0 | PRJNA811725 | 26431 | 299 | 2.659292 | 7.95128308 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 61.6 | 4.25e-9 | NR | HEX8186727.1 | 2283092 | g26185 | i0 | 58 | 0.501672240802676 | 50 | 19 | 48.2 | 2 | 146 | 3 | 60 | 109 | HEX8186727.1 DUF1572 family protein [Pyrinomonadaceae bacterium] | diamond | 150 | 61.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30410972 | 30410972 | PRJNA811725_P_NODE_8493_length_506_cov_3.986143_g8250_i0 | PRJNA811725 | 8493 | 506 | 3.986143 | 20.16988358 | Bacteria | 2 | Bacteria | Bacteria | 50.8 | 7.86e-4 | NR | HKN72360.1 | 2282142 | g8250 | i0 | 52.2 | 0.74703557312253 | 46 | 22 | 27.3 | 0 | 361 | 498 | 346 | 391 | HKN72360.1 PAS domain S-box protein [Terriglobales bacterium] | diamond | 378 | 51.2 | 0.9921875 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31254903 | 31254903 | PRJNA811725_P_NODE_9655_length_477_cov_3.430693_g9411_i0 | PRJNA811725 | 9655 | 477 | 3.430693 | 16.36440561 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 250 | 4.58e-75 | NR | HXI74091.1 | 2283092 | g9411 | i0 | 81.9 | 0.937106918238994 | 149 | 27 | 93.7 | 0 | 2 | 448 | 441 | 589 | HXI74091.1 carboxypeptidase-like regulatory domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 447 | 250 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;