contig_metadata
11 rows where bioproject = "PRJNA1233465", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32923870 | 32923870 | PRJNA1233465f_S_NODE_189369_length_182_cov_1.135338_g187089_i0 | PRJNA1233465 | 189369 | 182 | 1.135338 | 2.06631516 | Bacteria | 2 | Bacteria | Bacteria | 119 | 2.45e-29 | NR | OGW98185.1 | 1801839 | g187089 | i0 | 90 | 5.93406593406593 | 60 | 6 | 98.9 | 0 | 2 | 181 | 191 | 250 | OGW98185.1 MAG: glutamate synthase subunit alpha [Omnitrophica WOR_2 bacterium GWA2_45_18] | diamond | 1080 | 120 | 0.991666666666667 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium GWA2_45_18 | |||||
| 33008837 | 33008837 | PRJNA1233465a_S_NODE_166195_length_187_cov_2.043478_g164921_i0 | PRJNA1233465 | 166195 | 187 | 2.043478 | 3.82130386 | PVC group | 1783257 | Bacteria | Bacteria | 41.6 | 0.0457 | NR | MBD3378838.1 | 2035772 | g164921 | i0 | 36.7 | 1.7807486631016 | 49 | 31 | 78.6 | 0 | 180 | 34 | 139 | 187 | MBD3378838.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 333 | 42 | 0.990476190476191 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33042933 | 33042933 | PRJNA1233465a_S_NODE_144820_length_198_cov_1.550336_g143546_i0 | PRJNA1233465 | 144820 | 198 | 1.550336 | 3.06966528 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 90.9 | 1.41e-20 | NR | MBI3320648.1 | 2035772 | g143546 | i0 | 66.2 | 1.96969696969697 | 65 | 21 | 98.5 | 1 | 196 | 2 | 113 | 176 | MBI3320648.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 390 | 91.7 | 0.991275899672846 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33067997 | 33067997 | PRJNA1233465a_S_NODE_144317_length_198_cov_2.456376_g143043_i0 | PRJNA1233465 | 144317 | 198 | 2.456376 | 4.86362448 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 53.5 | 3.12e-6 | NR | MFH1800568.1 | 2035772 | g143043 | i0 | 63.2 | 0.575757575757576 | 38 | 11 | 57.6 | 1 | 197 | 84 | 446 | 480 | MFH1800568.1 leucyl aminopeptidase [Candidatus Omnitrophota bacterium] | diamond | 114 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33085781 | 33085781 | PRJNA1233465b_S_NODE_181606_length_218_cov_1.230769_g179921_i0 | PRJNA1233465 | 181606 | 218 | 1.230769 | 2.68307642 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 42.7 | 0.0072 | NR | HOW35028.1 | 2035772 | g179921 | i0 | 43.5 | 1.3348623853211 | 46 | 26 | 63.3 | 0 | 214 | 77 | 54 | 99 | HOW35028.1 cupin domain-containing protein [Candidatus Omnitrophota bacterium] | diamond | 291 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33103223 | 33103223 | PRJNA1233465b_S_NODE_50558_length_350_cov_6.930233_g48873_i0 | PRJNA1233465 | 50558 | 350 | 6.930233 | 24.2558155 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 108 | 3.97e-25 | NR | MBI4549771.1 | 2035772 | g48873 | i0 | 77.3 | 0.565714285714286 | 66 | 15 | 56.6 | 0 | 199 | 2 | 1 | 66 | MBI4549771.1 radical SAM protein [Candidatus Omnitrophota bacterium] | diamond | 198 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33104074 | 33104074 | PRJNA1233465e_S_NODE_167246_length_160_cov_3.801802_g165936_i0 | PRJNA1233465 | 167246 | 160 | 3.801802 | 6.0828832 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 45.4 | 4.38e-4 | NR | MCB9757916.1 | 2035772 | g165936 | i0 | 38 | 1.7625 | 50 | 31 | 93.8 | 0 | 1 | 150 | 60 | 109 | MCB9757916.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 282 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33111506 | 33111506 | PRJNA1233465e_S_NODE_141614_length_167_cov_1.737288_g140304_i0 | PRJNA1233465 | 141614 | 167 | 1.737288 | 2.90127096 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 1.01e-19 | NR | OGX37540.1 | 1801858 | g140304 | i0 | 90 | 13.4550898203593 | 50 | 5 | 89.8 | 0 | 17 | 166 | 77 | 126 | OGX37540.1 MAG: ATPase [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_52_10] | diamond | 2247 | 90.5 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_02_FULL_52_10 | |||||
| 33120480 | 33120480 | PRJNA1233465d_S_NODE_142583_length_162_cov_0.884956_g141472_i0 | PRJNA1233465 | 142583 | 162 | 0.884956 | 1.43362872 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 39.7 | 0.0187 | NR | MBU4376358.1 | 2035772 | g141472 | i0 | 45.5 | 0.611111111111111 | 33 | 18 | 61.1 | 0 | 157 | 59 | 7 | 39 | MBU4376358.1 50S ribosomal protein L33 [Candidatus Omnitrophota bacterium] | diamond | 99 | 39.7 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33155720 | 33155720 | PRJNA1233465f_S_NODE_16576_length_502_cov_2.801325_g14417_i0 | PRJNA1233465 | 16576 | 502 | 2.801325 | 14.0626515 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 73.9 | 1.68e-13 | NR | MCB9757916.1 | 2035772 | g14417 | i0 | 36.6 | 0.669322709163347 | 112 | 68 | 66.9 | 1 | 115 | 450 | 1 | 109 | MCB9757916.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 336 | 73.9 | 1 | Bacteria | PVC group | Pseudomonadati | Candidatus Omnitrophota | Candidatus Omnitrophota bacterium | |||||
| 33173122 | 33173122 | PRJNA1233465f_S_NODE_221696_length_170_cov_2.016529_g219416_i0 | PRJNA1233465 | 221696 | 170 | 2.016529 | 3.4280993 | Candidatus Omnitrophota bacterium | 2035772 | Bacteria | Bacteria | 77.8 | 2.73e-16 | NR | MBL8012205.1 | 2035772 | g219416 | i0 | 70 | 0.882352941176471 | 50 | 15 | 88.2 | 0 | 1 | 150 | 69 | 118 | MBL8012205.1 hypothetical protein [Candidatus Omnitrophota bacterium] | diamond | 150 | 77.8 | 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);;