contig_metadata
4 rows where bioproject = "PRJNA534016", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8160211 | 8160211 | PRJNA534016_P_NODE_12487_length_259_cov_3.010753_g12397_i0 | PRJNA534016 | 12487 | 259 | 3.010753 | 7.79785027 | uncultured Verrucomicrobia subdivision 3 bacterium | 257465 | Bacteria | Bacteria | 479 | 9.13e-131 | NTclustered | gi|378401408|emb|HE648177.1| | 257465 | g12397 | i0 | 100 | 98.4362934362934 | 259 | 0 | 100 | 0 | 1 | 259 | 1413 | 1155 | Uncultured Verrucomicrobia subdivision 3 bacterium partial 16S rRNA gene, clone P3 | blastn | 25495 | 479 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | uncultured Verrucomicrobia subdivision 3 bacterium | |||
| 8160350 | 8160350 | PRJNA534016_P_NODE_5487_length_355_cov_2.691489_g5397_i0 | PRJNA534016 | 5487 | 355 | 2.691489 | 9.55478595 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 149 | 9.919999999999997e-42 | NR | HCP06138.1 | 2026801 | g5397 | i0 | 67 | 3.65070422535211 | 115 | 31 | 97.2 | 2 | 1 | 345 | 145 | 252 | HCP06138.1 transaldolase [Verrucomicrobiales bacterium] | diamond | 1296 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 26919647 | 26919647 | PRJNA534016_P_NODE_17502_length_243_cov_0.905882_g17412_i0 | PRJNA534016 | 17502 | 243 | 0.905882 | 2.20129326 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 100 | 1.86e-23 | NR | MBN9692575.1 | 2026799 | g17412 | i0 | 97.9 | 0.592592592592593 | 48 | 1 | 59.3 | 0 | 243 | 100 | 223 | 270 | MBN9692575.1 EamA family transporter [Verrucomicrobiota bacterium] | diamond | 144 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27123998 | 27123998 | PRJNA534016_P_NODE_18882_length_232_cov_2.792453_g18792_i0 | PRJNA534016 | 18882 | 232 | 2.792453 | 6.47849096 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 46.6 | 0.00136 | NR | HEY6675445.1 | 1965319 | g18792 | i0 | 41.1 | 2.14655172413793 | 56 | 33 | 72.4 | 0 | 24 | 191 | 18 | 73 | HEY6675445.1 adenylate/guanylate cyclase domain-containing protein [Terrimicrobium sp.] | diamond | 498 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sp. |
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);;