contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 737238 | 737238 | PRJNA758088_P_NODE_314741_length_247_cov_0.885057_g307770_i0 | PRJNA758088 | 314741 | 247 | 0.885057 | 2.18609079 | Verrucomicrobiia bacterium Tous-C3TDCM | 1982330 | Bacteria | Bacteria | 152 | 1.62e-41 | NR | PAW62849.1 | 1982330 | g307770 | i0 | 97.5 | 2.95141700404858 | 81 | 2 | 98.4 | 0 | 245 | 3 | 329 | 409 | PAW62849.1 MAG: type II secretion system protein E [Verrucomicrobiia bacterium Tous-C3TDCM] | diamond | 729 | 152 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium Tous-C3TDCM | ||||
| 7115644 | 7115644 | PRJNA758088_P_NODE_289926_length_250_cov_0.870056_g282955_i0 | PRJNA758088 | 289926 | 250 | 0.870056 | 2.17514 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 166 | 5.569999999999999e-46 | NR | HCG20217.1 | 2026799 | g282955 | i0 | 91.6 | 1.932 | 83 | 7 | 99.6 | 0 | 1 | 249 | 574 | 656 | HCG20217.1 site-specific DNA-methyltransferase [Verrucomicrobiota bacterium] | diamond | 483 | 166 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 12216387 | 12216387 | PRJNA758088_P_NODE_282770_length_251_cov_0.865169_g275799_i0 | PRJNA758088 | 282770 | 251 | 0.865169 | 2.17157419 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 144 | 5.92e-38 | NR | HEX2747997.1 | 2026801 | g275799 | i0 | 83.1 | 0.99203187250996006 | 83 | 14 | 99.2 | 0 | 250 | 2 | 1036 | 1118 | HEX2747997.1 alpha-2-macroglobulin family protein [Verrucomicrobiales bacterium] | diamond | 249 | 144 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 26609589 | 26609589 | PRJNA758088_P_NODE_336021_length_244_cov_1.350877_g329050_i0 | PRJNA758088 | 336021 | 244 | 1.350877 | 3.29613988 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 87.4 | 3.2e-18 | NR | MCX6905895.1 | 2026799 | g329050 | i0 | 57.5 | 3.9344262295082 | 80 | 29 | 98.4 | 2 | 244 | 5 | 179 | 253 | MCX6905895.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 960 | 87.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27337592 | 27337592 | PRJNA758088_P_NODE_340483_length_244_cov_0.900585_g333512_i0 | PRJNA758088 | 340483 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 88.2 | 2.34e-18 | NR | MEY4487546.1 | 2026799 | g333512 | i0 | 53.8 | 0.983606557377049 | 80 | 37 | 98.4 | 0 | 1 | 240 | 255 | 334 | MEY4487546.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 240 | 88.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28095273 | 28095273 | PRJNA758088_P_NODE_349985_length_243_cov_0.905882_g343014_i0 | PRJNA758088 | 349985 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 91.7 | 6.78e-21 | NR | MEI6794832.1 | 2026799 | g343014 | i0 | 60.8 | 0.975308641975309 | 79 | 25 | 97.5 | 1 | 242 | 6 | 117 | 189 | MEI6794832.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 237 | 91.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29295074 | 29295074 | PRJNA758088_P_NODE_255649_length_265_cov_1.494792_g248678_i0 | PRJNA758088 | 255649 | 265 | 1.494792 | 3.9611988 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 83.2 | 9.2e-19 | NR | MCW0220631.1 | 1965333 | g248678 | i0 | 77.8 | 0.611320754716981 | 54 | 12 | 61.1 | 0 | 2 | 163 | 18 | 71 | MCW0220631.1 hypothetical protein [Prosthecobacter sp.] | diamond | 162 | 83.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29358315 | 29358315 | PRJNA758088_P_NODE_268109_length_258_cov_1.221622_g261138_i0 | PRJNA758088 | 268109 | 258 | 1.221622 | 3.15178476 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 102 | 3.929999999999999e-24 | NR | HXJ59741.1 | 2499141 | g261138 | i0 | 67.1 | 5.94186046511628 | 85 | 28 | 98.8 | 0 | 1 | 255 | 135 | 219 | HXJ59741.1 pyrroline-5-carboxylate reductase [Verrucomicrobiia bacterium] | diamond | 1533 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29578992 | 29578992 | PRJNA758088_P_NODE_325450_length_246_cov_0.890173_g318479_i0 | PRJNA758088 | 325450 | 246 | 0.890173 | 2.18982558 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 127 | 3.98e-35 | NR | WP_300194736.1 | 1965333 | g318479 | i0 | 70.7 | 1 | 82 | 24 | 100 | 0 | 1 | 246 | 21 | 102 | WP_300194736.1 metalloprotease family protein [Prosthecobacter sp.] | diamond | 246 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 29800177 | 29800177 | PRJNA758088_P_NODE_354911_length_242_cov_0.911243_g347940_i0 | PRJNA758088 | 354911 | 242 | 0.911243 | 2.20520806 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 161 | 1.15e-46 | NR | MBP3525504.1 | 2026772 | g347940 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 240 | 1 | 180 | 259 | MBP3525504.1 peptidylprolyl isomerase [Opitutales bacterium] | diamond | 240 | 161 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 30432521 | 30432521 | PRJNA758088_P_NODE_333333_length_245_cov_0.895349_g326362_i0 | PRJNA758088 | 333333 | 245 | 0.895349 | 2.19360505 | Coraliomargarita sp. CAG:312 | 1262865 | Bacteria | Bacteria | 170 | 3.05e-48 | NR | CDE82941.1 | 1262865 | g326362 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 244 | 2 | 300 | 380 | CDE82941.1 putative uncharacterized protein [Coraliomargarita sp. CAG:312] | diamond | 243 | 170 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Coraliomargaritaceae | Coraliomargarita | Coraliomargarita sp. CAG:312 | |
| 31664698 | 31664698 | PRJNA758088_P_NODE_215577_length_290_cov_1.276498_g208606_i0 | PRJNA758088 | 215577 | 290 | 1.276498 | 3.7018442 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 52.8 | 1.11e-5 | NR | HLW35798.1 | 2201154 | g208606 | i0 | 40 | 0.724137931034483 | 70 | 38 | 71.4 | 2 | 289 | 83 | 89 | 155 | HLW35798.1 GAF domain-containing protein [Chthoniobacterales bacterium] | diamond | 210 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32424193 | 32424193 | PRJNA758088_P_NODE_327479_length_245_cov_1.691860_g320508_i0 | PRJNA758088 | 327479 | 245 | 1.69186 | 4.145057 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 103 | 1.0099999999999999e-23 | NR | HTB63326.1 | 2026772 | g320508 | i0 | 56.1 | 1.00408163265306 | 82 | 35 | 99.2 | 1 | 244 | 2 | 236 | 317 | HTB63326.1 hypothetical protein [Opitutales bacterium] | diamond | 246 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 32676576 | 32676576 | PRJNA758088_P_NODE_366160_length_241_cov_0.916667_g359189_i0 | PRJNA758088 | 366160 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 163 | 5.11e-49 | NR | MES2508139.1 | 2026799 | g359189 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 2 | 241 | 97 | 176 | MES2508139.1 PEP-CTERM sorting domain-containing protein [Verrucomicrobiota bacterium] | diamond | 240 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32739857 | 32739857 | PRJNA758088_P_NODE_323820_length_246_cov_0.890173_g316849_i0 | PRJNA758088 | 323820 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 145 | 1.48e-38 | NR | MES2469949.1 | 2026799 | g316849 | i0 | 88.9 | 0.98780487804878 | 81 | 9 | 98.8 | 0 | 245 | 3 | 185 | 265 | MES2469949.1 DUF1592 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 243 | 145 | 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);;