contig_metadata
18 rows where bioproject = "PRJNA695273", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24903309 | 24903309 | PRJNA695273_P_NODE_137200_length_248_cov_0.880000_g136442_i0 | PRJNA695273 | 137200 | 248 | 0.88 | 2.1824 | Bacteria | 2 | Bacteria | Bacteria | 138 | 8.25e-36 | NR | PIV90371.1 | 1974580 | g136442 | i0 | 82.9 | 5.90322580645161 | 82 | 14 | 99.2 | 0 | 246 | 1 | 562 | 643 | PIV90371.1 MAG: elongation factor G [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13] | diamond | 1464 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13 | ||||||
| 27114062 | 27114062 | PRJNA695273_P_NODE_103482_length_276_cov_1.137931_g102724_i0 | PRJNA695273 | 103482 | 276 | 1.137931 | 3.14068956 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 49.7 | 2e-4 | NR | MFN7160639.1 | 2044595 | g102724 | i0 | 31 | 0.945652173913043 | 87 | 59 | 93.5 | 1 | 6 | 263 | 419 | 505 | MFN7160639.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 261 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28409159 | 28409159 | PRJNA695273_P_NODE_97606_length_282_cov_1.842105_g96848_i0 | PRJNA695273 | 97606 | 282 | 1.842105 | 5.1947361 | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5 | 2044595 | Bacteria | Bacteria | 152 | 8.559999999999998e-41 | NR | PIV90144.1 | 1974580 | g96848 | i0 | 74.2 | 0.98936170212766 | 93 | 24 | 98.9 | 0 | 281 | 3 | 93 | 185 | PIV90144.1 MAG: hypothetical protein COW46_04615 [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13] | diamond | 279 | 152 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13 | ||||||
| 28598729 | 28598729 | PRJNA695273_P_NODE_75627_length_317_cov_2.311475_g74869_i0 | PRJNA695273 | 75627 | 317 | 2.311475 | 7.32737575 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 57.4 | 6.36e-7 | NR | MFN7161341.1 | 2044595 | g74869 | i0 | 41 | 0.738170347003155 | 78 | 46 | 73.8 | 0 | 1 | 234 | 20 | 97 | MFN7161341.1 ATP-binding protein [Candidatus Altimarinota bacterium] | diamond | 234 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28661835 | 28661835 | PRJNA695273_P_NODE_83867_length_302_cov_1.008734_g83109_i0 | PRJNA695273 | 83867 | 302 | 1.008734 | 3.04637668 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 143 | 2.77e-37 | NR | MFN7160504.1 | 2044595 | g83109 | i0 | 70 | 0.993377483443709 | 100 | 30 | 99.3 | 0 | 1 | 300 | 541 | 640 | MFN7160504.1 protein translocase subunit SecD [Candidatus Altimarinota bacterium] | diamond | 300 | 143 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28693457 | 28693457 | PRJNA695273_P_NODE_121947_length_254_cov_1.933702_g121189_i0 | PRJNA695273 | 121947 | 254 | 1.933702 | 4.91160308 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 80.1 | 2.99e-15 | NR | MFN7160287.1 | 2044595 | g121189 | i0 | 58.1 | 0.874015748031496 | 74 | 31 | 87.4 | 0 | 222 | 1 | 354 | 427 | MFN7160287.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 222 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28693492 | 28693492 | PRJNA695273_P_NODE_68687_length_332_cov_1.189189_g67929_i0 | PRJNA695273 | 68687 | 332 | 1.189189 | 3.94810748 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 112 | 1.0600000000000002e-27 | NR | MFN7160554.1 | 2044595 | g67929 | i0 | 59.3 | 0.822289156626506 | 91 | 37 | 82.2 | 0 | 58 | 330 | 1 | 91 | MFN7160554.1 permease [Candidatus Altimarinota bacterium] | diamond | 273 | 112 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28819264 | 28819264 | PRJNA695273_P_NODE_87588_length_295_cov_1.387387_g86830_i0 | PRJNA695273 | 87588 | 295 | 1.387387 | 4.09279165 | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5 | 2044595 | Bacteria | Bacteria | 54.7 | 4.3e-6 | NR | PIV90380.1 | 1974580 | g86830 | i0 | 36.8 | 0.772881355932203 | 76 | 48 | 77.3 | 0 | 292 | 65 | 398 | 473 | PIV90380.1 MAG: DNA polymerase III, subunit gamma and tau [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13] | diamond | 228 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13 | ||||||
| 29577114 | 29577114 | PRJNA695273_P_NODE_67350_length_335_cov_1.175573_g66592_i0 | PRJNA695273 | 67350 | 335 | 1.175573 | 3.93816955 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 110 | 1.39e-25 | NR | MFN7160232.1 | 2044595 | g66592 | i0 | 48 | 1.87164179104478 | 98 | 51 | 87.8 | 0 | 40 | 333 | 1055 | 1152 | MFN7160232.1 SpoIID/LytB domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 627 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29956319 | 29956319 | PRJNA695273_P_NODE_74431_length_320_cov_1.246964_g73673_i0 | PRJNA695273 | 74431 | 320 | 1.246964 | 3.9902848 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 62 | 1.44e-8 | NR | MBP9718670.1 | 2044595 | g73673 | i0 | 37.5 | 0.975 | 104 | 54 | 97.5 | 1 | 8 | 319 | 202 | 294 | MBP9718670.1 PspC domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 312 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 30019625 | 30019625 | PRJNA695273_P_NODE_109411_length_269_cov_1.515306_g108653_i0 | PRJNA695273 | 109411 | 269 | 1.515306 | 4.07617314 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 80.1 | 3.19e-15 | NR | MFN7160697.1 | 2044595 | g108653 | i0 | 52.1 | 0.814126394052045 | 73 | 35 | 81.4 | 0 | 267 | 49 | 180 | 252 | MFN7160697.1 peptidoglycan DD-metalloendopeptidase family protein [Candidatus Altimarinota bacterium] | diamond | 219 | 80.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31124952 | 31124952 | PRJNA695273_P_NODE_156355_length_242_cov_0.911243_g155597_i0 | PRJNA695273 | 156355 | 242 | 0.911243 | 2.20520806 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 139 | 9.119999999999999e-40 | NR | MFN7160666.1 | 2044595 | g155597 | i0 | 83.8 | 0.991735537190083 | 80 | 13 | 99.2 | 0 | 2 | 241 | 60 | 139 | MFN7160666.1 uracil-DNA glycosylase family protein [Candidatus Altimarinota bacterium] | diamond | 240 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31568300 | 31568300 | PRJNA695273_P_NODE_43656_length_410_cov_1.142433_g42898_i0 | PRJNA695273 | 43656 | 410 | 1.142433 | 4.6839753 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 218 | 1.25e-62 | NR | MFN7160007.1 | 2044595 | g42898 | i0 | 69.1 | 1.99024390243902 | 136 | 42 | 99.5 | 0 | 408 | 1 | 373 | 508 | MFN7160007.1 class I tRNA ligase family protein [Candidatus Altimarinota bacterium] | diamond | 816 | 218 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32074204 | 32074204 | PRJNA695273_P_NODE_127938_length_250_cov_1.740113_g127180_i0 | PRJNA695273 | 127938 | 250 | 1.740113 | 4.3502825 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 64.3 | 1.03e-9 | NR | MFN7161311.1 | 2044595 | g127180 | i0 | 54.1 | 2.412 | 61 | 28 | 73.2 | 0 | 188 | 6 | 5525 | 5585 | MFN7161311.1 LamG-like jellyroll fold domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 603 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32105795 | 32105795 | PRJNA695273_P_NODE_131038_length_250_cov_0.870056_g130280_i0 | PRJNA695273 | 131038 | 250 | 0.870056 | 2.17514 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 60.1 | 3.3e-8 | NR | MFN7161162.1 | 2044595 | g130280 | i0 | 47.5 | 1.692 | 61 | 28 | 70.8 | 2 | 243 | 67 | 2420 | 2478 | MFN7161162.1 S-layer homology domain-containing protein [Candidatus Altimarinota bacterium] | diamond | 423 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32454139 | 32454139 | PRJNA695273_P_NODE_134739_length_248_cov_1.760000_g133981_i0 | PRJNA695273 | 134739 | 248 | 1.76 | 4.3648 | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_5 | 2044595 | Bacteria | Bacteria | 66.6 | 9.88e-11 | NR | PIV90566.1 | 1974580 | g133981 | i0 | 60.4 | 0.641129032258065 | 53 | 21 | 64.1 | 0 | 12 | 170 | 242 | 294 | PIV90566.1 MAG: hypothetical protein COW46_01970 [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13] | diamond | 159 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13 | ||||||
| 32549038 | 32549038 | PRJNA695273_P_NODE_152459_length_243_cov_0.905882_g151701_i0 | PRJNA695273 | 152459 | 243 | 0.905882 | 2.20129326 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 70.1 | 7.44e-12 | NR | MFN7161158.1 | 2044595 | g151701 | i0 | 44.3 | 2 | 79 | 44 | 97.5 | 0 | 2 | 238 | 174 | 252 | MFN7161158.1 radical SAM family heme chaperone HemW [Candidatus Altimarinota bacterium] | diamond | 486 | 70.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32780326 | 32780326 | PRJNA695273_P_NODE_132760_length_249_cov_0.875000_g132002_i0 | PRJNA695273 | 132760 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 77 | 3.39e-14 | NR | PIV90292.1 | 1974580 | g132002 | i0 | 47.2 | 1.81927710843373 | 72 | 38 | 86.7 | 0 | 31 | 246 | 104 | 175 | PIV90292.1 MAG: hypothetical protein COW46_03370 [Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13] | diamond | 453 | 77 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium CG17_big_fil_post_rev_8_21_14_2_50_48_13 |
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);;