contig_metadata
16 rows where bioproject = "PRJNA661142", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13382168 | 13382168 | PRJNA661142_P_NODE_12351_length_163_cov_0.894737_g12286_i0 | PRJNA661142 | 12351 | 163 | 0.894737 | 1.45842131 | Nibricoccus aquaticus | 2576891 | Bacteria | Bacteria | 99 | 1.72e-16 | NTclustered | gi|1243404978|gb|CP023344.1| | 2576891 | g12286 | i0 | 78.667 | 39.9815950920245 | 150 | 30 | 91 | 2 | 7 | 155 | 74725 | 74873 | Nibricoccus aquaticus strain HZ-65 chromosome, complete genome | blastn | 6517 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus aquaticus | |
| 25388119 | 25388119 | PRJNA661142_P_NODE_1760_length_576_cov_50.130930_g1699_i0 | PRJNA661142 | 1760 | 576 | 50.13093 | 288.7541568 | Luteolibacter | 518753 | Bacteria | Bacteria | 573 | 9.809999999999998e-159 | NTclustered | gi|2585939279|dbj|AP024600.1| | 2819286 | g1699 | i0 | 85.923 | 233.480902777778 | 547 | 65 | 93 | 8 | 39 | 576 | 2217888 | 2217345 | Luteolibacter sp. LG18 DNA, complete genome | blastn | 134485 | 573 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. LG18 | |
| 26796603 | 26796603 | PRJNA661142_P_NODE_12401_length_162_cov_0.902655_g12336_i0 | PRJNA661142 | 12401 | 162 | 0.902655 | 1.4623011 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 73.2 | 2.25e-13 | NR | MCX6902356.1 | 2026799 | g12336 | i0 | 77.4 | 0.981481481481482 | 53 | 12 | 98.1 | 0 | 2 | 160 | 177 | 229 | MCX6902356.1 DUF1080 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 159 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26923256 | 26923256 | PRJNA661142_P_NODE_12342_length_163_cov_0.894737_g12277_i0 | PRJNA661142 | 12342 | 163 | 0.894737 | 1.45842131 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 107 | 7.33e-27 | NR | HUJ11232.1 | 2499141 | g12277 | i0 | 88.9 | 1.96932515337423 | 54 | 6 | 99.4 | 0 | 163 | 2 | 154 | 207 | HUJ11232.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 321 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27283298 | 27283298 | PRJNA661142_P_NODE_11343_length_167_cov_0.864407_g11278_i0 | PRJNA661142 | 11343 | 167 | 0.864407 | 1.44355969 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.9 | 9.2e-11 | NR | MCX6893336.1 | 2026799 | g11278 | i0 | 67.3 | 2.96407185628743 | 55 | 17 | 98.8 | 1 | 3 | 167 | 4 | 57 | MCX6893336.1 aldehyde dehydrogenase EutE [Verrucomicrobiota bacterium] | diamond | 495 | 66.2 | 0.995468277945619 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27283299 | 27283299 | PRJNA661142_P_NODE_11703_length_166_cov_0.871795_g11638_i0 | PRJNA661142 | 11703 | 166 | 0.871795 | 1.4471797 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 83.2 | 7.39e-17 | NR | MEI7937755.1 | 2026799 | g11638 | i0 | 61.8 | 9.93975903614458 | 55 | 21 | 99.4 | 0 | 2 | 166 | 88 | 142 | MEI7937755.1 beta-propeller fold lactonase family protein [Verrucomicrobiota bacterium] | diamond | 1650 | 83.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27523752 | 27523752 | PRJNA661142_P_NODE_4463_length_369_cov_1.062500_g4398_i0 | PRJNA661142 | 4463 | 369 | 1.0625 | 3.920625 | Candidatus Udaeobacter sp. | 2665650 | Bacteria | Bacteria | 41.2 | 0.0417 | NR | HXQ40880.1 | 2665650 | g4398 | i0 | 66.7 | 0.24390243902439 | 30 | 10 | 24.4 | 0 | 359 | 270 | 1 | 30 | HXQ40880.1 LysR family transcriptional regulator [Candidatus Udaeobacter sp.] | diamond | 90 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Candidatus Udaeobacter | Candidatus Udaeobacter sp. | |
| 27587018 | 27587018 | PRJNA661142_P_NODE_11424_length_167_cov_0.864407_g11359_i0 | PRJNA661142 | 11424 | 167 | 0.864407 | 1.44355969 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 51.2 | 1.36e-5 | NR | MBL9168586.1 | 2026801 | g11359 | i0 | 46.3 | 0.970059880239521 | 54 | 29 | 97 | 0 | 162 | 1 | 103 | 156 | MBL9168586.1 RHS repeat-associated core domain-containing protein [Verrucomicrobiales bacterium] | diamond | 162 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28376176 | 28376176 | PRJNA661142_P_NODE_12326_length_163_cov_0.894737_g12261_i0 | PRJNA661142 | 12326 | 163 | 0.894737 | 1.45842131 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 73.2 | 2.31e-13 | NR | MCX6887604.1 | 2026799 | g12261 | i0 | 66.7 | 1.98773006134969 | 54 | 18 | 99.4 | 0 | 162 | 1 | 155 | 208 | MCX6887604.1 ATP-binding protein [Verrucomicrobiota bacterium] | diamond | 324 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28957009 | 28957009 | PRJNA661142_P_NODE_12208_length_163_cov_0.894737_g12143_i0 | PRJNA661142 | 12208 | 163 | 0.894737 | 1.45842131 | PVC group | 1783257 | Bacteria | Bacteria | 82 | 1.72e-16 | NR | HUA57236.1 | 2499141 | g12143 | i0 | 80 | 3.80981595092025 | 50 | 10 | 92 | 0 | 158 | 9 | 463 | 512 | HUA57236.1 DUF3656 domain-containing protein [Verrucomicrobiia bacterium] | diamond | 621 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29039573 | 29039573 | PRJNA661142_P_NODE_12788_length_161_cov_0.910714_g12723_i0 | PRJNA661142 | 12788 | 161 | 0.910714 | 1.46624954 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 95.5 | 9.76e-22 | NR | MSR64416.1 | 2499141 | g12723 | i0 | 76.9 | 0.968944099378882 | 52 | 12 | 96.9 | 0 | 161 | 6 | 76 | 127 | MSR64416.1 MBL fold metallo-hydrolase [Verrucomicrobiia bacterium] | diamond | 156 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29355182 | 29355182 | PRJNA661142_P_NODE_11469_length_167_cov_0.864407_g11404_i0 | PRJNA661142 | 11469 | 167 | 0.864407 | 1.44355969 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 72.4 | 4.59e-13 | NR | MBN2506407.1 | 2026799 | g11404 | i0 | 66.7 | 1.76047904191617 | 48 | 8 | 86.2 | 2 | 161 | 18 | 509 | 548 | MBN2506407.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 294 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30934591 | 30934591 | PRJNA661142_P_NODE_3014_length_453_cov_42.566832_g2951_i0 | PRJNA661142 | 3014 | 453 | 42.566832 | 192.82774896 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 101 | 1.06e-21 | NR | PYJ58739.1 | 2026799 | g2951 | i0 | 54.3 | 0.536423841059603 | 81 | 37 | 53.6 | 0 | 40 | 282 | 768 | 848 | PYJ58739.1 MAG: hypothetical protein DME24_15085, partial [Verrucomicrobiota bacterium] | diamond | 243 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31281997 | 31281997 | PRJNA661142_P_NODE_12055_length_164_cov_0.886957_g11990_i0 | PRJNA661142 | 12055 | 164 | 0.886957 | 1.45460948 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 79.3 | 1.6e-15 | NR | HEY9175879.1 | 2499141 | g11990 | i0 | 67.9 | 1.92073170731707 | 53 | 17 | 97 | 0 | 162 | 4 | 760 | 812 | HEY9175879.1 DUF4965 domain-containing protein [Verrucomicrobiia bacterium] | diamond | 315 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31567010 | 31567010 | PRJNA661142_P_NODE_12356_length_163_cov_0.885965_g12291_i0 | PRJNA661142 | 12356 | 163 | 0.885965 | 1.44412295 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 90.5 | 1.24e-21 | NR | MCW5556047.1 | 2499141 | g12291 | i0 | 73.6 | 0.975460122699387 | 53 | 14 | 97.5 | 0 | 3 | 161 | 52 | 104 | MCW5556047.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 159 | 90.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32199560 | 32199560 | PRJNA661142_P_NODE_11778_length_165_cov_0.879310_g11713_i0 | PRJNA661142 | 11778 | 165 | 0.87931 | 1.4508615 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 89.4 | 2.01e-19 | NR | HPC59806.1 | 2026799 | g11713 | i0 | 81.5 | 1.96363636363636 | 54 | 10 | 98.2 | 0 | 2 | 163 | 76 | 129 | HPC59806.1 dipeptide epimerase [Verrucomicrobiota bacterium] | diamond | 324 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;