contig_metadata
7 rows where bioproject = "PRJNA797655", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2060665 | 2060665 | PRJNA797655_S_NODE_206322_length_176_cov_1.203008_g205717_i0 | PRJNA797655 | 206322 | 176 | 1.203008 | 2.11729408 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 276 | 8.090000000000001e-70 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g205717 | i0 | 94.915 | 58.0681818181818 | 177 | 8 | 100 | 1 | 1 | 176 | 735870 | 736046 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 10220 | 276 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 3333008 | 3333008 | PRJNA797655_S_NODE_112663_length_234_cov_2.418848_g112058_i0 | PRJNA797655 | 112663 | 234 | 2.418848 | 5.66010432 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 399 | 6.499999999999999e-107 | NTclustered | gi|2874254019|emb|OY970344.1| | 412056 | g112058 | i0 | 97.447 | 96.0854700854701 | 235 | 5 | 100 | 1 | 1 | 234 | 737154 | 737388 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1 | blastn | 22484 | 399 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 27211753 | 27211753 | PRJNA797655_S_NODE_107962_length_238_cov_3.061538_g107357_i0 | PRJNA797655 | 107962 | 238 | 3.061538 | 7.28646044 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 43.1 | 0.0262 | NR | RYD65353.1 | 2026800 | g107357 | i0 | 30 | 0.882352941176471 | 70 | 40 | 76.9 | 1 | 41 | 223 | 101 | 170 | RYD65353.1 MAG: cobaltochelatase subunit CobN, partial [Verrucomicrobiaceae bacterium] | diamond | 210 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27843464 | 27843464 | PRJNA797655_S_NODE_79084_length_269_cov_1.699115_g78479_i0 | PRJNA797655 | 79084 | 269 | 1.699115 | 4.57061935 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.7 | 0.0478 | NR | MBN8249179.1 | 2026799 | g78479 | i0 | 54.3 | 0.390334572490706 | 35 | 16 | 39 | 0 | 147 | 251 | 73 | 107 | MBN8249179.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 105 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28696282 | 28696282 | PRJNA797655_S_NODE_174427_length_191_cov_3.445946_g173822_i0 | PRJNA797655 | 174427 | 191 | 3.445946 | 6.58175686 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 40.4 | 0.0479 | NR | MBS0661764.1 | 2026799 | g173822 | i0 | 43.5 | 0.722513089005236 | 46 | 26 | 72.3 | 0 | 182 | 45 | 35 | 80 | MBS0661764.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 138 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30527787 | 30527787 | PRJNA797655_S_NODE_202073_length_178_cov_1.066667_g201468_i0 | PRJNA797655 | 202073 | 178 | 1.066667 | 1.89866726 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 42.4 | 0.0217 | NR | MBL9176073.1 | 2026801 | g201468 | i0 | 48.8 | 0.691011235955056 | 41 | 19 | 69.1 | 1 | 159 | 37 | 217 | 255 | MBL9176073.1 acyltransferase family protein [Verrucomicrobiales bacterium] | diamond | 123 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 31823774 | 31823774 | PRJNA797655_S_NODE_178557_length_189_cov_2.301370_g177952_i0 | PRJNA797655 | 178557 | 189 | 2.30137 | 4.3495893 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 43.1 | 0.014 | NR | MBA3963233.1 | 2201154 | g177952 | i0 | 35.6 | 0.936507936507937 | 59 | 38 | 93.7 | 0 | 10 | 186 | 217 | 275 | MBA3963233.1 hypothetical protein [Chthoniobacterales bacterium] | diamond | 177 | 43.1 | 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);;