contig_metadata
11 rows where bioproject = "PRJNA533114", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27393825 | 27393825 | PRJNA533114_P_NODE_105363_length_247_cov_0.885057_g105111_i0 | PRJNA533114 | 105363 | 247 | 0.885057 | 2.18609079 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 78.6 | 6.42e-15 | NR | HMI53611.1 | 2973664 | g105111 | i0 | 71.4 | 3.04858299595142 | 49 | 14 | 59.5 | 0 | 245 | 99 | 298 | 346 | HMI53611.1 LacI family DNA-binding transcriptional regulator [Candidatus Saccharimonadales bacterium] | diamond | 753 | 78.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 27646516 | 27646516 | PRJNA533114_P_NODE_28824_length_425_cov_1.713068_g28572_i0 | PRJNA533114 | 28824 | 425 | 1.713068 | 7.280539 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 49.3 | 0.0013 | NR | MCR5572688.1 | 2026720 | g28572 | i0 | 29.4 | 0.889411764705882 | 126 | 79 | 83.3 | 4 | 62 | 415 | 500 | 623 | MCR5572688.1 RICIN domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 378 | 49.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27772814 | 27772814 | PRJNA533114_P_NODE_3984_length_1077_cov_1.357570_g3831_i0 | PRJNA533114 | 3984 | 1077 | 1.35757 | 14.6210289 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 52.8 | 0.00238 | NR | MBQ3293926.1 | 2026720 | g3831 | i0 | 36.2 | 0.323119777158774 | 116 | 66 | 30.1 | 3 | 127 | 450 | 797 | 912 | MBQ3293926.1 cadherin-like beta sandwich domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 348 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 28025255 | 28025255 | PRJNA533114_P_NODE_24205_length_461_cov_2.051546_g23955_i0 | PRJNA533114 | 24205 | 461 | 2.051546 | 9.45762706 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 49.7 | 0.00109 | NR | MBP9827025.1 | 2026720 | g23955 | i0 | 40.3 | 0.813449023861171 | 67 | 37 | 42.3 | 2 | 35 | 229 | 188 | 253 | MBP9827025.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 375 | 49.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29035797 | 29035797 | PRJNA533114_P_NODE_47428_length_341_cov_1.190299_g47176_i0 | PRJNA533114 | 47428 | 341 | 1.190299 | 4.05891959 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 142 | 9.49e-37 | NR | MBR6126027.1 | 2026720 | g47176 | i0 | 79.3 | 1.44281524926686 | 82 | 17 | 72.1 | 0 | 3 | 248 | 94 | 175 | MBR6126027.1 FHA domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 492 | 142 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 29130458 | 29130458 | PRJNA533114_P_NODE_1429_length_1538_cov_3.716724_g1358_i0 | PRJNA533114 | 1429 | 1538 | 3.716724 | 57.16321512 | Candidatus Saccharimonadales bacterium | 2973664 | Bacteria | Bacteria | 52.8 | 0.00434 | NR | HSX08275.1 | 2973664 | g1358 | i0 | 31.4 | 0.341352405721716 | 175 | 95 | 29.5 | 6 | 1181 | 729 | 266 | 439 | HSX08275.1 hypothetical protein [Candidatus Saccharimonadales bacterium] | diamond | 525 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadales bacterium | ||||
| 30172361 | 30172361 | PRJNA533114_P_NODE_3152_length_1178_cov_3.127602_g3014_i0 | PRJNA533114 | 3152 | 1178 | 3.127602 | 36.84315156 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 51.2 | 0.0088 | NR | MBQ3293926.1 | 2026720 | g3014 | i0 | 35.1 | 1.50254668930391 | 134 | 69 | 31.1 | 5 | 660 | 1025 | 779 | 906 | MBQ3293926.1 cadherin-like beta sandwich domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 1770 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31356819 | 31356819 | PRJNA533114_P_NODE_91156_length_254_cov_1.419890_g90904_i0 | PRJNA533114 | 91156 | 254 | 1.41989 | 3.6065206 | Bacteria | 2 | Bacteria | Bacteria | 72.4 | 1.09e-12 | NR | MBP6880162.1 | 2026720 | g90904 | i0 | 50 | 3.80314960629921 | 80 | 38 | 94.5 | 1 | 3 | 242 | 202 | 279 | MBP6880162.1 50S ribosomal protein L1 [Candidatus Saccharibacteria bacterium] | diamond | 966 | 72.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 31784361 | 31784361 | PRJNA533114_P_NODE_91337_length_254_cov_1.270718_g91085_i0 | PRJNA533114 | 91337 | 254 | 1.270718 | 3.22762372 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 144 | 8.36e-38 | NR | MBR6126027.1 | 2026720 | g91085 | i0 | 81 | 7.93700787401575 | 84 | 16 | 99.2 | 0 | 1 | 252 | 93 | 176 | MBR6126027.1 FHA domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 2016 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32764276 | 32764276 | PRJNA533114_P_NODE_60600_length_306_cov_1.639485_g60348_i0 | PRJNA533114 | 60600 | 306 | 1.639485 | 5.0168241 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 153 | 1.38e-40 | NR | MBR6126027.1 | 2026720 | g60348 | i0 | 70 | 1.90196078431373 | 100 | 30 | 98 | 0 | 306 | 7 | 35 | 134 | MBR6126027.1 FHA domain-containing protein [Candidatus Saccharibacteria bacterium] | diamond | 582 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 32795546 | 32795546 | PRJNA533114_P_NODE_45240_length_348_cov_1.221818_g44988_i0 | PRJNA533114 | 45240 | 348 | 1.221818 | 4.25192664 | Candidatus Saccharibacteria bacterium 49-2 | 1895829 | Bacteria | Bacteria | 51.2 | 6.41e-5 | NR | OJU87784.1 | 1895829 | g44988 | i0 | 39.1 | 0.594827586206897 | 69 | 42 | 59.5 | 0 | 208 | 2 | 9 | 77 | OJU87784.1 MAG: hypothetical protein BGO17_02250 [Candidatus Saccharibacteria bacterium 49-20] | diamond | 207 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 |
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);;