contig_metadata
7 rows where bioproject = "PRJNA352610" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21472209 | 21472209 | PRJNA352610_P_NODE_11877_length_345_cov_1.132353_g11816_i0 | PRJNA352610 | 11877 | 345 | 1.132353 | 3.90661785 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 505 | 2.08e-138 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g11816 | i0 | 93.043 | 223.76231884058 | 345 | 24 | 100 | 0 | 1 | 345 | 2749927 | 2750271 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 77198 | 505 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 27154740 | 27154740 | PRJNA352610_P_NODE_31262_length_242_cov_0.911243_g31201_i0 | PRJNA352610 | 31262 | 242 | 0.911243 | 2.20520806 | Rariglobus | 2706524 | Bacteria | Bacteria | 43.1 | 0.0222 | NR | HNC24174.1 | 2006848 | g31201 | i0 | 48.9 | 2.10743801652893 | 45 | 23 | 55.8 | 0 | 239 | 105 | 177 | 221 | HNC24174.1 hypothetical protein [Opitutaceae bacterium] | diamond | 510 | 43.5 | 0.990804597701149 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 27864354 | 27864354 | PRJNA352610_P_NODE_32065_length_241_cov_0.904762_g32004_i0 | PRJNA352610 | 32065 | 241 | 0.904762 | 2.18047642 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 43.1 | 0.0265 | NR | MBI5382792.1 | 2026771 | g32004 | i0 | 36.1 | 0.759336099585062 | 61 | 31 | 75.9 | 1 | 193 | 11 | 385 | 437 | MBI5382792.1 DegQ family serine endoprotease [Opitutia bacterium] | diamond | 183 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 28590819 | 28590819 | PRJNA352610_P_NODE_2567_length_618_cov_1.251376_g2507_i0 | PRJNA352610 | 2567 | 618 | 1.251376 | 7.73350368 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 128 | 1.85e-30 | NR | HXI84029.1 | 2499141 | g2507 | i0 | 54.5 | 0.650485436893204 | 134 | 54 | 64.1 | 4 | 616 | 221 | 162 | 290 | HXI84029.1 NF038122 family metalloprotease [Verrucomicrobiia bacterium] | diamond | 402 | 128 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29190700 | 29190700 | PRJNA352610_P_NODE_28929_length_245_cov_1.389535_g28868_i0 | PRJNA352610 | 28929 | 245 | 1.389535 | 3.40436075 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 90.5 | 5.63e-19 | NR | RME94189.1 | 2026799 | g28868 | i0 | 60.3 | 1.70204081632653 | 68 | 27 | 83.3 | 0 | 226 | 23 | 479 | 546 | RME94189.1 MAG: beta-N-acetylglucosaminidase [Verrucomicrobiota bacterium] | diamond | 417 | 90.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30643356 | 30643356 | PRJNA352610_P_NODE_8913_length_385_cov_1.176282_g8852_i0 | PRJNA352610 | 8913 | 385 | 1.176282 | 4.5286857 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 70.1 | 1.61e-11 | NR | HEU6448320.1 | 2499141 | g8852 | i0 | 60.4 | 0.412987012987013 | 53 | 20 | 41.3 | 1 | 1 | 159 | 192 | 243 | HEU6448320.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 159 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32477835 | 32477835 | PRJNA352610_P_NODE_7839_length_404_cov_1.773414_g7778_i0 | PRJNA352610 | 7839 | 404 | 1.773414 | 7.16459256 | Roseibacillus persicicus | 454148 | Bacteria | Bacteria | 51.6 | 1.79e-4 | NR | WP_308988555.1 | 454148 | g7778 | i0 | 45.2 | 1.38118811881188 | 62 | 31 | 46 | 1 | 188 | 3 | 86 | 144 | WP_308988555.1 family 16 glycoside hydrolase [Roseibacillus persicicus] | diamond | 558 | 51.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseibacillus | Roseibacillus persicicus |
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);;