contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJEB10140" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26779518 | 26779518 | PRJEB10140_P_NODE_283521_length_163_cov_0.912281_g266212_i0 | PRJEB10140 | 283521 | 163 | 0.912281 | 1.48701803 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 53.1 | 2.58e-6 | NR | MDR3547690.1 | 2053589 | g266212 | i0 | 65.8 | 0.699386503067485 | 38 | 13 | 69.9 | 0 | 18 | 131 | 346 | 383 | MDR3547690.1 Ig-like domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 114 | 53.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28358978 | 28358978 | PRJEB10140_P_NODE_271626_length_165_cov_0.887931_g254317_i0 | PRJEB10140 | 271626 | 165 | 0.887931 | 1.46508615 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79 | 1.81e-17 | NR | MFA5432895.1 | 2053589 | g254317 | i0 | 83.3 | 0.763636363636364 | 42 | 7 | 76.4 | 0 | 40 | 165 | 25 | 66 | MFA5432895.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 126 | 79 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29148867 | 29148867 | PRJEB10140_P_NODE_240749_length_171_cov_1.278689_g223440_i0 | PRJEB10140 | 240749 | 171 | 1.278689 | 2.18655819 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 89 | 4.95e-19 | NR | MBP9748437.1 | 2053589 | g223440 | i0 | 73.2 | 0.982456140350877 | 56 | 15 | 98.2 | 0 | 2 | 169 | 353 | 408 | MBP9748437.1 glycosyltransferase family 2 protein [Candidatus Paceibacterota bacterium] | diamond | 168 | 89 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29653308 | 29653308 | PRJEB10140_P_NODE_291170_length_162_cov_0.920354_g273861_i0 | PRJEB10140 | 291170 | 162 | 0.920354 | 1.49097348 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 48.1 | 1.58e-4 | NR | HEX5774955.1 | 2053589 | g273861 | i0 | 56.5 | 0.851851851851852 | 46 | 20 | 85.2 | 0 | 25 | 162 | 430 | 475 | HEX5774955.1 fibronectin type III domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 138 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30095657 | 30095657 | PRJEB10140_P_NODE_168072_length_225_cov_1.039773_g150763_i0 | PRJEB10140 | 168072 | 225 | 1.039773 | 2.33948925 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 52.8 | 1.56e-6 | NR | MFA5433670.1 | 2053589 | g150763 | i0 | 39.2 | 0.986666666666667 | 74 | 41 | 98.7 | 1 | 3 | 224 | 47 | 116 | MFA5433670.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 222 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30254044 | 30254044 | PRJEB10140_P_NODE_162192_length_231_cov_2.263736_g144884_i0 | PRJEB10140 | 162192 | 231 | 2.263736 | 5.22923016 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 109 | 7.020000000000001e-26 | NR | MFA6353762.1 | 2053589 | g144884 | i0 | 74 | 1 | 77 | 20 | 100 | 0 | 1 | 231 | 457 | 533 | MFA6353762.1 DNA primase [Candidatus Paceibacterota bacterium] | diamond | 231 | 109 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31138140 | 31138140 | PRJEB10140_P_NODE_183755_length_209_cov_1.200000_g166446_i0 | PRJEB10140 | 183755 | 209 | 1.2 | 2.508 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 42.7 | 0.0124 | NR | MFA5131881.1 | 2053589 | g166446 | i0 | 33.9 | 0.84688995215311 | 59 | 39 | 84.7 | 0 | 206 | 30 | 88 | 146 | MFA5131881.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 177 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31454825 | 31454825 | PRJEB10140_P_NODE_61336_length_598_cov_0.967213_g44547_i0 | PRJEB10140 | 61336 | 598 | 0.967213 | 5.78393374 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 206 | 9.41e-65 | NR | MCF7865422.1 | 2053589 | g44547 | i0 | 71.3 | 1.93645484949833 | 129 | 37 | 64.7 | 0 | 597 | 211 | 18 | 146 | MCF7865422.1 DUF5069 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 1158 | 206 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32309184 | 32309184 | PRJEB10140_P_NODE_240919_length_171_cov_1.270492_g223610_i0 | PRJEB10140 | 240919 | 171 | 1.270492 | 2.17254132 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 81.3 | 3.48e-16 | NR | MEZ0209001.1 | 2053589 | g223610 | i0 | 66.7 | 1 | 57 | 19 | 100 | 0 | 1 | 171 | 120 | 176 | MEZ0209001.1 lytic murein transglycosylase [Candidatus Paceibacterota bacterium] | diamond | 171 | 81.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32556287 | 32556287 | PRJEB10140_P_NODE_66639_length_551_cov_2.217131_g49624_i0 | PRJEB10140 | 66639 | 551 | 2.217131 | 12.21639181 | Bacteria | 2 | Bacteria | Bacteria | 244 | 6.740000000000001e-79 | NR | MBP6888232.1 | 2053589 | g49624 | i0 | 69.3 | 2.84210526315789 | 176 | 54 | 95.8 | 0 | 14 | 541 | 2 | 177 | MBP6888232.1 ABC transporter ATP-binding protein [Candidatus Paceibacterota bacterium] | diamond | 1566 | 244 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;