contig_metadata
25 rows where bioproject = "PRJNA756891" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26831464 | 26831464 | PRJNA756891_P_NODE_16001_length_242_cov_0.911243_g15932_i0 | PRJNA756891 | 16001 | 242 | 0.911243 | 2.20520806 | Pedosphaera sp. | 2024890 | Bacteria | Bacteria | 66.6 | 1.43e-10 | NR | MDB6121029.1 | 2024890 | g15932 | i0 | 49.4 | 1.02892561983471 | 83 | 39 | 99.2 | 2 | 241 | 2 | 859 | 941 | MDB6121029.1 hypothetical protein [Pedosphaera sp.] | diamond | 249 | 66.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. | |
| 27179166 | 27179166 | PRJNA756891_P_NODE_1422_length_682_cov_1.885057_g1358_i0 | PRJNA756891 | 1422 | 682 | 1.885057 | 12.85608874 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 110 | 8.36e-25 | NR | HEY5911529.1 | 2499141 | g1358 | i0 | 40.7 | 1.62316715542522 | 189 | 100 | 81.4 | 5 | 560 | 6 | 32 | 212 | HEY5911529.1 phosphate ABC transporter substrate-binding protein PstS [Verrucomicrobiia bacterium] | diamond | 1107 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27315799 | 27315799 | PRJNA756891_P_NODE_1683_length_632_cov_7.023256_g1616_i0 | PRJNA756891 | 1683 | 632 | 7.023256 | 44.38697792 | PVC group | 1783257 | Bacteria | Bacteria | 58.9 | 3.03e-6 | NR | MEI8312125.1 | 2026799 | g1616 | i0 | 31.6 | 1.27689873417722 | 155 | 85 | 65.5 | 5 | 200 | 613 | 18 | 168 | MEI8312125.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 807 | 59.3 | 0.993254637436762 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27590221 | 27590221 | PRJNA756891_P_NODE_1684_length_632_cov_6.157424_g1617_i0 | PRJNA756891 | 1684 | 632 | 6.157424 | 38.91491968 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 58.2 | 5.53e-6 | NR | MEI8312125.1 | 2026799 | g1617 | i0 | 31.6 | 1.30063291139241 | 155 | 85 | 65.5 | 5 | 200 | 613 | 18 | 168 | MEI8312125.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 822 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27789419 | 27789419 | PRJNA756891_P_NODE_13304_length_248_cov_0.880000_g13235_i0 | PRJNA756891 | 13304 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 95.9 | 7.94e-21 | NR | MCX6901516.1 | 2026799 | g13235 | i0 | 55.6 | 4.8991935483871 | 81 | 36 | 98 | 0 | 5 | 247 | 212 | 292 | MCX6901516.1 PAS domain S-box protein [Verrucomicrobiota bacterium] | diamond | 1215 | 96.7 | 0.991726990692865 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27884003 | 27884003 | PRJNA756891_P_NODE_3805_length_430_cov_0.823529_g3736_i0 | PRJNA756891 | 3805 | 430 | 0.823529 | 3.5411747 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 171 | 1.94e-47 | NR | HLP09976.1 | 2006848 | g3736 | i0 | 61.5 | 12.0139534883721 | 143 | 55 | 99.8 | 0 | 429 | 1 | 256 | 398 | HLP09976.1 NAD-dependent malic enzyme [Opitutaceae bacterium] | diamond | 5166 | 172 | 0.994186046511628 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 27905503 | 27905503 | PRJNA756891_P_NODE_15065_length_244_cov_0.900585_g14996_i0 | PRJNA756891 | 15065 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 53.1 | 8.02e-6 | NR | PYI49799.1 | 2026799 | g14996 | i0 | 28.4 | 2.98770491803279 | 81 | 57 | 99.6 | 1 | 244 | 2 | 109 | 188 | PYI49799.1 MAG: hypothetical protein DMF11_00075, partial [Verrucomicrobiota bacterium] | diamond | 729 | 53.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28347783 | 28347783 | PRJNA756891_P_NODE_1226_length_730_cov_3.683409_g1163_i0 | PRJNA756891 | 1226 | 730 | 3.683409 | 26.8888857 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 122 | 1.53e-29 | NR | MFT4176339.1 | 1962973 | g1163 | i0 | 35.7 | 0.908219178082192 | 221 | 140 | 90.8 | 2 | 729 | 67 | 55 | 273 | MFT4176339.1 choice-of-anchor A family protein [Luteolibacter sp.] | diamond | 663 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 28474175 | 28474175 | PRJNA756891_P_NODE_2566_length_522_cov_1.028953_g2498_i0 | PRJNA756891 | 2566 | 522 | 1.028953 | 5.37113466 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 48.9 | 0.00318 | NR | HEY8903288.1 | 2201154 | g2498 | i0 | 22.3 | 1.00574712643678 | 175 | 133 | 98.9 | 2 | 2 | 517 | 152 | 326 | HEY8903288.1 tetratricopeptide repeat protein [Chthoniobacterales bacterium] | diamond | 525 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 28547327 | 28547327 | PRJNA756891_P_NODE_1387_length_689_cov_1.425325_g1323_i0 | PRJNA756891 | 1387 | 689 | 1.425325 | 9.82048925 | Bacteria | 2 | Bacteria | Bacteria | 263 | 1.28e-81 | NR | MDD3180849.1 | 2006848 | g1323 | i0 | 57.7 | 12.6792452830189 | 208 | 87 | 90.6 | 1 | 624 | 1 | 10 | 216 | MDD3180849.1 NAD-dependent malic enzyme [Opitutaceae bacterium] | diamond | 8736 | 263 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28758214 | 28758214 | PRJNA756891_P_NODE_12047_length_251_cov_1.123596_g11978_i0 | PRJNA756891 | 12047 | 251 | 1.123596 | 2.82022596 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 44.7 | 0.0085 | NR | PYJ55986.1 | 2026799 | g11978 | i0 | 41.9 | 1.48207171314741 | 62 | 31 | 72.9 | 2 | 217 | 35 | 55 | 112 | PYJ55986.1 MAG: hypothetical protein DME24_23605 [Verrucomicrobiota bacterium] | diamond | 372 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28758217 | 28758217 | PRJNA756891_P_NODE_14727_length_245_cov_0.895349_g14658_i0 | PRJNA756891 | 14727 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 136 | 7.33e-39 | NR | PYI68843.1 | 2026799 | g14658 | i0 | 83.8 | 3.86938775510204 | 80 | 13 | 98 | 0 | 242 | 3 | 35 | 114 | PYI68843.1 MAG: hypothetical protein DMF07_00800 [Verrucomicrobiota bacterium] | diamond | 948 | 136 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29042613 | 29042613 | PRJNA756891_P_NODE_388_length_1192_cov_1.808758_g353_i0 | PRJNA756891 | 388 | 1192 | 1.808758 | 21.56039536 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 194 | 1.0299999999999999e-54 | NR | HEV3410536.1 | 2201154 | g353 | i0 | 35.4 | 0.860738255033557 | 342 | 172 | 83.3 | 8 | 168 | 1160 | 21 | 324 | HEV3410536.1 fatty acid desaturase [Chthoniobacterales bacterium] | diamond | 1026 | 194 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29484225 | 29484225 | PRJNA756891_P_NODE_15730_length_243_cov_0.905882_g15661_i0 | PRJNA756891 | 15730 | 243 | 0.905882 | 2.20129326 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 62.4 | 4.45e-9 | NR | MBC9890093.1 | 2026771 | g15661 | i0 | 37 | 0.901234567901235 | 73 | 45 | 90.1 | 1 | 243 | 25 | 330 | 401 | MBC9890093.1 SIS domain-containing protein [Opitutia bacterium] | diamond | 219 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 29736840 | 29736840 | PRJNA756891_P_NODE_12210_length_251_cov_0.865169_g12141_i0 | PRJNA756891 | 12210 | 251 | 0.865169 | 2.17157419 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 145 | 3.79e-38 | NR | HEX7515928.1 | 2201154 | g12141 | i0 | 86.7 | 0.99203187250996006 | 83 | 11 | 99.2 | 0 | 2 | 250 | 378 | 460 | HEX7515928.1 O-antigen ligase family protein [Chthoniobacterales bacterium] | diamond | 249 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29831772 | 29831772 | PRJNA756891_P_NODE_16831_length_227_cov_2.512987_g16762_i0 | PRJNA756891 | 16831 | 227 | 2.512987 | 5.70448049 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 47 | 9.66e-4 | NR | RYD77759.1 | 2026800 | g16762 | i0 | 40.8 | 1.00440528634361 | 76 | 44 | 99.1 | 1 | 2 | 226 | 465 | 540 | RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium] | diamond | 228 | 47 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30147455 | 30147455 | PRJNA756891_P_NODE_15072_length_244_cov_0.900585_g15003_i0 | PRJNA756891 | 15072 | 244 | 0.900585 | 2.1974274 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 130 | 4.81e-33 | NR | MEP6777806.1 | 2201154 | g15003 | i0 | 92 | 3.68852459016393 | 75 | 6 | 92.2 | 0 | 236 | 12 | 192 | 266 | MEP6777806.1 translation initiation factor IF-2 [Chthoniobacterales bacterium] | diamond | 900 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 31674496 | 31674496 | PRJNA756891_P_NODE_4877_length_382_cov_1.993528_g4808_i0 | PRJNA756891 | 4877 | 382 | 1.993528 | 7.61527696 | Bacteria | 2 | Bacteria | Bacteria | 92.8 | 4.85e-19 | NR | HUS35346.1 | 2499141 | g4808 | i0 | 41.4 | 4.21727748691099 | 133 | 62 | 97.4 | 4 | 5 | 376 | 402 | 527 | HUS35346.1 glutamine--tRNA ligase/YqeY domain fusion protein [Verrucomicrobiia bacterium] | diamond | 1611 | 93.6 | 0.991452991452991 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31800964 | 31800964 | PRJNA756891_P_NODE_11837_length_253_cov_2.377778_g11768_i0 | PRJNA756891 | 11837 | 253 | 2.377778 | 6.01577834 | Candidatus Udaeobacter | 1921511 | Bacteria | Bacteria | 132 | 6.49e-34 | NR | PYK16690.1 | 2026799 | g11768 | i0 | 80.6 | 9.43873517786561 | 72 | 14 | 85.4 | 0 | 24 | 239 | 438 | 509 | PYK16690.1 MAG: hypothetical protein DME55_11710 [Verrucomicrobiota bacterium] | diamond | 2388 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31917855 | 31917855 | PRJNA756891_P_NODE_15937_length_242_cov_0.911243_g15868_i0 | PRJNA756891 | 15937 | 242 | 0.911243 | 2.20520806 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 99 | 6.02e-22 | NR | PYL00862.1 | 2026799 | g15868 | i0 | 61.5 | 3.34710743801653 | 65 | 25 | 80.6 | 0 | 29 | 223 | 291 | 355 | PYL00862.1 MAG: hypothetical protein DME19_03735 [Verrucomicrobiota bacterium] | diamond | 810 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31917857 | 31917857 | PRJNA756891_P_NODE_17_length_3125_cov_3.289974_g15_i0 | PRJNA756891 | 17 | 3125 | 3.289974 | 102.8116875 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 53.9 | 0.0066 | NR | WP_221306153.1 | 48466 | g15 | i0 | 23.3 | 0.28032 | 292 | 152 | 22.5 | 8 | 1685 | 984 | 7335 | 7612 | WP_221306153.1 beta strand repeat-containing protein [Prosthecobacter vanneervenii] | diamond | 876 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 32139396 | 32139396 | PRJNA756891_P_NODE_8578_length_296_cov_2.000000_g8509_i0 | PRJNA756891 | 8578 | 296 | 2 | 5.92 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 116 | 5.270000000000001e-29 | NR | PYI97833.1 | 2026799 | g8509 | i0 | 58.4 | 7.18581081081081 | 89 | 37 | 90.2 | 0 | 272 | 6 | 2 | 90 | PYI97833.1 MAG: NADPH:quinone reductase [Verrucomicrobiota bacterium] | diamond | 2127 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32551002 | 32551002 | PRJNA756891_P_NODE_79_length_1977_cov_3.434874_g69_i0 | PRJNA756891 | 79 | 1977 | 3.434874 | 67.90745898 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 63.9 | 1.26e-7 | NR | RYD41621.1 | 2026800 | g69 | i0 | 29.9 | 0.283763277693475 | 187 | 91 | 27.6 | 5 | 1320 | 1865 | 11 | 162 | RYD41621.1 MAG: ankyrin repeat domain-containing protein [Verrucomicrobiaceae bacterium] | diamond | 561 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32676511 | 32676511 | PRJNA756891_P_NODE_4240_length_408_cov_1.785075_g4171_i0 | PRJNA756891 | 4240 | 408 | 1.785075 | 7.283106 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 86.3 | 1.92e-17 | NR | PYJ14598.1 | 2026799 | g4171 | i0 | 61.4 | 0.419117647058824 | 57 | 21 | 41.9 | 1 | 172 | 2 | 43 | 98 | PYJ14598.1 MAG: DNA ligase, partial [Verrucomicrobiota bacterium] | diamond | 171 | 86.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32865569 | 32865569 | PRJNA756891_P_NODE_10180_length_274_cov_1.283582_g10111_i0 | PRJNA756891 | 10180 | 274 | 1.283582 | 3.51701468 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 71.2 | 5.25e-12 | NR | HYR21671.1 | 2201154 | g10111 | i0 | 46.6 | 1.5985401459854 | 73 | 35 | 79.9 | 1 | 258 | 40 | 204 | 272 | HYR21671.1 LamG domain-containing protein [Chthoniobacterales bacterium] | diamond | 438 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales 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);;