contig_metadata
24 rows where bioproject = "PRJNA436017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1705898 | 1705898 | PRJNA436017_P_NODE_8482_length_301_cov_3.840909_g8184_i0 | PRJNA436017 | 8482 | 301 | 3.840909 | 11.56113609 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 379 | 1.13e-100 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g8184 | i0 | 89.369 | 268.046511627907 | 301 | 32 | 100 | 0 | 1 | 301 | 3559317 | 3559017 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 80682 | 379 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 2981551 | 2981551 | PRJNA436017_P_NODE_26343_length_159_cov_1.237705_g26045_i0 | PRJNA436017 | 26343 | 159 | 1.237705 | 1.96795095 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 278 | 2e-70 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g26045 | i0 | 98.125 | 99.7232704402516 | 160 | 1 | 100 | 2 | 1 | 159 | 635379 | 635537 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 15856 | 278 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 5534428 | 5534428 | PRJNA436017_P_NODE_17505_length_196_cov_1.685535_g17207_i0 | PRJNA436017 | 17505 | 196 | 1.685535 | 3.3036486 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 95.3 | 2.78e-15 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g17207 | i0 | 86.022 | 5.01020408163265 | 93 | 7 | 46 | 6 | 2 | 91 | 498722 | 498633 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 982 | 95.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 10634463 | 10634463 | PRJNA436017_P_NODE_10009_length_273_cov_1.665254_g9711_i0 | PRJNA436017 | 10009 | 273 | 1.665254 | 4.54614342 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 483 | 7.5e-132 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g9711 | i0 | 98.535 | 68.2564102564103 | 273 | 4 | 100 | 0 | 1 | 273 | 634685 | 634957 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 18634 | 483 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 10634923 | 10634923 | PRJNA436017_P_NODE_8609_length_298_cov_6.015326_g8311_i0 | PRJNA436017 | 8609 | 298 | 6.015326 | 17.92567148 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 285 | 2.51e-72 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g8311 | i0 | 84.175 | 238.130872483221 | 297 | 43 | 99 | 4 | 4 | 298 | 3301039 | 3300745 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 70963 | 285 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 11909575 | 11909575 | PRJNA436017_P_NODE_21950_length_174_cov_2.270073_g21652_i0 | PRJNA436017 | 21950 | 174 | 2.270073 | 3.94992702 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 322 | 1.01e-83 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g21652 | i0 | 100 | 8.52873563218391 | 174 | 0 | 100 | 0 | 1 | 174 | 635067 | 635240 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 1484 | 322 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 14459420 | 14459420 | PRJNA436017_P_NODE_12212_length_242_cov_2.151220_g11914_i0 | PRJNA436017 | 12212 | 242 | 2.15122 | 5.2059524 | Edaphobacter flagellatus | 1933044 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|2304905232|gb|CP073697.1| | 1933044 | g11914 | i0 | 100 | 123.595041322314 | 242 | 0 | 100 | 0 | 1 | 242 | 3268130 | 3267889 | Edaphobacter flagellatus strain HZ411 chromosome, complete genome | blastn | 29910 | 448 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter flagellatus | ||
| 14459572 | 14459572 | PRJNA436017_P_NODE_19952_length_183_cov_1.301370_g19654_i0 | PRJNA436017 | 19952 | 183 | 1.30137 | 2.3815071 | Edaphobacter flagellatus | 1933044 | Bacteria | Bacteria | 339 | 1.07e-88 | NTclustered | gi|2304905232|gb|CP073697.1| | 1933044 | g19654 | i0 | 100 | 119.393442622951 | 183 | 0 | 100 | 0 | 1 | 183 | 3268630 | 3268812 | Edaphobacter flagellatus strain HZ411 chromosome, complete genome | blastn | 21849 | 339 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter flagellatus | ||
| 15733583 | 15733583 | PRJNA436017_P_NODE_5373_length_391_cov_1.858757_g5077_i0 | PRJNA436017 | 5373 | 391 | 1.858757 | 7.26773987 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 163 | 1.66e-35 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g5077 | i0 | 75.881 | 1.90281329923274 | 369 | 61 | 91 | 18 | 3 | 356 | 4746910 | 4746555 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 744 | 163 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 22107455 | 22107455 | PRJNA436017_P_NODE_26418_length_159_cov_0.918033_g26120_i0 | PRJNA436017 | 26418 | 159 | 0.918033 | 1.4596724700000001 | uncultured Holophaga sp. | 188475 | Bacteria | Bacteria | 62.1 | 2.19e-5 | NTclustered | gi|2621702213|emb|OY760195.1| | 188475 | g26120 | i0 | 92.857 | 0.547169811320755 | 42 | 3 | 26 | 0 | 94 | 135 | 2189992 | 2189951 | MAG: uncultured Holophaga sp. isolate 19663c38-e6f5-42a8-8268-146037a524bf genome assembly, chromosome: 1 | blastn | 87 | 62.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophaga | uncultured Holophaga sp. | ||
| 22766068 | 22766068 | PRJNA436017_P_NODE_7218_length_331_cov_2.428571_g6921_i0 | PRJNA436017 | 7218 | 331 | 2.428571 | 8.03857001 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 374 | 5.859999999999998e-99 | NTclustered | gi|76574288|gb|DQ139436.1| | 171953 | g6921 | i0 | 87.195 | 81.6435045317221 | 328 | 42 | 99 | 0 | 1 | 328 | 19 | 346 | Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence | blastn | 27024 | 374 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 23383053 | 23383053 | PRJNA436017_P_NODE_24799_length_164_cov_1.196850_g24501_i0 | PRJNA436017 | 24799 | 164 | 1.19685 | 1.962834 | Bryobacterales bacterium F-183 | 2802972 | Bacteria | Bacteria | 122 | 1.03e-23 | NTclustered | gi|2131941663|dbj|AP025252.1| | 2802972 | g24501 | i0 | 97.222 | 0.439024390243902 | 72 | 2 | 44 | 0 | 91 | 162 | 4108411 | 4108482 | Bryobacterales bacterium F-183 DNA, nearly complete genome | blastn | 72 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium F-183 | ||||
| 23383196 | 23383196 | PRJNA436017_P_NODE_6039_length_365_cov_1.875000_g5743_i0 | PRJNA436017 | 6039 | 365 | 1.875 | 6.84375 | Edaphobacter flagellatus | 1933044 | Bacteria | Bacteria | 527 | 4.719999999999998e-145 | NTclustered | gi|2304905232|gb|CP073697.1| | 1933044 | g5743 | i0 | 93.539 | 319.142465753425 | 356 | 20 | 97 | 2 | 11 | 365 | 3268185 | 3268538 | Edaphobacter flagellatus strain HZ411 chromosome, complete genome | blastn | 116487 | 527 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter flagellatus | ||
| 26791102 | 26791102 | PRJNA436017_P_NODE_22101_length_174_cov_1.138686_g21803_i0 | PRJNA436017 | 22101 | 174 | 1.138686 | 1.98131364 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 59.3 | 1.06e-8 | NR | HXQ24409.1 | 2952895 | g21803 | i0 | 78 | 0.706896551724138 | 41 | 9 | 70.7 | 0 | 50 | 172 | 45 | 85 | HXQ24409.1 50S ribosomal protein L10 [Candidatus Acidiferrales bacterium] | diamond | 123 | 59.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 27075821 | 27075821 | PRJNA436017_P_NODE_23302_length_169_cov_1.181818_g23004_i0 | PRJNA436017 | 23302 | 169 | 1.181818 | 1.99727242 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 76.3 | 2.05e-14 | NR | MDJ0840096.1 | 1978231 | g23004 | i0 | 58.9 | 5.96449704142012 | 56 | 23 | 99.4 | 0 | 2 | 169 | 225 | 280 | MDJ0840096.1 M20 family metallopeptidase [Acidobacteriota bacterium] | diamond | 1008 | 76.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27518226 | 27518226 | PRJNA436017_P_NODE_28403_length_153_cov_1.344828_g28105_i0 | PRJNA436017 | 28403 | 153 | 1.344828 | 2.05758684 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.9 | 2.13e-10 | NR | HLP24116.1 | 1978231 | g28105 | i0 | 60 | 2.98039215686275 | 50 | 20 | 98 | 0 | 153 | 4 | 150 | 199 | HLP24116.1 HAD-IIB family hydrolase [Acidobacteriota bacterium] | diamond | 456 | 63.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28212581 | 28212581 | PRJNA436017_P_NODE_10686_length_263_cov_1.362832_g10388_i0 | PRJNA436017 | 10686 | 263 | 1.362832 | 3.58424816 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 119 | 5.64e-29 | NR | HEX8286473.1 | 2283092 | g10388 | i0 | 62.1 | 0.992395437262357 | 87 | 33 | 99.2 | 0 | 263 | 3 | 427 | 513 | HEX8286473.1 TonB-dependent receptor [Pyrinomonadaceae bacterium] | diamond | 261 | 119 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28939173 | 28939173 | PRJNA436017_P_NODE_3708_length_484_cov_10.228188_g3424_i0 | PRJNA436017 | 3708 | 484 | 10.228188 | 49.50442992 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 55.8 | 1.39e-6 | NR | HEY8561019.1 | 2283092 | g3424 | i0 | 63 | 0.334710743801653 | 54 | 17 | 33.5 | 2 | 235 | 396 | 76 | 126 | HEY8561019.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 162 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29145223 | 29145223 | PRJNA436017_P_NODE_23829_length_167_cov_1.461538_g23531_i0 | PRJNA436017 | 23829 | 167 | 1.461538 | 2.44076846 | Bacteria | 2 | Bacteria | Bacteria | 47 | 2.78e-4 | NR | MDQ3089409.1 | 1978231 | g23531 | i0 | 74.1 | 2.4251497005988 | 27 | 7 | 48.5 | 0 | 167 | 87 | 109 | 135 | MDQ3089409.1 energy transducer TonB [Acidobacteriota bacterium] | diamond | 405 | 47 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30123697 | 30123697 | PRJNA436017_P_NODE_27792_length_155_cov_1.288136_g27494_i0 | PRJNA436017 | 27792 | 155 | 1.288136 | 1.9966108 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 90.1 | 2.04e-19 | NR | HBL31187.1 | 1978231 | g27494 | i0 | 88.2 | 5.90322580645161 | 51 | 6 | 98.7 | 0 | 154 | 2 | 239 | 289 | HBL31187.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 915 | 90.9 | 0.991199119911991 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30282212 | 30282212 | PRJNA436017_P_NODE_29812_length_150_cov_0.973451_g29514_i0 | PRJNA436017 | 29812 | 150 | 0.973451 | 1.4601765 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 78.6 | 1.21e-16 | NR | HZN11135.1 | 2052146 | g29514 | i0 | 72 | 16.92 | 50 | 14 | 100 | 0 | 150 | 1 | 42 | 91 | HZN11135.1 tail fiber protein [Blastocatellia bacterium] | diamond | 2538 | 78.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30897490 | 30897490 | PRJNA436017_P_NODE_18274_length_192_cov_0.980645_g17976_i0 | PRJNA436017 | 18274 | 192 | 0.980645 | 1.8828384 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 52.8 | 5.38e-6 | NR | MBV9769597.1 | 2026791 | g17976 | i0 | 50.9 | 3.65625 | 57 | 28 | 89.1 | 0 | 17 | 187 | 385 | 441 | MBV9769597.1 DegQ family serine endoprotease [Bryobacterales bacterium] | diamond | 702 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 31339729 | 31339729 | PRJNA436017_P_NODE_26076_length_160_cov_0.926829_g25778_i0 | PRJNA436017 | 26076 | 160 | 0.926829 | 1.4829264 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 100 | 2.4e-26 | NR | MEO6589170.1 | 2283092 | g25778 | i0 | 98 | 0.9375 | 50 | 1 | 93.8 | 0 | 10 | 159 | 1 | 50 | MEO6589170.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 150 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32257561 | 32257561 | PRJNA436017_P_NODE_28398_length_153_cov_1.344828_g28100_i0 | PRJNA436017 | 28398 | 153 | 1.344828 | 2.05758684 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 83.2 | 5.92e-17 | NR | MCD9187273.1 | 2283092 | g28100 | i0 | 81.3 | 0.941176470588235 | 48 | 9 | 94.1 | 0 | 148 | 5 | 169 | 216 | MCD9187273.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 144 | 83.2 | 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);;