contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA781427" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16064050 | 16064050 | PRJNA781427_P_NODE_76413_length_250_cov_0.870056_g75529_i0 | PRJNA781427 | 76413 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 161 | 1.6e-45 | NR | MFO1478303.1 | 2026799 | g75529 | i0 | 97.6 | 10.956 | 83 | 2 | 99.6 | 0 | 1 | 249 | 236 | 318 | MFO1478303.1 sigma-54 dependent transcriptional regulator [Verrucomicrobiota bacterium] | diamond | 2739 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27157370 | 27157370 | PRJNA781427_P_NODE_77622_length_250_cov_0.870056_g76738_i0 | PRJNA781427 | 77622 | 250 | 0.870056 | 2.17514 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 125 | 2.3099999999999997e-31 | NR | MDP4643254.1 | 2026772 | g76738 | i0 | 67.9 | 3.024 | 84 | 26 | 99.6 | 1 | 1 | 249 | 379 | 462 | MDP4643254.1 hypothetical protein [Opitutales bacterium] | diamond | 756 | 126 | 0.992063492063492 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 27938104 | 27938104 | PRJNA781427_P_NODE_78825_length_249_cov_0.875000_g77941_i0 | PRJNA781427 | 78825 | 249 | 0.875 | 2.17875 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 94 | 2.16e-22 | NR | MEX1110853.1 | 2201154 | g77941 | i0 | 100 | 0.578313253012048 | 48 | 0 | 57.8 | 0 | 1 | 144 | 91 | 138 | MEX1110853.1 biopolymer transporter ExbD [Chthoniobacterales bacterium] | diamond | 144 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27969539 | 27969539 | PRJNA781427_P_NODE_77625_length_250_cov_0.870056_g76741_i0 | PRJNA781427 | 77625 | 250 | 0.870056 | 2.17514 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 144 | 2.76e-41 | NR | HXC32960.1 | 2499141 | g76741 | i0 | 90.2 | 0.984 | 82 | 7 | 98.4 | 1 | 3 | 248 | 64 | 144 | HXC32960.1 cytochrome c oxidase subunit 3 [Verrucomicrobiia bacterium] | diamond | 246 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28601187 | 28601187 | PRJNA781427_P_NODE_82807_length_247_cov_0.885057_g81923_i0 | PRJNA781427 | 82807 | 247 | 0.885057 | 2.18609079 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 54.3 | 1.42e-7 | NR | MDA7648774.1 | 2562705 | g81923 | i0 | 52.5 | 0.48582995951417 | 40 | 19 | 48.6 | 0 | 240 | 121 | 28 | 67 | MDA7648774.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 120 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 28664292 | 28664292 | PRJNA781427_P_NODE_83047_length_247_cov_0.885057_g82163_i0 | PRJNA781427 | 83047 | 247 | 0.885057 | 2.18609079 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 144 | 4.1e-40 | NR | HSH16017.1 | 2499141 | g82163 | i0 | 76.5 | 0.983805668016194 | 81 | 16 | 98.4 | 1 | 245 | 3 | 234 | 311 | HSH16017.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 243 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 28695958 | 28695958 | PRJNA781427_P_NODE_80647_length_248_cov_0.880000_g79763_i0 | PRJNA781427 | 80647 | 248 | 0.88 | 2.1824 | Candidatus Udaeobacter sp. | 2665650 | Bacteria | Bacteria | 100 | 2.57e-22 | NR | HWJ47637.1 | 2665650 | g79763 | i0 | 87.7 | 0.786290322580645 | 65 | 7 | 77.4 | 1 | 229 | 38 | 685 | 749 | HWJ47637.1 response regulator [Candidatus Udaeobacter sp.] | diamond | 195 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Candidatus Udaeobacter | Candidatus Udaeobacter sp. | |
| 28758866 | 28758866 | PRJNA781427_P_NODE_75027_length_251_cov_0.865169_g74143_i0 | PRJNA781427 | 75027 | 251 | 0.865169 | 2.17157419 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 183 | 2.82e-54 | NR | MEY3275544.1 | 2026799 | g74143 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 317 | 399 | MEY3275544.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 249 | 183 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29232684 | 29232684 | PRJNA781427_P_NODE_77349_length_250_cov_0.870056_g76465_i0 | PRJNA781427 | 77349 | 250 | 0.870056 | 2.17514 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 119 | 3.21e-30 | NR | MEI7733399.1 | 2026799 | g76465 | i0 | 70.4 | 0.972 | 81 | 24 | 97.2 | 0 | 7 | 249 | 103 | 183 | MEI7733399.1 RHS repeat-associated core domain-containing protein [Verrucomicrobiota bacterium] | diamond | 243 | 119 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29295686 | 29295686 | PRJNA781427_P_NODE_95469_length_241_cov_0.916667_g94585_i0 | PRJNA781427 | 95469 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 149 | 7.659999999999998e-41 | NR | HWY77892.1 | 2499141 | g94585 | i0 | 91.3 | 0.995850622406639 | 80 | 7 | 99.6 | 0 | 1 | 240 | 138 | 217 | HWY77892.1 GldG family protein [Verrucomicrobiia bacterium] | diamond | 240 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29358914 | 29358914 | PRJNA781427_P_NODE_81729_length_248_cov_0.880000_g80845_i0 | PRJNA781427 | 81729 | 248 | 0.88 | 2.1824 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 53.5 | 6.28e-6 | NR | HSY13264.1 | 2499141 | g80845 | i0 | 48.1 | 0.629032258064516 | 52 | 27 | 62.9 | 0 | 77 | 232 | 599 | 650 | HSY13264.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 156 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29421792 | 29421792 | PRJNA781427_P_NODE_85729_length_246_cov_0.890173_g84845_i0 | PRJNA781427 | 85729 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 118 | 4.41e-31 | NR | MCB1208656.1 | 2026801 | g84845 | i0 | 69.9 | 2.02439024390244 | 83 | 23 | 98.8 | 1 | 2 | 244 | 88 | 170 | MCB1208656.1 lysophospholipid acyltransferase family protein [Verrucomicrobiales bacterium] | diamond | 498 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30179836 | 30179836 | PRJNA781427_P_NODE_90612_length_244_cov_0.900585_g89728_i0 | PRJNA781427 | 90612 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 139 | 7.079999999999999e-37 | NR | MEN9675876.1 | 2026799 | g89728 | i0 | 79 | 1.99180327868852 | 81 | 17 | 99.6 | 0 | 243 | 1 | 223 | 303 | MEN9675876.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 486 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30685370 | 30685370 | PRJNA781427_P_NODE_83733_length_247_cov_0.885057_g82849_i0 | PRJNA781427 | 83733 | 247 | 0.885057 | 2.18609079 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 127 | 1.1800000000000001e-36 | NR | HVU99849.1 | 2499141 | g82849 | i0 | 93.8 | 0.777327935222672 | 64 | 4 | 77.7 | 0 | 56 | 247 | 1 | 64 | HVU99849.1 HipA N-terminal domain-containing protein [Verrucomicrobiia bacterium] | diamond | 192 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30685380 | 30685380 | PRJNA781427_P_NODE_93433_length_242_cov_0.911243_g92549_i0 | PRJNA781427 | 93433 | 242 | 0.911243 | 2.20520806 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 111 | 1.17e-27 | NR | MDB6060589.1 | 2026800 | g92549 | i0 | 63.8 | 0.991735537190083 | 80 | 29 | 99.2 | 0 | 242 | 3 | 184 | 263 | MDB6060589.1 AraC family transcriptional regulator [Verrucomicrobiaceae bacterium] | diamond | 240 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30694788 | 30694788 | PRJNA781427_P_NODE_85913_length_246_cov_0.890173_g85029_i0 | PRJNA781427 | 85913 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 137 | 1.34e-36 | NR | MBW8865516.1 | 2026799 | g85029 | i0 | 81.5 | 9.78048780487805 | 81 | 15 | 98.8 | 0 | 2 | 244 | 120 | 200 | MBW8865516.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 2406 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30780253 | 30780253 | PRJNA781427_P_NODE_64594_length_275_cov_1.490099_g63710_i0 | PRJNA781427 | 64594 | 275 | 1.490099 | 4.09777225 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 104 | 2.95e-25 | NR | MCW0218216.1 | 1965333 | g63710 | i0 | 75.8 | 0.676363636363636 | 62 | 15 | 67.6 | 0 | 272 | 87 | 176 | 237 | MCW0218216.1 LexA family transcriptional regulator [Prosthecobacter sp.] | diamond | 186 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32108354 | 32108354 | PRJNA781427_P_NODE_87998_length_245_cov_0.895349_g87114_i0 | PRJNA781427 | 87998 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 162 | 2.28e-47 | NR | MBV9732281.1 | 2026799 | g87114 | i0 | 95.1 | 2.96326530612245 | 81 | 4 | 99.2 | 0 | 243 | 1 | 125 | 205 | MBV9732281.1 pyridoxal-phosphate dependent enzyme [Verrucomicrobiota bacterium] | diamond | 726 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32519952 | 32519952 | PRJNA781427_P_NODE_92759_length_243_cov_0.905882_g91875_i0 | PRJNA781427 | 92759 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 109 | 1.3399999999999999e-25 | NR | RFC51989.1 | 2026799 | g91875 | i0 | 75.6 | 0.962962962962963 | 78 | 19 | 96.3 | 0 | 236 | 3 | 221 | 298 | RFC51989.1 MAG: Uncharacterized conserved protein (DUF2075) [Verrucomicrobiota bacterium] | diamond | 234 | 109 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32645558 | 32645558 | PRJNA781427_P_NODE_92320_length_243_cov_0.905882_g91436_i0 | PRJNA781427 | 92320 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 122 | 1.4799999999999998e-32 | NR | PYJ02970.1 | 2026799 | g91436 | i0 | 83.6 | 0.901234567901235 | 73 | 12 | 90.1 | 0 | 22 | 240 | 57 | 129 | PYJ02970.1 MAG: hypothetical protein DME25_14135 [Verrucomicrobiota bacterium] | diamond | 219 | 122 | 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);;