contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6686223 | 6686223 | PRJNA1159911_P_NODE_6946_length_1303_cov_8.297561_g6624_i0 | PRJNA1159911 | 6946 | 1303 | 8.297561 | 108.11721983 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 426 | 7.499999999999997e-145 | NR | RYD65414.1 | 2026800 | g6624 | i0 | 75.9 | 0.649270913277053 | 282 | 65 | 64.7 | 2 | 301 | 1143 | 56 | 335 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 846 | 426 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 7415915 | 7415915 | PRJNA1159911_P_NODE_7106_length_1286_cov_4.079143_g6778_i0 | PRJNA1159911 | 7106 | 1286 | 4.079143 | 52.45777898 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 434 | 5.579999999999998e-148 | NR | RYD65414.1 | 2026800 | g6778 | i0 | 76.3 | 0.660186625194401 | 283 | 65 | 66 | 1 | 1058 | 210 | 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 | ||
| 19434300 | 19434300 | PRJNA1159911_P_NODE_6736_length_1329_cov_4.105096_g6417_i0 | PRJNA1159911 | 6736 | 1329 | 4.105096 | 54.55672584 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 289 | 1.45e-90 | NR | RYD71398.1 | 2026800 | g6417 | i0 | 44.8 | 0.801354401805869 | 355 | 183 | 78.8 | 6 | 82 | 1128 | 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 | ||
| 27261744 | 27261744 | PRJNA1159911_P_NODE_93963_length_246_cov_0.890173_g93421_i0 | PRJNA1159911 | 93963 | 246 | 0.890173 | 2.18982558 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 51.6 | 2.8e-5 | NR | MFN2474974.1 | 2201154 | g93421 | i0 | 40 | 1.86585365853659 | 75 | 39 | 91.5 | 3 | 6 | 230 | 147 | 215 | MFN2474974.1 matrixin family metalloprotease [Chthoniobacterales bacterium] | diamond | 459 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27988027 | 27988027 | PRJNA1159911_P_NODE_62945_length_302_cov_0.886463_g62403_i0 | PRJNA1159911 | 62945 | 302 | 0.886463 | 2.67711826 | Limisphaerales bacterium | 2052186 | Bacteria | Bacteria | 149 | 2.9e-39 | NR | MEQ2007490.1 | 2052186 | g62403 | i0 | 67.7 | 0.983443708609272 | 99 | 31 | 98.3 | 1 | 298 | 2 | 1018 | 1115 | MEQ2007490.1 N-6 DNA methylase [Limisphaerales bacterium] | diamond | 297 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales bacterium | |||
| 28588047 | 28588047 | PRJNA1159911_P_NODE_33547_length_455_cov_1.722513_g33006_i0 | PRJNA1159911 | 33547 | 455 | 1.722513 | 7.83743415 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 130 | 4.96e-32 | NR | MBI5423982.1 | 2026771 | g33006 | i0 | 45.9 | 2.25494505494505 | 170 | 56 | 88.4 | 1 | 43 | 444 | 55 | 224 | MBI5423982.1 M13 family metallopeptidase [Opitutia bacterium] | diamond | 1026 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 28777203 | 28777203 | PRJNA1159911_P_NODE_25187_length_555_cov_1.549793_g24650_i0 | PRJNA1159911 | 25187 | 555 | 1.549793 | 8.60135115 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 285 | 3.82e-93 | NR | RYD81270.1 | 2026800 | g24650 | i0 | 69.2 | 1.98378378378378 | 182 | 56 | 98.4 | 0 | 555 | 10 | 148 | 329 | RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium] | diamond | 1101 | 285 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28840364 | 28840364 | PRJNA1159911_P_NODE_103008_length_233_cov_2.431250_g102466_i0 | PRJNA1159911 | 103008 | 233 | 2.43125 | 5.6648125 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 89.4 | 5.85e-19 | NR | RYD71398.1 | 2026800 | g102466 | i0 | 58.9 | 0.939914163090129 | 73 | 30 | 94 | 0 | 221 | 3 | 196 | 268 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 219 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28871941 | 28871941 | PRJNA1159911_P_NODE_86648_length_251_cov_1.724719_g86106_i0 | PRJNA1159911 | 86648 | 251 | 1.724719 | 4.32904469 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 153 | 6.459999999999998e-42 | NR | HEY3600888.1 | 2201154 | g86106 | i0 | 94 | 3.9681274900398402 | 83 | 5 | 99.2 | 0 | 251 | 3 | 101 | 183 | HEY3600888.1 Rne/Rng family ribonuclease [Chthoniobacterales bacterium] | diamond | 996 | 153 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 30154218 | 30154218 | PRJNA1159911_P_NODE_101492_length_241_cov_0.916667_g100950_i0 | PRJNA1159911 | 101492 | 241 | 0.916667 | 2.20916747 | PVC group | 1783257 | Bacteria | Bacteria | 124 | 1.31e-32 | NR | HUF40714.1 | 2499141 | g100950 | i0 | 78.2 | 5.850622406639 | 78 | 17 | 97.1 | 0 | 236 | 3 | 138 | 215 | HUF40714.1 homocysteine S-methyltransferase family protein [Verrucomicrobiia bacterium] | diamond | 1410 | 125 | 0.992 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30672183 | 30672183 | PRJNA1159911_P_NODE_80393_length_262_cov_1.407407_g79851_i0 | PRJNA1159911 | 80393 | 262 | 1.407407 | 3.68740634 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 161 | 1.6999999999999996e-47 | NR | MBI2814291.1 | 2026771 | g79851 | i0 | 96.5 | 0.984732824427481 | 86 | 3 | 98.5 | 0 | 3 | 260 | 100 | 185 | MBI2814291.1 flagellar hook basal-body protein [Opitutia bacterium] | diamond | 258 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 31083071 | 31083071 | PRJNA1159911_P_NODE_95215_length_245_cov_0.895349_g94673_i0 | PRJNA1159911 | 95215 | 245 | 0.895349 | 2.19360505 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 162 | 1.68e-45 | NR | HXD00327.1 | 2499141 | g94673 | i0 | 96.3 | 4.95918367346939 | 81 | 3 | 99.2 | 0 | 3 | 245 | 189 | 269 | HXD00327.1 NADH-quinone oxidoreductase subunit M [Verrucomicrobiia bacterium] | diamond | 1215 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31462680 | 31462680 | PRJNA1159911_P_NODE_52256_length_338_cov_1.562264_g51714_i0 | PRJNA1159911 | 52256 | 338 | 1.562264 | 5.28045232 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 75.5 | 1.54e-13 | NR | MCD8534895.1 | 2026799 | g51714 | i0 | 64.6 | 1.27810650887574 | 48 | 17 | 42.6 | 0 | 338 | 195 | 242 | 289 | MCD8534895.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 432 | 75.5 | 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);;