contig_metadata
10 rows where bioproject = "PRJNA1011844", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27097884 | 27097884 | PRJNA1011844_P_NODE_126242_length_274_cov_10.452736_g117664_i0 | PRJNA1011844 | 126242 | 274 | 10.452736 | 28.64049664 | Candidatus Velamenicoccus archaeovorus | 1930593 | Bacteria | Bacteria | 55.1 | 2.46e-6 | NR | WP_128699025.1 | 1930593 | g117664 | i0 | 58.5 | 2.37591240875912 | 41 | 17 | 44.9 | 0 | 19 | 141 | 260 | 300 | WP_128699025.1 mucoidy inhibitor MuiA family protein [Candidatus Velamenicoccus archaeovorus] | diamond | 651 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Velamenicoccus | Candidatus Velamenicoccus archaeovorus | ||||
| 28803058 | 28803058 | PRJNA1011844_P_NODE_47808_length_652_cov_6.200345_g39613_i0 | PRJNA1011844 | 47808 | 652 | 6.200345 | 40.4262494 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 46.6 | 0.044 | NR | MDO8675958.1 | 2035772 | g39613 | i0 | 26.5 | 0.676380368098159 | 147 | 96 | 63 | 6 | 11 | 421 | 198 | 342 | MDO8675958.1 glutamate--tRNA ligase [Candidatus Omnitrophota bacterium] | diamond | 441 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29710886 | 29710886 | PRJNA1011844_P_NODE_67870_length_467_cov_4.007614_g59422_i0 | PRJNA1011844 | 67870 | 467 | 4.007614 | 18.71555738 | PVC group | 1783257 | Bacteria | Bacteria | 51.6 | 2.41e-4 | NR | MCA9399637.1 | 2035772 | g59422 | i0 | 39.7 | 0.809421841541756 | 73 | 39 | 46.9 | 1 | 25 | 243 | 157 | 224 | MCA9399637.1 ankyrin repeat domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 378 | 52 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 29876933 | 29876933 | PRJNA1011844_P_NODE_177011_length_208_cov_4.622222_g168429_i0 | PRJNA1011844 | 177011 | 208 | 4.622222 | 9.61422176 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.5 | 0.0125 | NR | MFC1631445.1 | 2035772 | g168429 | i0 | 85 | 1.3125 | 20 | 3 | 28.8 | 0 | 148 | 207 | 16 | 35 | MFC1631445.1 amidinotransferase [Candidatus Omnitrophota bacterium] | diamond | 273 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 30287875 | 30287875 | PRJNA1011844_P_NODE_109572_length_303_cov_7.834783_g100997_i0 | PRJNA1011844 | 109572 | 303 | 7.834783 | 23.73939249 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.5 | 0.038 | NR | MCB9769720.1 | 2035772 | g100997 | i0 | 36.4 | 0.762376237623762 | 77 | 39 | 70.3 | 3 | 55 | 267 | 110 | 182 | MCB9769720.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 231 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 31457019 | 31457019 | PRJNA1011844_P_NODE_58276_length_542_cov_4.138593_g49904_i0 | PRJNA1011844 | 58276 | 542 | 4.138593 | 22.43117406 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 53.5 | 1.26e-4 | NR | MCL5097506.1 | 2035772 | g49904 | i0 | 30.4 | 0.874538745387454 | 158 | 94 | 84.7 | 7 | 69 | 527 | 504 | 650 | MCL5097506.1 glycoside hydrolase family 2 [Candidatus Omnitrophota bacterium] | diamond | 474 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32176930 | 32176930 | PRJNA1011844_P_NODE_173218_length_221_cov_5.533784_g164637_i0 | PRJNA1011844 | 173218 | 221 | 5.533784 | 12.22966264 | Bacteria | 2 | Bacteria | Bacteria | 100 | 1.2e-22 | NR | MCC6758542.1 | 2035772 | g164637 | i0 | 61.8 | 2.82352941176471 | 68 | 26 | 92.3 | 0 | 12 | 215 | 177 | 244 | MCC6758542.1 MBOAT family protein [Candidatus Omnitrophota bacterium] | diamond | 624 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32342827 | 32342827 | PRJNA1011844_P_NODE_115839_length_290_cov_1.497696_g107263_i0 | PRJNA1011844 | 115839 | 290 | 1.497696 | 4.3433184 | Omnitrophica bacterium RIFCSPHIGHO2_ | 2035772 | Bacteria | Bacteria | 72.8 | 2.1e-14 | NR | OGW82557.1 | 1801823 | g107263 | i0 | 55.4 | 4.03448275862069 | 65 | 29 | 67.2 | 0 | 87 | 281 | 3 | 67 | OGW82557.1 MAG: 30S ribosomal protein S15 [Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18] | diamond | 1170 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica bacterium RIFCSPHIGHO2_02_FULL_51_18 | |||||
| 32406053 | 32406053 | PRJNA1011844_P_NODE_48659_length_642_cov_4.708260_g40443_i0 | PRJNA1011844 | 48659 | 642 | 4.70826 | 30.2270292 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 68.6 | 1.33e-9 | NR | MCK5014156.1 | 2035772 | g40443 | i0 | 32.3 | 0.883177570093458 | 189 | 103 | 77.6 | 7 | 631 | 134 | 73 | 259 | MCK5014156.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 567 | 68.6 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 32784352 | 32784352 | PRJNA1011844_P_NODE_112280_length_297_cov_3.102679_g103704_i0 | PRJNA1011844 | 112280 | 297 | 3.102679 | 9.21495663 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 43.1 | 0.0463 | NR | MEK6727990.1 | 2035772 | g103704 | i0 | 34.7 | 0.727272727272727 | 72 | 45 | 70.7 | 1 | 69 | 278 | 90 | 161 | MEK6727990.1 biotin synthase BioB [Candidatus Omnitrophota bacterium] | diamond | 216 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota 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);;