contig_metadata
18 rows where bioproject = "PRJNA1120060", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12504849 | 12504849 | PRJNA1120060_P_NODE_2218610_length_264_cov_2.256545_g2200557_i0 | PRJNA1120060 | 2218610 | 264 | 2.256545 | 5.9572788 | Bacteria | 2 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2126063867|gb|CP085689.1| | 2886196 | g2200557 | i0 | 100 | 0.212121212121212 | 28 | 0 | 11 | 0 | 98 | 125 | 2265989 | 2265962 | Lentisphaerae bacterium WC36 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium WC36 | |||||
| 20659012 | 20659012 | PRJNA1120060_P_NODE_2974877_length_242_cov_0.923077_g2956783_i0 | PRJNA1120060 | 2974877 | 242 | 0.923077 | 2.23384634 | Lentisphaera profundi | 1658616 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2445967839|gb|CP117812.1| | 1658616 | g2956783 | i0 | 100 | 0.119834710743802 | 29 | 0 | 12 | 0 | 198 | 226 | 424716 | 424744 | Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence | blastn | 29 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaerales | Lentisphaeraceae | Lentisphaera | Lentisphaera profundi | |
| 26679148 | 26679148 | PRJNA1120060_P_NODE_2446581_length_256_cov_1.032787_g2428512_i0 | PRJNA1120060 | 2446581 | 256 | 1.032787 | 2.64393472 | Victivallis | 172900 | Bacteria | Bacteria | 129 | 5.59e-34 | NR | MFA4945509.1 | 2053569 | g2428512 | i0 | 65.5 | 2.90625 | 84 | 29 | 98.4 | 0 | 256 | 5 | 53 | 136 | MFA4945509.1 branched-chain amino acid aminotransferase [Lentisphaeria bacterium] | diamond | 744 | 130 | 0.992307692307692 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 27384972 | 27384972 | PRJNA1120060_P_NODE_205343_length_465_cov_2.563776_g188837_i0 | PRJNA1120060 | 205343 | 465 | 2.563776 | 11.9215584 | Lentisphaerae bacterium RIFOXYA12_FULL_48_11 | 1798578 | Bacteria | Bacteria | 42.7 | 0.0343 | NR | OGV64345.1 | 1798578 | g188837 | i0 | 39.3 | 0.361290322580645 | 56 | 34 | 36.1 | 0 | 417 | 250 | 13 | 68 | OGV64345.1 MAG: hypothetical protein A2283_24110 [Lentisphaerae bacterium RIFOXYA12_FULL_48_11] | diamond | 168 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerae bacterium RIFOXYA12_FULL_48_11 | |||||
| 27764197 | 27764197 | PRJNA1120060_P_NODE_2442984_length_256_cov_1.409836_g2424915_i0 | PRJNA1120060 | 2442984 | 256 | 1.409836 | 3.60918016 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 42.7 | 0.0445 | NR | NLB65384.1 | 1932692 | g2424915 | i0 | 33 | 1.03125 | 88 | 37 | 82 | 4 | 38 | 247 | 269 | 352 | NLB65384.1 hypothetical protein [Lentisphaerota bacterium] | diamond | 264 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 28173852 | 28173852 | PRJNA1120060_P_NODE_1826126_length_280_cov_1.043478_g1808112_i0 | PRJNA1120060 | 1826126 | 280 | 1.043478 | 2.9217384 | Lentisphaera profundi | 1658616 | Bacteria | Bacteria | 41.2 | 0.0397 | NR | WDE96618.1 | 1658616 | g1808112 | i0 | 36 | 0.535714285714286 | 50 | 31 | 53.6 | 1 | 227 | 78 | 36 | 84 | WDE96618.1 hypothetical protein PQO03_01375 [Lentisphaera profundi] | diamond | 150 | 41.2 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaerales | Lentisphaeraceae | Lentisphaera | Lentisphaera profundi | |
| 28680495 | 28680495 | PRJNA1120060_P_NODE_3613507_length_198_cov_4.200000_g3595379_i0 | PRJNA1120060 | 3613507 | 198 | 4.2 | 8.316 | Lentisphaera profundi | 1658616 | Bacteria | Bacteria | 42 | 0.0387 | NR | WP_274150939.1 | 1658616 | g3595379 | i0 | 31.7 | 0.954545454545455 | 63 | 42 | 95.5 | 1 | 1 | 189 | 210 | 271 | WP_274150939.1 serine hydrolase [Lentisphaera profundi] | diamond | 189 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaerales | Lentisphaeraceae | Lentisphaera | Lentisphaera profundi | |
| 29059263 | 29059263 | PRJNA1120060_P_NODE_3442528_length_212_cov_4.604317_g3424403_i0 | PRJNA1120060 | 3442528 | 212 | 4.604317 | 9.76115204 | Lentisphaerota bacterium | 1932692 | Bacteria | Bacteria | 42 | 0.0465 | NR | NLB69628.1 | 1932692 | g3424403 | i0 | 36.6 | 0.580188679245283 | 41 | 26 | 58 | 0 | 212 | 90 | 269 | 309 | NLB69628.1 formylglycine-generating enzyme family protein [Lentisphaerota bacterium] | diamond | 123 | 42 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaerota bacterium | |||||
| 29531740 | 29531740 | PRJNA1120060_P_NODE_1782430_length_281_cov_4.014423_g1764418_i0 | PRJNA1120060 | 1782430 | 281 | 4.014423 | 11.28052863 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 43.5 | 0.0308 | NR | MBR4664273.1 | 2053569 | g1764418 | i0 | 27.5 | 0.97153024911032 | 91 | 62 | 95 | 3 | 279 | 13 | 61 | 149 | MBR4664273.1 carbohydrate-binding protein [Lentisphaeria bacterium] | diamond | 273 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29626509 | 29626509 | PRJNA1120060_P_NODE_2562350_length_252_cov_1.268156_g2544275_i0 | PRJNA1120060 | 2562350 | 252 | 1.268156 | 3.19575312 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 43.5 | 0.0222 | NR | MBO7327534.1 | 2053569 | g2544275 | i0 | 25.8 | 0.785714285714286 | 66 | 49 | 78.6 | 0 | 218 | 21 | 181 | 246 | MBO7327534.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 198 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 29626936 | 29626936 | PRJNA1120060_P_NODE_3256670_length_229_cov_2.243590_g3238563_i0 | PRJNA1120060 | 3256670 | 229 | 2.24359 | 5.1378211 | Victivallis vadensis | 172901 | Bacteria | Bacteria | 42.4 | 0.0413 | NR | WP_302453179.1 | 172901 | g3238563 | i0 | 40.4 | 0.681222707423581 | 52 | 29 | 68.1 | 1 | 50 | 205 | 18 | 67 | WP_302453179.1 hypothetical protein [Victivallis vadensis] | diamond | 156 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallaceae | Victivallis | Victivallis vadensis | |
| 30038056 | 30038056 | PRJNA1120060_P_NODE_3346311_length_222_cov_4.248322_g3328197_i0 | PRJNA1120060 | 3346311 | 222 | 4.248322 | 9.43127484 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 42.7 | 0.0279 | NR | MBR4662836.1 | 2053569 | g3328197 | i0 | 42.9 | 0.567567567567568 | 42 | 23 | 56.8 | 1 | 33 | 158 | 175 | 215 | MBR4662836.1 DUF2339 domain-containing protein [Lentisphaeria bacterium] | diamond | 126 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 31079976 | 31079976 | PRJNA1120060_P_NODE_2071075_length_270_cov_1.360406_g2053038_i0 | PRJNA1120060 | 2071075 | 270 | 1.360406 | 3.6730962 | Lentisphaeraceae bacterium | 2461380 | Bacteria | Bacteria | 45.1 | 0.00702 | NR | MCM8537095.1 | 2461380 | g2053038 | i0 | 31 | 0.933333333333333 | 84 | 49 | 84.4 | 3 | 32 | 259 | 52 | 134 | MCM8537095.1 glutamate--tRNA ligase family protein [Lentisphaeraceae bacterium] | diamond | 252 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaerales | Lentisphaeraceae | Lentisphaeraceae bacterium | ||
| 31554707 | 31554707 | PRJNA1120060_P_NODE_2608676_length_251_cov_0.865169_g2590599_i0 | PRJNA1120060 | 2608676 | 251 | 0.865169 | 2.17157419 | Victivallis lenta | 2606640 | Bacteria | Bacteria | 44.7 | 0.00854 | NR | WP_154416726.1 | 2606640 | g2590599 | i0 | 38.9 | 0.645418326693227 | 54 | 33 | 64.5 | 0 | 21 | 182 | 282 | 335 | WP_154416726.1 S1 family peptidase [Victivallis lenta] | diamond | 162 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Victivallales | Victivallaceae | Victivallis | Victivallis lenta | |
| 31870256 | 31870256 | PRJNA1120060_P_NODE_1895717_length_277_cov_1.382353_g1877698_i0 | PRJNA1120060 | 1895717 | 277 | 1.382353 | 3.82911781 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 43.5 | 0.0294 | NR | MBQ6598830.1 | 2053569 | g1877698 | i0 | 46.9 | 0.346570397111913 | 32 | 17 | 34.7 | 0 | 90 | 185 | 226 | 257 | MBQ6598830.1 hypothetical protein [Lentisphaeria bacterium] | diamond | 96 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 32408843 | 32408843 | PRJNA1120060_P_NODE_2729079_length_248_cov_0.880000_g2710996_i0 | PRJNA1120060 | 2729079 | 248 | 0.88 | 2.1824 | Lentisphaeria bacterium | 2053569 | Bacteria | Bacteria | 44.7 | 0.00839 | NR | MBP5181936.1 | 2053569 | g2710996 | i0 | 50 | 0.338709677419355 | 28 | 14 | 33.9 | 0 | 92 | 9 | 330 | 357 | MBP5181936.1 endopeptidase La [Lentisphaeria bacterium] | diamond | 84 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaeria bacterium | ||||
| 32629090 | 32629090 | PRJNA1120060_P_NODE_1750420_length_283_cov_1.314286_g1732412_i0 | PRJNA1120060 | 1750420 | 283 | 1.314286 | 3.71942938 | Lentisphaerales bacterium | 2448604 | Bacteria | Bacteria | 43.5 | 0.0312 | NR | TFH16640.1 | 2448604 | g1732412 | i0 | 38.9 | 0.763250883392226 | 72 | 41 | 73.1 | 1 | 14 | 220 | 305 | 376 | TFH16640.1 MAG: MiaB/RimO family radical SAM methylthiotransferase [Lentisphaerales bacterium] | diamond | 216 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Lentisphaeria | Lentisphaerales | Lentisphaerales bacterium | |||
| 32714450 | 32714450 | PRJNA1120060_P_NODE_3394780_length_216_cov_12.902098_g3376660_i0 | PRJNA1120060 | 3394780 | 216 | 12.902098 | 27.86853168 | Lentisphaerota | 256845 | Bacteria | Bacteria | 42.7 | 0.0265 | NR | WP_307262527.1 | 760260 | g3376660 | i0 | 38.2 | 1.52777777777778 | 55 | 34 | 76.4 | 0 | 205 | 41 | 917 | 971 | WP_307262527.1 serine/threonine protein kinase [Oligosphaera ethanolica] | diamond | 330 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Lentisphaerota | Oligosphaeria | Oligosphaerales | Oligosphaeraceae | Oligosphaera | Oligosphaera ethanolica |
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);;