contig_metadata
23 rows where bioproject = "PRJNA688352", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 666906 | 666906 | PRJNA688352_P_NODE_7881_length_250_cov_0.870056_g7778_i0 | PRJNA688352 | 7881 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 169 | 2.15e-37 | NTclustered | gi|2108374973|gb|CP070648.1| | 2033014 | g7778 | i0 | 79.352 | 2.992 | 247 | 45 | 98 | 6 | 7 | 250 | 3246759 | 3246516 | MAG: Armatimonadetes bacterium isolate bin88 chromosome | blastn | 748 | 169 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 3217731 | 3217731 | PRJNA688352_P_NODE_10603_length_244_cov_0.900585_g10500_i0 | PRJNA688352 | 10603 | 244 | 0.900585 | 2.1974274 | uncultured Armatimonadetes bacterium | 157466 | Bacteria | Bacteria | 158 | 4.53e-34 | NTclustered | gi|2874253689|emb|OY969415.1| | 157466 | g10500 | i0 | 85.256 | 17.6475409836066 | 156 | 20 | 63 | 3 | 1 | 154 | 1201114 | 1201268 | MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 | blastn | 4306 | 158 | 1 | Bacteria | Bacillati | Armatimonadota | uncultured Armatimonadetes bacterium | ||||||
| 8829641 | 8829641 | PRJNA688352_P_NODE_10247_length_245_cov_0.895349_g10144_i0 | PRJNA688352 | 10247 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 151 | 5.82e-43 | NR | MBM3497850.1 | 2033014 | g10144 | i0 | 86.4 | 1.98367346938776 | 81 | 11 | 99.2 | 0 | 2 | 244 | 48 | 128 | MBM3497850.1 malate dehydrogenase [Armatimonadota bacterium] | diamond | 486 | 151 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 17244859 | 17244859 | PRJNA688352_P_NODE_7634_length_250_cov_0.870056_g7531_i0 | PRJNA688352 | 7634 | 250 | 0.870056 | 2.17514 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 192 | 2.44e-59 | NR | MCC7230684.1 | 2682144 | g7531 | i0 | 98.8 | 1.968 | 82 | 1 | 98.4 | 0 | 3 | 248 | 194 | 275 | MCC7230684.1 cysteine--tRNA ligase [Fimbriimonadaceae bacterium] | diamond | 492 | 192 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 17244893 | 17244893 | PRJNA688352_P_NODE_9774_length_246_cov_0.890173_g9671_i0 | PRJNA688352 | 9774 | 246 | 0.890173 | 2.18982558 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 157 | 1.8e-42 | NR | NMC83160.1 | 2033014 | g9671 | i0 | 98.8 | 0.98780487804878 | 81 | 1 | 98.8 | 0 | 4 | 246 | 567 | 647 | NMC83160.1 polyribonucleotide nucleotidyltransferase [Armatimonadota bacterium] | diamond | 243 | 157 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26639037 | 26639037 | PRJNA688352_P_NODE_7861_length_250_cov_0.870056_g7758_i0 | PRJNA688352 | 7861 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 139 | 7.7e-40 | NR | NMC81833.1 | 2033014 | g7758 | i0 | 91.1 | 0.948 | 79 | 7 | 94.8 | 0 | 249 | 13 | 84 | 162 | NMC81833.1 pantetheine-phosphate adenylyltransferase [Armatimonadota bacterium] | diamond | 237 | 139 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26861073 | 26861073 | PRJNA688352_P_NODE_3941_length_319_cov_1.000000_g3838_i0 | PRJNA688352 | 3941 | 319 | 1 | 3.19 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 156 | 4.05e-43 | NR | HEY3411720.1 | 2033014 | g3838 | i0 | 76.5 | 0.921630094043887 | 98 | 23 | 92.2 | 0 | 26 | 319 | 55 | 152 | HEY3411720.1 group II intron reverse transcriptase/maturase [Armatimonadota bacterium] | diamond | 294 | 156 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26987200 | 26987200 | PRJNA688352_P_NODE_7042_length_251_cov_0.865169_g6939_i0 | PRJNA688352 | 7042 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 94 | 1.93e-20 | NR | NLC56404.1 | 2033014 | g6939 | i0 | 48.2 | 0.99203187250996006 | 83 | 43 | 99.2 | 0 | 249 | 1 | 68 | 150 | NLC56404.1 hypothetical protein [Armatimonadota bacterium] | diamond | 249 | 94 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27271866 | 27271866 | PRJNA688352_P_NODE_10023_length_245_cov_0.895349_g9920_i0 | PRJNA688352 | 10023 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 70.9 | 3.05e-12 | NR | NSW57005.1 | 2033014 | g9920 | i0 | 50 | 0.906122448979592 | 74 | 36 | 89.4 | 1 | 24 | 242 | 130 | 203 | NSW57005.1 fibronectin type III domain-containing protein [Armatimonadota bacterium] | diamond | 222 | 70.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27398425 | 27398425 | PRJNA688352_P_NODE_8103_length_249_cov_0.875000_g8000_i0 | PRJNA688352 | 8103 | 249 | 0.875 | 2.17875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 141 | 5.54e-40 | NR | HUU55613.1 | 2033014 | g8000 | i0 | 85.4 | 1.96385542168675 | 82 | 12 | 98.8 | 0 | 247 | 2 | 25 | 106 | HUU55613.1 sodium/proton-translocating pyrophosphatase [Armatimonadota bacterium] | diamond | 489 | 141 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28061273 | 28061273 | PRJNA688352_P_NODE_7765_length_250_cov_0.870056_g7662_i0 | PRJNA688352 | 7765 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 160 | 2.2399999999999992e-43 | NR | NMC83078.1 | 2033014 | g7662 | i0 | 92.7 | 1.968 | 82 | 6 | 98.4 | 0 | 5 | 250 | 692 | 773 | NMC83078.1 carbohydrate-binding protein [Armatimonadota bacterium] | diamond | 492 | 160 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28092911 | 28092911 | PRJNA688352_P_NODE_7785_length_250_cov_0.870056_g7682_i0 | PRJNA688352 | 7785 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 48.9 | 1.61e-4 | NR | MCJ7751431.1 | 2033014 | g7682 | i0 | 46.1 | 1.068 | 89 | 41 | 98.4 | 3 | 246 | 1 | 56 | 144 | MCJ7751431.1 hypothetical protein [Armatimonadota bacterium] | diamond | 267 | 48.9 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28314016 | 28314016 | PRJNA688352_P_NODE_10726_length_244_cov_0.900585_g10623_i0 | PRJNA688352 | 10726 | 244 | 0.900585 | 2.1974274 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 162 | 1.35e-45 | NR | NMC82559.1 | 2033014 | g10623 | i0 | 92.6 | 0.995901639344262 | 81 | 6 | 99.6 | 0 | 243 | 1 | 183 | 263 | NMC82559.1 proteasome accessory factor PafA2 family protein [Armatimonadota bacterium] | diamond | 243 | 162 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28377004 | 28377004 | PRJNA688352_P_NODE_9326_length_247_cov_0.885057_g9223_i0 | PRJNA688352 | 9326 | 247 | 0.885057 | 2.18609079 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 83.2 | 3.43e-17 | NR | MCC2670774.1 | 2033014 | g9223 | i0 | 85.7 | 2.67206477732794 | 42 | 6 | 51 | 0 | 121 | 246 | 4 | 45 | MCC2670774.1 1-(5-phosphoribosyl)-5-((5-phosphoribosylamino) methylideneamino) imidazole-4-carboxamide isomerase [Armatimonadota bacterium] | diamond | 660 | 83.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28566498 | 28566498 | PRJNA688352_P_NODE_10747_length_244_cov_0.900585_g10644_i0 | PRJNA688352 | 10747 | 244 | 0.900585 | 2.1974274 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 83.2 | 2.13e-16 | NR | MDH7602907.1 | 2033014 | g10644 | i0 | 55.6 | 1.93032786885246 | 81 | 36 | 99.6 | 0 | 2 | 244 | 195 | 275 | MDH7602907.1 fused MFS/spermidine synthase [Armatimonadota bacterium] | diamond | 471 | 83.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29071904 | 29071904 | PRJNA688352_P_NODE_7888_length_250_cov_0.870056_g7785_i0 | PRJNA688352 | 7888 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 154 | 3.169999999999999e-42 | NR | MBM3474188.1 | 2033014 | g7785 | i0 | 91.6 | 1.992 | 83 | 7 | 99.6 | 0 | 1 | 249 | 221 | 303 | MBM3474188.1 hypothetical protein [Armatimonadota bacterium] | diamond | 498 | 154 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30272093 | 30272093 | PRJNA688352_P_NODE_7032_length_251_cov_0.865169_g6929_i0 | PRJNA688352 | 7032 | 251 | 0.865169 | 2.17157419 | Armatimonadetes bacterium RBG_16_58_9 | 1797287 | Bacteria | Bacteria | 117 | 2.02e-28 | NR | OFX14576.1 | 1797287 | g6929 | i0 | 72.3 | 3.9681274900398402 | 83 | 23 | 99.2 | 0 | 249 | 1 | 254 | 336 | OFX14576.1 MAG: hypothetical protein A2Z18_11300 [Armatimonadetes bacterium RBG_16_58_9] | diamond | 996 | 117 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadetes bacterium RBG_16_58_9 | ||||||
| 30367014 | 30367014 | PRJNA688352_P_NODE_7092_length_251_cov_0.865169_g6989_i0 | PRJNA688352 | 7092 | 251 | 0.865169 | 2.17157419 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 68.2 | 4.5e-11 | NR | MEA3400281.1 | 2033014 | g6989 | i0 | 49.4 | 1.9601593625498 | 83 | 39 | 99.2 | 1 | 1 | 249 | 71 | 150 | MEA3400281.1 hypothetical protein [Armatimonadota bacterium] | diamond | 492 | 68.2 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30650714 | 30650714 | PRJNA688352_P_NODE_9413_length_247_cov_0.885057_g9310_i0 | PRJNA688352 | 9413 | 247 | 0.885057 | 2.18609079 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 176 | 2.1400000000000002e-49 | NR | NPV47656.1 | 2033014 | g9310 | i0 | 92.6 | 0.983805668016194 | 81 | 6 | 98.4 | 0 | 2 | 244 | 637 | 717 | NPV47656.1 DUF4091 domain-containing protein [Armatimonadota bacterium] | diamond | 243 | 176 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30745754 | 30745754 | PRJNA688352_P_NODE_9114_length_247_cov_0.885057_g9011_i0 | PRJNA688352 | 9114 | 247 | 0.885057 | 2.18609079 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 152 | 2.769999999999999e-41 | NR | HJN16311.1 | 2033014 | g9011 | i0 | 86.4 | 0.983805668016194 | 81 | 11 | 98.4 | 0 | 2 | 244 | 406 | 486 | HJN16311.1 arylsulfatase [Armatimonadota bacterium] | diamond | 243 | 152 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31030358 | 31030358 | PRJNA688352_P_NODE_12375_length_241_cov_0.916667_g12272_i0 | PRJNA688352 | 12375 | 241 | 0.916667 | 2.20916747 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 44.7 | 0.00749 | NR | MES2465205.1 | 2033014 | g12272 | i0 | 34.3 | 0.871369294605809 | 70 | 40 | 79.7 | 2 | 228 | 37 | 92 | 161 | MES2465205.1 hypothetical protein [Armatimonadota bacterium] | diamond | 210 | 44.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32232222 | 32232222 | PRJNA688352_P_NODE_10098_length_245_cov_0.895349_g9995_i0 | PRJNA688352 | 10098 | 245 | 0.895349 | 2.19360505 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 85.1 | 4.68e-17 | NR | MDI6828276.1 | 2033014 | g9995 | i0 | 67.3 | 0.673469387755102 | 55 | 18 | 67.3 | 0 | 168 | 4 | 410 | 464 | MDI6828276.1 DUF499 domain-containing protein [Armatimonadota bacterium] | diamond | 165 | 85.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32358813 | 32358813 | PRJNA688352_P_NODE_7619_length_250_cov_0.870056_g7516_i0 | PRJNA688352 | 7619 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 158 | 1.1399999999999999e-48 | NR | NMC81528.1 | 2033014 | g7516 | i0 | 98.7 | 0.948 | 79 | 1 | 94.8 | 0 | 237 | 1 | 1 | 79 | NMC81528.1 30S ribosomal protein S18 [Armatimonadota bacterium] | diamond | 237 | 158 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota 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);;