contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Staskawicziibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27165414 | 27165414 | PRJNA1148190_P_NODE_178762_length_395_cov_1.850932_g167593_i0 | PRJNA1148190 | 178762 | 395 | 1.850932 | 7.3111814 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 109 | 3.31e-27 | NR | MFA6190665.1 | 2053617 | g167593 | i0 | 78.6 | 0.425316455696203 | 56 | 12 | 42.5 | 0 | 227 | 394 | 22 | 77 | MFA6190665.1 hypothetical protein [Candidatus Staskawiczbacteria bacterium] | diamond | 168 | 109 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 27766900 | 27766900 | PRJNA1148190_P_NODE_723504_length_244_cov_0.900585_g712331_i0 | PRJNA1148190 | 723504 | 244 | 0.900585 | 2.1974274 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 77.8 | 3.05e-15 | NR | MSU54477.1 | 2053617 | g712331 | i0 | 48.8 | 0.983606557377049 | 80 | 41 | 98.4 | 0 | 5 | 244 | 81 | 160 | MSU54477.1 hypothetical protein [Candidatus Staskawiczbacteria bacterium] | diamond | 240 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 28018443 | 28018443 | PRJNA1148190_P_NODE_190185_length_385_cov_0.794872_g179015_i0 | PRJNA1148190 | 190185 | 385 | 0.794872 | 3.0602572 | Candidatus Staskawiczbacteria bacterium RIFOXYD2_FULL_37_1 | 2053617 | Bacteria | Bacteria | 161 | 6.0799999999999986e-43 | NR | OGZ93112.1 | 1802239 | g179015 | i0 | 60.2 | 0.997402597402597 | 128 | 51 | 99.7 | 0 | 385 | 2 | 183 | 310 | OGZ93112.1 MAG: hypothetical protein A2549_00380 [Candidatus Staskawiczbacteria bacterium RIFOXYD2_FULL_37_10] | diamond | 384 | 161 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFOXYD2_FULL_37_10 | ||||||
| 29219259 | 29219259 | PRJNA1148190_P_NODE_74269_length_641_cov_2.295775_g63163_i0 | PRJNA1148190 | 74269 | 641 | 2.295775 | 14.71591775 | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_ | 2053617 | Bacteria | Bacteria | 242 | 2.98e-75 | NR | OGZ69760.1 | 1802207 | g63163 | i0 | 55.9 | 0.996879875195008 | 213 | 91 | 99.7 | 2 | 2 | 640 | 50 | 259 | OGZ69760.1 MAG: hypothetical protein A3D44_04425 [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_02_FULL_42_22] | diamond | 639 | 242 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_02_FULL_42_22 | ||||||
| 29281864 | 29281864 | PRJNA1148190_P_NODE_628829_length_249_cov_0.875000_g617656_i0 | PRJNA1148190 | 628829 | 249 | 0.875 | 2.17875 | Candidatus Staskawiczbacteria bacterium RIFOXYD1_FULL_39_28 | 1802237 | Bacteria | Bacteria | 66.6 | 7.13e-11 | NR | OGZ91552.1 | 1802237 | g617656 | i0 | 44.9 | 0.939759036144578 | 78 | 35 | 94 | 1 | 246 | 13 | 183 | 252 | OGZ91552.1 MAG: hypothetical protein A2599_03765 [Candidatus Staskawiczbacteria bacterium RIFOXYD1_FULL_39_28] | diamond | 234 | 66.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFOXYD1_FULL_39_28 | ||||||
| 29364867 | 29364867 | PRJNA1148190_P_NODE_222729_length_360_cov_1.048780_g211559_i0 | PRJNA1148190 | 222729 | 360 | 1.04878 | 3.775608 | Bacillati | 1783272 | Bacteria | Bacteria | 147 | 1.43e-42 | NR | MBI1866395.1 | 2053617 | g211559 | i0 | 72.6 | 1.58333333333333 | 95 | 26 | 79.2 | 0 | 359 | 75 | 56 | 150 | MBI1866395.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Candidatus Staskawiczbacteria bacterium] | diamond | 570 | 148 | 0.993243243243243 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 29503117 | 29503117 | PRJNA1148190_P_NODE_728690_length_244_cov_0.900585_g717517_i0 | PRJNA1148190 | 728690 | 244 | 0.900585 | 2.1974274 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 81.6 | 7.85e-16 | NR | MCX6718450.1 | 2053617 | g717517 | i0 | 49.4 | 3.65163934426229 | 81 | 38 | 99.6 | 1 | 244 | 2 | 961 | 1038 | MCX6718450.1 FG-GAP-like repeat-containing protein [Candidatus Staskawiczbacteria bacterium] | diamond | 891 | 81.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 29534760 | 29534760 | PRJNA1148190_P_NODE_682990_length_246_cov_0.890173_g671817_i0 | PRJNA1148190 | 682990 | 246 | 0.890173 | 2.18982558 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 150 | 7.91e-41 | NR | MDP3882978.1 | 2053617 | g671817 | i0 | 81.3 | 0.975609756097561 | 80 | 15 | 97.6 | 0 | 5 | 244 | 250 | 329 | MDP3882978.1 hypothetical protein [Candidatus Staskawiczbacteria bacterium] | diamond | 240 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 29691645 | 29691645 | PRJNA1148190_P_NODE_323990_length_310_cov_1.464135_g312817_i0 | PRJNA1148190 | 323990 | 310 | 1.464135 | 4.5388185 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 85.9 | 5.98e-17 | NR | MCX6721301.1 | 2053617 | g312817 | i0 | 57.3 | 2.45806451612903 | 89 | 37 | 86.1 | 1 | 267 | 1 | 253 | 340 | MCX6721301.1 HYR domain-containing protein [Candidatus Staskawiczbacteria bacterium] | diamond | 762 | 85.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 30185961 | 30185961 | PRJNA1148190_P_NODE_770732_length_242_cov_0.911243_g759559_i0 | PRJNA1148190 | 770732 | 242 | 0.911243 | 2.20520806 | Bacteria | 2 | Bacteria | Bacteria | 103 | 1.9699999999999998e-23 | NR | OGZ67486.1 | 1802206 | g759559 | i0 | 66.3 | 4.94628099173554 | 80 | 27 | 99.2 | 0 | 241 | 2 | 170 | 249 | OGZ67486.1 MAG: hypothetical protein A3D35_00420 [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_02_FULL_34_9] | diamond | 1197 | 104 | 0.990384615384615 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_02_FULL_34_9 | ||||||
| 30576128 | 30576128 | PRJNA1148190_P_NODE_237733_length_350_cov_1.667870_g226563_i0 | PRJNA1148190 | 237733 | 350 | 1.66787 | 5.837545 | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_ | 2053617 | Bacteria | Bacteria | 150 | 2.23e-39 | NR | OGZ67351.1 | 1802206 | g226563 | i0 | 62.6 | 0.985714285714286 | 115 | 43 | 98.6 | 0 | 346 | 2 | 1006 | 1120 | OGZ67351.1 MAG: hypothetical protein A3D35_01690 [Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_02_FULL_34_9] | diamond | 345 | 150 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPHIGHO2_02_FULL_34_9 | ||||||
| 30956182 | 30956182 | PRJNA1148190_P_NODE_509454_length_265_cov_1.203125_g498281_i0 | PRJNA1148190 | 509454 | 265 | 1.203125 | 3.18828125 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 127 | 1.1399999999999999e-31 | NR | MSU54349.1 | 2053617 | g498281 | i0 | 85.1 | 1.69811320754717 | 74 | 11 | 83.8 | 0 | 1 | 222 | 717 | 790 | MSU54349.1 hypothetical protein [Candidatus Staskawiczbacteria bacterium] | diamond | 450 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium | ||||||
| 31113106 | 31113106 | PRJNA1148190_P_NODE_135735_length_452_cov_1.110818_g124571_i0 | PRJNA1148190 | 135735 | 452 | 1.110818 | 5.02089736 | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_ | 2053617 | Bacteria | Bacteria | 182 | 1.92e-50 | NR | OGZ72817.1 | 1802214 | g124571 | i0 | 58.7 | 2.98672566371681 | 150 | 54 | 99.6 | 1 | 452 | 3 | 184 | 325 | OGZ72817.1 MAG: leucine--tRNA ligase [Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_38_12b] | diamond | 1350 | 182 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_38_12b | ||||||
| 31545049 | 31545049 | PRJNA1148190_P_NODE_469556_length_272_cov_2.206030_g458383_i0 | PRJNA1148190 | 469556 | 272 | 2.20603 | 6.0004016 | Bacteria | 2 | Bacteria | Bacteria | 125 | 3.1799999999999996e-31 | NR | OGZ72817.1 | 1802214 | g458383 | i0 | 70.1 | 6.79411764705882 | 77 | 23 | 84.9 | 0 | 232 | 2 | 1 | 77 | OGZ72817.1 MAG: leucine--tRNA ligase [Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_38_12b] | diamond | 1848 | 125 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_38_12b | ||||||
| 31809369 | 31809369 | PRJNA1148190_P_NODE_305257_length_317_cov_2.827869_g294084_i0 | PRJNA1148190 | 305257 | 317 | 2.827869 | 8.96434473 | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_ | 2053617 | Bacteria | Bacteria | 45.4 | 0.00929 | NR | OGZ70756.1 | 1802211 | g294084 | i0 | 54.1 | 1.73186119873817 | 37 | 17 | 35 | 0 | 207 | 317 | 10 | 46 | OGZ70756.1 MAG: hypothetical protein A2904_02515 [Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_33_9] | diamond | 549 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_33_9 | ||||||
| 32411448 | 32411448 | PRJNA1148190_P_NODE_765179_length_242_cov_0.911243_g754006_i0 | PRJNA1148190 | 765179 | 242 | 0.911243 | 2.20520806 | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_ | 2053617 | Bacteria | Bacteria | 79.7 | 4.56e-17 | NR | OGZ71920.1 | 1802214 | g754006 | i0 | 58.5 | 0.65702479338843 | 53 | 22 | 65.7 | 0 | 197 | 39 | 66 | 118 | OGZ71920.1 MAG: hypothetical protein A2908_02455 [Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_38_12b] | diamond | 159 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria bacterium RIFCSPLOWO2_01_FULL_38_12b | ||||||
| 32631861 | 32631861 | PRJNA1148190_P_NODE_535300_length_260_cov_1.235294_g524127_i0 | PRJNA1148190 | 535300 | 260 | 1.235294 | 3.2117644 | Candidatus Staskawiczbacteria bacterium | 2053617 | Bacteria | Bacteria | 61.2 | 1.36e-8 | NR | MFA5878237.1 | 2053617 | g524127 | i0 | 49.4 | 0.957692307692308 | 83 | 39 | 95.8 | 1 | 259 | 11 | 135 | 214 | MFA5878237.1 peptidoglycan-binding protein [Candidatus Staskawiczbacteria bacterium] | diamond | 249 | 61.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Staskawicziibacteriota | Candidatus Staskawiczbacteria 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);;