contig_metadata
25 rows where bioproject = "PRJNA758088", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12683368 | 12683368 | PRJNA758088_P_NODE_298630_length_249_cov_0.875000_g291659_i0 | PRJNA758088 | 298630 | 249 | 0.875 | 2.17875 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 298 | 2.62e-76 | NTclustered | gi|663071213|gb|CP007139.1| | 661478 | g291659 | i0 | 88.4 | 119.78313253012 | 250 | 25 | 100 | 3 | 1 | 249 | 28366 | 28612 | Fimbriimonas ginsengisoli Gsoil 348, complete genome | blastn | 29826 | 298 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 26799752 | 26799752 | PRJNA758088_P_NODE_286561_length_250_cov_3.248588_g279590_i0 | PRJNA758088 | 286561 | 250 | 3.248588 | 8.12147 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 84.7 | 6.9e-17 | NR | MFM7188328.1 | 2033014 | g279590 | i0 | 47.6 | 1.896 | 82 | 43 | 98.4 | 0 | 247 | 2 | 399 | 480 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 474 | 84.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 26926430 | 26926430 | PRJNA758088_P_NODE_266602_length_259_cov_1.059140_g259631_i0 | PRJNA758088 | 266602 | 259 | 1.05914 | 2.7431726 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 53.1 | 9.99e-6 | NR | MFM7188328.1 | 2033014 | g259631 | i0 | 29.5 | 1.01930501930502 | 88 | 57 | 96.1 | 3 | 249 | 1 | 333 | 420 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 264 | 53.1 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27210835 | 27210835 | PRJNA758088_P_NODE_5582_length_2120_cov_1.657059_g4109_i0 | PRJNA758088 | 5582 | 2120 | 1.657059 | 35.1296508 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 337 | 6.769999999999998e-101 | NR | MEI7987340.1 | 2033014 | g4109 | i0 | 40.2 | 0.69622641509434 | 492 | 263 | 67.8 | 11 | 1492 | 56 | 6 | 479 | MEI7987340.1 hypothetical protein [Armatimonadota bacterium] | diamond | 1476 | 337 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27558318 | 27558318 | PRJNA758088_P_NODE_327424_length_245_cov_1.750000_g320453_i0 | PRJNA758088 | 327424 | 245 | 1.75 | 4.2875 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 110 | 7.67e-26 | NR | MEI7987137.1 | 2033014 | g320453 | i0 | 59.3 | 0.991836734693878 | 81 | 33 | 99.2 | 0 | 244 | 2 | 796 | 876 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 243 | 110 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 27685121 | 27685121 | PRJNA758088_P_NODE_249944_length_269_cov_1.010204_g242973_i0 | PRJNA758088 | 249944 | 269 | 1.010204 | 2.71744876 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 121 | 9.289999999999999e-30 | NR | MEI7987340.1 | 2033014 | g242973 | i0 | 66.7 | 1.03717472118959 | 93 | 27 | 99.3 | 1 | 3 | 269 | 689 | 781 | MEI7987340.1 hypothetical protein [Armatimonadota bacterium] | diamond | 279 | 121 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28347852 | 28347852 | PRJNA758088_P_NODE_33266_length_819_cov_2.532172_g27340_i0 | PRJNA758088 | 33266 | 819 | 2.532172 | 20.73848868 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 291 | 1.5199999999999998e-88 | NR | MFM7188328.1 | 2033014 | g27340 | i0 | 52.2 | 2.03663003663004 | 278 | 127 | 99.6 | 2 | 2 | 817 | 138 | 415 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 1668 | 291 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28852841 | 28852841 | PRJNA758088_P_NODE_290468_length_250_cov_0.870056_g283497_i0 | PRJNA758088 | 290468 | 250 | 0.870056 | 2.17514 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 89.7 | 1.2e-18 | NR | MEI7987340.1 | 2033014 | g283497 | i0 | 72.7 | 0.66 | 55 | 15 | 66 | 0 | 250 | 86 | 735 | 789 | MEI7987340.1 hypothetical protein [Armatimonadota bacterium] | diamond | 165 | 89.7 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 28915937 | 28915937 | PRJNA758088_P_NODE_25528_length_969_cov_1.705357_g20371_i0 | PRJNA758088 | 25528 | 969 | 1.705357 | 16.52490933 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 409 | 3.82e-133 | NR | MFM7188328.1 | 2033014 | g20371 | i0 | 60.6 | 2.97832817337461 | 322 | 127 | 99.7 | 0 | 2 | 967 | 7 | 328 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 2886 | 409 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29673659 | 29673659 | PRJNA758088_P_NODE_103250_length_413_cov_0.876471_g96280_i0 | PRJNA758088 | 103250 | 413 | 0.876471 | 3.61982523 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 77.4 | 1.88e-13 | NR | MFM7188328.1 | 2033014 | g96280 | i0 | 65.6 | 1.5544794188862 | 61 | 19 | 44.3 | 1 | 190 | 8 | 464 | 522 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 642 | 77.4 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30464149 | 30464149 | PRJNA758088_P_NODE_313033_length_247_cov_0.885057_g306062_i0 | PRJNA758088 | 313033 | 247 | 0.885057 | 2.18609079 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 46.6 | 0.00177 | NR | MEI7987137.1 | 2033014 | g306062 | i0 | 43.1 | 0.619433198380567 | 51 | 27 | 59.5 | 1 | 5 | 151 | 944 | 994 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 153 | 46.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30464166 | 30464166 | PRJNA758088_P_NODE_89853_length_444_cov_3.334232_g82883_i0 | PRJNA758088 | 89853 | 444 | 3.334232 | 14.80399008 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 188 | 3.36e-52 | NR | MEI7987137.1 | 2033014 | g82883 | i0 | 53.7 | 1.97972972972973 | 147 | 68 | 99.3 | 0 | 442 | 2 | 690 | 836 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 879 | 188 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30748135 | 30748135 | PRJNA758088_P_NODE_273754_length_254_cov_1.729282_g266783_i0 | PRJNA758088 | 273754 | 254 | 1.729282 | 4.39237628 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 81.3 | 1.19e-15 | NR | MFM7188328.1 | 2033014 | g266783 | i0 | 50 | 0.992125984251969 | 84 | 37 | 98 | 2 | 253 | 5 | 597 | 676 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 252 | 81.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30811239 | 30811239 | PRJNA758088_P_NODE_103474_length_412_cov_1.640118_g96504_i0 | PRJNA758088 | 103474 | 412 | 1.640118 | 6.75728616 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 125 | 3.7699999999999995e-30 | NR | MFM7188328.1 | 2033014 | g96504 | i0 | 44.1 | 1.04126213592233 | 143 | 74 | 99.8 | 3 | 412 | 2 | 304 | 446 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 429 | 125 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30874467 | 30874467 | PRJNA758088_P_NODE_74634_length_494_cov_0.995249_g67671_i0 | PRJNA758088 | 74634 | 494 | 0.995249 | 4.91653006 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 149 | 4.799999999999999e-38 | NR | MEI7987137.1 | 2033014 | g67671 | i0 | 45.8 | 1.02024291497976 | 168 | 83 | 99.6 | 2 | 493 | 2 | 789 | 952 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 504 | 149 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30969440 | 30969440 | PRJNA758088_P_NODE_43994_length_684_cov_1.093290_g37446_i0 | PRJNA758088 | 43994 | 684 | 1.09329 | 7.4781036 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 72.8 | 9.79e-11 | NR | MEI7987137.1 | 2033014 | g37446 | i0 | 36.5 | 0.552631578947368 | 126 | 72 | 53.5 | 2 | 2 | 367 | 874 | 995 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 378 | 72.8 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 30969445 | 30969445 | PRJNA758088_P_NODE_95194_length_431_cov_1.122905_g88224_i0 | PRJNA758088 | 95194 | 431 | 1.122905 | 4.83972055 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 93.6 | 5.16e-19 | NR | MFM7188328.1 | 2033014 | g88224 | i0 | 35.8 | 2.04640371229698 | 151 | 80 | 99.5 | 5 | 2 | 430 | 332 | 473 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 882 | 93.6 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31064275 | 31064275 | PRJNA758088_P_NODE_29415_length_886_cov_1.185732_g23831_i0 | PRJNA758088 | 29415 | 886 | 1.185732 | 10.50558552 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 298 | 4.6099999999999996e-89 | NR | MEI7987137.1 | 2033014 | g23831 | i0 | 49.1 | 0.95823927765237 | 283 | 140 | 94.5 | 1 | 3 | 839 | 656 | 938 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 849 | 298 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31231655 | 31231655 | PRJNA758088_P_NODE_364875_length_241_cov_0.916667_g357904_i0 | PRJNA758088 | 364875 | 241 | 0.916667 | 2.20916747 | Fimbriimonas | 1005038 | Bacteria | Bacteria | 123 | 8.08e-34 | NR | WP_084178898.1 | 1005039 | g357904 | i0 | 77.2 | 5.75103734439834 | 79 | 18 | 98.3 | 0 | 238 | 2 | 14 | 92 | WP_084178898.1 Fur family transcriptional regulator [Fimbriimonas ginsengisoli] | diamond | 1386 | 124 | 0.991935483870968 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 31475191 | 31475191 | PRJNA758088_P_NODE_29156_length_891_cov_1.964548_g23606_i0 | PRJNA758088 | 29156 | 891 | 1.964548 | 17.50412268 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 268 | 4.6e-80 | NR | MEI7987340.1 | 2033014 | g23606 | i0 | 54 | 0.915824915824916 | 272 | 114 | 88.6 | 6 | 841 | 53 | 520 | 789 | MEI7987340.1 hypothetical protein [Armatimonadota bacterium] | diamond | 816 | 268 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31981065 | 31981065 | PRJNA758088_P_NODE_50898_length_623_cov_1.083636_g44167_i0 | PRJNA758088 | 50898 | 623 | 1.083636 | 6.75105228 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 157 | 2.11e-40 | NR | MFM7188328.1 | 2033014 | g44167 | i0 | 41 | 2.0561797752809 | 212 | 116 | 99.7 | 4 | 621 | 1 | 319 | 526 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 1281 | 157 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32139432 | 32139432 | PRJNA758088_P_NODE_149038_length_345_cov_1.209559_g142067_i0 | PRJNA758088 | 149038 | 345 | 1.209559 | 4.17297855 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 176 | 8.98e-49 | NR | MFM7188328.1 | 2033014 | g142067 | i0 | 68.4 | 0.991304347826087 | 114 | 36 | 99.1 | 0 | 2 | 343 | 397 | 510 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 342 | 176 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32519338 | 32519338 | PRJNA758088_P_NODE_193619_length_306_cov_0.841202_g186648_i0 | PRJNA758088 | 193619 | 306 | 0.841202 | 2.57407812 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 101 | 2.2700000000000003e-22 | NR | MFM7188328.1 | 2033014 | g186648 | i0 | 47.6 | 1.00980392156863 | 103 | 53 | 100 | 1 | 306 | 1 | 380 | 482 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 309 | 101 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32896958 | 32896958 | PRJNA758088_P_NODE_152800_length_341_cov_1.182836_g145829_i0 | PRJNA758088 | 152800 | 341 | 1.182836 | 4.03347076 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 108 | 9.65e-25 | NR | MEI7987137.1 | 2033014 | g145829 | i0 | 64.6 | 2.08504398826979 | 79 | 28 | 69.5 | 0 | 340 | 104 | 316 | 394 | MEI7987137.1 reverse transcriptase domain-containing protein [Armatimonadota bacterium] | diamond | 711 | 108 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 32896965 | 32896965 | PRJNA758088_P_NODE_248700_length_269_cov_1.877551_g241729_i0 | PRJNA758088 | 248700 | 269 | 1.877551 | 5.05061219 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 107 | 9.32e-25 | NR | MFM7188328.1 | 2033014 | g241729 | i0 | 56.2 | 0.992565055762082 | 89 | 39 | 99.3 | 0 | 267 | 1 | 427 | 515 | MFM7188328.1 RNase H-like domain-containing protein [Armatimonadota bacterium] | diamond | 267 | 107 | 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);;