contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA415856" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 419270 | 419270 | PRJNA415856_P_NODE_28161_length_177_cov_1.992188_g27900_i0 | PRJNA415856 | 28161 | 177 | 1.992188 | 3.52617276 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 233 | 4.9799999999999995e-57 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g27900 | i0 | 98.485 | 83.4237288135593 | 132 | 2 | 75 | 0 | 1 | 132 | 3556144 | 3556275 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 14766 | 233 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 2359086 | 2359086 | PRJNA415856_P_NODE_8382_length_314_cov_3.418868_g8121_i0 | PRJNA415856 | 8382 | 314 | 3.418868 | 10.73524552 | Chthoniobacter | 295577 | Bacteria | Bacteria | 375 | 1.5299999999999998e-99 | NTclustered | gi|226525288|gb|FJ872373.1| | 156588 | g8121 | i0 | 89.369 | 261.684713375796 | 301 | 28 | 95 | 4 | 1 | 299 | 17769 | 17471 | Uncultured Verrucomicrobia bacterium clone 118 genomic sequence | blastn | 82169 | 375 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 2970089 | 2970089 | PRJNA415856_P_NODE_38583_length_166_cov_0.871795_g38322_i0 | PRJNA415856 | 38583 | 166 | 0.871795 | 1.4471797 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 176 | 7.91e-40 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g38322 | i0 | 90.84 | 8.19277108433735 | 131 | 12 | 79 | 0 | 36 | 166 | 4369754 | 4369884 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 1360 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 9347482 | 9347482 | PRJNA415856_P_NODE_40268_length_165_cov_1.224138_g40007_i0 | PRJNA415856 | 40268 | 165 | 1.224138 | 2.0198277 | Nibricoccus aquaticus | 2576891 | Bacteria | Bacteria | 294 | 2.08e-75 | NTclustered | gi|1243404978|gb|CP023344.1| | 2576891 | g40007 | i0 | 98.788 | 18.9090909090909 | 165 | 2 | 100 | 0 | 1 | 165 | 2497234 | 2497070 | Nibricoccus aquaticus strain HZ-65 chromosome, complete genome | blastn | 3120 | 294 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus aquaticus | |
| 22095611 | 22095611 | PRJNA415856_P_NODE_16778_length_212_cov_4.042945_g16517_i0 | PRJNA415856 | 16778 | 212 | 4.042945 | 8.5710434 | Candidatus Methylacidiphilum infernorum | 511746 | Bacteria | Bacteria | 193 | 1.05e-44 | NTclustered | gi|1999105499|gb|CP065956.1| | 511746 | g16517 | i0 | 83.81 | 105.943396226415 | 210 | 27 | 98 | 7 | 6 | 212 | 2044615 | 2044410 | Candidatus Methylacidiphilum infernorum strain IT5 chromosome, complete genome | blastn | 22460 | 193 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Methylacidiphilae | Methylacidiphilales | Methylacidiphilaceae | Methylacidiphilum (ex Ratnadevi et al. 2023) | Candidatus Methylacidiphilum infernorum | |
| 24645872 | 24645872 | PRJNA415856_P_NODE_560_length_1211_cov_2.354561_g463_i0 | PRJNA415856 | 560 | 1211 | 2.354561 | 28.51373371 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 1576 | 0 | NTclustered | gi|183579828|emb|AM905425.1| | 497964 | g463 | i0 | 90.19 | 204.23534269199 | 1213 | 113 | 100 | 6 | 1 | 1211 | 1424 | 216 | Chthoniobacter flavus 23S rRNA gene, strain Ellin428 | blastn | 247329 | 1576 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus |
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);;