contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7976682 | 7976682 | PRJNA1196438_P_NODE_57767_length_261_cov_2.776596_g57340_i0 | PRJNA1196438 | 57767 | 261 | 2.776596 | 7.24691556 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 333 | 7.589999999999999e-87 | NTclustered | gi|183579828|emb|AM905425.1| | 497964 | g57340 | i0 | 89.734 | 269.735632183908 | 263 | 23 | 100 | 4 | 1 | 261 | 1972 | 2232 | Chthoniobacter flavus 23S rRNA gene, strain Ellin428 | blastn | 70401 | 333 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 11801408 | 11801408 | PRJNA1196438_P_NODE_15730_length_312_cov_3.912134_g15304_i0 | PRJNA1196438 | 15730 | 312 | 3.912134 | 12.20585808 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 67.6 | 1.04e-6 | NTclustered | gi|2022020957|gb|CP059069.1| | 2562705 | g15304 | i0 | 85.714 | 1.01923076923077 | 63 | 9 | 20 | 0 | 218 | 280 | 3176310 | 3176372 | Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome | blastn | 318 | 67.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 15625657 | 15625657 | PRJNA1196438_P_NODE_14793_length_312_cov_4.280335_g14367_i0 | PRJNA1196438 | 14793 | 312 | 4.280335 | 13.3546452 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 233 | 9.71e-57 | NTclustered | gi|2874253768|emb|OY969715.1| | 412056 | g14367 | i0 | 94.667 | 94.9839743589744 | 150 | 8 | 76 | 0 | 162 | 311 | 915059 | 914910 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1 | blastn | 29635 | 233 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 15626218 | 15626218 | PRJNA1196438_P_NODE_66313_length_251_cov_0.876404_g65886_i0 | PRJNA1196438 | 66313 | 251 | 0.876404 | 2.19977404 | Opitutus terrae | 107709 | Bacteria | Bacteria | 130 | 1.02e-25 | NTclustered | gi|177839040|gb|CP001032.1| | 452637 | g65886 | i0 | 95.122 | 0.653386454183267 | 82 | 4 | 33 | 0 | 170 | 251 | 3854930 | 3854849 | Opitutus terrae PB90-1, complete genome | blastn | 164 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus terrae | |
| 18175000 | 18175000 | PRJNA1196438_P_NODE_62855_length_254_cov_1.723757_g62428_i0 | PRJNA1196438 | 62855 | 254 | 1.723757 | 4.37834278 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 163 | 1.02e-35 | NTclustered | gi|2029343589|gb|CP073100.1| | 2824561 | g62428 | i0 | 86.897 | 8.89370078740157 | 145 | 19 | 57 | 0 | 109 | 253 | 3202267 | 3202123 | Luteolibacter ambystomatis strain 32A chromosome, complete genome | blastn | 2259 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 20724313 | 20724313 | PRJNA1196438_P_NODE_2637_length_596_cov_5.135755_g2238_i0 | PRJNA1196438 | 2637 | 596 | 5.135755 | 30.6090998 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 900 | 0 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g2238 | i0 | 93.96 | 264.785234899329 | 596 | 35 | 100 | 1 | 1 | 596 | 3046257 | 3046851 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 157812 | 900 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 21999943 | 21999943 | PRJNA1196438_P_NODE_4678_length_456_cov_7.422977_g4260_i0 | PRJNA1196438 | 4678 | 456 | 7.422977 | 33.84877512 | Sulfuriroseicoccus oceanibius | 2707525 | Bacteria | Bacteria | 326 | 2.36e-84 | NTclustered | gi|1953472588|gb|CP066776.1| | 2707525 | g4260 | i0 | 88.561 | 73.2456140350877 | 271 | 28 | 98 | 3 | 1 | 271 | 3450453 | 3450186 | Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome | blastn | 33400 | 326 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Sulfuriroseicoccus | Sulfuriroseicoccus oceanibius | |
| 23275910 | 23275910 | PRJNA1196438_P_NODE_86059_length_210_cov_8.810219_g85631_i0 | PRJNA1196438 | 86059 | 210 | 8.810219 | 18.5014599 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 226 | 1.0299999999999999e-54 | NTclustered | gi|2874253952|emb|OY970277.1| | 412056 | g85631 | i0 | 86.603 | 56.3333333333333 | 209 | 23 | 99 | 5 | 2 | 208 | 2749803 | 2750008 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1 | blastn | 11830 | 226 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae 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);;