contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA474426" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27012929 | 27012929 | PRJNA474426_P_NODE_36142_length_162_cov_2.725664_g35937_i0 | PRJNA474426 | 36142 | 162 | 2.725664 | 4.41557568 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 73.2 | 2.26e-13 | NR | MBL9137825.1 | 2026801 | g35937 | i0 | 66 | 3.7037037037037 | 50 | 16 | 90.7 | 1 | 148 | 2 | 668 | 717 | MBL9137825.1 PAS domain S-box protein [Verrucomicrobiales bacterium] | diamond | 600 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27455668 | 27455668 | PRJNA474426_P_NODE_35803_length_163_cov_0.903509_g35598_i0 | PRJNA474426 | 35803 | 163 | 0.903509 | 1.47271967 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 54.3 | 1.02e-6 | NR | MBI5767949.1 | 2026799 | g35598 | i0 | 58 | 0.920245398773006 | 50 | 21 | 92 | 0 | 12 | 161 | 1241 | 1290 | MBI5767949.1 PAS domain S-box protein [Verrucomicrobiota bacterium] | diamond | 150 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27487065 | 27487065 | PRJNA474426_P_NODE_27403_length_185_cov_1.507353_g27198_i0 | PRJNA474426 | 27403 | 185 | 1.507353 | 2.78860305 | Terrimicrobium sacchariphilum | 690879 | Bacteria | Bacteria | 103 | 2.0199999999999998e-24 | NR | WP_075079064.1 | 690879 | g27198 | i0 | 100 | 0.778378378378378 | 48 | 0 | 77.8 | 0 | 160 | 17 | 61 | 108 | WP_075079064.1 sulfite exporter TauE/SafE family protein [Terrimicrobium sacchariphilum] | diamond | 144 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sacchariphilum | |
| 28150258 | 28150258 | PRJNA474426_P_NODE_11485_length_314_cov_1.056604_g11280_i0 | PRJNA474426 | 11485 | 314 | 1.056604 | 3.31773656 | Terrimicrobium sacchariphilum | 690879 | Bacteria | Bacteria | 176 | 1.55e-53 | NR | WP_075081201.1 | 690879 | g11280 | i0 | 91 | 1.70063694267516 | 89 | 8 | 85 | 0 | 267 | 1 | 1 | 89 | WP_075081201.1 rhomboid family intramembrane serine protease [Terrimicrobium sacchariphilum] | diamond | 534 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sacchariphilum | |
| 28276273 | 28276273 | PRJNA474426_P_NODE_7786_length_387_cov_1.724852_g7582_i0 | PRJNA474426 | 7786 | 387 | 1.724852 | 6.67517724 | Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_1 | 1802433 | Bacteria | Bacteria | 124 | 2.29e-31 | NR | OHE79004.1 | 1802433 | g7582 | i0 | 49.2 | 0.914728682170543 | 118 | 60 | 91.5 | 0 | 12 | 365 | 218 | 335 | OHE79004.1 MAG: hypothetical protein A3F67_10845, partial [Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_10] | diamond | 354 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_10 | |||||
| 28687135 | 28687135 | PRJNA474426_P_NODE_2167_length_668_cov_3.046850_g2018_i0 | PRJNA474426 | 2167 | 668 | 3.04685 | 20.352958 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 49.3 | 0.00717 | NR | MEI7774771.1 | 2026799 | g2018 | i0 | 54.2 | 0.215568862275449 | 48 | 18 | 21.6 | 2 | 342 | 199 | 784 | 827 | MEI7774771.1 reverse transcriptase domain-containing protein [Verrucomicrobiota bacterium] | diamond | 144 | 49.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29003060 | 29003060 | PRJNA474426_P_NODE_21528_length_214_cov_1.345455_g21323_i0 | PRJNA474426 | 21528 | 214 | 1.345455 | 2.8792737 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 111 | 1.44e-26 | NR | MEZ0218311.1 | 2706526 | g21323 | i0 | 75 | 0.953271028037383 | 68 | 17 | 95.3 | 0 | 1 | 204 | 401 | 468 | MEZ0218311.1 cation:proton antiporter [Rariglobus sp.] | diamond | 204 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 29050424 | 29050424 | PRJNA474426_P_NODE_8348_length_374_cov_1.350769_g8143_i0 | PRJNA474426 | 8348 | 374 | 1.350769 | 5.05187606 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 139 | 2.21e-36 | NR | WP_078812920.1 | 48467 | g8143 | i0 | 86.8 | 7.25935828877005 | 76 | 10 | 61 | 0 | 373 | 146 | 53 | 128 | WP_078812920.1 cytochrome ubiquinol oxidase subunit I [Prosthecobacter debontii] | diamond | 2715 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter debontii | |
| 29113537 | 29113537 | PRJNA474426_P_NODE_12688_length_295_cov_7.922764_g12483_i0 | PRJNA474426 | 12688 | 295 | 7.922764 | 23.3721538 | Chthoniobacter | 295577 | Bacteria | Bacteria | 145 | 3.74e-39 | NR | WP_202797352.1 | 191863 | g12483 | i0 | 81.6 | 3.51864406779661 | 87 | 16 | 88.5 | 0 | 17 | 277 | 71 | 157 | WP_202797352.1 (Fe-S)-binding protein [Chthoniobacter flavus] | diamond | 1038 | 146 | 0.993150684931507 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 29633691 | 29633691 | PRJNA474426_P_NODE_33930_length_165_cov_1.758621_g33725_i0 | PRJNA474426 | 33930 | 165 | 1.758621 | 2.90172465 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 61.2 | 3.8e-9 | NR | HEY0550975.1 | 2499141 | g33725 | i0 | 61.7 | 1.74545454545455 | 47 | 18 | 85.5 | 0 | 160 | 20 | 1035 | 1081 | HEY0550975.1 immunoglobulin domain-containing protein [Verrucomicrobiia bacterium] | diamond | 288 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29807968 | 29807968 | PRJNA474426_P_NODE_28191_length_182_cov_1.398496_g27986_i0 | PRJNA474426 | 28191 | 182 | 1.398496 | 2.54526272 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 123 | 5.12e-33 | NR | MBI3852043.1 | 2026799 | g27986 | i0 | 98.3 | 1.91208791208791 | 58 | 1 | 95.6 | 0 | 182 | 9 | 73 | 130 | MBI3852043.1 AAA family ATPase [Verrucomicrobiota bacterium] | diamond | 348 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29949924 | 29949924 | PRJNA474426_P_NODE_13311_length_287_cov_2.466387_g13106_i0 | PRJNA474426 | 13311 | 287 | 2.466387 | 7.07853069 | Puniceicoccaceae bacterium | 2026784 | Bacteria | Bacteria | 135 | 1.6199999999999998e-35 | NR | MAV39023.1 | 2026784 | g13106 | i0 | 88.9 | 1.5052264808362401 | 72 | 8 | 75.3 | 0 | 20 | 235 | 272 | 343 | MAV39023.1 phage portal protein [Puniceicoccaceae bacterium] | diamond | 432 | 135 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccaceae | Puniceicoccaceae bacterium | ||
| 29949930 | 29949930 | PRJNA474426_P_NODE_33871_length_165_cov_2.439655_g33666_i0 | PRJNA474426 | 33871 | 165 | 2.439655 | 4.02543075 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 40.4 | 0.0445 | NR | MDA1277473.1 | 2026799 | g33666 | i0 | 71.4 | 0.509090909090909 | 28 | 8 | 50.9 | 0 | 92 | 9 | 1 | 28 | MDA1277473.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 84 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30361095 | 30361095 | PRJNA474426_P_NODE_36192_length_162_cov_1.814159_g35987_i0 | PRJNA474426 | 36192 | 162 | 1.814159 | 2.93893758 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 96.3 | 6.96e-23 | NR | MEX1049632.1 | 2562705 | g35987 | i0 | 88.7 | 0.981481481481482 | 53 | 6 | 98.1 | 0 | 2 | 160 | 84 | 136 | MEX1049632.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 159 | 96.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 30487095 | 30487095 | PRJNA474426_P_NODE_8013_length_381_cov_14.277108_g7808_i0 | PRJNA474426 | 8013 | 381 | 14.277108 | 54.39578148 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 108 | 3.5300000000000003e-26 | NR | MCB1242637.1 | 2499141 | g7808 | i0 | 57.9 | 0.748031496062992 | 95 | 40 | 74.8 | 0 | 97 | 381 | 10 | 104 | MCB1242637.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 285 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30661069 | 30661069 | PRJNA474426_P_NODE_36713_length_162_cov_0.902655_g36508_i0 | PRJNA474426 | 36713 | 162 | 0.902655 | 1.4623011 | Bacteria | 2 | Bacteria | Bacteria | 73.6 | 1.64e-13 | NR | MCU0784392.1 | 2026799 | g36508 | i0 | 97.3 | 35.6296296296296 | 37 | 1 | 68.5 | 0 | 3 | 113 | 534 | 570 | MCU0784392.1 Flp pilus assembly complex ATPase component TadA [Verrucomicrobiota bacterium] | diamond | 5772 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30961042 | 30961042 | PRJNA474426_P_NODE_25754_length_192_cov_1.062937_g25549_i0 | PRJNA474426 | 25754 | 192 | 1.062937 | 2.04083904 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 78.6 | 3.04e-15 | NR | MBL9169925.1 | 2026801 | g25549 | i0 | 61 | 0.921875 | 59 | 23 | 92.2 | 0 | 11 | 187 | 76 | 134 | MBL9169925.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 177 | 78.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 31498531 | 31498531 | PRJNA474426_P_NODE_12676_length_296_cov_1.161943_g12471_i0 | PRJNA474426 | 12676 | 296 | 1.161943 | 3.43935128 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 111 | 3.2e-26 | NR | WP_397383654.1 | 1965333 | g12471 | i0 | 100 | 0.557432432432432 | 55 | 0 | 55.7 | 0 | 176 | 12 | 1 | 55 | WP_397383654.1 esterase/lipase family protein [Prosthecobacter sp.] | diamond | 165 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 31514736 | 31514736 | PRJNA474426_P_NODE_23576_length_202_cov_2.333333_g23371_i0 | PRJNA474426 | 23576 | 202 | 2.333333 | 4.71333266 | Rariglobus | 2706524 | Bacteria | Bacteria | 111 | 1.6500000000000002e-26 | NR | MCC6415431.1 | 2006848 | g23371 | i0 | 76.1 | 3.98019801980198 | 67 | 16 | 99.5 | 0 | 202 | 2 | 334 | 400 | MCC6415431.1 cation:proton antiporter [Opitutaceae bacterium] | diamond | 804 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31656323 | 31656323 | PRJNA474426_P_NODE_8597_length_368_cov_5.840125_g8392_i0 | PRJNA474426 | 8597 | 368 | 5.840125 | 21.49166 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 113 | 1.66e-28 | NR | MES2737221.1 | 2026799 | g8392 | i0 | 51.8 | 0.91304347826087 | 112 | 48 | 91.3 | 3 | 339 | 4 | 26 | 131 | MES2737221.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 336 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32036112 | 32036112 | PRJNA474426_P_NODE_35018_length_164_cov_0.904348_g34813_i0 | PRJNA474426 | 35018 | 164 | 0.904348 | 1.48313072 | Rariglobus sp. | 2706526 | Bacteria | Bacteria | 59.3 | 1.8e-8 | NR | HEY8933372.1 | 2706526 | g34813 | i0 | 83.8 | 1.35365853658537 | 37 | 6 | 67.7 | 0 | 112 | 2 | 345 | 381 | HEY8933372.1 polysaccharide biosynthesis tyrosine autokinase [Rariglobus sp.] | diamond | 222 | 59.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Rariglobus | Rariglobus sp. | |
| 32036113 | 32036113 | PRJNA474426_P_NODE_7598_length_392_cov_1.860058_g7394_i0 | PRJNA474426 | 7598 | 392 | 1.860058 | 7.29142736 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 171 | 7.87e-47 | NR | MBE7494985.1 | 2026800 | g7394 | i0 | 91 | 2.70918367346939 | 89 | 8 | 68.1 | 0 | 269 | 3 | 211 | 299 | MBE7494985.1 zinc-binding dehydrogenase [Verrucomicrobiaceae bacterium] | diamond | 1062 | 171 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32668364 | 32668364 | PRJNA474426_P_NODE_10140_length_337_cov_1.649306_g9935_i0 | PRJNA474426 | 10140 | 337 | 1.649306 | 5.55816122 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 113 | 7.080000000000001e-27 | NR | MBE2214387.1 | 2006848 | g9935 | i0 | 72 | 0.667655786350148 | 75 | 21 | 66.8 | 0 | 281 | 57 | 270 | 344 | MBE2214387.1 ATP-binding protein [Opitutaceae bacterium] | diamond | 225 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32857350 | 32857350 | PRJNA474426_P_NODE_15700_length_260_cov_1.957346_g15495_i0 | PRJNA474426 | 15700 | 260 | 1.957346 | 5.0890996 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 136 | 6.28e-35 | NR | MEI7773971.1 | 2026799 | g15495 | i0 | 77.8 | 0.934615384615385 | 81 | 17 | 92.3 | 1 | 3 | 242 | 327 | 407 | MEI7773971.1 reverse transcriptase domain-containing protein [Verrucomicrobiota bacterium] | diamond | 243 | 136 | 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);;