contig_metadata
16 rows where bioproject = "PRJEB10320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13492 | 13492 | PRJEB10320_P_NODE_11441_length_284_cov_1.377510_g11183_i0 | PRJEB10320 | 11441 | 284 | 1.37751 | 3.9121284 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 396 | 1.05e-105 | NTclustered | gi|2621785934|emb|OY782392.1| | 2052139 | g11183 | i0 | 91.873 | 119.401408450704 | 283 | 23 | 99 | 0 | 2 | 284 | 427950 | 427668 | MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1 | blastn | 33910 | 396 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 2563416 | 2563416 | PRJEB10320_P_NODE_22943_length_174_cov_1.971223_g22685_i0 | PRJEB10320 | 22943 | 174 | 1.971223 | 3.42992802 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 294 | 2.1999999999999998e-75 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g22685 | i0 | 97.126 | 17.9195402298851 | 174 | 5 | 100 | 0 | 1 | 174 | 890776 | 890603 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 3118 | 294 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 21690157 | 21690157 | PRJEB10320_P_NODE_20358_length_190_cov_1.709677_g20100_i0 | PRJEB10320 | 20358 | 190 | 1.709677 | 3.2483863 | Candidatus Gracilibacteria bacterium HOT-871 | 1540872 | Bacteria | Bacteria | 213 | 7.08e-51 | NTclustered | gi|1275383184|gb|CP017714.1| | 1540872 | g20100 | i0 | 86.842 | 62.8526315789474 | 190 | 25 | 100 | 0 | 1 | 190 | 890000 | 890189 | Candidatus Gracilibacteria bacterium HOT-871, complete genome | blastn | 11942 | 213 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium HOT-871 | ||||||
| 26969348 | 26969348 | PRJEB10320_P_NODE_1402_length_883_cov_2.783019_g1253_i0 | PRJEB10320 | 1402 | 883 | 2.783019 | 24.57405777 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 85.9 | 1.26e-14 | NR | HVX00123.1 | 2545253 | g1253 | i0 | 45.7 | 0.319365798414496 | 94 | 46 | 30.9 | 3 | 4 | 276 | 611 | 702 | HVX00123.1 RNase H-like domain-containing protein [Candidatus Babeliaceae bacterium] | diamond | 282 | 85.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 28485551 | 28485551 | PRJEB10320_P_NODE_14587_length_240_cov_1.912195_g14329_i0 | PRJEB10320 | 14587 | 240 | 1.912195 | 4.589268 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 85.1 | 4.36e-17 | NR | MEZ0208637.1 | 2053589 | g14329 | i0 | 59.2 | 1.8875 | 76 | 31 | 95 | 0 | 8 | 235 | 1285 | 1360 | MEZ0208637.1 RNase H-like domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 453 | 85.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28580330 | 28580330 | PRJEB10320_P_NODE_21807_length_181_cov_1.417808_g21549_i0 | PRJEB10320 | 21807 | 181 | 1.417808 | 2.56623248 | Candidatus Babeliales bacterium | 2803731 | Bacteria | Bacteria | 68.2 | 1.69e-11 | NR | MEX0940507.1 | 2803731 | g21549 | i0 | 59.6 | 0.94475138121547 | 57 | 22 | 94.5 | 1 | 10 | 180 | 67 | 122 | MEX0940507.1 histone deacetylase [Candidatus Babeliales bacterium] | diamond | 171 | 68.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliales bacterium | |||||
| 28927539 | 28927539 | PRJEB10320_P_NODE_27588_length_153_cov_2.033898_g27330_i0 | PRJEB10320 | 27588 | 153 | 2.033898 | 3.11186394 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 60.5 | 5.92e-9 | NR | HVX00491.1 | 2545253 | g27330 | i0 | 61.9 | 1.64705882352941 | 42 | 16 | 82.4 | 0 | 17 | 142 | 19 | 60 | HVX00491.1 RNase H-like domain-containing protein [Candidatus Babeliaceae bacterium] | diamond | 252 | 60.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 28953282 | 28953282 | PRJEB10320_P_NODE_15508_length_230_cov_1.523077_g15250_i0 | PRJEB10320 | 15508 | 230 | 1.523077 | 3.5030771 | Bacillati | 1783272 | Bacteria | Bacteria | 41.6 | 0.0367 | NR | KKR90616.1 | 1618593 | g15250 | i0 | 55.6 | 1.47391304347826 | 36 | 16 | 47 | 0 | 34 | 141 | 9 | 44 | KKR90616.1 MAG: 50S ribosomal protein L7/L12 [Candidatus Woesebacteria bacterium GW2011_GWD1_41_12] | diamond | 339 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Woeseibacteriota | Candidatus Woesebacteria bacterium GW2011_GWD1_41_12 | ||||||
| 29527525 | 29527525 | PRJEB10320_P_NODE_18930_length_200_cov_1.454545_g18672_i0 | PRJEB10320 | 18930 | 200 | 1.454545 | 2.90909 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 41.6 | 0.0402 | NR | NLD25205.1 | 2099670 | g18672 | i0 | 50 | 0.54 | 36 | 18 | 54 | 0 | 3 | 110 | 30 | 65 | NLD25205.1 DUF4116 domain-containing protein [Candidatus Dojkabacteria bacterium] | diamond | 108 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 29906520 | 29906520 | PRJEB10320_P_NODE_13131_length_259_cov_1.116071_g12873_i0 | PRJEB10320 | 13131 | 259 | 1.116071 | 2.89062389 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 58.9 | 9.24e-8 | NR | MCL4419262.1 | 2052139 | g12873 | i0 | 69.4 | 0.416988416988417 | 36 | 11 | 41.7 | 0 | 1 | 108 | 114 | 149 | MCL4419262.1 hypothetical protein [Patescibacteria group bacterium] | diamond | 108 | 58.9 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 29969517 | 29969517 | PRJEB10320_P_NODE_6091_length_423_cov_3.340206_g5840_i0 | PRJEB10320 | 6091 | 423 | 3.340206 | 14.12907138 | Candidatus Babeliaceae bacterium | 2545253 | Bacteria | Bacteria | 155 | 7.19e-42 | NR | HVW99438.1 | 2545253 | g5840 | i0 | 51.8 | 1.97163120567376 | 139 | 67 | 98.6 | 0 | 421 | 5 | 196 | 334 | HVW99438.1 DDE-type integrase/transposase/recombinase [Candidatus Babeliaceae bacterium] | diamond | 834 | 155 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babeliae | Candidatus Babeliales | Candidatus Babeliaceae | Candidatus Babeliaceae bacterium | ||||
| 29995209 | 29995209 | PRJEB10320_P_NODE_9451_length_321_cov_2.255245_g9193_i0 | PRJEB10320 | 9451 | 321 | 2.255245 | 7.23933645 | Bacteria | 2 | Bacteria | Bacteria | 60.1 | 2.88e-8 | NR | MEK7066353.1 | 2052139 | g9193 | i0 | 39.8 | 2.01869158878505 | 108 | 52 | 97.2 | 2 | 312 | 1 | 76 | 174 | MEK7066353.1 sigma-70 family RNA polymerase sigma factor [Patescibacteria group bacterium] | diamond | 648 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31353848 | 31353848 | PRJEB10320_P_NODE_2896_length_629_cov_3.968013_g2687_i0 | PRJEB10320 | 2896 | 629 | 3.968013 | 24.95880177 | Bacteria | 2 | Bacteria | Bacteria | 114 | 4.31e-28 | NR | MCT4592035.1 | 2044595 | g2687 | i0 | 39.5 | 1.38314785373609 | 147 | 86 | 69.6 | 2 | 543 | 106 | 4 | 148 | MCT4592035.1 NAD(P)H-dependent oxidoreductase [Candidatus Altimarinota bacterium] | diamond | 870 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 31360089 | 31360089 | PRJEB10320_P_NODE_22696_length_176_cov_1.134752_g22438_i0 | PRJEB10320 | 22696 | 176 | 1.134752 | 1.99716352 | Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_12_FULL_5 | 2053521 | Bacteria | Bacteria | 65.1 | 3.78e-11 | NR | OGD62259.1 | 1797470 | g22438 | i0 | 58 | 0.852272727272727 | 50 | 21 | 85.2 | 0 | 22 | 171 | 122 | 171 | OGD62259.1 MAG: 50S ribosomal protein L6 [Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_12_FULL_50_11] | diamond | 150 | 65.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Berkelbacteria | Candidatus Berkelbacteria bacterium RIFCSPHIGHO2_12_FULL_50_11 | ||||||
| 32119261 | 32119261 | PRJEB10320_P_NODE_28138_length_152_cov_0.923077_g27880_i0 | PRJEB10320 | 28138 | 152 | 0.923077 | 1.40307704 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 45.4 | 0.0012 | NR | MCX6714917.1 | 2053634 | g27880 | i0 | 63 | 2.05263157894737 | 27 | 10 | 53.3 | 0 | 7 | 87 | 483 | 509 | MCX6714917.1 hypothetical protein [Candidatus Uhrbacteria bacterium] | diamond | 312 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 32751064 | 32751064 | PRJEB10320_P_NODE_13280_length_257_cov_1.788288_g13022_i0 | PRJEB10320 | 13280 | 257 | 1.788288 | 4.59590016 | Candidatus Binatus sp. | 2811406 | Bacteria | Bacteria | 50.8 | 4.2e-5 | NR | HSV07951.1 | 2811406 | g13022 | i0 | 54.1 | 0.431906614785992 | 37 | 17 | 43.2 | 0 | 255 | 145 | 84 | 120 | HSV07951.1 hypothetical protein [Candidatus Binatus sp.] | diamond | 111 | 50.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binatus | Candidatus Binatus sp. |
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);;