contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA864829" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5950555 | 5950555 | PRJNA864829_S_NODE_10905_length_192_cov_2.258741_g10819_i0 | PRJNA864829 | 10905 | 192 | 2.258741 | 4.33678272 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 100 | 2.2299999999999998e-23 | NR | MEO6750286.1 | 2811408 | g10819 | i0 | 79 | 1.953125 | 62 | 13 | 96.9 | 0 | 191 | 6 | 88 | 149 | MEO6750286.1 sugar ABC transporter ATP-binding protein [Chthoniobacteraceae bacterium] | diamond | 375 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 7225470 | 7225470 | PRJNA864829_S_NODE_2346_length_345_cov_2.239865_g2260_i0 | PRJNA864829 | 2346 | 345 | 2.239865 | 7.72753425 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 172 | 6.44e-49 | NR | NOS71559.1 | 2026799 | g2260 | i0 | 73.9 | 1 | 115 | 30 | 100 | 0 | 345 | 1 | 26 | 140 | NOS71559.1 PAS domain S-box protein [Verrucomicrobiota bacterium] | diamond | 345 | 172 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 8500170 | 8500170 | PRJNA864829_S_NODE_12327_length_182_cov_2.203008_g12241_i0 | PRJNA864829 | 12327 | 182 | 2.203008 | 4.00947456 | Bacteria | 2 | Bacteria | Bacteria | 74.3 | 2.5e-15 | NR | MEQ2008880.1 | 2052186 | g12241 | i0 | 90.9 | 1.08791208791209 | 33 | 3 | 54.4 | 0 | 83 | 181 | 1 | 33 | MEQ2008880.1 DUF6717 family protein [Limisphaerales bacterium] | diamond | 198 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales bacterium | |||
| 18698623 | 18698623 | PRJNA864829_S_NODE_3795_length_291_cov_3.268595_g3709_i0 | PRJNA864829 | 3795 | 291 | 3.268595 | 9.51161145 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 186 | 1.5299999999999996e-55 | NR | MBL9203415.1 | 2006848 | g3709 | i0 | 94.8 | 1 | 97 | 5 | 100 | 0 | 291 | 1 | 146 | 242 | MBL9203415.1 TonB-dependent receptor plug domain-containing protein [Opitutaceae bacterium] | diamond | 291 | 186 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 26801866 | 26801866 | PRJNA864829_S_NODE_7701_length_222_cov_3.739884_g7615_i0 | PRJNA864829 | 7701 | 222 | 3.739884 | 8.30254248 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 138 | 9.13e-40 | NR | MBP9903528.1 | 2026799 | g7615 | i0 | 89 | 0.986486486486487 | 73 | 8 | 98.6 | 0 | 220 | 2 | 14 | 86 | MBP9903528.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 219 | 138 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 26960038 | 26960038 | PRJNA864829_S_NODE_7602_length_224_cov_0.948571_g7516_i0 | PRJNA864829 | 7602 | 224 | 0.948571 | 2.12479904 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 110 | 2.76e-26 | NR | MEK7780601.1 | 2026799 | g7516 | i0 | 75.7 | 0.991071428571429 | 74 | 18 | 99.1 | 0 | 224 | 3 | 68 | 141 | MEK7780601.1 MiaB/RimO family radical SAM methylthiotransferase [Verrucomicrobiota bacterium] | diamond | 222 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27055223 | 27055223 | PRJNA864829_S_NODE_2482_length_338_cov_3.245675_g2396_i0 | PRJNA864829 | 2482 | 338 | 3.245675 | 10.9703815 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 167 | 1.15e-46 | NR | HZR21342.1 | 2499141 | g2396 | i0 | 75.5 | 0.976331360946746 | 110 | 27 | 97.6 | 0 | 336 | 7 | 65 | 174 | HZR21342.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 330 | 167 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27189560 | 27189560 | PRJNA864829_S_NODE_6242_length_243_cov_1.664948_g6156_i0 | PRJNA864829 | 6242 | 243 | 1.664948 | 4.04582364 | Bacteria | 2 | Bacteria | Bacteria | 144 | 9.91e-40 | NR | MCI0536045.1 | 2026801 | g6156 | i0 | 81.3 | 10.8641975308642 | 80 | 15 | 98.8 | 0 | 242 | 3 | 68 | 147 | MCI0536045.1 histidinol-phosphate transaminase [Verrucomicrobiales bacterium] | diamond | 2640 | 145 | 0.993103448275862 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27592392 | 27592392 | PRJNA864829_S_NODE_4744_length_270_cov_1.764706_g4658_i0 | PRJNA864829 | 4744 | 270 | 1.764706 | 4.7647062 | Limisphaerales bacterium | 2052186 | Bacteria | Bacteria | 95.9 | 1.3700000000000002e-21 | NR | MCI0747926.1 | 2052186 | g4658 | i0 | 61.6 | 1.62222222222222 | 73 | 28 | 81.1 | 0 | 52 | 270 | 2 | 74 | MCI0747926.1 TonB family protein [Limisphaerales bacterium] | diamond | 438 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales bacterium | |||
| 27655588 | 27655588 | PRJNA864829_S_NODE_8164_length_217_cov_1.547619_g8078_i0 | PRJNA864829 | 8164 | 217 | 1.547619 | 3.35833323 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 127 | 5.979999999999999e-32 | NR | MBL9198877.1 | 2006848 | g8078 | i0 | 93.1 | 1.99078341013825 | 72 | 5 | 99.5 | 0 | 2 | 217 | 373 | 444 | MBL9198877.1 TonB-dependent receptor [Opitutaceae bacterium] | diamond | 432 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28223543 | 28223543 | PRJNA864829_S_NODE_10186_length_198_cov_1.429530_g10100_i0 | PRJNA864829 | 10186 | 198 | 1.42953 | 2.8304694 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 104 | 3.03e-24 | NR | NOS69518.1 | 2026799 | g10100 | i0 | 91.2 | 0.863636363636364 | 57 | 5 | 86.4 | 0 | 27 | 197 | 191 | 247 | NOS69518.1 VWA domain-containing protein [Verrucomicrobiota bacterium] | diamond | 171 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28286639 | 28286639 | PRJNA864829_S_NODE_2546_length_336_cov_2.188153_g2460_i0 | PRJNA864829 | 2546 | 336 | 2.188153 | 7.35219408 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 190 | 2.44e-56 | NR | MBK8000775.1 | 2026799 | g2460 | i0 | 78.4 | 0.991071428571429 | 111 | 24 | 99.1 | 0 | 334 | 2 | 258 | 368 | MBK8000775.1 PQQ-binding-like beta-propeller repeat protein [Verrucomicrobiota bacterium] | diamond | 333 | 190 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28507930 | 28507930 | PRJNA864829_S_NODE_3467_length_301_cov_1.873016_g3381_i0 | PRJNA864829 | 3467 | 301 | 1.873016 | 5.63777816 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 107 | 1.6099999999999997e-24 | NR | TAL03652.1 | 2026799 | g3381 | i0 | 57.7 | 0.966777408637874 | 97 | 38 | 93.7 | 1 | 284 | 3 | 1 | 97 | TAL03652.1 MAG: hypothetical protein EPO07_05895 [Verrucomicrobiota bacterium] | diamond | 291 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28705557 | 28705557 | PRJNA864829_S_NODE_2887_length_321_cov_1.378676_g2801_i0 | PRJNA864829 | 2887 | 321 | 1.378676 | 4.42554996 | Bacteria | 2 | Bacteria | Bacteria | 127 | 4.009999999999999e-32 | NR | MBK8001322.1 | 2026799 | g2801 | i0 | 73.1 | 3.54205607476635 | 78 | 21 | 72.9 | 0 | 87 | 320 | 8 | 85 | MBK8001322.1 DUF3748 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 1137 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29076369 | 29076369 | PRJNA864829_S_NODE_7888_length_220_cov_1.690058_g7802_i0 | PRJNA864829 | 7888 | 220 | 1.690058 | 3.7181276 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 60.1 | 2.17e-8 | NR | MBL9194896.1 | 2006848 | g7802 | i0 | 48.1 | 3.19090909090909 | 79 | 34 | 98.2 | 1 | 5 | 220 | 791 | 869 | MBL9194896.1 ThuA domain-containing protein [Opitutaceae bacterium] | diamond | 702 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 29738973 | 29738973 | PRJNA864829_S_NODE_13790_length_173_cov_1.620968_g13704_i0 | PRJNA864829 | 13790 | 173 | 1.620968 | 2.80427464 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 100 | 4.8e-23 | NR | MBS0585179.1 | 2026799 | g13704 | i0 | 89.5 | 0.988439306358382 | 57 | 6 | 98.8 | 0 | 171 | 1 | 108 | 164 | MBS0585179.1 copper-translocating P-type ATPase [Verrucomicrobiota bacterium] | diamond | 171 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30212963 | 30212963 | PRJNA864829_S_NODE_2632_length_331_cov_2.946809_g2546_i0 | PRJNA864829 | 2632 | 331 | 2.946809 | 9.75393779 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 152 | 1.27e-41 | NR | MEN9677136.1 | 2026799 | g2546 | i0 | 71 | 1.93957703927492 | 107 | 31 | 97 | 0 | 3 | 323 | 334 | 440 | MEN9677136.1 FecR protein [Verrucomicrobiota bacterium] | diamond | 642 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30876598 | 30876598 | PRJNA864829_S_NODE_15794_length_165_cov_0.905172_g15708_i0 | PRJNA864829 | 15794 | 165 | 0.905172 | 1.4935338 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 60.8 | 5.18e-9 | NR | MBK7999079.1 | 2026799 | g15708 | i0 | 62 | 0.909090909090909 | 50 | 19 | 90.9 | 0 | 2 | 151 | 76 | 125 | MBK7999079.1 putative Ig domain-containing protein [Verrucomicrobiota bacterium] | diamond | 150 | 60.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30939954 | 30939954 | PRJNA864829_S_NODE_11334_length_189_cov_1.700000_g11248_i0 | PRJNA864829 | 11334 | 189 | 1.7 | 3.213 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 69.7 | 5.05e-12 | NR | HZR19871.1 | 2499141 | g11248 | i0 | 51.6 | 1.95238095238095 | 62 | 29 | 96.8 | 1 | 187 | 5 | 236 | 297 | HZR19871.1 peptidylprolyl isomerase [Verrucomicrobiia bacterium] | diamond | 369 | 69.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31034898 | 31034898 | PRJNA864829_S_NODE_1535_length_408_cov_2.646240_g1449_i0 | PRJNA864829 | 1535 | 408 | 2.64624 | 10.7966592 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 162 | 1.0899999999999999e-47 | NR | MBL9202377.1 | 2006848 | g1449 | i0 | 98.9 | 0.647058823529412 | 88 | 1 | 64.7 | 0 | 142 | 405 | 1 | 88 | MBL9202377.1 F0F1 ATP synthase subunit B [Opitutaceae bacterium] | diamond | 264 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31327142 | 31327142 | PRJNA864829_S_NODE_2035_length_364_cov_3.012698_g1949_i0 | PRJNA864829 | 2035 | 364 | 3.012698 | 10.96622072 | Candidatus Didemnitutus | 2055839 | Bacteria | Bacteria | 215 | 5.12e-68 | NR | MBP7947027.1 | 2026799 | g1949 | i0 | 86.7 | 1.97802197802198 | 120 | 16 | 98.9 | 0 | 362 | 3 | 50 | 169 | MBP7947027.1 restriction endonuclease subunit S [Verrucomicrobiota bacterium] | diamond | 720 | 215 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31603795 | 31603795 | PRJNA864829_S_NODE_15216_length_167_cov_1.347458_g15130_i0 | PRJNA864829 | 15216 | 167 | 1.347458 | 2.25025486 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 94.7 | 6.4400000000000006e-21 | NR | MEN9661763.1 | 2026799 | g15130 | i0 | 85.1 | 0.844311377245509 | 47 | 7 | 84.4 | 0 | 157 | 17 | 311 | 357 | MEN9661763.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 141 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32149757 | 32149757 | PRJNA864829_S_NODE_9438_length_204_cov_1.729032_g9352_i0 | PRJNA864829 | 9438 | 204 | 1.729032 | 3.52722528 | Bacteria | 2 | Bacteria | Bacteria | 114 | 8.44e-28 | NR | HXJ59758.1 | 2499141 | g9352 | i0 | 80.9 | 2 | 68 | 13 | 100 | 0 | 204 | 1 | 311 | 378 | HXJ59758.1 polynucleotide adenylyltransferase [Verrucomicrobiia bacterium] | diamond | 408 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32173391 | 32173391 | PRJNA864829_S_NODE_4638_length_272_cov_2.650224_g4552_i0 | PRJNA864829 | 4638 | 272 | 2.650224 | 7.20860928 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 90.9 | 6.44e-19 | NR | MEI7730580.1 | 2026799 | g4552 | i0 | 63.1 | 1.6875 | 65 | 24 | 71.7 | 0 | 250 | 56 | 1606 | 1670 | MEI7730580.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 459 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32204887 | 32204887 | PRJNA864829_S_NODE_7898_length_220_cov_1.298246_g7812_i0 | PRJNA864829 | 7898 | 220 | 1.298246 | 2.8561412 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 126 | 8.62e-32 | NR | MBL9167133.1 | 2026801 | g7812 | i0 | 86.1 | 0.981818181818182 | 72 | 10 | 98.2 | 0 | 220 | 5 | 254 | 325 | MBL9167133.1 carboxypeptidase regulatory-like domain-containing protein [Verrucomicrobiales bacterium] | diamond | 216 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 32331750 | 32331750 | PRJNA864829_S_NODE_1799_length_382_cov_3.033033_g1713_i0 | PRJNA864829 | 1799 | 382 | 3.033033 | 11.58618606 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 130 | 5.67e-36 | NR | MEK7780027.1 | 2026799 | g1713 | i0 | 96.8 | 0.486910994764398 | 62 | 2 | 48.7 | 0 | 2 | 187 | 84 | 145 | MEK7780027.1 exosortase system-associated protein, TIGR04073 family [Verrucomicrobiota bacterium] | diamond | 186 | 130 | 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);;