contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJEB36940" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988982 | 988982 | PRJEB36940_P_NODE_7041_length_325_cov_2.547619_g6912_i0 | PRJEB36940 | 7041 | 325 | 2.547619 | 8.27976175 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 76.6 | 8.59e-14 | NR | RYD71398.1 | 2026800 | g6912 | i0 | 37.5 | 0.96 | 104 | 64 | 96 | 1 | 13 | 324 | 26 | 128 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 312 | 76.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 8983872 | 8983872 | PRJEB36940_P_NODE_288_length_1349_cov_4.984326_g228_i0 | PRJEB36940 | 288 | 1349 | 4.984326 | 67.23855774 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 290 | 8.76e-91 | NR | RYD71398.1 | 2026800 | g228 | i0 | 45.1 | 0.789473684210526 | 355 | 182 | 77.6 | 6 | 1253 | 207 | 14 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 1065 | 290 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 26621740 | 26621740 | PRJEB36940_P_NODE_9101_length_288_cov_1.502326_g8972_i0 | PRJEB36940 | 9101 | 288 | 1.502326 | 4.32669888 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 75.9 | 7.5e-15 | NR | RYD79446.1 | 2026800 | g8972 | i0 | 57.1 | 0.729166666666667 | 70 | 30 | 72.9 | 0 | 211 | 2 | 3 | 72 | RYD79446.1 MAG: hypothetical protein EOP84_13030, partial [Verrucomicrobiaceae bacterium] | diamond | 210 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 26811821 | 26811821 | PRJEB36940_P_NODE_13441_length_249_cov_0.880682_g13312_i0 | PRJEB36940 | 13441 | 249 | 0.880682 | 2.19289818 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 86.7 | 1.3e-17 | NR | HEX7861274.1 | 2499141 | g13312 | i0 | 100 | 0.518072289156627 | 43 | 0 | 51.8 | 0 | 129 | 1 | 1 | 43 | HEX7861274.1 DUF1800 domain-containing protein [Verrucomicrobiia bacterium] | diamond | 129 | 86.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 26969903 | 26969903 | PRJEB36940_P_NODE_14742_length_245_cov_0.906977_g14613_i0 | PRJEB36940 | 14742 | 245 | 0.906977 | 2.22209365 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 100 | 7.080000000000001e-26 | NR | RYD81271.1 | 2026800 | g14613 | i0 | 66.2 | 0.906122448979592 | 74 | 20 | 84.5 | 2 | 208 | 2 | 5 | 78 | RYD81271.1 MAG: hypothetical protein EOP84_11270 [Verrucomicrobiaceae bacterium] | diamond | 222 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 29370237 | 29370237 | PRJEB36940_P_NODE_6169_length_346_cov_1.417582_g6040_i0 | PRJEB36940 | 6169 | 346 | 1.417582 | 4.90483372 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 65.1 | 1.86e-9 | NR | MBL9134505.1 | 2026801 | g6040 | i0 | 38.9 | 2.69653179190751 | 108 | 57 | 92.8 | 2 | 345 | 25 | 927 | 1026 | MBL9134505.1 S8 family serine peptidase [Verrucomicrobiales bacterium] | diamond | 933 | 65.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 29780592 | 29780592 | PRJEB36940_P_NODE_4211_length_416_cov_2.705539_g4082_i0 | PRJEB36940 | 4211 | 416 | 2.705539 | 11.25504224 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 223 | 9.67e-70 | NR | RYD81270.1 | 2026800 | g4082 | i0 | 73.9 | 0.995192307692308 | 138 | 36 | 99.5 | 0 | 415 | 2 | 169 | 306 | RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] | diamond | 414 | 223 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30096394 | 30096394 | PRJEB36940_P_NODE_2512_length_535_cov_2.731602_g2386_i0 | PRJEB36940 | 2512 | 535 | 2.731602 | 14.6140707 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 143 | 1.0199999999999998e-37 | NR | RYD71398.1 | 2026800 | g2386 | i0 | 54.9 | 0.745794392523364 | 133 | 59 | 74 | 1 | 501 | 106 | 229 | 361 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 399 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30570158 | 30570158 | PRJEB36940_P_NODE_12693_length_251_cov_0.876404_g12564_i0 | PRJEB36940 | 12693 | 251 | 0.876404 | 2.19977404 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 112 | 4.71e-29 | NR | MBA3883211.1 | 2201154 | g12564 | i0 | 82.5 | 0.752988047808765 | 63 | 11 | 75.3 | 0 | 2 | 190 | 126 | 188 | MBA3883211.1 RNA polymerase sigma factor [Chthoniobacterales bacterium] | diamond | 189 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 31803169 | 31803169 | PRJEB36940_P_NODE_2897_length_497_cov_1.205189_g2770_i0 | PRJEB36940 | 2897 | 497 | 1.205189 | 5.98978933 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 226 | 5.49e-69 | NR | RYD76251.1 | 2026800 | g2770 | i0 | 64.8 | 0.995975855130785 | 165 | 58 | 99.6 | 0 | 496 | 2 | 140 | 304 | RYD76251.1 MAG: hypothetical protein EOP84_17160, partial [Verrucomicrobiaceae bacterium] | diamond | 495 | 226 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32183104 | 32183104 | PRJEB36940_P_NODE_258_length_1400_cov_6.782216_g204_i0 | PRJEB36940 | 258 | 1400 | 6.782216 | 94.951024 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 440 | 8.18e-150 | NR | RYD65414.1 | 2026800 | g204 | i0 | 77 | 0.606428571428571 | 283 | 63 | 60.6 | 1 | 1067 | 219 | 56 | 336 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 849 | 440 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32877519 | 32877519 | PRJEB36940_P_NODE_3860_length_434_cov_2.997230_g3731_i0 | PRJEB36940 | 3860 | 434 | 2.99723 | 13.0079782 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 42.4 | 0.0385 | NR | MBV9671622.1 | 2026799 | g3731 | i0 | 37 | 0.317972350230415 | 46 | 29 | 31.8 | 0 | 261 | 398 | 8 | 53 | MBV9671622.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 138 | 42.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota 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);;