contig_metadata
23 rows where bioproject = "PRJEB83101", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3968324 | 3968324 | PRJEB83101_P_NODE_50924_length_274_cov_2.522388_g50619_i0 | PRJEB83101 | 50924 | 274 | 2.522388 | 6.91134312 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 198 | 3.0499999999999998e-46 | NTclustered | gi|2022020957|gb|CP059069.1| | 2562705 | g50619 | i0 | 82.051 | 2.56569343065693 | 234 | 40 | 85 | 2 | 41 | 273 | 3204414 | 3204646 | Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome | blastn | 703 | 198 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 6520204 | 6520204 | PRJEB83101_P_NODE_44906_length_285_cov_1.471698_g44601_i0 | PRJEB83101 | 44906 | 285 | 1.471698 | 4.1943393 | Terrimicrobiaceae bacterium | 2832348 | Bacteria | Bacteria | 114 | 3.55e-29 | NR | HRJ72192.1 | 2832348 | g44601 | i0 | 62.4 | 0.978947368421053 | 93 | 35 | 97.9 | 0 | 282 | 4 | 2 | 94 | HRJ72192.1 DNA alkylation repair protein [Terrimicrobiaceae bacterium] | diamond | 279 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobiaceae bacterium | ||
| 10345337 | 10345337 | PRJEB83101_P_NODE_58109_length_263_cov_1.305263_g57804_i0 | PRJEB83101 | 58109 | 263 | 1.305263 | 3.43284169 | Horticoccus luteus | 2862869 | Bacteria | Bacteria | 213 | 1.04e-50 | NTclustered | gi|2077391884|gb|CP080507.1| | 2862869 | g57804 | i0 | 81.369 | 100.752851711027 | 263 | 47 | 99 | 2 | 2 | 263 | 2127162 | 2126901 | Horticoccus luteus strain KSB-15 chromosome, complete genome | blastn | 26498 | 213 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Horticoccus | Horticoccus luteus | |
| 19268478 | 19268478 | PRJEB83101_P_NODE_82156_length_244_cov_0.912281_g81851_i0 | PRJEB83101 | 82156 | 244 | 0.912281 | 2.22596564 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 58.4 | 4.73e-4 | NTclustered | gi|2874254096|emb|OY970179.1| | 412056 | g81851 | i0 | 90.909 | 1.02049180327869 | 44 | 3 | 18 | 1 | 186 | 229 | 670107 | 670149 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1 | blastn | 249 | 58.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 23094673 | 23094673 | PRJEB83101_P_NODE_68679_length_251_cov_0.876404_g68374_i0 | PRJEB83101 | 68679 | 251 | 0.876404 | 2.19977404 | Luteolibacter sp. SL250 | 2995170 | Bacteria | Bacteria | 353 | 5.569999999999998e-93 | NTclustered | gi|2381117106|gb|CP113054.1| | 2995170 | g68374 | i0 | 92.032 | 1 | 251 | 20 | 100 | 0 | 1 | 251 | 2801644 | 2801394 | Luteolibacter sp. SL250 chromosome | blastn | 251 | 353 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 27603218 | 27603218 | PRJEB83101_P_NODE_83704_length_243_cov_0.917647_g83399_i0 | PRJEB83101 | 83704 | 243 | 0.917647 | 2.22988221 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 131 | 2.15e-37 | NR | MFO1488687.1 | 2026799 | g83399 | i0 | 80 | 5.92592592592593 | 80 | 15 | 98.8 | 1 | 242 | 3 | 33 | 111 | MFO1488687.1 DUF6573 family protein [Verrucomicrobiota bacterium] | diamond | 1440 | 131 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28455704 | 28455704 | PRJEB83101_P_NODE_70086_length_250_cov_1.480226_g69781_i0 | PRJEB83101 | 70086 | 250 | 1.480226 | 3.700565 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 155 | 6.7e-42 | NR | MEP6663575.1 | 2026799 | g69781 | i0 | 81.7 | 0.984 | 82 | 15 | 98.4 | 0 | 248 | 3 | 448 | 529 | MEP6663575.1 DEAD/DEAH box helicase [Verrucomicrobiota bacterium] | diamond | 246 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29181925 | 29181925 | PRJEB83101_P_NODE_86389_length_242_cov_0.923077_g86084_i0 | PRJEB83101 | 86389 | 242 | 0.923077 | 2.23384634 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 49.3 | 1.78e-4 | NR | HWZ94845.1 | 2006848 | g86084 | i0 | 43.2 | 0.545454545454545 | 44 | 25 | 54.5 | 0 | 133 | 2 | 220 | 263 | HWZ94845.1 2-succinyl-5-enolpyruvyl-6-hydroxy-3-cyclohexene-1-carboxylic-acid synthase [Opitutaceae bacterium] | diamond | 132 | 49.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 30128789 | 30128789 | PRJEB83101_P_NODE_77672_length_246_cov_1.560694_g77367_i0 | PRJEB83101 | 77672 | 246 | 1.560694 | 3.83930724 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 43.5 | 0.0106 | NR | MBP7948463.1 | 2026801 | g77367 | i0 | 45.7 | 1.34146341463415 | 46 | 25 | 56.1 | 0 | 45 | 182 | 97 | 142 | MBP7948463.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 330 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 30184875 | 30184875 | PRJEB83101_P_NODE_48492_length_279_cov_0.980583_g48187_i0 | PRJEB83101 | 48492 | 279 | 0.980583 | 2.73582657 | Bacteria | 2 | Bacteria | Bacteria | 116 | 4.57e-28 | NR | MCL4181614.1 | 2026799 | g48187 | i0 | 57.6 | 4.89247311827957 | 92 | 39 | 98.9 | 0 | 1 | 276 | 399 | 490 | MCL4181614.1 DUF4965 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 1365 | 116 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30413762 | 30413762 | PRJEB83101_P_NODE_65813_length_253_cov_0.866667_g65508_i0 | PRJEB83101 | 65813 | 253 | 0.866667 | 2.19266751 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 117 | 4.5999999999999996e-32 | NR | MBS0585245.1 | 2026799 | g65508 | i0 | 86.7 | 0.889328063241107 | 75 | 10 | 88.9 | 0 | 253 | 29 | 17 | 91 | MBS0585245.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 225 | 117 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30950790 | 30950790 | PRJEB83101_P_NODE_78674_length_246_cov_0.901734_g78369_i0 | PRJEB83101 | 78674 | 246 | 0.901734 | 2.21826564 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 140 | 1.19e-39 | NR | MEY4201227.1 | 2026799 | g78369 | i0 | 97.2 | 0.865853658536585 | 71 | 2 | 86.6 | 0 | 33 | 245 | 122 | 192 | MEY4201227.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 213 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31488284 | 31488284 | PRJEB83101_P_NODE_80356_length_245_cov_0.906977_g80051_i0 | PRJEB83101 | 80356 | 245 | 0.906977 | 2.22209365 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 69.3 | 1.01e-12 | NR | MDB6059734.1 | 2026801 | g80051 | i0 | 78.4 | 0.453061224489796 | 37 | 8 | 45.3 | 0 | 244 | 134 | 105 | 141 | MDB6059734.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 111 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 31519809 | 31519809 | PRJEB83101_P_NODE_57096_length_264_cov_2.198953_g56791_i0 | PRJEB83101 | 57096 | 264 | 2.198953 | 5.80523592 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 44.7 | 0.00984 | NR | MEY3479740.1 | 2026799 | g56791 | i0 | 34.8 | 0.784090909090909 | 69 | 42 | 75 | 1 | 46 | 243 | 5 | 73 | MEY3479740.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 207 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31740921 | 31740921 | PRJEB83101_P_NODE_44877_length_285_cov_1.471698_g44572_i0 | PRJEB83101 | 44877 | 285 | 1.471698 | 4.1943393 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 49.3 | 2.66e-4 | NR | HEV7401287.1 | 2811408 | g44572 | i0 | 81.5 | 0.284210526315789 | 27 | 5 | 28.4 | 0 | 204 | 284 | 1 | 27 | HEV7401287.1 acetylglutamate kinase [Chthoniobacteraceae bacterium] | diamond | 81 | 49.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 31930763 | 31930763 | PRJEB83101_P_NODE_68717_length_251_cov_0.876404_g68412_i0 | PRJEB83101 | 68717 | 251 | 0.876404 | 2.19977404 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 79.3 | 1.05e-15 | NR | MDB6059034.1 | 2026801 | g68412 | i0 | 77.4 | 0.633466135458167 | 53 | 12 | 63.3 | 0 | 8 | 166 | 96 | 148 | MDB6059034.1 putative rane protein [Verrucomicrobiales bacterium] | diamond | 159 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 31962470 | 31962470 | PRJEB83101_P_NODE_80378_length_245_cov_0.906977_g80073_i0 | PRJEB83101 | 80378 | 245 | 0.906977 | 2.22209365 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 93.6 | 3.850000000000001e-21 | NR | HVJ47147.1 | 1962973 | g80073 | i0 | 65.4 | 0.991836734693878 | 81 | 23 | 94.3 | 3 | 5 | 235 | 166 | 245 | HVJ47147.1 hypothetical protein [Luteolibacter sp.] | diamond | 243 | 93.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 32373985 | 32373985 | PRJEB83101_P_NODE_61699_length_257_cov_2.135870_g61394_i0 | PRJEB83101 | 61699 | 257 | 2.13587 | 5.4891859 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 52.8 | 1.3e-5 | NR | MFH1476185.1 | 2026799 | g61394 | i0 | 68.6 | 0.852140077821012 | 35 | 11 | 40.9 | 0 | 107 | 3 | 5 | 39 | MFH1476185.1 NAD(+) synthase [Verrucomicrobiota bacterium] | diamond | 219 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32398251 | 32398251 | PRJEB83101_P_NODE_61919_length_257_cov_1.597826_g61614_i0 | PRJEB83101 | 61919 | 257 | 1.597826 | 4.10641282 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 61.6 | 6.3e-9 | NR | HAV65483.1 | 2026801 | g61614 | i0 | 45.6 | 3.65369649805447 | 68 | 36 | 79.4 | 1 | 49 | 252 | 117 | 183 | HAV65483.1 prephenate dehydrogenase/arogenate dehydrogenase family protein [Verrucomicrobiales bacterium] | diamond | 939 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 32405566 | 32405566 | PRJEB83101_P_NODE_40659_length_293_cov_2.468182_g40354_i0 | PRJEB83101 | 40659 | 293 | 2.468182 | 7.23177326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42 | 0.0303 | NR | MED5278845.1 | 2026799 | g40354 | i0 | 34.6 | 0.532423208191126 | 52 | 34 | 53.2 | 0 | 61 | 216 | 37 | 88 | MED5278845.1 sugar phosphate isomerase/epimerase [Verrucomicrobiota bacterium] | diamond | 156 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32437388 | 32437388 | PRJEB83101_P_NODE_54959_length_268_cov_1.261538_g54654_i0 | PRJEB83101 | 54959 | 268 | 1.261538 | 3.38092184 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 108 | 9.72e-26 | NR | MFO1501623.1 | 2026799 | g54654 | i0 | 79.4 | 0.761194029850746 | 68 | 14 | 76.1 | 0 | 266 | 63 | 325 | 392 | MFO1501623.1 MFS transporter [Verrucomicrobiota bacterium] | diamond | 204 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32469011 | 32469011 | PRJEB83101_P_NODE_89039_length_233_cov_2.393750_g88734_i0 | PRJEB83101 | 89039 | 233 | 2.39375 | 5.5774375 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 47.8 | 5.47e-4 | NR | MEI7954406.1 | 2026799 | g88734 | i0 | 51.3 | 0.502145922746781 | 39 | 19 | 50.2 | 0 | 173 | 57 | 405 | 443 | MEI7954406.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 117 | 47.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32689529 | 32689529 | PRJEB83101_P_NODE_69160_length_251_cov_0.876404_g68855_i0 | PRJEB83101 | 69160 | 251 | 0.876404 | 2.19977404 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 99 | 1.36e-23 | NR | MCX6883943.1 | 2026799 | g68855 | i0 | 74.2 | 5.12749003984064 | 62 | 16 | 74.1 | 0 | 2 | 187 | 144 | 205 | MCX6883943.1 phosphoribosylanthranilate isomerase [Verrucomicrobiota bacterium] | diamond | 1287 | 99 | 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);;