contig_metadata
14 rows where 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 | |
| 27186837 | 27186837 | PRJNA415856_P_NODE_23522_length_186_cov_1.489051_g23261_i0 | PRJNA415856 | 23522 | 186 | 1.489051 | 2.76963486 | Luteolibacter | 518753 | Bacteria | Bacteria | 125 | 8.019999999999999e-32 | NR | WP_264503544.1 | 1859460 | g23261 | i0 | 96.8 | 9 | 62 | 2 | 100 | 0 | 186 | 1 | 141 | 202 | WP_264503544.1 ATP-binding cassette domain-containing protein [Luteolibacter flavescens] | diamond | 1674 | 126 | 0.992063492063492 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter flavescens | |
| 27534593 | 27534593 | PRJNA415856_P_NODE_42223_length_165_cov_0.879310_g41962_i0 | PRJNA415856 | 42223 | 165 | 0.87931 | 1.4508615 | Terrimicrobium | 1649503 | Bacteria | Bacteria | 107 | 1.63e-25 | NR | HEY5770341.1 | 1965319 | g41962 | i0 | 98.2 | 3 | 55 | 1 | 100 | 0 | 165 | 1 | 24 | 78 | HEY5770341.1 outer membrane protein assembly factor BamA [Terrimicrobium sp.] | diamond | 495 | 107 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sp. | |
| 27770759 | 27770759 | PRJNA415856_P_NODE_53244_length_161_cov_0.910714_g52983_i0 | PRJNA415856 | 53244 | 161 | 0.910714 | 1.46624954 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 87.4 | 1.85e-18 | NR | MEO7098658.1 | 1962973 | g52983 | i0 | 84 | 1.91925465838509 | 50 | 8 | 93.2 | 0 | 151 | 2 | 213 | 262 | MEO7098658.1 MBL fold metallo-hydrolase [Luteolibacter sp.] | diamond | 309 | 87.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 28717861 | 28717861 | PRJNA415856_P_NODE_47687_length_163_cov_0.894737_g47426_i0 | PRJNA415856 | 47687 | 163 | 0.894737 | 1.45842131 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 40.4 | 0.0402 | NR | MBU1694158.1 | 2026799 | g47426 | i0 | 41 | 0.717791411042945 | 39 | 23 | 71.8 | 0 | 133 | 17 | 88 | 126 | MBU1694158.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 117 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29380808 | 29380808 | PRJNA415856_P_NODE_48789_length_162_cov_0.902655_g48528_i0 | PRJNA415856 | 48789 | 162 | 0.902655 | 1.4623011 | Haloferula sp. | 2497595 | Bacteria | Bacteria | 99 | 9.99e-25 | NR | HEY1122096.1 | 2497595 | g48528 | i0 | 96.2 | 1.96296296296296 | 53 | 2 | 98.1 | 0 | 2 | 160 | 48 | 100 | HEY1122096.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Haloferula sp.] | diamond | 318 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula sp. | |
| 30075453 | 30075453 | PRJNA415856_P_NODE_51932_length_161_cov_0.910714_g51671_i0 | PRJNA415856 | 51932 | 161 | 0.910714 | 1.46624954 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 89.7 | 7.86e-20 | NR | HWA08628.1 | 2006848 | g51671 | i0 | 78.8 | 0.968944099378882 | 52 | 11 | 96.9 | 0 | 6 | 161 | 33 | 84 | HWA08628.1 outer membrane lipoprotein-sorting protein [Opitutaceae bacterium] | diamond | 156 | 89.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31908893 | 31908893 | PRJNA415856_P_NODE_40897_length_165_cov_0.879310_g40636_i0 | PRJNA415856 | 40897 | 165 | 0.87931 | 1.4508615 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 77.4 | 2.74e-16 | NR | MEP2774824.1 | 1962973 | g40636 | i0 | 54.5 | 2 | 55 | 25 | 100 | 0 | 1 | 165 | 33 | 87 | MEP2774824.1 hypothetical protein [Luteolibacter sp.] | diamond | 330 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 32225408 | 32225408 | PRJNA415856_P_NODE_49638_length_162_cov_0.902655_g49377_i0 | PRJNA415856 | 49638 | 162 | 0.902655 | 1.4623011 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 94.7 | 3.46e-21 | NR | HXA08440.1 | 2201154 | g49377 | i0 | 79.2 | 0.981481481481482 | 53 | 11 | 98.1 | 0 | 162 | 4 | 127 | 179 | HXA08440.1 diaminopimelate decarboxylase [Chthoniobacterales bacterium] | diamond | 159 | 94.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales 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);;