contig_metadata
6 rows where bioproject = "PRJNA289590", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5475934 | 5475934 | PRJNA289590_P_NODE_20505_length_196_cov_2.068027_g20281_i0 | PRJNA289590 | 20505 | 196 | 2.068027 | 4.05333292 | Oceaniferula spumae | 2979115 | Bacteria | Bacteria | 132 | 2.12e-26 | NTclustered | gi|2753272999|dbj|AP026866.1| | 2979115 | g20281 | i0 | 91.579 | 48.0204081632653 | 95 | 8 | 48 | 0 | 1 | 95 | 833029 | 833123 | Verrucomicrobiaceae bacterium NT6N DNA, complete genome | blastn | 9412 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Oceaniferula | Oceaniferula spumae | |
| 5476120 | 5476120 | PRJNA289590_P_NODE_29125_length_165_cov_0.896552_g28901_i0 | PRJNA289590 | 29125 | 165 | 0.896552 | 1.4793108 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 150 | 4.76e-32 | NTclustered | gi|2814788334|emb|OY762281.2| | 2026772 | g28901 | i0 | 83.333 | 10.133333333333301 | 168 | 22 | 100 | 6 | 1 | 165 | 977513 | 977677 | MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1 | blastn | 1672 | 150 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 18224466 | 18224466 | PRJNA289590_P_NODE_6715_length_370_cov_2.246106_g6491_i0 | PRJNA289590 | 6715 | 370 | 2.246106 | 8.3105922 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 169 | 3.3499999999999996e-37 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g6491 | i0 | 90.625 | 61.7540540540541 | 128 | 10 | 34 | 2 | 245 | 370 | 3047506 | 3047379 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 22849 | 169 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 26915958 | 26915958 | PRJNA289590_P_NODE_22622_length_185_cov_1.529412_g22398_i0 | PRJNA289590 | 22622 | 185 | 1.529412 | 2.8294122 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 70.5 | 2.82e-12 | NR | RYD85970.1 | 2026800 | g22398 | i0 | 53.8 | 0.843243243243243 | 52 | 24 | 84.3 | 0 | 30 | 185 | 515 | 566 | RYD85970.1 MAG: hypothetical protein EOP84_00610 [Verrucomicrobiaceae bacterium] | diamond | 156 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27358827 | 27358827 | PRJNA289590_P_NODE_4183_length_499_cov_2.033333_g3964_i0 | PRJNA289590 | 4183 | 499 | 2.033333 | 10.14633167 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 139 | 2.4899999999999996e-37 | NR | HEV2695716.1 | 2499141 | g3964 | i0 | 49.7 | 0.907815631262525 | 151 | 72 | 90.2 | 3 | 493 | 44 | 7 | 154 | HEV2695716.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 453 | 139 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29902356 | 29902356 | PRJNA289590_P_NODE_24871_length_174_cov_1.112000_g24647_i0 | PRJNA289590 | 24871 | 174 | 1.112 | 1.93488 | PVC group | 1783257 | Bacteria | Bacteria | 52 | 8.33e-6 | NR | MEI6675535.1 | 2026799 | g24647 | i0 | 50.9 | 5 | 53 | 26 | 91.4 | 0 | 1 | 159 | 2541 | 2593 | MEI6675535.1 cadherin-like beta sandwich domain-containing protein [Verrucomicrobiota bacterium] | diamond | 870 | 52 | 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);;