contig_metadata
10 rows where bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4246701 | 4246701 | PRJNA416866_P_NODE_264_length_1354_cov_6.601701_g205_i0 | PRJNA416866 | 264 | 1354 | 6.601701 | 89.38703154 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 289 | 1.86e-90 | NR | RYD71398.1 | 2026800 | g205 | i0 | 44.8 | 0.786558345642541 | 355 | 183 | 77.3 | 6 | 1261 | 215 | 14 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 1065 | 289 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 15111479 | 15111479 | PRJNA416866_P_NODE_252_length_1378_cov_6.574032_g196_i0 | PRJNA416866 | 252 | 1378 | 6.574032 | 90.59016096 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 434 | 1.6399999999999995e-147 | NR | RYD65414.1 | 2026800 | g196 | i0 | 76.3 | 0.61611030478955 | 283 | 65 | 61.6 | 1 | 318 | 1166 | 56 | 336 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 849 | 434 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 22760718 | 22760718 | PRJNA416866_P_NODE_3398_length_363_cov_1.576159_g3255_i0 | PRJNA416866 | 3398 | 363 | 1.576159 | 5.72145717 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 166 | 9.569999999999999e-48 | NR | WP_347441213.1 | 2109375 | g3255 | i0 | 67.2 | 12.3884297520661 | 119 | 39 | 98.3 | 0 | 361 | 5 | 169 | 287 | WP_347441213.1 NADPH-dependent aldehyde reductase Ahr [Rubritalea sp.] | diamond | 4497 | 167 | 0.994011976047904 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Rubritaleaceae | Rubritalea | Rubritalea sp. | |
| 26854338 | 26854338 | PRJNA416866_P_NODE_6701_length_251_cov_1.473684_g6557_i0 | PRJNA416866 | 6701 | 251 | 1.473684 | 3.69894684 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 94.7 | 2.06e-20 | NR | RYD77759.1 | 2026800 | g6557 | i0 | 60.2 | 0.99203187250996006 | 83 | 33 | 99.2 | 0 | 3 | 251 | 162 | 244 | RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium] | diamond | 249 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27170173 | 27170173 | PRJNA416866_P_NODE_4682_length_304_cov_1.950617_g4538_i0 | PRJNA416866 | 4682 | 304 | 1.950617 | 5.92987568 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 103 | 3.94e-24 | NR | RYD81270.1 | 2026800 | g4538 | i0 | 78.9 | 0.5625 | 57 | 12 | 56.3 | 0 | 132 | 302 | 179 | 235 | RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] | diamond | 171 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29254309 | 29254309 | PRJNA416866_P_NODE_5729_length_273_cov_1.547170_g5585_i0 | PRJNA416866 | 5729 | 273 | 1.54717 | 4.2237741 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 46.6 | 0.00123 | NR | MCX6904291.1 | 2026799 | g5585 | i0 | 44.1 | 0.648351648351648 | 59 | 33 | 64.8 | 0 | 94 | 270 | 53 | 111 | MCX6904291.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 177 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31655664 | 31655664 | PRJNA416866_P_NODE_9897_length_208_cov_0.870748_g9753_i0 | PRJNA416866 | 9897 | 208 | 0.870748 | 1.81115584 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 91.7 | 1.02e-20 | NR | MBN2068425.1 | 2026772 | g9753 | i0 | 62.1 | 0.951923076923077 | 66 | 25 | 95.2 | 0 | 5 | 202 | 131 | 196 | MBN2068425.1 hypothetical protein [Opitutales bacterium] | diamond | 198 | 91.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 31782188 | 31782188 | PRJNA416866_P_NODE_5717_length_273_cov_2.971698_g5573_i0 | PRJNA416866 | 5717 | 273 | 2.971698 | 8.11273554 | Akkermansia muciniphila | 239935 | Bacteria | Bacteria | 82 | 6.19e-18 | NR | WP_102713290.1 | 239935 | g5573 | i0 | 53.6 | 2.96703296703297 | 69 | 32 | 75.8 | 0 | 209 | 3 | 2 | 70 | WP_102713290.1 RNA recognition motif domain-containing protein [Akkermansia muciniphila] | diamond | 810 | 82 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia muciniphila | |
| 31877080 | 31877080 | PRJNA416866_P_NODE_11097_length_203_cov_1.802817_g10953_i0 | PRJNA416866 | 11097 | 203 | 1.802817 | 3.65971851 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 101 | 5.2599999999999997e-23 | NR | RYD77759.1 | 2026800 | g10953 | i0 | 77.6 | 0.990147783251232 | 67 | 15 | 99 | 0 | 1 | 201 | 478 | 544 | RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium] | diamond | 201 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32257301 | 32257301 | PRJNA416866_P_NODE_7058_length_244_cov_1.890710_g6914_i0 | PRJNA416866 | 7058 | 244 | 1.89071 | 4.6133324 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 146 | 5.07e-43 | NR | RYD73503.1 | 2026800 | g6914 | i0 | 84 | 1.99180327868852 | 81 | 13 | 99.6 | 0 | 243 | 1 | 1 | 81 | RYD73503.1 MAG: fructose-bisphosphate aldolase class I, partial [Verrucomicrobiaceae bacterium] | diamond | 486 | 146 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae 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);;