contig_metadata
13 rows where bioproject = "PRJNA699078" and tax_clade = "PVC group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19809047 | 19809047 | PRJNA699078_S_NODE_36956_length_285_cov_1.233051_g36007_i0 | PRJNA699078 | 36956 | 285 | 1.233051 | 3.51419535 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 84.7 | 4.15e-18 | NR | MBI1978359.1 | 2035772 | g36007 | i0 | 51.6 | 2.93684210526316 | 93 | 38 | 97.9 | 2 | 2 | 280 | 96 | 181 | MBI1978359.1 DJ-1/PfpI family protein [Candidatus Omnitrophota bacterium] | diamond | 837 | 84.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 26893111 | 26893111 | PRJNA699078_S_NODE_38641_length_278_cov_2.043668_g37692_i0 | PRJNA699078 | 38641 | 278 | 2.043668 | 5.68139704 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 66.6 | 7.56e-12 | NR | MBO7147636.1 | 2053569 | g37692 | i0 | 37.1 | 1.89928057553957 | 89 | 56 | 96 | 0 | 10 | 276 | 9 | 97 | MBO7147636.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 528 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27335714 | 27335714 | PRJNA699078_S_NODE_55303_length_229_cov_1.466667_g54354_i0 | PRJNA699078 | 55303 | 229 | 1.466667 | 3.35866743 | Rhodopirellula sallentina | 1263869 | Bacteria | Bacteria | 93.2 | 2.88e-20 | NR | WP_085979993.1 | 1263869 | g54354 | i0 | 69.5 | 1.54585152838428 | 59 | 18 | 77.3 | 0 | 1 | 177 | 308 | 366 | WP_085979993.1 cis-3-hydroxy-L-proline dehydratase [Rhodopirellula sallentina] | diamond | 354 | 93.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Rhodopirellula | Rhodopirellula sallentina | |
| 27556437 | 27556437 | PRJNA699078_S_NODE_11084_length_462_cov_6.135593_g10169_i0 | PRJNA699078 | 11084 | 462 | 6.135593 | 28.34643966 | Planctomycetota bacterium | 2026780 | Bacteria | Bacteria | 147 | 3.31e-40 | NR | MEI8371948.1 | 2026780 | g10169 | i0 | 56.1 | 5.31168831168831 | 132 | 58 | 85.7 | 0 | 422 | 27 | 193 | 324 | MEI8371948.1 hypothetical protein [Planctomycetota bacterium] | diamond | 2454 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetota bacterium | |||||
| 27714953 | 27714953 | PRJNA699078_S_NODE_109524_length_156_cov_2.429907_g108575_i0 | PRJNA699078 | 109524 | 156 | 2.429907 | 3.79065492 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 62 | 1.85e-9 | NR | MEC8928922.1 | 2026799 | g108575 | i0 | 54 | 4.98076923076923 | 50 | 23 | 96.2 | 0 | 150 | 1 | 509 | 558 | MEC8928922.1 arginine--tRNA ligase [Verrucomicrobiota bacterium] | diamond | 777 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29798307 | 29798307 | PRJNA699078_S_NODE_105211_length_164_cov_0.904348_g104262_i0 | PRJNA699078 | 105211 | 164 | 0.904348 | 1.48313072 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.7 | 0.0125 | NR | MDQ6626063.1 | 2026799 | g104262 | i0 | 46.2 | 0.713414634146341 | 39 | 21 | 71.3 | 0 | 14 | 130 | 43 | 81 | MDQ6626063.1 sulfotransferase domain-containing protein [Verrucomicrobiota bacterium] | diamond | 117 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30473191 | 30473191 | PRJNA699078_S_NODE_21493_length_363_cov_4.426752_g20544_i0 | PRJNA699078 | 21493 | 363 | 4.426752 | 16.06910976 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 77.8 | 3.3e-14 | NR | MBL9129324.1 | 2026801 | g20544 | i0 | 37 | 4.05785123966942 | 100 | 59 | 80.2 | 3 | 363 | 73 | 63 | 161 | MBL9129324.1 redoxin domain-containing protein [Verrucomicrobiales bacterium] | diamond | 1473 | 77.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30682866 | 30682866 | PRJNA699078_S_NODE_31493_length_307_cov_3.065891_g30544_i0 | PRJNA699078 | 31493 | 307 | 3.065891 | 9.41228537 | Chlamydiales bacterium | 2047757 | Bacteria | Bacteria | 43.5 | 0.0416 | NR | MFI5343144.1 | 2047757 | g30544 | i0 | 31.3 | 0.625407166123778 | 64 | 43 | 62.5 | 1 | 260 | 69 | 173 | 235 | MFI5343144.1 type IV secretion system protein TraC [Chlamydiales bacterium] | diamond | 192 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Chlamydiales | Chlamydiales bacterium | |||
| 31283326 | 31283326 | PRJNA699078_S_NODE_65855_length_208_cov_1.503145_g64906_i0 | PRJNA699078 | 65855 | 208 | 1.503145 | 3.1265416 | Planctomycetes bacterium RIFCSPLOWO2_12_38_17 | 1801946 | Bacteria | Bacteria | 42.7 | 0.0243 | NR | OHB98512.1 | 1801946 | g64906 | i0 | 29.6 | 0.778846153846154 | 54 | 38 | 77.9 | 0 | 47 | 208 | 84 | 137 | OHB98512.1 MAG: hypothetical protein A2W74_07070 [Planctomycetes bacterium RIFCSPLOWO2_12_38_17] | diamond | 162 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetes bacterium RIFCSPLOWO2_12_38_17 | |||||
| 31326229 | 31326229 | PRJNA699078_S_NODE_95615_length_170_cov_2.231405_g94666_i0 | PRJNA699078 | 95615 | 170 | 2.231405 | 3.7933885 | Bacteria | 2 | Bacteria | Bacteria | 59.3 | 1.74e-8 | NR | MEN9343412.1 | 2081524 | g94666 | i0 | 59.6 | 9 | 47 | 19 | 82.9 | 0 | 3 | 143 | 268 | 314 | MEN9343412.1 thioredoxin reductase [Chlamydiota bacterium] | diamond | 1530 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiota bacterium | |||||
| 31346795 | 31346795 | PRJNA699078_S_NODE_34456_length_295_cov_1.268293_g33507_i0 | PRJNA699078 | 34456 | 295 | 1.268293 | 3.74146435 | Pirellulaceae bacterium | 2699754 | Bacteria | Bacteria | 68.2 | 6.35e-11 | NR | MDA7951408.1 | 2699754 | g33507 | i0 | 47.9 | 0.722033898305085 | 71 | 37 | 72.2 | 0 | 294 | 82 | 269 | 339 | MDA7951408.1 asparaginase [Pirellulaceae bacterium] | diamond | 213 | 68.2 | 1 | Bacteria | PVC group | Pseudomonadati | Planctomycetota | Planctomycetia | Pirellulales | Pirellulaceae | Pirellulaceae bacterium | ||
| 31473363 | 31473363 | PRJNA699078_S_NODE_37536_length_282_cov_3.497854_g36587_i0 | PRJNA699078 | 37536 | 282 | 3.497854 | 9.86394828 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 80.9 | 2.34e-15 | NR | MBG89631.1 | 2026801 | g36587 | i0 | 44.4 | 0.957446808510638 | 90 | 48 | 93.6 | 1 | 19 | 282 | 467 | 556 | MBG89631.1 glutamine--tRNA ligase [Verrucomicrobiales bacterium] | diamond | 270 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 32496957 | 32496957 | PRJNA699078_S_NODE_98159_length_168_cov_2.184874_g97210_i0 | PRJNA699078 | 98159 | 168 | 2.184874 | 3.67058832 | PVC group | 1783257 | Bacteria | Bacteria | 73.9 | 1.14e-13 | NR | MBQ9788854.1 | 2053569 | g97210 | i0 | 59.6 | 4.67857142857143 | 52 | 21 | 92.9 | 0 | 9 | 164 | 319 | 370 | MBQ9788854.1 type III PLP-dependent enzyme [Lentisphaeria bacterium] | diamond | 786 | 73.9 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria 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);;