contig_metadata
12 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Portnoyibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2309583 | 2309583 | PRJNA1148190_P_NODE_215082_length_365_cov_1.318493_g203912_i0 | PRJNA1148190 | 215082 | 365 | 1.318493 | 4.81249945 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 173 | 3.1099999999999995e-48 | NR | MCX6729947.1 | 2053593 | g203912 | i0 | 69.4 | 3.9041095890411 | 121 | 37 | 99.5 | 0 | 365 | 3 | 468 | 588 | MCX6729947.1 ATP-dependent RecD-like DNA helicase [Candidatus Portnoybacteria bacterium] | diamond | 1425 | 173 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 26901585 | 26901585 | PRJNA1148190_P_NODE_637461_length_248_cov_1.554286_g626288_i0 | PRJNA1148190 | 637461 | 248 | 1.554286 | 3.85462928 | Bacteria | 2 | Bacteria | Bacteria | 68.9 | 1.47e-11 | NR | MDD2730939.1 | 2053593 | g626288 | i0 | 49.3 | 2.56451612903226 | 73 | 34 | 84.7 | 1 | 248 | 39 | 8 | 80 | MDD2730939.1 RNA ligase family protein [Candidatus Portnoybacteria bacterium] | diamond | 636 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 27502265 | 27502265 | PRJNA1148190_P_NODE_803283_length_229_cov_2.730769_g792110_i0 | PRJNA1148190 | 803283 | 229 | 2.730769 | 6.25346101 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.1 | 8.18e-5 | NR | MCX6729947.1 | 2053593 | g792110 | i0 | 62.5 | 1.65065502183406 | 40 | 14 | 51.1 | 1 | 228 | 112 | 574 | 613 | MCX6729947.1 ATP-dependent RecD-like DNA helicase [Candidatus Portnoybacteria bacterium] | diamond | 378 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 28891055 | 28891055 | PRJNA1148190_P_NODE_496668_length_267_cov_1.582474_g485495_i0 | PRJNA1148190 | 496668 | 267 | 1.582474 | 4.22520558 | Bacteria | 2 | Bacteria | Bacteria | 114 | 1.15e-28 | NR | PJE58278.1 | 1974812 | g485495 | i0 | 65.9 | 3.86516853932584 | 88 | 26 | 98.9 | 1 | 267 | 4 | 151 | 234 | PJE58278.1 MAG: hypothetical protein COU81_01575 [Candidatus Portnoybacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_7] | diamond | 1032 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_7 | ||||||
| 29156234 | 29156234 | PRJNA1148190_P_NODE_77509_length_624_cov_1.656987_g66393_i0 | PRJNA1148190 | 77509 | 624 | 1.656987 | 10.33959888 | Candidatus Portnoybacteria bacterium | 2053593 | Bacteria | Bacteria | 216 | 3.84e-61 | NR | MDD2731248.1 | 2053593 | g66393 | i0 | 52.3 | 0.956730769230769 | 199 | 93 | 94.7 | 2 | 31 | 621 | 1 | 199 | MDD2731248.1 LAGLIDADG family homing endonuclease [Candidatus Portnoybacteria bacterium] | diamond | 597 | 216 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 29313493 | 29313493 | PRJNA1148190_P_NODE_553609_length_256_cov_1.644809_g542436_i0 | PRJNA1148190 | 553609 | 256 | 1.644809 | 4.21071104 | Candidatus Portnoybacteria bacterium | 2053593 | Bacteria | Bacteria | 138 | 4.5299999999999997e-38 | NR | HHD92133.1 | 2053593 | g542436 | i0 | 77.1 | 0.97265625 | 83 | 19 | 97.3 | 0 | 3 | 251 | 23 | 105 | HHD92133.1 prohibitin family protein [Candidatus Portnoybacteria bacterium] | diamond | 249 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 31019543 | 31019543 | PRJNA1148190_P_NODE_684795_length_246_cov_0.890173_g673622_i0 | PRJNA1148190 | 684795 | 246 | 0.890173 | 2.18982558 | Candidatus Portnoybacteria bacterium CG1 | 2053593 | Bacteria | Bacteria | 60.1 | 2.94e-8 | NR | PJE57808.1 | 1974812 | g673622 | i0 | 38.5 | 0.951219512195122 | 78 | 43 | 89 | 1 | 230 | 12 | 380 | 457 | PJE57808.1 MAG: hypothetical protein COU81_04090 [Candidatus Portnoybacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_7] | diamond | 234 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium CG10_big_fil_rev_8_21_14_0_10_36_7 | ||||||
| 31272384 | 31272384 | PRJNA1148190_P_NODE_710675_length_245_cov_0.895349_g699502_i0 | PRJNA1148190 | 710675 | 245 | 0.895349 | 2.19360505 | Candidatus Portnoybacteria bacterium | 2053593 | Bacteria | Bacteria | 45.8 | 3.51e-4 | NR | MDD2730934.1 | 2053593 | g699502 | i0 | 38.7 | 0.759183673469388 | 62 | 36 | 75.9 | 1 | 233 | 48 | 12 | 71 | MDD2730934.1 hypothetical protein [Candidatus Portnoybacteria bacterium] | diamond | 186 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 31461284 | 31461284 | PRJNA1148190_P_NODE_101316_length_530_cov_2.864333_g90160_i0 | PRJNA1148190 | 101316 | 530 | 2.864333 | 15.1809649 | Candidatus Portnoybacteria bacterium | 2053593 | Bacteria | Bacteria | 219 | 8.67e-63 | NR | MDD2731248.1 | 2053593 | g90160 | i0 | 60.6 | 0.990566037735849 | 175 | 67 | 99.1 | 1 | 5 | 529 | 424 | 596 | MDD2731248.1 LAGLIDADG family homing endonuclease [Candidatus Portnoybacteria bacterium] | diamond | 525 | 219 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 31639760 | 31639760 | PRJNA1148190_P_NODE_55716_length_783_cov_1.557746_g44802_i0 | PRJNA1148190 | 55716 | 783 | 1.557746 | 12.19715118 | Bacteria | 2 | Bacteria | Bacteria | 81.6 | 6.41e-16 | NR | MBD3282443.1 | 2053593 | g44802 | i0 | 49.5 | 0.693486590038314 | 91 | 42 | 34.1 | 3 | 695 | 429 | 1 | 89 | MBD3282443.1 hypothetical protein [Candidatus Portnoybacteria bacterium] | diamond | 543 | 82 | 0.995121951219512 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium | ||||||
| 32663774 | 32663774 | PRJNA1148190_P_NODE_745600_length_243_cov_0.905882_g734427_i0 | PRJNA1148190 | 745600 | 243 | 0.905882 | 2.20129326 | Candidatus Portnoybacteria bacterium RIFCSPHIGHO2_ | 2053593 | Bacteria | Bacteria | 67 | 4.91e-12 | NR | OGZ37256.1 | 1801995 | g734427 | i0 | 62 | 0.617283950617284 | 50 | 19 | 61.7 | 0 | 242 | 93 | 67 | 116 | OGZ37256.1 MAG: hypothetical protein A2646_03080 [Candidatus Portnoybacteria bacterium RIFCSPHIGHO2_02_FULL_39_12] | diamond | 150 | 67 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium RIFCSPHIGHO2_02_FULL_39_12 | ||||||
| 32694180 | 32694180 | PRJNA1148190_P_NODE_107820_length_512_cov_1.503417_g96661_i0 | PRJNA1148190 | 107820 | 512 | 1.503417 | 7.69749504 | Candidatus Portnoybacteria bacterium RIFCSPHIGHO2_ | 2053593 | Bacteria | Bacteria | 56.6 | 2.25e-6 | NR | OGZ35106.1 | 1801993 | g96661 | i0 | 35.5 | 0.626953125 | 107 | 60 | 58.6 | 3 | 303 | 4 | 3 | 107 | OGZ35106.1 MAG: AmmeMemoRadiSam system protein B, partial [Candidatus Portnoybacteria bacterium RIFCSPHIGHO2_01_FULL_39_19] | diamond | 321 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Portnoyibacteriota | Candidatus Portnoybacteria bacterium RIFCSPHIGHO2_01_FULL_39_19 |
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);;