contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA546018" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6889030 | 6889030 | PRJNA546018_S_NODE_55666_length_205_cov_0.902778_g55341_i0 | PRJNA546018 | 55666 | 205 | 0.902778 | 1.8506949 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 96.7 | 1.02e-21 | NR | MDB6113615.1 | 1961806 | g55341 | i0 | 90 | 1.46341463414634 | 50 | 5 | 73.2 | 0 | 55 | 204 | 206 | 255 | MDB6113615.1 putative FAD-linked oxidoreductase [Lacunisphaera sp.] | diamond | 300 | 96.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 11322391 | 11322391 | PRJNA546018_S_NODE_49669_length_215_cov_2.110390_g49344_i0 | PRJNA546018 | 49669 | 215 | 2.11039 | 4.5373385 | Bacteria | 2 | Bacteria | Bacteria | 115 | 1.1599999999999999e-28 | NR | MBN8246459.1 | 2026799 | g49344 | i0 | 79.7 | 3.57209302325581 | 64 | 13 | 89.3 | 0 | 213 | 22 | 150 | 213 | MBN8246459.1 efflux RND transporter permease subunit [Verrucomicrobiota bacterium] | diamond | 768 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 23463416 | 23463416 | PRJNA546018_S_NODE_44739_length_229_cov_1.160714_g44414_i0 | PRJNA546018 | 44739 | 229 | 1.160714 | 2.65803506 | Lacunisphaera | 1961799 | Bacteria | Bacteria | 96.3 | 1.24e-21 | NR | HEY8993145.1 | 1961806 | g44414 | i0 | 81.1 | 1.40174672489083 | 53 | 10 | 69.4 | 0 | 14 | 172 | 103 | 155 | HEY8993145.1 YCF48-related protein [Lacunisphaera sp.] | diamond | 321 | 96.7 | 0.995863495346432 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 27362676 | 27362676 | PRJNA546018_S_NODE_53443_length_208_cov_1.163265_g53118_i0 | PRJNA546018 | 53443 | 208 | 1.163265 | 2.4195912 | Candidatus Udaeobacter sp. | 2665650 | Bacteria | Bacteria | 137 | 1.6199999999999998e-35 | NR | MFL6504060.1 | 2665650 | g53118 | i0 | 92.8 | 0.995192307692308 | 69 | 5 | 99.5 | 0 | 207 | 1 | 446 | 514 | MFL6504060.1 FAD-binding and (Fe-S)-binding domain-containing protein [Candidatus Udaeobacter sp.] | diamond | 207 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Candidatus Udaeobacter | Candidatus Udaeobacter sp. | |
| 27787850 | 27787850 | PRJNA546018_S_NODE_28904_length_293_cov_2.125000_g28579_i0 | PRJNA546018 | 28904 | 293 | 2.125 | 6.22625 | Horticoccus | 2986286 | Bacteria | Bacteria | 101 | 2.1399999999999994e-23 | NR | PAW64921.1 | 1982319 | g28579 | i0 | 59.3 | 1.5358361774744 | 81 | 33 | 82.9 | 0 | 263 | 21 | 2 | 82 | PAW64921.1 MAG: hypothetical protein B9S34_11765 [Opitutia bacterium Tous-C1TDCM] | diamond | 450 | 102 | 0.990196078431373 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium Tous-C1TDCM | ||||
| 27962313 | 27962313 | PRJNA546018_S_NODE_37985_length_251_cov_1.026316_g37660_i0 | PRJNA546018 | 37985 | 251 | 1.026316 | 2.57605316 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 138 | 2.09e-36 | NR | WP_165201968.1 | 2711231 | g37660 | i0 | 89.5 | 0.908366533864542 | 76 | 8 | 90.8 | 0 | 23 | 250 | 354 | 429 | WP_165201968.1 preprotein translocase subunit SecY [Roseimicrobium sp. ORNL1] | diamond | 228 | 138 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 | |
| 28040385 | 28040385 | PRJNA546018_S_NODE_30225_length_286_cov_0.866667_g29900_i0 | PRJNA546018 | 30225 | 286 | 0.866667 | 2.47866762 | Opitutaceae | 134623 | Bacteria | Bacteria | 115 | 8.27e-29 | NR | HEY8995874.1 | 1961806 | g29900 | i0 | 66.3 | 1.93006993006993 | 92 | 30 | 96.5 | 1 | 11 | 286 | 136 | 226 | HEY8995874.1 hypothetical protein [Lacunisphaera sp.] | diamond | 552 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 28404362 | 28404362 | PRJNA546018_S_NODE_18966_length_373_cov_9.131410_g18641_i0 | PRJNA546018 | 18966 | 373 | 9.13141 | 34.0601593 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 64.3 | 4.59e-9 | NR | MEN7973604.1 | 2026799 | g18641 | i0 | 53.6 | 0.450402144772118 | 56 | 25 | 44.2 | 1 | 347 | 183 | 733 | 788 | MEN7973604.1 reverse transcriptase domain-containing protein [Verrucomicrobiota bacterium] | diamond | 168 | 64.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28657097 | 28657097 | PRJNA546018_S_NODE_3407_length_1009_cov_3.419831_g3208_i0 | PRJNA546018 | 3407 | 1009 | 3.419831 | 34.50609479 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 185 | 1.25e-48 | NR | MBI5387454.1 | 2026799 | g3208 | i0 | 53.3 | 1.02279484638256 | 167 | 77 | 49.7 | 1 | 48 | 548 | 1 | 166 | MBI5387454.1 PAS domain S-box protein [Verrucomicrobiota bacterium] | diamond | 1032 | 185 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28877850 | 28877850 | PRJNA546018_S_NODE_32668_length_273_cov_1.533019_g32343_i0 | PRJNA546018 | 32668 | 273 | 1.533019 | 4.18514187 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 133 | 2.21e-35 | NR | HEY0944486.1 | 2006848 | g32343 | i0 | 75.9 | 0.912087912087912 | 83 | 20 | 91.2 | 0 | 10 | 258 | 49 | 131 | HEY0944486.1 transaldolase family protein [Opitutaceae bacterium] | diamond | 249 | 133 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28941347 | 28941347 | PRJNA546018_S_NODE_54148_length_207_cov_1.034247_g53823_i0 | PRJNA546018 | 54148 | 207 | 1.034247 | 2.14089129 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 128 | 1.4399999999999999e-32 | NR | MBN8460050.1 | 2026799 | g53823 | i0 | 85.3 | 0.985507246376812 | 68 | 10 | 98.6 | 0 | 206 | 3 | 259 | 326 | MBN8460050.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 204 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29193902 | 29193902 | PRJNA546018_S_NODE_32789_length_272_cov_3.218009_g32464_i0 | PRJNA546018 | 32789 | 272 | 3.218009 | 8.75298448 | Brevifollis gellanilyticus | 748831 | Bacteria | Bacteria | 131 | 8.19e-34 | NR | WP_170266582.1 | 748831 | g32464 | i0 | 89.5 | 0.838235294117647 | 76 | 8 | 83.8 | 0 | 24 | 251 | 55 | 130 | WP_170266582.1 S41 family peptidase [Brevifollis gellanilyticus] | diamond | 228 | 131 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Brevifollis | Brevifollis gellanilyticus | |
| 29951566 | 29951566 | PRJNA546018_S_NODE_57571_length_202_cov_0.921986_g57246_i0 | PRJNA546018 | 57571 | 202 | 0.921986 | 1.86241172 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 77.4 | 2.26e-16 | NR | HON08814.1 | 2026799 | g57246 | i0 | 52.3 | 4.81188118811881 | 65 | 31 | 96.5 | 0 | 201 | 7 | 45 | 109 | HON08814.1 glycosyl hydrolase [Verrucomicrobiota bacterium] | diamond | 972 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31784528 | 31784528 | PRJNA546018_S_NODE_49757_length_215_cov_1.610390_g49432_i0 | PRJNA546018 | 49757 | 215 | 1.61039 | 3.4623385 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 94.4 | 1.77e-20 | NR | MDR1280815.1 | 2006848 | g49432 | i0 | 73.4 | 0.893023255813953 | 64 | 17 | 89.3 | 0 | 13 | 204 | 556 | 619 | MDR1280815.1 hypothetical protein [Opitutaceae bacterium] | diamond | 192 | 94.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32069372 | 32069372 | PRJNA546018_S_NODE_23278_length_332_cov_1.833948_g22953_i0 | PRJNA546018 | 23278 | 332 | 1.833948 | 6.08870736 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 59.7 | 4.26e-8 | NR | MBN8709212.1 | 2026799 | g22953 | i0 | 61.1 | 0.487951807228916 | 54 | 20 | 47.9 | 1 | 266 | 108 | 153 | 206 | MBN8709212.1 TetR family transcriptional regulator [Verrucomicrobiota bacterium] | diamond | 162 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32196041 | 32196041 | PRJNA546018_S_NODE_58458_length_198_cov_2.094891_g58133_i0 | PRJNA546018 | 58458 | 198 | 2.094891 | 4.14788418 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 94.7 | 9.93e-21 | NR | MBL9188591.1 | 2006848 | g58133 | i0 | 95.7 | 0.696969696969697 | 46 | 2 | 69.7 | 0 | 197 | 60 | 287 | 332 | MBL9188591.1 TonB-dependent receptor [Opitutaceae bacterium] | diamond | 138 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32638319 | 32638319 | PRJNA546018_S_NODE_35320_length_261_cov_1.840000_g34995_i0 | PRJNA546018 | 35320 | 261 | 1.84 | 4.8024 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 43.5 | 0.0247 | NR | MEN9359760.1 | 2026799 | g34995 | i0 | 33.8 | 0.816091954022989 | 71 | 47 | 81.6 | 0 | 258 | 46 | 282 | 352 | MEN9359760.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 213 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32795794 | 32795794 | PRJNA546018_S_NODE_41560_length_238_cov_4.926554_g41235_i0 | PRJNA546018 | 41560 | 238 | 4.926554 | 11.72519852 | Candidatus Synoicihabitans palmerolidicus | 2818510 | Bacteria | Bacteria | 113 | 4.160000000000001e-27 | NR | MCC5025902.1 | 2818510 | g41235 | i0 | 74 | 0.920168067226891 | 73 | 19 | 92 | 0 | 221 | 3 | 1762 | 1834 | MCC5025902.1 polyketide synthase dehydratase domain-containing protein [Candidatus Synoicihabitans palmerolidicus] | diamond | 219 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Synoicihabitans | Candidatus Synoicihabitans palmerolidicus |
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);;