contig_metadata
7 rows where bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2853664 | 2853664 | PRJNA1156092_P_NODE_15343_length_297_cov_1.031250_g15213_i0 | PRJNA1156092 | 15343 | 297 | 1.03125 | 3.0628125 | uncultured Verrucomicrobiota bacterium | 156588 | Bacteria | Bacteria | 448 | 3.0099999999999998e-121 | NTclustered | gi|226525288|gb|FJ872373.1| | 156588 | g15213 | i0 | 93.96 | 69.3771043771044 | 298 | 14 | 99 | 4 | 1 | 296 | 16357 | 16652 | Uncultured Verrucomicrobia bacterium clone 118 genomic sequence | blastn | 20605 | 448 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 21979753 | 21979753 | PRJNA1156092_P_NODE_30678_length_243_cov_0.905882_g30548_i0 | PRJNA1156092 | 30678 | 243 | 0.905882 | 2.20129326 | Opitutus sp. GAS368 | 1882749 | Bacteria | Bacteria | 73.1 | 1.68e-8 | NTclustered | gi|1085764882|emb|LT629735.1| | 1882749 | g30548 | i0 | 82.418 | 30.8765432098765 | 91 | 9 | 38 | 6 | 26 | 116 | 2527548 | 2527465 | Opitutus sp. GAS368 genome assembly, chromosome: I | blastn | 7503 | 73.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. GAS368 | |
| 26806512 | 26806512 | PRJNA1156092_P_NODE_29661_length_244_cov_0.900585_g29531_i0 | PRJNA1156092 | 29661 | 244 | 0.900585 | 2.1974274 | Haloferula | 574899 | Bacteria | Bacteria | 112 | 1.15e-26 | NR | WP_200279376.1 | 490093 | g29531 | i0 | 62.5 | 1.9672131147541 | 80 | 30 | 98.4 | 0 | 242 | 3 | 591 | 670 | WP_200279376.1 lamin tail domain-containing protein [Haloferula rosea] | diamond | 480 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula rosea | |
| 27829998 | 27829998 | PRJNA1156092_P_NODE_29584_length_244_cov_0.900585_g29454_i0 | PRJNA1156092 | 29584 | 244 | 0.900585 | 2.1974274 | Candidatus Methylacidiphilales bacterium | 2720631 | Bacteria | Bacteria | 102 | 4.529999999999999e-23 | NR | MDD5262713.1 | 2720631 | g29454 | i0 | 67.1 | 4.75819672131148 | 76 | 24 | 93.4 | 1 | 228 | 1 | 198 | 272 | MDD5262713.1 FGGY-family carbohydrate kinase [Candidatus Methylacidiphilales bacterium] | diamond | 1161 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Candidatus Methylacidiphilales bacterium | |||
| 28998609 | 28998609 | PRJNA1156092_P_NODE_29748_length_244_cov_0.900585_g29618_i0 | PRJNA1156092 | 29748 | 244 | 0.900585 | 2.1974274 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 44.7 | 0.00777 | NR | MCD8481200.1 | 2026799 | g29618 | i0 | 30.7 | 0.922131147540984 | 75 | 50 | 91 | 2 | 242 | 21 | 98 | 171 | MCD8481200.1 fibronectin type III domain-containing protein [Verrucomicrobiota bacterium] | diamond | 225 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29093149 | 29093149 | PRJNA1156092_P_NODE_29148_length_244_cov_0.900585_g29018_i0 | PRJNA1156092 | 29148 | 244 | 0.900585 | 2.1974274 | Roseimicrobium sp. ORNL1 | 2711231 | Bacteria | Bacteria | 44.3 | 0.0109 | NR | WP_165210747.1 | 2711231 | g29018 | i0 | 35.3 | 0.836065573770492 | 68 | 33 | 76.2 | 2 | 59 | 244 | 179 | 241 | WP_165210747.1 ArnT family glycosyltransferase [Roseimicrobium sp. ORNL1] | diamond | 204 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseimicrobium | Roseimicrobium sp. ORNL1 | |
| 31430692 | 31430692 | PRJNA1156092_P_NODE_32516_length_241_cov_0.916667_g32386_i0 | PRJNA1156092 | 32516 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 123 | 3.2e-33 | NR | HAV63979.1 | 2026801 | g32386 | i0 | 74.7 | 0.983402489626556 | 79 | 20 | 98.3 | 0 | 4 | 240 | 102 | 180 | HAV63979.1 TetR/AcrR family transcriptional regulator [Verrucomicrobiales bacterium] | diamond | 237 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales 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);;