contig_metadata
10 rows where bioproject = "PRJNA494251", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Altimarinota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17052784 | 17052784 | PRJNA494251_P_NODE_4074_length_623_cov_2.487273_g3784_i0 | PRJNA494251 | 4074 | 623 | 2.487273 | 15.49571079 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 348 | 7.040000000000001e-91 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g3784 | i0 | 79.487 | 20.0417335473515 | 507 | 90 | 80 | 13 | 95 | 594 | 1165738 | 1165239 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 12486 | 348 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 18327287 | 18327287 | PRJNA494251_P_NODE_8535_length_452_cov_2.722955_g8231_i0 | PRJNA494251 | 8535 | 452 | 2.722955 | 12.3077566 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 176 | 1.21e-48 | NR | MBW7954625.1 | 2044595 | g8231 | i0 | 91.5 | 2.49557522123894 | 94 | 8 | 62.4 | 0 | 3 | 284 | 100 | 193 | MBW7954625.1 molecular chaperone DnaK [Candidatus Altimarinota bacterium] | diamond | 1128 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 19601402 | 19601402 | PRJNA494251_P_NODE_44576_length_245_cov_0.895349_g44262_i0 | PRJNA494251 | 44576 | 245 | 0.895349 | 2.19360505 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 281 | 2.59e-71 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g44262 | i0 | 88.745 | 4.64081632653061 | 231 | 24 | 94 | 2 | 1 | 231 | 1252129 | 1251901 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 1137 | 281 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20877199 | 20877199 | PRJNA494251_P_NODE_38157_length_250_cov_0.870056_g37843_i0 | PRJNA494251 | 38157 | 250 | 0.870056 | 2.17514 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 137 | 6.08e-28 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g37843 | i0 | 81.25 | 1.412 | 176 | 28 | 69 | 5 | 1 | 172 | 174077 | 174251 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 353 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20877296 | 20877296 | PRJNA494251_P_NODE_46557_length_243_cov_1.352941_g46243_i0 | PRJNA494251 | 46557 | 243 | 1.352941 | 3.28764663 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 107 | 1.08e-25 | NR | MCH2188740.1 | 2044595 | g46243 | i0 | 72.5 | 0.987654320987654 | 80 | 21 | 98.8 | 1 | 2 | 241 | 130 | 208 | MCH2188740.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 240 | 107 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29224547 | 29224547 | PRJNA494251_P_NODE_17909_length_332_cov_1.486486_g17595_i0 | PRJNA494251 | 17909 | 332 | 1.486486 | 4.93513352 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 101 | 7.57e-23 | NR | MDD4151141.1 | 2044595 | g17595 | i0 | 50 | 0.921686746987952 | 102 | 48 | 90.4 | 3 | 5 | 304 | 53 | 153 | MDD4151141.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 306 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 29697470 | 29697470 | PRJNA494251_P_NODE_29630_length_273_cov_1.540000_g29316_i0 | PRJNA494251 | 29630 | 273 | 1.54 | 4.2042 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 65.9 | 3.88e-10 | NR | MDD3120228.1 | 2044595 | g29316 | i0 | 50 | 0.725274725274725 | 66 | 33 | 72.5 | 0 | 3 | 200 | 591 | 656 | MDD3120228.1 efflux RND transporter periplasmic adaptor subunit [Candidatus Altimarinota bacterium] | diamond | 198 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31277537 | 31277537 | PRJNA494251_P_NODE_2535_length_761_cov_2.706395_g2275_i0 | PRJNA494251 | 2535 | 761 | 2.706395 | 20.59566595 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 62 | 3.89e-7 | NR | MDD5770230.1 | 2044595 | g2275 | i0 | 42.2 | 0.327201051248357 | 83 | 46 | 32.3 | 2 | 262 | 17 | 236 | 317 | MDD5770230.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 249 | 62 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31530877 | 31530877 | PRJNA494251_P_NODE_36596_length_251_cov_1.966292_g36282_i0 | PRJNA494251 | 36596 | 251 | 1.966292 | 4.93539292 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 45.1 | 0.00631 | NR | MDD3067177.1 | 2044595 | g36282 | i0 | 40.7 | 0.705179282868526 | 59 | 34 | 70.5 | 1 | 246 | 70 | 17 | 74 | MDD3067177.1 hypothetical protein [Candidatus Altimarinota bacterium] | diamond | 177 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32637368 | 32637368 | PRJNA494251_P_NODE_34580_length_257_cov_1.668478_g34266_i0 | PRJNA494251 | 34580 | 257 | 1.668478 | 4.28798846 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 101 | 6.1e-23 | NR | MBW7954407.1 | 2044595 | g34266 | i0 | 56.5 | 0.992217898832685 | 85 | 37 | 99.2 | 0 | 255 | 1 | 405 | 489 | MBW7954407.1 peptidylprolyl isomerase [Candidatus Altimarinota bacterium] | diamond | 255 | 101 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota 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);;