contig_metadata
28 rows where bioproject = "PRJNA1226487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 335041 | 335041 | PRJNA1226487_P_NODE_68021_length_248_cov_1.760000_g67919_i0 | PRJNA1226487 | 68021 | 248 | 1.76 | 4.3648 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 141 | 9.31e-37 | NR | WP_091057957.1 | 1882749 | g67919 | i0 | 86.3 | 1.93548387096774 | 80 | 10 | 96.8 | 1 | 240 | 1 | 114 | 192 | WP_091057957.1 glycosyltransferase [Opitutus sp. GAS368] | diamond | 480 | 141 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 6712784 | 6712784 | PRJNA1226487_P_NODE_68026_length_248_cov_1.760000_g67924_i0 | PRJNA1226487 | 68026 | 248 | 1.76 | 4.3648 | Opitutus terrae | 107709 | Bacteria | Bacteria | 174 | 4.59e-39 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g67924 | i0 | 80.995 | 45.8225806451613 | 221 | 40 | 89 | 2 | 7 | 226 | 2261607 | 2261388 | Opitutus terrae PB90-1, complete genome | blastn | 11364 | 174 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 7988389 | 7988389 | PRJNA1226487_P_NODE_54847_length_265_cov_1.604167_g54745_i0 | PRJNA1226487 | 54847 | 265 | 1.604167 | 4.25104255 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 337 | 5.97e-88 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g54745 | i0 | 89.734 | 1.98490566037736 | 263 | 27 | 99 | 0 | 1 | 263 | 3731113 | 3730851 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 526 | 337 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 9263116 | 9263116 | PRJNA1226487_P_NODE_75148_length_243_cov_1.811765_g75046_i0 | PRJNA1226487 | 75148 | 243 | 1.811765 | 4.40258895 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 140 | 6.78e-41 | NR | HVR68205.1 | 2499141 | g75046 | i0 | 74.4 | 4.83950617283951 | 78 | 20 | 96.3 | 0 | 8 | 241 | 6 | 83 | HVR68205.1 GFA family protein [Verrucomicrobiia bacterium] | diamond | 1176 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 14364005 | 14364005 | PRJNA1226487_P_NODE_57992_length_260_cov_1.647059_g57890_i0 | PRJNA1226487 | 57992 | 260 | 1.647059 | 4.2823534 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 348 | 2.7e-91 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g57890 | i0 | 90.769 | 23.5153846153846 | 260 | 24 | 100 | 0 | 1 | 260 | 4110017 | 4110276 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 6114 | 348 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 15637827 | 15637827 | PRJNA1226487_P_NODE_40393_length_288_cov_1.432558_g40291_i0 | PRJNA1226487 | 40393 | 288 | 1.432558 | 4.12576704 | Oleiharenicola lentus | 2508720 | Bacteria | Bacteria | 167 | 6.16e-50 | NR | WP_129045696.1 | 2508720 | g40291 | i0 | 87.5 | 1 | 96 | 12 | 100 | 0 | 1 | 288 | 80 | 175 | WP_129045696.1 response regulator [Oleiharenicola lentus] | diamond | 288 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola lentus | |
| 19461077 | 19461077 | PRJNA1226487_P_NODE_80816_length_231_cov_3.721519_g80714_i0 | PRJNA1226487 | 80816 | 231 | 3.721519 | 8.59670889 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 144 | 1.08e-38 | NR | TAK97310.1 | 2026799 | g80714 | i0 | 93.4 | 4.93506493506494 | 76 | 5 | 98.7 | 0 | 229 | 2 | 43 | 118 | TAK97310.1 MAG: MmgE/PrpD family protein [Verrucomicrobiota bacterium] | diamond | 1140 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 20736533 | 20736533 | PRJNA1226487_P_NODE_77957_length_241_cov_1.833333_g77855_i0 | PRJNA1226487 | 77957 | 241 | 1.833333 | 4.41833253 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 213 | 9.4e-51 | NTclustered | gi|2029343589|gb|CP073100.1| | 2824561 | g77855 | i0 | 82.573 | 4.87136929460581 | 241 | 42 | 100 | 0 | 1 | 241 | 348754 | 348514 | Luteolibacter ambystomatis strain 32A chromosome, complete genome | blastn | 1174 | 213 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 26946092 | 26946092 | PRJNA1226487_P_NODE_70682_length_246_cov_1.780347_g70580_i0 | PRJNA1226487 | 70682 | 246 | 1.780347 | 4.37965362 | Pedosphaera sp. Tous-C6FEB | 1982324 | Bacteria | Bacteria | 115 | 1.33e-27 | NR | PAW80850.1 | 1982324 | g70580 | i0 | 67.9 | 0.98780487804878 | 81 | 26 | 98.8 | 0 | 3 | 245 | 432 | 512 | PAW80850.1 MAG: phenylalanine--tRNA ligase subunit beta [Pedosphaera sp. Tous-C6FEB] | diamond | 243 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera sp. Tous-C6FEB | |
| 27009354 | 27009354 | PRJNA1226487_P_NODE_39062_length_290_cov_1.419355_g38960_i0 | PRJNA1226487 | 39062 | 290 | 1.419355 | 4.1161295 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 142 | 9.07e-37 | NR | MBK9989251.1 | 2026799 | g38960 | i0 | 65.6 | 6.87931034482759 | 96 | 33 | 99.3 | 0 | 289 | 2 | 985 | 1080 | MBK9989251.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 1995 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27293989 | 27293989 | PRJNA1226487_P_NODE_39063_length_290_cov_1.419355_g38961_i0 | PRJNA1226487 | 39063 | 290 | 1.419355 | 4.1161295 | Candidatus Didemnitutus sp. | 2814259 | Bacteria | Bacteria | 145 | 4.6e-39 | NR | HVU18795.1 | 2814259 | g38961 | i0 | 73.7 | 1.97586206896552 | 95 | 25 | 98.3 | 0 | 285 | 1 | 145 | 239 | HVU18795.1 PleD family two-component system response regulator [Candidatus Didemnitutus sp.] | diamond | 573 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Candidatus Didemnitutus | Candidatus Didemnitutus sp. | |
| 27515124 | 27515124 | PRJNA1226487_P_NODE_18643_length_368_cov_3.654237_g18541_i0 | PRJNA1226487 | 18643 | 368 | 3.654237 | 13.44759216 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 61.2 | 4.96e-8 | NR | RYD20361.1 | 2026800 | g18541 | i0 | 44.4 | 2.95923913043478 | 81 | 40 | 62.8 | 3 | 8 | 238 | 203 | 282 | RYD20361.1 MAG: phosphatidylinositol-specific phospholipase C domain-containing protein [Verrucomicrobiaceae bacterium] | diamond | 1089 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28620384 | 28620384 | PRJNA1226487_P_NODE_50307_length_272_cov_1.547739_g50205_i0 | PRJNA1226487 | 50307 | 272 | 1.547739 | 4.20985008 | Terrimicrobiaceae bacterium | 2832348 | Bacteria | Bacteria | 73.2 | 1.02e-12 | NR | HRJ72513.1 | 2832348 | g50205 | i0 | 81.3 | 0.529411764705882 | 48 | 9 | 52.9 | 0 | 145 | 2 | 2 | 49 | HRJ72513.1 BatA domain-containing protein [Terrimicrobiaceae bacterium] | diamond | 144 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobiaceae bacterium | ||
| 29314857 | 29314857 | PRJNA1226487_P_NODE_44589_length_281_cov_1.480769_g44487_i0 | PRJNA1226487 | 44589 | 281 | 1.480769 | 4.16096089 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 176 | 1.59e-53 | NR | HWA27332.1 | 1961806 | g44487 | i0 | 91.4 | 0.99288256227758 | 93 | 8 | 99.3 | 0 | 1 | 279 | 98 | 190 | HWA27332.1 SDR family oxidoreductase [Lacunisphaera sp.] | diamond | 279 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 29440835 | 29440835 | PRJNA1226487_P_NODE_58010_length_260_cov_1.647059_g57908_i0 | PRJNA1226487 | 58010 | 260 | 1.647059 | 4.2823534 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 152 | 4.109999999999999e-43 | NR | MEY4387465.1 | 2026799 | g57908 | i0 | 89.5 | 0.992307692307692 | 86 | 9 | 99.2 | 0 | 1 | 258 | 163 | 248 | MEY4387465.1 putative serine protease HhoB precursor [Verrucomicrobiota bacterium] | diamond | 258 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29472425 | 29472425 | PRJNA1226487_P_NODE_56670_length_262_cov_1.629630_g56568_i0 | PRJNA1226487 | 56670 | 262 | 1.62963 | 4.2696306 | Verrucomicrobiia bacterium DG1235 | 382464 | Bacteria | Bacteria | 100 | 1.36e-23 | NR | EDY85116.1 | 382464 | g56568 | i0 | 55.3 | 0.973282442748092 | 85 | 38 | 97.3 | 0 | 261 | 7 | 112 | 196 | EDY85116.1 hypothetical protein VDG1235_4751 [Verrucomicrobiia bacterium DG1235] | diamond | 255 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium DG1235 | ||||
| 29598740 | 29598740 | PRJNA1226487_P_NODE_66750_length_249_cov_1.750000_g66648_i0 | PRJNA1226487 | 66750 | 249 | 1.75 | 4.3575 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 142 | 8e-41 | NR | HEX2860835.1 | 1961806 | g66648 | i0 | 86.7 | 2 | 83 | 11 | 100 | 0 | 249 | 1 | 40 | 122 | HEX2860835.1 FliH/SctL family protein [Lacunisphaera sp.] | diamond | 498 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 29965187 | 29965187 | PRJNA1226487_P_NODE_59311_length_258_cov_1.664865_g59209_i0 | PRJNA1226487 | 59311 | 258 | 1.664865 | 4.2953517 | Bacteria | 2 | Bacteria | Bacteria | 138 | 5.32e-38 | NR | MCU0789421.1 | 2026799 | g59209 | i0 | 78.6 | 3.8953488372093 | 84 | 18 | 97.7 | 0 | 3 | 254 | 93 | 176 | MCU0789421.1 S8 family serine peptidase [Verrucomicrobiota bacterium] | diamond | 1005 | 138 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30104231 | 30104231 | PRJNA1226487_P_NODE_50232_length_272_cov_1.547739_g50130_i0 | PRJNA1226487 | 50232 | 272 | 1.547739 | 4.20985008 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 56.6 | 1.73e-7 | NR | RYD61954.1 | 2026800 | g50130 | i0 | 78.6 | 0.308823529411765 | 28 | 6 | 30.9 | 0 | 270 | 187 | 134 | 161 | RYD61954.1 MAG: hypothetical protein EOP83_15845 [Verrucomicrobiaceae bacterium] | diamond | 84 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30294319 | 30294319 | PRJNA1226487_P_NODE_47872_length_276_cov_1.517241_g47770_i0 | PRJNA1226487 | 47872 | 276 | 1.517241 | 4.18758516 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 162 | 4.45e-47 | NR | HEY0863433.1 | 1961806 | g47770 | i0 | 87.9 | 3.94565217391304 | 91 | 11 | 98.9 | 0 | 2 | 274 | 65 | 155 | HEY0863433.1 glycosyltransferase family 2 protein [Lacunisphaera sp.] | diamond | 1089 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 30452137 | 30452137 | PRJNA1226487_P_NODE_3353_length_638_cov_2.051327_g3262_i0 | PRJNA1226487 | 3353 | 638 | 2.051327 | 13.08746626 | Synoicihabitans lomoniglobus | 2909285 | Bacteria | Bacteria | 135 | 1.07e-33 | NR | WP_330930613.1 | 2909285 | g3262 | i0 | 40.1 | 4.38244514106583 | 182 | 79 | 83.2 | 2 | 572 | 42 | 260 | 416 | WP_330930613.1 bifunctional ornithine acetyltransferase/N-acetylglutamate synthase [Synoicihabitans lomoniglobus] | diamond | 2796 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Synoicihabitans | Synoicihabitans lomoniglobus | |
| 30831010 | 30831010 | PRJNA1226487_P_NODE_63434_length_252_cov_1.720670_g63332_i0 | PRJNA1226487 | 63434 | 252 | 1.72067 | 4.3360884 | Oleiharenicola lentus | 2508720 | Bacteria | Bacteria | 55.8 | 1.2e-7 | NR | MES1168318.1 | 2508720 | g63332 | i0 | 45.7 | 0.964285714285714 | 81 | 38 | 91.7 | 3 | 2 | 232 | 42 | 120 | MES1168318.1 hypothetical protein [Oleiharenicola lentus] | diamond | 243 | 55.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola lentus | |
| 30957598 | 30957598 | PRJNA1226487_P_NODE_39754_length_289_cov_1.425926_g39652_i0 | PRJNA1226487 | 39754 | 289 | 1.425926 | 4.12092614 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 58.2 | 1.45e-8 | NR | MFM9079835.1 | 2006848 | g39652 | i0 | 50.6 | 0.799307958477509 | 77 | 38 | 79.9 | 0 | 58 | 288 | 2 | 78 | MFM9079835.1 hypothetical protein [Opitutaceae bacterium] | diamond | 231 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 30957599 | 30957599 | PRJNA1226487_P_NODE_61934_length_254_cov_1.701657_g61832_i0 | PRJNA1226487 | 61934 | 254 | 1.701657 | 4.32220878 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 68.2 | 3.37e-11 | NR | MEK7707197.1 | 2026799 | g61832 | i0 | 49.3 | 1.67716535433071 | 71 | 32 | 83.9 | 1 | 42 | 254 | 1 | 67 | MEK7707197.1 peptidylprolyl isomerase [Verrucomicrobiota bacterium] | diamond | 426 | 68.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31209686 | 31209686 | PRJNA1226487_P_NODE_70775_length_246_cov_1.780347_g70673_i0 | PRJNA1226487 | 70775 | 246 | 1.780347 | 4.37965362 | Terrimicrobium sp. | 1965319 | Bacteria | Bacteria | 129 | 1.02e-34 | NR | HEY5769635.1 | 1965319 | g70673 | i0 | 72.5 | 0.975609756097561 | 80 | 22 | 97.6 | 0 | 244 | 5 | 97 | 176 | HEY5769635.1 formyltetrahydrofolate deformylase [Terrimicrobium sp.] | diamond | 240 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sp. | |
| 31431558 | 31431558 | PRJNA1226487_P_NODE_42096_length_285_cov_1.452830_g41994_i0 | PRJNA1226487 | 42096 | 285 | 1.45283 | 4.1405655 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 140 | 1.36e-39 | NR | MDI1249374.1 | 1961806 | g41994 | i0 | 83.9 | 0.91578947368421 | 87 | 14 | 91.6 | 0 | 284 | 24 | 142 | 228 | MDI1249374.1 hypothetical protein [Lacunisphaera sp.] | diamond | 261 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 31861380 | 31861380 | PRJNA1226487_P_NODE_56777_length_262_cov_1.629630_g56675_i0 | PRJNA1226487 | 56777 | 262 | 1.62963 | 4.2696306 | Opitutus | 178440 | Bacteria | Bacteria | 82 | 6.77e-16 | NR | WP_012376522.1 | 107709 | g56675 | i0 | 66.1 | 1.61450381679389 | 59 | 18 | 67.6 | 1 | 85 | 261 | 4 | 60 | WP_012376522.1 glycoside hydrolase 43 family protein [Opitutus terrae] | diamond | 423 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 32462825 | 32462825 | PRJNA1226487_P_NODE_73559_length_244_cov_1.801170_g73457_i0 | PRJNA1226487 | 73559 | 244 | 1.80117 | 4.3948548 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 63.5 | 1.77e-9 | NR | MFO1446905.1 | 2006848 | g73457 | i0 | 52.7 | 1.35245901639344 | 55 | 26 | 67.6 | 0 | 1 | 165 | 586 | 640 | MFO1446905.1 alpha/beta hydrolase [Opitutaceae bacterium] | diamond | 330 | 63.9 | 0.993740219092332 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae 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);;