contig_metadata
20 rows where bioproject = "PRJNA541476", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3060163 | 3060163 | PRJNA541476_P_NODE_6603_length_440_cov_1.678474_g6399_i0 | PRJNA541476 | 6603 | 440 | 1.678474 | 7.3852856 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 752 | 0 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g6399 | i0 | 97.5 | 344.781818181818 | 440 | 11 | 100 | 0 | 1 | 440 | 1250844 | 1251283 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 151704 | 752 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 15811306 | 15811306 | PRJNA541476_P_NODE_17413_length_294_cov_2.873303_g17207_i0 | PRJNA541476 | 17413 | 294 | 2.873303 | 8.44751082 | Candidatus Gracilibacteria bacterium 28_42_T64 | 1862133 | Bacteria | Bacteria | 348 | 3.11e-91 | NTclustered | gi|1769783243|gb|CP042461.1| | 1862133 | g17207 | i0 | 88.136 | 24.3333333333333 | 295 | 32 | 100 | 3 | 1 | 294 | 1251839 | 1252131 | Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome | blastn | 7154 | 348 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Gracilibacteria bacterium 28_42_T64 | ||||||
| 20910535 | 20910535 | PRJNA541476_P_NODE_18057_length_291_cov_1.417431_g17851_i0 | PRJNA541476 | 18057 | 291 | 1.417431 | 4.12472421 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 125 | 1.8599999999999995e-31 | NR | MDR3570663.1 | 2053589 | g17851 | i0 | 66 | 1.03092783505155 | 100 | 28 | 96.9 | 1 | 290 | 9 | 59 | 158 | MDR3570663.1 beta-Ala-His dipeptidase [Candidatus Paceibacterota bacterium] | diamond | 300 | 125 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26697915 | 26697915 | PRJNA541476_P_NODE_4201_length_560_cov_1.330595_g4005_i0 | PRJNA541476 | 4201 | 560 | 1.330595 | 7.451332 | Candidatus Sumerlaeota bacterium | 2107588 | Bacteria | Bacteria | 47.8 | 0.0128 | NR | MCX7046093.1 | 2107588 | g4005 | i0 | 34.9 | 0.867857142857143 | 83 | 50 | 42.9 | 2 | 527 | 288 | 559 | 640 | MCX7046093.1 hypothetical protein [Candidatus Sumerlaeota bacterium] | diamond | 486 | 47.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Sumerlaeota | Candidatus Sumerlaeota bacterium | ||||||
| 26712678 | 26712678 | PRJNA541476_P_NODE_12101_length_335_cov_1.427481_g11895_i0 | PRJNA541476 | 12101 | 335 | 1.427481 | 4.78206135 | Bacteria | 2 | Bacteria | Bacteria | 104 | 3.39e-26 | NR | HLD81802.1 | 2052139 | g11895 | i0 | 46.7 | 9.58208955223881 | 107 | 57 | 95.8 | 0 | 323 | 3 | 1 | 107 | HLD81802.1 50S ribosomal protein L14 [Patescibacteria group bacterium] | diamond | 3210 | 104 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 27898960 | 27898960 | PRJNA541476_P_NODE_36065_length_245_cov_0.906977_g35859_i0 | PRJNA541476 | 36065 | 245 | 0.906977 | 2.22209365 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 43.5 | 0.00467 | NR | MCS7316783.1 | 2099670 | g35859 | i0 | 70.4 | 0.330612244897959 | 27 | 8 | 33.1 | 0 | 245 | 165 | 70 | 96 | MCS7316783.1 baseplate wedge protein 53 [Candidatus Dojkabacteria bacterium] | diamond | 81 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 28246247 | 28246247 | PRJNA541476_P_NODE_3066_length_667_cov_1.898990_g2874_i0 | PRJNA541476 | 3066 | 667 | 1.89899 | 12.6662633 | Candidatus Binataceae bacterium | 2785449 | Bacteria | Bacteria | 153 | 1.44e-41 | NR | HKN02187.1 | 2785449 | g2874 | i0 | 47.3 | 0.845577211394303 | 188 | 80 | 84.6 | 4 | 1 | 564 | 124 | 292 | HKN02187.1 alpha/beta hydrolase [Candidatus Binataceae bacterium] | diamond | 564 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatales | Candidatus Binataceae | Candidatus Binataceae bacterium | |||
| 28783057 | 28783057 | PRJNA541476_P_NODE_5907_length_466_cov_2.190840_g5705_i0 | PRJNA541476 | 5907 | 466 | 2.19084 | 10.2093144 | Candidatus Binatia bacterium | 2838779 | Bacteria | Bacteria | 69.3 | 2.3e-10 | NR | HJW68814.1 | 2838779 | g5705 | i0 | 35.4 | 0.637339055793991 | 99 | 49 | 60.5 | 2 | 86 | 367 | 158 | 246 | HJW68814.1 LamG-like jellyroll fold domain-containing protein [Candidatus Binatia bacterium] | diamond | 297 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Binatota | Candidatus Binatia | Candidatus Binatia bacterium | |||||
| 29824983 | 29824983 | PRJNA541476_P_NODE_14331_length_314_cov_2.709544_g14125_i0 | PRJNA541476 | 14331 | 314 | 2.709544 | 8.50796816 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 43.9 | 0.00363 | NR | GMQ95321.1 | 2052139 | g14125 | i0 | 34.5 | 0.554140127388535 | 58 | 28 | 45.9 | 1 | 32 | 175 | 14 | 71 | GMQ95321.1 MAG: hypothetical protein BMS9Abin13_434 [Patescibacteria group bacterium] | diamond | 174 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 30836141 | 30836141 | PRJNA541476_P_NODE_12454_length_331_cov_1.678295_g12248_i0 | PRJNA541476 | 12454 | 331 | 1.678295 | 5.55515645 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79.7 | 1.01e-14 | NR | MDR3570663.1 | 2053589 | g12248 | i0 | 68.5 | 0.489425981873112 | 54 | 17 | 48.9 | 0 | 1 | 162 | 409 | 462 | MDR3570663.1 beta-Ala-His dipeptidase [Candidatus Paceibacterota bacterium] | diamond | 162 | 79.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31278445 | 31278445 | PRJNA541476_P_NODE_12755_length_328_cov_1.490196_g12549_i0 | PRJNA541476 | 12755 | 328 | 1.490196 | 4.88784288 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 159 | 2.63e-43 | NR | MBU1126552.1 | 2052139 | g12549 | i0 | 69.2 | 0.978658536585366 | 107 | 33 | 97.9 | 0 | 327 | 7 | 221 | 327 | MBU1126552.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Patescibacteria group bacterium] | diamond | 321 | 159 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 31626440 | 31626440 | PRJNA541476_P_NODE_34676_length_246_cov_1.624277_g34470_i0 | PRJNA541476 | 34676 | 246 | 1.624277 | 3.99572142 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 75.1 | 2.85e-15 | NR | MDR3570671.1 | 2053589 | g34470 | i0 | 54.1 | 1.03658536585366 | 85 | 33 | 96.3 | 2 | 1 | 237 | 24 | 108 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 255 | 75.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31721375 | 31721375 | PRJNA541476_P_NODE_26477_length_258_cov_1.362162_g26271_i0 | PRJNA541476 | 26477 | 258 | 1.362162 | 3.51437796 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 43.5 | 0.0138 | NR | MFA7192012.1 | 2053589 | g26271 | i0 | 31.9 | 0.837209302325581 | 72 | 49 | 83.7 | 0 | 40 | 255 | 3 | 74 | MFA7192012.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 216 | 43.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31862590 | 31862590 | PRJNA541476_P_NODE_11357_length_343_cov_1.677778_g11151_i0 | PRJNA541476 | 11357 | 343 | 1.677778 | 5.75477854 | Bacteria | 2 | Bacteria | Bacteria | 60.5 | 9.05e-9 | NR | AKM81192.1 | 1619077 | g11151 | i0 | 55.8 | 5.16034985422741 | 43 | 19 | 37.6 | 0 | 130 | 2 | 13 | 55 | AKM81192.1 MAG: 50S ribosomal protein L13, large subunit ribosomal protein L13 [candidate division TM6 bacterium GW2011_GWF2_28_16] | diamond | 1770 | 60.8 | 0.995065789473684 | Bacteria | Bacteria candidate phyla | candidate division TM6 bacterium GW2011_GWF2_28_16 | |||||||
| 32037794 | 32037794 | PRJNA541476_P_NODE_32618_length_248_cov_1.274286_g32412_i0 | PRJNA541476 | 32618 | 248 | 1.274286 | 3.16022928 | Candidatus Firestoneibacteriota bacterium | 2715505 | Bacteria | Bacteria | 42.7 | 0.0401 | NR | MBI5207974.1 | 2715505 | g32412 | i0 | 36.7 | 0.592741935483871 | 49 | 31 | 59.3 | 0 | 176 | 30 | 675 | 723 | MBI5207974.1 tetratricopeptide repeat protein [Candidatus Firestonebacteria bacterium] | diamond | 147 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Firestoneibacteriota | Candidatus Firestoneibacteriota bacterium | ||||||
| 32195997 | 32195997 | PRJNA541476_P_NODE_2818_length_701_cov_6.558917_g2627_i0 | PRJNA541476 | 2818 | 701 | 6.558917 | 45.97800817 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 138 | 6.5499999999999995e-37 | NR | MCT4592035.1 | 2044595 | g2627 | i0 | 42.1 | 0.680456490727532 | 159 | 89 | 68 | 2 | 588 | 112 | 4 | 159 | MCT4592035.1 NAD(P)H-dependent oxidoreductase [Candidatus Altimarinota bacterium] | diamond | 477 | 138 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 32210897 | 32210897 | PRJNA541476_P_NODE_18758_length_288_cov_1.390698_g18552_i0 | PRJNA541476 | 18758 | 288 | 1.390698 | 4.00521024 | Bacteria | 2 | Bacteria | Bacteria | 50.4 | 1.31e-4 | NR | HTY44297.1 | 2052139 | g18552 | i0 | 63.3 | 0.9375 | 30 | 10 | 30.2 | 1 | 196 | 282 | 491 | 520 | HTY44297.1 C1 family peptidase [Patescibacteria group bacterium] | diamond | 270 | 50.8 | 0.992125984251969 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32322836 | 32322836 | PRJNA541476_P_NODE_10279_length_356_cov_1.908127_g10073_i0 | PRJNA541476 | 10279 | 356 | 1.908127 | 6.79293212 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 99.4 | 2.3399999999999994e-23 | NR | MCL4419857.1 | 2052139 | g10073 | i0 | 55.7 | 0.741573033707865 | 88 | 39 | 74.2 | 0 | 90 | 353 | 55 | 142 | MCL4419857.1 KTI12 family protein [Patescibacteria group bacterium] | diamond | 264 | 99.4 | 1 | Bacteria | Bacteria candidate phyla | Patescibacteria group bacterium | |||||||
| 32322855 | 32322855 | PRJNA541476_P_NODE_28719_length_252_cov_1.128492_g28513_i0 | PRJNA541476 | 28719 | 252 | 1.128492 | 2.84379984 | candidate division WWE3 bacterium GW2 | 422282 | Bacteria | Bacteria | 42.4 | 0.0279 | NR | KKS21261.1 | 1619103 | g28513 | i0 | 28.8 | 0.952380952380952 | 80 | 57 | 95.2 | 0 | 245 | 6 | 54 | 133 | KKS21261.1 MAG: hypothetical protein UU80_C0032G0025 [candidate division WWE3 bacterium GW2011_GWA1_41_8] | diamond | 240 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | candidate division WWE3 | candidate division WWE3 bacterium GW2011_GWA1_41_8 | ||||||
| 32795760 | 32795760 | PRJNA541476_P_NODE_4620_length_530_cov_4.032823_g4421_i0 | PRJNA541476 | 4620 | 530 | 4.032823 | 21.3739619 | Patescibacteria group bacterium | 2052139 | Bacteria | Bacteria | 281 | 3.690000000000001e-91 | NR | MCL4419852.1 | 2052139 | g4421 | i0 | 81.8 | 0.962264150943396 | 170 | 31 | 96.2 | 0 | 3 | 512 | 232 | 401 | MCL4419852.1 CoA-acylating methylmalonate-semialdehyde dehydrogenase [Patescibacteria group bacterium] | diamond | 510 | 281 | 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);;