contig_metadata
20 rows where bioproject = "PRJNA572587", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3109908 | 3109908 | PRJNA572587_P_NODE_3423_length_707_cov_2.784195_g3147_i0 | PRJNA572587 | 3423 | 707 | 2.784195 | 19.68425865 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 147 | 2.65e-36 | NR | HEY8933051.1 | 2706526 | g3147 | i0 | 53.9 | 1.28995756718529 | 152 | 65 | 62.8 | 3 | 699 | 256 | 586 | 736 | HEY8933051.1 AAA family ATPase [Rariglobus sp.] | diamond | 912 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 5662364 | 5662364 | PRJNA572587_P_NODE_10205_length_371_cov_30.354037_g9878_i0 | PRJNA572587 | 10205 | 371 | 30.354037 | 112.61347727 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 414 | 3.91e-111 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g9878 | i0 | 90.252 | 99.7870619946092 | 318 | 29 | 85 | 2 | 3 | 319 | 1316737 | 1316421 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 37021 | 414 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 8211617 | 8211617 | PRJNA572587_P_NODE_10007_length_376_cov_2.113150_g9680_i0 | PRJNA572587 | 10007 | 376 | 2.11315 | 7.945444 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 278 | 5.4300000000000006e-70 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g9680 | i0 | 86.853 | 64.9601063829787 | 251 | 29 | 66 | 4 | 127 | 376 | 3863933 | 3863686 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 24425 | 278 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 8211744 | 8211744 | PRJNA572587_P_NODE_1647_length_992_cov_12.179215_g1491_i0 | PRJNA572587 | 1647 | 992 | 12.179215 | 120.8178128 | Cerasicoccus maritimus | 490089 | Bacteria | Bacteria | 58.9 | 1.01e-5 | NR | WP_309398316.1 | 490089 | g1491 | i0 | 28.8 | 0.925403225806452 | 146 | 93 | 42.3 | 4 | 536 | 955 | 30 | 170 | WP_309398316.1 hypothetical protein [Cerasicoccus maritimus] | diamond | 918 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Cerasicoccaceae | Cerasicoccus | Cerasicoccus maritimus | |
| 8212173 | 8212173 | PRJNA572587_P_NODE_5347_length_544_cov_286.056566_g5027_i0 | PRJNA572587 | 5347 | 544 | 286.056566 | 1556.14771904 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 667 | 0 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g5027 | i0 | 90.173 | 94.8841911764706 | 519 | 41 | 94 | 10 | 1 | 514 | 3833087 | 3833600 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 51617 | 667 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 10763473 | 10763473 | PRJNA572587_P_NODE_6109_length_501_cov_5.110619_g5788_i0 | PRJNA572587 | 6109 | 501 | 5.110619 | 25.60420119 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 145 | 1.5499999999999996e-40 | NR | MBI4625648.1 | 2026799 | g5788 | i0 | 88 | 0.497005988023952 | 83 | 10 | 49.7 | 0 | 9 | 257 | 48 | 130 | MBI4625648.1 DJ-1/PfpI family protein [Verrucomicrobiota bacterium] | diamond | 249 | 145 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 14588016 | 14588016 | PRJNA572587_P_NODE_8892_length_403_cov_78.319209_g8565_i0 | PRJNA572587 | 8892 | 403 | 78.319209 | 315.62641227 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 340 | 7.36e-89 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g8565 | i0 | 87.097 | 56.6774193548387 | 310 | 29 | 74 | 5 | 82 | 380 | 3832143 | 3832452 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 22841 | 340 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 15861359 | 15861359 | PRJNA572587_P_NODE_16613_length_280_cov_267.956710_g16285_i0 | PRJNA572587 | 16613 | 280 | 267.95671 | 750.278788 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 294 | 3.88e-75 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g16285 | i0 | 89.7 | 108.939285714286 | 233 | 20 | 82 | 4 | 21 | 250 | 3833369 | 3833600 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 30503 | 294 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 17136300 | 17136300 | PRJNA572587_P_NODE_12654_length_327_cov_23.694245_g12326_i0 | PRJNA572587 | 12654 | 327 | 23.694245 | 77.48018115 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 411 | 4.4e-110 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g12326 | i0 | 91.118 | 233.590214067278 | 304 | 25 | 93 | 2 | 22 | 325 | 768 | 1069 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 76384 | 411 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 26858384 | 26858384 | PRJNA572587_P_NODE_8501_length_414_cov_76.786301_g8175_i0 | PRJNA572587 | 8501 | 414 | 76.786301 | 317.89528614 | Puniceicoccales bacterium | 2478473 | Bacteria | Bacteria | 42.4 | 0.0288 | NR | MDR0742450.1 | 2478473 | g8175 | i0 | 34.9 | 0.456521739130435 | 63 | 35 | 41.3 | 2 | 172 | 2 | 2 | 64 | MDR0742450.1 hypothetical protein [Puniceicoccales bacterium] | diamond | 189 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccales bacterium | |||
| 28942993 | 28942993 | PRJNA572587_P_NODE_10008_length_376_cov_1.694190_g9681_i0 | PRJNA572587 | 10008 | 376 | 1.69419 | 6.3701544 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 217 | 1.1999999999999998e-67 | NR | MBX9577730.1 | 2201154 | g9681 | i0 | 89 | 0.941489361702128 | 118 | 13 | 94.1 | 0 | 374 | 21 | 117 | 234 | MBX9577730.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Chthoniobacterales bacterium] | diamond | 354 | 217 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29384850 | 29384850 | PRJNA572587_P_NODE_19009_length_261_cov_1.509434_g18681_i0 | PRJNA572587 | 19009 | 261 | 1.509434 | 3.93962274 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 82.4 | 1.57e-17 | NR | NJR42023.1 | 2562705 | g18681 | i0 | 41.3 | 2.14942528735632 | 104 | 36 | 90.8 | 2 | 241 | 5 | 21 | 124 | NJR42023.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 561 | 82.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 29636956 | 29636956 | PRJNA572587_P_NODE_26590_length_217_cov_2.410714_g26262_i0 | PRJNA572587 | 26590 | 217 | 2.410714 | 5.23124938 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 48.5 | 2.33e-4 | NR | MEQ1747904.1 | 1965333 | g26262 | i0 | 70.3 | 0.511520737327189 | 37 | 11 | 51.2 | 0 | 79 | 189 | 7 | 43 | MEQ1747904.1 thiamine pyrophosphate-dependent enzyme [Prosthecobacter sp.] | diamond | 111 | 48.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30111072 | 30111072 | PRJNA572587_P_NODE_30352_length_201_cov_32.013158_g30024_i0 | PRJNA572587 | 30352 | 201 | 32.013158 | 64.34644758 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 104 | 1.12e-26 | NR | MBS0628409.1 | 2026799 | g30024 | i0 | 80 | 0.895522388059702 | 60 | 12 | 89.6 | 0 | 3 | 182 | 30 | 89 | MBS0628409.1 disulfide bond formation protein B [Verrucomicrobiota bacterium] | diamond | 180 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30901075 | 30901075 | PRJNA572587_P_NODE_33974_length_190_cov_1.042553_g33646_i0 | PRJNA572587 | 33974 | 190 | 1.042553 | 1.9808507 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 51.6 | 5.26e-6 | NR | NJR42023.1 | 2562705 | g33646 | i0 | 52.5 | 0.631578947368421 | 40 | 19 | 63.2 | 0 | 187 | 68 | 124 | 163 | NJR42023.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 120 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 31121776 | 31121776 | PRJNA572587_P_NODE_30735_length_200_cov_11.158940_g30407_i0 | PRJNA572587 | 30735 | 200 | 11.15894 | 22.31788 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 117 | 5.3e-29 | NR | MCX7713884.1 | 2201154 | g30407 | i0 | 100 | 0.84 | 56 | 0 | 84 | 0 | 3 | 170 | 95 | 150 | MCX7713884.1 hypothetical protein [Chthoniobacterales bacterium] | diamond | 168 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 31375213 | 31375213 | PRJNA572587_P_NODE_3076_length_746_cov_37.383070_g2818_i0 | PRJNA572587 | 3076 | 746 | 37.38307 | 278.8777022 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 63.9 | 2.66e-9 | NR | NJR41398.1 | 2562705 | g2818 | i0 | 66 | 0.189008042895442 | 47 | 15 | 18.5 | 1 | 408 | 545 | 32 | 78 | NJR41398.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 141 | 63.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 31976016 | 31976016 | PRJNA572587_P_NODE_2158_length_881_cov_33.518029_g1965_i0 | PRJNA572587 | 2158 | 881 | 33.518029 | 295.29383549 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 47.4 | 0.0133 | NR | PWU09965.1 | 2026799 | g1965 | i0 | 32 | 1.0522133938706 | 103 | 67 | 34.7 | 2 | 785 | 480 | 49 | 149 | PWU09965.1 MAG: 30S ribosomal protein S7 [Verrucomicrobiota bacterium] | diamond | 927 | 47.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32514278 | 32514278 | PRJNA572587_P_NODE_11579_length_344_cov_43.698305_g11252_i0 | PRJNA572587 | 11579 | 344 | 43.698305 | 150.3221692 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 94 | 3.04e-20 | NR | HYG83408.1 | 2499141 | g11252 | i0 | 48.1 | 0.706395348837209 | 81 | 42 | 70.6 | 0 | 33 | 275 | 139 | 219 | HYG83408.1 Kiwa anti-phage protein KwaB-like domain-containing protein [Verrucomicrobiia bacterium] | diamond | 243 | 94 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32716726 | 32716726 | PRJNA572587_P_NODE_22120_length_240_cov_6.821990_g21792_i0 | PRJNA572587 | 22120 | 240 | 6.8219900000000004 | 16.372776000000002 | Bacteria | 2 | Bacteria | Bacteria | 85.9 | 2.16e-18 | NR | MCD6049068.1 | 2026799 | g21792 | i0 | 84.4 | 1.275 | 45 | 7 | 56.3 | 0 | 83 | 217 | 186 | 230 | MCD6049068.1 Hydroxypyruvate isomerase [Verrucomicrobiota bacterium] | diamond | 306 | 86.7 | 0.990772779700115 | 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);;