contig_metadata
23 rows where bioproject = "PRJNA492363", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25897226 | 25897226 | PRJNA492363_S_NODE_75771_length_219_cov_2.683544_g74950_i0 | PRJNA492363 | 75771 | 219 | 2.683544 | 5.87696136 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 93.2 | 7.88e-21 | NR | HEX4278163.1 | 2212468 | g74950 | i0 | 69 | 1.58904109589041 | 58 | 18 | 79.5 | 0 | 23 | 196 | 169 | 226 | HEX4278163.1 PIG-L deacetylase family protein [Bryobacteraceae bacterium] | diamond | 348 | 93.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 25975648 | 25975648 | PRJNA492363_S_NODE_91372_length_206_cov_1.324138_g90551_i0 | PRJNA492363 | 91372 | 206 | 1.324138 | 2.72772428 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 52.8 | 0.018 | NTclustered | gi|2874253709|emb|OY969474.1| | 171953 | g90551 | i0 | 100 | 0.135922330097087 | 28 | 0 | 14 | 0 | 114 | 141 | 688502 | 688529 | MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26111633 | 26111633 | PRJNA492363_S_NODE_89805_length_207_cov_0.876712_g88984_i0 | PRJNA492363 | 89805 | 207 | 0.876712 | 1.81479384 | Holophagales bacterium | 2478486 | Bacteria | Bacteria | 176 | 1.03e-39 | NTclustered | gi|1958024485|gb|CP064972.1| | 2478486 | g88984 | i0 | 82.587 | 45.7004830917874 | 201 | 33 | 97 | 2 | 4 | 203 | 1577558 | 1577359 | Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome | blastn | 9460 | 176 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagales bacterium | ||||
| 26382557 | 26382557 | PRJNA492363_S_NODE_23479_length_245_cov_2.179348_g22658_i0 | PRJNA492363 | 23479 | 245 | 2.179348 | 5.3394026 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 185 | 2.09e-42 | NTclustered | gi|2518552083|emb|OX638355.1| | 2081523 | g22658 | i0 | 82.192 | 69.0897959183673 | 219 | 36 | 89 | 1 | 3 | 221 | 5076892 | 5076677 | MAG: Terriglobia bacterium isolate 290eebee-5386-4bec-b87c-7b5c19ab3581 genome assembly, chromosome: 1 | blastn | 16927 | 185 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 26383566 | 26383566 | PRJNA492363_S_NODE_85919_length_209_cov_1.493243_g85098_i0 | PRJNA492363 | 85919 | 209 | 1.493243 | 3.12087787 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 105 | 4.48e-25 | NR | HZJ33333.1 | 2910147 | g85098 | i0 | 93 | 4.90909090909091 | 57 | 4 | 81.8 | 0 | 173 | 3 | 39 | 95 | HZJ33333.1 MFS transporter [Vicinamibacterales bacterium] | diamond | 1026 | 105 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 26518554 | 26518554 | PRJNA492363_S_NODE_14048_length_265_cov_1.323529_g13227_i0 | PRJNA492363 | 14048 | 265 | 1.323529 | 3.50735185 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 118 | 3.5e-30 | NR | HZM62539.1 | 2910147 | g13227 | i0 | 80 | 1.69811320754717 | 75 | 15 | 84.9 | 0 | 15 | 239 | 1 | 75 | HZM62539.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Vicinamibacterales bacterium] | diamond | 450 | 118 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32918026 | 32918026 | PRJNA492363_S_NODE_12265_length_279_cov_1.807339_g11444_i0 | PRJNA492363 | 12265 | 279 | 1.807339 | 5.04247581 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 45.4 | 0.00623 | NR | MCU0237941.1 | 2283092 | g11444 | i0 | 60 | 0.43010752688172 | 40 | 16 | 43 | 0 | 4 | 123 | 331 | 370 | MCU0237941.1 DJ-1/PfpI family protein [Pyrinomonadaceae bacterium] | diamond | 120 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32935408 | 32935408 | PRJNA492363_S_NODE_97217_length_203_cov_0.901408_g96396_i0 | PRJNA492363 | 97217 | 203 | 0.901408 | 1.82985824 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 88.6 | 2.19e-20 | NR | HZT60060.1 | 2283092 | g96396 | i0 | 62.5 | 0.945812807881773 | 64 | 24 | 94.6 | 0 | 12 | 203 | 43 | 106 | HZT60060.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 192 | 88.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32952635 | 32952635 | PRJNA492363_S_NODE_91402_length_206_cov_1.324138_g90581_i0 | PRJNA492363 | 91402 | 206 | 1.324138 | 2.72772428 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 48.5 | 2.09e-4 | NR | HKP71062.1 | 2283092 | g90581 | i0 | 50 | 1.19417475728155 | 44 | 22 | 64.1 | 0 | 132 | 1 | 1 | 44 | HKP71062.1 glycoside hydrolase family 88 protein [Pyrinomonadaceae bacterium] | diamond | 246 | 48.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32958611 | 32958611 | PRJNA492363_S_NODE_97002_length_203_cov_1.133803_g96181_i0 | PRJNA492363 | 97002 | 203 | 1.133803 | 2.30162009 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.4 | 0.00251 | NR | MES2391110.1 | 1978231 | g96181 | i0 | 39.1 | 4.13793103448276 | 64 | 37 | 93.1 | 2 | 15 | 203 | 1095 | 1157 | MES2391110.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 840 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32969796 | 32969796 | PRJNA492363_S_NODE_91634_length_206_cov_0.882759_g90813_i0 | PRJNA492363 | 91634 | 206 | 0.882759 | 1.81848354 | Kocuria sp. cx-116 | 2771378 | Bacteria | Bacteria | 95.1 | 1.26e-23 | NR | WP_190782522.1 | 2771378 | g90813 | i0 | 87.5 | 0.815533980582524 | 56 | 7 | 81.6 | 0 | 3 | 170 | 40 | 95 | WP_190782522.1 hypothetical protein [Kocuria sp. cx-116] | diamond | 168 | 95.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Candidatus Korobacteraceae | Candidatus Sulfotelmatobacter | Kocuria sp. cx-116 | ||
| 32969837 | 32969837 | PRJNA492363_S_NODE_98898_length_202_cov_1.148936_g98077_i0 | PRJNA492363 | 98898 | 202 | 1.148936 | 2.32085072 | Candidatus Sulfopaludibacter sp. SbA3 | 2043164 | Bacteria | Bacteria | 56.2 | 3.54e-7 | NR | SPE37511.1 | 2043164 | g98077 | i0 | 47.5 | 1.81188118811881 | 61 | 30 | 89.1 | 2 | 21 | 200 | 54 | 113 | SPE37511.1 NHL repeat containing protein (fragment) [Candidatus Sulfopaludibacter sp. SbA3] | diamond | 366 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. SbA3 | ||
| 33054787 | 33054787 | PRJNA492363_S_NODE_59157_length_229_cov_1.142857_g58336_i0 | PRJNA492363 | 59157 | 229 | 1.142857 | 2.61714253 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 143 | 9.81e-41 | NR | MBA2336010.1 | 2052146 | g58336 | i0 | 84 | 2.93449781659389 | 75 | 12 | 98.3 | 0 | 227 | 3 | 52 | 126 | MBA2336010.1 tRNA pseudouridine(38-40) synthase TruA [Blastocatellia bacterium] | diamond | 672 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 33054910 | 33054910 | PRJNA492363_S_NODE_93533_length_205_cov_0.888889_g92712_i0 | PRJNA492363 | 93533 | 205 | 0.888889 | 1.82222245 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 120 | 5.65e-30 | NR | HEX2060071.1 | 2651171 | g92712 | i0 | 83.8 | 3.98048780487805 | 68 | 11 | 99.5 | 0 | 2 | 205 | 126 | 193 | HEX2060071.1 gamma-glutamyltransferase [Thermoanaerobaculia bacterium] | diamond | 816 | 120 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 33071633 | 33071633 | PRJNA492363_S_NODE_100821_length_201_cov_1.371429_g100000_i0 | PRJNA492363 | 100821 | 201 | 1.371429 | 2.75657229 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 70.1 | 4.77e-12 | NR | HEY6937309.1 | 2282142 | g100000 | i0 | 54.1 | 5.58208955223881 | 61 | 28 | 91 | 0 | 184 | 2 | 453 | 513 | HEY6937309.1 EAL domain-containing protein [Terriglobales bacterium] | diamond | 1122 | 70.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 33077873 | 33077873 | PRJNA492363_S_NODE_100989_length_201_cov_0.914286_g100168_i0 | PRJNA492363 | 100989 | 201 | 0.914286 | 1.83771486 | Bacteria | 2 | Bacteria | Bacteria | 102 | 1.49e-23 | NR | MBL8123317.1 | 2052146 | g100168 | i0 | 74.6 | 4.61194029850746 | 63 | 16 | 94 | 0 | 201 | 13 | 548 | 610 | MBL8123317.1 VWA domain-containing protein [Blastocatellia bacterium] | diamond | 927 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 33122931 | 33122931 | PRJNA492363_S_NODE_110695_length_194_cov_2.406015_g109874_i0 | PRJNA492363 | 110695 | 194 | 2.406015 | 4.6676691 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 69.3 | 6.77e-12 | NR | HXG85097.1 | 2283092 | g109874 | i0 | 60.9 | 0.989690721649485 | 64 | 21 | 99 | 2 | 193 | 2 | 141 | 200 | HXG85097.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 192 | 69.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 33129187 | 33129187 | PRJNA492363_S_NODE_96759_length_203_cov_1.816901_g95938_i0 | PRJNA492363 | 96759 | 203 | 1.816901 | 3.68830903 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 1.3e-26 | NR | HXW13249.1 | 2081523 | g95938 | i0 | 76.1 | 4.77339901477832 | 67 | 16 | 99 | 0 | 1 | 201 | 257 | 323 | HXW13249.1 class I fructose-bisphosphate aldolase [Terriglobia bacterium] | diamond | 969 | 108 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 33140133 | 33140133 | PRJNA492363_S_NODE_83807_length_210_cov_1.765101_g82986_i0 | PRJNA492363 | 83807 | 210 | 1.765101 | 3.7067121 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 112 | 2.9800000000000003e-27 | NR | MEQ1760072.1 | 2910147 | g82986 | i0 | 88.3 | 0.857142857142857 | 60 | 7 | 85.7 | 0 | 180 | 1 | 39 | 98 | MEQ1760072.1 efflux RND transporter periplasmic adaptor subunit [Vicinamibacterales bacterium] | diamond | 180 | 112 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 33140135 | 33140135 | PRJNA492363_S_NODE_83927_length_210_cov_1.234899_g83106_i0 | PRJNA492363 | 83927 | 210 | 1.234899 | 2.5932879 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 87.8 | 3.08e-18 | NR | HEY0658295.1 | 2283092 | g83106 | i0 | 64.7 | 0.971428571428571 | 68 | 24 | 97.1 | 0 | 205 | 2 | 32 | 99 | HEY0658295.1 sigma-54 dependent transcriptional regulator [Pyrinomonadaceae bacterium] | diamond | 204 | 87.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 33140149 | 33140149 | PRJNA492363_S_NODE_87767_length_208_cov_1.639456_g86946_i0 | PRJNA492363 | 87767 | 208 | 1.639456 | 3.41006848 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 70.9 | 2.76e-12 | NR | HEY4365576.1 | 2212468 | g86946 | i0 | 58.3 | 0.865384615384615 | 60 | 25 | 86.5 | 0 | 194 | 15 | 336 | 395 | HEY4365576.1 HAD-IIIC family phosphatase [Bryobacteraceae bacterium] | diamond | 180 | 70.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 33157056 | 33157056 | PRJNA492363_S_NODE_51704_length_232_cov_1.497076_g50883_i0 | PRJNA492363 | 51704 | 232 | 1.497076 | 3.47321632 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 145 | 2.47e-38 | NR | WP_325379830.1 | 1934404 | g50883 | i0 | 96.1 | 0.995689655172414 | 77 | 3 | 99.6 | 0 | 231 | 1 | 443 | 519 | WP_325379830.1 DEAD/DEAH box helicase, partial [Edaphobacter sp.] | diamond | 231 | 145 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 33157195 | 33157195 | PRJNA492363_S_NODE_98848_length_202_cov_1.340426_g98027_i0 | PRJNA492363 | 98848 | 202 | 1.340426 | 2.70766052 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 43.5 | 0.00188 | NR | WP_325379828.1 | 1934404 | g98027 | i0 | 100 | 0.326732673267327 | 22 | 0 | 32.7 | 0 | 135 | 200 | 2 | 23 | WP_325379828.1 hypothetical protein [Edaphobacter sp.] | diamond | 66 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter 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);;