contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA889065" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26960401 | 26960401 | PRJNA889065_S_NODE_31662_length_171_cov_1.078125_g31424_i0 | PRJNA889065 | 31662 | 171 | 1.078125 | 1.84359375 | Candidatus Peregrinibacteria bacterium GW2 | 2030811 | Bacteria | Bacteria | 43.9 | 0.00494 | NR | KKP37644.1 | 1619065 | g31424 | i0 | 41.3 | 0.807017543859649 | 46 | 27 | 80.7 | 0 | 25 | 162 | 168 | 213 | KKP37644.1 MAG: NusG antitermination factor, transcriptional antiterminator NusG [Candidatus Peregrinibacteria bacterium GW2011_GWF2_33_10] | diamond | 138 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium GW2011_GWF2_33_10 | ||||||
| 28097745 | 28097745 | PRJNA889065_S_NODE_9925_length_303_cov_4.634615_g9687_i0 | PRJNA889065 | 9925 | 303 | 4.634615 | 14.04288345 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 151 | 1.52e-40 | NR | MCL4419431.1 | 2052139 | g9687 | i0 | 82.2 | 0.891089108910891 | 90 | 15 | 88.1 | 1 | 300 | 34 | 498 | 587 | MCL4419431.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 270 | 151 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28792264 | 28792264 | PRJNA889065_S_NODE_26487_length_188_cov_3.455172_g26249_i0 | PRJNA889065 | 26487 | 188 | 3.455172 | 6.49572336 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 42 | 0.0322 | NR | MCA9352618.1 | 2052139 | g26249 | i0 | 35.5 | 0.98936170212766 | 62 | 38 | 97.3 | 2 | 183 | 1 | 127 | 187 | MCA9352618.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 186 | 42 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 28800045 | 28800045 | PRJNA889065_S_NODE_5367_length_406_cov_1.842975_g5129_i0 | PRJNA889065 | 5367 | 406 | 1.842975 | 7.4824785 | Bacteria | 2 | Bacteria | Bacteria | 84 | 4.36e-16 | NR | MBU0531484.1 | 2052139 | g5129 | i0 | 43.2 | 9.05172413793103 | 111 | 58 | 82 | 2 | 404 | 72 | 246 | 351 | MBU0531484.1 peptide chain release factor 1 [Patescibacteria group bacterium] | diamond | 3675 | 84.7 | 0.991735537190083 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29297634 | 29297634 | PRJNA889065_S_NODE_20649_length_214_cov_2.152047_g20411_i0 | PRJNA889065 | 20649 | 214 | 2.152047 | 4.60538058 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 45.1 | 3.83e-4 | NR | MDE1971439.1 | 2052139 | g20411 | i0 | 33.3 | 0.672897196261682 | 48 | 32 | 67.3 | 0 | 185 | 42 | 9 | 56 | MDE1971439.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 144 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30055357 | 30055357 | PRJNA889065_S_NODE_22091_length_207_cov_1.682927_g21853_i0 | PRJNA889065 | 22091 | 207 | 1.682927 | 3.48365889 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 50.1 | 3.6e-5 | NR | MFS8160316.1 | 2282149 | g21853 | i0 | 38.8 | 2.94202898550725 | 67 | 36 | 97.1 | 2 | 2 | 202 | 134 | 195 | MFS8160316.1 WD40 repeat domain-containing protein [Candidatus Roizmanbacteria bacterium] | diamond | 609 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 31414357 | 31414357 | PRJNA889065_S_NODE_22936_length_203_cov_1.725000_g22698_i0 | PRJNA889065 | 22936 | 203 | 1.725 | 3.50175 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 67.4 | 8.6e-13 | NR | RTL06915.1 | 2030827 | g22698 | i0 | 65.2 | 0.679802955665025 | 46 | 16 | 68 | 0 | 156 | 19 | 37 | 82 | RTL06915.1 MAG: hypothetical protein EKK58_03725 [Candidatus Dependentiae bacterium] | diamond | 138 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 31445991 | 31445991 | PRJNA889065_S_NODE_34476_length_163_cov_1.150000_g34238_i0 | PRJNA889065 | 34476 | 163 | 1.15 | 1.8745 | Candidatus Eiseniibacteriota bacterium | 2212470 | Bacteria | Bacteria | 42 | 0.0232 | NR | MBU1702138.1 | 2212470 | g34238 | i0 | 52.9 | 2.13496932515337 | 34 | 16 | 62.6 | 0 | 108 | 7 | 2 | 35 | MBU1702138.1 acyl-CoA dehydrogenase family protein [Candidatus Eiseniibacteriota bacterium] | diamond | 348 | 42 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Eiseniibacteriota | Candidatus Eiseniibacteriota bacterium | ||||||
| 31762198 | 31762198 | PRJNA889065_S_NODE_13697_length_261_cov_2.137615_g13459_i0 | PRJNA889065 | 13697 | 261 | 2.137615 | 5.57917515 | Candidatus Daviesbacteria bacterium | 2053542 | Bacteria | Bacteria | 42.7 | 0.0479 | NR | MDD5416035.1 | 2053542 | g13459 | i0 | 35.8 | 0.770114942528736 | 67 | 33 | 77 | 2 | 4 | 204 | 130 | 186 | MDD5416035.1 IPT/TIG domain-containing protein [Candidatus Daviesbacteria bacterium] | diamond | 201 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Daviesiibacteriota | Candidatus Daviesbacteria bacterium | ||||||
| 31762220 | 31762220 | PRJNA889065_S_NODE_9977_length_303_cov_1.592308_g9739_i0 | PRJNA889065 | 9977 | 303 | 1.592308 | 4.82469324 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 44.3 | 0.0214 | NR | HYE10182.1 | 2052139 | g9739 | i0 | 37.2 | 0.772277227722772 | 78 | 47 | 75.2 | 1 | 239 | 12 | 245 | 322 | HYE10182.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 234 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32015342 | 32015342 | PRJNA889065_S_NODE_26758_length_187_cov_2.722222_g26520_i0 | PRJNA889065 | 26758 | 187 | 2.722222 | 5.09055514 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 48.1 | 2.25e-4 | NR | HLC41421.1 | 2072417 | g26520 | i0 | 45 | 0.962566844919786 | 60 | 27 | 96.3 | 1 | 183 | 4 | 453 | 506 | HLC41421.1 M1 family metallopeptidase [Candidatus Methylomirabilota bacterium] | diamond | 180 | 48.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 32300501 | 32300501 | PRJNA889065_S_NODE_6859_length_361_cov_2.509434_g6621_i0 | PRJNA889065 | 6859 | 361 | 2.509434 | 9.05905674 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 124 | 2.66e-31 | NR | MCL4419852.1 | 2052139 | g6621 | i0 | 83.1 | 0.590027700831025 | 71 | 12 | 59 | 0 | 3 | 215 | 331 | 401 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 213 | 124 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group 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);;