contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Tayloriibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27128040 | 27128040 | PRJEB64798_P_NODE_107302_length_210_cov_21.310559_g105536_i0 | PRJEB64798 | 107302 | 210 | 21.310559 | 44.7521739 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 54.7 | 8.56e-8 | NR | MDO8430762.1 | 2052153 | g105536 | i0 | 65.6 | 0.871428571428571 | 32 | 11 | 45.7 | 0 | 207 | 112 | 30 | 61 | MDO8430762.1 MerR family DNA-binding transcriptional regulator [Candidatus Taylorbacteria bacterium] | diamond | 183 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 28448234 | 28448234 | PRJEB64798_P_NODE_115806_length_208_cov_8.867925_g114040_i0 | PRJEB64798 | 115806 | 208 | 8.867925 | 18.445284 | Bacteria | 2 | Bacteria | Bacteria | 65.5 | 2.18e-10 | NR | MDO8430461.1 | 2052153 | g114040 | i0 | 97 | 9.04326923076923 | 33 | 1 | 47.6 | 0 | 101 | 3 | 213 | 245 | MDO8430461.1 ribonuclease Y [Candidatus Taylorbacteria bacterium] | diamond | 1881 | 65.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 28739109 | 28739109 | PRJEB64798_P_NODE_170007_length_179_cov_0.961538_g168241_i0 | PRJEB64798 | 170007 | 179 | 0.961538 | 1.72115302 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 59.3 | 9.71e-9 | NR | MSR71390.1 | 2052153 | g168241 | i0 | 87.1 | 2.59776536312849 | 31 | 4 | 52 | 0 | 162 | 70 | 1 | 31 | MSR71390.1 LysE family translocator [Candidatus Taylorbacteria bacterium] | diamond | 465 | 59.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 29023578 | 29023578 | PRJEB64798_P_NODE_124808_length_202_cov_4.522876_g123042_i0 | PRJEB64798 | 124808 | 202 | 4.522876 | 9.13620952 | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_ | 1802313 | Bacteria | Bacteria | 43.5 | 0.00188 | NR | OHA28567.1 | 1802313 | g123042 | i0 | 48.1 | 0.772277227722772 | 52 | 27 | 77.2 | 0 | 5 | 160 | 2 | 53 | OHA28567.1 MAG: hypothetical protein A3C08_02330 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_47_18] | diamond | 156 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_47_18 | ||||||
| 30633901 | 30633901 | PRJEB64798_P_NODE_198373_length_168_cov_0.873950_g196607_i0 | PRJEB64798 | 198373 | 168 | 0.87395 | 1.468236 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 92.8 | 2.48e-20 | NR | MBI5134470.1 | 2052153 | g196607 | i0 | 85.2 | 1.92857142857143 | 54 | 8 | 96.4 | 0 | 2 | 163 | 53 | 106 | MBI5134470.1 pyruvate kinase [Candidatus Taylorbacteria bacterium] | diamond | 324 | 92.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 30792050 | 30792050 | PRJEB64798_P_NODE_228634_length_159_cov_4.509091_g226868_i0 | PRJEB64798 | 228634 | 159 | 4.509091 | 7.16945469 | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_ | 1802306 | Bacteria | Bacteria | 78.2 | 2.09e-15 | NR | OHA24371.1 | 1802306 | g226868 | i0 | 62 | 1.90566037735849 | 50 | 19 | 94.3 | 0 | 159 | 10 | 196 | 245 | OHA24371.1 MAG: hypothetical protein A3C72_02185 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_43_32b] | diamond | 303 | 78.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_02_FULL_43_32b | ||||||
| 31765163 | 31765163 | PRJEB64798_P_NODE_193817_length_169_cov_2.066667_g192051_i0 | PRJEB64798 | 193817 | 169 | 2.066667 | 3.49266723 | Bacteria | 2 | Bacteria | Bacteria | 101 | 3.38e-23 | NR | OHA17832.1 | 1802300 | g192051 | i0 | 92.7 | 13.6686390532544 | 55 | 4 | 97.6 | 0 | 1 | 165 | 198 | 252 | OHA17832.1 MAG: copper-translocating P-type ATPase [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_45_63] | diamond | 2310 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_45_63 | ||||||
| 31771970 | 31771970 | PRJEB64798_P_NODE_105317_length_211_cov_13.845679_g103551_i0 | PRJEB64798 | 105317 | 211 | 13.845679 | 29.21438269 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 100 | 5.8e-25 | NR | MEI6305143.1 | 2052153 | g103551 | i0 | 65.8 | 1.08056872037915 | 76 | 18 | 96.7 | 1 | 3 | 206 | 4 | 79 | MEI6305143.1 NUDIX domain-containing protein [Candidatus Taylorbacteria bacterium] | diamond | 228 | 100 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota bacterium | ||||||
| 32183482 | 32183482 | PRJEB64798_P_NODE_157218_length_185_cov_1.301471_g155452_i0 | PRJEB64798 | 157218 | 185 | 1.301471 | 2.40772135 | Candidatus Tayloriibacteriota bacterium | 2052153 | Bacteria | Bacteria | 94 | 1.5600000000000002e-21 | NR | MBU3668597.1 | 2052153 | g155452 | i0 | 66.7 | 0.972972972972973 | 60 | 20 | 97.3 | 0 | 184 | 5 | 197 | 256 | MBU3668597.1 hypothetical protein [Candidatus Taylorbacteria bacterium] | diamond | 180 | 94 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Tayloriibacteriota | Candidatus Tayloriibacteriota 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);;