contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA977246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2227055 | 2227055 | PRJNA977246_S_NODE_48042_length_158_cov_3.573643_g47050_i0 | PRJNA977246 | 48042 | 158 | 3.573643 | 5.64635594 | Verrucomicrobium sp. GAS474 | 1882831 | Bacteria | Bacteria | 124 | 2.73e-24 | NTclustered | gi|1085974270|emb|LT629781.1| | 1882831 | g47050 | i0 | 81.481 | 141.487341772152 | 162 | 21 | 100 | 8 | 1 | 158 | 3537849 | 3538005 | Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I | blastn | 22355 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. GAS474 | |
| 7329447 | 7329447 | PRJNA977246_S_NODE_48886_length_156_cov_3.897638_g47894_i0 | PRJNA977246 | 48886 | 156 | 3.897638 | 6.08031528 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 171 | 3.399999999999999e-38 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g47894 | i0 | 95.327 | 95.6153846153846 | 107 | 5 | 69 | 0 | 50 | 156 | 3831862 | 3831756 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 14916 | 171 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 16253914 | 16253914 | PRJNA977246_S_NODE_20633_length_302_cov_8.076923_g19641_i0 | PRJNA977246 | 20633 | 302 | 8.076923 | 24.39230746 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 313 | 1.17e-80 | NTclustered | gi|183579828|emb|AM905425.1| | 497964 | g19641 | i0 | 85.479 | 138.158940397351 | 303 | 40 | 100 | 3 | 1 | 302 | 191 | 490 | Chthoniobacter flavus 23S rRNA gene, strain Ellin428 | blastn | 41724 | 313 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 16254439 | 16254439 | PRJNA977246_S_NODE_41493_length_176_cov_4.714286_g40501_i0 | PRJNA977246 | 41493 | 176 | 4.714286 | 8.29714336 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 147 | 6.619999999999999e-31 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g40501 | i0 | 82.456 | 0.971590909090909 | 171 | 27 | 96 | 3 | 2 | 170 | 266 | 435 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 171 | 147 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 16254517 | 16254517 | PRJNA977246_S_NODE_45653_length_164_cov_3.466667_g44661_i0 | PRJNA977246 | 45653 | 164 | 3.466667 | 5.68533388 | Pedosphaera parvula | 1032527 | Bacteria | Bacteria | 196 | 5.98e-46 | NTclustered | gi|183579829|emb|AM905426.1| | 320771 | g44661 | i0 | 88.415 | 92.2012195121951 | 164 | 17 | 99 | 2 | 2 | 164 | 1509 | 1671 | Bacterium Ellin514 23S rRNA gene, isolate Ellin514 | blastn | 15121 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Pedosphaerae | Pedosphaerales | Pedosphaeraceae | Pedosphaera | Pedosphaera parvula | |
| 21352885 | 21352885 | PRJNA977246_S_NODE_12537_length_423_cov_5.685279_g11566_i0 | PRJNA977246 | 12537 | 423 | 5.685279 | 24.04873017 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 420 | 9.699999999999999e-113 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g11566 | i0 | 92.857 | 76.8605200945626 | 294 | 13 | 68 | 7 | 1 | 289 | 3558070 | 3557780 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 32512 | 420 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 21353003 | 21353003 | PRJNA977246_S_NODE_16877_length_347_cov_5901.251572_g15885_i0 | PRJNA977246 | 16877 | 347 | 5901.251572 | 20477.34295484 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 375 | 1.7199999999999998e-99 | NTclustered | gi|2874253690|emb|OY969416.1| | 412056 | g15885 | i0 | 89.369 | 67.1440922190202 | 301 | 29 | 86 | 3 | 50 | 347 | 1316149 | 1316449 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1 | blastn | 23299 | 375 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 21353121 | 21353121 | PRJNA977246_S_NODE_21097_length_297_cov_6799.847015_g20105_i0 | PRJNA977246 | 21097 | 297 | 6799.847015 | 20195.54563455 | Luteolibacter sp. AS25 | 3135776 | Bacteria | Bacteria | 344 | 4.06e-90 | NTclustered | gi|2889346039|gb|CP151837.1| | 3135776 | g20105 | i0 | 91.566 | 145.515151515152 | 249 | 21 | 84 | 0 | 49 | 297 | 454549 | 454797 | Luteolibacter sp. AS25 chromosome, complete genome | blastn | 43218 | 344 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. AS25 |
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);;