contig_metadata
18 rows where bioproject = "PRJNA930380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18760954 | 18760954 | PRJNA930380_P_NODE_13435_length_244_cov_0.900585_g13382_i0 | PRJNA930380 | 13435 | 244 | 0.900585 | 2.1974274 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 187 | 5.7799999999999984e-43 | NTclustered | gi|2874254065|emb|OY970130.1| | 412056 | g13382 | i0 | 81.013 | 0.971311475409836 | 237 | 43 | 97 | 2 | 2 | 237 | 1776960 | 1777195 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1 | blastn | 237 | 187 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 26835204 | 26835204 | PRJNA930380_P_NODE_7781_length_283_cov_2.152381_g7728_i0 | PRJNA930380 | 7781 | 283 | 2.152381 | 6.09123823 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 69.3 | 5.78e-12 | NR | MEG2248925.1 | 1872421 | g7728 | i0 | 62.3 | 0.561837455830389 | 53 | 20 | 56.2 | 0 | 208 | 50 | 82 | 134 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 159 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27119494 | 27119494 | PRJNA930380_P_NODE_6182_length_290_cov_2.253456_g6129_i0 | PRJNA930380 | 6182 | 290 | 2.253456 | 6.5350224 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 72.8 | 2.95e-13 | NR | MEG2248925.1 | 1872421 | g6129 | i0 | 63.3 | 0.620689655172414 | 60 | 22 | 62.1 | 0 | 290 | 111 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 72.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 27688790 | 27688790 | PRJNA930380_P_NODE_6844_length_287_cov_3.593458_g6791_i0 | PRJNA930380 | 6844 | 287 | 3.593458 | 10.31322446 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 62.4 | 2.55e-9 | NR | MEG2248925.1 | 1872421 | g6791 | i0 | 64.6 | 0.501742160278746 | 48 | 17 | 50.2 | 0 | 267 | 124 | 153 | 200 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 144 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28162148 | 28162148 | PRJNA930380_P_NODE_9985_length_271_cov_1.267677_g9932_i0 | PRJNA930380 | 9985 | 271 | 1.267677 | 3.43540467 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 48.9 | 2.29e-4 | NR | MEG2248925.1 | 1872421 | g9932 | i0 | 53.7 | 0.453874538745387 | 41 | 19 | 45.4 | 0 | 149 | 271 | 1 | 41 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 123 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28351393 | 28351393 | PRJNA930380_P_NODE_6006_length_291_cov_1.958716_g5953_i0 | PRJNA930380 | 6006 | 291 | 1.958716 | 5.69986356 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 55.5 | 1.05e-6 | NR | MEG2248925.1 | 1872421 | g5953 | i0 | 52.9 | 0.525773195876289 | 51 | 24 | 52.6 | 0 | 290 | 138 | 143 | 193 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 153 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28572404 | 28572404 | PRJNA930380_P_NODE_9347_length_275_cov_1.396040_g9294_i0 | PRJNA930380 | 9347 | 275 | 1.39604 | 3.83911 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 46.6 | 0.00166 | NR | MEG2248925.1 | 1872421 | g9294 | i0 | 54.1 | 0.403636363636364 | 37 | 17 | 40.4 | 0 | 151 | 261 | 1 | 37 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 111 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29014794 | 29014794 | PRJNA930380_P_NODE_6568_length_289_cov_1.180556_g6515_i0 | PRJNA930380 | 6568 | 289 | 1.180556 | 3.41180684 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 79 | 1.28e-15 | NR | MEG2248925.1 | 1872421 | g6515 | i0 | 60.7 | 0.633217993079585 | 61 | 24 | 63.3 | 0 | 107 | 289 | 83 | 143 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 183 | 79 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29046155 | 29046155 | PRJNA930380_P_NODE_6608_length_288_cov_6.665116_g6555_i0 | PRJNA930380 | 6608 | 288 | 6.665116 | 19.19553408 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 175 | 1.7299999999999998e-54 | NR | MEG2248926.1 | 1872421 | g6555 | i0 | 94.7 | 0.979166666666667 | 94 | 5 | 97.9 | 0 | 5 | 286 | 28 | 121 | MEG2248926.1 hypothetical protein [Akkermansia sp.] | diamond | 282 | 175 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 29077772 | 29077772 | PRJNA930380_P_NODE_5388_length_294_cov_2.778281_g5335_i0 | PRJNA930380 | 5388 | 294 | 2.778281 | 8.16814614 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 77.4 | 5.19e-15 | NR | MEG2248925.1 | 1872421 | g5335 | i0 | 70 | 0.612244897959184 | 60 | 18 | 61.2 | 0 | 292 | 113 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 30025131 | 30025131 | PRJNA930380_P_NODE_6451_length_289_cov_1.962963_g6398_i0 | PRJNA930380 | 6451 | 289 | 1.962963 | 5.67296307 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 76.3 | 1.39e-14 | NR | MEG2248925.1 | 1872421 | g6398 | i0 | 68.5 | 0.560553633217993 | 54 | 17 | 56.1 | 0 | 288 | 127 | 143 | 196 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 162 | 76.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 30372900 | 30372900 | PRJNA930380_P_NODE_6172_length_290_cov_2.576037_g6119_i0 | PRJNA930380 | 6172 | 290 | 2.576037 | 7.4705073 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 74.3 | 7.6e-14 | NR | MEG2248925.1 | 1872421 | g6119 | i0 | 60 | 0.620689655172414 | 60 | 24 | 62.1 | 0 | 290 | 111 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 31257199 | 31257199 | PRJNA930380_P_NODE_5375_length_294_cov_3.850679_g5322_i0 | PRJNA930380 | 5375 | 294 | 3.850679 | 11.32099626 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 74.7 | 5.62e-14 | NR | MEG2248925.1 | 1872421 | g5322 | i0 | 66.7 | 0.612244897959184 | 60 | 20 | 61.2 | 0 | 3 | 182 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 74.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 31383875 | 31383875 | PRJNA930380_P_NODE_5156_length_296_cov_2.744395_g5103_i0 | PRJNA930380 | 5156 | 296 | 2.744395 | 8.1234092 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 82.8 | 4.54e-17 | NR | MEG2248925.1 | 1872421 | g5103 | i0 | 41.9 | 0.942567567567568 | 93 | 54 | 94.3 | 0 | 290 | 12 | 43 | 135 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 279 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32111361 | 32111361 | PRJNA930380_P_NODE_6018_length_291_cov_1.811927_g5965_i0 | PRJNA930380 | 6018 | 291 | 1.811927 | 5.27270757 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 72.4 | 4.15e-13 | NR | MEG2248925.1 | 1872421 | g5965 | i0 | 61.7 | 0.618556701030928 | 60 | 23 | 61.9 | 0 | 290 | 111 | 143 | 202 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 180 | 72.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32586033 | 32586033 | PRJNA930380_P_NODE_6179_length_290_cov_2.400922_g6126_i0 | PRJNA930380 | 6179 | 290 | 2.400922 | 6.9626738 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 63.5 | 9.68e-10 | NR | MEG2248925.1 | 1872421 | g6126 | i0 | 54.4 | 0.589655172413793 | 57 | 26 | 59 | 0 | 269 | 99 | 150 | 206 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 171 | 63.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32743400 | 32743400 | PRJNA930380_P_NODE_6420_length_289_cov_2.444444_g6367_i0 | PRJNA930380 | 6420 | 289 | 2.444444 | 7.06444316 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 73.2 | 2.11e-13 | NR | MEG2248925.1 | 1872421 | g6367 | i0 | 58.1 | 0.643598615916955 | 62 | 26 | 64.4 | 0 | 2 | 187 | 143 | 204 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 186 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 32837637 | 32837637 | PRJNA930380_P_NODE_5420_length_294_cov_2.090498_g5367_i0 | PRJNA930380 | 5420 | 294 | 2.090498 | 6.14606412 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 84 | 1.57e-17 | NR | MEG2248925.1 | 1872421 | g5367 | i0 | 51.1 | 0.897959183673469 | 88 | 43 | 89.8 | 0 | 6 | 269 | 43 | 130 | MEG2248925.1 hypothetical protein [Akkermansia sp.] | diamond | 264 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. |
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);;