contig_metadata
23 rows where bioproject = "PRJNA1025141", tax_phylum = "Acidobacteriota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1437484 | 1437484 | PRJNA1025141_P_NODE_12142_length_244_cov_0.894737_g12081_i0 | PRJNA1025141 | 12142 | 244 | 0.894737 | 2.18315828 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 112 | 5.46e-29 | NR | HSL22177.1 | 2910147 | g12081 | i0 | 74.1 | 0.995901639344262 | 81 | 20 | 98.4 | 1 | 3 | 242 | 49 | 129 | HSL22177.1 ECF-type sigma factor [Vicinamibacterales bacterium] | diamond | 243 | 112 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 6540889 | 6540889 | PRJNA1025141_P_NODE_11286_length_246_cov_0.890173_g11225_i0 | PRJNA1025141 | 11286 | 246 | 0.890173 | 2.18982558 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 142 | 4.95e-41 | NR | HWB30767.1 | 2910147 | g11225 | i0 | 82.9 | 1.98780487804878 | 82 | 14 | 100 | 0 | 246 | 1 | 4 | 85 | HWB30767.1 shikimate kinase [Vicinamibacterales bacterium] | diamond | 489 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 11207437 | 11207437 | PRJNA1025141_P_NODE_12589_length_242_cov_0.911243_g12528_i0 | PRJNA1025141 | 12589 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 222 | 1.57e-53 | NTclustered | gi|2874254049|emb|OY970373.1| | 171953 | g12528 | i0 | 83.402 | 96.8099173553719 | 241 | 39 | 99 | 1 | 3 | 242 | 5166250 | 5166010 | MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1 | blastn | 23428 | 222 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 12916478 | 12916478 | PRJNA1025141_P_NODE_13131_length_241_cov_0.916667_g13070_i0 | PRJNA1025141 | 13131 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 129 | 1.77e-32 | NR | MEO8502555.1 | 1978231 | g13070 | i0 | 83.8 | 15.9336099585062 | 80 | 13 | 99.6 | 0 | 241 | 2 | 761 | 840 | MEO8502555.1 translation initiation factor IF-2 [Acidobacteriota bacterium] | diamond | 3840 | 129 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 21839779 | 21839779 | PRJNA1025141_P_NODE_9658_length_251_cov_0.865169_g9597_i0 | PRJNA1025141 | 9658 | 251 | 0.865169 | 2.17157419 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 85.1 | 1.05e-17 | NR | HEU4892387.1 | 2910147 | g9597 | i0 | 50.6 | 0.99203187250996006 | 83 | 41 | 99.2 | 0 | 3 | 251 | 74 | 156 | HEU4892387.1 GNAT family N-acetyltransferase [Vicinamibacterales bacterium] | diamond | 249 | 85.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 26939924 | 26939924 | PRJNA1025141_P_NODE_10502_length_248_cov_0.880000_g10441_i0 | PRJNA1025141 | 10502 | 248 | 0.88 | 2.1824 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 159 | 2.3999999999999998e-43 | NR | HVG86114.1 | 2910147 | g10441 | i0 | 89 | 2.9758064516129 | 82 | 9 | 99.2 | 0 | 1 | 246 | 569 | 650 | HVG86114.1 ABC transporter permease [Vicinamibacterales bacterium] | diamond | 738 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27034986 | 27034986 | PRJNA1025141_P_NODE_2_length_4236_cov_3.624309_g1_i0 | PRJNA1025141 | 2 | 4236 | 3.624309 | 153.52572924 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 190 | 1.12e-44 | NR | HMV46425.1 | 2052146 | g1 | i0 | 49 | 0.524079320113314 | 257 | 113 | 17.3 | 7 | 2355 | 3086 | 285 | 536 | HMV46425.1 DUF4394 domain-containing protein [Blastocatellia bacterium] | diamond | 2220 | 190 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28574549 | 28574549 | PRJNA1025141_P_NODE_2747_length_494_cov_1.517815_g2686_i0 | PRJNA1025141 | 2747 | 494 | 1.517815 | 7.4980061 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 226 | 8.07e-71 | NR | KAA0253286.1 | 1978231 | g2686 | i0 | 65 | 3.98380566801619 | 163 | 56 | 98.4 | 1 | 486 | 1 | 96 | 258 | KAA0253286.1 MAG: zinc metalloprotease [Acidobacteriota bacterium] | diamond | 1968 | 226 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28732576 | 28732576 | PRJNA1025141_P_NODE_5887_length_330_cov_1.684825_g5826_i0 | PRJNA1025141 | 5887 | 330 | 1.684825 | 5.5599225 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 116 | 1.1e-27 | NR | MCB1054384.1 | 1978231 | g5826 | i0 | 52.7 | 7.12727272727273 | 112 | 50 | 99.1 | 1 | 329 | 3 | 252 | 363 | MCB1054384.1 M4 family metallopeptidase [Acidobacteriota bacterium] | diamond | 2352 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28929845 | 28929845 | PRJNA1025141_P_NODE_13188_length_241_cov_0.904762_g13127_i0 | PRJNA1025141 | 13188 | 241 | 0.904762 | 2.18047642 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 104 | 7.92e-24 | NR | HKV09459.1 | 2651171 | g13127 | i0 | 64.1 | 3.83402489626556 | 78 | 28 | 97.1 | 0 | 241 | 8 | 2071 | 2148 | HKV09459.1 DUF6603 domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 924 | 104 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 29466213 | 29466213 | PRJNA1025141_P_NODE_7790_length_282_cov_1.325359_g7729_i0 | PRJNA1025141 | 7790 | 282 | 1.325359 | 3.73751238 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 55.8 | 1.2e-6 | NR | MEP7336774.1 | 1978231 | g7729 | i0 | 33.3 | 1.42553191489362 | 72 | 48 | 76.6 | 0 | 8 | 223 | 94 | 165 | MEP7336774.1 kelch repeat-containing protein [Acidobacteriota bacterium] | diamond | 402 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29592473 | 29592473 | PRJNA1025141_P_NODE_10250_length_249_cov_0.875000_g10189_i0 | PRJNA1025141 | 10250 | 249 | 0.875 | 2.17875 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 110 | 1.4700000000000002e-27 | NR | HEX8736076.1 | 2283092 | g10189 | i0 | 68.7 | 3 | 83 | 24 | 100 | 1 | 249 | 1 | 73 | 153 | HEX8736076.1 SDR family NAD(P)-dependent oxidoreductase [Pyrinomonadaceae bacterium] | diamond | 747 | 110 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30216600 | 30216600 | PRJNA1025141_P_NODE_3932_length_410_cov_1.020772_g3871_i0 | PRJNA1025141 | 3932 | 410 | 1.020772 | 4.1851652 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 0.00271 | NR | MBA2604189.1 | 1978231 | g3871 | i0 | 29.2 | 2.29024390243902 | 113 | 58 | 82.7 | 3 | 409 | 71 | 91 | 181 | MBA2604189.1 methyltransferase domain-containing protein [Acidobacteriota bacterium] | diamond | 939 | 47.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30414454 | 30414454 | PRJNA1025141_P_NODE_11713_length_245_cov_0.895349_g11652_i0 | PRJNA1025141 | 11713 | 245 | 0.895349 | 2.19360505 | Candidatus Polarisedimenticolia bacterium | 3069555 | Bacteria | Bacteria | 67.8 | 4.38e-11 | NR | HKN46905.1 | 3069555 | g11652 | i0 | 43.6 | 0.955102040816327 | 78 | 44 | 95.5 | 0 | 235 | 2 | 1 | 78 | HKN46905.1 TagF domain-containing protein [Candidatus Polarisedimenticolia bacterium] | diamond | 234 | 67.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Candidatus Polarisedimenticolia | Candidatus Polarisedimenticolia bacterium | |||||
| 30540517 | 30540517 | PRJNA1025141_P_NODE_9673_length_251_cov_0.865169_g9612_i0 | PRJNA1025141 | 9673 | 251 | 0.865169 | 2.17157419 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 45.1 | 0.00606 | NR | HYG63891.1 | 2651171 | g9612 | i0 | 31.9 | 0.824701195219124 | 69 | 47 | 82.5 | 0 | 42 | 248 | 319 | 387 | HYG63891.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 207 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30635146 | 30635146 | PRJNA1025141_P_NODE_11853_length_244_cov_0.900585_g11792_i0 | PRJNA1025141 | 11853 | 244 | 0.900585 | 2.1974274 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 85.1 | 3.76e-17 | NR | HLH17717.1 | 2212468 | g11792 | i0 | 81 | 1.0327868852459 | 42 | 8 | 51.6 | 0 | 244 | 119 | 395 | 436 | HLH17717.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 252 | 85.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31038489 | 31038489 | PRJNA1025141_P_NODE_8355_length_271_cov_0.994949_g8294_i0 | PRJNA1025141 | 8355 | 271 | 0.994949 | 2.69631179 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 107 | 9.63e-25 | NR | PYP82944.1 | 2169413 | g8294 | i0 | 54.4 | 4.97047970479705 | 90 | 41 | 99.6 | 0 | 1 | 270 | 44 | 133 | PYP82944.1 MAG: decarboxylase [Blastocatellia bacterium AA13] | diamond | 1347 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium AA13 | |||||
| 31235528 | 31235528 | PRJNA1025141_P_NODE_35_length_2501_cov_3.736409_g31_i0 | PRJNA1025141 | 35 | 2501 | 3.736409 | 93.44758909 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 166 | 7e-38 | NR | HXM09481.1 | 2282142 | g31 | i0 | 28.2 | 0.803678528588565 | 670 | 369 | 73.5 | 26 | 148 | 1986 | 670 | 1284 | HXM09481.1 IPT/TIG domain-containing protein [Terriglobales bacterium] | diamond | 2010 | 166 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31267320 | 31267320 | PRJNA1025141_P_NODE_11355_length_246_cov_0.890173_g11294_i0 | PRJNA1025141 | 11355 | 246 | 0.890173 | 2.18982558 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 80.1 | 2.77e-15 | NR | PYR93546.1 | 1978231 | g11294 | i0 | 53.1 | 0.98780487804878 | 81 | 38 | 98.8 | 0 | 246 | 4 | 551 | 631 | PYR93546.1 MAG: hypothetical protein DMF84_09090 [Acidobacteriota bacterium] | diamond | 243 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31481155 | 31481155 | PRJNA1025141_P_NODE_9596_length_251_cov_0.865169_g9535_i0 | PRJNA1025141 | 9596 | 251 | 0.865169 | 2.17157419 | root | 1 | Root_unresolved | Root_unresolved | 114 | 1.34e-27 | NR | HWF10651.1 | 2212468 | g9535 | i0 | 56.6 | 7.8406374501992 | 83 | 36 | 99.2 | 0 | 3 | 251 | 306 | 388 | HWF10651.1 aldehyde dehydrogenase family protein [Bryobacteraceae bacterium] | diamond | 1968 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31520467 | 31520467 | PRJNA1025141_P_NODE_10736_length_248_cov_0.862857_g10675_i0 | PRJNA1025141 | 10736 | 248 | 0.862857 | 2.13988536 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 46.6 | 0.00127 | NR | MDQ6758358.1 | 1978231 | g10675 | i0 | 37.5 | 0.774193548387097 | 64 | 40 | 77.4 | 0 | 210 | 19 | 31 | 94 | MDQ6758358.1 ParA family protein [Acidobacteriota bacterium] | diamond | 192 | 46.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32153064 | 32153064 | PRJNA1025141_P_NODE_10578_length_248_cov_0.880000_g10517_i0 | PRJNA1025141 | 10578 | 248 | 0.88 | 2.1824 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 136 | 5.549999999999999e-37 | NR | HVR29307.1 | 2651171 | g10517 | i0 | 79.7 | 0.955645161290323 | 79 | 16 | 95.6 | 0 | 1 | 237 | 57 | 135 | HVR29307.1 NTP transferase domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 237 | 136 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32658505 | 32658505 | PRJNA1025141_P_NODE_9440_length_251_cov_0.865169_g9379_i0 | PRJNA1025141 | 9440 | 251 | 0.865169 | 2.17157419 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 160 | 1.2899999999999999e-43 | NR | HEX7333951.1 | 2283092 | g9379 | i0 | 95.2 | 0.99203187250996006 | 83 | 4 | 99.2 | 0 | 2 | 250 | 165 | 247 | HEX7333951.1 SBBP repeat-containing protein [Pyrinomonadaceae bacterium] | diamond | 249 | 160 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;