contig_metadata
20 rows where bioproject = "PRJNA330616", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389644 | 389644 | PRJNA330616_P_NODE_18661_length_195_cov_1.356164_g18252_i0 | PRJNA330616 | 18661 | 195 | 1.356164 | 2.6445198 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 75.1 | 7.7e-14 | NR | HZQ70140.1 | 2282142 | g18252 | i0 | 56.7 | 6.66153846153846 | 60 | 25 | 90.8 | 1 | 3 | 179 | 2906 | 2965 | HZQ70140.1 amino acid adenylation domain-containing protein [Terriglobales bacterium] | diamond | 1299 | 75.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 1069366 | 1069366 | PRJNA330616_P_NODE_23321_length_175_cov_1.365079_g22912_i0 | PRJNA330616 | 23321 | 175 | 1.365079 | 2.38888825 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 122 | 1.1099999999999999e-23 | NTclustered | gi|2621701418|emb|OY760136.1| | 2910147 | g22912 | i0 | 79.885 | 27.6971428571429 | 174 | 29 | 98 | 6 | 1 | 171 | 1699524 | 1699354 | MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 | blastn | 4847 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 1664537 | 1664537 | PRJNA330616_P_NODE_5542_length_357_cov_1.902597_g5133_i0 | PRJNA330616 | 5542 | 357 | 1.902597 | 6.79227129 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 462 | 1.32e-125 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g5133 | i0 | 90.028 | 107.137254901961 | 361 | 31 | 100 | 4 | 1 | 357 | 3300016 | 3299657 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 38248 | 462 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 2940347 | 2940347 | PRJNA330616_P_NODE_23723_length_173_cov_2.411290_g23314_i0 | PRJNA330616 | 23723 | 173 | 2.41129 | 4.1715317 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 222 | 1.05e-53 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g23314 | i0 | 90.173 | 90.757225433526 | 173 | 14 | 100 | 3 | 1 | 173 | 3298705 | 3298874 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 15701 | 222 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 11868438 | 11868438 | PRJNA330616_P_NODE_30690_length_162_cov_1.398230_g30281_i0 | PRJNA330616 | 30690 | 162 | 1.39823 | 2.2651326 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 215 | 1.62e-51 | NTclustered | gi|1958093598|gb|CP065003.1| | 1978231 | g30281 | i0 | 92.667 | 67.3641975308642 | 150 | 10 | 92 | 1 | 1 | 149 | 317262 | 317411 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome | blastn | 10913 | 215 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 16967232 | 16967232 | PRJNA330616_P_NODE_7094_length_313_cov_1.488636_g6685_i0 | PRJNA330616 | 7094 | 313 | 1.488636 | 4.65943068 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 193 | 1.65e-44 | NTclustered | gi|2621701418|emb|OY760136.1| | 2910147 | g6685 | i0 | 80.224 | 72.6932907348243 | 268 | 43 | 84 | 10 | 50 | 313 | 1699525 | 1699264 | MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1 | blastn | 22753 | 193 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 19515668 | 19515668 | PRJNA330616_P_NODE_31276_length_162_cov_0.902655_g30867_i0 | PRJNA330616 | 31276 | 162 | 0.902655 | 1.4623011 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 147 | 6.009999999999999e-31 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g30867 | i0 | 85.714 | 5.09259259259259 | 140 | 18 | 86 | 2 | 24 | 162 | 2282265 | 2282127 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 825 | 147 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 19515735 | 19515735 | PRJNA330616_P_NODE_6576_length_326_cov_1.018051_g6167_i0 | PRJNA330616 | 6576 | 326 | 1.018051 | 3.31884626 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 357 | 5.8e-94 | NTclustered | gi|217038907|gb|EU810998.1| | 171953 | g6167 | i0 | 93.361 | 220.69018404908 | 241 | 16 | 74 | 0 | 86 | 326 | 1 | 241 | Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence | blastn | 71945 | 357 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 24615599 | 24615599 | PRJNA330616_P_NODE_11220_length_247_cov_1.262626_g10811_i0 | PRJNA330616 | 11220 | 247 | 1.262626 | 3.11868622 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 265 | 2.63e-66 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g10811 | i0 | 86 | 163.514170040486 | 250 | 32 | 100 | 2 | 1 | 247 | 4233619 | 4233868 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 40388 | 265 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 27485436 | 27485436 | PRJNA330616_P_NODE_31123_length_162_cov_0.902655_g30714_i0 | PRJNA330616 | 31123 | 162 | 0.902655 | 1.4623011 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 57 | 5.34e-9 | NR | MBK9061592.1 | 1978231 | g30714 | i0 | 57.1 | 2.62962962962963 | 49 | 20 | 90.7 | 1 | 155 | 9 | 6 | 53 | MBK9061592.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 426 | 57 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27692398 | 27692398 | PRJNA330616_P_NODE_16224_length_208_cov_1.283019_g15815_i0 | PRJNA330616 | 16224 | 208 | 1.283019 | 2.66867952 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 93.2 | 5.51e-21 | NR | MEW5980043.1 | 1978231 | g15815 | i0 | 65.2 | 26.8701923076923 | 69 | 24 | 99.5 | 0 | 1 | 207 | 25 | 93 | MEW5980043.1 aldolase/citrate lyase family protein [Acidobacteriota bacterium] | diamond | 5589 | 94 | 0.991489361702128 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28874610 | 28874610 | PRJNA330616_P_NODE_28748_length_164_cov_0.886957_g28339_i0 | PRJNA330616 | 28748 | 164 | 0.886957 | 1.45460948 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 80.1 | 6.13e-16 | NR | MEQ1923763.1 | 2283092 | g28339 | i0 | 71.7 | 0.969512195121951 | 53 | 15 | 97 | 0 | 159 | 1 | 97 | 149 | MEQ1923763.1 CHRD domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 159 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29459972 | 29459972 | PRJNA330616_P_NODE_6150_length_338_cov_1.570934_g5741_i0 | PRJNA330616 | 6150 | 338 | 1.570934 | 5.30975692 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 97.1 | 1.07e-20 | NR | MCU1268103.1 | 1978231 | g5741 | i0 | 48.2 | 9.94082840236686 | 112 | 58 | 99.4 | 0 | 3 | 338 | 1425 | 1536 | MCU1268103.1 putative linear pentadecapeptide gramicidin synthetase LgrB [Acidobacteriota bacterium] | diamond | 3360 | 97.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29965615 | 29965615 | PRJNA330616_P_NODE_21991_length_180_cov_1.557252_g21582_i0 | PRJNA330616 | 21991 | 180 | 1.557252 | 2.8030536 | Bacteria | 2 | Bacteria | Bacteria | 49.3 | 7.69e-5 | NR | MEM9554443.1 | 1978231 | g21582 | i0 | 46.8 | 2.06666666666667 | 62 | 30 | 98.3 | 2 | 2 | 178 | 48 | 109 | MEM9554443.1 peroxidase family protein [Acidobacteriota bacterium] | diamond | 372 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30232563 | 30232563 | PRJNA330616_P_NODE_19592_length_190_cov_2.085106_g19183_i0 | PRJNA330616 | 19592 | 190 | 2.085106 | 3.9617014 | Geothrix limicola | 2927978 | Bacteria | Bacteria | 90.1 | 2.68e-20 | NR | WP_285576367.1 | 2927978 | g19183 | i0 | 70.3 | 1.01052631578947 | 64 | 17 | 97.9 | 1 | 4 | 189 | 25 | 88 | WP_285576367.1 CatB-related O-acetyltransferase [Geothrix limicola] | diamond | 192 | 90.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Geothrix | Geothrix limicola | ||
| 30628812 | 30628812 | PRJNA330616_P_NODE_26733_length_166_cov_0.871795_g26324_i0 | PRJNA330616 | 26733 | 166 | 0.871795 | 1.4471797 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 44.7 | 0.00283 | NR | SPF32762.1 | 2043165 | g26324 | i0 | 52.9 | 4.60843373493976 | 51 | 15 | 90.4 | 2 | 166 | 17 | 1164 | 1206 | SPF32762.1 exported hypothetical protein [Candidatus Sulfopaludibacter sp. SbA4] | diamond | 765 | 45.1 | 0.991130820399113 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. SbA4 | ||
| 31813011 | 31813011 | PRJNA330616_P_NODE_26957_length_166_cov_0.871795_g26548_i0 | PRJNA330616 | 26957 | 166 | 0.871795 | 1.4471797 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 105 | 1.38e-24 | NR | MBI4850196.1 | 1978231 | g26548 | i0 | 88.9 | 0.975903614457831 | 54 | 6 | 97.6 | 0 | 3 | 164 | 526 | 579 | MBI4850196.1 TonB-dependent siderophore receptor [Acidobacteriota bacterium] | diamond | 162 | 105 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32002877 | 32002877 | PRJNA330616_P_NODE_20098_length_188_cov_1.467626_g19689_i0 | PRJNA330616 | 20098 | 188 | 1.467626 | 2.75913688 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 49.3 | 7.68e-5 | NR | HEU4893770.1 | 2910147 | g19689 | i0 | 61.8 | 1.08510638297872 | 34 | 13 | 54.3 | 0 | 86 | 187 | 5 | 38 | HEU4893770.1 glycosyltransferase [Vicinamibacterales bacterium] | diamond | 204 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32051781 | 32051781 | PRJNA330616_P_NODE_11098_length_248_cov_1.793970_g10689_i0 | PRJNA330616 | 11098 | 248 | 1.79397 | 4.4490456 | root | 1 | Root_unresolved | Root_unresolved | 108 | 3.21e-25 | NR | HEV8590257.1 | 2283092 | g10689 | i0 | 65 | 13.6209677419355 | 80 | 28 | 96.8 | 0 | 243 | 4 | 292 | 371 | HEV8590257.1 non-ribosomal peptide synthetase [Pyrinomonadaceae bacterium] | diamond | 3378 | 109 | 0.990825688073395 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32477628 | 32477628 | PRJNA330616_P_NODE_22799_length_177_cov_1.429688_g22390_i0 | PRJNA330616 | 22799 | 177 | 1.429688 | 2.53054776 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 51.6 | 1.13e-5 | NR | MCK6691006.1 | 2651171 | g22390 | i0 | 41.1 | 2.89830508474576 | 56 | 31 | 94.9 | 1 | 176 | 9 | 88 | 141 | MCK6691006.1 ABC transporter permease [Thermoanaerobaculia bacterium] | diamond | 513 | 51.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia 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);;