contig_metadata
13 rows where bioproject = "PRJNA561212", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6923628 | 6923628 | PRJNA561212_P_NODE_9766_length_353_cov_1.125000_g9555_i0 | PRJNA561212 | 9766 | 353 | 1.125 | 3.97125 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 344 | 4.92e-90 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g9555 | i0 | 85.671 | 75.371104815864 | 328 | 45 | 93 | 2 | 18 | 344 | 3832605 | 3832279 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 26606 | 344 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 8198302 | 8198302 | PRJNA561212_P_NODE_21207_length_251_cov_0.876404_g20996_i0 | PRJNA561212 | 21207 | 251 | 0.876404 | 2.19977404 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 359 | 1.2e-94 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g20996 | i0 | 94.421 | 140.247011952191 | 233 | 13 | 93 | 0 | 12 | 244 | 3863253 | 3863485 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 35202 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 15848122 | 15848122 | PRJNA561212_P_NODE_12753_length_312_cov_1.230126_g12542_i0 | PRJNA561212 | 12753 | 312 | 1.230126 | 3.83799312 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 359 | 1.5299999999999998e-94 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g12542 | i0 | 88.667 | 26.1185897435897 | 300 | 27 | 95 | 6 | 10 | 304 | 1316380 | 1316677 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 8149 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 16433400 | 16433400 | PRJNA561212_P_NODE_8373_length_379_cov_1.986928_g8162_i0 | PRJNA561212 | 8373 | 379 | 1.986928 | 7.53045712 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 111 | 1.13e-26 | NR | HXJ60019.1 | 2499141 | g8162 | i0 | 65.2 | 6.35620052770449 | 89 | 30 | 70.4 | 1 | 12 | 278 | 231 | 318 | HXJ60019.1 transaldolase [Verrucomicrobiia bacterium] | diamond | 2409 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 20947746 | 20947746 | PRJNA561212_P_NODE_9997_length_349_cov_1.094203_g9786_i0 | PRJNA561212 | 9997 | 349 | 1.094203 | 3.81876847 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 536 | 7.459999999999997e-148 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g9786 | i0 | 95.015 | 257.819484240688 | 341 | 17 | 98 | 0 | 9 | 349 | 1315691 | 1316031 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 89979 | 536 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 22222538 | 22222538 | PRJNA561212_P_NODE_3778_length_568_cov_2.135354_g3571_i0 | PRJNA561212 | 3778 | 568 | 2.135354 | 12.12881072 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 678 | 0 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g3571 | i0 | 88.969 | 217.588028169014 | 553 | 56 | 97 | 3 | 9 | 560 | 1314951 | 1315499 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 123590 | 678 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 27141927 | 27141927 | PRJNA561212_P_NODE_16222_length_281_cov_1.043269_g16011_i0 | PRJNA561212 | 16222 | 281 | 1.043269 | 2.93158589 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 51.6 | 4.26e-5 | NR | MBV9490222.1 | 2026799 | g16011 | i0 | 50 | 2.11387900355872 | 42 | 21 | 44.8 | 0 | 274 | 149 | 4 | 45 | MBV9490222.1 WD40 repeat domain-containing protein [Verrucomicrobiota bacterium] | diamond | 594 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28089717 | 28089717 | PRJNA561212_P_NODE_17365_length_272_cov_2.783920_g17154_i0 | PRJNA561212 | 17365 | 272 | 2.78392 | 7.5722624 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 43.5 | 0.0287 | NR | HOB97342.1 | 2026799 | g17154 | i0 | 30.9 | 0.893382352941177 | 81 | 56 | 89.3 | 0 | 254 | 12 | 187 | 267 | HOB97342.1 glycoside hydrolase family 127 protein [Verrucomicrobiota bacterium] | diamond | 243 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29226719 | 29226719 | PRJNA561212_P_NODE_9269_length_362_cov_0.809689_g9058_i0 | PRJNA561212 | 9269 | 362 | 0.809689 | 2.93107418 | Puniceicoccaceae bacterium K14 | 2922731 | Bacteria | Bacteria | 125 | 9.52e-31 | NR | MCH6258034.1 | 2922731 | g9058 | i0 | 59.8 | 0.969613259668508 | 117 | 38 | 97 | 2 | 362 | 12 | 390 | 497 | MCH6258034.1 allophanate hydrolase [Puniceicoccaceae bacterium K14] | diamond | 351 | 125 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccaceae | Puniceicoccaceae bacterium K14 | ||
| 31564725 | 31564725 | PRJNA561212_P_NODE_7636_length_397_cov_1.407407_g7425_i0 | PRJNA561212 | 7636 | 397 | 1.407407 | 5.58740579 | Candidatus Methylacidiphilales bacterium | 2720631 | Bacteria | Bacteria | 100 | 5.319999999999999e-23 | NR | MCE0499624.1 | 2720631 | g7425 | i0 | 51.5 | 0.778337531486146 | 103 | 32 | 77.8 | 2 | 312 | 4 | 45 | 129 | MCE0499624.1 superoxide dismutase [Candidatus Methylacidiphilales bacterium] | diamond | 309 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Candidatus Methylacidiphilales bacterium | |||
| 31659161 | 31659161 | PRJNA561212_P_NODE_20377_length_253_cov_0.866667_g20166_i0 | PRJNA561212 | 20377 | 253 | 0.866667 | 2.19266751 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 76.6 | 4.82e-14 | NR | MBS0645922.1 | 2026799 | g20166 | i0 | 50.7 | 2.66798418972332 | 75 | 36 | 87.7 | 1 | 233 | 12 | 846 | 920 | MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 675 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31785682 | 31785682 | PRJNA561212_P_NODE_22837_length_248_cov_0.891429_g22626_i0 | PRJNA561212 | 22837 | 248 | 0.891429 | 2.21074392 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 73.6 | 5.21e-13 | NR | MBO34746.1 | 2026801 | g22626 | i0 | 69.6 | 0.556451612903226 | 46 | 14 | 55.6 | 0 | 237 | 100 | 394 | 439 | MBO34746.1 3-deoxy-7-phosphoheptulonate synthase class II [Verrucomicrobiales bacterium] | diamond | 138 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 32306339 | 32306339 | PRJNA561212_P_NODE_23299_length_247_cov_0.896552_g23088_i0 | PRJNA561212 | 23299 | 247 | 0.896552 | 2.21448344 | Bacteria | 2 | Bacteria | Bacteria | 58.2 | 1.42e-7 | NR | MFU8848897.1 | 2026772 | g23088 | i0 | 45.8 | 4.91902834008097 | 72 | 36 | 87.4 | 1 | 218 | 3 | 666 | 734 | MFU8848897.1 DEAD/DEAH box helicase [Opitutales bacterium] | diamond | 1215 | 58.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales 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);;