contig_metadata
15 rows where bioproject = "PRJNA980587", tax_clade = "Bacteria candidate phyla" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3506701 | 3506701 | PRJNA980587_P_NODE_81703_length_249_cov_0.875000_g80910_i0 | PRJNA980587 | 81703 | 249 | 0.875 | 2.17875 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 144 | 1.52e-41 | NR | HDJ22686.1 | 2052149 | g80910 | i0 | 74.7 | 6 | 83 | 21 | 100 | 0 | 249 | 1 | 6 | 88 | HDJ22686.1 NAD-dependent epimerase/dehydratase family protein [Candidatus Aminicenantes bacterium] | diamond | 1494 | 144 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 11159764 | 11159764 | PRJNA980587_P_NODE_93209_length_242_cov_0.911243_g92416_i0 | PRJNA980587 | 93209 | 242 | 0.911243 | 2.20520806 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 120 | 5.17e-31 | NR | MFC1598622.1 | 2052139 | g92416 | i0 | 70.9 | 6.9297520661157 | 79 | 23 | 97.9 | 0 | 240 | 4 | 73 | 151 | MFC1598622.1 ribose-phosphate pyrophosphokinase-like domain-containing protein [Patescibacteria group bacterium] | diamond | 1677 | 120 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 26715355 | 26715355 | PRJNA980587_P_NODE_39741_length_370_cov_2.020202_g38948_i0 | PRJNA980587 | 39741 | 370 | 2.020202 | 7.4747474 | Bacteria | 2 | Bacteria | Bacteria | 52 | 6.99e-5 | NR | OGL39352.1 | 1817876 | g38948 | i0 | 35.8 | 2.53783783783784 | 120 | 68 | 94.9 | 5 | 353 | 3 | 3 | 116 | OGL39352.1 MAG: hypothetical protein A2042_04910, partial [Candidatus Schekmanbacteria bacterium GWA2_38_11] | diamond | 939 | 52.4 | 0.99236641221374 | Bacteria | Bacteria candidate phyla | Candidatus Schekmaniibacteriota | Candidatus Schekmanbacteria bacterium GWA2_38_11 | ||||||
| 28321057 | 28321057 | PRJNA980587_P_NODE_79546_length_250_cov_2.559322_g78753_i0 | PRJNA980587 | 79546 | 250 | 2.559322 | 6.398305 | Candidatus Peregrinibacteria bacterium GW2 | 2030811 | Bacteria | Bacteria | 60.5 | 2.28e-8 | NR | KKP37541.1 | 1619065 | g78753 | i0 | 43.4 | 0.912 | 76 | 38 | 87.6 | 2 | 31 | 249 | 241 | 314 | KKP37541.1 MAG: leucyl aminopeptidase, leucyl aminopeptidase [Candidatus Peregrinibacteria bacterium GW2011_GWF2_33_10] | diamond | 228 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium GW2011_GWF2_33_10 | ||||||
| 29615320 | 29615320 | PRJNA980587_P_NODE_29290_length_447_cov_3.058824_g28497_i0 | PRJNA980587 | 29290 | 447 | 3.058824 | 13.67294328 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 55.1 | 1.73e-5 | NR | MBU0625772.1 | 2052139 | g28497 | i0 | 55.3 | 0.912751677852349 | 47 | 20 | 31.5 | 1 | 159 | 299 | 403 | 448 | MBU0625772.1 DUF4215 domain-containing protein [Patescibacteria group bacterium] | diamond | 408 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29741686 | 29741686 | PRJNA980587_P_NODE_58530_length_298_cov_1.142222_g57737_i0 | PRJNA980587 | 58530 | 298 | 1.142222 | 3.40382156 | Candidatus Terrybacteria bacterium RIFCSPHIGHO2_ | 2750081 | Bacteria | Bacteria | 68.9 | 4.36e-11 | NR | OHA48673.1 | 1802363 | g57737 | i0 | 48.3 | 0.895973154362416 | 89 | 37 | 89.6 | 3 | 268 | 2 | 419 | 498 | OHA48673.1 MAG: glutaminyl-tRNA synthase (glutamine-hydrolyzing) subunit A [Candidatus Terrybacteria bacterium RIFCSPHIGHO2_01_FULL_58_15] | diamond | 267 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Terryibacteriota | Candidatus Terrybacteria bacterium RIFCSPHIGHO2_01_FULL_58_15 | ||||||
| 30057674 | 30057674 | PRJNA980587_P_NODE_71391_length_266_cov_2.388601_g70598_i0 | PRJNA980587 | 71391 | 266 | 2.388601 | 6.35367866 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 51.6 | 3.74e-5 | NR | MCL4375092.1 | 2052139 | g70598 | i0 | 32.1 | 1.77067669172932 | 84 | 56 | 93.6 | 1 | 8 | 256 | 326 | 409 | MCL4375092.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 471 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30215633 | 30215633 | PRJNA980587_P_NODE_24252_length_505_cov_1.425926_g23461_i0 | PRJNA980587 | 24252 | 505 | 1.425926 | 7.2009263 | Candidatus Dependentiae bacterium | 2030827 | Bacteria | Bacteria | 92 | 4.01e-19 | NR | RTL06913.1 | 2030827 | g23461 | i0 | 44.7 | 0.611881188118812 | 103 | 57 | 61.2 | 0 | 315 | 7 | 27 | 129 | RTL06913.1 MAG: hypothetical protein EKK58_03715 [Candidatus Dependentiae bacterium] | diamond | 309 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 30980380 | 30980380 | PRJNA980587_P_NODE_80314_length_250_cov_0.870056_g79521_i0 | PRJNA980587 | 80314 | 250 | 0.870056 | 2.17514 | Bacteria | 2 | Bacteria | Bacteria | 88.6 | 1.59e-19 | NR | KKW04846.1 | 1619071 | g79521 | i0 | 75.5 | 6.552 | 53 | 13 | 63.6 | 0 | 1 | 159 | 155 | 207 | KKW04846.1 MAG: tRNA (guanine-N(7)-)-methyltransferase [Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9] | diamond | 1638 | 88.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Saccharimonadota | Candidatus Saccharibacteria bacterium GW2011_GWC2_48_9 | ||||||
| 31043690 | 31043690 | PRJNA980587_P_NODE_18315_length_603_cov_1.860377_g17534_i0 | PRJNA980587 | 18315 | 603 | 1.860377 | 11.21807331 | Bacteria | 2 | Bacteria | Bacteria | 66.2 | 8.63e-9 | NR | HQF41170.1 | 2053589 | g17534 | i0 | 28.8 | 1.8955223880597 | 208 | 101 | 94.5 | 8 | 576 | 7 | 316 | 494 | HQF41170.1 Ig-like domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 1143 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31043700 | 31043700 | PRJNA980587_P_NODE_92175_length_243_cov_0.905882_g91382_i0 | PRJNA980587 | 92175 | 243 | 0.905882 | 2.20129326 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 104 | 1.3e-25 | NR | MEK7144983.1 | 2052139 | g91382 | i0 | 67.1 | 2.79012345679012 | 70 | 23 | 86.4 | 0 | 211 | 2 | 125 | 194 | MEK7144983.1 HNH endonuclease [Patescibacteria group bacterium] | diamond | 678 | 104 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31480187 | 31480187 | PRJNA980587_P_NODE_47196_length_336_cov_1.091255_g46403_i0 | PRJNA980587 | 47196 | 336 | 1.091255 | 3.6666168 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 47 | 5.88e-4 | NR | MCL4419714.1 | 2052139 | g46403 | i0 | 60.5 | 0.339285714285714 | 38 | 15 | 33.9 | 0 | 177 | 64 | 28 | 65 | MCL4419714.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 114 | 47 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31922706 | 31922706 | PRJNA980587_P_NODE_53337_length_314_cov_1.253112_g52544_i0 | PRJNA980587 | 53337 | 314 | 1.253112 | 3.93477168 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 77.8 | 2.03e-15 | NR | MCL4418492.1 | 2052139 | g52544 | i0 | 69.1 | 0.525477707006369 | 55 | 17 | 52.5 | 0 | 2 | 166 | 93 | 147 | MCL4418492.1 alpha-hydroxy-acid oxidizing protein [Patescibacteria group bacterium] | diamond | 165 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32334360 | 32334360 | PRJNA980587_P_NODE_79179_length_251_cov_0.865169_g78386_i0 | PRJNA980587 | 79179 | 251 | 0.865169 | 2.17157419 | Candidatus Colwellbacteria bacterium | 2750074 | Bacteria | Bacteria | 66.2 | 2.4e-11 | NR | MDD4931421.1 | 2750074 | g78386 | i0 | 70.2 | 1.63745019920319 | 47 | 14 | 56.2 | 0 | 142 | 2 | 32 | 78 | MDD4931421.1 hypothetical protein [Candidatus Colwellbacteria bacterium] | diamond | 411 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Colwelliibacteriota | Candidatus Colwellbacteria bacterium | ||||||
| 32397497 | 32397497 | PRJNA980587_P_NODE_84079_length_248_cov_0.880000_g83286_i0 | PRJNA980587 | 84079 | 248 | 0.88 | 2.1824 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 50.8 | 3.06e-6 | NR | MCL4419717.1 | 2052139 | g83286 | i0 | 87.5 | 0.387096774193548 | 32 | 4 | 38.7 | 0 | 240 | 145 | 4 | 35 | MCL4419717.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 96 | 50.8 | 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);;