contig_metadata
7 rows where bioproject = "PRJNA898105", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3424673 | 3424673 | PRJNA898105_P_NODE_7563_length_245_cov_0.895349_g7363_i0 | PRJNA898105 | 7563 | 245 | 0.895349 | 2.19360505 | Prosthecobacter vanneervenii | 48466 | Bacteria | Bacteria | 425 | 1.1299999999999999e-114 | NTclustered | gi|12583975|gb|AF245379.1|AF245379 | 48466 | g7363 | i0 | 97.959 | 227.955102040816 | 245 | 5 | 100 | 0 | 1 | 245 | 532 | 776 | Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence | blastn | 55849 | 425 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter vanneervenii | |
| 26644053 | 26644053 | PRJNA898105_P_NODE_6441_length_250_cov_0.870056_g6241_i0 | PRJNA898105 | 6441 | 250 | 0.870056 | 2.17514 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 142 | 5.189999999999999e-37 | NR | HEY1173498.1 | 2499141 | g6241 | i0 | 91.6 | 2.976 | 83 | 7 | 99.6 | 0 | 249 | 1 | 809 | 891 | HEY1173498.1 CusA/CzcA family heavy metal efflux RND transporter [Verrucomicrobiia bacterium] | diamond | 744 | 142 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29802948 | 29802948 | PRJNA898105_P_NODE_4651_length_278_cov_1.765854_g4451_i0 | PRJNA898105 | 4651 | 278 | 1.765854 | 4.90907412 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 111 | 3.5300000000000003e-26 | NR | MEQ1747971.1 | 1965333 | g4451 | i0 | 68.1 | 1.97482014388489 | 91 | 29 | 98.2 | 0 | 6 | 278 | 1591 | 1681 | MEQ1747971.1 putative Ig domain-containing protein [Prosthecobacter sp.] | diamond | 549 | 111 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 30308986 | 30308986 | PRJNA898105_P_NODE_6472_length_250_cov_0.870056_g6272_i0 | PRJNA898105 | 6472 | 250 | 0.870056 | 2.17514 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 148 | 1.5799999999999994e-42 | NR | MEO6784820.1 | 2811408 | g6272 | i0 | 91.6 | 0.996 | 83 | 7 | 99.6 | 0 | 1 | 249 | 33 | 115 | MEO6784820.1 acetate/propionate family kinase [Chthoniobacteraceae bacterium] | diamond | 249 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 31762421 | 31762421 | PRJNA898105_P_NODE_4557_length_280_cov_1.410628_g4357_i0 | PRJNA898105 | 4557 | 280 | 1.410628 | 3.9497584 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 56.6 | 7.46e-7 | NR | MES2735671.1 | 2026799 | g4357 | i0 | 35.7 | 1.52142857142857 | 70 | 44 | 75 | 1 | 55 | 264 | 381 | 449 | MES2735671.1 Fic family protein [Verrucomicrobiota bacterium] | diamond | 426 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31888919 | 31888919 | PRJNA898105_P_NODE_1917_length_433_cov_1.494444_g1717_i0 | PRJNA898105 | 1917 | 433 | 1.494444 | 6.47094252 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 95.9 | 8.18e-20 | NR | MBS0645922.1 | 2026799 | g1717 | i0 | 38.2 | 5.96535796766744 | 144 | 83 | 98.4 | 3 | 6 | 431 | 842 | 981 | MBS0645922.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 2583 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32276613 | 32276613 | PRJNA898105_P_NODE_5698_length_259_cov_1.424731_g5498_i0 | PRJNA898105 | 5698 | 259 | 1.424731 | 3.69005329 | Bacteria | 2 | Bacteria | Bacteria | 139 | 3.26e-37 | NR | HMP82642.1 | 2026799 | g5498 | i0 | 74.4 | 5.90733590733591 | 86 | 22 | 99.6 | 0 | 258 | 1 | 209 | 294 | HMP82642.1 acyl-CoA reductase [Verrucomicrobiota bacterium] | diamond | 1530 | 140 | 0.992857142857143 | 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);;