contig_metadata
22 rows where bioproject = "PRJNA495391", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 476061 | 476061 | PRJNA495391_S_NODE_22021_length_256_cov_1.592760_g20969_i0 | PRJNA495391 | 22021 | 256 | 1.59276 | 4.0774656 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 3.6e-14 | NR | MES1241810.1 | 1978231 | g20969 | i0 | 60.4 | 0.62109375 | 53 | 21 | 62.1 | 0 | 69 | 227 | 20 | 72 | MES1241810.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 159 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 4935983 | 4935983 | PRJNA495391_S_NODE_9784_length_386_cov_2.353276_g8732_i0 | PRJNA495391 | 9784 | 386 | 2.353276 | 9.08364536 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 103 | 2.13e-24 | NR | MAM83057.1 | 1978231 | g8732 | i0 | 43.4 | 2.03626943005181 | 136 | 68 | 98.7 | 2 | 3 | 383 | 31 | 166 | MAM83057.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 786 | 103 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 17053051 | 17053051 | PRJNA495391_S_NODE_12614_length_337_cov_2.360927_g11562_i0 | PRJNA495391 | 12614 | 337 | 2.360927 | 7.95632399 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 91.7 | 1.82e-21 | NR | HEV7893325.1 | 2283092 | g11562 | i0 | 67.9 | 0.997032640949555 | 56 | 18 | 49.9 | 0 | 2 | 169 | 41 | 96 | HEV7893325.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 336 | 91.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 18328659 | 18328659 | PRJNA495391_S_NODE_60775_length_160_cov_2.088000_g59723_i0 | PRJNA495391 | 60775 | 160 | 2.088 | 3.3408 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 174 | 2.71e-39 | NTclustered | gi|2621707050|emb|OY764903.1| | 2212468 | g59723 | i0 | 86.25 | 181.6375 | 160 | 22 | 100 | 0 | 1 | 160 | 3559301 | 3559142 | MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1 | blastn | 29062 | 174 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 26792245 | 26792245 | PRJNA495391_S_NODE_49041_length_176_cov_2.290780_g47989_i0 | PRJNA495391 | 49041 | 176 | 2.29078 | 4.0317728 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 67.4 | 3e-11 | NR | MAM83283.1 | 1978231 | g47989 | i0 | 54.4 | 0.971590909090909 | 57 | 26 | 97.2 | 0 | 3 | 173 | 45 | 101 | MAM83283.1 SAM-dependent methyltransferase [Acidobacteriota bacterium] | diamond | 171 | 67.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27740685 | 27740685 | PRJNA495391_S_NODE_46984_length_180_cov_1.558621_g45932_i0 | PRJNA495391 | 46984 | 180 | 1.558621 | 2.8055178 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 44.3 | 0.0034 | NR | MAM83905.1 | 1978231 | g45932 | i0 | 39.2 | 0.85 | 51 | 31 | 85 | 0 | 155 | 3 | 77 | 127 | MAM83905.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 153 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28213713 | 28213713 | PRJNA495391_S_NODE_47346_length_179_cov_2.055556_g46294_i0 | PRJNA495391 | 47346 | 179 | 2.055556 | 3.67944524 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 72 | 7.43e-13 | NR | HEV7745096.1 | 2283092 | g46294 | i0 | 51.7 | 10.6927374301676 | 58 | 28 | 97.2 | 0 | 178 | 5 | 62 | 119 | HEV7745096.1 PEP/pyruvate-binding domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 1914 | 72 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28435081 | 28435081 | PRJNA495391_S_NODE_60326_length_161_cov_1.261905_g59274_i0 | PRJNA495391 | 60326 | 161 | 1.261905 | 2.03166705 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.4 | 0.0156 | NR | MEP7306451.1 | 1978231 | g59274 | i0 | 43.8 | 0.894409937888199 | 48 | 26 | 89.4 | 1 | 17 | 160 | 176 | 222 | MEP7306451.1 ArsI/CadI family heavy metal resistance metalloenzyme [Acidobacteriota bacterium] | diamond | 144 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28860903 | 28860903 | PRJNA495391_S_NODE_71288_length_150_cov_1.260870_g70236_i0 | PRJNA495391 | 71288 | 150 | 1.26087 | 1.891305 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52 | 5.55e-6 | NR | MAM83285.1 | 1978231 | g70236 | i0 | 62.8 | 2.72 | 43 | 16 | 86 | 0 | 148 | 20 | 23 | 65 | MAM83285.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 408 | 52.4 | 0.99236641221374 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28876955 | 28876955 | PRJNA495391_S_NODE_31528_length_216_cov_2.099448_g30476_i0 | PRJNA495391 | 31528 | 216 | 2.099448 | 4.53480768 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 60.1 | 2.03e-8 | NR | MDX2030272.1 | 2052146 | g30476 | i0 | 47.9 | 1.95833333333333 | 71 | 37 | 98.6 | 0 | 216 | 4 | 429 | 499 | MDX2030272.1 MBL fold metallo-hydrolase [Blastocatellia bacterium] | diamond | 423 | 60.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29224619 | 29224619 | PRJNA495391_S_NODE_6529_length_481_cov_2.612108_g5488_i0 | PRJNA495391 | 6529 | 481 | 2.612108 | 12.56423948 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 249 | 1.95e-78 | NR | MAM83411.1 | 1978231 | g5488 | i0 | 75.5 | 0.991683991683992 | 159 | 38 | 99.2 | 1 | 5 | 481 | 64 | 221 | MAM83411.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 477 | 249 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29318989 | 29318989 | PRJNA495391_S_NODE_35369_length_205_cov_1.764706_g34317_i0 | PRJNA495391 | 35369 | 205 | 1.764706 | 3.6176473 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 43.9 | 0.00905 | NR | HWK09171.1 | 2910147 | g34317 | i0 | 39.3 | 0.819512195121951 | 56 | 34 | 82 | 0 | 187 | 20 | 33 | 88 | HWK09171.1 CRTAC1 family protein [Vicinamibacterales bacterium] | diamond | 168 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30139796 | 30139796 | PRJNA495391_S_NODE_55532_length_167_cov_1.212121_g54480_i0 | PRJNA495391 | 55532 | 167 | 1.212121 | 2.02424207 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 110 | 5.06e-27 | NR | HSK76109.1 | 2651171 | g54480 | i0 | 96.4 | 0.988023952095808 | 55 | 2 | 98.8 | 0 | 1 | 165 | 7 | 61 | HSK76109.1 endolytic transglycosylase MltG [Thermoanaerobaculia bacterium] | diamond | 165 | 110 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30139806 | 30139806 | PRJNA495391_S_NODE_8492_length_415_cov_3.010526_g7441_i0 | PRJNA495391 | 8492 | 415 | 3.010526 | 12.4936829 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 114 | 7.83e-27 | NR | MAM83411.1 | 1978231 | g7441 | i0 | 83.3 | 0.47710843373494 | 66 | 11 | 47.7 | 0 | 199 | 2 | 1 | 66 | MAM83411.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 198 | 114 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30234911 | 30234911 | PRJNA495391_S_NODE_14712_length_312_cov_2.054152_g13660_i0 | PRJNA495391 | 14712 | 312 | 2.054152 | 6.40895424 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 125 | 1.85e-31 | NR | MAM83859.1 | 1978231 | g13660 | i0 | 62.4 | 0.894230769230769 | 93 | 35 | 89.4 | 0 | 280 | 2 | 95 | 187 | MAM83859.1 tyrosine--tRNA ligase [Acidobacteriota bacterium] | diamond | 279 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30456466 | 30456466 | PRJNA495391_S_NODE_24953_length_241_cov_2.058252_g23901_i0 | PRJNA495391 | 24953 | 241 | 2.058252 | 4.96038732 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.5 | 0.017 | NR | MBW4033005.1 | 1978231 | g23901 | i0 | 48.1 | 0.647302904564315 | 52 | 25 | 64.7 | 1 | 225 | 70 | 71 | 120 | MBW4033005.1 helix-turn-helix domain-containing protein [Acidobacteriota bacterium] | diamond | 156 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30772216 | 30772216 | PRJNA495391_S_NODE_14174_length_318_cov_1.632509_g13122_i0 | PRJNA495391 | 14174 | 318 | 1.632509 | 5.19137862 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 47.4 | 2.31e-4 | NR | HKE24990.1 | 2212468 | g13122 | i0 | 35.1 | 1.43396226415094 | 77 | 47 | 72.6 | 2 | 234 | 4 | 1 | 74 | HKE24990.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 456 | 47.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31246009 | 31246009 | PRJNA495391_S_NODE_51055_length_173_cov_1.855072_g50003_i0 | PRJNA495391 | 51055 | 173 | 1.855072 | 3.20927456 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 94.4 | 5.1800000000000006e-21 | NR | HZD45349.1 | 2052142 | g50003 | i0 | 80.8 | 4.47398843930636 | 52 | 10 | 90.2 | 0 | 16 | 171 | 72 | 123 | HZD45349.1 transaldolase [Acidobacteriaceae bacterium] | diamond | 774 | 94.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 31846915 | 31846915 | PRJNA495391_S_NODE_50237_length_174_cov_2.568345_g49185_i0 | PRJNA495391 | 50237 | 174 | 2.568345 | 4.4689203 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 102 | 8.32e-24 | NR | HEY1254467.1 | 1964191 | g49185 | i0 | 84.2 | 1.96551724137931 | 57 | 9 | 98.3 | 0 | 3 | 173 | 46 | 102 | HEY1254467.1 oleate hydratase [Terracidiphilus sp.] | diamond | 342 | 102 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 32290361 | 32290361 | PRJNA495391_S_NODE_39099_length_196_cov_1.347826_g38047_i0 | PRJNA495391 | 39099 | 196 | 1.347826 | 2.64173896 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 51.6 | 5.17e-6 | NR | MAM83288.1 | 1978231 | g38047 | i0 | 60.5 | 0.581632653061224 | 38 | 15 | 58.2 | 0 | 75 | 188 | 1 | 38 | MAM83288.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 114 | 51.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32511763 | 32511763 | PRJNA495391_S_NODE_34919_length_206_cov_2.216374_g33867_i0 | PRJNA495391 | 34919 | 206 | 2.216374 | 4.56573044 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 59.3 | 1.61e-8 | NR | MBV9959358.1 | 1978231 | g33867 | i0 | 43.8 | 0.932038834951456 | 64 | 36 | 93.2 | 0 | 198 | 7 | 158 | 221 | MBV9959358.1 dTMP kinase [Acidobacteriota bacterium] | diamond | 192 | 59.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32858061 | 32858061 | PRJNA495391_S_NODE_45920_length_182_cov_1.408163_g44868_i0 | PRJNA495391 | 45920 | 182 | 1.408163 | 2.56285666 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 68.2 | 1.72e-11 | NR | MAM83412.1 | 1978231 | g44868 | i0 | 63.5 | 0.857142857142857 | 52 | 19 | 85.7 | 0 | 5 | 160 | 12 | 63 | MAM83412.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 156 | 68.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;