contig_metadata
12 rows where bioproject = "PRJNA977246", tax_clade = "PVC group" 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 | ||||
| 14022974 | 14022974 | PRJNA977246_S_NODE_6591_length_621_cov_3172.217905_g5816_i0 | PRJNA977246 | 6591 | 621 | 3172.217905 | 19699.47319005 | root | 1 | Root_unresolved | Root_unresolved | 87 | 6.6e-17 | NR | HZV35108.1 | 2499141 | g5816 | i0 | 60 | 0.942028985507246 | 65 | 26 | 31.4 | 0 | 406 | 600 | 8 | 72 | HZV35108.1 ParB N-terminal domain-containing protein [Verrucomicrobiia bacterium] | diamond | 585 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia 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 | |
| 27158399 | 27158399 | PRJNA977246_S_NODE_46862_length_161_cov_2.924242_g45870_i0 | PRJNA977246 | 46862 | 161 | 2.924242 | 4.70802962 | Prosthecobacter | 48463 | Bacteria | Bacteria | 51.2 | 1.23e-5 | NR | WP_395722112.1 | 1965333 | g45870 | i0 | 64.5 | 2.98136645962733 | 31 | 11 | 57.8 | 0 | 60 | 152 | 16 | 46 | WP_395722112.1 universal stress protein [Prosthecobacter sp.] | diamond | 480 | 51.6 | 0.992248062015504 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27342419 | 27342419 | PRJNA977246_S_NODE_16863_length_348_cov_2.952978_g15871_i0 | PRJNA977246 | 16863 | 348 | 2.952978 | 10.27636344 | Luteolibacter yonseiensis | 1144680 | Bacteria | Bacteria | 68.9 | 7.91e-11 | NR | WP_200351912.1 | 1144680 | g15871 | i0 | 52.2 | 0.577586206896552 | 67 | 31 | 56.9 | 1 | 9 | 206 | 559 | 625 | WP_200351912.1 LTA synthase family protein [Luteolibacter yonseiensis] | diamond | 201 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter yonseiensis | |
| 31264588 | 31264588 | PRJNA977246_S_NODE_37915_length_189_cov_3.156250_g36923_i0 | PRJNA977246 | 37915 | 189 | 3.15625 | 5.9653125 | Verrucomicrobiales | 48461 | Bacteria | Bacteria | 101 | 2.74e-23 | NR | MBX3742762.1 | 2562705 | g36923 | i0 | 90.9 | 1.74603174603175 | 55 | 5 | 87.3 | 0 | 25 | 189 | 131 | 185 | MBX3742762.1 FecR domain-containing protein [Akkermansiaceae bacterium] | diamond | 330 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae 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);;