contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJEB50332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20520435 | 20520435 | PRJEB50332_P_NODE_9717_length_226_cov_1.466667_g9635_i0 | PRJEB50332 | 9717 | 226 | 1.466667 | 3.31466742 | Bacteria | 2 | Bacteria | Bacteria | 103 | 3.5399999999999995e-24 | NR | OGG00794.1 | 1817867 | g9635 | i0 | 59.2 | 6.73008849557522 | 71 | 29 | 94.2 | 0 | 5 | 217 | 265 | 335 | OGG00794.1 MAG: hypothetical protein A3F83_02335 [Candidatus Glassbacteria bacterium RIFCSPLOWO2_12_FULL_58_11] | diamond | 1521 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Glassiibacteriota | Candidatus Glassbacteria bacterium RIFCSPLOWO2_12_FULL_58_11 | ||||||
| 26812066 | 26812066 | PRJEB50332_P_NODE_3741_length_304_cov_2.181070_g3659_i0 | PRJEB50332 | 3741 | 304 | 2.18107 | 6.6304528 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 152 | 4.08e-41 | NR | MCL4419431.1 | 2052139 | g3659 | i0 | 80.6 | 0.917763157894737 | 93 | 17 | 90.8 | 1 | 303 | 28 | 495 | 587 | MCL4419431.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 279 | 152 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27318158 | 27318158 | PRJEB50332_P_NODE_9003_length_230_cov_1.497041_g8921_i0 | PRJEB50332 | 9003 | 230 | 1.497041 | 3.4431943 | Candidatus Saccharimonadota bacterium | 2026720 | Bacteria | Bacteria | 52.4 | 1.01e-5 | NR | MCA9324640.1 | 2026720 | g8921 | i0 | 41.9 | 0.965217391304348 | 74 | 36 | 95.2 | 4 | 3 | 221 | 57 | 124 | MCA9324640.1 hypothetical protein [Candidatus Saccharibacteria bacterium] | diamond | 222 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadota bacterium | ||||||
| 27381377 | 27381377 | PRJEB50332_P_NODE_123_length_1358_cov_9.097147_g91_i0 | PRJEB50332 | 123 | 1358 | 9.097147 | 123.53925626 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 90.9 | 1.55e-16 | NR | RTL06913.1 | 2030827 | g91 | i0 | 39.7 | 0.278350515463918 | 126 | 75 | 27.6 | 1 | 196 | 570 | 27 | 152 | RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium] | diamond | 378 | 90.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 27437903 | 27437903 | PRJEB50332_P_NODE_17823_length_202_cov_0.921986_g17741_i0 | PRJEB50332 | 17823 | 202 | 0.921986 | 1.86241172 | Bacteria | 2 | Bacteria | Bacteria | 126 | 2.12e-33 | NR | OJU87599.1 | 1895829 | g17741 | i0 | 95.5 | 3.98019801980198 | 67 | 3 | 99.5 | 0 | 202 | 2 | 120 | 186 | OJU87599.1 MAG: type I glyceraldehyde-3-phosphate dehydrogenase [Candidatus Saccharibacteria bacterium 49-20] | diamond | 804 | 127 | 0.992125984251969 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium 49-20 | ||||||
| 27665570 | 27665570 | PRJEB50332_P_NODE_12704_length_211_cov_0.866667_g12622_i0 | PRJEB50332 | 12704 | 211 | 0.866667 | 1.82866737 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 71.2 | 2.19e-12 | NR | MDR3548433.1 | 2053589 | g12622 | i0 | 50.7 | 1.97630331753555 | 69 | 33 | 98.1 | 1 | 207 | 1 | 118 | 185 | MDR3548433.1 HAD-IC family P-type ATPase [Candidatus Paceibacterota bacterium] | diamond | 417 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27760433 | 27760433 | PRJEB50332_P_NODE_284_length_951_cov_3.723596_g236_i0 | PRJEB50332 | 284 | 951 | 3.723596 | 35.41139796 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 137 | 1.2e-34 | NR | RTL06913.1 | 2030827 | g236 | i0 | 35.8 | 0.712933753943218 | 226 | 138 | 70 | 3 | 144 | 809 | 15 | 237 | RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium] | diamond | 678 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 27917894 | 27917894 | PRJEB50332_P_NODE_9985_length_224_cov_2.085890_g9903_i0 | PRJEB50332 | 9985 | 224 | 2.08589 | 4.6723936 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.9 | 0.0116 | NR | HRY51239.1 | 2053589 | g9903 | i0 | 39.1 | 2.49107142857143 | 64 | 35 | 80.4 | 1 | 2 | 181 | 49 | 112 | HRY51239.1 PQQ-binding-like beta-propeller repeat protein [Candidatus Paceibacterota bacterium] | diamond | 558 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29212700 | 29212700 | PRJEB50332_P_NODE_1049_length_529_cov_2.401709_g969_i0 | PRJEB50332 | 1049 | 529 | 2.401709 | 12.70504061 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 55.1 | 2.82e-5 | NR | RTL06914.1 | 2030827 | g969 | i0 | 44.6 | 0.31758034026465 | 56 | 31 | 31.8 | 0 | 1 | 168 | 365 | 420 | RTL06914.1 MAG: hypothetical protein EKK58_03720 [Candidatus Dependentiae bacterium] | diamond | 168 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 29244147 | 29244147 | PRJEB50332_P_NODE_429_length_806_cov_2.259060_g368_i0 | PRJEB50332 | 429 | 806 | 2.25906 | 18.2080236 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 113 | 4.33e-26 | NR | RTL06913.1 | 2030827 | g368 | i0 | 30.9 | 0.807692307692308 | 217 | 149 | 80.8 | 1 | 744 | 94 | 27 | 242 | RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium] | diamond | 651 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 29244151 | 29244151 | PRJEB50332_P_NODE_8609_length_232_cov_1.982456_g8527_i0 | PRJEB50332 | 8609 | 232 | 1.982456 | 4.59929792 | Candidatus Saccharimonas sp. | 1917697 | Bacteria | Bacteria | 144 | 5.19e-38 | NR | RKW02477.1 | 1917697 | g8527 | i0 | 98.7 | 0.982758620689655 | 76 | 1 | 98.3 | 0 | 3 | 230 | 254 | 329 | RKW02477.1 MAG: ATP-dependent DNA helicase RecG [Candidatus Saccharimonas sp.] | diamond | 228 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharimonadia | Candidatus Saccharimonadales | Candidatus Saccharimonadaceae | Candidatus Saccharimonas | Candidatus Saccharimonas sp. | ||
| 31202108 | 31202108 | PRJEB50332_P_NODE_5535_length_262_cov_2.298507_g5453_i0 | PRJEB50332 | 5535 | 262 | 2.298507 | 6.02208834 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 87 | 1.24e-17 | NR | MBY0538658.1 | 2052139 | g5453 | i0 | 100 | 0.480916030534351 | 42 | 0 | 48.1 | 0 | 126 | 1 | 202 | 243 | MBY0538658.1 ATP-dependent DNA helicase RecG [Patescibacteria group bacterium] | diamond | 126 | 87 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31423943 | 31423943 | PRJEB50332_P_NODE_11056_length_218_cov_2.273885_g10974_i0 | PRJEB50332 | 11056 | 218 | 2.273885 | 4.9570693 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 124 | 5.66e-32 | NR | MCL4419852.1 | 2052139 | g10974 | i0 | 79.2 | 0.990825688073395 | 72 | 15 | 99.1 | 0 | 216 | 1 | 258 | 329 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 216 | 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);;