contig_metadata
9 rows where bioproject = "PRJEB76780", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16715421 | 16715421 | PRJEB76780_P_NODE_12374_length_245_cov_1.796512_g12274_i0 | PRJEB76780 | 12374 | 245 | 1.796512 | 4.4014544 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 143 | 1.16e-38 | NR | MBL9213920.1 | 2006848 | g12274 | i0 | 86.4 | 29.669387755102 | 81 | 11 | 99.2 | 0 | 243 | 1 | 223 | 303 | MBL9213920.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Opitutaceae bacterium] | diamond | 7269 | 144 | 0.993055555555556 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 26837227 | 26837227 | PRJEB76780_P_NODE_5861_length_334_cov_1.494253_g5761_i0 | PRJEB76780 | 5861 | 334 | 1.494253 | 4.99080502 | Bacteria | 2 | Bacteria | Bacteria | 80.1 | 1.42e-16 | NR | MDO8540592.1 | 2006848 | g5761 | i0 | 39.2 | 2.53293413173653 | 97 | 56 | 87.1 | 2 | 291 | 1 | 3 | 96 | MDO8540592.1 DUF302 domain-containing protein [Opitutaceae bacterium] | diamond | 846 | 80.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 26868938 | 26868938 | PRJEB76780_P_NODE_8181_length_283_cov_1.485714_g8081_i0 | PRJEB76780 | 8181 | 283 | 1.485714 | 4.20457062 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 2.69e-22 | NR | MBP8014419.1 | 2026799 | g8081 | i0 | 57.4 | 7.96113074204947 | 94 | 40 | 99.6 | 0 | 2 | 283 | 85 | 178 | MBP8014419.1 hydroxylamine reductase [Verrucomicrobiota bacterium] | diamond | 2253 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27824116 | 27824116 | PRJEB76780_P_NODE_1124_length_780_cov_1.493635_g1036_i0 | PRJEB76780 | 1124 | 780 | 1.493635 | 11.650353 | Luteolibacter rhizosphaerae | 2989719 | Bacteria | Bacteria | 128 | 1.2699999999999998e-31 | NR | WP_264511378.1 | 2989719 | g1036 | i0 | 52.2 | 0.530769230769231 | 138 | 59 | 53.1 | 1 | 415 | 2 | 7 | 137 | WP_264511378.1 DUF4394 domain-containing protein [Luteolibacter rhizosphaerae] | diamond | 414 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter rhizosphaerae | |
| 27855477 | 27855477 | PRJEB76780_P_NODE_12605_length_245_cov_0.906977_g12505_i0 | PRJEB76780 | 12605 | 245 | 0.906977 | 2.22209365 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 64.7 | 2.13e-10 | NR | NNE92924.1 | 2026801 | g12505 | i0 | 48.1 | 1.26122448979592 | 54 | 28 | 66.1 | 0 | 223 | 62 | 69 | 122 | NNE92924.1 superoxide dismutase family protein [Verrucomicrobiales bacterium] | diamond | 309 | 64.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28329060 | 28329060 | PRJEB76780_P_NODE_7226_length_301_cov_0.864035_g7126_i0 | PRJEB76780 | 7226 | 301 | 0.864035 | 2.60074535 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 47.4 | 5.82e-4 | NR | HEX4085711.1 | 2811408 | g7126 | i0 | 40 | 0.498338870431894 | 50 | 29 | 48.8 | 1 | 137 | 283 | 45 | 94 | HEX4085711.1 hypothetical protein [Chthoniobacteraceae bacterium] | diamond | 150 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 29908046 | 29908046 | PRJEB76780_P_NODE_7031_length_305_cov_1.008621_g6931_i0 | PRJEB76780 | 7031 | 305 | 1.008621 | 3.07629405 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 65.5 | 8.01e-10 | NR | MEK7782269.1 | 2026799 | g6931 | i0 | 53.1 | 2.53770491803279 | 64 | 28 | 63 | 1 | 193 | 2 | 487 | 548 | MEK7782269.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Verrucomicrobiota bacterium] | diamond | 774 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30539727 | 30539727 | PRJEB76780_P_NODE_13193_length_242_cov_1.710059_g13093_i0 | PRJEB76780 | 13193 | 242 | 1.710059 | 4.13834278 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 44.3 | 0.0102 | NR | MFL6529243.1 | 2201154 | g13093 | i0 | 33.3 | 1.26446280991736 | 51 | 34 | 63.2 | 0 | 154 | 2 | 182 | 232 | MFL6529243.1 chromate efflux transporter [Chthoniobacterales bacterium] | diamond | 306 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32776652 | 32776652 | PRJEB76780_P_NODE_8280_length_281_cov_2.807692_g8180_i0 | PRJEB76780 | 8280 | 281 | 2.807692 | 7.88961452 | Bacteria | 2 | Bacteria | Bacteria | 43.9 | 0.00986 | NR | MFP4674096.1 | 2026772 | g8180 | i0 | 35.2 | 3.75800711743772 | 54 | 35 | 57.7 | 0 | 183 | 22 | 52 | 105 | MFP4674096.1 hypothetical protein [Opitutales bacterium] | diamond | 1056 | 44.3 | 0.99097065462754 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales 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);;